vBulletin (Forum) Database error! - Please Help me

[David_R]

I get this error in my technical email everyday more then 100 emails

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE vb3_games SET highscorerid=,highscore=6000 WHERE shortname='neverland'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'highscore=6000 WHERE shortname='neverland'' at line 1

mysql error number: 1064

Please help me I dont know what is wrong in my arcade

[Rick Sample]

I had that same problem with my V3arcade, even after I uninstalled it. Im not sure if you use it still or not, but to get rid of that, all I did was in the admin panel, go to scheduled task, task manager, then delete the one that says arcade. I'm not sure if this is your problem or not, but it fixed my board and I was getting the same exact message!

[David_R]

this is very rare error email i receive, max 1 in 1 week.

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Originally Posted by Rick Sample

I had that same problem with my V3arcade, even after I uninstalled it. Im not sure if you use it still or not, but to get rid of that, all I did was in the admin panel, go to scheduled task, task manager, then delete the one that says arcade. I'm not sure if this is your problem or not, but it fixed my board and I was getting the same exact message!

I started facing this problem after upgraded to 3.0.7, was running perfect since ages.

[Zachery]

Originally Posted by David_R

I get this error in my technical email everyday more then 100 emails



Please help me I dont know what is wrong in my arcade

That is not the WHOLE ERROR.

Show us the WHOLE error.

[David_R]

Originally Posted by Zachery

That is not the WHOLE ERROR.

Show us the WHOLE error.

i receive that message in my config.php technical email address everyday, how do I show you further report ?

Thanks for replying

[Paul M]

Originally Posted by Zachery

That is not the WHOLE ERROR.

Show us the WHOLE error.

What's missing then ? - It looks like the whole error to me.

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE vb3_games SET highscorerid=,highscore=6000 WHERE shortname='neverland'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'highscore=6000 WHERE shortname='neverland'' at line 1

mysql error number: 1064

The section highlighted is where the error is - the value for highscoreid is missing.

[David_R]

Originally Posted by Paul M

What's missing then ? - It looks like the whole error to me.

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE vb3_games SET highscorerid=,highscore=6000 WHERE shortname='neverland'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'highscore=6000 WHERE shortname='neverland'' at line 1

mysql error number: 1064

The section highlighted is where the error is - the value for highscoreid is missing.

hi paul,
i am not a coder can you please tell me what to do in order to fix this problem ?

[David_R]

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE vb3_games SET highscorerid=,highscore=6000 WHERE shortname='neverland'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'highscore=6000 WHERE shortname='neverland'' at line 1

mysql error number: 1064

Date: Friday 20th of May 2005 07:25:46 AM
Script: http://forum.mydomain.com/cron.php?&rand=987029
Referer: http://www.mydomain.com/forum/
Username: xyz
IP Address: ***.**.**.**

I have disabled the game neverland from arcade admincp, but this error keeps coming.

Please help.

[Paul M]

I'm guessing this is the v3 arcade ? - if so you might get more response if you post in it's support thread.

I don't have it installed so I can't help you. From just looking at the error it seems to me that a cron job runs to update each games high score - and 'neverland' has a high score not associated with a user (deleted perhaps). If you can edit the games scores then look for a score of 6000 and delete it.

[David_R]

Originally Posted by Paul M

I'm guessing this is the v3 arcade ? - if so you might get more response if you post in it's support thread.

I don't have it installed so I can't help you. From just looking at the error it seems to me that a cron job runs to update each games high score - and 'neverland' has a high score not associated with a user (deleted perhaps). If you can edit the games scores then look for a score of 6000 and delete it.

I found a row in my vb3_games folder for game name neverland with a highscore of 6000.
I have deleted the entire row. shall wait for some more time to see if those alerts stop.

Thanks for help Paul