phpbb arcade error?

All about creating websites!
Post Reply
User avatar
xero
Newbie
Newbie
Posts: 4
Joined: 27 Jun 2006, 16:00
15

phpbb arcade error?

Post by xero »

ERROR, No Game Data Received


DEBUG MODE

SQL Error : 1054 Unknown column 'game_id' in 'where clause'

SELECT * FROM an1m3clan_ina_games WHERE game_id = 0
i get this error when i try to use my site arcade can anyone tell me how to fix it?

User avatar
bad_brain
Site Owner
Site Owner
Posts: 11598
Joined: 06 Apr 2005, 16:00
16
Location: The zone.
Contact:

Post by bad_brain »

the game_id column is missing in the database, so you have to add it. I found this query which have worked for people with the same problem:

Code: Select all

ALTER TABLE `an1m3clan_ina_games' ADD `game_id' MEDIUMINT( 9 ) DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
simply run it in phpmyadmin... :wink:

Post Reply