Announcement

Collapse
No announcement yet.

Importing problem

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

  • Importing problem

    Hi im getting this problem

    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 TABLESmysql error: No Database Selectedmysql error number: 1046Date: Friday 11th of April 2008 04:30:04 PMDatabase: sourceMySQL error: No Database Selected

    and here is my config file

    Code:
    <?php
    if (!defined('IDIR')) { die; }
    #################################################################### |;
    # vBulletin  - Licence Number L6542561
    # ---------------------------------------------------------------- # |;
    # Copyright ©2000–2008 Jelsoft Enterprises Ltd. All Rights Reserved. |;
    # This file may not be redistributed in whole or significant part. # |;
    # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |;
    # [URL]http://www.vbulletin.com[/URL] | [URL]http://www.vbulletin.com/license.html[/URL] # |;
    #################################################################### |;
    # The following settings allow ImpEx to connect to the vBulletin 3
    # database into which you will be importing data.
    ####
    #
    # TARGET - The target is the vBulletin database (where the  data is going to)
    #
    ####
    $impexconfig['target']['server']  = 'h41mysql19.secureserver.net';
    $impexconfig['target']['user']   = 'vbspurs';
    $impexconfig['target']['password']  = 'pass';
    $impexconfig['target']['database']  = 'pass';
    $impexconfig['target']['tableprefix'] = '';
    # 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
    $impexconfig['sourceexists']   = true;
    ####
    #
    # SOURCE - The source is the old forum database (where the  data is coming from)
    #
    ####
    # mysql / mssql
    $impexconfig['source']['databasetype'] = 'mysql';  // mysql OR mssql
    $impexconfig['source']['server']  = 'mysql243.secureserver.net';
    $impexconfig['source']['user']   = 'pass';
    $impexconfig['source']['password']  = 'pass';
    $impexconfig['source']['database']  = 'source';
    $impexconfig['source']['tableprefix']   = 'phpbb';
    ####
    #
    # DUPLICATE CHECKING
    # Where unique import id's are aviable ImpEx can check for duplicates with some
    # Tier2 systems this will need to be set to false.
    #
    # yahoo_groups, YaBB 2.1, Ikonboard 3.1.5 (for attachments)
    #
    ####
    define('dupe_checking', true);
    ###############################################################################
    ####
    #
    # ADVANCED - For a standard import or a novice user leave the settings below.
    #
    ####
    // Advanced Target
    $impexconfig['target']['databasetype'] = 'mysql'; // currently mysql only
    $impexconfig['target']['charset']  = '';
    $impexconfig['target']['persistent'] = false;  // (true/false) use mysql_pconnect
    // Advanced Source
    $impexconfig['source']['charset']  = '';
    $impexconfig['source']['persistent'] = false;
    # pagespeed is the second(s) wait before the page refreshes.
    $impexconfig['system']['language']  = '/impex_language.php';
    $impexconfig['system']['pagespeed']  = 1;
    define('impexdebug', false);
    define('emailcasesensitive', false);
    define('forcesqlmode', false);
    define('skipparentids', false);
    define('shortoutput', false);
    define('do_mysql_fetch_assoc', false);
    define('step_through', false);
    define('lowercase_table_names', false);
    define('use_utf8_encode', false);
    ?>

    Any help would be great

    thanks
    The opinions expressed in forum posts are my own personal opinions and do not represent any companies that i am associated with.

  • #2
    I'd guess you either on h41mysql19 or mysql243 and one account dosn't have the permissions to access the other ?

    Try copying all the source tables into the same database that vBulletin is in and setting source and target as the same, as long as there is a table prefix to stop any name clashes.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Sorry i forgot to write something in, its now connecting but getting these errors now

      Code:
      [B]Altering tables[/B]
      
      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. 
      [B]moderator[/B] - importmoderatorid [I]Completed[/I] 
      [B]usergroup[/B] - importusergroupid [I]Completed[/I] 
      [B]ranks[/B] - importrankid [I]Completed[/I] 
      [B]poll[/B] - importpollid [I]Completed[/I] 
      [B]forum[/B] - importforumid [I]Completed[/I] 
      [B]forum[/B] - importcategoryid [I]Completed[/I] 
      [B]user[/B] - importuserid [I]Completed[/I] 
      [B]style[/B] - importstyleid [I]Completed[/I] 
      [B]thread[/B] - importthreadid [I]Completed[/I] 
      [B]post[/B] - importthreadid [I]Completed[/I] 
      [B]thread[/B] - importforumid [I]Completed[/I] 
      [B]smilie[/B] - importsmilieid [I]Completed[/I] 
      [B]pmtext[/B] - importpmid [I]Completed[/I] 
      [B]avatar[/B] - importavatarid [I]Completed[/I] 
      [B]customavatar[/B] - importcustomavatarid [I]Completed[/I] 
      [B]customprofilepic[/B] - importcustomprofilepicid [I]Completed[/I] 
      [B]post[/B] - importpostid [I]Completed[/I] 
      [B]attachment[/B] - importattachmentid [I]Completed[/I] 
      [B]pm[/B] - importpmid [I]Completed[/I] 
      [B]usernote[/B] - importusernoteid [I]Completed[/I] 
      [B]phrase[/B] - importphraseid [I]Completed[/I] 
      [B]subscription[/B] - importsubscriptionid [I]Completed[/I] 
      [B]subscriptionlog[/B] - importsubscriptionlogid [I]Completed[/I]
      
      [B]Valid found tables :[/B]
      
      
      [B]Possibly custom tables or incorrect prefix :[/B]
      
      attachments [B]NOT[/B] found. 
      attachments_desc [B]NOT[/B] found. 
      auth_access [B]NOT[/B] found. 
      banlist [B]NOT[/B] found. 
      categories [B]NOT[/B] found. 
      config [B]NOT[/B] found. 
      confirm [B]NOT[/B] found. 
      disallow [B]NOT[/B] found. 
      forum_prune [B]NOT[/B] found. 
      forums [B]NOT[/B] found. 
      groups [B]NOT[/B] found. 
      posts [B]NOT[/B] found. 
      posts_text [B]NOT[/B] found. 
      privmsgs [B]NOT[/B] found. 
      privmsgs_text [B]NOT[/B] found. 
      ranks [B]NOT[/B] found. 
      search_results [B]NOT[/B] found. 
      search_wordlist [B]NOT[/B] found. 
      search_wordmatch [B]NOT[/B] found. 
      sessions [B]NOT[/B] found. 
      smilies [B]NOT[/B] found. 
      themes [B]NOT[/B] found. 
      themes_name [B]NOT[/B] found. 
      topics [B]NOT[/B] found. 
      topics_watch [B]NOT[/B] found. 
      user_group [B]NOT[/B] found. 
      users [B]NOT[/B] found. 
      vote_desc [B]NOT[/B] found. 
      vote_results [B]NOT[/B] found. 
      vote_voters [B]NOT[/B] found. 
      words [B]NOT[/B] found. 
      
      [B]If you have all red tables, i.e. none correct this could possible be your table prefix :[/B] 
      
      
      phpbb_album_ Failed Check database permissions and connection, or table prefix to ensure its correct
      The opinions expressed in forum posts are my own personal opinions and do not represent any companies that i am associated with.

      Comment


      • #4
        Sorry i know your busy but i need to get this working before tomorrow night, surely there is someone else apart from Jerry that knows IMPEX ?
        The opinions expressed in forum posts are my own personal opinions and do not represent any companies that i am associated with.

        Comment


        • #5
          If you have all red tables, i.e. none correct this could possible be your table prefix :

          phpbb_album_ Failed Check database permissions and connection, or table prefix to ensure its correct
          This means that your table prefix for your scource database is incorrect and is likely to be phpbb_ or phpbb_album_

          Comment


          • #6
            Originally posted by riverwire View Post
            Sorry i know your busy but i need to get this working before tomorrow night, surely there is someone else apart from Jerry that knows IMPEX ?
            Well ImpEx was trying to tell you :

            If you have all red tables, i.e. none correct this could possible be your table prefix :

            phpbb_album_ Failed Check database permissions and connection, or table prefix to ensure its correct
            I'd guess KA is right and it's phpbb_
            I wrote ImpEx.

            Blog | Me

            Comment

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