Oh No! Lot's of errors IPB to SMF

[EdwinK]

holy ******... look at that... it was successful and worked.
Was one error but it went fast and  I didn thave time to see it... was something about private messages.

Wow!

I'm relieved Thank You so much for your time in helping me like this.
I will have to look through it all as I assume there will be issues still that need solving but its getting there 

Problem though with passwords... I cannot login using my IPB password or any password I used for SMF
I assume this needs sorting somehow and will affect others as well ?
What do I do about this please ?

That seems to be a problem with the conversion from Invision to SMF. You can try and retrieve your password through the 'forgotten password' link. It's just a one time thing that everyone on your board needs to do, unfortunatly.

[Oldiesmann]

Sorry for the delayed response... Just now saw this.

Found a couple more typos in the file. This one should work better.

EDIT: Found another bug - images weren't getting converted properly in some cases.

Also added code to convert <img src="style_emoticons/<#EMO_DIR#>/emoticon.gif" style="vertical-align:middle" emoid="emoticoncode" ... />

[rjscott]

Sorry for the delayed response... Just now saw this.

Found a couple more typos in the file. This one should work better.

EDIT: Found another bug - images weren't getting converted properly in some cases.

Also added code to convert <img src="style_emoticons/<#EMO_DIR#>/emoticon.gif" style="vertical-align:middle" emoid="emoticoncode" ... />

Hey, that thing worked WAY better than the invision2_to_smf.sql file. Fixed 100% of the reported conversion errors and lots of errors that weren't reported. Now I have a couple of questions:
Wait.... Here's some information-
IPB Version     v2.1.7
SQL Version    MYSQL (4.1.20)
PHP Version    5.0.4 (apache2handler)

Ok on to the questions-
1. Why does this-- Dave: "I've told you a million times, don't exaggerate!" whob1sob1 (formatting removed) look like this in IPB, but in SMF it looks like this--

Code Select Expand

[!--fonto:Georgia--][span style=\"font-family:Georgia\"][!--/fonto--][!--sizeo:2--][span style=\"font-size:10pt;line-height:100%\"][!--/sizeo--]Dave: "I've told you a million times, don't exaggerate!"
[!--sizec--][/span][!--/sizec--]
[!--sizeo:1--][span style=\"font-size:8pt;line-height:100%\"][!--/sizeo--]whob1sob1[!--sizec--][/span][!--/sizec--][!--fontc--][/span][!--/fontc--]


2. Does something look fishy here:

Code Select Expand

[!--quoteo(post=27814:date=Dec 20 2006, 09:12 AM:name=JohnZ)--][div class=\'quotetop\']QUOTE(JohnZ @ Dec 20 2006, 09:12 AM) [snapback]27814[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Don't let the aged look fool you - according to his profile he's only one  year old!
[/quote]

3. And what's the deal with the

Code Select Expand

\" action here:

Code Select Expand

[a href=\"http://www.flickr.com/photos/unchartedwaters/\" target=\"_blank\"]fotos![/a]

So, have I missed something obvious in the admin panel? Do I need to install a mod? Am I a dork newbie that should crawl back under my rock?

[Oldiesmann]

IPB has a really weird system for parsing bbcode. Instead of parsing it when it's displayed like SMF does, they parse it before inserting the contents into the database, surrounding the appropriate HTML with special comments to indicate where the bbcode tags should go. Unfortunately, it's difficult to convert this stuff, although we're working on it. When SMF gets done converting the bbcode, it replaces any remaining < and > symbols with the appropriate brackets to ensure that the remaning HTML doesn't mess up the formatting of the post. I'm not sure why the quotes got escaped though.

We are trying hard to fix the bbcode parsing, but every time we try to fix it, someone comes along with a slightly different configuration and we have to add a bunch more code to fix it. I'll take a look at it in a little while and see if I can fix it. Unfortunately, I'm not an expert at regular expressions, so I can't guarantee that I can fix it.

[rjscott]

Thank you. I appreciate the work. Hopefully we can get to work so I can switch over to SMF soon.

[Oldiesmann]

Ok. Try this one. I made quite a few changes that should make things work better.

[rjscott]

Okay will do. I'll report back as soon as I run it again.

[rjscott]

Ok. Try this one. I made quite a few changes that should make things work better.

I just tried it and it pooped out here:

Code Select Expand

http://foo.goo/convert.php?step=1&substep=35&start=500
Just a white page and the status bar says Done... 
Matter of fact, the whole Joomla site is now blank.

[rjscott]

UPDATE: I wiped the settings.php and restored from a backup. I then ran the convert.php using the new 2.1 sql file and now the quoted replies are working!
Next on the list-
1. The signatures that (presumably) were affected by the odd IPB parsing are not working yet.
2. It seems that the image file path for the avatars is mismatched and the file names are being pureed and tossed into the *wrong* folder- /attachments but right clicking on the missing image icon in IE and looking at the properties shows the image path to be /avatars.
This is what the typical file name looks like before and after conversion-
Oh wait a minute.... it's more complicated than that. Looks like maybe the personal image and the avatars are also getting mashed around. . .
Let me just show an example of what the file names look like-
239_bazooka_bert_jpgd95cbea480917439969e0154b246b01f
This should be bazooka bert.jpg

That's all for now. Thanks again.

[Oldiesmann]

SMF encrypts the filenames for security reasons (prevents hotlinking, prevents problems caused by two or more users uploading a file with the same name, etc.), so that's normal.

To fix the issue with avatars:
Admin -> Attachments and Avatars -> Avatar Settings
Set "Upload avatars to" to "Attachments directory".

[rjscott]

SMF encrypts the filenames for security reasons (prevents hotlinking, prevents problems caused by two or more users uploading a file with the same name, etc.), so that's normal.

To fix the issue with avatars:
Admin -> Attachments and Avatars -> Avatar Settings
Set "Upload avatars to" to "Attachments directory".

Hi- I checked and it was already set to upload to the Attachments directory. My quick fix was to load all of the avatars from the current IPB forum into the avatar directory on my SMF forum. This worked but the image sizes are not being controlled by the settings in the Avatar Settings panel. Any ideas?

[rjscott]

UPDATE:
So I was able to get a successful install of SMF/Joomla!. Successful isn't mean to imply that everything works completely or works as expected though. Overall, I'm very happy so far and would like to get the rest of the issues worked out so I can flip the switch off for IPB.
Without further adieux here is the current list of questions/issues:
1. Messages/Inbox/PM's
Shows that user has messages but there is no way to see them unless you do a search. Even then, you can't get them to show up in the inbox.

2. Signature code from IPB not importing correctly. Example:

Code Select Expand


[!--coloro:#000000--][span style=\"color:#000000\"][!--/coloro--]RJ Scott
CV Charter Member
Mellophone 1998- ...
Board of Directors :: Webmaster
| 404.xxx.xxxx | AIM: xxxxxxxx | YIM: xxxxxxxx[/color]
[!--coloro:#000000--][span style=\"color:#000000\"][!--/coloro--]Atlanta CorpsVets plays the best:[/i] Dynasty© | REMO© | Pro-Mark©[/color]
[!--coloro:#333333--][span style=\"color:#333333\"][!--/coloro--]"We are what we repeatedly do. Excellence, therefore, is not an act but a habit." --Aristotle
"thats right, or its a slipper up the @ss" --Dave Henry[/color]

3. Avatars still not working. I need to take another look at your suggestion for fixing that.

4. VirtueMart/Joomla!/SMF
I'm in the beginning stages of figuring this one out but the basics are simple- When using VM, the Joomla! user manager isn't used. Only the VM user manager is used. This presents issues with the bridge because the extra user data doesn't seem to match up.

With that said, it may be an issue with a persons username in the original IPB forum not being identical to their username in Joomla!/VM. I'm wondering if it would be possible for the bridge to have a method for matching up usernames. Something like a list of forum un's on one side and a list of J!/VM un's on the other. Then you could manually match up the ones that aren't done automatically. I hope I'm making some sort of sense... 

There are some other issues with VM and its user tables but I'll get to them after I figure this other stuff out.
Thanks for all of the help!

[rjscott]

Another quick issue- When I log into the web site I can no longer get to the smf admin panel. When I click the admin tab I am asked to enter my password and this is the response message I receive:
An Error Has Occurred!
Session verification failed. Please try logging out and back in again, and then try again.

I've tried doing what it says to no avail. Ideas?

[rjscott]

UPDATE: It seems that I'm only getting the session error when the forum is wrapped in Joomla!. When I go directly to the forum without being wrapped, I do not have any session errors.


Another quick issue- When I log into the web site I can no longer get to the smf admin panel. When I click the admin tab I am asked to enter my password and this is the response message I receive:
An Error Has Occurred!
Session verification failed. Please try logging out and back in again, and then try again.

I've tried doing what it says to no avail. Ideas? Also, clicking on the logout tab in the forum results in the same message. I have to log out using the logout button on the web site.

[DHC]

I had the same problems with the poll conversion NOT working well - but there were so few polls (3 total) I thought it would be simple just to truncate that data from the table.

Now I receive THESE errors:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Unsuccessful!
This query:

    INSERT INTO `onlined1_forum`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('', '4'),
    ('', '11'),
    ('', '22'),
    ('', '1'),
    ('', '34'),
    ('', '9'),
    ('', '7'),
    ('', '48'),
    ('', '36'),
    ('', '12'),
    ('', '18'),
    ('', '24'),
    ('', '30'),
    ('', '33'),
    ('', '7');

Caused the error:

    Duplicate entry '0-7-0' for key 1
********************************

Can someone please help?

[Orb!ter]

Hi,

Your entire query has a duplicated primary key. If you go into your administration area for your MySQL database, simply run this query for your database:

INSERT INTO `onlined1_forum`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('', '4'),
    ('', '11'),
    ('', '22'),
    ('', '1'),
    ('', '34'),
    ('', '9'),
    ('', '7'),
    ('', '48'),
    ('', '36'),
    ('', '12'),
    ('', '18'),
    ('', '24'),
    ('', '30'),
    ('', '33');

I noticed when converting my board, many of these 'logs' came up. Ideally they aren't that important, so you could simply skip the step by manipulating the URL. There will be a step? parameter in the URL, when you click 'Try Again', simply add 1 to the current step value. Should from memory be 15.

Thanks,
Orb!ter

[DHC]

Hi,

Your entire query has a duplicated primary key. If you go into your administration area for your MySQL database, simply run this query for your database:

INSERT INTO `onlined1_forum`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('', '4'),
    ('', '11'),
    ('', '22'),
    ('', '1'),
    ('', '34'),
    ('', '9'),
    ('', '7'),
    ('', '48'),
    ('', '36'),
    ('', '12'),
    ('', '18'),
    ('', '24'),
    ('', '30'),
    ('', '33');

I noticed when converting my board, many of these 'logs' came up. Ideally they aren't that important, so you could simply skip the step by manipulating the URL. There will be a step? parameter in the URL, when you click 'Try Again', simply add 1 to the current step value. Should from memory be 15.

Thanks,
Orb!ter

I am sorry, but I do not understand your reply.

Please help (with detailed instructions for a NEWBIE)

[Oldiesmann]

The issues with PMs and the color tag were due to typos (a missing ")" in the pattern for the color tag was causing it to not get converted, and the PM issue was due to setting the "label" to an empty string instead of 0).

The poll issue is because you didn't clear out the voters table, although it's also due to the annoying functionality of MySQL's "LEFT JOIN" statement (see http://www.tizag.com/mysqlTutorial/mysqlleftjoin.php for a good explanation).

Try the attached file with convert.php after you clear out the "voters" table in IPB.

[DHC]

The issues with PMs and the color tag were due to typos (a missing ")" in the pattern for the color tag was causing it to not get converted, and the PM issue was due to setting the "label" to an empty string instead of 0).

The poll issue is because you didn't clear out the voters table, although it's also due to the annoying functionality of MySQL's "LEFT JOIN" statement (see http://www.tizag.com/mysqlTutorial/mysqlleftjoin.php for a good explanation).

Try the attached file with convert.php after you clear out the "voters" table in IPB.

Does "convert.php" require ANY modification to use the revised .sql file?

[DHC]

Nevermind - I simply changed the filename to match the original .sql filename - ran the conver.php file - AND IT WORKED!

Thanks!