HELP: - mysql error number: 1064

[BrAinZ]

We have made no changes to our code and yet today I suddenly started to get this error when I try to update any user options from the Admin Control Panel.

We are currently on version 2.0.3 (yes I KNOW we need to upgrade.. I'm working on it, but have made NO changes to our live system.. Am testing the upgrade on a standalone laptop)

This is the error that I am getting:

“There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin Control Panel: Invalid SQL: SELECT COUNT(*) AS users FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND usergroup.cancontrolpanel=1 AND user.userid<>
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Thursday 27th of June 2002 09:05:05 AM
Script: /fadmin/user.php
Referer: http://www.mysite.com/fadmin/user.ph...&userid=XXX”

Any help would be appreciated!

[Chen]

You must update to 2.2.6 in order to fix this problem. It's an error caused by incompatibility with PHP 4.2.x.

[Jake Bunce]

see this thread for more info about your problem - http://www.vbulletin.com/forum/showt...threadid=44820

[Chen]

Originally posted by Jakeman
see this thread for more info about your problem - http://www.vbulletin.com/forum/showt...threadid=44820

...but don't use the files from there as you are running a very old version that will more than likely not work with those updated scripts.

[BrAinZ]

OK.. Thanks for the prompt replies guys!

[Night Owl]

I'm confused. I just upgraded to 2.2.6 but an still periodically getting this error:

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO loginlog (loginid, ip, username, password, userid, atime) VALUES ('','209.130.145.151', 'kinsey', 'fourkids'', '504', '1025332952')
mysql error: You have an error in your SQL syntax near '504', '1025332952')' at line 1

mysql error number: 1064

Date: Saturday 29th of June 2002 02:42:32 AM
Script: http://www.sybermoms.com/forums/~syb...ums/member.php
Referer: http://216.118.116.130/~sybermom/for...t=shack+attack

What do I need to do?

[Steve Machol]

I don't see a loginlog table in vB. Is this from a hack?

[Scott MacVicar]

Hack written by me

Post on the thread at vBulletin.org if you want to find it follow the link in my sig.

[Trillian]

I'm having the same trouble and it is maddening.

I woke this morning to find errors on every page... I couldn't access the admin panel either.

Through the web host I downloaded the entire database and files from the server, deleted them, and tried a completely fresh install with shiny new database too.

Still the same errors . I can go through the install steps using install.php (the pretty vBulletin page comes up and it populates the database with the tables). But once I try to access the control panel, I get e-mailed errors like this:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
mysql error: You have an error in your SQL syntax near 'userid=user.userid WHERE user.userid='1'' at line 1

mysql error number: 1064

Date: Saturday 29th of June 2002 09:53:41 PM
Script: http://www.aorworld.com/forums/forums/admin/index.php
Referer: http://www.aorworld.com/forums/admin/install.php

I've been in contact with the web host but he claims no changes or tweaks have been made to any of their server settings.

fwiw, here are the versions:

Kernel Version 2.4.9-31
Apache Version 1.3.26 (Unix)
Perl Version 5.006001
PHP Version 4.1.2
MySQL Version 3.23.45

and I tried installing vBulletin 2.2.6.

Thanks in advance.

p.s.... the url in the email "Script http://www.aorworld.com/forums/forums/admin/index.php" was generated by the email incorrectly. There should only be one "forums" in the url, so it should be:

http://www.aorworld.com/forums/admin/index.php

[Trillian]

And this might help too...

http://aorworld.com/info.php for my phpinfo page.