PDA

View Full Version : MySQL error



777connect
Fri 27th Apr '07, 3:56am
I am trying to upgrade for 3.64 to 3.6.5 and I get the following error. What could be the problem?
Database error in vBulletin 3.6.4:

Invalid SQL:

UPDATE vb_user SET
infractiongroupids = '',
infractiongroupid = 0
WHERE ipoints = 0
AND (infractiongroupids <> '' OR infractiongroupid <> 0);

MySQL Error : Unknown column 'infractiongroupid' in 'where clause'
Error Number : 1054
Date : Friday, April 27th 2007 @ 01:49:12 AM
Script : http://mywebsite.com/forum/install/upgrade_365.php?step=1
Referrer : http://mywebsite.com/forum/install/upgrade_365.php?rand=527
IP Address : XX.XXX.XXX.XX
Username :
Classname : vb_database

Marco van Herwaarden
Fri 27th Apr '07, 4:07am
To troubleshoot this, reupload all the original vB non-image files (except install/install.php). ensure that you have downloaded a vBulletin package with the XML-files. Make sure you upload these in ASCII format and overwrite the ones on the server.

Once the files are uplaoded, run install/upgrade.php again.

777connect
Fri 27th Apr '07, 4:16am
To troubleshoot this, reupload all the original vB non-image files (except install/install.php). ensure that you have downloaded a vBulletin package with the XML-files. Make sure you upload these in ASCII format and overwrite the ones on the server.

Once the files are uplaoded, run install/upgrade.php again.

I have done this twice now and still get the same results.

Marco van Herwaarden
Fri 27th Apr '07, 4:20am
Please open a support ticket. Make sure to include acces information.

777connect
Fri 27th Apr '07, 4:29am
Please open a support ticket. Make sure to include acces information.

I open a support ticket 24 hours ago with this issue. I have jsut updated it.
It is ticket# : 635776

Marco van Herwaarden
Fri 27th Apr '07, 4:54am
Then please stick to the support ticket.

777connect
Fri 27th Apr '07, 5:09am
I open a support ticket 24 hours ago with this issue. I have jsut updated it.
It is ticket# : 635776

Thanks Marco for taking care of the problem. I truly appreciate it.