Conversion problem(s)

[SleePy]

cenourinha,

Using phpMyAdmin, go into your IPB database. Find the posts table. Search by pid for "220463". This is the post/message id of that topic you linked to.

Could you save that in a text file and attach it here? This is the raw format of the message before it goes through any parser or cleanup. This is helpful in seeing what is not converting properly.

[cenourinha]

Code Select Expand

<div align='center'><img src="http://i288.photobucket.com/albums/ll166/_art******/CpiadeSkins_by_Hazzy.jpg" border="0" class="linked-image" /></div><br /><br />&#8220;Skins&#8221; segue um grupo de amigos nos seus dois últimos anos num liceu em Bristol. Cada episódio é dedicado a uma das personagens, seguindo os seus dramas familiares e escolares, misturados com muito sexo, drogas e rock &amp; roll.<br /><br />Talvez por ser britânica, esta série distingue-se pela maneira dura e crua como aborda os temas da juventude, utilizando mesmo o exagero para passar uma mensagem.<br /><br />A série conta já com duas temporadas, que segue o primeiro grupo de amigos. Uma terceira já está a ser filmada, mas dedicada a um segundo grupo de personagens.<br /><br />A primeira temporada conta com nove episódios de aventuras de Tony (Nicholas Hoult; Era Uma Vez um Rapaz), Michelle (April Pearson), Sid (Mike Bailey), Chris (Joseph Dempsie), Cassie (Hannah Murray), Jal (Larissa Wilson), Maxxie (Mitch Hewer) e Anwar (Dev Patel), actor que como devem saber, poderá vir a ser nomeado a um Óscar pela sua participação em Slumdog Millionaire.<br /><br />Já foram produzidas e exibidas duas temporadas e em 2009 virá a terceira temporada, com um elenco renovado à excepção de Kaya Scodelario, que será agora a protagonista da série, depois de participar numa capacidade recorrente como Effy, a irmã mais nova de Tony.<br /><br /><script language="JavaScript" src="http://www.ltassrv.com/serve/api5.4.asp?d=4491&s=5191&c=4920&v=1"></script>

<div name="mediaspace" id="mediaspace" align="center" style="background: #fff url('http://s34.photobucket.com/albums/d109/cenourinha/macbook-air.jpg') no-repeat center; height: 500px; padding-top: 93px;">
<embed
  src="http://www.webtuga.com/player.swf"
  width="592"
  height="362"
  bgcolor="#ffffff"
  wmode="transparent"
  allowscriptaccess="always"
  allowfullscreen="true"
  flashvars="&plugins=ltas&channel=4920&file=http://www.youtube.com/watch?v=uLPa5FeZZ5g"
/></div><br /><br /><a href="http://www.youtube.com/watch?v=uLPa5FeZZ5g" target="_blank" rel="nofollow">Ver Vídeo</a><br /><br /><a href="http://www.youtube.com/watch?v=406UcAk8cpU" target="_blank" rel="nofollow">Ver Vídeo (outro)</a><br /><br />A terceira temporada começou ontem, fica aqui o vídeo da promo:<br /><br /><a href="http://www.youtube.com/watch?v=d1TxkN6zggU" target="_blank" rel="nofollow">Ver Vídeo (embeded foi desactivado)</a><br /><br />Achei excelente a série. Parece uma versão do American Pie britânica mas em série.

[SleePy]

The problem is the html that is being used in the posts. I don't see an easy way to strip it, without loosing the way you want it displayed. I think we could convert the embed to use the flash bbc, but the javascript and the div that uses a background won't be able to convert.

SMF doesn't allow HTML by non admins by default. You could as an admin, edit that post and add at the start "" and then to the end "" without the quotes. This will allow the html as long as no non-admin user edits it.

[cenourinha]

There isn't another way to do that? any sql query or script that could to that for me automatically?

[ThorstenE]

The only way to import it without loosing the "layout": import the raw html into the SMF tables. SMF can "read" the html content, but you cannot edit the messages or you'll loose the formatings.

I'll check it later this day and attach a new converter file.

[ThorstenE]

ok, new version attached.. Hope it works..

[cenourinha]

Didn't worked.
http://www.webtuga.com/smf/index.php

It does imported all the posts and all went wrong.

[ThorstenE]

I'm currently working on the converter again and hope that I can fix some issues until weekend.

It's normal to take up to 6 hours to complete the conversion?

I think I've found this issue: Our converter has a LEFT JOIN for the ipb polls and there is no Key/index in the ipb table for the "tid" field in ibf_polls:
I added a key "tid" to the table and the topics now convert in a few minutes

Code Select Expand


ALTER TABLE `ibf_polls` ADD INDEX ( `tid` );

[cenourinha]

Thank you. 

[cenourinha]

Hi there,

Any update on this?

[SleePy]

Did you do what TE did to alter the table? This sounds like it will resolve the current conversion issues

[cenourinha]

I already tried that but it's hard to get working.
The images and other embed html don't work as well... i really like SMF and i'm frustated because i cann't get it to work from IPB... :|

[SleePy]

For one of the topics where images are not converting. Can you send me the raw data?
To do this you need to get the message id of the post. I can't remember off hand how to get it for IPB, but most of them have it shown somewhere in post such as maybe a direct link to it (such as on smf we link to it with topic#"msg" + msgID).

Once you find that just go into the ipb data then the posts table. Search for the message id. You body text. That is the information I am looking for. This way I have the message contents before it goes through any parser or functions of IPB or SMF.

[cenourinha]

You can see the raw text for this topic: http://www.webtuga.com/forum/index.php?s=&showtopic=26583&view=findpost&p=220463 here > http://paste2.org/p/230188

[SleePy]

There is actually nothing wrong with that. SMF does not allow HTML in posts by default. So the html is being converted to attempt to make a bbc compatible version.
The converter can be modified so that html can be used, but you would not be able to modify any old posts.

To do that, open the invision23_to_smf.sql

Find:

Code Select Expand

$row['body'] = substr(strtr(strtr($row['body'], '<>', '[]'), array('[br /]' => '<br />')), 0, 65534);

Replace:

Code Select Expand

$row['body'] = substr(strtr(strtr($row['body'], array('<' => '[html]<', '>' => '>[/html]'), array('[br /]' => '<br />')), 0, 65534);

If you want to edit any old post from before the conversion after this. You will need to use an admin account or remove the html.

[cenourinha]

What .sql file do you recommend to use? The default at SMF site or the ones from TE?

[cenourinha]

I tried with the SMF oficial 1.9 convertor but i got this error:

Code Select Expand

Converting topics... Successful.
Converting posts (this may take some time)...
Parse error: syntax error, unexpected ';' in /home/webtuga/public_html/smf2009/convert.php(1097) : eval()'d code on line 82

Parse error: syntax error, unexpected ';' in /home/webtuga/public_html/smf2009/convert.php(1097) : eval()'d code on line 82

[...]

Parse error: syntax error, unexpected ';' in /home/webtuga/public_html/smf2009/convert.php(1097) : eval()'d code on line 82

Parse error: syntax error, unexpected ';' in /home/webtuga/public_html/smf2009/convert.php(1097) : eval()'d code on line 82


Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 4864 bytes) in /home/webtuga/public_html/smf2009/convert.php(1097) : eval()'d code on line 1

[SleePy]

Which converter file are you using?
It looks like there is a bug in the converter file.

[cenourinha]

I've used the official in the SMF website.

[cenourinha]

Any update on this? I really need to change to SMF... :|