vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Thread table read only? (https://vborg.vbsupport.ru/showthread.php?t=122583)

peterska2 07-30-2006 09:40 PM

Thread table read only?
 
I've just been posting up a few of the random emails I get into my mail box (the sort of jokes and chain mail that everyone gets) onto my forums, when I started getting this error

Database error in vBulletin 3.6.0 Release Candidate 3:

Invalid SQL:
INSERT INTO thread
(postusername, postuserid, title, iconid, visible, forumid, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('peterska2', 1, 'Dangerous Virus', 0, 1, 23, '1059, 953, 2451, 881, 22876', 1154298690, 1, 0, 1154298690, 'peterska2', 0, 0, 0);

MySQL Error : Table 'thread' is read only
Error Number : 1036
Date : Sunday, July 30th 2006 @ 11:31:30 PM
Script : http://www.peterska2.co.uk/newthread...ostthread&f=23
Referrer : http://www.peterska2.co.uk/newthread...newthread&f=23
IP Address :
Username : peterska2
Classname : vb_database
I have no idea why this is, and when I ran repair and optimize tables it continued to say that my thread table is read only.

If anyone has any ideas on what or why, then I'd appreciate a bit of help with this.

Thanks.

Shazz 07-30-2006 09:55 PM

If peterska can't do it, no one can :(
________
video review

peterska2 07-30-2006 09:55 PM

The database isn't my speciality though, and I know when I'm beat, hence the post.

I've tried everything I know, and withough dropping the table and restoring it, I don't know what else to do. Thats not really a viable option though.

peterska2 07-30-2006 10:07 PM

What ever it was, it's working again now, so it was just a temporary hitch.

Although if someone could explain why it did that, I would appreciate it.

Paul M 07-30-2006 10:22 PM

The table was locked (with a write lock) by another connection.


All times are GMT. The time now is 05:58 AM.

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.00958 seconds
  • Memory Usage 1,724KB
  • 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)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