Error while importing from phpbb2.08

[LordSoth]

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

[Jerry]

The SQL to allow it to continue would be :

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).

[LordSoth]

The SQL to allow it to continue would be :

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

[Jerry]

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