Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: omagiko on December 16, 2009, 05:03:26 AM

Title: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on December 16, 2009, 05:03:26 AM
I has a problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2.
I use a your site converter : Yabb to SMF 2-0-rc2

But in convert give error:
.....................
Converting members...
Notice: Undefined variable: no_prefix in /home/foromag/public_html/yabb_to_smf.php on line 1452
indexed_columns:
array(38) { [0]=> string(11) "member_name" [1]=> string(6)
................................
...............................
string(1) "0" ["pm_email_notify"]=>  string(1) "1" }
Wrong value type sent to the database. Integer expected. (date_registered)

and stop it

I not that to do,  :'(
help me please
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on December 16, 2009, 06:53:28 PM
Hello there!

Please use the attached file, instead, with the convert.php you already have. If it fails, can you please copy and paste here (or in a text file) all the messages on the screen?
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on December 17, 2009, 06:28:33 AM
Thanks Norv.
In my desperation, I tried upgrade Yabb SP 1.3.1 to the version 2.2 of Yabb and it worked well. Can I use this file to turn now from Yabb 2.2 to SMF 2.0 RC2?
Now my SMF is wrong ¿? I will must repair it.
I´m very inexpert
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on December 17, 2009, 12:44:34 PM
Quote from: omagiko on December 17, 2009, 06:28:33 AM
In my desperation, I tried upgrade Yabb SP 1.3.1 to the version 2.2 of Yabb and it worked well. Can I use this file to turn now from Yabb 2.2 to SMF 2.0 RC2?
No, please try using the file for Yabb2.2 then, I attach it to this post.

Quote from: omagiko on December 17, 2009, 06:28:33 AM
Now my SMF is wrong ¿? I will must repair it.
What edits did you make to your SMF? Did you edit ./Sources/Subs-Db-mysql.php?
Is this the new SMF to which you want to convert?
If it is the new SMF installation to which you want to convert, you can always download the small update package to SMF 2.0 RC2 from this site's Downloads, unzip it, and upload the files in it, to your FTP account, overwriting SMF's files. (without upgrade.php and the upgrade sql files).
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on December 17, 2009, 02:53:55 PM
QuoteWhat edits did you make to your SMF? Did you edit ./Sources/Subs-Db-mysql.php?
I have edit MODs: Aeva, language-drop, language spanish and portugues, favicon, Arcade with games.

It is not posts in the forum I have copy in my PC, I would like to preserve the changes realized.

Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on December 17, 2009, 03:35:35 PM
Is this SMF, with Aeva, Arcade, and so on, the same installation to which you want to convert yabb2.2 ?
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on December 17, 2009, 06:42:37 PM
Yes it is
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on December 17, 2009, 11:47:34 PM
I would advice to convert to a new un-modified SMF. Then, after successful conversion, install the mods you want.
Otherwise there can be cases when the conversion process will break mods.

You could: uninstall mods, or take a large upgrade package from this site's Downloads, unzip, and upload the files over your SMF files, overwriting them. (except upgrade.php and upgrade sql files). Or even better, make a new installation.

Then, upload the convert.php and the yabb22_to_smf.php attached above and run convert.php.
If your conversion works well, then you can verify your SMF forum works, and then, install the mods you want.
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on December 18, 2009, 07:43:26 PM
Tanks very much Norv
I will try to do it of this form

I will not be able to do it this weekend, when that´s made, I tell you
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on December 28, 2009, 11:34:55 PM
I tried to converter and it showed:
QuoteConverting...

Notice: Undefined index: convert_script in /home/foromag/public_html/convert.php on line 977

Warning: Invalid argument supplied for foreach() in /home/foromag/public_html/convert.php on line 980

Notice: Undefined index: convert_script in /home/foromag/public_html/convert.php on line 992
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/foromag/public_html/convert.php on line 2513

Notice: Undefined variable: result in /home/foromag/public_html/convert.php on line 2514

Notice: Undefined index: db_fetch_assoc in /home/foromag/public_html/convert.php on line 1391

Fatal error: Function name must be a string in /home/foromag/public_html/convert.php on line 1391
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on December 29, 2009, 05:46:37 AM
Please make sure you restart the converter fully.

Delete your cookies, and access http://your_smf_address/convert.php.
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on January 03, 2010, 12:56:19 AM
I have tried again the conversion, and now showed:
QuoteConverting...
Converting personal messages (part 1)... Successful.
Converting boards and categories... Successful.
Converting topics (part 1)...Duplicate entry '1050934603-6' for key 2

And in a new attempt:
QuoteConverting...
Converting members... Successful.
Converting settings... Successful.
Converting personal messages (part 1)... Successful.
Converting boards and categories... Successful.
Converting topics (part 1)...Duplicate entry '1050934603-4' for key 2

In both cases it stops without finishing the conversion.   :'(

I have deleted the cookies every time

Happy new year
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on February 02, 2010, 03:45:10 AM
I am still with this problem. I have made good progress in the conversion but I can not get to the end
my forum is still offline
help me please  :(
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on February 02, 2010, 04:27:50 AM
What is the last error message that happens?

About the former message: "Converting topics (part 1)...Duplicate entry '1050934603-4' for key 2", it looks like the IDs of messages in yabb are bigger than expected. Please login in phpMyAdmin, select the SMF database, then the SQL tab. Enter the following code and click 'Go'.

SELECT max(id_msg) FROM smf_messages;

and please post the result here.
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on February 03, 2010, 07:18:21 PM
here attached image of what I have done
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on February 06, 2010, 05:20:24 AM
not be as follow. what I do now?

My links forum:
old:  http://www.magika21.com.ar/secreta/YaBB_2.4/cgi-bin/yabb2/YaBB.pl

new:  http://foro.magika21.com.ar/index.php
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on February 25, 2010, 04:47:53 AM
Anyone can tell me where to get help with this issue? I am left alone, and need to resolve it  :(
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: kat on February 25, 2010, 06:16:46 AM
I've removed your post from "SMF Feedback and Discussion".

Please don't make duplicate posts.

We'll help as soon as we can, but we may be in different parts of the world and our time-zones might be totally different to yours.
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on March 08, 2010, 04:35:37 AM
Sorry for the delay!
I am back from my hiatus, and will try to assist you on this, I think I might need to write a little script for this case you have here. Can you please also run in phpmyadmin:

SELECT max(id_msg) FROM smf_topics;

and post the result here?
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on March 08, 2010, 02:28:14 PM
Ok, I'm happy you're back.  :)

here attached image of what I have done
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on March 09, 2010, 09:02:12 AM
Please, try this instead:

SELECT max(id_last_message) FROM smf_topics;

Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on March 09, 2010, 07:41:51 PM
here's the new image

I noticed it says can not find the column and then also tried with "SELECT max (id_last_msg) FROM smf_topics;" 
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on March 09, 2010, 07:55:09 PM
Ah, my fault, please try this:

SELECT max(id_last_msg) FROM smf_topics;
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on March 09, 2010, 08:10:28 PM
Ah ok, here he had tried
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: Norv on March 09, 2010, 08:27:33 PM
Okay, thank you...
I will have to write a script to deal with this situation. I'm afraid it may take a few hours to a few days, because I don't really have much time..., but I'll be back on this as soon as possible.
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on March 10, 2010, 11:57:08 PM
ok, here I will wait, thanks  ;)
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on July 23, 2010, 06:15:41 AM
I have not been able to resolve this problem, can anyone help me?, Is there a patch for this conversion?  :(
Title: Re: Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please
Post by: omagiko on November 05, 2010, 04:20:53 AM
This stage was overcome, that is why I resolved the issue by