Announcement

Collapse
No announcement yet.

database error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    Yep.

    Leave a comment:


  • croft
    replied
    That fixed the problem =)
    A question tho.
    i se that there is a repair.php file in the admincp folder.
    can i run that when this happens again ?

    Leave a comment:


  • Steve Machol
    replied
    Your thread table is crashed and needs to be repaired:

    REPAIR TABLE thread;

    Leave a comment:


  • croft
    replied
    I have run that thing about 10 times now and nothing.
    How is the thread table supposed to look like ?
    Qause when i push the thread table to browse it it comes up with this.


    SQL-query :

    SHOW KEYS FROM `thread`

    MySQL said:


    Can't open file: 'thread.MYI'. (errno: 145)
    Is the problem in the thread table or what ?

    Leave a comment:


  • Steve Machol
    replied
    That is the correct way to repair this table. Sometimes you need to run the repair query more than once so try again.

    Leave a comment:


  • croft
    replied
    getting this when going in to phpmyadmin.


    SQL-query :

    SHOW KEYS FROM `thread`

    MySQL said:


    Can't open file: 'thread.MYI'. (errno: 145)


    "edit" I tryed running this
    REPAIR TABLE user;
    With no luck. Is there anything ellse i can do ? "edit"
    Last edited by croft; Sun 24 Aug '03, 11:47am.

    Leave a comment:


  • croft
    started a topic database error

    database error

    This is one of many errors i get. =(
    It have been working fine since i installed vb3 beta 5. But today these errors yust came running in =)
    I can acces the forum ok. its question about enter subforums that is the problem ?

    Database error in vBulletin 3.0.0 Beta 5:

    Invalid SQL:
    SELECT thread.title, thread.threadid, thread.forumid, thread.postuserid, thread.visible,
    NOT ISNULL(deletionlog.primaryid) AS isdeleted
    ,post.pagetext AS preview
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
    WHERE thread.threadid IN (0,5647)

    mysql error: Can't open file: 'thread.MYI'. (errno: 145)

    mysql error number: 1016
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X