Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Import PHP.BB Failure
Avatar
Phil Lockwood
Member
Free Members
sp_UserOfflineSmall Offline
Feb 22, 2012 - 10:22 am

Hi,

I'm trying to import a PHP.BB database into my Simple:Press 5 installation and even though I've used the correct database name, user name and password I'm getting the following error -

ErrorImage Enlarger

The PHP.BB database was originally a PHP.BB 2 that was upgarded to 3.

 

Could it be be because even though both installations are on the same server, (thus local host), they are currently on different domains and if so, will editing the old database domain and replacing it with the new one then importing the edited one to a new database of the server work or is it a problem as the database is an old version that's been converted.

 

Regards,

 

Phil

Image Enlarger

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 22, 2012 - 11:20 am

The domain wont matter at all. It is just access to the database itself.

The users table is the first thing it looks for and it uses that as a test of all of the db settings to see if can access the db. The name of the table in a phpBB system should be 'users' so in your settings there it will be looking for table name of 'phpbb_users'. Does that exist?

I am unsure oif the upgrade procedure within phpBB but i believe most users who have used the importer have been largely on the most up to date version.

So - what about the other db setings? Are they 100% correct?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Phil Lockwood
Member
Free Members
sp_UserOfflineSmall Offline
Feb 22, 2012 - 12:03 pm

Thanks for the quick reply Yellow Swordfish.

Yep, all the other database settings, (database name, user name and password), are 100% correct, (I copied and pasted them from the config file of the current installation), with the error message changing now and saying "Unable to query FORUMS using the db settings supplied".

When you update from PHP.BB2 to PHP.BB3 the database is converted from PHP.BB2 to PHP.BB3 format I understand, but you have to leave the PHP.BB2 files as a source although I don't understand the full process.

I can see me being bald by the end of the night, ripping my hair out in frustration here 🙂

Any suggestions please ?

Phil

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 22, 2012 - 12:17 pm

Ok this is probably a a daft question but you ARE putting the phpbb settings in there and not the Wp ones I assume?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Phil Lockwood
Member
Free Members
sp_UserOfflineSmall Offline
Feb 22, 2012 - 12:26 pm

Yep, I'm copying the DB settings from the PHP.BB config file, the original PHP.BB instalation is still live in another folder on the same server as the WP instalation.

Phil

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 22, 2012 - 12:46 pm

Not sure what I can suggest to be honest.
Does anyone else have any ideas?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Phil Lockwood
Member
Free Members
sp_UserOfflineSmall Offline
Feb 23, 2012 - 4:19 am

Thanks for your help Yellow Swordfish, I've found what the problem is.

 

For anybody else having a similar problem, when you upgrade PHP.BB from version 2 to version 3 it creates a second database and install of PHP.BB in another folder of your root domain and to import you have to use the database details from the config file of this second installation

 

Best wishes,

 

Phil

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 23, 2012 - 4:59 am

Wow - thanks for that information. I didn't know that. What a very strange method to adopt.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625