phpBB >> vb3

[Ferghal]

Howdy,
Ive tried doing this but it doesnt seem to work. "Check and update database" seems to work, but when the results come up alot of things come up in red and when I try the next module I get this error

Database error in vBulletin:ImpEx Source 3.0.3:

Invalid SQL:
SELECT user_id,username
FROM users
ORDER BY user_id
LIMIT 0,25
mysql error: Table 'ferghal_forum.users' doesn't exist

mysql error number: 1146

Date: Sunday 08th of August 2004 03:01:05 PM
Script: http://forum.ferghal.com/impex/index.php

In phpBB there is a table called user but not users

[Floris]

vBulletin:ImpEx Source 3.0.3

I believe the source is the phpBB from which you want to import data from, and the target is the vBulletin forum in which you want to import the data into.

It errors because the suspected source details are from vBulletin and not phpBB. So it seems.

[Ferghal]

I understand that but the problem is I was first using vBulletin but then I was going to use it at a different site so I changed to phpBB, and vBulletin has no table prefix.
So phpBB has now no table prefix, Ive tried just using the phpBB database that was once vBulletin, posting threads and everything works but the admin panel doesnt...

[Floris]

I don't understand you.

You can not use the ImpEx system to import vBulletin into phpBB. It will only allow you to import from phpBB into vBulletin.

If that is the case, you don't have to set a table prefix, if none is setup. Just leave it empty.

[Ferghal]

It errors because the suspected source details are from vBulletin and not phpBB. So it seems.

Yes, because it was originally vBulletin, I then imported the data to phpBB and now I want to go back to vBulletin..

But it doesnt seem to work :S

[Floris]

If you want to import from phpBB into vBulletin, the same comment stands:

vBulletin:ImpEx Source 3.0.3

I believe the source is the phpBB from which you want to import data from, and the target is the vBulletin forum in which you want to import the data into.

It errors because the suspected source details are from vBulletin and not phpBB. So it seems.

[Ferghal]

So what can I do to get it back on vbulletin?

[Steve Machol]

Edit your Impex config file with the correct info.

[Ferghal]

Okay, I fdoun the problem, one of the dumbest things I have ever done. It was the wrong database it was pointing to, so thats all done but one thing.
It says it has imported everything but all that appears on the forum is Members, not the posts, threads or anything!

Have a look: http://forum.ferghal.com/index.php

[Steve Machol]

Update the user, thread and forum counters:

Admin CP -> Import & Maintenance -> Update Counters