Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: gusdrummer on January 03, 2005, 04:26:45 PM

Title: phpBB2 attachement
Post by: gusdrummer on January 03, 2005, 04:26:45 PM
Hello...

Just a little problem with the new converter...
I have 322 files on my phpBB 2.0.4 forum...
I know the converter is for > 2.0.7... but nearly everything's ok with a 2.0.4...
File copying to the attachements dir is ok...
My problem is on the INSERT query...
Once the convertion done, I only have ID_ATTACH from 101 to 200 and from 301 to 322 in my database...!!
ID_ATTACH from 1 to 100 and from 201 to 300 are missing...

Any idea...??

Thanks in advance... and keep up the good work...!!

Gus
Title: Re: phpBB2 attachement
Post by: [Unknown] on January 04, 2005, 01:46:20 AM
Interesting.  Can you try the attached converter?

It should give you an error message if anything goes wrong.

Thanks,
-[Unknown]
Title: Re: phpBB2 attachement
Post by: gusdrummer on January 04, 2005, 03:39:03 AM
Here's an error :

Converting attachments... You have an error in your SQL syntax near 'RAOK...pdf', 58), (14, 174674, 9, 'ABJAKEZ.pdf', 58), (15, 80724, 6, '' at line 17

Probably because file number 13 contains a ' ...
Should be the same for files from 201 to 300...!!

thanks again in advance for your help...

Title: Re: phpBB2 attachement
Post by: [Unknown] on January 04, 2005, 03:44:03 AM
This one, then?

-[Unknown]
Title: Re: phpBB2 attachement
Post by: gusdrummer on January 04, 2005, 03:52:52 AM
Perfect...!!
Thanks very much...

:) ;) :D