vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Anyone seen this database error before? (https://vborg.vbsupport.ru/showthread.php?t=136291)

BigJohnny 01-12-2007 02:13 PM

Anyone seen this database error before?
 
Ya i just got an email about this lastnight, And i dont know why

[QUOTE]
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' smiliecache','bbcodecache','noavatarperms');

MySQL Error : Can't find file: './*********/datastore.frm' (errno: 13)
Error Number : 1017
Date : Thursday, January 11th 2007 @ 09:25:25 PM
Script : http://**********/***/calendar.php?c=1&week=1160870400
Referrer : http://www.google.pl/search?q=vb-fxp...ient=firefox-a
IP Address : ***.***.***.***
Username :
Classname : vb_database
[/CODE]

noppid 01-12-2007 04:47 PM

Looks like the table is damaged. Try a repair in phpmyadmin or whatever you have handy.

You may want to invetory your backups and or do another first JIC.

blind-eddie 01-12-2007 08:03 PM

Ok My turn, I just got one also, what does this mean?....

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('33ab7abe21c100db9382aef2c1f329f2', 34, '68.143.186.146', 'ca6480cd20266d9b84b2a8ce25c9f8dd', 1168635816, '/', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.9) Gecko/20061206 Firefox/1.5.0.9', 0, 0);

MySQL Error : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error Number : 2002
Date : Friday, January 12th 2007 @ 02:03:37 PM
Script : http://outerzone.us/
Referrer :
IP Address : --------------
Username : ---------------
Classname : vb_database


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.16.10/624 - Release Date: 1/12/2007

Adrian Schneider 01-12-2007 08:43 PM

Quote:

Originally Posted by BigJohnny (Post 1157061)
Ya i just got an email about this lastnight, And i dont know why

Quote:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' smiliecache','bbcodecache','noavatarperms');

MySQL Error : Can't find file: './*********/datastore.frm' (errno: 13)
Error Number : 1017
Date : Thursday, January 11th 2007 @ 09:25:25 PM
Script : http://**********/***/calendar.php?c=1&week=1160870400
Referrer : http://www.google.pl/search?q=vb-fxp...ient=firefox-a
IP Address : ***.***.***.***
Username :
Classname : vb_database

As noppid said, the table is damaged and you need to repair it.
Quote:

Originally Posted by blind-eddie (Post 1157424)
Ok My turn, I just got one also, what does this mean?....

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('33ab7abe21c100db9382aef2c1f329f2', 34, '68.143.186.146', 'ca6480cd20266d9b84b2a8ce25c9f8dd', 1168635816, '/', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.9) Gecko/20061206 Firefox/1.5.0.9', 0, 0);

MySQL Error : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error Number : 2002
Date : Friday, January 12th 2007 @ 02:03:37 PM
Script : http://outerzone.us/
Referrer :
IP Address : --------------
Username : ---------------
Classname : vb_database


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.16.10/624 - Release Date: 1/12/2007

Kind of unrelated... should create a new thread next time.

The error means PHP cannot connect to MySQL for whatever reason.

(its down, network problems, etc)

Kirk Y 01-12-2007 10:27 PM

I get BigJohnny's error all the time on our test board, when the MySQL is down.


All times are GMT. The time now is 08:16 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.01009 seconds
  • Memory Usage 1,730KB
  • 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
  • (5)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