problems importing forums ipb 1.3.1 to vb3.01

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • philipwhite
    New Member
    • Feb 2004
    • 9

    problems importing forums ipb 1.3.1 to vb3.01

    I can inport users fine but when it comes time to import forums the importer fails any help would be appreciated.

    Code:
    Database error in vBulletin:ImpEx Target 3.0.1:
     
     Invalid SQL: SELECT forumid, importforumid FROM forum
     mysql error: Table 'cythcom_cythcom.forum' doesn't exist
     
     mysql error number: 1146
     
     Date: Wednesday 19th of May 2004 02:36:16 AM
     Script: http://cythraul.com/forums/impex/index.php
     Referer: http://cythraul.com/forums/impex/index.php
     Username: philipwhite
     IP Address: xxxxxxxxxxxxxxx
    I dumped my invision database into the vb3 database (cythcom_cythcom) so all invision tables start ibf_ and vb3 tables start vb3_ and I have this in the config.
    MBA Forums
  • SaN-DeeP
    Senior Member
    • Dec 2003
    • 1352
    • 1.1.x

    #2
    dumped ur invision db into vb3 db :S why is that ??
    TechArena - TechArena Community - Technology News - Tools Download - Tech Video - Gamer Guide - Hardware Review

    Comment

    • Jerry
      Senior Member
      • Dec 2002
      • 9137
      • 1.1.x

      #3
      Originally posted by philipwhite
      I can inport users fine but when it comes time to import forums the importer fails any help would be appreciated.

      Code:
      Database error in vBulletin:ImpEx Target 3.0.1:
       
       Invalid SQL: SELECT forumid, importforumid FROM forum
       mysql error: Table 'cythcom_cythcom.forum' doesn't exist
       
       mysql error number: 1146
       
       Date: Wednesday 19th of May 2004 02:36:16 AM
       Script: http://cythraul.com/forums/impex/index.php
       Referer: http://cythraul.com/forums/impex/index.php
       Username: philipwhite
       IP Address: xxxxxxxxxxxxxxx
      I dumped my invision database into the vb3 database (cythcom_cythcom) so all invision tables start ibf_ and vb3 tables start vb3_ and I have this in the config.
      Must be something missing in the config.

      Is :

      targettableprefix = vb3_ ?

      cythcom_cythcom.forum looks like it should be cythcom_cythcom.vb3_forum

      if thats what the prefix is.
      I wrote ImpEx.

      Blog | Me

      Comment

      • Shack Networks
        New Member
        • May 2004
        • 1

        #4
        In the ibp file 006.php do a search for the two instances of targete and replace with the word target, then run the script again and it should work.

        A simple spelling mistuke tis all.

        H

        Comment

        • philipwhite
          New Member
          • Feb 2004
          • 9

          #5
          thanks shack I'll give it a try
          MBA Forums

          Comment

          • Jerry
            Senior Member
            • Dec 2002
            • 9137
            • 1.1.x

            #6
            Whoops, updated the scripts now.
            I wrote ImpEx.

            Blog | Me

            Comment

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