mysql errors after 4.0.16 -> 3.23.49 downgrade

[kontrabass]

I'm getting the following errors, after backing down to mysql 3.23.49 after a few days running 4.0.16. Only other change I made was install/uninstall Turck MMcache. The errors only occur when I'm working wtih the 'user' table in the admin CP... BTW I know my VB is out of date :) (upgrade planned). Any ideas? Thanks!

These errors occur when trying to change the user's group, or edit their profile in any way via the admin CP

Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,receivebulletin,receivebulletin_ type,showemail,invisible,usertitle,customtitle,joi ndate,cookieuser,daysprune,lastvisit,lastactivity, lastpost,posts,timezoneoffset,emailnotification,re ceivepm,emailonpm,ipaddress,pmpopup,options,birthd ay) VALUES (NULL,'2','test9999','ec0e2603172c73a8b644bb9456c1 ff6e','joe@lkasdf.com','1','','0','http://www.','','','','','1','1','1','0','','0',106728328 0,'1','-1',1067283280,1067283280,1067283280,'0','0','1','1 ','0','','0','15','birthday')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Monday 27th of October 2003 12:34:40 PM
Script: http://www.talkbass.com/forum/forum/admin/user.php
Referer: http://www.talkbass.com/forum/admin/user.php?action=add&


Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT userid
FROM user
WHERE username='cb56'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Date: Monday 27th of October 2003 12:48:30 PM
Script: http://www.talkbass.com/forum/forum/admin/user.php
Referer: http://www.talkbass.com/forum/admin/user.php?action=edit&userid=6021

[kontrabass]

Sorry forgot to mention that I also upgraded php from 4.1.2 to 4.3.3 before this error started occuring. Maybe something is up with php 4.3.3 and VB 2.2?

[kontrabass]

Odd... All of the links in the user modification interface in the CP are missing the userid - ie, the links look like this:

http://www.talkbass.com/forum/search.php?s=&action=finduser&userid=
http://www.talkbass.com/forum/private.php?s=&action=newmessage&userid=
http://www.talkbass.com/forum/admin/user.php?s=&action=editaccess&userid=

Except for the 'view profile for membername' link which does have the #:

http://www.talkbass.com/forum/member.php?s=&action=getinfo&userid=17747

Hmm... looks like this is because the code in user.php for the above link is
"&userid=$userid"

vs

"&userid=$user[userid]" for the previous. So for some reason $user[userid] is returning nothing?

Needless to say all the links missing the userid don't work (they all default ot userid 0).

I'm no expert - TIA for any help or ideas :(

[Steve Machol]

Yes, there are known incompatibilities between PHP 4.3.x and the older version of vB you are running. The first thing you need to do is upgrade to vB 2.3.2. Please see the instructions here:

http://www.vbulletin.com/members/upgrade.html

[kontrabass]

Yes, there are known incompatibilities between PHP 4.3.x and the older version of vB you are running. The first thing you need to do is upgrade to vB 2.3.2. Please see the instructions here:

http://www.vbulletin.com/members/upgrade.html

Thanks for the info. I have sooo many hacks installed I was hoping VB3.0 would be my next upgrade. Oh well :) Time to get to work!