vb.org Archive - MySQL Errors?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - MySQL Errors? (https://vborg.vbsupport.ru/showthread.php?t=254464)

I've just moved servers & i've receved a lot of these errors:

Code:

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' (2)

/home/thebadc/public_html/mydomain.com/includes/class_core.php on line 311



MySQL Error   :

Error Number  :

Request Date  : Tuesday, November 30th 2010 @ 02:33:13 PM

Error Date    : Tuesday, November 30th 2010 @ 02:33:13 PM

Script        : http://www.mydomain.com/archive/index.php/t-17056.html

Referrer      :

IP Address    : **.2*9.**.1*0

Username      :

Classname     : vB_Database

MySQL Version :

Does anyone know how to fix it?

This is a server issue and you'll have to talk to your host about it.

See this page for the causes of this error: http://www.vbulletin.com/docs/html/cantconnect

Thanks, i've just set up a support ticket.

I just got this error now, trying to view a forum via my browser:

Code:

Database error in vBulletin 3.8.6:



Invalid SQL:



                SELECT 

                        IF(votenum >= 1, votenum, 0) AS votenum,

                        IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

                 post.pagetext AS preview,post.thankscache,

                        thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,

                        thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,

                        thread.prefixid, thread.taglist, hiddencount, deletedcount

                        , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed

                        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

                        

                        , threadredirect.expires

Do you know what that means.

We need to see the whole error, not just the sql statement.

How do i get the whole error, that's all it give me.

Also my host said that the problem is that my sites to big for shared hosting, but i had a shared hosting account on my last server & i never had any problems.

They give me a link to upgrade to a VPS server, but do you think there just trying to get more money out of me?

Thanks

There should be something on the bottom of that error like this:

Code:

The actual mysql query/code/problem....



MySQL Error : some sort of something here

Error Number : another something here

Date : Sunday, April 13th 2008 @ 11:16:43 AM

Script : http://address.path.path/page.php

Referrer :

IP Address : **.***.**.***

Username : username

Classname : database

Heres the latest error i've been emailed: (1000's of them)

Code:

Invalid SQL:



                       SELECT *

                       FROM datastore

                       WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache','mailqueue','bookmarksitecache');



MySQL Error   : Can't find file: './thebadc_db/datastore.frm' (errno: 13)

Error Number  : 1017

Request Date  : Wednesday, December 1st 2010 @ 05:09:05 PM

Error Date    : Wednesday, December 1st 2010 @ 05:09:05 PM

Script        : http://www.domain.com/showthread.php?p=42666

Referrer      :

IP Address    : 66.249.66.133

Username      :

Classname     : vB_Database

MySQL Version :

Another one:

Code:

Database error in vBulletin 3.8.6:



Invalid SQL:



                       SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.calendarid,calendar.title, displayorder

                       FROM calendar AS calendar

                       LEFT JOIN calendarpermission AS calendarpermission ON

                               (calendarpermission.calendarid = calendar.calendarid AND usergroupid IN (1))

                       ORDER BY displayorder ASC;



MySQL Error   : Can't find file: './thebadc_db/calendar.frm' (errno: 13)

Error Number  : 1017

Request Date  : Wednesday, December 1st 2010 @ 03:27:07 PM

Error Date    : Wednesday, December 1st 2010 @ 03:27:07 PM

Script        : http://www.domain.com/calendar.php?c=1&week=1775347200

Referrer      :

IP Address    : 66.249.66.133

Username      : Unregistered

Classname     : vB_Database

MySQL Version :

And now my site wont load at all.

You need to repair your tables. Do it via phpMyAdmin or whatever interface you have to your database. 3 ways to repair a database

Although, looking at those again.... are you sure your imported the full database from your other site?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01068 seconds Memory Usage 1,735KB 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 (5)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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
Messages: