Announcement

Collapse
No announcement yet.

Error while importing from phpbb2.08

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

  • Error while importing from phpbb2.08

    Database error in vBulletin:ImpEx Target 3.0.1:

    Invalid SQL:
    INSERT INTO vb3_post
    (
    threadid, userid, importthreadid,
    parentid, username, title,
    dateline, pagetext, allowsmilie,
    showsignature, ipaddress, iconid,
    visible, attach, importpostid
    )
    VALUES
    (
    '1',
    '7',
    '2',
    '',
    'khalil',
    '',
    '1077509348',
    'i read naruto scanned manga. jajjaa',
    '1',
    '0',
    '*.*.*.*',
    '',
    '1',
    '',
    ''
    )

    mysql error: Unknown column 'importpostid' in 'field list'

    mysql error number: 1054

    Date: Wednesday 30th of June 2004 08:46:24 PM
    Script: http://www.tenstones.net/forums/impex/index.php
    Referer: http://www.tenstones.net/forums/impex/index.php

    Is there anyway around this without having to delete that field. Also now the import tool is stuck in redicting mode and just keeps reloading over and over. I found a thread about fixing that so I will try that.


    Thank-you
    Joe

  • #2
    The SQL to allow it to continue would be :

    Code:
    ALTER TABLE vb3_post ADD COLUMN importpostid BIGINT NOT NULL DEFAULT 0
    This is a bug that I've corrected in the latest download of the phpBB importer (and two others).
    Last edited by Jerry; Wed 30th Jun '04, 6:11pm.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Originally posted by Jerry
      The SQL to allow it to continue would be :

      Code:
      ALTER TABLE vb3_post ADD COLUMN importpostid BIGINT NOT NULL DEFAULT 0
      This is a bug that I've corrected in the latest download of the phpBB importer (and two others).
      Thanks Jerry. Worked like a charm. And sort of information are you looking for in terms of system information?

      Thank-you
      Joe

      Comment


      • #4
        Originally posted by LordSoth
        And sort of information are you looking for in terms of system information?
        Well if everything is working now, I don't need anything to diagnose the issue
        I wrote ImpEx.

        Blog | Me

        Comment

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