Advertisement:

Author Topic: [SMF Converter] Yabb 2.2  (Read 120202 times)

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,930
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
[SMF Converter] Yabb 2.2
« on: July 14, 2008, 10:47:48 PM »
Software: Yabb
Version: 2.2.x
Supported SMF Database Types: MySQL *

This is the official support topic for Yabb converter.  You may use this topic or the Yabb/Yabb SE board to ask for support with this converter.

Note This converter is using a new method of conversion. If you experience any issues at all please let us know.
At this time there may be a bug with membergroups not creating post count based groups on their actual post based group numbers.

Changelog
! Rewrote the Yabb 2.2 converter to use a convert table during conversion instead of altering tables. (yabb22_to_smf.php)

convert.php
Use this convert.php with the .php file attached in this topic.
« Last Edit: July 18, 2009, 03:04:45 PM by TE »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline edsager

  • Semi-Newbie
  • *
  • Posts: 11
Re: [Beta] [SMF Converter] Yabb 2.2
« Reply #1 on: October 05, 2008, 03:49:24 PM »
I am a bit frustrated with trying to find the necessary "yabb22_to_smf.sql" file. 

Where can I find this file?

Thank you,
edsager

ThorstenE

  • Guest
Re: [Beta] [SMF Converter] Yabb 2.2
« Reply #2 on: October 06, 2008, 01:42:14 AM »
the yabb converters use php-files (not .sql), the needed yabb22_to_smf.php is attached in SleePy's Message (above yours)

Offline edsager

  • Semi-Newbie
  • *
  • Posts: 11
Re: [Beta] [SMF Converter] Yabb 2.2
« Reply #3 on: October 12, 2008, 04:38:40 AM »
TE,

Thank you for the response.

What did SleePy mean with the statement, "Use this convert.php with the .sql file attached in this topic"?  This statement got me looking for a .sql file in the referenced topic.

Thanks,
edsager

ThorstenE

  • Guest
Re: [Beta] [SMF Converter] Yabb 2.2
« Reply #4 on: October 12, 2008, 05:54:57 AM »
Quote
Changelog
! Rewrote the Yabb 2.2 converter to use a convert table during conversion instead of altering tables. (yabb22_to_smf.sql)
Don't care about, it's only a note for us.. the old yabb converter (before it was rewritten) was an .sql file...

You only need the convert.php and the yabb22_to_smf.php from this topic.

Offline edsager

  • Semi-Newbie
  • *
  • Posts: 11
Re: [Beta] [SMF Converter] Yabb 2.2
« Reply #5 on: October 12, 2008, 10:50:11 PM »
Thank you!

edsager

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,930
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [Beta] [SMF Converter] Yabb 2.2
« Reply #6 on: October 13, 2008, 03:02:51 PM »
My bad, those instances should of been .php. That is what I get for copy and pasting ;)
I fixed them.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

ThorstenE

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #7 on: February 27, 2009, 01:36:41 AM »
the yaBB converter needs a configuration file from your old YaBB:
Paths.pl
the Paths.pl contains the variables for your data dirs..

Quote
   $boardsdir = "./Boards";
   $sourcedir = "./Sources";
   $memberdir = "./Members";
   $vardir    = "./Variables";

I'll check my YaBB installation later this day, maybe I can post an example paths.pl

Offline pikarl

  • Semi-Newbie
  • *
  • Posts: 10
Re: [SMF Converter] Yabb 2.2
« Reply #8 on: February 27, 2009, 04:18:44 AM »
Hi TE,

thank you for this hint. I just try to convert my YaBB 2.2.1 to SMF, still with many errors. But I do not understand what exactly you mean: Should I copy those vars from Paths.pl into the yabb22_to_smf.php?

Another question: Is it suitable to use the current SMF version 1.1.8 as target for the conversion or should I use an older one?

Offline pikarl

  • Semi-Newbie
  • *
  • Posts: 10
Re: [SMF Converter] Yabb 2.2
« Reply #9 on: February 27, 2009, 07:22:56 AM »
I get the following error message in converting:

