News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

IPB 2.1.3

Started by daveb47, November 27, 2005, 12:54:19 PM

Previous topic - Next topic

Monteiro

The future of my community relies on you ;)

Oldiesmann

Make sure you're using the right convert.php for the version of SMF you're converting to. The one in the 1.1 Converters topic only works with 1.1RC1. If you're converting to 1.1RC2, you'll need the one here. That's the last part of the converter anyway, so I guess everything else went smoothly? If so, I'll add this converter to the collection in the 1.1 converters topic.
Michael Eshom
Christian Metal Fans

Monteiro

I'll convert my database tonight. As soon as it's done I'll post the results.

Thanks for your work, Oldies! "I think missa loves you" ;)

daveb47

Thanx Oldiesman,That was certainly a major part of my problems.

Now it hanging on converting statistics,Left it on it overnight & it was still on stats this morning.

Most of board has converted tho.

Main probs now are Signatures which are showing on board as

[img src=\"http://www.*********.co.uk/digital-pics/3659IRedGW-thumb.gif\" border=\"0\" alt=\"\" /]
[img src=\"http://www.********.pwp.blueyonder.co.uk/alloneword3.gif\" border=\"0\" alt=\"\" /]
[!--coloro:blue--][span style=\"color:blue\"][!--/coloro--]May The Force Be With You.[!--colorc--][/span][!--/colorc--]
[!--coloro:red--][span style=\"color:red\"][!--/coloro--]The only thing in life that is guaranteed is that both you & I will die one day.[!--colorc--][/span][!--/colorc--]


& smillies which are showing as

Okey dokey dave thanx for keeping us informed hun  [img src=\"style_emoticons/[#EMO_DIR#]/thumbsup.gif\" style=\"vertical-align:middle\" emoid=\":thumbsup:\" border=\"0\" alt=\"thumbsup.gif\" /]

I can redo smilies but this will not make existing ones in posts show up.
Many thanx for all your hard work m8.
Dave
.


https://daveb47.co.uk

A Slinky is like Jeremy CorbynWinehouse,Weird looking,Not really of any use to anybody.
But its really funny when it falls down the stairs!!:D:D

Oldiesmann

I'll take care of that in a little while.
Michael Eshom
Christian Metal Fans

Oldiesmann

#45
Ok... Fixed those issues as well as a few other bbcode-related issues. Try the attached file.
Michael Eshom
Christian Metal Fans

daveb47

#46
Now that is strange,Now getting this on Converting posts,For every post by the look of it

Parse error: parse error, unexpected '~', expecting ')' in /home/goldus/public_html/essexfm4/index/convert.php(814) : eval()'d code on line 19

Parse error: parse error, unexpected '~', expecting ')' in /home/goldus/public_html/essexfm4/index/convert.php(814) : eval()'d code on line 19

Parse error: parse error, unexpected '~', expecting ')' in /home/goldus/public_html/essexfm4/index/convert.php(814) : eval()'d code on line 19


Still hanging on Statistics,Wont go any further.
https://daveb47.co.uk

A Slinky is like Jeremy CorbynWinehouse,Weird looking,Not really of any use to anybody.
But its really funny when it falls down the stairs!!:D:D

Oldiesmann

#47
That has something to do with the new code I added for bbcode-related stuff, but unfortunately I can't find any place that's missing a ), although I did find a couple of missing tildes in there, so maybe that had something to do with it. Try this one...
Michael Eshom
Christian Metal Fans

daveb47

Betyou wish you had never started with this one!!! ;D ;D ;D

Still getting same errors tho m8.
https://daveb47.co.uk

A Slinky is like Jeremy CorbynWinehouse,Weird looking,Not really of any use to anybody.
But its really funny when it falls down the stairs!!:D:D

Oldiesmann

Ok. I'll look at it more closely and see what I can find.
Michael Eshom
Christian Metal Fans

daveb47

Thanx m8,Much appreciated.
Any chance you can attach correct convert.php just to make double sure that i am using right one.
https://daveb47.co.uk

A Slinky is like Jeremy CorbynWinehouse,Weird looking,Not really of any use to anybody.
But its really funny when it falls down the stairs!!:D:D

Oldiesmann

#51
Ok... After careful investigation, I found the issue - I had an extra ' after one line, so it thought I was ending the array and therefore was looking for a ) and not a ~... Anyway, new file is attached.

The convert.php you need is the one in this topic
Michael Eshom
Christian Metal Fans

daveb47

Was using correct converter.php,But getting this now.

Converting...
Converting topics... Successful.
Converting posts (this may take some time)...
Parse error: parse error, unexpected '[', expecting ')' in /home/goldus/public_html/essexfm4/index/convert.php(814) : eval()'d code on line 38

Parse error: parse error, unexpected '[', expecting ')' in /home/goldus/public_html/essexfm4/index/convert.php(814) : eval()'d code on line 38

Parse error: parse error, unexpected '[', expecting ')' in /home/goldus/public_html/essexfm4/index/convert.php(814) : eval()'d code on line 38


Does this all the way thru converting posts.

Then goes to this
Converting...
Recalculating forum statistics... Incomplete.
Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.

& sticks on this page.
http://essexfm4.me.uk/index/convert.php?step=2&substep=10&start=0
https://daveb47.co.uk

A Slinky is like Jeremy CorbynWinehouse,Weird looking,Not really of any use to anybody.
But its really funny when it falls down the stairs!!:D:D

Monteiro

#53
Hi Oldies. I've ran into the same problems and tryed looking into your code to see what those errors was about and found a few array items without the trailing quote (') and/or coma (,) (in different combinations). Take a look and you'll find them. After fixing that, everything was fine, except for the fact that I got an error message wich I wasn't able to see what was about. Tomorrow I'll try to reconvert my db and post about it.

Update: I'm navigating on my just-converted-SMF-from-IPB board and noticed that the smileys got messed up showing like:
Quote[img]style_emoticons/[#EMO_DIR#]/cry.gif\" style=\"vertical-align:middle\" emoid=\":choro:\" border=\"0\" alt=\"cry.gif\" /]

Guess we're getting there.

Monteiro

Maybe the smileys problem should stay for latter. Here a major problem for now:

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Use of undefined constant ID_POLL - assumed 'ID_POLL' in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 11

Notice: Undefined index: 1 in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 11

Notice: Use of undefined constant ID_POLL - assumed 'ID_POLL' in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 17

Warning: Invalid argument supplied for foreach() in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 17

Notice: Use of undefined constant ID_POLL - assumed 'ID_POLL' in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 11

Notice: Undefined index: 2 in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 11

Notice: Use of undefined constant ID_POLL - assumed 'ID_POLL' in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 17

Warning: Invalid argument supplied for foreach() in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 17

Notice: Use of undefined constant ID_POLL - assumed 'ID_POLL' in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 11

Notice: Undefined index: 3 in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 11

Notice: Use of undefined constant ID_POLL - assumed 'ID_POLL' in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 17


This go until "Undefined index 516" and then that:

Notice: Undefined index: 516 in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 11

Notice: Use of undefined constant ID_POLL - assumed 'ID_POLL' in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 17

Warning: Invalid argument supplied for foreach() in D:\WEB_APPS\public_html\smf\convert.php(814) : eval()'d code on line 17
Successful.
Converting poll logs... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('121', '487'),
    ('123', '487'),
    ('122', '487'),
    ('123', '606'),
    ('118', '654'),
    ('121', '59'),
    ('123', '654'),
    ('122', '59'),
    ('122', '529'),
    ('122', '724'),
    ('123', '525'),
    ('118', '141'),
    ('118', '577'),
    ('123', '93'),
    ('123', '673'),
    ('123', '382'),
    ('118', '762'),
    ('123', '553'),
    ('123', '59'),
    ('101', '631'),
    ('118', '412'),
    ('118', '691'),
    ('101', '766'),
    ('113', '766'),
    ('112', '766'),
    ('107', '766'),
    ('113', '464'),
    ('113', '368'),
    ('118', '472'),
    ('113', '724'),
    ('113', '59'),
    ('122', '766'),
    ('120', '766'),
    ('124', '766'),
    ('32', '766'),
    ('117', '232'),
    ('124', '482'),
    ('124', '724'),
    ('32', '724'),
    ('99', '761'),
    ('112', '724'),
    ('118', '689'),
    ('118', '357'),
    ('118', '769'),
    ('124', '412'),
    ('124', '282'),
    ('124', '464'),
    ('124', '721'),
    ('123', '645'),
    ('32', '457'),
    ('113', '457'),
    ('112', '499'),
    ('121', '769'),
    ('119', '740'),
    ('121', '773'),
    ('113', '631'),
    ('67', '744'),
    ('121', '721'),
    ('81', '362'),
    ('81', '561'),
    ('32', '721'),
    ('124', '368'),
    ('124', '115'),
    ('124', '217'),
    ('124', '445'),
    ('81', '551'),
    ('119', '551'),
    ('119', '631'),
    ('113', '525'),
    ('112', '457'),
    ('121', '657'),
    ('121', '673'),
    ('121', '631'),
    ('121', '548'),
    ('92', '781'),
    ('121', '732'),
    ('121', '325'),
    ('121', '612'),
    ('121', '477'),
    ('121', '368'),
    ('120', '496'),
    ('120', '464'),
    ('119', '26'),
    ('121', '376'),
    ('118', '672'),
    ('118', '781'),
    ('113', '499'),
    ('113', '313'),
    ('120', '472'),
    ('92', '756'),
    ('113', '721'),
    ('81', '628'),
    ('118', '766'),
    ('81', '766'),
    ('118', '232'),
    ('81', '657'),
    ('118', '657'),
    ('125', '482'),
    ('125', '744'),
    ('125', '412'),
    ('67', '766'),
    ('115', '766'),
    ('39', '766'),
    ('125', '766'),
    ('105', '766'),
    ('114', '766'),
    ('114', '744'),
    ('126', '186'),
    ('126', '564'),
    ('125', '457'),
    ('125', '54'),
    ('125', '724'),
    ('105', '724'),
    ('125', '489'),
    ('125', '654'),
    ('125', '782'),
    ('105', '430'),
    ('125', '447'),
    ('105', '457'),
    ('105', '628'),
    ('125', '606'),
    ('105', '35'),
    ('125', '232'),
    ('105', '486'),
    ('105', '736'),
    ('126', '232'),
    ('125', '645'),
    ('125', '331'),
    ('125', '729'),
    ('125', '631'),
    ('125', '59'),
    ('109', '766'),
    ('114', '64'),
    ('106', '766'),
    ('124', '239'),
    ('106', '721'),
    ('124', '564'),
    ('126', '721'),
    ('106', '376'),
    ('126', '376'),
    ('126', '464'),
    ('125', '24'),
    ('114', '484'),
    ('114', '673'),
    ('115', '376'),
    ('115', '697'),
    ('127', '376'),
    ('127', '487'),
    ('127', '457'),
    ('127', '529'),
    ('127', '186'),
    ('125', '798'),
    ('105', '798'),
    ('127', '766'),
    ('109', '678'),
    ('121', '265'),
    ('92', '265'),
    ('127', '606'),
    ('127', '42'),
    ('127', '727'),
    ('114', '658'),
    ('114', '464'),
    ('109', '712'),
    ('114', '265'),
    ('109', '658'),
    ('109', '807'),
    ('128', '1'),
    ('121', '686'),
    ('128', '12'),
    ('128', '313'),
    ('128', '464'),
    ('105', '545'),
    ('128', '658'),
    ('128', '200'),
    ('128', '141'),
    ('128', '61'),
    ('106', '810'),
    ('128', '54'),
    ('129', '54'),
    ('128', '357'),
    ('128', '714'),
    ('129', '63'),
    ('129', '464'),
    ('129', '1'),
    ('109', '495'),
    ('109', '457'),
    ('129', '673'),
    ('106', '657'),
    ('106', '732'),
    ('109', '732'),
    ('124', '529'),
    ('124', '2'),
    ('128', '239'),
    ('129', '561'),
    ('129', '631'),
    ('124', '331'),
    ('109', '657'),
    ('128', '727'),
    ('128', '153'),
    ('106', '813'),
    ('109', '794'),
    ('105', '445'),
    ('106', '631'),
    ('128', '183'),
    ('128', '186'),
    ('128', '35'),
    ('106', '411'),
    ('129', '265'),
    ('105', '495'),
    ('125', '509'),
    ('125', '509'),
    ('125', '64'),
    ('125', '529'),
    ('109', '506'),
    ('109', '561'),
    ('109', '412'),
    ('109', '376'),
    ('128', '412'),
    ('125', '658'),
    ('125', '217'),
    ('125', '624'),
    ('125', '464'),
    ('109', '227'),
    ('128', '766'),
    ('125', '732'),
    ('106', '106'),
    ('109', '106'),
    ('125', '698'),
    ('125', '499'),
    ('125', '551'),
    ('106', '551'),
    ('109', '551'),
    ('106', '119'),
    ('114', '165'),
    ('114', '817'),
    ('114', '1'),
    ('114', '774'),
    ('114', '412'),
    ('114', '313'),
    ('114', '851'),
    ('125', '773'),
    ('109', '773'),
    ('125', '453'),
    ('123', '847'),
    ('128', '2'),
    ('128', '418'),
    ('132', '773'),
    ('128', '882'),
    ('128', '732'),
    ('128', '899'),
    ('132', '529'),
    ('131', '899'),
    ('131', '376'),
    ('131', '73'),
    ('125', '73'),
    ('131', '849'),
    ('113', '736'),
    ('131', '774'),
    ('131', '232'),
    ('131', '817'),
    ('131', '509'),
    ('131', '922'),
    ('131', '732'),
    ('131', '631'),
    ('125', '851'),
    ('113', '851'),
    ('125', '931'),
    ('130', '924'),
    ('131', '828'),
    ('126', '766'),
    ('130', '200'),
    ('131', '766'),
    ('131', '529'),
    ('130', '807'),
    ('126', '932'),
    ('130', '584'),
    ('131', '322'),
    ('131', '471'),
    ('114', '879'),
    ('131', '200'),
    ('114', '486'),
    ('114', '736'),
    ('114', '933'),
    ('114', '890'),
    ('130', '413'),
    ('125', '584'),
    ('131', '944'),
    ('121', '946'),
    ('131', '851'),
    ('106', '944'),
    ('118', '742'),
    ('121', '545'),
    ('114', '545'),
    ('114', '849'),
    ('121', '746'),
    ('121', '962'),
    ('127', '486'),
    ('118', '486'),
    ('118', '297'),
    ('118', '931'),
    ('118', '773'),
    ('127', '732'),
    ('131', '852'),
    ('81', '946'),
    ('131', '742'),
    ('118', '933'),
    ('127', '933'),
    ('118', '866'),
    ('118', '890'),
    ('118', '758'),
    ('118', '561'),
    ('118', '962'),
    ('118', '746'),
    ('118', '984'),
    ('133', '153'),
    ('133', '445'),
    ('121', '985'),
    ('121', '866'),
    ('127', '721'),
    ('133', '849'),
    ('121', '849'),
    ('133', '933'),
    ('121', '933'),
    ('133', '624'),
    ('127', '357'),
    ('121', '882'),
    ('133', '457'),
    ('134', '2'),
    ('92', '137'),
    ('118', '997'),
    ('121', '994'),
    ('135', '994'),
    ('135', '766'),
    ('121', '766'),
    ('121', '526'),
    ('118', '5'),
    ('121', '944'),
    ('133', '529'),
    ('133', '905'),
    ('118', '994'),
    ('133', '994'),
    ('133', '532'),
    ('136', '994'),
    ('136', '773'),
    ('135', '773'),
    ('121', '239'),
    ('136', '59'),
    ('136', '1000'),
    ('136', '624'),
    ('136', '866'),
    ('127', '866'),
    ('133', '297'),
    ('133', '766'),
    ('135', '744'),
    ('136', '382'),
    ('136', '458'),
    ('121', '997'),
    ('136', '997'),
    ('136', '746'),
    ('136', '282'),
    ('127', '746'),
    ('135', '866'),
    ('121', '624'),
    ('136', '847'),
    ('136', '944'),
    ('121', '230'),
    ('136', '904'),
    ('118', '904'),
    ('121', '1005'),
    ('136', '1005'),
    ('121', '864'),
    ('121', '905'),
    ('135', '282'),
    ('121', '42'),
    ('135', '54'),
    ('136', '499'),
    ('136', '732'),
    ('135', '297'),
    ('121', '72'),
    ('135', '624'),
    ('137', '232'),
    ('135', '232'),
    ('137', '744'),
    ('121', '445'),
    ('137', '445'),
    ('135', '445'),
    ('137', '773'),
    ('136', '445'),
    ('138', '54'),
    ('138', '382'),
    ('138', '624'),
    ('136', '673'),
    ('138', '933'),
    ('136', '48'),
    ('138', '458'),
    ('138', '890'),
    ('136', '933'),
    ('135', '933'),
    ('138', '994'),
    ('135', '376'),
    ('138', '1000'),
    ('138', '12'),
    ('138', '232'),
    ('136', '232'),
    ('138', '1'),
    ('138', '499'),
    ('114', '866'),
    ('114', '1020'),
    ('114', '994'),
    ('136', '1020'),
    ('136', '1007'),
    ('136', '766'),
    ('135', '968'),
    ('137', '331'),
    ('136', '828'),
    ('138', '828'),
    ('136', '175'),
    ('137', '721'),
    ('137', '73'),
    ('137', '866'),
    ('131', '866'),
    ('106', '866'),
    ('136', '881'),
    ('138', '26'),
    ('138', '882'),
    ('133', '232'),
    ('136', '561'),
    ('114', '106'),
    ('131', '673'),
    ('137', '729'),
    ('133', '729'),
    ('136', '1038'),
    ('114', '1039'),
    ('121', '1039'),
    ('131', '1038'),
    ('106', '1038'),
    ('133', '1031'),
    ('135', '1031'),
    ('131', '59'),
    ('135', '153'),
    ('133', '866'),
    ('135', '313'),
    ('133', '847'),
    ('114', '1036'),
    ('121', '1036'),
    ('106', '890'),
    ('138', '412'),
    ('131', '70'),
    ('118', '1036'),
    ('133', '382'),
    ('106', '382'),
    ('137', '382'),
    ('131', '723'),
    ('136', '1031'),
    ('136', '1047'),
    ('137', '54'),
    ('133', '376'),
    ('136', '412'),
    ('136', '357'),
    ('136', '1028'),
    ('136', '73'),
    ('136', '331'),
    ('105', '773'),
    ('105', '712'),
    ('105', '1057'),
    ('105', '817'),
    ('136', '362'),
    ('136', '817'),
    ('138', '1057'),
    ('127', '1057'),
    ('136', '457'),
    ('136', '1063'),
    ('105', '1063'),
    ('139', '115'),
    ('139', '382'),
    ('139', '1035'),
    ('140', '864'),
    ('139', '232'),
    ('136', '1073'),
    ('121', '1073'),
    ('136', '832'),
    ('140', '382'),
    ('121', '471'),
    ('140', '721'),
    ('121', '1031'),
    ('140', '1076'),
    ('140', '376'),
    ('141', '945'),
    ('141', '773'),
    ('141', '1031'),
    ('140', '1048'),
    ('140', '931'),
    ('133', '1057'),
    ('141', '1057'),
    ('140', '746'),
    ('140', '945'),
    ('135', '1085'),
    ('135', '382'),
    ('140', '106'),
    ('140', '645');

Caused the error:

    Duplicate entry '125-509-0' for key 1


That seems to be the error I wasn't able to see yesterday.

Oldiesmann

#55
Try this one - it fixes the issue with smileys and the "unexpected ]" error (this was due to a missing comma) as well as the "Use of undefined constant ID_POLL" issue. I'm not sure what's up with the "undefined index" error, so I'll have to look at that more closely later on. IPB stores all the poll data in a nice array, so it's just a matter of getting to the right spot in that array.

The "duplicate entry" error is because you apparently have two different vote entries from the same user in the same poll. I'm not sure what can be done about that - I'll have to look at it more later.
Michael Eshom
Christian Metal Fans

Monteiro

Thanks again, Oldies!

Let go the "Duplicate entry" stuff... When I get home, I'll reconvert my database again to test the new version. I'll have to delete some of my IPB posts in order to test your scripts faster... I have about 300k posts and it takes forever to convert! :'(

daveb47

#57
It was still missing a few ', but is now going right thru to Statistics,But is stopping there,

Converting...
Recalculating forum statistics... Incomplete.
Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.


& sticks on this page.
http://essexfm4.me.uk/index/convert.php?step=2&substep=10&start=0

But everything seems to have converted ok except
Signatures which are still showing on board as

[img src=\"http://www.*********.co.uk/digital-pics/3659IRedGW-thumb.gif\" border=\"0\" alt=\"\" /]
[img src=\"http://www.********.pwp.blueyonder.co.uk/alloneword3.gif\" border=\"0\" alt=\"\" /]
[!--coloro:blue--][span style=\"color:blue\"][!--/coloro--]May The Force Be With You.[!--colorc--][/span][!--/colorc--]
[!--coloro:red--][span style=\"color:red\"][!--/coloro--]The only thing in life that is guaranteed is that both you & I will die one day.[!--colorc--][/span][!--/colorc--]



& smillies which are showing as


Okey dokey dave thanx for keeping us informed hun  [img src=\"style_emoticons/[#EMO_DIR#]/thumbsup.gif\" style=\"vertical-align:middle\" emoid=\":thumbsup:\" border=\"0\" alt=\"thumbsup.gif\" /]

Quotes & Codes are not working either.

Board addy is here if you want to take a look what i mean.

http://www.essexfm4.me.uk/index/

Thanx for all your hard work m8.
Dave
https://daveb47.co.uk

A Slinky is like Jeremy CorbynWinehouse,Weird looking,Not really of any use to anybody.
But its really funny when it falls down the stairs!!:D:D

Oldiesmann

I'm working on the issues now and will post a new version shortly.
Michael Eshom
Christian Metal Fans

Oldiesmann

#59
Ok... Try this one.
Michael Eshom
Christian Metal Fans

Advertisement: