Register Members List Search Today's Posts Mark Forums Read

Mod Options
Old 23 Nov 2009, 19:26
blh654 blh654 is offline
Join Date: Feb 2008
[HELP] Reimported users table, now getting database error for arcade

Hi, I had to reimport my users table because of an error I made. It was before I installed the arcade.

After the import, I get this error from the arcade page when trying to access it:
mySQL query error: SELECT userid, username, posts, arcade_ban, times_played, is_arcade_mod AS is_mod,
fav_games AS favs, user_sort, user_order, user_g_pp, user_s_pp, def_g_cat,
game_skin, arcade_mod_privs, arcade_pmactive,
usergroupid, membergroupids
FROM user
WHERE userid=1

mySQL error: Unknown column 'arcade_ban' in 'field list'
Obviously this is because the arcade tables aren't in the database - so how do I recreate them? I don't want to re-install my arcade because I have a lot of games/categories installed, and I don't want to lose them.

Also, I have vbPlaza installed too - will this be affected by the arcade errors?
Old 23 Nov 2009, 20:49
kh99 kh99 is offline
Join Date: Aug 2009
Real name: Kevin
Looking at the install code in the product xml file, I found the following additions are made to the user table (assuming you had the latest version installed):

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

so you could probably either find a way to execute that or else you could edit it into SQL queries pretty easily. Obviously all the data in those fields is gone.

I don't know whether or not that will fix everything, but it may be worth a shot.
Old 23 Nov 2009, 22:10
blh654 blh654 is offline
Join Date: Feb 2008
Hallelujah! It worked out like a charm (had to modify each query to run, but it was worth it!)

Thanks KH99!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 07:58.

Layout Options | Width: Wide Color: