Announcement

Collapse
No announcement yet.

Problem with importing from PHPbb

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

  • Problem with importing from PHPbb

    Hello
    During the import process I've got following error:
    Code:
    ImpEx Database errormysql error: Invalid SQL: 
                SELECT post_text,post_subject FROM cpfrm_posts_text
                WHERE
                post_id=
                
    
    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 '' at line 3
    
    mysql error number: 1064
    
    Date: Wednesday 22nd of November 2006 01:23:21 AM
    Database: u21293
    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 '' at line 3
    It occurs after successful import of ~2086 post.
    It seems that it is because of missing post_id = 2087 in the table above.
    Is there way to continue import from post_id=2088?
    Thanks for the answer and sorry for my English.
    Artyem

  • #2
    Fill out a support ticket at:

    http://members.vbulletin.com/members...ontactform.php

    Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.
    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
      Steve, thanks for the fast answer.
      Can you explain me what namely I should describe in detail?
      Thanks,
      Artyem

      Comment


      • #4
        I got the same problem with ImpEx 1.72 and vB 3.6.3, altough the ImpEx is skipping post_ids serveral times before failing like this.

        Last week I did a test Import with 1.70 to 3.6.2 with the same DB dump, no such problem.

        I'll send you guys a ticket.
        Last edited by pedantic; Wed 22 Nov '06, 1:59am.

        Comment


        • #5
          Fixed in 1.73 which will be out in the next 24 hours.
          I wrote ImpEx.

          Blog | Me

          Comment


          • #6
            Jerry, could you please show in member area number of the current version of ImpEx available for downloading? Like version of vbulletin.
            Thanks,
            Artyem.

            Comment


            • #7
              Well, I faced the same problem, and found out that there were some phpbb_post rows, that didn't had an association with the phpbb_post_text table.

              Lacking referential integrity can lead to problems like these, but it was easy to solve. I just had to delete these orphan rows, and everything proceeded smoothly.

              Comment


              • #8
                Originally posted by artvs View Post
                Jerry, could you please show in member area number of the current version of ImpEx available for downloading? Like version of vbulletin.
                Thanks,
                Artyem.
                1.73 is out now and it handles the broken referential integrity in the phpBB2 database.
                I wrote ImpEx.

                Blog | Me

                Comment


                • #9
                  Jerry, are you sure that impex archive is normal? I can see in it some strange files like moo.txt or test.txt but ImpEx folder is empty

                  Comment

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