Advertisement:

Author Topic: [SMF Converter] Yabb - 2.1  (Read 322378 times)

Offline enna

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] Yabb - 2.1
« Reply #460 on: January 25, 2009, 01:57:45 PM »
thank you very much.

I did it and this error came:
Error

SQL query:

UPDATE smf_topics SET ID_LAST_MSG = ID_LAST_MSG +1000000;

MySQL said: Documentation
#1146 - Table 'NAME_imga1.smf_topics' doesn't exist

(i just replaced my account with "name")

ThorstenE

  • Guest
Re: [SMF Converter] Yabb - 2.1
« Reply #461 on: January 25, 2009, 02:08:22 PM »
sorry, my mistake.. you used a different table prefix and the table is named camileve_topics instead of smf_topics.

try it with:
Code: [Select]
UPDATE camileve_topics SET ID_LAST_MSG = ID_LAST_MSG + 1000000;
UPDATE camileve_topics SET ID_LAST_MSG = ID_FIRST_MSG + 1000000;

Offline enna

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] Yabb - 2.1
« Reply #462 on: January 25, 2009, 03:08:44 PM »
thank you very much. I am workin on it. Will let you know. Greatly appreciate the help!

Offline temestos

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] Yabb - 2.1
« Reply #463 on: May 13, 2009, 10:22:23 AM »
Hi,

I'm thinking of changing from YaBB to SMF. I tested to convert from the YaBB 2.1 -> SMF. All works fine but atleast things listed below are one problem. Anyone have suggestions how to fix em' ?

- Attachments do not convert. SMF attachments directory is empty, mysql attachments don't have any data. No errors in the conversion program.

- In private messages, I see 300 posts even though there should be only 58. Those posts seem to be related to topics I have posted something and not my actual pm's.

Thanks.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,939
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb - 2.1
« Reply #464 on: May 28, 2009, 06:11:49 PM »
Give this file a try.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline temestos

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] Yabb - 2.1
« Reply #465 on: May 30, 2009, 01:59:59 PM »
Give this file a try.

No change.

Also one problem is that Scandinavian characters like Ä and Ö are not showing at all. They have been replaced by "?" character.

I will try to convert my yabb to clean 2.2 version without any modifications. And then convert to SMF. Hopefully it will solve these problems.

ThorstenE

  • Guest
Re: [SMF Converter] Yabb - 2.1
« Reply #466 on: May 31, 2009, 06:17:53 AM »
Also one problem is that Scandinavian characters like Ä and Ö are not showing at all. They have been replaced by "?" character.
This is UTF-8 related..
see  UTF-8 Readme

Offline lgisl

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] Yabb - 2.1
« Reply #467 on: April 05, 2010, 02:11:28 PM »
Hi,

I found problems to import the attachments of yabb, we solve changing this SQL in line 1220 of yabb21_to_smf.php, it has an error with real_id and temp fields, now it works:

      $result = convert_query("
            SELECT m.ID_MSG, con.real_id as temp_filename
            FROM {$to_prefix}messages AS m
               INNER JOIN {$to_prefix}convert AS con ON (con.temp = CONCAT(m.posterTime, ':', m.posterName))
            WHERE con.type = 'msg_attach'
            LIMIT $_GET[substep], $block_size");

Thanks

Regards
Lucas
« Last Edit: April 05, 2010, 02:20:51 PM by lgisl »

Offline lgisl

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] Yabb - 2.1
« Reply #468 on: April 05, 2010, 02:16:01 PM »
Hi,

Another problem with yabb and iso8859-1 to utf8.

When we need to import the yabb to smf our forum files are in iso8859-1, the solution is convert all the files of yabb to utf8, we use this .sh:

--------------
#!/bin/bash

ICONVBIN='/usr/bin/iconv' # path to iconv binary

if [ $# -lt 3 ]
then
    echo "$0 dir from_charset to_charset"
    exit
fi

for f in $1/*
do
    if test -f $f
    then
        echo -e "\nConverting $f"
        /bin/mv $f $f.old
        $ICONVBIN -f $2 -t $3 $f.old > $f
    else
        echo -e "\nSkipping $f - not a regular file";
    fi
done
--------------

Later we execute this .sh in the directories Messages, Boards and Members of our yabb forum to convert all the files to utf8.

The sintaxis to run the .sh are:

file.sh directory_to_convert from_characterset to_characterset

example for directory messages:
/path_of_sh/name_of_sh.sh /path_of_your_yabb_directory/Messages iso-8859-1 utf8


With this files in utf8 and the solved attachments import the conversion works fine.

Thanks for the conversion script ;)

Regards
Lucas

« Last Edit: April 05, 2010, 02:20:06 PM by lgisl »

Offline the506

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] Yabb - 2.1
« Reply #469 on: September 23, 2010, 07:15:17 PM »
Just converted from YaBB 2.1 over to SMF today. I can tell that all of the posts were converted (topic and post totals match), but some of them are not showing up. In many threads, only the first page of 25 posts are viewable. There are quite a few 20+ page threads on this forum so it's a major problem.

What could be the cause of this problem and is there any way to fix it?

Thanks.

Offline phunkybeam

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] Yabb - 2.1
« Reply #470 on: September 11, 2011, 04:54:43 PM »
When i convert my board than i missing the Attachment on the Posts ... !?
Have you a Solutions vor this problem !?
« Last Edit: September 11, 2011, 06:22:10 PM by phunkybeam »

Offline Bazie

  • Semi-Newbie
  • *
  • Posts: 92
  • Gender: Male
  • Tä?
    • Bazie.net
Re: [SMF Converter] Yabb - 2.1
« Reply #471 on: August 16, 2014, 09:32:41 AM »
I am coverting Yabb 2.1 to SMF. First I tried it with the newest version 2.0.8 and later with 2.0. Still I get this error:
Quote
Converting membergroups...
Unsuccessful!
This query:

    REPLACE INTO `XXXXX_smf`.smf_XXXXXmembergroups
    (ID_GROUP, groupName, onlineColor, minPosts, stars)
    VALUES (2, SUBSTRING('Global Moderator', 1, 80), SUBSTRING('blue', 1, 20), '-1', SUBSTRING('5#stargmod.gif', 1, 255)),
    (3, SUBSTRING('YaBB Moderator', 1, 80), SUBSTRING('green', 1, 20), '-1', SUBSTRING('5#starmod.gif', 1, 255)),
    (1, SUBSTRING('Admini', 1, 80), SUBSTRING('red', 1, 20), '-1', SUBSTRING('0#staradmin.gif', 1, 255));

Caused the error:

    Unknown column 'groupName' in 'field list'
Any thoughts how to fix this?

Offline Bazie

  • Semi-Newbie
  • *
  • Posts: 92
  • Gender: Male
  • Tä?
    • Bazie.net
Re: [SMF Converter] Yabb - 2.1
« Reply #472 on: August 27, 2014, 12:50:56 PM »
Any thoughts how to fix this?
Help, please :)

SMF 1.1 RC3 is mentioned on starting post but I can't install 1.1 because of newer version MySQL :-\

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] Yabb - 2.1
« Reply #473 on: August 27, 2014, 01:31:27 PM »
For SMF2 you should use the converters from the download page:
http://download.simplemachines.org/?converters;software=yabb
Use 2.0.8 as the database schema is the same in all 2.0.x range ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Bazie

  • Semi-Newbie
  • *
  • Posts: 92
  • Gender: Male
  • Tä?
    • Bazie.net
Re: [SMF Converter] Yabb - 2.1
« Reply #474 on: August 27, 2014, 01:46:01 PM »
For SMF2 you should use the converters from the download page:
http://download.simplemachines.org/?converters;software=yabb
Use 2.0.8 as the database schema is the same in all 2.0.x range ;)
Now I did a fresh install of 2.0.8. Then I used converter from link above. Now I get this error message:
Quote
Converting...
Successful.
Converting membergroups...
Successful.
Converting members...
array(6) { [0]=> array(4) { ["file"]=> string(49) "/home/XXXXXX/public_html/forum/yabb21_to_smf.php" ["line"]=> int(219) ["function"]=> string(10) "alterTable" ["args"]=> array(4) { [0]=> &string(7) "members" [1]=> &array(1) { ["PRIMARY"]=> string(16) "DROP PRIMARY KEY" } [2]=> &string(0) "" [3]=> &array(1) { ["id_member"]=> string(74) "CHANGE COLUMN id_member id_member mediumint(8) unsigned NOT NULL default 0" } } } [1]=> array(2) { ["function"]=> string(12) "convertStep3" ["args"]=> array(0) { } } [2]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(1346) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) { [0]=> &string(12) "convertStep3" } } [3]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(973) ["function"]=> string(17) "run_php_converter" ["args"]=> array(0) { } } [4]=> array(2) { ["function"]=> string(7) "doStep1" ["args"]=> array(0) { } } [5]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(51) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) { [0]=> &string(7) "doStep1" } } }
Warning: Missing argument 1 for smf_db_list_indexes(), called in /home/XXXXXX/public_html/forum/convert.php on line 2864 and defined in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 530

Notice: Undefined variable: table_name in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 534
Incorrect table name ''

Offline Bazie

  • Semi-Newbie
  • *
  • Posts: 92
  • Gender: Male
  • Tä?
    • Bazie.net
Re: [SMF Converter] Yabb - 2.1
« Reply #475 on: October 06, 2014, 12:26:05 PM »
Now I did a fresh install of 2.0.8. Then I used converter from link above. Now I get this error message:
Quote
Converting...
Successful.
Converting membergroups...
Successful.
Converting members...
array(6) {
  • => array(4) { ["file"]=> string(49) "/home/XXXXXX/public_html/forum/yabb21_to_smf.php" ["line"]=> int(219) ["function"]=> string(10) "alterTable" ["args"]=> array(4) {
  • => &string(7) "members" [1]=> &array(1) { ["PRIMARY"]=> string(16) "DROP PRIMARY KEY" } [2]=> &string(0) "" [3]=> &array(1) { ["id_member"]=> string(74) "CHANGE COLUMN id_member id_member mediumint(8) unsigned NOT NULL default 0" } } } [1]=> array(2) { ["function"]=> string(12) "convertStep3" ["args"]=> array(0) { } } [2]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(1346) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) {
  • => &string(12) "convertStep3" } } [3]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(973) ["function"]=> string(17) "run_php_converter" ["args"]=> array(0) { } } [4]=> array(2) { ["function"]=> string(7) "doStep1" ["args"]=> array(0) { } } [5]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(51) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) {
  • => &string(7) "doStep1" } } }
Warning: Missing argument 1 for smf_db_list_indexes(), called in /home/XXXXXX/public_html/forum/convert.php on line 2864 and defined in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 530

Notice: Undefined variable: table_name in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 534
Incorrect table name ''
Any help on this?

Offline Bazie

  • Semi-Newbie
  • *
  • Posts: 92
  • Gender: Male
  • Tä?
    • Bazie.net