No announcement yet.

"No Database Selected" error (1046) in converting phpbb 2.0.6 to vb 3.0.7

  • Filter
  • Time
  • Show
Clear All
new posts

  • Khashyar
    The solution...

    The phpbb mysql database that I was having imported was restored in a backup by my webhost tech support (because it was damaged and had to be reinstalled).

    The reason that I was receiving the import error was because the user and password for the phpbb database were incorrect.

    Thanks again Steve and Jerry for your help.


    Leave a comment:

  • Khashyar
    Thanks for your response, Steve...

    I just submitted the requested information to you on the support ticket...

    Also, I would like to post what the issue was on this thread after it is solved so that others with the same issue might find the answer here...


    Leave a comment:

  • Steve Machol
    I've asked for more info in your support ticket.

    Leave a comment:

  • Khashyar
    I just posted a support ticket to hopefully have this issue solved quickly.


    Leave a comment:

  • "No Database Selected" error (1046) in converting phpbb 2.0.6 to vb 3.0.7

    Hi Everyone,

    I am receiving a "mysql error: No Database Selected" error with the importer when I run the first import module.

    Thank you for any help or ideas......

    I am importing from phpbb 2.0.6 to VB 3.0.7

    When I run the first module, I receive this error:

    moderator - importmoderatorid OK
    usergroup - importusergroupid OK
    ranks - importrankid OK
    poll - importpollid OK
    forum - importforumid OK
    forum - importcategoryid OK
    user - importuserid OK
    style - importstyleid OK
    thread - importthreadid OK
    post - importthreadid OK
    thread - importforumid OK
    smilie - importsmilieid OK
    pmtext - importpmid OK
    avatar - importavatarid OK
    customavatar - importcustomavatarid OK
    customprofilepic - importcustomprofilepicid OK
    post - importpostid OK
    attachment - importattachmentid OK
    pm - importpmid OK

    There seems to have been a slight problem with the Форум для русских женщин "The Russian Meeting Place" database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.


    Database error in vBulletin:ImpEx Source 3.0.7:

    Invalid SQL: SHOW TABLES
    mysql error: No Database Selected

    mysql error number: 1046

    Date: Tuesday 12th of April 2005 11:37:08 AM
    Username: xxxxxxxxxxx
    IP Address:


    Here are my config settings for the import module:

    [ Target Database ]
    ; The following settings allow ImpEx to connect to the vBulletin 3
    ; database into which you will be importing data.

    targetdatabasetype = mysql
    targetserver = localhost
    targetuser = "xxxx_xxxx"
    targetpassword = "*****"
    targetdatabase = russianm_rusforum
    targettableprefix =

    [ Source Database ]
    ; If the system that is being imported from uses a database,
    ; enter the details for it here and set 'sourceexists' to TRUE.
    ; If the source data is NOT stored in a database, set 'sourceexists' to FALSE

    sourceexists = true

    ; mysql OR mssql
    sourcedatabasetype = mysql
    sourceserver = localhost
    sourceuser = "xxx_xxxxx"
    sourcepassword = "***"
    sourcedatabase = russianm_xmb2
    sourcetableprefix = phpbb_


    Thanks for your thoughts about how to resolve this.

    Last edited by Khashyar; Tue 12 Apr '05, 11:16am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.