MySQL error

[mathforum]

I've installed everything and re-uploaded to make sure I didn't miss anything, but I keep getting this MySQL error:

mySQL query error: SELECT g.gid, g.active, count(*) nb, g.bestscore, g.bestmid AS champ_mid, u.username AS champ_name FROM games_list AS g INNER JOIN user AS u ON u.userid=g.bestmid WHERE active=1 GROUP BY bestmid ORDER BY 3 DESC LIMIT 1

mySQL error: Unknown column 'g.bestscore' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:31:47 PM

when I try to access arcade.php on my main site and

mySQL query error: SELECT usergroupid, title, arcade_access, p_require, max_play, ppd_require, ibpa_cats, tourney FROM usergroup

mySQL error: Unknown column 'tourney' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:34:01 PM

when I access Group Permissions from my AdminCP

I uploaded version 2.5.6 but in my product manager it says I have version 2.5.3.

Please help

Fixed! No help needed. Thank you MrZeroPage!

[Wolf_Hook]

Kind of the on the same lines.

mySQL query error: INSERT INTO pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie) VALUES ('13', 'Dundon's W.G.P', 'Your Highscore got beaten', 'This is an automatically generated message

Hello futix76

your Highscore in the game Pacman got beaten.

Click here to check the Highscores or here to play the game and claim back the Highscore !

Enjoy the Arcade

', '6', 0, 1155867338, 0, 0)

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 's W.G.P', 'Your Highscore got beaten', '[size=1][i]This is an a
mySQL error code:
Date: Thursday 17th of August 2006 07:15:38 PM

Fella on my forum has beaten a Pacman score twice in succession but receives this error after submitting a score.

Now that is to do with the auto PM sent but this is the first time a user has posted this error.

Occasionally members complain about not being able to register a high score as well. I am not sure if it is connected at all.

[MrZeropage]

the username has special characters in it

This is fixed for v2.5.7+


you should do the following to quick-fix it:

open /arcade.php

search for$DB->query("INSERT INTO ibf_pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie) VALUES ('".$senderid."', '".$sendername."', '".$title."', '" . addslashes($message) . "', '" . $recipient . "', 0, " . TIMENOW . ", 0, 0)");and replace it with$DB->query("INSERT INTO ibf_pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie) VALUES ('".$senderid."', '".addslashes($sendername)."', '".$title."', '" . addslashes($message) . "', '" . $recipient . "', 0, " . TIMENOW . ", 0, 0)");

[Wolf_Hook]

WOW, I got a response!

Thanks for that. My members love this arcade so thanks for coding it.

[MrZeropage]

WOW, I got a response!Why should you not ?

[Wolf_Hook]

I have had some problems recently with another mod and it seems that if you have a problem then you try and fix it yourself. No one was supporting it.

[MrZeropage]

Well... welcome to ibProArcade :)

[Neo_obs]

Zeropage is very good on support and I believe he should be getting alot of credit all over for his excellent support on his work. He works and helps us and helps the forums I believe he deserves a round of applause.

/me applauds

[Wheels]

I've installed everything and re-uploaded to make sure I didn't miss anything, but I keep getting this MySQL error:

mySQL query error: SELECT g.gid, g.active, count(*) nb, g.bestscore, g.bestmid AS champ_mid, u.username AS champ_name FROM games_list AS g INNER JOIN user AS u ON u.userid=g.bestmid WHERE active=1 GROUP BY bestmid ORDER BY 3 DESC LIMIT 1

mySQL error: Unknown column 'g.bestscore' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:31:47 PM

when I try to access arcade.php on my main site and

mySQL query error: SELECT usergroupid, title, arcade_access, p_require, max_play, ppd_require, ibpa_cats, tourney FROM usergroup

mySQL error: Unknown column 'tourney' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:34:01 PM

when I access Group Permissions from my AdminCP

I uploaded version 2.5.6 but in my product manager it says I have version 2.5.3.

Please help

Fixed! No help needed. Thank you MrZeroPage!


How did you fix it? I've been having that error on a friend's forum for about a week.

Edit: My cousin fixed it. Was an issue with the game_list table, which was corrupted. Simply uploading a back-up fixed it.