Announcement

Collapse
No announcement yet.

vb3 to vb3

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

  • vb3 to vb3

    hanging at step 006


    Database error in vBulletin:ImpEx Source 3.0.3:
    Invalid SQL: SELECT * FROM customprofilepic ORDER BY userid LIMIT 0,
    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 1

    anyway I can fix this?

  • #2
    Firstly, download the latest impex there is some error checking that went in recently to stop this SQL error getting passed to the database.

    Secondly, run this SQL :

    DELETE FROM datastore WHERE title='ImpExSession';

    To clear the broken session and start the whole import again.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Thanks Jerry, I had the latest..3.03 but was still getting the errors...while waiting I manually added the query's and everything worked fine. Thanks.

      Comment


      • #4
        Good to hear, though for public note. 3.03 is the vB version, impex versioning seprate and is in the status thread.
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          Sorry I meant the latest impex version

          Comment

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