Announcement

Collapse
No announcement yet.

Query problem in ImpEx.

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

  • [Forum] Query problem in ImpEx.

    Hello,

    I have this query problem while using ImpEx:

    ImpEx Database error

    mysql error: Invalid SQL:
    INSERT INTO vbulletin_forum
    (
    styleid, title, description,
    options, daysprune, displayorder,
    parentid, importforumid, importcategoryid,
    title_clean, description_clean
    )
    VALUES
    (
    '',
    'TU COMUNIDAD',
    '',
    89795,
    '30',
    '1046',
    '-1',
    '0',
    '1046',
    'TU COMUNIDAD',
    ''
    )


    mysql error: Duplicate entry '65535' for key 'PRIMARY'

    mysql error number: 1062

    Date: Monday 06th 2011f June 2011 11:20:46 PM
    Database: vbulletin
    MySQL error:
    What could I do?

  • #2
    What forum software are you converting from?

    Comment


    • #3
      Originally posted by riceboi1230 View Post
      What forum software are you converting from?
      PHPBB 3.0.0 to latest vBulletin.

      Fixed. I did:

      ALTER TABLE vbulletin_forum CHANGE COLUMN forumid forumid INT UNSIGNED NOT NULL AUTO_INCREMENT ;
      Last edited by ParadiseSC; Mon 6th Jun '11, 2:10pm.

      Comment

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