Code: [Select]
Converting personal messages (part 1)... Unsuccessful!
This query:INSERT IGNORE INTO `raumcon`.smf114_pm_recipients
(ID_PM, ID_MEMBER, labels, is_read)
SELECT pm.ID_PM, mem.ID_MEMBER, -1 AS labels, 1 AS is_read
FROM `raumcon`.smf114_personal_messages AS pm
INNER JOIN `raumcon`.smf114_convert AS c ON (c.real_id = pm.ID_PM)
INNER JOIN `raumcon`.smf114_members AS mem ON (mem.memberName = c.temp)
WHERE c.type = 'personal_messages'
AND pm.deletedBySender = 1;Caused the error:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

I am trying to convert YaBB 2.2.1 to SMF 1.1.0 in this case. I got the same message when converting to SMF 1.1.4 or 1.1.8.

Offline pikarl

  • Semi-Newbie
  • *
  • Posts: 10
Re: [SMF Converter] Yabb 2.2
« Reply #10 on: February 27, 2009, 09:07:07 AM »
Hi,

I solved above problem now. My MySQL (4.1.13) is creating new tables in this strange swedish char set by default. I now created this convert table by myself in utf-8 and uncommented the following lines in yabb22_to_smf.php:

Code: [Select]
// convert_query("
// DROP TABLE IF EXISTS {$to_prefix}convert");

// convert_query("
// CREATE TABLE {$to_prefix}convert (
// real_id TINYTEXT NOT NULL ,
// temp TINYTEXT NOT NULL ,
// type TINYTEXT NOT NULL
// ) ENGINE=MYISAM");

Then it worked. But now I have a different problem:

I use the attachment function of YaBB. Now the converter tries not only to copy all the YaBB attachment images (11 MB) but additionally 1 GB+ of all images included in posts on external servers. That should not happen.

Any ideas?

ThorstenE

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #11 on: February 27, 2009, 10:58:46 AM »
I don't know much about YaBB but the converter should not convert "external" Links as attachments. Is there a reference file for each "external" attachment in the YaBB attachments directory?

Offline pikarl

  • Semi-Newbie
  • *
  • Posts: 10
Ynt: [SMF Converter] Yabb 2.2
« Reply #12 on: February 27, 2009, 12:15:11 PM »
No, I just get lots of images with encrypted filenames. My /attachments looks like this:

