PDA

View Full Version : phpbb 2.08 import problems (split thread)


oglsmm
Sat 1st May '04, 2:20am
Ok i did that.


Now one question

Trying to import my phpbb forum, and on step 2 I get an sql error.


Database error in vBulletin :

Invalid SQL:

SELECT title, data

FROM datastore

WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'userstats', 'birthdaycache', 'maxloggedin', 'iconcache', 'eventcache', 'mailqueue')



mysql error: Table 'REMOVED' doesn't exist

mysql error number: 1146


and


Database error in vBulletin:ImpEx Source 3.0.1:

Invalid SQL:

SELECT user_id,username

FROM users

ORDER BY user_id

LIMIT 0,25

mysql error: Table 'REMOVED' doesn't exist

mysql error number: 1146


Or at least that is what the email from Vbulletin said.

Any suugestions? Perhaps I should move this to support forum..

Zachery
Sat 1st May '04, 3:04am
Did you install vBulletin?

oglsmm
Sat 1st May '04, 9:56am
Did you install vBulletin?
lol

Yes I uploaded and installed Vbulletin, should I delete the default forums etc?

oglsmm
Sat 1st May '04, 10:26am
nvm,


I messed up the impex config file.... I didn't put the table prefix's


doh!

oglsmm
Sat 1st May '04, 10:39am
Hmmm another issue...

One the phpbb forum I have the admin account, during the install of VB I have to create an admin account as well.

So I created the amdin account using the same user name as the phpbb one. During the import I associated the phpbb admin account with the VB user ID# of the VB admin account created during install.

It seemed to work, but then it immediatly asked me to re-login to the admin section with Graphics that are very messed up and it won't take the admin acoount or password anymore.

Is it possible to keep the same admin in VB or do I have to create a default on during the install and then use that account to give the old phpbb admin account admin rights?

oglsmm

Zachery
Sat 1st May '04, 1:18pm
I think, what happened is instead of merging your old account into your new one, you merged your new account into your old one, which probaly does not have admin rights.

After the import is 100% done, you should use the merge feature of vBulletin to merge your old account into your new one so you retain Admin access, and you should create a backup admin account for good measure