Thread: Profile Enhancements - iTrader 2.1.0 (Interim Release)
View Single Post
  #136  
Old 07-30-2008, 11:12 PM
TimberFloorAu's Avatar
TimberFloorAu TimberFloorAu is offline
 
Join Date: May 2008
Location: Brisbane
Posts: 2,264
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

We have uninstalled this mod, until its out of BETA.

We now have numerous MySql errors and need to fix this.

All template edits have been reverted, product succesfully uninstalled.

The error we get ( but cannot locate ) .. so help needed is:

Code:
nvalid SQL:

               SELECT
                       userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
                       IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
                       language.phrasegroup_global AS phrasegroup_global,
                       language.phrasegroup_itrader AS phrasegroup_itrader,
                       language.phrasegroup_posting AS phrasegroup_posting,
                       language.phrasegroup_prefix AS phrasegroup_prefix,
                       language.phrasegroup_adv_gallery_int AS phrasegroup_adv_gallery_int,
                       language.options AS lang_options,
                       language.languagecode AS lang_code,
                       language.charset AS lang_charset,
                       language.locale AS lang_locale,
                       language.imagesoverride AS lang_imagesoverride,
                       language.dateoverride AS lang_dateoverride,
                       language.timeoverride AS lang_timeoverride,
                       language.registereddateoverride AS lang_registereddateoverride,
                       language.calformat1override AS lang_calformat1override,
                       language.calformat2override AS lang_calformat2override,
                       language.logdateoverride AS lang_logdateoverride,
                       language.decimalsep AS lang_decimalsep,
                       language.thousandsep AS lang_thousandsep
                       ,mgcugp.mgc_cb_evo_default_color, ppgal_user.*
               FROM yobromofuser AS user
               LEFT JOIN yobromofuserfield AS userfield ON (user.userid = userfield.userid)
               LEFT JOIN yobromofusertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN yobromoflanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
                LEFT JOIN yobromofusergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid)
LEFT JOIN yobromofppgal_user AS ppgal_user ON (ppgal_user.userid = user.userid)
               WHERE user.userid = 2;

MySQL Error   : Unknown column 'language.phrasegroup_itrader' in 'field list'
Error Number  : 1054
Request Date  : Thursday, July 31st 2008 @ 09:37:38 AM
Error Date    : Thursday, July 31st 2008 @ 09:37:38 AM
Script        : http://www.xxxxxxxx.com/forum/itrader_feedback.php?u=34
Referrer      :
IP Address    : xxx.xxx.xxx.xxx
Username      :
Classname     : vB_Database
MySQL Version :
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01121 seconds
  • Memory Usage 1,772KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete