Oh No! Lot's of errors IPB to SMF

[ShootMePls]

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Array to string conversion in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 8

Notice: Array to string conversion in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 8

Notice: Array to string conversion in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 8

Notice: Array to string conversion in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 8

Notice: Array to string conversion in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 8

Notice: Array to string conversion in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 8

There is soo many lines like that


as well as like:

Notice: Array to string conversion in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 8
Unsuccessful!
This query:

    INSERT INTO `ausclanc_smf`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, SUBSTRING('The price of eggs in China ?', 1, 255), 'Array', 1, 255), 'Array'),
    (1, SUBSTRING('Who is the spam king/queen ?', 1, 255), 'Array', 1, 255), 'Array'),
    (1, SUBSTRING('Why am I doing this ?', 1, 255), 'Array', 1, 255), 'Array'),
    (2, SUBSTRING('Should word association increase post count ?', 1, 255), 'Array', 1, 255), 'Array'),
    (3, SUBSTRING('What do you think of the new Look ?', 1, 255), 'Array', 1, 255), 'Array'),
    (4, SUBSTRING('Do we need it in forums ?', 1, 255), 'Array', 1, 255), 'Array'),
    (5, SUBSTRING('It's Okay', 1, 255), 'Array', 1, 255), 'Array'),
    (6, SUBSTRING('Do we keep the fade affect ?', 1, 255), 'Array', 1, 255), 'Array'

Hell... I don't know what to do!
It converted some forum categories and that was all

[ShootMePls]

There was this line don't know if it helps..

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Array'),
    (1, SUBSTRING('Who is the spam king/queen ?', 1, 255), 'Array'' at line 3

[Oldiesmann]

Ugh. I thought someone had fixed the converter on the main page by now. Give me a minute and I'll fix it for you.

[Oldiesmann]

Ok... Try this one...

[ShootMePls]

Ugh. I thought someone had fixed the converter on the main page by now. Give me a minute and I'll fix it for you.

umm....... I don't know what your talking about.... I'm new here and to SMF etc..

Ok... Try this one...

I'm new to SMF, converters and all of this.. a little more info would have been nice.
You say Try this one, Okay... so I restart the process again
Will that affect anything ?
Do I need to delete anything first ?
I have some forum categories already created by the last converter I used.. Do I leave them there ?
Im really unsure what I should do.. but because it will take a while for a response, I'll just run it as it is as see what happens.

[ShootMePls]

Parse error: syntax error, unexpected '~', expecting ')' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 24
Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:

    INSERT INTO `ausclanc_smf`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, 1, "$150", 0),
    (1, 2, "$2.50", 1),
    (1, 3, "some undisclosed amount of chinese currency", 7),
    (1, 1, "Junkie", 1),
    (1, 2, "V8_Junkie", 5),

Caused the error:

    Duplicate entry '1-1' for key 1

loads of errors.

I removed the other file that came with the one i downloaded, replaced it with the one you said to try and thats what I have ended up with

[Oldiesmann]

I'll take a look at it in a second. It shouldn't find two different choices with the same ID in the same poll...

[ShootMePls]

Great 

Do I need to PM you any details ?
I dont know whats going on but SMF never lets me login now.
Not sure if its because of doing this conversion thing or something else.
Always thinks Im using wrong password now.. but i guess can worry about that after conversion is fully successful.

[Oldiesmann]

This one will fix the "Unexpected ~" errors. I'm not sure what the problem is with the polls. If you could email me a copy of your polls table (whichever one contains the information about votes and poll options), I can take a look and see if I can figure out what's going on.

[ShootMePls]

wait a minute

I dont know what you mean.
I dont understand all this stuff...
Poll tables... right.. how do I find that ?
I really neeed full guidance with all of this, sorry but I do.

The polls is it possible because in IPB we can ask up to 20 Questions from the one poll and then have around 10-20 responses per question ?
Could that be the issue ?

[Oldiesmann]

Yes, that's probably what's causing the problem. SMF only lets you have one question per poll.

[ShootMePls]

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:

    INSERT INTO `ausclanc_smf`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, 1, "$150", 0),
    (1, 2, "$2.50", 1),

(110, 1, "Yes", 3),
    (110, 2, "No", 1),
    (111, 1, "Yes", 4),
    (111, 2, "No", 0);

Caused the error:

    Duplicate entry '1-1' for key 1

Yes, that's probably what's causing the problem. SMF only lets you have one question per poll.

what do we do about that then ?

Is there some way the convert can skip the polls  then ?
Not sure if that will mess anything up ?
Im not fussed in losing the polls, as long as everything else works and converts.

As for your other comment about the poll tabkes, I dont know how to find, obtain that

[ShootMePls]

Any suggestions ?

[Oldiesmann]

Try this one. I've added additional code to skip the option if an option with that ID already exists. That should fix the duplicate entry errors...

[ShootMePls]

Converting members...
Parse error: syntax error, unexpected '~', expecting ')' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 24


Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Parse error: syntax error, unexpected ';', expecting ']' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 29

Parse error: syntax error, unexpected ';', expecting ']' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 29

Parse error: syntax error, unexpected ';', expecting ']' in /home/ausclanc/public_html/ausarena/forums/convert.php(814) : eval()'d code on line 29


INSERT INTO `ausclanc_smf`.smf_poll_choices
(ID_POLL, choices)
VALUES ('1', 'a:3:{i:1;a:3:{s:8:\"question\";s:28:\"The price of eggs in China ?\";s:6:\"choice\";a:3:{i:1;s:9:\"$150\";i:2;s:10:\"$2.50\";i:3;s:43:\"some undisclosed amount of chinese currency\";}s:5:\"votes\";a:3:{i:1;i:0;i:2;i:1;i:3;i:7;}}i:2;a:3:{s:8:\"question\";s:28:\"Who is the spam king/queen ?\";s:6:\"choice\";a:6:{i:1;s:6:\"Junkie\";i:2;s:9:\"V8_Junkie\";i:3;s:13:\"Junkie_Master\";i:4;s:32:\"KillAor's Mate, Heath Ledger\";i:5;s:35:\"KillAor's Mate, Jonny Knoxville\";i:6;s:20:\"some ghey BF2 player\";}s:5:\"votes\";a:

Caused the error:

    Unknown column 'choices' in 'field list'

Umm I also have another Question.
Has anyone actually succeeded converting IPB to SMF ?
I have seen many many threads with errors and issues but I have never seen on where someone has succeeded.

[Oldiesmann]

A couple of minor typos... This one should work better.

And yes, many people have actually converted from IPB successfully.

[ShootMePls]

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Incomplete.
Not quite done yet!


Converting poll options... Unsuccessful!
This query:

    INSERT INTO `ausclanc_smf`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, 1, "$150", 0),

     (110, 1, "Yes", 3),
    (110, 2, "No", 1),
    (111, 1, "Yes", 4),
    (111, 2, "No", 0);

Caused the error:

    Duplicate entry '1-1' for key 1

Good then there is hope for me to get off IPB and onto SMF then bridge to Joomla. Thats great then!

[Oldiesmann]

Another typo. The array I was using to keep track of the poll choices was being reset each time through the foreach loop.

[ShootMePls]

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 ?

[EdwinK]

Another typo. The array I was using to keep track of the poll choices was being reset each time through the foreach loop.

Hi Oldies,

I've tried the sql file you attached, but I'm still keep getting errors

Converting personal messages (step 1)...
Parse error: syntax error, unexpected '~', expecting ')' in /home/dungeons/public_html/paddy/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/dungeons/public_html/paddy/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/dungeons/public_html/paddy/convert.php(814) : eval()'d code on line 24

and this goes on for some time..

Parse error: syntax error, unexpected '~', expecting ')' in /home/dungeons/public_html/paddy/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/dungeons/public_html/paddy/convert.php(814) : eval()'d code on line 24

Parse error: syntax error, unexpected '~', expecting ')' in /home/dungeons/public_html/paddy/convert.php(814) : eval()'d code on line 24
Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions...
Notice: Undefined index: start in /home/dungeons/public_html/paddy/convert.php(653) : eval()'d code on line 37
Unsuccessful!
This query:

    SELECT
    g_id AS ID_GROUP, g_title AS groupName, g_max_messages AS maxMessages,
    g_view_board AS view_stats, g_mem_info AS view_mlist,
    g_view_board AS who_view, g_use_search AS search_posts, g_email_friend AS send_topic,
    g_edit_profile AS profile_identity_own, g_post_new_topics AS post_new,
    g_reply_own_topics AS post_reply_own, g_reply_other_topics AS post_reply_any,
    g_edit_posts AS modify_own, g_delete_own_posts AS delete_own,
    g_post_polls AS poll_post, g_post_polls AS poll_add_own, g_vote_polls AS poll_vote,
    g_use_pm AS pm_read, g_use_pm AS pm_send, g_is_supmod AS moderate_forum,
    g_is_supmod AS manage_membergroups, g_is_supmod AS manage_bans,
    g_access_cp AS manage_smileys, g_access_cp AS manage_attachments,
    g_can_remove AS delete_any, g_calendar_post AS calendar_post,
    g_calendar_post AS calendar_edit_any, g_post_closed AS lock_own,
    g_edit_topic AS modify_any, g_open_close_posts AS lock_any
    FROM `dungeons_commonroom`.ibf_groups
    WHERE g_id NOT IN (1, 4, 5)
    LIMIT , 100;

Caused the error:

    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 100' at line 17

I believe we are using IBP 2.1.7 right now, but I really want to kick that one out (if I can get my co-admins to agree that is, so everything should be working 100%, or I can't convince them).

(edit: When I press 'continue', the conversion finish, so, it might not be a very important thing).

[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!

[JRSofty]

I can't seem to download your attachment because my company's proxy server is apparently blocking it. Is there a way you can zip it and re-attach so that I can download?

[rjscott]

Here's the same file zipped.