SMF to s9y

[garvinhicking]

Hi!

The importer was written with phpbb2 in mind, I don'T know if it still all applies to phpbb3.

php2 had a column 'user_level', what could it be named like now?

Regards,
Garvin

[3nd3r]

I think we're talking about phpbb_users table.

I've found one of this two could be:

Code: Select all

Field_name 	Min_value 	Max_value  	Empties_or_zeros 	Nulls 	Optimal_fieldtype 
pajareo_phpbb.phpbb_users.user_id	1	272	0	0	SMALLINT(3) UNSIGNED NOT NULL
pajareo_phpbb.phpbb_users.user_type	2	3	54	0	ENUM('0','2','3') NOT NULL

[garvinhicking]

Hi!

So maybe you can search for "user_level" and replace that with "user_type" in the phpbb.inc.php importer s9y file.

Regards,
Garvin

[3nd3r]

Done.

This message appears:

Code: Select all

Importación fallida: No se puede seleccionar la información del usuario: Unknown column 'user_active' in 'where clause'.

The table phpbb_users has this fields:

Code: Select all

user_id
user_type
group_id
user_permissions
user_perm_from
user_ip
user_regdate
username
username_clean
user_password
user_passchg
user_pass_convert
user_email
user_email_hash
user_birthday
user_lastvisit
user_lastmark
user_lastpost_time
user_lastpage
user_last_confirm_key
user_last_search
user_warnings
user_last_warning
user_login_attempts
user_inactive_reason
user_inactive_time
user_posts
user_lang
user_timezone
user_dst
user_dateformat	user_style
user_rank
user_colour
user_new_privmsg
user_unread_privmsg
user_last_privmsg
user_message_rules
user_full_folder
user_emailtime
user_topic_show_days
user_topic_sortby_type
user_topic_sortby_dir
user_post_show_days
user_post_sortby_type
user_post_sortby_dir
user_notify
user_notify_pm
user_notify_type
user_allow_pm
user_allow_viewonline
user_allow_viewemail
user_allow_massemail
user_options
user_avatar
user_avatar_type
user_avatar_width
user_avatar_height
user_sig
user_sig_bbcode_uid
user_sig_bbcode_bitfield
user_from
user_icq
user_aim
user_yim
user_msnm
user_jabber
user_website
user_occ
user_interests
user_actkey
user_newpasswd
user_form_salt
login_name

[garvinhicking]

Hi!

Seems like some more fields have changed. Maybe you can map them to the new ones one after one.

It seems there no longer is a colum that matches user_active, so maybe you just create a column called user_active and set it to 1 for every row.

Or you can try to find a SMF->phpbb2 importer?

Regards,
Garvin

[3nd3r]

Yes... I'll look for a SMF to phpBB2 convertor...

Just tell you that you may work on phpBB3 to s9y importer... For future users, I mean... Don't be upset with this, just an positive advice, ok?

I'll tell you how is working.

[3nd3r]

Well, it's done. And there's a few errors, I hope will be easy to solve.

The original web is http://www.pajareo.com
the phpBB2 is http://www.pajareo.com/phpBB2/
and the final s9y is http://www.pajareo.com/s9y/

I've made the conversion through admin panel with UTF-8, HTML entities conversion on 'Yes', and the last 'links' option set to 'No'.

Here we go:

1) What tables in s9y database should I drop to try conversion again without duplicate users or entries?

2) Entries titles are truncated, and some characters in them appears with '?': á, é, í, ó, ú, ¿, ¡ ...

3) Some characters in entries body appears like '?': ', € ...

4) Some BBCode or HTML appears wrong: For example, in http://www.pajareo.com/s9y/index.php?/a ... todos.html :
a) This should be an image with text aligned to the left:

Code: Select all

[img align=left alt=xVST]http://xviservicethief.wiki.sourceforge.net/space/showimage/header_wiki.png[/img]

b) In the original SMF, this text

Code: Select all

<a href="http://xviservicethief.sourceforge.net/index.php?action=home">xVideoServiceThief</a>

are dumped into phpBB2 like s9y shows

Code: Select all

<a>xVideoServiceThief</a>

but it must be

Code: Select all

<a href="http://xviservicethief.sourceforge.net/index.php?action=home">xVideoServiceThief</a>

c) There's no HTML links:
This

Code: Select all

http://bitelia.com/2008/08/26/descarga-y-convierte-videos-de-los-sitios-mas-populares-de-internet-con-xvideoservicethief/

should be this

Code: Select all

<a href="http://bitelia.com/2008/08/26/descarga-y-convierte-videos-de-los-sitios-mas-populares-de-internet-con-xvideoservicethief/">http://bitelia.com/2008/08/26/descarga-y-convierte-videos-de-los-sitios-mas-populares-de-internet-con-xvideoservicethief/</a>

d) Some BBCode are wrong, like these one here:

