Announcement

Collapse
No announcement yet.

IMPEX problems with phpbb2.07

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    IMPEX problems with phpbb2.07

    Code:
     Import / Export
    
 [CENTER][URL="http://www.darkrangers.com/phpbb/impex/help.php"]Database cleanup & restart[/URL] ||| [URL="http://../docs/html/impex"] Online manual[/URL]
 Using includes/config.php for target config.
[/CENTER]
 
     
[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]Valid found tables :[/B]
 

[B]Possiablly custom tables or incorrect prefix :[/B]
 
phpbbattachments [B]NOT[/B] found.
phpbbattachments_desc [B]NOT[/B] found.
phpbbauth_access [B]NOT[/B] found.
phpbbbanlist [B]NOT[/B] found.
phpbbcategories [B]NOT[/B] found.
phpbbconfig [B]NOT[/B] found.
phpbbconfirm [B]NOT[/B] found.
phpbbdisallow [B]NOT[/B] found.
phpbbforum_prune [B]NOT[/B] found.
phpbbforums [B]NOT[/B] found.
phpbbgroups [B]NOT[/B] found.
phpbbposts [B]NOT[/B] found.
phpbbposts_text [B]NOT[/B] found.
phpbbprivmsgs [B]NOT[/B] found.
phpbbprivmsgs_text [B]NOT[/B] found.
phpbbranks [B]NOT[/B] found.
phpbbsearch_results [B]NOT[/B] found.
phpbbsearch_wordlist [B]NOT[/B] found.
phpbbsearch_wordmatch [B]NOT[/B] found.
phpbbsessions [B]NOT[/B] found.
phpbbsmilies [B]NOT[/B] found.
phpbbthemes [B]NOT[/B] found.
phpbbthemes_name [B]NOT[/B] found.
phpbbtopics [B]NOT[/B] found.
phpbbtopics_watch [B]NOT[/B] found.
phpbbuser_group [B]NOT[/B] found.
phpbbusers [B]NOT[/B] found.
phpbbvote_desc [B]NOT[/B] found.
phpbbvote_results [B]NOT[/B] found.
phpbbvote_voters [B]NOT[/B] found.
phpbbwords [B]NOT[/B] found.

[B]If you have all red tables, i.e. none correct this could possiable be your table prefix :[/B]

phpbb_
 [CENTER][URL="http://../"]vBulletin v3.5.0, Copyright ©2000-2005, Jelsoft Enterprises Ltd.[/URL][/CENTER]
      myvar = ""; timeout = 10;             function exec_refresh()             {                 window.status="Redirecting"+myvar; myvar = myvar + " .";                 timerID = setTimeout("exec_refresh();", 100);                 if (timeout > 0)                 { timeout -= 1; }                 else { clearTimeout(timerID); window.status=""; window.location="index.php"; }             }             exec_refresh();     
