• Welcome to Simple Machines Community Forum. Please login or sign up.
September 24, 2021, 04:33:14 AM

News:

Follow SMF on Twitter.


[SMF Converter] IPB 2.2.x

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

Previous topic - Next topic

SleePy

May 12, 2008, 10:20:53 PM #160 Last Edit: May 12, 2008, 10:24:13 PM by SleePy
I see why its happening.
In the database it has it as "&lt;/b&gt;" instead of "</b>".
This is why the convert file isn't

That is simple enough. This one should force it to parse that above string as a bbc code.

If there is any others let me know of them. Most of them can be added (Only ones with bbc code translations as SMF doesn't allow html in posts for security reasons).

The iframe wouldn't be fixable without comprising security. I could detect it and add the [html][/html] around it (only admins can use those tags in posts, since the conversion converts it, it can be inserted into the database with the html tags and wouldn't go through the security parser that occurs when you post). But then if anyone had posted something in IPB that was a bad site, it would be usable on the SMF forum.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

scimmiotto

May 13, 2008, 11:41:04 AM #161 Last Edit: May 13, 2008, 12:27:03 PM by scimmiotto
wow now it seems alla correct. Tnx sleep u were very gentle, tnx a lot :) if i'll found some bugs i'll comunicate them to you.

p.s. only one question...this sql will be ok also to smf 2.0 final?

edit: i have a problem in personal messages. if i try to read them i have this error


Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'find_in_set'
File: /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/smf/Sources/PersonalMessage.php
Linea: 381
Loop code example:
The following statement is FALSE
The previous statement is TRUE.

SleePy

The 2.0 converters are not ready yet.

I wouldn't expect to see them either until after the 2.0 Final release :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

scimmiotto

tnx sleepy, plz see the errore reported in my previous post.
Loop code example:
The following statement is FALSE
The previous statement is TRUE.

SleePy

That error is saying for some reason there is a table or column in the database that is not set to utf-8.

In your Admin -> Forum Maintenance do you have the option to convert to UTF-8?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

scimmiotto

Loop code example:
The following statement is FALSE
The previous statement is TRUE.

scimmiotto

Loop code example:
The following statement is FALSE
The previous statement is TRUE.

SleePy

Ok, well the second way to fix it is a little harder and requires some work then :|

The reason you get that error is one of the table or a column in it does not match another table or column that is being used i the same query.

To fix it. You will need to use something such as phpMyAdmin What is phpMyAdmin?
First go to your database and look at all your tables. They should all say "utf8_general_ci" for the character type.
Now for each of those tables (which is where this takes time) you will need to go in and click on the structure tab.
Then you can view each column and make sure it says "utf8_general_ci" for the character type.

If any of those doesn't say "utf8_general_ci" then you will need to click the edit icon and change it to be "utf8_general_ci"
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Elkaz

Hello all.
I have a problem - I need to convert IPB 2.2.2 => SMF 2.0 Beta 3.1. Can I do this?
If no - when it will be available?
Thanks.

SleePy

At this time and point the 2.0 converters are not released (and I don't think they will be until after 2.0 is final.

You can convert to 1.1 and then just perform a large upgrade to 2.0 :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Elkaz

Wow, thanks a lot. I will try it soon.

MaNaRa

error in the converter:

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... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments... Successful.
Converting user avatars... Successful.
Recalculating forum statistics...
Notice: Undefined index: latestMember in /home/usuarios/foro/convert.php on line 1344

Notice: Undefined index: latestRealName in /home/usuarios/foro/convert.php on line 1345
Successful.


Help me, please
mi versión de foro es SMF 2.0

SleePy

Do all your members, posts, etc convert?

If they did just go to Admin -> Forum Maintenance
Do a recount totals and Stats as well as Find and repair Errors :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

alado

July 03, 2008, 03:10:03 AM #173 Last Edit: July 03, 2008, 03:16:44 AM by alado
Good day. Download a Converters for SMF 1.1
SMF version 1.1.5
IPB version 2.2.2

Two forum put into one database! Run convert.php

Converting...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Unsuccessful!
This query:
SELECT
SUBSTRING(title, 1, 30) AS title,
CONCAT(year, '-', month, '-', mday) AS eventDate
FROM `z58416_ipb`.ibf_calendar_events
WHERE event_repeat = 1
AND repeat_unit = 'y'
LIMIT 0, 500;
Caused the error:

Table 'z58416_ipb.ibf_calendar_events' doesn't exist




What could be wrong?

ThorstenE

i think you are using the invision2_to_smf.sql from the download-page. Download the new version from the first post attached in this topic (http://www.simplemachines.org/community/index.php?topic=145284.msg925365#msg925365) and the convert.php from this topic (http://www.simplemachines.org/community/index.php?topic=140741.0)

don't forget to delete the old  invision2_to_smf.sql and convert.php first..

alado

Quote from: ThorstenE on July 03, 2008, 03:29:32 AM
i think you are using the invision2_to_smf.sql from the download-page. Download the new version from the first post attached in this topic (http://www.simplemachines.org/community/index.php?topic=145284.msg925365#msg925365) and the convert.php from this topic (http://www.simplemachines.org/community/index.php?topic=140741.0)

don't forget to delete the old  invision2_to_smf.sql and convert.php first..

Thanks

mikungfu

July 27, 2008, 02:12:58 AM #176 Last Edit: July 27, 2008, 02:16:27 AM by mikungfu
I have posted this post elsewhere, but I was advised to post it here.

Using several "invision22_to_smf" files that I downloaded from several sections of this topic, I have tried to convert my IPB 2.2.2 into my SMF 1.1.5. The best results I got so far was with a "invision22_to_smf" I found was in page 9 of this topic, and using it I got the following error:

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... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments... Successful.
Converting user avatars...
Warning: copy(/home/thanatos/public_html/forun/attachments/av-896.jpg) [function.copy]: failed to open stream: No such file or directory in /home/thanatos/public_html/forun/convert.php(827) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.

Conversion Complete
Apart from what it says here about Avatars (which I don't know what it means, specially since there were no avatars in my IPB), what I noticed is that although there is a link to Private Messages and although it even says I have 7 PMs, the truth is that when I click on the link, it shows no PMs at all.

Also, although all categories, posts, members and even attachments were converted, I noticed that once I click on a title of a category or a board, it changes from bold into regular font... Which is not nice, since I'd like them to keep bold. Why is that? It didn't use to be that way in IPB...

Thanks. 

SleePy

Run this query via phpMyAdmin:
What is phpMyAdmin?

UPDATE smf_pm_recipients
SET labels = '-1';
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

mikungfu

Thank you very much!.. :D

It seems to have solved the PMs problem. About the bold/regular font problem in the boards categories and titles, it seems to be a bug of the Blazev1 Theme I'm using. I'll try to fix that in the css or something.

MrRundog

What are the definitive sql and convert.php files for 2.2 to smf please - I seem to be going round in circles attempting to use the correct ones (convert.php in the link above just sends me back & forth from post to post. Could someone please attach.

Cheers
"Tell Me & I Forget; Show Me & I Remember; Involve Me & I Understand"

Advertisement: