Announcement

Collapse
No announcement yet.

Moved servers, now I'm getting a MySQL error :(

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

  • Moved servers, now I'm getting a MySQL error :(

    The forum looks normal, until I try to post anything. Then I get an error sent to my inbox reading:
    Code:
    Invalid SQL:
                                    REPLACE INTO postindex
                                    (wordid, postid, score, intitle)
                                    VALUES
                                     (17507, 181116, 1, 0)
    
    mysql error: Table 'forum.postindex' doesn't exist
    
    mysql error number: 1146
    I tried searching for this, but came up empty. Can anybody shed some light on this one? I'm not very MySQL savvy, so dumb it down a notch or two Thanks!

  • #2
    It means you are missing your postindex table. Do you know how to look into your database via cpanel/phpmyadmin ?

    Comment


    • #3
      I know how to poke around in there, but I don't know what I'm doing :-/

      Comment


      • #4
        Did your host move the account/system for you?

        Comment


        • #5
          I backed up the the db to a .sql file locally, which I then FTP'd up to the new server. Unfortunately I don't have access to the old server. The new host then took that sql file and created a new db with it. Mostly the same parameters except for the hostname in config.php... oh and the admin name was change too. But the db name stayed the same.

          Comment


          • #6
            See if you have postindex table in database or not.

            Try Rebuilding Search Index in Maintenance -> Update Counters.

            Comment


            • #7
              Originally posted by veenuisthebest View Post
              See if you have postindex table in database or not.

              Try Rebuilding Search Index in Maintenance -> Update Counters.
              Doing that now.. wow, this is taking a while. It's been going for the last 35-40 minutes.

              Comment


              • #8
                How long should this take? It's been going for a few hours now. 180,000 and climbing...

                Comment


                • #9
                  It really depends on the server. As long as it's progressing then it's still working on it.
                  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


                  • #10
                    Well son of a gun... That did the trick! Thanks veenuisthebest!!!

                    Comment


                    • #11
                      Maybe I spoke too soon. The forum itself seems to work. But whenever I go to User CP, I get the following error:

                      Code:
                      Database error in vBulletin 3.0.3:
                      
                      Invalid SQL: 
                          SELECT thread.threadid, thread.forumid
                          FROM thread AS thread, subscribethread AS subscribethread
                          LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
                          WHERE subscribethread.threadid = thread.threadid
                          AND subscribethread.userid = 2
                          AND thread.visible = 1
                          AND lastpost > 1254249703
                          AND deletionlog.primaryid IS NULL
                      
                      mysql error: Unknown column 'thread.threadid' in 'on clause'
                      
                      mysql error number: 1054
                      Does anybody have any ideas on this one?

                      Comment


                      • #12
                        You need to upgrade vB. That error is from incompatibilities between that ancient version of vB and your newer versions of PHP and MySQL.
                        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

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