Print Page - Converting from phpBB 3.0.11 to SMF 2.0.5

Title: Converting from phpBB 3.0.11 to SMF 2.0.5 - Error During Conversion Process
Post by: PiGuy on August 19, 2013, 12:51:31 AM

Hi,

I've encountered several errors whilst trying to convert my phpBB forum to SMF.

The first error I encountered was with Ranks, but that was solved by removing all custom ranks.

Now, it's giving an error when converting groups:

Code Select

Converting...
Converting ranks... Successful.
Converting groups...Field 'description' doesn't have a default value

I've tried changing the field type and adding a default to description, but that doesn't seem to work.

Any suggestions?

Title: Re: Converting from phpBB 3.0.11 to SMF 2.0.5 - Error During Conversion Process
Post by: Oldiesmann on October 29, 2013, 04:27:31 PM

In the phpbb3_to_smf.sql file...

Find

Code Select

-1 AS min_posts, '' AS stars, group_colour AS online_color

Replace

Code Select

-1 AS min_posts, '' AS stars, group_colour AS online_color, '' AS description

That should fix that problem.

Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: PiGuy on August 19, 2013, 12:51:31 AM