Implex from PHP 2.0.6 to latest VBB

[No-Logic]

Hey,

I have just setup a new VBB board and would like to try and import the posts across. If I can't its ok, I will just link to the old board.

When I do the check db/start import process it works and it can seem to talk to both databaes, but when I do the import users (to do the forums to do the threads), it comes up with a database error, and an email has been sent to the technical staff.

I assume this is a problem in the VBB side, as PHP doesn't give any nice errors like that. My PHP board is very heavily modified so I didnt really expect it to work. Would I be correct in assuming its a problem with the tables in php not being where implex expected?

Hope this makes sense, I have been up for a long time!

Many Thanks,

Morgan

[Jerry]

The phpBB2 importer is designed to work with 2.0.17. There maybe be significant enough difference that it won't work with a version that far back, I'd see to see the SQL error from the source of the page to know.

[No-Logic]

Thanks for your quick reply!

The error..

<!--
Database error in vBulletin:ImpEx Source :
Invalid SQL:
SELECT * FROM users
ORDER BY user_id
LIMIT 0,500
mysql error: Table 'qspec_forumtalk.users' doesn't exist
mysql error number: 1146


I have locked both sites to stop any content change while I do this, but I believe that doesnt lock the db or anything.

Users must exsist, as the old forum still works.. ?

[No-Logic]

I think I have worked it out, looks like in the original DB its phpbb_users..

[No-Logic]

It's all working, had osme massive problems with user id's. Where i already had myself as an admin, and when I did the import I lost all my admin access. Did some changed in sql and its all going now. The importer rocks, it converted everything,

vb rocks! thx!

[No-Logic]

Hey,

All works fine but now I get this error.

Database error in vBulletin 3.5.0:
Invalid SQL:
INSERT INTO userfield
(field5, userid)
VALUES
('', 270);
MySQL Error : Duplicate entry '270' for key 1 Error Number : 1062
Date : Friday, October 14th 2005 @ 04:07:48 PM
Script : http://forum.pulsenq.com/register.php (http://forum.pulsenq.com/register.php)
Referrer : http://forum.pulsenq.com/register.php (http://forum.pulsenq.com/register.php)
IP Address : 202.47.114.19
Username : Test
Classname : vb_database

The 270 bit progresses up one from each registration.

Any Ideas?

There are 268 members registered ..

I read after searching its a sync issue with two sections of the database. Can anything be done about it without redoing it from scratch?

[No-Logic]

This is now fixed. Added a user manually in sql and then deleted it and it synced it all up.