PDA

View Full Version : error when upgrading arcade


nofat.co.nz
02-21-2009, 01:06 AM
I have just upgraded to the new arcade - but I get this error in the arcade management section when I try and save the arcade 'on' again (had turned it off to do the upgrade)

mySQL query error: UPDATE games_settings SET arcade_status='0',arcade_language='en',g_display_s ort='gtitle',g_display_order='ASC',scores_amount=' 10',score_type='top',log='0',skin='1',use_cats='0' ,crown_type='1',notification='pm',show_new='0',sho w_new_frame='60',show_active='a:7:{s:5:\"glist\";s:1:\"1\";s:4:\"play\";s:1:\"1\";s:8:\"newscore\";s:1:\"1\";s:5:\"stats\";s:1:\"1\";s:15:\"viewtournaments\";s:1:\"1\";s:11:\"playtourney\";s:1:\"1\";s:11:\"viewtourney\";s:1:\"1\";}',auto_prune='0',auto_prune_time='0',auto_prune_ time2='3600',games_pr='4',games_pp='40',user_choic es='5,10,15,20,25',allow_user_skin='0',def_cat='1' ,cats_per_tr='0',show_crowns='1',show_t_won='1',sc ore_sep='0',dec_amount='0',league_scores='10,9,8,7 ,6,5,4,3,2,1,0',use_announce='1',announcement='Arc ade will be off just for 10 min hopefully - fingers crossed will be back on and all games will still be here :P


Welcome to the Arcade :)

Let me know if you know any good games that aren\'t already on here - and I\'ll try and find them ;)

Warning - the arcade is addictive - haha',announcement_parsed='Arcade will be off just for 10 min hopefully - fingers crossed will be back on and all games will still be here <img src=\"images/smilies/tongue.gif\" border=\"0\" alt=\"\" title=\"Tounge\" class=\"inlineimg\" /><br />
<br />
<br />
Welcome to the Arcade <img src=\"images/smilies/smile.gif\" border=\"0\" alt=\"\" title=\"Smile\" class=\"inlineimg\" /><br />
<br />
Let me know if you know any good games that aren\'t already on here - and I\'ll try and find them <img src=\"images/smilies/wink.gif\" border=\"0\" alt=\"\" title=\"Wink\" class=\"inlineimg\" /> <br />
<br />
Warning - the arcade is addictive - haha',games_new='15',games_popular='15',scoretimeo ut='4',htmltitle='%FORUMNAME% - %IBPRO% - %ACTION%'

mySQL error: Unknown column 'htmltitle' in 'field list'
mySQL error code:
Date: Friday 20th 2009f February 2009 10:00:03 PM


Why am I getting this error - mySQL error: Unknown column 'htmltitle' in 'field list' :eek::(

Please can someone let me know :up:

--------------- Added 1235185665 at 1235185665 ---------------

I am running 3.7.3 Patch Level 1 vbulletin in case you need to know ;)

--------------- Added 1235187241 at 1235187241 ---------------

please does anyone know why - or how I can fix it? - kind of urgent

private_ale
02-21-2009, 01:41 AM
Which arcade mod are you using? There is more than one you know.
Also, you will get a better reply if you ask in the modification's thread. If you use ibProArcade (https://vborg.vbsupport.ru/forumdisplay.php?f=170) it has an entire forum where you can ask for help.

nofat.co.nz
02-21-2009, 01:43 AM
I'm using ibProArcade

Cool - thanks for letting me know about the other place to post too :D

vbplusme
02-21-2009, 12:37 PM
is this error still happening?

mySQL error: Unknown column 'htmltitle' in 'field list'
mySQL error code:
Date: Friday 20th 2009f February 2009 10:00:03 PM

If you need it, here is the manual sql to add that table:

ALTER TABLE `games_settings` ADD `htmltitle` TEXT NOT NULL;


You should run it in an sql window in phpMyAdmin if you need it.