Originally Posted by ggiersdorf

we need a thread for problems Zero.. Im getting this when going into the Admin CP

and clicking on usergroups or pathing to the arcade manually



mySQL query error: SELECT m.userid, m.username, m.posts, m.arcade_ban, m.times_played, m.is_arcade_mod AS is_mod,
m.fav_games AS favs, m.user_sort, m.user_order, m.user_g_pp,
m.user_s_pp, m.def_g_cat, m.game_skin, m.arcade_mod_privs, m.arcade_pmactive, g.adminpermissions AS is_admin,
g.arcade_access, g.p_require, g.max_play, g.ppd_require, g.ibpa_cats AS allowed_categories
FROM user AS m
LEFT JOIN usergroup AS g
ON (m.usergroupid = g.usergroupid)
WHERE userid=1 LIMIT 0, 1

mySQL error: Unknown column 'g.ibpa_cats' in 'field list'
mySQL error code:
Date: Sunday 06th of November 2005 07:42:54 AM


Version 3.5.0 fresh install. Anyone else had this and have the fix?!

Originally Posted by micheal332001

Hi there you need to run this in your phpmyadmin

Remember to put your prefix in

Originally Posted by Huijting

Aaarghh,

Got it working , i think

I changed the code :

ALTER TABLE `usergroup` ADD `arcade_pmactive` tinyint(1) NOT NULL default '1';

ALTER TABLE `usergroup` ADD `ibpa_cats` MEDIUMTEXT ;

to :

ALTER TABLE `user` ADD `arcade_pmactive` tinyint(1) NOT NULL default '1';

ALTER TABLE `usergroup` ADD `ibpa_cats` MEDIUMTEXT ;

For now it works for me

Originally Posted by Wordplay

is there no challange system in ipb arcade? :(