phpbb3 working on old server not new server.

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Suggested Hosts
Locked
Empeethree
Registered User
Posts: 5
Joined: Tue Mar 01, 2011 6:37 pm

phpbb3 working on old server not new server.

Post by Empeethree »

long story short. I started converting a pnphpbb to phpbb2 (thanks Dicky for pointing me in the right direction) then I went to phpbb3. this all works on my old server I am trying to move off of. The new server gives me this error.

General Error
SQL ERROR [ mysql4 ]

Unknown column 'is_dynamic' in 'where clause' [1054]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

so I tried the database update in the install directory and I get this.

Updating database to latest stable release

Database type :: mysql4
Previous version :: .0.23
Updated version :: 3.0.8

Fatal error: SQL ERROR [ mysql4 ]

Unknown column 'is_dynamic' in 'field list' [1054]

SQL

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('dbms_version', '5.0.91-log', 0)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 157
CALL: dbal_mysql->sql_query()

FILE: install/database_update.php
LINE: 227
CALL: set_config()

in /home/content/58/7520058/html/phpbb/includes/db/dbal.php on line 697


I have tried a few things I read here but I am at a loss as to what I need to do to get this working, any help is greatly appreciated.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70017
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: phpbb3 working on old server not new server.

Post by KevC »

Your phpBB3 installation is trying to read your phpBB2 database.

It doesn't work like that.

Information on how to convert from phpBB2 to phpBB3 is here.

Basically, you must have both phpBB2 and phpBB3 installed on the same server. After you have finished installing phpBB3 you will have the option to convert your phpBB2 board using the built in converter. The information it asks you for is related to the phpBB2 installation and can be found in its config.php file on the server. All of your users, posts, forums, PMs etc are converted. However, styles and MODs are not (with the exception of the birthday and attachment MODs which are supported by the converter). The phpBB2 database is not converted per se, it is merely read and converted/moved to the new phpBB3 database, so if it goes wrong your old board will not be affected at all. At the end of the conversion, once you're happy it's all working, your phpBB2 database and files can be backed up and removed if you so wish. They are not connected to the new installation in any way.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
Empeethree
Registered User
Posts: 5
Joined: Tue Mar 01, 2011 6:37 pm

Re: phpbb3 working on old server not new server.

Post by Empeethree »

thanks for the reply, I might not have made it clear in the first post.

on the old server I have already converted everything to phpbb3 & it is working ( the phpbb3 version of the forum). I am having issues transferring the phpbb3 to my new server.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70017
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: phpbb3 working on old server not new server.

Post by KevC »

Make sure you've moved the right database.

At the moment it's looking at a 2x database.
Empeethree wrote:Database type :: mysql4
Previous version :: .0.23 <----- this is phpBB2
Updated version :: 3.0.8
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
Empeethree
Registered User
Posts: 5
Joined: Tue Mar 01, 2011 6:37 pm

Re: phpbb3 working on old server not new server.

Post by Empeethree »

that was it , love it when it is the simple things.


thanks
Locked

Return to “[3.0.x] Convertors”