Announcement

Collapse
No announcement yet.

Impex Import Error

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

  • Impex Import Error

    Hi

    I have just purchased vbulletin 3.5x and have installed impex with a view for importing my simpleboard from my mambo CMS.
    When i tried to import the forums and threads i get the following messege

    "There seems to be a problem with the database.
    ImpEx Database errormysql error: Invalid SQL:
    INSERT INTO xvb_forum
    (
    styleid, title, options,
    displayorder, parentid, importforumid,
    importcategoryid, description, replycount,
    lastpost, lastposter, lastthread,
    lastthreadid, lasticonid, threadcount,
    daysprune, newpostemail, newthreademail,
    parentlist, password, link, childlist,
    title_clean, description_clean
    )
    VALUES
    (
    '',
    'Paper 1',
    89799,
    '1',
    '3',
    '3',
    '0',
    'Questions 1-15
    ',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'Paper 1',
    'Questions 1-15
    '
    )

    mysql error: Duplicate entry '65535' for key 1
    mysql error number: 1062
    Date: Thursday 27th of October 2005 12:58:27 PM

    When i hit the database cleanup and restart tab to attempt to fix it i get

    "
    Unable to add cookies, header already sent.
    File: /home/xxxxxxxx/public_html/exams/forum/impex/help.php
    Line: 17"

    Any suggestions as to how to fix these problems?

    thanks

    mark

    medical community
    Medical Interviews
    ITU
    Medical-Interview

  • #2
    You have exhausted your index field in the database, you will need to reinstall vBulletin and when you are importing ensure that you import all the forums in one go, i.e. set the per page to 5000.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Thanks jerry

      Reinstalled the vb3.5.0 files and imported the posts from my previous simpleboard with 5000 posts per session. No problems all works now

      many thanks

      mark
      medical community
      Medical Interviews
      ITU
      Medical-Interview

      Comment

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