LoL! OMG!!! Here We Go!!!

**Vin DSL** · 04-05-2004, 11:05 PM

Neutron: MySQL 4.0.18-standard

Are you game? I am...

**Vin DSL** · 04-06-2004, 02:13 AM

Hello?!?!? Is the microphone on? Can everybody hear me in the back?

Am I the only one that got upgraded to MySQL 4 yesterday? Ppl have been waiting for this day to arrive for months. WTF? No tickertape parade? I don't get it!

Maybe this is a joke...

**Sara** · 04-06-2004, 03:25 AM

Just not all of us who is as hyper as you

Or upgraded yet.

**Smo** · 04-06-2004, 04:22 AM

zinc isn't upgraded, sooo unfair.. not that I know what's new in mysql 4

**Vin DSL** · 04-06-2004, 04:26 AM

Heh! I'm like a racehorse in the starting gate. This is going to be fun!

My PHP-Nuke site doesn't like MySQL 4 so far. Luckily, I can still run it in MySQL 3 mode.

I noticed it was getting errors all over the place. I tracked this down to a bug in PHP-Nuke itself.

To get MySQL 4 to work with PHP-Nuke, the variable '$dbtype' in 'config.php' needs to be set to 'mysql4'. However, the 'sql_layer.php' file only has provisions for 'MySQL', and not 'mysql4' (case sensitive, not bad spelling). So, I hacked the file and added:

PHP Code:


 if ($dbtype == "mysql4") { $dbtype="MySQL"; }

That took care of the sql layer problems, but then I noticed my MS-Analysis program wasn't displaying any data. Still haven't figured that one out yet, so I switched back to MySQL 3 mode again.

Another problem is going to be sql injection vulnerabilites with the 'UNION' operator in MySQL 4. A sharp script kiddy can pull all the passwords off your site in a heartbeat if you aren't protected against it.

phpMyAdmin was having problems too. Instead of displaying things in frames, when you clicked on something, it was opening a new window.

Hahahaha! I pity Tech Support...

**G.Bloke** · 04-06-2004, 06:05 AM

Most looking forward to the multiple table delete feature in MySQL. I've been running version 4 on my development server for some time now and so I know my scripts are compatible, just the hassle of rewriting section to take advantage of the new features.

**tank** · 04-06-2004, 06:39 AM

chimera is at 4.0.18

**Zhen-Xjell** · 04-06-2004, 07:49 AM

Yah Vin that is a problem with mysql 4 and I'm not on it yet. I know its performance is supposed to be better, but...

**mattsiegman** · 04-06-2004, 03:29 PM

backwards compatibility is always a good thing to have...

**Vin DSL** · 04-06-2004, 03:45 PM

Originally posted by Zhen-Xjell
Yah Vin that is a problem with mysql 4 and I'm not on it yet. I know its performance is supposed to be better, but...

I was looking through the CVS files on NC, last night, and I noticed this lack of support for 'mysql4' has never been addressed in 'sql_layer.php'. Maybe it's time we hop on that, Bugs...

**Vin DSL** · 04-06-2004, 03:54 PM

Originally posted by mattsiegman
backwards compatibility is always a good thing to have...

My first impression is that the permissions have NOT been set correctly for the sql users.

When I looked in cPanel, I noticed that one of my db user names has full permissions, but all the others are subject to limitation. I think that's what's happening with my stat program. I suspect it doesn't have permission to query the db and pull the numbers needed.

The user name that has full permissions is the one cPanel uses in the auto-installer for PHP-Nuke, so maybe I need to contact Tech Support and have them manipulate the permissions for the other users.

Hrm...

**tank** · 04-07-2004, 09:55 AM

Hey Vin,

How did you run your Nuke site in MySQL 3 mode?

I recently signed up with Jaguar and am porting over my nuke site. Everything works OK except the entire PHPBB port. Anything to do with PHPBB does not work correctly (memberlist, forums, private messages)

I tried your fix above but it didn't help. My database copied over OK as well as all teh changes needed. I haven't changed the DNS pointer yet so I'm still using the IP to test everything.

What is weird is that everything else on the site works except the PHPBB stuff which doesn't display at all (no error message or anything) The memberlist at least shows up but is not correct.

Any ideas?

**Vin DSL** · 04-07-2004, 01:40 PM

Originally posted by tank
How did you run your Nuke site in MySQL 3 mode?...

I recently signed up with Jaguar and am porting over my nuke site. Everything works OK except the entire PHPBB port. Anything to do with PHPBB does not work correctly (memberlist, forums, private messages)...

Any ideas?

The db type ('$dbtype') is specified in 'config.php'. To run in MySQL 3 mode, use 'MySQL' (CaSe SeNSiTiVe). MySQL 4 would be 'mysql4', but PHP-Nuke is whack under MySQL 4, so I wouldn't suggest it.

As far as the phpBB goes, I suspect it might be a cookie issue. You might try clearing your cookies and the cache in your browser.

If that doesn't work, it might be the cookie settings in phpBB. I use:

Cookie domain: <leave blank>
Cookie name: phpbb2mysql
Cookie path: /
Cookie secure: <disabled>
Session length [ seconds ]: 0

Gotta run. BBL...