Quote
9906_screenshot_jpgfb82eba9821f5664842e5b513e188056
9907_vdb152_benintende_klein_JPG8f12f350a78c13807763c2ef64fa459b
9908_W00043245_jpg230a67d4c529871013e79bcce09e648b
9909_W00043236_jpgaa39d205ebc0776680fada5c04db2cbb
990_vlcsnap-397588_png8e556ba923dbab88d54d7f8f7d80eead
9910_enceladus-flyby_Kopie_jpgec73482a7feba11ca92a076cebba3d06
9911_nz070812p_55_fireball_jpg581e1a3d0a292f05bfd19a6711a0413e
9912_saturnbedeckung_jpgb0cb78e292e6c64efbcd7b1423a2de23
9913_Christopher-Go1_strip_gif49fe6247d01ce1b1d068ed5df22178a6
9914_GRA-06129-Meteorit_jpgb537e6caf29fb208f899a0767e3eacec
9915_Sofi_2_e_best_geschnitten_jpg0766624a26d7005c2f3e70bf6b9dcb35
9916_IMG_9475-sommerdreieck_klein_JPG6ce206344fda9045297856929efbe57e
9917_IMG_3580a-02k_jpg237bca76a1e43f341a6c6c97cef5c999
9918_bg_raumfahrt_jpg0b9866893411521023d13d6e4cb813ac
9919_1000__jpg6672cd9c2c0b9ef7cb87613ffd567668
991_vlcsnap-399474_png61095e5cba7cab015959bf18f0f735d2
9920_ModMap_jpg9f6a19484f349194179080e5519da9fe
9921_ModMap2_jpg4b0c006b8d6aa2fa8eca24a03c597ee0
9922_ModMap2_001_jpg49335371b901066a0de2aa7692832f8c
9923_ModMap2_002_jpgf9c9fc3ef954213613e77cb263d65cc0
9924_ModMap3_jpg370311aeed17a490bdeaf9373680d421
9925_ModMap4_jpg94c5a4bf67bf61c8fb27704fd06c80fe
9926_besucher_png893c2fab67ca4190b1c43c8b95af7827
9927_titel_pngc0f7ea80d951a89c3848b5f5c0dffb4d
9928_ModMap5_jpg6326c442b37ff05b745e5af829c4e886
9929_paygar_jpgb1b7db360426e3959b6113b7c25e7efd
992_IMG_2447_jpgd520d5b90faed376f48fccd7cfc2f338
9930_tex_jpgf45cda7fa4d8c22e3d8f0fad80bb445d
9931_communitylink_png7a641be3587574e7eb090a60beb16353
9932_bild_JPGc087340014c3f3ad74d61a1006712669
9933_unterstreichung_png933b152cdb90e675dee46e4cd00768d2
9934_49_Mitglieder_115_Gste_JPGf2b3d940f1f6eb689a0a111ce33c5d01
9935_Mitglieder_Sep07_jpgd4774af6c19acad39ebe2fb2a9faf2c1
9936_Prsentation1_gif1ed2c7742a023a5b48f540b896baf942
9937_stat_png2fe382709accb963b1d23b28e8e3e541
9938_suchfeld_pngb43c7d9d36a3c4571a265b7bdc5ade60
9939_Ansicht_jpg353b607b27b3a1015a04bf81c0bbcf3d
993_IMG_2446_jpg81dd40230aa874b1592b4ee169d3233b
9940_screenshot_PNGe03c8ae8ed529a5552c9b19ba2f8e5c6
9941_screeny_pngd01b3183aa90f3e5c6e352c1a1ab1365
9942_sts122_png3a1f374ed362bb7664bf6b8fcdfe4616
9943_Clipboard01_001_pngb4f9547da89e23abf2ef7b8afdbdb123
9944_VFR_08005_Raumcon-Aufkleber_transp_kl_png692ffc23732c65e8e228459832688960
9945_Clipboard01_jpge3c2b70e75b86971b768623934a8fe2d
9946_Gemini_6_views_Gemini_7_jpg678d800a68bbc3739e5160d0b7b3efcf
9947_bildtest_jpg2aab8a373a8af0ceb4299a4a86462814
9948_VFR_08005_Raumcon-Aufkleber_RZ_jpg2834a9526e2ef4abf25b6ef4424fa36e
9949_Clipboard01_pngb44da42edae7423cf10d37cb085054ab
994_IMG_2452_jpg5f400246a6c3549d77ecc4bf7c2cf5aa
9950_Ariane5_ECA_txtfd01164b5632191b0f7720cae2f4313f
9951_raumconlexikon_jpgc3689b122da5c0b4c211b883d3007d9b
9952_raumconlexikon2_jpgac682908287fbcf919cd371084810f81
9953_raumconlexikon3_jpg751f4071a60a9533cbbf2d9b677194d3
9954_raumconlexikon4_jpg1a84d8373402226e4150caea004413c5
9955_raumconlexikon5_jpg6f7415a73278b3bde069b343f9bf040f
9956_Lexikon-Tutorial_pdf1dafd9e0dbe0e1507a018f65db0a2afc
9957_Bild-1_JPG31c438d7d1bef5ab24cc433527947531
9958_isee-3_small_gif451abd0ca15c01521535cd2e1a9f07da
9959_beta_pictoris_jpgb802e965b62023c9296a7f6236d00ce9
995_IMG_2453_jpg8851e1466faf73ee3c39f41627499a17

and 19,000+ more

EDIT: Another issue - he is not taking over the number of views to SMF. Is this feature included into the converter?
« Last Edit: February 27, 2009, 12:32:45 PM by pikarl »

ThorstenE

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #13 on: February 27, 2009, 12:36:51 PM »
how many file are in the YaBB upload directory ($uploaddir)?

Offline pikarl

  • Semi-Newbie
  • *
  • Posts: 10
Re: [SMF Converter] Yabb 2.2
« Reply #14 on: February 27, 2009, 12:37:15 PM »
less than 100, around 11 MB.

ThorstenE

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #15 on: February 27, 2009, 01:42:37 PM »
the converter checks different vars before inserting the data into the convert table

if (isset($yabb['uploaddir']) && !empty($message[12]) && file_exists($yabb['uploaddir'] . '/' . $message[12]))

are you sure the variable $yabb['uploaddir'] is set to the right path?

Offline hhhoagie

  • Semi-Newbie
  • *
  • Posts: 25
Re: [SMF Converter] Yabb 2.2
« Reply #16 on: February 27, 2009, 04:28:55 PM »
the yaBB converter needs a configuration file from your old YaBB:
Paths.pl
the Paths.pl contains the variables for your data dirs..

Quote
   $boardsdir = "./Boards";
   $sourcedir = "./Sources";
   $memberdir = "./Members";
   $vardir    = "./Variables";

I'll check my YaBB installation later this day, maybe I can post an example paths.pl
Well I don't have a path.pl file so how do I go about getting around this.  I have my Boards, Sources, Members, Variable, Modules, Attachments, Messages and Templates backed up and that's all I have.
Am I dead in the water?  Or is there hope for me?
SMF 2.0.4
Template Curve
No extensions

ThorstenE

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #17 on: February 28, 2009, 02:34:52 AM »
place a "sample" paths.pl to your YaBB folder, then our converter should be able to read the old data files..

try the attached version.

Offline pikarl

  • Semi-Newbie
  • *
  • Posts: 10
Re: [SMF Converter] Yabb 2.2
« Reply #18 on: February 28, 2009, 08:26:45 AM »
the converter checks different vars before inserting the data into the convert table

if (isset($yabb['uploaddir']) && !empty($message[12]) && file_exists($yabb['uploaddir'] . '/' . $message[12]))

are you sure the variable $yabb['uploaddir'] is set to the right path?

I checked this now, the path is set correctly to the absolute directory and $yabb['uploaddir'] is set to it as well. Now I finally know what´s going wrong but I don´t have an elegant solution. In function convertStep12() in yabb22_to_smf.php the while loop is running infinitely. So he is copying YaBB´s 160 attachment files many times to SMF´s attachment directory. But I do not get why the while loop is not breaking up at this point as it should:

Code: [Select]
if (mysql_num_rows($result) < $block_size)
break;

My workaround for the moment is to set the number of loops to the number I assume to be needed regarding the block size and the total number of files in YaBB´s attachment folder.

Offline hhhoagie

  • Semi-Newbie
  • *
  • Posts: 25
Re: [SMF Converter] Yabb 2.2
« Reply #19 on: February 28, 2009, 07:00:43 PM »
place a "sample" paths.pl to your YaBB folder, then our converter should be able to read the old data files..

try the attached version.

Whoo Hoo.  That worked and looks like no errors.  Smoooooth.  thank you TE
SMF 2.0.4
Template Curve
No extensions

dataangel

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #20 on: May 12, 2009, 04:20:12 AM »
This is my first post, so bare with me... :D

I am running Yabb 2.2(which is not a clean install but upgraded from prior versions as I have been using yabb for years), I also have SMF 1.1.8 installed, running a mysql 4.1 database. If anyone can help I'd really appreciate it, I don't know anything about mysql or PHP, yes im pretty technically literate but after many hours I can't get it to pass without an errorI tried yabb22_to_smf_.php and of course I also tried yabb21_to_smf.php and yabb2_to_smf.php to compare errors, and they are all different errors naturally.

After I run the yabb22_to_smf.php convertor and I get the following:


Successful.
Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages (part 1)... Successful.
Successful.
Converting boards and categories...
Notice: Undefined index: general_cat in /home/content/d/a/t/dataangel/html/yabb22_to_smf.php on line 782

Notice: Undefined index: general_cat in /home/content/d/a/t/dataangel/html/yabb22_to_smf.php on line 784
Successful.
Converting topics (part 1)... Successful.
Converting posts (part 1 - this may take some time)... Unsuccessful!
This query:

    UPDATE `smfzork`.smfzork_topics
    SET ID_FIRST_MSG = ,
    ID_LAST_MSG =
    WHERE ID_TOPIC = 7;

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 '
    ID_LAST_MSG =
    WHERE ID_TOPIC = 7' at line 2
« Last Edit: May 12, 2009, 02:14:27 PM by dataangel »

ThorstenE

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #21 on: May 12, 2009, 01:58:30 PM »
dataangel, have you tried the yabb22_to_smf.php attached to this topic (first post)?

