Announcement

Collapse
No announcement yet.

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

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

  • Steve Machol
    replied
    You need to upgrade vB. That error is from incompatibilities between that ancient version of vB and your newer versions of PHP and MySQL.

    Leave a comment:


  • CheeseFrog
    replied
    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?

    Leave a comment:


  • CheeseFrog
    replied
    Well son of a gun... That did the trick! Thanks veenuisthebest!!!

    Leave a comment:


  • Steve Machol
    replied
    It really depends on the server. As long as it's progressing then it's still working on it.

    Leave a comment:


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

    Leave a comment:


  • CheeseFrog
    replied
    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.

    Leave a comment:


  • veenuisthebest
    replied
    See if you have postindex table in database or not.

    Try Rebuilding Search Index in Maintenance -> Update Counters.

    Leave a comment:


  • CheeseFrog
    replied
    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.

    Leave a comment:


  • dodgeboard.com
    replied
    Did your host move the account/system for you?

    Leave a comment:


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

    Leave a comment:


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

    Leave a comment:


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

    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!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X