.
    Heres how my databse is like
    Code:
    [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_auth_access&sql_query=SELECT+%2A+FROM+%60phpbb_auth_access%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]         [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_auth_access"]phpbb_auth_access[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_banlist&sql_query=SELECT+%2A+FROM+%60phpbb_banlist%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]         [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_banlist"]phpbb_banlist[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_categories&sql_query=SELECT+%2A+FROM+%60phpbb_categories%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]          [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_categories"]phpbb_categories[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_config&sql_query=SELECT+%2A+FROM+%60phpbb_config%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]         [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_config"]phpbb_config[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_disallow&sql_query=SELECT+%2A+FROM+%60phpbb_disallow%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]           [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_disallow"]phpbb_disallow[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_forum_prune&sql_query=SELECT+%2A+FROM+%60phpbb_forum_prune%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]          [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_forum_prune"]phpbb_forum_prune[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_forums&sql_query=SELECT+%2A+FROM+%60phpbb_forums%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]            [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_forums"]phpbb_forums[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_groups&sql_query=SELECT+%2A+FROM+%60phpbb_groups%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]         [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_groups"]phpbb_groups[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_posts&sql_query=SELECT+%2A+FROM+%60phpbb_posts%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]           [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_posts"]phpbb_posts[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_posts_text&sql_query=SELECT+%2A+FROM+%60phpbb_posts_text%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]          [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_posts_text"]phpbb_posts_text[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_privmsgs&sql_query=SELECT+%2A+FROM+%60phpbb_privmsgs%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]          [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_privmsgs"]phpbb_privmsgs[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_privmsgs_text&sql_query=SELECT+%2A+FROM+%60phpbb_privmsgs_text%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]           [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_privmsgs_text"]phpbb_privmsgs_text[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_ranks&sql_query=SELECT+%2A+FROM+%60phpbb_ranks%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]            [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_ranks"]phpbb_ranks[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_search_results&sql_query=SELECT+%2A+FROM+%60phpbb_search_results%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]           [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_search_results"]phpbb_search_results[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_search_wordlist&sql_query=SELECT+%2A+FROM+%60phpbb_search_wordlist%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]         [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_search_wordlist"]phpbb_search_wordlist[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_search_wordmatch&sql_query=SELECT+%2A+FROM+%60phpbb_search_wordmatch%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]            [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_search_wordmatch"]phpbb_search_wordmatch[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_sessions&sql_query=SELECT+%2A+FROM+%60phpbb_sessions%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]          [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_sessions"]phpbb_sessions[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_smilies&sql_query=SELECT+%2A+FROM+%60phpbb_smilies%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]            [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_smilies"]phpbb_smilies[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_themes&sql_query=SELECT+%2A+FROM+%60phpbb_themes%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]        [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_themes"]phpbb_themes[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_themes_name&sql_query=SELECT+%2A+FROM+%60phpbb_themes_name%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]           [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_themes_name"]phpbb_themes_name[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_topics&sql_query=SELECT+%2A+FROM+%60phpbb_topics%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]         [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_topics"]phpbb_topics[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_topics_watch&sql_query=SELECT+%2A+FROM+%60phpbb_topics_watch%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]         [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_topics_watch"]phpbb_topics_watch[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_user_group&sql_query=SELECT+%2A+FROM+%60phpbb_user_group%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]          [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_user_group"]phpbb_user_group[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_users&sql_query=SELECT+%2A+FROM+%60phpbb_users%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]          [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_users"]phpbb_users[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_vote_desc&sql_query=SELECT+%2A+FROM+%60phpbb_vote_desc%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]         [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_vote_desc"]phpbb_vote_desc[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_vote_results&sql_query=SELECT+%2A+FROM+%60phpbb_vote_results%60&pos=0&goto=tbl_properties_structure.php"]              [/URL]        [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_vote_results"]phpbb_vote_results[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_vote_voters&sql_query=SELECT+%2A+FROM+%60phpbb_vote_voters%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]            [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_vote_voters"]phpbb_vote_voters[/URL]
      [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_words&sql_query=SELECT+%2A+FROM+%60phpbb_words%60&pos=0&goto=tbl_properties_structure.php"]               [/URL]            [URL="http://phreakonline.com:2082/3rdparty/phpMyAdmin/tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=drclan_phpbb&table=phpbb_words"]phpbb_words[/URL]
    For some reason, i cant get it to import. when i do, this comes up:
    Using includes/config.php for target config.
    no links.

    Tags: None
  • #2
    I'd guess your source database table prefix is "phpbb_" not "phpbb".
    I wrote ImpEx.

    Blog | Me

    Comment

    • #3
      i get the same error i do we fix that ?

      Comment

      • #4
        The error message gives you the answer, as with the case of the first post :

        Originally posted by ImpEx
        If you have all red tables, i.e. none correct this could possiable be your table prefix :

        phpbb_
        I wrote ImpEx.

        Blog | Me

        Comment

        • #5
          i have changed the table prefix but still get the error

          Comment

          • #6
            nm ive solve the problem thx for the help

            Comment

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