try another color scheme:


Go Back   TECH6.0 > Web Design/Development and SEO > Internet Forum Softwares > vBulletin


Database Errors help please

This is a discussion on Database Errors help please within the vBulletin section, part of the Internet Forum Softwares category; Database error in vBulletin 3.7.2: Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_global ...

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 22-08-2008, 07:16 PM
No Avatar

Techie
 
Join Date: Aug 2008
Posts: 52
UaECasher is on a distinguished road
Default Database Errors help please

Database error in vBulletin 3.7.2: Invalid 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_holiday AS phrasegroup_holiday, language.phrasegroup_prefix AS phrasegroup_prefix, 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 = 537; MySQL Error : Got error 12 from storage engineError Number : 1030Request Date : Friday, August 22nd 2008 @ 07:30:07 AMError Date : Friday, August 22nd 2008 @ 07:30:07 AMScript : http://www.casherz.com/forums/index.php?Referrer : http://www.casherz.com/forums/newthr...=newthread&f=6
IP Address : Username : Classname : vb_databaseMySQL Version :
Database error in vBulletin 3.7.2: Invalid SQL: SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, session.inforum, session.lastactivity, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid FROM session AS session LEFT JOIN user AS user ON(user.userid = session.userid) WHERE session.lastactivity > 1219400972 ORDER BY username ASC; MySQL Error : Got error 12 from storage engineError Number : 1030Request Date : Friday, August 22nd 2008 @ 06:44:32 AMError Date : Friday, August 22nd 2008 @ 06:44:33 AMScript : http://www.casherz.com/forums/index.php?Referrer : http://www.casherz.com/forums/regist...do=addmemberIP Address : 117.0.0.40Username : UnregisteredClassname : vb_databaseMySQL Version :
please help me
Reply With Quote
  #2  
Old 22-08-2008, 07:22 PM
webwizzy's Avatar

Administrator
 
Name: Vinayak
Join Date: Feb 2008
Location: India
Phone: Samsung Wave
Posts: 1,116
webwizzy is just really nicewebwizzy is just really nicewebwizzy is just really nicewebwizzy is just really nicewebwizzy is just really nice
Send a message via Yahoo to webwizzy
Default

its hard to understand coz the way you have posted the error.

anyways.. Error 12 means that MySQL cannot allocate more memory from the server. Usually this requires a restart of the server or manually killing unused processes on the server. So, contact your host.

btw.. if this occured after a mod install, then try disabling/uninstalling the most recent one you installed after which this error started appearing.
__________________
Always TAG and SHARE your threads
Submit your site to TECH6 Directory
TECH6 on Facebook - Like Us

Would you like to Link To Us | Support TECH6 by going Premium
Know more about me at Vinayaks.com | Follow TECH6 at Twitter


Reply With Quote
  #3  
Old 22-08-2008, 07:31 PM
No Avatar

Techie
 
Join Date: Aug 2008
Posts: 52
UaECasher is on a distinguished road
Default

what about styles will they do this?
Reply With Quote
  #4  
Old 22-08-2008, 07:33 PM
webwizzy's Avatar

Administrator
 
Name: Vinayak
Join Date: Feb 2008
Location: India
Phone: Samsung Wave
Posts: 1,116
webwizzy is just really nicewebwizzy is just really nicewebwizzy is just really nicewebwizzy is just really nicewebwizzy is just really nice
Send a message via Yahoo to webwizzy
Default

i don't think styles could cause this.

But if this occured right after installing a style, then there's no harm on uninstalling and seeing the effect.
__________________
Always TAG and SHARE your threads
Submit your site to TECH6 Directory
TECH6 on Facebook - Like Us

Would you like to Link To Us | Support TECH6 by going Premium
Know more about me at Vinayaks.com | Follow TECH6 at Twitter


Reply With Quote
  #5  
Old 22-08-2008, 07:43 PM
No Avatar

Techie
 
Join Date: Aug 2008
Posts: 52
UaECasher is on a distinguished road
Default

Well the only thing i recently installed is the ads page i got this error now


Database error in vBulletin : mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)/home/casherzc/public_html/forums/includes/class_core.php on line 311 MySQL Error : Error Number : Request Date : Friday, August 22nd 2008 @ 09:44:54 AMError Date : Friday, August 22nd 2008 @ 09:44:54 AMScript : http://www.casherz.com/forums/showth...?t=529Referrer : IP Address : 209.67.23.129Username : Classname : vb_databaseMySQL
Version :
Reply With Quote
  #6  
Old 22-08-2008, 08:02 PM
webwizzy's Avatar

Administrator
 
Name: Vinayak
Join Date: Feb 2008
Location: India
Phone: Samsung Wave
Posts: 1,116
webwizzy is just really nicewebwizzy is just really nicewebwizzy is just really nicewebwizzy is just really nicewebwizzy is just really nice
Send a message via Yahoo to webwizzy
Default

Database error in vBulletin : mysql_connect() Can't connect to local MySQL server
Your MySQL server is/was not running at that moment or there was an error with the server. Its a temporary problem and usually happens on shared hosting environment.
__________________
Always TAG and SHARE your threads
Submit your site to TECH6 Directory
TECH6 on Facebook - Like Us

Would you like to Link To Us | Support TECH6 by going Premium
Know more about me at Vinayaks.com | Follow TECH6 at Twitter


Reply With Quote
  #7  
Old 23-01-2011, 10:47 PM
No Avatar

Learner
 
Join Date: Jan 2011
Posts: 2
Varshaa is on a distinguished road
Default

Nice update
Reply With Quote
  #8  
Old 03-03-2011, 03:59 PM
No Avatar

Learner
 
Join Date: Mar 2011
Posts: 5
RoySon is on a distinguished road
Default

Cannot allocate more memory from the server. Usually this requires a restart of the server or manually killing unused processes on the server. So, contact your host.
Reply With Quote
Reply

Bookmarks

Tags
database, errors


Thread Tools
Display Modes




All times are GMT +5.5. The time now is 01:16 AM.

Contact Us - Tech6.com - Link to Us - Advertise - Submit Site - Privacy Statement - TOS - Top