dataangel

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #22 on: May 12, 2009, 02:13:24 PM »
I didn't say directly that I tried it, but yes that was the one I used and then I tried the others. Edited my main post.  ;)

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,930
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb 2.2
« Reply #23 on: May 28, 2009, 06:03:41 PM »
How many posts do you have on your yabb forum?
Can you attach or send me your forum.master file from your yabb board files? My email is listed on the team page if you prefer to email it :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

dataangel

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #24 on: May 29, 2009, 12:57:35 AM »
I have something like 2000 posts? However each thread is its own file... when I run the convertor all the posts are there, however the topic convertor fails so theres NO threads for the posts to be assigned.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,930
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb 2.2
« Reply #25 on: June 03, 2009, 05:29:07 PM »
Do any boards convert?

Far as I can tell I think the boards conversion may be failing. But I don't see why

Edit,
We could try this
Find in the yabb2_to_smf.sql

Code: [Select]
list ($tempCatID, $tempID, , $description, $mods, , , , , $doCountPosts, , , $is_recycle) = explode('|', rtrim($line));
// !!! is_recycle -> set recycle board?

Add before:
Code: [Select]
if (substr($line, 0, 3) == 'qq~')
$line = substr($line, 3);
« Last Edit: June 03, 2009, 05:35:14 PM by SleePy »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

dataangel

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #26 on: June 04, 2009, 01:54:51 AM »
Ill give that a try and report the results, thanks.


^
Successful.
Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages (part 1)... Successful.
Successful.
Converting boards and categories...
Notice: Undefined index: general_cat in /home/content/d/a/t/dataangel/html/yabb22_to_smf.php on line 785

Notice: Undefined index: general_cat in /home/content/d/a/t/dataangel/html/yabb22_to_smf.php on line 787
Successful.
Converting topics (part 1)...
Notice: Undefined variable: i in /home/content/d/a/t/dataangel/html/yabb22_to_smf.php on line 866

Notice: Undefined variable: userData in /home/content/d/a/t/dataangel/html/yabb22_to_smf.php on line 866

Converting posts (part 1 - this may take some time)... Unsuccessful!
This query:

    UPDATE `smfzork`.smfzork_topics
    SET ID_FIRST_MSG = ,
    ID_LAST_MSG =
    WHERE ID_TOPIC = 7;

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 '
    ID_LAST_MSG =
    WHERE ID_TOPIC = 7' at line 2
« Last Edit: June 04, 2009, 02:36:49 AM by dataangel »

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,930
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb 2.2
« Reply #27 on: June 04, 2009, 08:04:58 PM »
I think I see it now.
Make a backup of your forum.control.

Open it. The very last line should have something similar to "general_cat|news||All"

Change general_cat to 1. I think this is the issue here as that is an invalid cat id. The converter can't find it so index errors are occurring and the conversion isn't completing.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

dataangel

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #28 on: June 05, 2009, 02:16:16 AM »
FIXED ^

Notice: Undefined variable: i in /home/content/d/a/t/dataangel/html/yabb22_to_smf.php on line 864

Notice: Undefined variable: userData in /home/content/d/a/t/dataangel/html/yabb22_to_smf.php on line 864

Converting posts (part 1 - this may take some time)... Unsuccessful!
This query:

    UPDATE `smfzork`.smfzork_topics
    SET ID_FIRST_MSG = ,
    ID_LAST_MSG =
    WHERE ID_TOPIC = 7;

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 '
    ID_LAST_MSG =
    WHERE ID_TOPIC = 7' at line 2

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,930
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb 2.2
« Reply #29 on: June 07, 2009, 12:13:21 AM »
Did the members get converted?

Those line errors are way off from what I have, so this is making debugging harder to track down. I don't think it is anything you are doing, most likely just issues with line endings from different operating systems.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

dataangel

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #30 on: June 07, 2009, 04:42:14 AM »
No it did not convert the members.  :(

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,930
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb 2.2
« Reply #31 on: June 07, 2009, 10:04:10 PM »
Would you be able to just send me all your yabb database? I can try the converter locally then. I don't know why it isn't working. I have a feeling it may be due to the changes yabb is doing in order to work with mysql and other databases.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

dataangel

  • Guest
Re: [SMF Converter] Yabb 2.2
« Reply #32 on: June 10, 2009, 03:19:58 AM »
Thanks for fixing it! Guess I just had an issue with my forum data, Doh! I don't know how that happened...

Offline Deminora

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] Yabb 2.2
« Reply #33 on: August 09, 2009, 05:06:20 PM »
Hello.

I'm trying to convert Yabb 2.1 to SMF but I get absolutly the same errors that dataangel had.

After I follow the instruction you advice in this topic I got this:

Quote
Successful.
Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages (part 1)... Successful.
Successful.
Converting boards and categories...
Notice: Undefined index: 1 in /home2/awhitney/public_html/forum/yabb21_to_smf.php on line 793

Notice: Undefined index: 1 in /home2/awhitney/public_html/forum/yabb21_to_smf.php on line 795
Successful.
Converting topics (part 1)... Successful.
Converting posts (part 1 - this may take some time)... Unsuccessful!
This query:
UPDATE `awhitney_forum`.smf_topics
SET ID_FIRST_MSG = ,
ID_LAST_MSG =
WHERE ID_TOPIC = 41;
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 '
ID_LAST_MSG =
WHERE ID_TOPIC = 41' at line 2

 :'(

I'll be very grateful for your help...

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,037
    • Arantor on GitHub
Re: [SMF Converter] Yabb 2.2
« Reply #34 on: September 05, 2009, 06:26:52 PM »
Are you still having trouble with this? I'm guessing you tried the fixes mentioned so far by SleePy though.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline nirok

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] Yabb 2.2
« Reply #35 on: October 15, 2009, 07:19:37 PM »
Hi i'm very new to SMF and wanting to move my Yabb forum to it, i'm getting this error message:

Converting posts (part 2)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up... Successful.
Converting polls and poll choices (part 1)... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:
REPLACE INTO {$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1255648495),
("conversion_from", "yabb22_to_smf.php");
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 '{$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1255648495)' at line 1



I jsut want to know if this is a problem??? I just when to my SMF board and it all seems to be there and working?? i'm just doing some tests but can someone let me know what this might mean??

Thanks

Korin

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,930
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb 2.2
« Reply #36 on: October 18, 2009, 05:54:21 PM »
You can safely ignore this error.  It is a bug in our main convert.php file.  This doesn't affect your conversion.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline machinez12

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] Yabb 2.2
« Reply #37 on: December 29, 2009, 03:37:55 PM »
Thanks for fixing it  :)

Offline bioai

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] Yabb 2.2
« Reply #38 on: February 09, 2011, 11:05:58 AM »
Hi All,

I have just converted from yaBB 2.3 to SMF 1.1.12, went very smoothly but I have had a few errors. All of my posts and users seem to be there, but I haven't done a thorough testing, other than logging in with my admin account (which was transferred also).

Can anyone shed any light on the following errors please?? They seem fairly unimportant by description, but are they likely to impact things down the line? Should I try and resolve these (or go and change settings in SMF to reflect) before I make the SMF the live forum (the old yaBB forum is currently shut down in maintenance mode,and was for the conversion).

Thanks for any advice...

My conversion log:
Converting...
Successful.
Converting membergroups... Successful.
Converting members... Successful.
Converting settings...
Notice: Undefined index: userpic_width in /home/ribcghal/public_html/smf/yabb22_to_smf.php on line 441

Notice: Undefined index: userpic_height in /home/ribcghal/public_html/smf/yabb22_to_smf.php on line 442

Notice: Undefined index: userpic_width in /home/ribcghal/public_html/smf/yabb22_to_smf.php on line 443

Notice: Undefined index: userpic_height in /home/ribcghal/public_html/smf/yabb22_to_smf.php on line 444

Successful.
Converting personal messages (part 1)... Successful.
Successful.
Converting boards and categories...
Notice: Undefined index: web in /home/ribcghal/public_html/smf/yabb22_to_smf.php on line 785

Notice: Undefined index: web in /home/ribcghal/public_html/smf/yabb22_to_smf.php on line 787

Successful.
Converting topics (part 1)... Successful.
Converting posts (part 1 - this may take some time)... Successful.
Converting posts (part 2)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up... Successful.
Converting polls and poll choices (part 1)... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Successful.
Recalculating forum statistics... Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the YaBB 2.2 installation.

We hope you had a smooth transition!


BTW: very happy so far, next step is looking at a portal or CMS integration :)


EDIT: The yabb22_to_smf.php used was the once currently attached to this thread, and convert.php from here: http://www.simplemachines.org/community/index.php?topic=140741.0

Offline bioai

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] Yabb 2.2
« Reply #39 on: February 12, 2011, 09:21:33 AM »
Hello... Can anyone suggest what these errors might relate too please? Is it max avatar size or something?

Offline IamTheBoy

  • Semi-Newbie
  • *
  • Posts: 74
    • Omega Owners Forum
Re: [SMF Converter] Yabb 2.2
« Reply #40 on: April 26, 2011, 07:00:30 AM »
Does (and where?) this converter log anywhere - I'm getting an error about 1 hour into conversion:

Converting...
Converting mark read data...The database value you're trying to insert does not exist: id_member


But no clues as to what it is doing at the time, except doing the mark read stuff.  (I'm trying to convert a 2.5AE YaBB to SMF 2.0 RC5)

Offline moodydood

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] Yabb 2.2
« Reply #41 on: January 11, 2012, 11:11:18 PM »
I guess I'll add to this.  Was working on converting YaBB 2.2 board to SMF and got this error:

Converting topics (part 1)...Wrong value type sent to the database. Integer expected. (num_views)

Please let me know if you need any more information.  Thanks.

Offline moodydood

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] Yabb 2.2
« Reply #42 on: January 12, 2012, 11:21:07 AM »
OK, found my answer after some digging.  That error is MySql saying "Hey, you're trying to insert something weird into the integer field called num_viewed."  I opened up the yabb22_to_smf.php script and looked for that field.  I then had it print out the variable that it was trying to insert into the table and it turned out that it was inserting a string into the field.  I then added some code to check if that variable was an integer and reran the script and it ran through all the way to the end.  Thank God, because converting has been nasty.  Hope this helps someone.  Time for a beer.

Offline ggn

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] Yabb 2.2
« Reply #43 on: July 09, 2012, 11:13:53 AM »
Hello, I'm trying to convert my Yabb 2.4 forum and got the same error as moodydood:

Quote
Converting...
 Successful.
 Converting membergroups... Successful.
 Converting members... Successful.
 Converting settings... Successful.
 Converting personal messages (part 1)... Incomplete.
Not quite done yet!
 This conversion has paused to avoid overloading your server, and hence not working properly.
 Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.

Converting topics (part 1)... Successful.
 Converting mark read data...The database value you're trying to insert does not exist: id_member

Can someone help with this? moodydood if you're still around maybe? :D

Thanks!

Offline moodydood

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] Yabb 2.2
« Reply #44 on: July 09, 2012, 12:25:44 PM »
No problem.  I'll try to help if I can.  However the problem you're running into is the same as IamTheBoy's problem, which is what opened the topic.  I just added to it and I never got that particular problem, so I don't know how much help I will be.  Maybe tell me what steps you took to get to this point?
 

Offline ggn

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] Yabb 2.2
« Reply #45 on: July 09, 2012, 02:13:10 PM »
Firstly, thanks for taking the time to reply and offer for help.

I did nothing fancy other than install latest smf and pointing the yabb2.2 conversion script to my current yabb2 install. I read  IamTheBoy's post and he suggested putting yabb2 into maintenance mode and running all cleanup routines, which I hadn't done. Do you think that this can cause a problem?

I was thinking of just installing smf 1.something like  IamTheBoy did and running the 2.4 conversion script and see what happens.

But I'm really interested in your opinion, what would you suggest?

Cheers,

(sorry for replying with email too, I thought you contacted me there instead of posting on the forum!)

Offline Westwegoman

  • Jr. Member
  • **
  • Posts: 189
  • Gender: Male
    • westwegoman on Facebook
    • Westwegoman on LinkedIn
    • Bayou State Fishing
Re: [SMF Converter] Yabb 2.2
« Reply #46 on: July 10, 2012, 04:13:37 AM »
For what it's worth, I followed Iamtheboys' instructions and converted mine when I was playing around with SMF and it worked great. I went from YaBB 2.4 to SMF 1.1.14 full version, then upgraded to SMF 2.0.2.

I used the instructions from the following post.
http://www.simplemachines.org/community/index.php?topic=457735.0

Hope this helps.

Sorry about the link, I'm on my phone.
« Last Edit: July 10, 2012, 04:26:04 AM by Westwegoman »

Offline ggn

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] Yabb 2.2
« Reply #47 on: July 10, 2012, 04:58:01 PM »
Well I did all the suggestions from IamTheBoy's post, and it seems it did its job! Of course I'll have to comb and massage it a bit till I'm sure it did a 100% job (and see how I can port over my existing shoutbox etc etc etc).

Anyway, thanks to all the people that helped :)

Offline Westwegoman

  • Jr. Member
  • **
  • Posts: 189
  • Gender: Male
    • westwegoman on Facebook
    • Westwegoman on LinkedIn
    • Bayou State Fishing
Re: [SMF Converter] Yabb 2.2
« Reply #48 on: July 12, 2012, 11:30:19 AM »
Glad to hear it worked. I was worried when I did mine but all went well.
« Last Edit: August 06, 2012, 05:06:12 AM by Westwegoman »

Offline Tuna78

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] Yabb 2.2
« Reply #49 on: May 10, 2014, 04:10:02 AM »
Hi everybody. Knowing that this is an old topic, but still hoping for an answer. I was trying to convert my Yabb2.2.2 to SMF with the converter and got the following error message. As I'm not very good at this is there any suggestions what to do?

---
Converting...
Successful.
Converting membergroups... Unsuccessful!
This query:
REPLACE INTO `viskikaa_smf`.smf_membergroups
(ID_GROUP, groupName, onlineColor, minPosts, stars)
VALUES (2, SUBSTRING('Moderaattori', 1, 80), SUBSTRING('#blue', 1, 20), '-1', SUBSTRING('5#stargmod.gif', 1, 255)),
(1, SUBSTRING('Ylläpitäjä', 1, 80), SUBSTRING('#red', 1, 20), '-1', SUBSTRING('5#staradmin.gif', 1, 255)),
(3, SUBSTRING('YaBB Moderator', 1, 80), SUBSTRING('green', 1, 20), '-1', SUBSTRING('5#starmod.gif', 1, 255));

Caused the error:
Unknown column 'groupName' in 'field list'
---


Offline HerbW

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] Yabb 2.2
« Reply #50 on: December 09, 2014, 02:15:25 PM »
Hi there!

In fact, I curently try to directly convert from YaBB 2.3.1 to SMF 2.0.9.

It seems as if i'm half way through (even though the forum looks quite broken, when I log in... - I still hope, this will become better...)

But now the converter stops with this Message (see image below)

What mods are you talking about? And what' happening with the database?

Maybe it is a sfaer bet to convert to an elder SMF Version (like 1.1.n ) and then go for a second try to convert that to SMF 2.x ?

Best regards,
Herbert

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] Yabb 2.2
« Reply #51 on: December 09, 2014, 05:26:43 PM »
Yes, I would say to try with 1.1 first. These converters are quite old...
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 HolgerGr

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] Yabb 2.2
« Reply #52 on: December 09, 2017, 09:38:33 AM »
Hello there,

I've just converted my YaBB 2.4 to SMF 1.1.21. I tried it with the latest version forst but it didn't work.

So far, everything worked fine. However there is still some minor issue: Any text gets cut off at the first ä, ö or ü character. So, there is some chance that I just choosed the wrong charset (I choosed UTF-8). Or will I have to change the language in the forum first? If so, I didn't find a proper language pack (german) for the old version. These ones https://download.simplemachines.org/index.php?languages;id=21 doen't work correctly.

Does anyone have the same issue and know how to fix? Woukld be great. Thank you

Holger
« Last Edit: December 09, 2017, 10:20:54 AM by HolgerGr »

Offline HolgerGr

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] Yabb 2.2
« Reply #53 on: December 10, 2017, 06:47:52 AM »
Well, I restarted the converting process with ISO 8859-1 charset now. I also changed the forums charset to ISO 8895-1. In rsult, the forums titels and descriptions are completely. Also some of the userposting. But still there are some missing by cutting off behind the first Ä, Ö or Ü