• Welcome to Simple Machines Community Forum. Please login or sign up.
January 21, 2022, 08:01:15 AM

News:

Check out the SMF Function DB!


[SMF Converter] IPB 2.2.x

Started by JayBachatero, January 24, 2007, 07:30:01 PM

Previous topic - Next topic

moczymorda

December 19, 2007, 08:11:29 AM #80 Last Edit: December 19, 2007, 08:23:51 AM by moczymorda
Hi. Im using this nvision22_to_smf.sql file from first post and have one problem:

Quote
Converting smileys... Unsuccessful!
This query:

    ALTER TABLE `gamerz_smf`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2

Powered By IP.Board  2.2.2

Ok im fix this.

pdavida

   
I am with the same problem of the post above ...

Needs to be done urgently to change ...

Thanks

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

pdavida

The error continues .. Arrives this part and will not .. Already tried all sql and convert.php ..

Urgent need of this conversion ..

JayBachatero

Edit the .sql file and change LENGTH(code) to code
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

pdavida

now

Recalculating forum statistics... Unsuccessful!
This query:

    SELECT hxxp:mem.id [nonactive]_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.unreadMessages
    FROM `kazehot_portal`.smf_members AS mem
    LEFT JOIN `kazehot_portal`.smf_pm_recipients AS pmr ON (mem.ID_MEMBER = hxxp:pmr.id [nonactive]_MEMBER AND pmr.deleted = 0 AND hxxp:pmr.is [nonactive]_read = 0)
    GROUP BY hxxp:mem.id [nonactive]_MEMBER
    HAVING realNum != unreadMessages;

Caused the error:

    The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay


Sarge

Quote from: pdavida on January 04, 2008, 03:22:32 AM
    The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

Download status.php from this post:
http://www.simplemachines.org/community/index.php?topic=49999.msg354073#msg354073

Upload it via FTP to your site and open the page in your browser. For example, if you upload it to your forum folder and your forum is located at yoursite.com/forum/ then you need to visit yoursite.com/forum/status.php

Go to the bottom of the page and click on the "Show more information..." link, or add ?mysql_info=1 to the URL. After the page reloads, search in the page for max_join_size and post the value here.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

JayBachatero

pdavida were you able to convert?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Powerbob

Quote from: placebo333 on November 12, 2007, 02:17:41 AM
Hi, i just did another test conversion, this time IPB 2.33 to SMF 1.14.

I spend some time looking at signatures as they are all broken after conversion. Following queries will remove unwanted tags and fix most of your signatures, executed in phpmyadmin.

Please do so at your own risk of course  :D


UPDATE smf_members SET `signature` = replace(signature,"[size=]","");
UPDATE smf_members SET `signature` = replace(signature,"[/size]","");
UPDATE smf_members SET `signature` = replace(signature,"class=\\\"linked-image\\\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"class=\"linked-sig-image\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"border=\\\"0\\\" class=\\\"linked-sig-image\\\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,".jpg\\",".jpg");
UPDATE smf_members SET `signature` = replace(signature,".gif\\",".gif");
UPDATE smf_members SET `signature` = replace(signature,".png\\",".png");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"center\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"right\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"left\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[/div]","");
UPDATE smf_members SET `signature` = replace(signature,"\\\"/]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"/]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"[/blockquote]","");
UPDATE smf_members SET `signature` = replace(signature,"[blockquote]","");
UPDATE smf_members SET `signature` = replace(signature,"\\\"","\"");
UPDATE smf_members SET `signature` = replace(signature,"\\'","'");


I have managed to (partly) successfully convert from IPB 2.3.3 to SMF 1.1.4, I say partly because attachments and pictures posted do not show!

I get this;
[size=]Kang

[/size][div align=\"center\"][img]http://xxxxxx.com/cpg1410/albums/userpics/10001/normal_kang1.JPG\" border=\"0\" class=\"linked-image\" /]
Is there anyway to do for the posts what was done for the signatures?


Bob



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

JayBachatero

They might have changed the way they hangle BBC tag.  Again :(.  Post the original IPB message with the problem.  Get it directly from the database.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Powerbob

No it's the same for all posted and attached pictures. The converter ran over this step with no problems?

The error comes later with the converted posts:

Quote
I get this;
[size=]Kang

[/size][div align=\"center\"][img]http://xxxxxx.com/cpg1410/albums/userpics/10001/normal_kang1.JPG\" border=\"0\" class=\"linked-image\" /]


Bob



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

Powerbob

Basically what I need is a routine to strip away all the unwanted tags in the posts, same as was done for the signatures.



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

JayBachatero

I need the raw data.  Straight from the database and not the one from the edit screen. IPB stores posts different than what they look on edit.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Powerbob

OK I have attached a small dump of the posts table from 233 for you.

Bob



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

Powerbob

Here is data from a topic with photos.



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Powerbob

Sorry still no luck, see attached file.



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

JayBachatero

What is the exact code in SMF right now? Get it from the database.
* JayBachatero curses IPB's stupid BBC style.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Powerbob

Using the same post this is the line out of the smf db;

QuoteINSERT INTO `smf_messages` VALUES(71175, 9934, 135, 1199873939, 1, 0, 'Line up January &#39;08', 'Powerbob', 'bob@xxx.com', '125.27.31.10', 1, 0, '', 'Glad u enjoy the pics.<br /><br />Here some more.<br /><br />[size=]Kang<br /><br />[/size][div align=\\"center\\"][img]http://xxx.com/cpg1410/albums/userpics/10001/normal_kang1.JPG\\" border=\\"0\\" class=\\"linked-image\\" /]<br /><br /><br />[img]http://xxx.com/cpg1410/albums/userpics/10001/normal_kang2.JPG\\" border=\\"0\\" class=\\"linked-image\\" /]<br />[/div]', 'xx');

Thanks

Bob



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

JayBachatero

Weird.  Try converting again.  I see that the [/div] tag was converted and I had the converter remove it.  Also post the same message but from the IPB database.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: