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


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]

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]

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]

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]

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]

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 :)

[David_R]

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 :)
darn.. deleted the row specified above. error emails still exist please help :(

[Marco van Herwaarden]

Error mail still got the same data?

[David_R]

Error mail still got the same data?
yeah it has exactly same data in it. :(

[angelicGrace]

When you get a page with that error, veiw it's page source. That should give you the full error as I found out a few days ago with a similar MySQL database error.

My first guess is that the games table of the MySQL database might be currupt. But don't ask me how to fix it. My tech gods do that for me.

[David_R]

When you get a page with that error, veiw it's page source. That should give you the full error as I found out a few days ago with a similar MySQL database error.

My first guess is that the games table of the MySQL database might be currupt. But don't ask me how to fix it. My tech gods do that for me.
I am not getting this error on any specific page.
I assume its generated because of a cron job (Arcade Tasks)

I am getting emails on my technical address specified in config.php file.

[David_R]

I am not getting this error on any specific page.
I assume its generated because of a cron job (Arcade Tasks)

I am getting emails on my technical address specified in config.php file.
Bumping back again, gurus please help me out get rid of this nasty emails.

Thanks.

[Marco van Herwaarden]

I suggest you try to uninstall this game, and remove all references to it from your tables.