Topic: How to upgrade from SOBI1 to SOBI2

[aquadust]

I have written an SQL script, but you need to make sure you test this in your development region first.

Just follow the instructions and should be O.K

I don t seem to be able to attach the script so here it is . do in on your own risk.

Assumptions.
1- Immigaes don t get migrated
2- Single layer of categories


Pre Requisites:
1 - First make sure you replace the "TablePREFIX" with the correct one for your site.
2 - Change 99 to the administratorID lookup value in TablePREFIX_users table
3 - follow instructions step by step

First make sure you replace the "TablePREFIX" with the correct one for your site.

1 - Edit properties on table TablePREFIX_sobi2_categories, TURN OFF AUTO INCREMENT ON catid
2 - Run the following SQL:

Code: [Select]

insert  into `TablePREFIX_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 `TablePREFIX_categories` where `section` = "com_sobi"


Code: [Select]

insert  into `DBNAME_sobi2_cats_relations` (`catid`,`parentid`)
select  `id`,1 FROM `TablePREFIX_categories` where `section` = "com_sobi"
3 - Edit properties on table TablePREFIX_sobi2_categories , TURN ON AUTO INCREMENT ON catid
4 - Run the following SQL:

Code: [Select]

ALTER TABLE `TablePREFIX_sobi2_categories` Auto_increment=select (max(`catid`)+1) from `TablePREFIX_sobi2_categories`;
5 - Edit properties on table TablePREFIX_sobi2_item, TURN OFF AUTO INCREMENT itemid
6 - Run the following SQL: (Change 99 to the administratorID in TablePREFIX_users table)
   

Code: [Select]

insert into `TablePREFIX_sobi2_item`
(`itemid`,`title`,`hits`,`visits`,`published`,`checked_out`,`checked_out_time`,`ordering`,`owner`,`ip`,`metakey`,`metadesc`)
select `id`,`name`,`hits`,`visits`,`published`,`checked_out`,`checked_out_time`,`ordering`,99,"127.0.0.1",`description`,`description` from `TablePREFIX_sobi`;

Code: [Select]

insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 1,`address`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 2,`postcode`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 3,`city`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 4,`county`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 5,`federal_state`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 6,`country`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 7,`email`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 8,`url`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 9,`contact_person`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 10,`telephone`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 11,`fax`,"",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 12,"","",`id`,"" from `TablePREFIX_sobi`);
insert into `TablePREFIX_sobi2_fields_data` (`fieldid`,`data_txt`,`data_bool`,`itemid`,`expiration`)
(select 13,`description`,"",`id`,"" from `TablePREFIX_sobi`);
7 - Edit properties on table TablePREFIX_sobi2_item , TURN ON AUTO INCREMENT ON catid
8 - Run the following SQL:

Code: [Select]

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

Code: [Select]

insert into `TablePREFIX_sobi2_cat_items_relations` (`catid`,`itemid`,`ordering`)
select `catid`,`id`,`ordering` from `TablePREFIX_sobi`;

 8) 8)

[neo]

If this really works, You are the best

[sa3di]

yeah if this works u r the best

i will try and tell..

[sa3di]

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 `TablePREFIX_categories` where `section` = "com_sobi"


doesnt work with errors...

can u help?

[Trinity]

I can't check it, but try this

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

Trinity

[sa3di]

the same..

please can u help us to make sussceful upgrade ?

[Trinity]

which error message do you get?

[sa3di]

pleazse explain this..

2 - Change 99 to the administratorID lookup value in TablePREFIX_users table

[wp1]

Hi Trinity, aquadust & Anyone Else Working On This Upgrade Script!

Just want you to know many of us non-coders and/or baby coders are grateful for your work.

I have almost 200 entries in a "SOBI" component now and adding daily.  If I had to convert each manually, it would really be a huge task taking away from other things I should be doing on the site.

SOBI is definately a very important and useful component (Thank you to Trinity & his Team).  It is listed as the Top Rated Component at Extensions.Joomla.Org for quite a while now.

I hope some kind of automatic conversion tool/script can eventually be developed.

Thanks again to all involved.

WP1

[sa3di]

i have more than 1000 entry on Sobi

so any help