Announcement

Collapse
No announcement yet.

New database error after server migration

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

  • New database error after server migration

    I was running Ensim 4.0.3 on Fedora Core 1, but then I backed up all my sites and upgraded to Ensim 4.0.3 on CentOS 3.4. I then restored the sites, but now am getting strange errors.
    When one of my vbulletin users tries to make a post or replies to one, they are getting this error:
    Database error in vBulletin 3.0.5:

    Invalid SQL: SELECT wordid, title FROM word WHERE title IN ('','','i','worked','a','lot','a','lot')
    mysql error: Table 'clemsontalk_com1.word' doesn't exist

    mysql error number: 1146
    The post still gets posted, but they don't get a confirmation. I was running MySQL 4.x prior to the migration, but after the migration Ensim defaulted to MySQL-3.23.x. I thought that may have been the problems, so I updated MySQL to 4.1.x, but am still getting the error. I also updated PHP to 5.x, but that did not seem to help.

  • #2
    Your word table is missing. This means you did not have a complete backup. How did you make the backup?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      I used Ensim's backup function. Is there a way I can recreate the word table?

      Comment


      • #4
        Asumming this is the only problem with your database, here is the query to recreate the word table:

        CREATE TABLE word (
        wordid INT UNSIGNED NOT NULL AUTO_INCREMENT,
        title CHAR(50) NOT NULL DEFAULT '',
        PRIMARY KEY (wordid),
        UNIQUE KEY title (title)
        );


        You will need to rebuild the search index also:

        Admin CP -> Import & Maintenance -> Update Counters -> Rebuild Search Index
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Ok, I seem to be having another problem now:

          Database error in vBulletin 3.0.5:

          Invalid SQL:
          REPLACE INTO postindex
          (wordid, postid, score, intitle)
          VALUES
          (1580, 287674, 1, 0), (4573, 287674, 1, 0), (264, 287674, 1, 0), (2058, 287674, 1, 0)

          mysql error: Can't open file: 'postindex.MYD'. (errno: 145)

          mysql error number: 1016

          Date: Saturday 18th of June 2005 05:23:23 PM
          Script: http://www.clemsontalk.com/vb/newreply.php
          Referer: http://www.clemsontalk.com/vb/showthread.php?p=287667
          Followed by:

          Database error in vBulletin 3.0.5:

          Invalid SQL:
          REPLACE INTO postindex
          (wordid, postid, score, intitle)
          VALUES
          (283, 287670, 1, 0), (358, 287670, 1, 0), (2688, 287670, 1, 0), (2486, 287670, 1, 0), (3832, 287670, 1, 0), (249, 287670, 2, 0), (2284, 287670, 1, 0), (211, 287670, 1, 0), (8229, 287670, 1, 0), (1163, 287670, 1, 0), (748, 287670, 1, 0), (1647, 287670, 1, 0), (5005, 287670, 1, 0), (7909, 287670, 1, 0), (16827, 287670, 1, 0), (15549, 287670, 1, 0), (165, 287670, 1, 0), (27376, 287670, 1, 0), (529, 287670, 1, 0), (691, 287670, 1, 0), (73, 287670, 1, 0), (710, 287670, 1, 0), (130, 287670, 1, 0)

          mysql error: Incorrect key file for table: 'postindex'. Try to repair it

          mysql error number: 1034

          Date: Saturday 18th of June 2005 04:23:09 PM
          Script: http://www.clemsontalk.com/vb/newreply.php
          Referer: http://www.clemsontalk.com/vb/newrep...reply&p=287665

          Comment


          • #6
            I ran Repair/Optimize tables, and all seems to be well again.

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X