Bugs in PHPBB to SMF convert sql for SMF 1.1

[bazzix]

There are bugs in the Substring declarations for the members AIM MSN and email, and also in the personal messages: fromName

I'd attach the working sql but noticed that file uploading is not possible, anyways I did a diff so you can see the difference:

-bash-2.05b$ diff phpbb2_to_smf.sql phpbb2_to_smf.sql-original.sql
133c133
<       SUBSTRING(u.user_email, 1, 255) AS emailAddress,
---
>       SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
135,136c135,136
<       SUBSTRING(u.user_msnm, 1, 255) AS MSN,
<       SUBSTRING(u.user_aim, 1, 16) AS AIM,
---
>       SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
>       SUBSTRING(u.user_aim AS AIM, 1, 16) AS AIM,
367c367
<       SUBSTRING(uf.username, 1, 255) AS fromName,
---
>       SUBSTRING(uf.username AS fromName, 1, 255) AS fromName,
968c968
< ---#
---
> ---#

sorry if i put this in the wrong place.

greetings

[Oldiesmann]

This is a known issue, although I don't know why nobody has uploaded the fixed version of the converter file...

Try the attached one. If you run into any more problems, check out http://www.simplemachines.org/community/index.php?topic=107868.0 - chances are there's a fix posted in that topic (but also let me know so I can fix it in my copy and notify the appropriate people to fix it as well).

EDIT: Uploaded the wrong file...

[bazzix]

Hi oldiesmann, I fixed it by correcting those errors I mentioned earlier.
Thanks