View Single Post
  #1557  
Old 06-08-2013, 01:34 PM
sadiq6210 sadiq6210 is offline
 
Join Date: Sep 2005
Posts: 684
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by sadiq6210 View Post
I try to uninstall the mod but I got this error

Database error in vBulletin 4.1.12:

Invalid SQL:
DELETE FROM activitystreamtype WHERE section = 'product' AND type = 'review';

MySQL Error : Table 'dbname_testforum2.activitystreamtype' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 12th 2013 @ 02:25:48 PM
Error Date : Tuesday, March 12th 2013 @ 02:25:48 PM
Script : http://www.domain.com/vbtest/admincp...do=productkill
Referrer : http://www.domain.com/vbtest/admincp...duct_forums&s=
IP Address :
Username : sadiq6210
Classname : vB_Database
MySQL Version : 5.1.68-cll

_________________________________________

In 4.1.12 there is no activity stream

I will use it soon but I want to test it first and have all information about it.
Thank you for the great mod
Quote:
Originally Posted by Ted S View Post
The perils of using a significantly outdated version of vB with mods...

We'll be sure to code in db error suppression to avoid this bug but in the meantime you can comment out the lines in the .xml file, update and then uninstall.
I updated my forum to 4.2.1 and I tried to uninstall this mod
I uninstalled it and I didn't face any error during the un-installation process.

But after If I uninstalled it, the forum is not working at all (Database Error)! I receive many database errors in my email like this:

Code:
Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT 
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_activitystream AS phrasegroup_activitystream,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_adv_gallery_int AS phrasegroup_adv_gallery_int,
language.phrasegroup_bop5iframer AS phrasegroup_bop5iframer,
language.phrasegroupinfo AS lang_phrasegroupinfo,
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
, ppgal_user.ppicount, ppgal_user.pppcount, ppgal_user.lastimageid, ppgal_user.lastimagetitle, ppgal_user.lastimagedate, ppgal_user.lastpostid, ppgal_user.lastposttitle, ppgal_user.lastpostdate, ppgal_user.profile_active, ppgal_user.profile_exclude, ppgal_user.profile_include, ppgal_user.profile_orderby, ppgal_user.profile_cutoff, ppgal_user.profile_tabfirst, ppgal_user.profile_autosel, ppgal_user.profile_tabstats, ppgal_user.profile_tabhighlight, ppgal_user.profile_showtitle, ppgal_user.profile_showcat, ppgal_user.profile_showcontext, ppgal_user.profile_contextfirst, ppgal_user.profile_showhtitle, ppgal_user.profile_husername, ppgal_user.profile_showhcat, ppgal_user.profile_showhcontext, ppgal_user.ppfavcount, ppgal_user.upload_readpolicy, ppgal_user.profile_tabthumbs, ppgal_user.profile_limit 
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 5, user.languageid)) 

LEFT JOIN ppgal_user AS ppgal_user ON (ppgal_user.userid = user.userid) 
WHERE user.userid = 1 LIMIT 1;

MySQL Error : Unknown column 'language.phrasegroup_activitystream' in 'field list'
Error Number : 1054
I installed it again and the forum is working.
Again I tried to uninstall it >> the forum not working (database error)
Install it again >> the forum working.
...........

How can I uninstall it?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01140 seconds
  • Memory Usage 1,796KB
  • 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
  • (2)bbcode_quote
  • (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