Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: ComunidadNokia on March 04, 2014, 12:15:57 PM

Title: Error in conversion phpbb3 to smf
Post by: ComunidadNokia on March 04, 2014, 12:15:57 PM
Hi,

I am trying to convert my forum from phpbb3 to smf, but it is imposible:


Converting...
Converting members...

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/data_f87c4bcabd98a9a06b5cf781528d1786-SMF-db_last_error.php) is not within the allowed path(s): (C:/Inetpub/vhosts/comunidadnokia.net\;C:\Windows\Temp\) in C:\Inetpub\vhosts\comunidadnokia.net\httpdocs\foro\Sources\Load.php on line 2707
Duplicate entry '4206' for key 'PRIMARY'


I cannot continue from here.

Could anyone help me?

Thanks!!
Title: Re: Error in conversion phpbb3 to smf
Post by: margarett on March 04, 2014, 12:22:40 PM
You shouldn't have duplicate ids in member tables... It is possible to ignore that error but I think you will have other problems later...

You should analyze your original phpBB members table and search for that duplicate register, if existent.
Title: Re: Error in conversion phpbb3 to smf
Post by: ComunidadNokia on March 04, 2014, 12:51:30 PM
Quote from: margarett on March 04, 2014, 12:22:40 PM
You shouldn't have duplicate ids in member tables... It is possible to ignore that error but I think you will have other problems later...

You should analyze your original phpBB members table and search for that duplicate register, if existent.

Thanks for answering!

I have revised the table phpbb_users, but there is any duplicate ids  :-[
Title: Re: Error in conversion phpbb3 to smf
Post by: margarett on March 04, 2014, 01:24:13 PM
Are you using the converter from this page here:
http://download.simplemachines.org/?converters;software=phpbb
?
Title: Re: Error in conversion phpbb3 to smf
Post by: ComunidadNokia on March 04, 2014, 01:33:03 PM
Yes, this one: http://download.simplemachines.org/index.php?thanks;filename=smf_2-0_phpbb3_converter.zip
Title: Re: Error in conversion phpbb3 to smf
Post by: margarett on March 04, 2014, 01:43:31 PM
Well, try this.

Edit phpbb3_to_smf.sql, find this:

---* {$to_prefix}members
---{

And add after
$ignore = true;

When I converted from phpBB (several years ago) I eliminated all the duplicate entries from the SQL dump itself. I got a lot of those errors at that time, honestly... Let's hope yours can be bypassed by ignoring the duplicate entries ;)
Title: Re: Error in conversion phpbb3 to smf
Post by: ComunidadNokia on March 04, 2014, 02:43:38 PM
It worked!!!

:)

THANKS!!
Title: Re: Error in conversion phpbb3 to smf
Post by: margarett on March 04, 2014, 03:04:12 PM
Welcome to SMF ;)