Problem about convert YaBB 1 Gold - SP 1.3.1 to SMF 2.0 RC2 - Help me please

Started by omagiko, December 16, 2009, 05:03:26 AM

Previous topic - Next topic

omagiko

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

Norv

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?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

omagiko

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

Norv

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).
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

omagiko

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.


Norv

Is this SMF, with Aeva, Arcade, and so on, the same installation to which you want to convert yabb2.2 ?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github


Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

omagiko

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

omagiko

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

Norv

Please make sure you restart the converter fully.

Delete your cookies, and access http://your_smf_address/convert.php.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

omagiko

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

omagiko

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  :(

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github


omagiko


omagiko

Anyone can tell me where to get help with this issue? I am left alone, and need to resolve it  :(

kat

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.

Norv

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?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

omagiko

Ok, I'm happy you're back.  :)

here attached image of what I have done

Advertisement: