vb.org Archive - MySQL Error : Table 'xxxxxx' is read only

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

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - MySQL Error : Table 'xxxxxx' is read only (https://vborg.vbsupport.ru/showthread.php?t=197066)

007	11-23-2008 08:56 PM

MySQL Error : Table 'xxxxxx' is read only

I have a fairly large board that is growing fast. Lately I've noticed the following errors on a Windows 2003 server running IIS 6.0.

Quote:

MySQL Error : Table 'word' is read only

Quote:

MySQL Error : Table 'postindex' is read only

Among others.

I've done nothing (no mods or custom coding) that would effect these areas.

This is happening all the time now. Has anybody else had this happen before? How can I fix it?

SEOvB

11-24-2008 08:44 AM

Make sure the database user has full permissions to the database.

You can find your database user in your config.php file, and I've got no clue how to check the permissions on windows mysql :D

kermit2

11-24-2008 10:41 AM

You might want to try repairing the tables (eg via the mysql command line client), or it could be that another process has them locked. When you say 'all the time' do you literally mean all the time, or just very regularly?

007	11-24-2008 05:07 PM

By "all the time" I mean every few days, but when it happens it happens for 90% of posts, so I get about 200 emails about this (the auto emails) along with a few threads from members complaining.

If I repair and optimize tables the problem stops. It's only when I don't do that for a few days that this starts happening again.

SEOvB

11-25-2008 12:16 AM

When its occuring are you by chance backing up the databases?

All times are GMT. The time now is 05:39 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01944 seconds Memory Usage 1,713KB 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 (2)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
Messages: