Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Unknown column 'htmltitle' in 'field list' Details »»
Unknown column 'htmltitle' in 'field list'
Version: , by nofat.co.nz nofat.co.nz is offline
Developer Last Online: Dec 2013 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 02-21-2009 Last Update: Never Installs: 0
 
No support by the author.

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:\"ne wscore\";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',au to_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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 02-21-2009, 02:00 AM
vbplusme vbplusme is offline
 
Join Date: Sep 2008
Location: CyberSpace
Posts: 332
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #3  
Old 02-21-2009, 06:52 AM
nofat.co.nz nofat.co.nz is offline
 
Join Date: Sep 2006
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 [DATE]1235207020[/DATE] at [TIME]1235207020[/TIME] ---------------

Thanks so much vbplusme

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

Thanks again :up::up:
Reply With Quote
  #4  
Old 02-21-2009, 07:04 AM
vbplusme vbplusme is offline
 
Join Date: Sep 2008
Location: CyberSpace
Posts: 332
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 02-21-2009, 07:24 AM
nofat.co.nz nofat.co.nz is offline
 
Join Date: Sep 2006
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

me too - thanks again
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 01:56 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03807 seconds
  • Memory Usage 2,239KB
  • Queries Executed 18 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (4)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete