Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2011, 03:30 AM
dallibose dallibose is offline
 
Join Date: Apr 2009
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default lots of database erros in emails

i have upgraded from vbulletin 3.8 to 4.0.3 and I notice that I am getting lots of emails regarding vbulletin database error. Below is what I get...any idea on what might be causing this..is it some kind of video mod that could possibly cause this? I am using the youtube link parser which i am going to uninstall just in case..

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_video AS phrasegroup_video,
phrasegroup_posting AS phrasegroup_posting,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_video' in 'field list'
Error Number : 1054
Request Date : Thursday, September 15th 2011 @ 12:42:43 PM
Error Date : Thursday, September 15th 2011 @ 12:42:43 PM
Script : http://mywebsite.com/video.php?do=vi...oid=79&page=67
Reply With Quote
  #2  
Old 09-16-2011, 03:42 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There is no column 'phrasegroup_video' in default vbulletin, so this error is from a modification.
Reply With Quote
  #3  
Old 09-17-2011, 11:04 PM
dallibose dallibose is offline
 
Join Date: Apr 2009
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I uninstalled youtube link parser and since then there's been no error emails...

thanks..

--------------- Added [DATE]1316326556[/DATE] at [TIME]1316326556[/TIME] ---------------

well...getting it again once I installed a new mod...has it ever happened that installing new mod ever created this kind of problem?

--------------- Added [DATE]1316358883[/DATE] at [TIME]1316358883[/TIME] ---------------

may be not..i unstalled the new mod but still getting the same problem...

MySQL Error : Unknown column 'phrasegroup_video' in 'field list'

Any way to resolve this...I am getting irritated with the numbers of emails I am getting each minute...
Reply With Quote
  #4  
Old 09-18-2011, 11:58 PM
dallibose dallibose is offline
 
Join Date: Apr 2009
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am getting this as well

ySQL Error : Unknown column 'phrasegroup_adv_links_moderate' in 'field list'
Error Number : 1054
Request Date : Sunday, September 18th 2011 @ 07:40:52 PM
Error Date : Sunday, September 18th 2011 @ 07:40:52 PM

Seems like there's still something that needs to be removed from 3.8x..

Is there anyway I can remove the 3.8x mods from the server side? any help would be highly appreciated..
Reply With Quote
  #5  
Old 09-19-2011, 12:23 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looks to me like it's coming from this mod: https://vborg.vbsupport.ru/showthread.php?t=200819 so maybe uninstall it, or just try reinstalling (uninstalling can lose data, I have no idea if there's data that will be lost if you uninstall that mod. You should ask in the mod thread).
Reply With Quote
  #6  
Old 09-19-2011, 02:25 AM
dallibose dallibose is offline
 
Join Date: Apr 2009
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well when I upgraded to 4.0x I had already uninstalled the mod you are referring to... how can I completely remove it..??
Reply With Quote
  #7  
Old 09-19-2011, 02:39 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you make sure to remove all the files you uploaded with the modifications also? You should be going through each of your installation files and doing the steps backwards whenever you go to uninstall a modification.
Reply With Quote
  #8  
Old 09-20-2011, 02:20 PM
dallibose dallibose is offline
 
Join Date: Apr 2009
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I removed all the installed files for the mod and now I am getting this

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User *****_admin already has more than 'max_user_connections' active connections
/home/****/public_html/includes/class_core.php on line 312
Reply With Quote
  #9  
Old 09-20-2011, 02:35 PM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dallibose View Post
I removed all the installed files for the mod and now I am getting this

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User *****_admin already has more than 'max_user_connections' active connections
/home/****/public_html/includes/class_core.php on line 312
You need to talk to your host about this error.
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 02:50 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.04214 seconds
  • Memory Usage 2,240KB
  • Queries Executed 11 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)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