[micheal332001]

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?!

Hi there you need to run this in your phpmyadmin

PHP Code:

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


Remember to put your prefix in