Version: , by mathforum
Developer Last Online: May 2020
Version: Unknown
Rating:
Released: 08-14-2006
Last Update: Never
Installs: 0
No support by the author.
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!
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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.
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.
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.