PDA

View Full Version : lots of database erros in emails


dallibose
09-16-2011, 03:30 AM
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=viewdetails&videoid=79&page=67

Lynne
09-16-2011, 03:42 PM
There is no column 'phrasegroup_video' in default vbulletin, so this error is from a modification.

dallibose
09-17-2011, 11:04 PM
I uninstalled youtube link parser and since then there's been no error emails...

thanks..

--------------- Added 1316326556 at 1316326556 ---------------

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 1316358883 at 1316358883 ---------------

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...

dallibose
09-18-2011, 11:58 PM
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..

kh99
09-19-2011, 12:23 AM
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).

dallibose
09-19-2011, 02:25 AM
Well when I upgraded to 4.0x I had already uninstalled the mod you are referring to... how can I completely remove it..??

Lynne
09-19-2011, 02:39 AM
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.

dallibose
09-20-2011, 02:20 PM
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

Brandon Sheley
09-20-2011, 02:35 PM
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.