Announcement

Announcement Module
Collapse
No announcement yet.

MySQL error: No database selected

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL error: No database selected

    Hi, I'm using the latest version of vbulletin and am trying to convert from phpbb 2. When I run the Check and update database tool, this is what happens:

    Code:
    Altering tables
    
    ImpEx will now Alter the tables in the vB database to include import id numbers.This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time.They will also be left after the import if you need to link back to the origional vB userid. 
    moderator - importmoderatorid Completed 
    usergroup - importusergroupid Completed 
    ranks - importrankid Completed 
    poll - importpollid Completed 
    forum - importforumid Completed 
    forum - importcategoryid Completed 
    user - importuserid Completed 
    style - importstyleid Completed 
    thread - importthreadid Completed 
    post - importthreadid Completed 
    thread - importforumid Completed 
    smilie - importsmilieid Completed 
    pmtext - importpmid Completed 
    avatar - importavatarid Completed 
    customavatar - importcustomavatarid Completed 
    customprofilepic - importcustomprofilepicid Completed 
    post - importpostid Completed 
    attachment - importattachmentid Completed 
    pm - importpmid Completed 
    usernote - importusernoteid Completed 
    phrase - importphraseid Completed 
    subscription - importsubscriptionid Completed 
    subscriptionlog - importsubscriptionlogid Completed 
    
    
    There seems to have been a problem with the database.
    
    ImpEx Database errormysql error: Invalid SQL: SHOW TABLES
    
    mysql error: No database selected
    
    mysql error number: 1046
    
    Date: Sunday 15th of June 2008 01:32:13 AM
    Database: ******_phpb1
    MySQL error: No database selected
    
    I've checked and double-checked the config files, but can't see what the problem can be. Any assistance would be very much appreciated.


    Edit: Actually, I've been using phpbb fully modded:http://phpbb-fm.com/support/index_fm.php so I presume this could be the problem?
    Last edited by angeljs; Sun 15th Jun '08, 2:42am.

  • #2
    mysql error: No database selected

    This means that you have the wrong target db info in your ImpExConfig.php file.
    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 have the same problem.. checked the config file and the right database info is there...

      ImpEx Database errormysql error: Invalid SQL: SHOW TABLES
      mysql error: No database selected
      mysql error number: 1046
      Date: Sunday 21st 2008f September 2008 02:28:53 AM
      Database: toronto_phpbb
      MySQL error: No database selected


      Its an old phpBB2.0... is that why? I noticed impex says 2.0.22 when you pick phpBB2 in the original selection...

      I bought vbulletin a week ago and I need to convert my board or this is useless to me.

      Please help!

      Comment


      • #4
        Post #2 applies to you too.

        Please start your own thread if you need any furthr help.
        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

        Working...
        X