Code: Select all

[b:7288251b27]revivir a Freddy Krueger ([i:7288251b27]Pesadilla en Elm Street[/i:7288251b27]) y Jason Voorhes ([i:7288251b27]Viernes 13[/i:7288251b27])[/b:7288251b27], además de atreverse con una insólita relectura de [b:7288251b27]La semilla del diablo[/b:7288251b27]

that should be

Code: Select all

<strong>revivir a Freddy Krueger (<em>Pesadilla en Elm Street</em>) y Jason Voorhes (<em>Viernes 13</em>)</strong>, además de atreverse con una insólita relectura de <strong>La semilla del diablo</strong>

5) Categories title and names are showed wrong in right side block, and its links seems not to work

6) Flash links to videos:

Code: Select all

[flash=425,344]http://www.youtube.com/v/6tKuMPOpbIY&hl=es[/flash]

I think that most of this errors are easy to solve with an SQL sentence... For anyone (not me) who knows how to do it...

Please be patient... Take your time and thank you very much in advance for helping me... I really want to get rid of SMF and start designing my new s9y site.

[garvinhicking]

Hi!

1) What tables in s9y database should I drop to try conversion again without duplicate users or entries?

You should never drop tables, only empty them. But this is hard, because you would also drop other stuff.

I suggest to create a DB dump of your s9y installation BEFORE import, and if you need to retry the import, first restore your DB dump of the s9y installation.

2) Entries titles are truncated, and some characters in them appears with '?': á, é, í, ó, ú, ¿, ¡ ...
3) Some characters in entries body appears like '?': ', € ...

This usually means that the import failed because of mismatching charsets. You should disable HTML entity conversion, and maybe retry import with ISO instead of UTF-8.

4) Some BBCode or HTML appears wrong: For example, in http://www.pajareo.com/s9y/index.php?/a ... todos.html :

The s9y BBCode seems to work differently, you need to specify the url via url=XXX and not within the code brackets.

About this b:XXX code stuff: s9y cannot convert interal phpbb references to its own bbcode, because phpbb defines a DB lookup that s9y cannot do.

5) Categories title and names are showed wrong in right side block, and its links seems not to work

This might have happened because of multiple imports into the same s9y?

Code: Select all

6) Flash links to videos:
[code][flash=425,344]http://www.youtube.com/v/6tKuMPOpbIY&hl=es[/flash]

[/code]

s9y's bbcode plugin does not support this (flash) command.
You will need to use search+replace, maybe even with some code logic, to replace those missing bbcodes, or one might need to write an own BBCode s9y plugin (or change the existing) to include those new bbcodes.

HTH,
Garvin

[3nd3r]

Quote:
1) What tables in s9y database should I drop to try conversion again without duplicate users or entries?



You should never drop tables, only empty them. But this is hard, because you would also drop other stuff.

I suggest to create a DB dump of your s9y installation BEFORE import, and if you need to retry the import, first restore your DB dump of the s9y installation.

Ok. So, now my that my s9y DB has many registers, how could I make it?
Should I try to install s9y again over it?

I'll try the other things after that

[garvinhicking]

Hi!

Ok. So, now my that my s9y DB has many registers, how could I make it?
Should I try to install s9y again over it?

Yes, that would be the easiest way. I think you have no other content in that s9y blog that you would loose then...?

Regards,
Garvin

[3nd3r]

Not really... I think.

I want to import posts, comments and users, and then go to design.

So I think I don't loose any important thing if I reinstall s9y over current one, do I?

[garvinhicking]

Hi!

Right, you shouldn't loose anything, apart from your basic configuration - everything you entetred independently from the import before. So drop all serendipity_* DB tables and delete your serendipity_config_local.inc.php file then you can reinstall s9y.

Regards,
Garvin

[3nd3r]

2) Entries titles are truncated, and some characters in them appears with '?': á, é, í, ó, ú, ¿, ¡ ...
3) Some characters in entries body appears like '?': ', € ...

This usually means that the import failed because of mismatching charsets. You should disable HTML entity conversion, and maybe retry import with ISO instead of UTF-8.

5) Categories title and names are showed wrong in right side block, and its links seems not to work

This might have happened because of multiple imports into the same s9y?

Well, I did what you say (disabling HTML entities) and import with ISO and the errors are the same or similar in titles, entries and categories on first import...

I also see that comment on an entry are showed like an entry itself:
http://www.pajareo.com/s9y/index.php?/a ... ruina.html

[3nd3r]

Bump!

Pardon my insistence, any ideas about this?

Thanks in advance for your time

[garvinhicking]

Hi!

Sorry, right now this is a bit too time consuming for me to inspect. If a character mismatch happens it can have a lot of reasons because of differing myslq charsets.

I hope once a work project is finished I can help you again, but that might take a week or two.

Regards,
Garvin