[MissKalunji]

Originally Posted by micheal332001

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

it doesnt work.....

Thats what i get and its on an upgrade

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=1315 LIMIT 0, 1

mySQL error: Unknown column 'm.arcade_pmactive' in 'field list'
mySQL error code:
Date: Sunday 06th of November 2005 10:25:24 AM

found the bug :


it didnt execute this : $vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD arcade_pmactive tinyint(1) DEFAULT '1' NOT NULL");
$