vb.org Archive - mysql errors

Page 1 of 2

Show 40 post(s) from this thread on one page

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=70869)

Watson

10-22-2004 09:41 AM

mysql errors

I keep getting around 300 odd emails a day with errors like this in them

Code:

Database error in vBulletin 3.0.3:



Invalid SQL: SELECT attachmentid, COUNT(*) AS views FROM attachmentviews GROUP BY

attachmentid

mysql error: Can't find file: 'attachmentviews.MYD' (errno: 2)



mysql error number: 1017



Date: Thursday 21st of October 2004 10:10:11 AM

Script: http://forums.bootleg.org.uk/cron.php?&rand=790522

Referer: http://forums.bootleg.org.uk/showthread.php?p=10417&posted=1#post10417

Username: Watson

IP Address: 62.252.128.25

They aint able to do anything over at vb.com cause I used hacks, but these emails are really annoying me now, anyone know what could be causeing them?

Watson

Brad	10-22-2004 03:09 PM

Run this query:

[sql]REPAIR TABLE attachmentviews;[/sql]

Xenon

10-22-2004 04:01 PM

it could be needed to run it more than once.

Watson

10-22-2004 04:04 PM

got this error

repair error Can't find file: 'attachmentviews.MYD' (errno: 2)

Xenon

10-22-2004 04:13 PM

it's a corruption in your DB, nothing to do with vBulletin itself.

try upload the file tools.php from your vb zip file and run the repair option several times, if that doesn't help, you will have to contact the server admin, to repair the DB manually.

it could also mean you would have to upload a backup...

Watson

10-22-2004 09:02 PM

ahh, its been like that for ages now, so any backup I got will have same problems :( I tried the tools.php a while ago and still had same problem. Only good thing thats came of it is I filtered the mail into a new folder, heh, but still a pain. I will have a word with the server admins, cause I know them personally, its just trying to convince 1 of them to have a look :p

thanks for the help tho :)

Zachery

10-22-2004 09:40 PM

http://www.vbulletin.com/forum/showp...98&postcount=4 :)

Watson

10-23-2004 08:45 AM

got another error mate

SQL-query :

DROP IF EXISTS threadviews

MySQL said:

You have an error in your SQL syntax near 'IF EXISTS threadviews' at line 1

Zachery

10-23-2004 12:20 PM

Quote:

Originally Posted by Watson

got another error mate

SQL-query :

DROP IF EXISTS threadviews

MySQL said:

You have an error in your SQL syntax near 'IF EXISTS threadviews' at line 1

give it another shot now (i edited my post)

Watson

10-23-2004 04:49 PM

Cheers Zach, both executed succesful, I will let you know later on if it works (no more emails :))

All times are GMT. The time now is 03:00 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01318 seconds Memory Usage 1,728KB 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 (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: