Log in

View Full Version : Unknown column 'htmltitle' in 'field list'


nofat.co.nz
02-21-2009, 01:46 AM
Please can someone help me - I just upgraded my ibproarcade to ibProArcade v2.6.8+ 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 error: Unknown column 'htmltitle' in 'field list'

Here is the whole error message:

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',s kin='1',use_cats='0',crown_typ e='1',notification='pm',show_new='0',show_new_fram e='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_ t ime2='3600',games_pr='4',games_pp='40',user_choice s='5,10,15,20,25',allow_user_s kin='0',def_cat='1',cats_per_tr='0',show_crowns='1 ',show_t_won='1',score_sep='0' ,dec_amount='0',league_scores='10,9,8,7,6,5,4,3,2, 1,0',use_announce='1',announce ment='Arcade 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'

Please can someone let me know

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

vbplusme
02-21-2009, 02:00 AM
When you did the upgrade, did you "overwrite" the product?

HTML Title should have been "added" when you did the upgrade so I am suspicious that you didn't. HTH

edit: FYI, vBulletin 3.5.x, 3.6.x and 3.7.x:
---------------------------------
* overwrite all(!!) PHP-Files from /upload-Folder in your Forum
* Update the Product "ibProArcade" in Product-Manager (set "overwrite" to YES to update it)
* you're done

nofat.co.nz
02-21-2009, 06:52 AM
Yep did choose overwrite the product ;) - but I did only upgrade the php files - I didn't do any other files - but it does say php only

when I went overwrite the ibProArcade in admin it seemed to work - shows ibProArcade v2.6.8+ in both my admin and on the bottom of the arcade page

weird - I'll maybe do that last step again - fingers crossed

--------------- Added 1235207020 at 1235207020 ---------------

Thanks so much vbplusme :D:D:D

I went back and just did the product manager bit - and this time I uploaded the one from my computer (last time I took the online one) - and it worked :D:D

Thanks again :D:up::up:

vbplusme
02-21-2009, 07:04 AM
I looked at the source for "product-ibproarcade.xml" and importing that xml with overwrite enabled is what creates the missing tables so I am pretty sure that is where the problem is. HTH

Edit: VERY COOL, glad you have it sorted.

nofat.co.nz
02-21-2009, 07:24 AM
me too :D - thanks again :D:D:D