Announcement

Collapse
No announcement yet.

Invision Power Board v1.1.2

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

  • Invision Power Board v1.1.2

    Does the import script work for it?

    I'm getting the error

    Invalid SQL: SELECT template FROM template WHERE title='options'
    mysql error: Table 'gyms12_t12.template' doesn't exist

    I look at the tables in the database via phpmyadmin and notice they are all ibf_ prefixed. They do not have a template table but a templates instead. What am I doing wrong?
    Canadian Bodybuilding | Canadian Bodybuilding Forum

  • #2
    This script has been tested and does work. It looks like you aren't using the correct prefix (ibf_). Make sure you are using the correct values for:

    - Name of Invision Power Board Database
    - Invision Power Board Table Prefix
    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
      Line 105 of the script code
      makeinputcode("Invision Power Board Table Prefix","idbprefix","ibf_",1,60);

      Seems like I don't have a choice in the matter. ibf_ is used regardless. Unless I can set the idbprefix somewhere??

      Here is what some of the tables look like
      Attached Files
      Canadian Bodybuilding | Canadian Bodybuilding Forum

      Comment


      • #4
        BTW, what I've done is moved the whole database to a new server, uploaded all the vb files and now I'm trying to do the convert. Maybe I'm going about it wrong??
        Canadian Bodybuilding | Canadian Bodybuilding Forum

        Comment


        • #5
          You need to install vB2 before you run the importer.

          Go to admin/install.php and run that script.
          Scott MacVicar

          My Blog | Twitter

          Comment


          • #6
            Ah, now I see my problem. Last question, do I install in the same database or do install a new database then use the import script to bring it into the vb one?
            Canadian Bodybuilding | Canadian Bodybuilding Forum

            Comment


            • #7
              either is good as long as the username and password for the vbulletin database has access to read the invision database.

              Using two databases would probably be easier for maintence since you can remove the old database once imported.
              Scott MacVicar

              My Blog | Twitter

              Comment


              • #8
                Thanks guys
                Canadian Bodybuilding | Canadian Bodybuilding Forum

                Comment


                • #9
                  Odd, I did the installation, all is well but there are no replies to any posts. Any idea's?
                  Canadian Bodybuilding | Canadian Bodybuilding Forum

                  Comment


                  • #10
                    now that the installation is complete.

                    download importers.zip from members area and upload this into a folder called importers in your root vBulletin folder.

                    Then visit the admin panel and select BBImport from the left hand menu and import from Invision.
                    Scott MacVicar

                    My Blog | Twitter

                    Comment


                    • #11
                      hehe, i did that, I went through the whole import process, everything is fine. It shows the first post in all the threads and no replies. I checked the post table and they are all in there. It just doesn't seem to show replies anywhere.
                      Canadian Bodybuilding | Canadian Bodybuilding Forum

                      Comment


                      • #12
                        did you rebuild
                        thread info then rebuild forum info?

                        This is required after an upgrade.
                        Scott MacVicar

                        My Blog | Twitter

                        Comment


                        • #13
                          I could rebuild forum but then when i rebulid thread I get this error

                          Database error in vBulletin Control Panel 2.3.0:

                          Invalid SQL: UPDATE thread SET lastpost=1062474542,replycount=0,postusername='Da Bomb', postuserid='146', lastposter='Da Bomb',attach= WHERE threadid=1737
                          mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE threadid=1737' at line 1

                          MySQL version is 3.23.49

                          Any idea's?
                          Last edited by musclenexus; Wed 3 Sep '03, 1:17am.
                          Canadian Bodybuilding | Canadian Bodybuilding Forum

                          Comment


                          • #14
                            Nevermind, I found the problem. I'll just post the thread link here in case if someone does a search and stumbles across this thread.

                            Last fix for 2.3.0 imports then update of threads
                            http://www.vbulletin.com/forum/showt...546#post463546
                            Canadian Bodybuilding | Canadian Bodybuilding Forum

                            Comment


                            • #15
                              its something that changed in recent versions of MySQL

                              doing a sum on a numeric column returns NULL instead of 0.

                              I guess this would be a bug, though i'd have to do some testing first.
                              Scott MacVicar

                              My Blog | Twitter

                              Comment

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