DB errors after moving vB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SnakeEaterITA
    New Member
    • Sep 2010
    • 15
    • 3.8.x

    [Forum] DB errors after moving vB

    Hi, I recetly moved my website and forum from one hosting service to a new one, and I imported my old database. I was forced to change DB username (from xxxx_frm to xx_frm), and now i get this king of error:

    Code:
    Invalid SQL:
    
                            SELECT ap.*,p.caption
                            FROM vb3_albumpicture ap
                            LEFT JOIN vb3_picture p on p.pictureid=ap.pictureid
                            WHERE state = 'visible' AND albumid = '13';
    
    MySQL Error   : Table 'xxxx_frm.vb3_albumpicture' doesn't exist
    now, i understand the problem is the name of the table he keeps looking for, he tries to load the old database table, but what should I do to solve the problem?

    Thanks a lot
  • we_are_borg
    Senior Member
    • Aug 2004
    • 5454
    • 4.2.X

    #2
    Have you changed the prefix in config.php else it follows the wrong one.

    Comment

    • SnakeEaterITA
      New Member
      • Sep 2010
      • 15
      • 3.8.x

      #3
      Yes, I already changed the config.php database username prefix, but i still get this error :S

      Comment

      • Zachery
        Former vBulletin Support
        • Jul 2002
        • 59097

        #4
        What do the tables in your database look like?

        Comment

        • SnakeEaterITA
          New Member
          • Sep 2010
          • 15
          • 3.8.x

          #5
          mmm what do you mean? they're like the standard vbulletin tables

          Comment

          • Lynne
            Former vBulletin Support
            • Oct 2004
            • 26255

            #6
            Originally posted by SnakeEaterITA
            Yes, I already changed the config.php database username prefix, but i still get this error :S
            Not the username, the prefix:
            HTML Code:
                //    ****** TABLE PREFIX ****** 
                //    Prefix that your vBulletin tables have in the database. 
            $config['Database']['tableprefix'] = '';
            It looks like you should have 'vb3_' in there.

            If this is a vb4 database though (you posted in the vb4 forum), then you have something wrong because there is no allbumpicture table in vb4. That error is from a modification if you really are running vb4.

            Please don't PM or VM me for support - I only help out in the threads.
            vBulletin Manual & vBulletin 4.0 Code Documentation (API)
            Want help modifying your vbulletin forum? Head on over to vbulletin.org
            If I post CSS and you don't know where it goes, throw it into the additional.css template.

            W3Schools <- awesome site for html/css help

            Comment

            • SnakeEaterITA
              New Member
              • Sep 2010
              • 15
              • 3.8.x

              #7
              I have vb3 as prefix because i upgraded months ago from vb3 to vb4, so I still have the old db tables

              Comment

              • Trevor Hannant
                vBulletin Support
                • Aug 2002
                • 24326
                • 5.7.X

                #8
                As per the second part of Zachery's reply, there is no albumpicture table in vB4 unless you're using a modification?S
                Vote for:

                - Admin Settable Paid Subscription Reminder Timeframe (vB6)
                - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

                Comment

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