vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database error after uninstalling some mod :( (https://vborg.vbsupport.ru/showthread.php?t=142824)

dj_melayu 03-22-2007 05:05 PM
Database error after uninstalling some mod :(
 
Hi guys, I am really need ya help regarding to my problem posted here.

Your immediate attention is highly appreciated since the Author of this hack was last taken action on 17. April 2006 For your information this thread is supported but I wonder why he don't support his mod:)

Best Regards & Sorry for posting in the wrong sections :D

upirate 03-22-2007 05:13 PM
not only its the wrong section. thats an inppropriate title for a post. Everyone needs help.

dj_melayu 03-22-2007 05:18 PM
Can you give a positive feedback? I really need help :)

SCRIPT3R 03-22-2007 05:20 PM
the mod is tagged as Supported so why not just email/PM the mod creator? An additional note... why would you install a hack that has not yet been released for the current version of vB without the hack authors notation that it will work? Guess you learned your lesson huh?

dj_melayu 03-22-2007 05:25 PM
Quote:
Originally Posted by GearTripper (Post 1209704)
the mod is tagged as Supported so why not just email/PM the mod creator? An additional note... why would you install a hack that has not yet been released for the current version of vB without the hack authors notation that it will work? Guess you learned your lesson huh?

I don't know whether it is compatible with 3.6 version. But mine working fine on after I decided to uninstall that mod and install mod compatible with 3.6 version. Yeah, I know I just learned someting but could ya guys just help me fix this problem?

Can I just remove the table for plugins?If yes, what is the name for plugins table? For your information,I didnt backup my db for today since it just 2.30am here. My last backup was did yesterday on 11pm (Thursday). I don't want to lose my new members, new thread/post and so on.
I know I'll losing it if I restore by backup.Please help me :)

Thanks for your help

SCRIPT3R 03-22-2007 05:29 PM
i'm not familiar with that particular hack... but the uninstall features should automatically remove all tables created during the install process. empty tables shouldn't really even hurt your DB if they still exists. if it's a plugin, you could disable all plugins so your board runs and then remove/reinstall them one by one as needed. what is the specific error message you're getting?

dj_melayu 03-22-2007 05:32 PM
I didnt give me any specific message.It just a database error page. For your info, I've disabled plugin tru config.php but still I couldn't login to my ACP.

Thanks Man, thanks for your help

SCRIPT3R 03-22-2007 05:51 PM
if you view the source code of the error page, you will be able to see the specific DB error message.

dj_melayu 03-22-2007 05:57 PM
Quote:
Originally Posted by GearTripper (Post 1209731)
if you view the source code of the error page, you will be able to see the specific DB error message.

Quote:
Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_showthread AS phrasegroup_showthread,
language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
language.phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
language.phrasegroup_profilefield AS phrasegroup_profilefield,
language.phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
language.phrasegroup_autopm_title AS phrasegroup_autopm_title,
language.phrasegroup_autopm_text AS phrasegroup_autopm_text,
language.phrasegroup_photoplog AS phrasegroup_photoplog,
language.phrasegroup_global AS phrasegroup_global,
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

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, 1, user.languageid))

WHERE user.userid = 5;

MySQL Error : Unknown column 'language.phrasegroup_posting' in 'field list'
Error Number : 1054
Date : Thursday, March 22nd 2007 @ 05:37:48 PM
Script : http://www.myforum.org/showthread.php?t=1833
Referrer :
IP Address : **********
Username :
Classname : vB_Database
Yeah, you're right, this is the database error details. I'm really nooby And Didn't know how to solve this. Really need ya help. :)

Thanks a lot guys..You're very helpfull community. I've restore by old db and this thread shall be close. Thanks and have a good day :)


All times are GMT. The time now is 05:54 PM.

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.01006 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete