How to upgrade from SOBI1 to SOBI2

[wp1]

SNIP...

My plan to upgrade is mainly to export my existing listing database, and re-configure it to insert into the new tables via PHPMyAdmin.

Hello meadwench!

If all works well for you and if you have the time, please, post a "Step By Step" Tutorial as to how you did it.

Thanks in advance.

WP1

[meadwench]

Will do. I'm hoping to make the upgrade sometime this month, work permitting. I'll try to post a step-by-step when I get it done, and attach spreadsheets that contain the info......

[Wicked]

sir we all thanks u for ur free version

but as u know and any body knows when somebody decide to programming a new script and wanna it be more famouse should be work in academy way like that

1- programming
2- put strategy for upgrade
3- work on support for free
4 - try to resolve all errors
5- when make upgrade should be care about who trust u and uses ur first version to make script how to upgrade there data entry..
6-
7-

dear friend we are here to dicusc if u wanna money about this works should u say from first we will take money about our service...

and if any one here wanna pay should was gone to other paid scripts  right?


any how thank u very much

Who is this Arrogant Prick?

Iam amazed at your Patience with him Trinity & Neo , and you are absolutely right when you say that this sort of support is worth more money then this dude is willing to offer, make it worse he probably makes alot of money out of the use of this component and has the cheek to tell you that you must (the audacity) provide a FREE strategy and upgrade ability options for him/herself.

Being of the opinion that this is an excellent component with minimal bugs and perhaps an issue or two with limitations & Backup facilities , I would in no way hold the inventors of this script responsable if it failed majorly or otherwise , as it was my choice to install and use it under the terms and conditions in the ula presented before downloading. If I am concerned about anything then I like everyone else in this board would post a question and await a reply patiently (usually very prompt and very detailed) Thankyou Trinity.Neo & Eihwaz.

These pathetic statements make me Angry and had I been moderator of this board the word would be
BANNED! IP and otherwise.

My Rant.

Wks../

ps: I do appreciate the work that you guys/gals are putting into this project and try to help where I can short of putting myself through PHP school. (May actually contemplate this).
Keep up the good work.

[Wicked]

SNIP...

My plan to upgrade is mainly to export my existing listing database, and re-configure it to insert into the new tables via PHPMyAdmin.

Hello meadwench!

If all works well for you and if you have the time, please, post a "Step By Step" Tutorial as to how you did it.

Thanks in advance.

WP1

Hi there,

This is currently being worked on in this post

from what I can gather is that you export through phpmyadmin your existing listings (I have not used sobi1 but presume that it has similar fields to sobi2)

Secondly you create a new MYSQL DB on the server , change the field names accordingly in the new DB & Script in above link.

Run the Script.

Pray!

Best Regards

Wks../

[meadwench]

Actually, as far as I can tell, no one is working on it. The SOBI1 and SOBI2 tables are completely different, and SOBI2 has a completely different structure, hence the problems. If it were the same, moving it would be easy.

I'm going to attempt the script posted earlier, see if that does it. If I can't get it to work, I'll make some changes.

Neo, Trinity, great work on *both* these. Unlike some, I don't expect free components to provide worry-free/work-free upgrade paths.

[meadwench]

OK, tested the script here: http://www.sigsiu.net/forum/index.php/topic,903.msg1433.html#msg1433 and it works. These steps were unecessary for me:

Code:

ALTER TABLE `TablePREFIX_sobi2_categories` Auto_increment=select (max(`catid`)+1) from `TablePREFIX_sobi2_categories`;

and

Code:

ALTER TABLE `TablePREFIX_sobi2_item` Auto_increment=select (max(`catid`)+1) from `TablePREFIX_sobi2_item`;

because I changed my table properties using Navicat, my SQL program.



Thanx,

Vicky Rowe
Gotmead.com

[jaywilliams]

Hi,

I know this is an old thread however I'm hoping someone might be able to help me out!

I've got a client at the moment thats running sobi and is looking at running sobi2 so any migration of any of the data will be helpful.

I found this thread and the mysql code seems to do what I'm trying to do however I've hit an error. I'm not real up on mysql but I can stumble my way around php admin and can follow the instructions that are posted relatively well.

This is my error at the moment:

When I run

Code:

insert into `jos_mediaww_sobi2_categories`
(`catid`,`name`, `image`,`image_position`,`description`,`introtext`,`published`,`checked_out`,`checked_out_time`,`ordering`,`access`,`count`,`params`,`icon`)
select `id`,`name`,`image`,`image_position`,`description`,`description`,`published`,`checked_out`,`checked_out_time`,`ordering`,`access`,`count`,`params`,
FROM `jos_mediaww_categories` where `section` = "com_sobi"

I'm getting the following error:

MySQL said: 

#1064 - 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 'FROM `jos_mediawwcategories` where `section` = "com_sobi"' at li

That's all of the message that displays. I'm running a mysql 4 database.

If anyone is able to give me some pointers as to the error that would be fantastic!

Regards

Jay