Topic: How to upgrade from SOBI1 to SOBI2

[sa3di]

hello
How to upgrade from 1.1.0 to 2.1??
without losing any information or entry?

[neo]

We are really sorry, but this is possible only manual. :dry:

[sa3di]

ok
but How To??
please more explain?

[Trinity]

You have to add each entry from SOBI1 in SOBI2. You can do that via the frontend (Add new entry) or via Backend (Add new: Entry).

Trinity

[danceswithlife]

Does this apply to an upgrade from 1.03 as well?

[danceswithlife]

Does this apply to an upgrade from 1.03 as well?

[danceswithlife]

Does this apply to an upgrade from 1.03 as well?

[Trinity]

Hi danceswithlife,

Upgrading from SOBI 1 to SOBI 2 can be done only manually.

Upgrading from SOBI 2 Beta 1 to higher SOBI 2 ist not possible.

Upgrading from SOBI 2 Beta 2 and higher is always possible.

Trinity

[aquadust]

I have written a 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 it on your own risk.

Assumptions.
1- Images don t get migrated
2- Single layer of categories
3- all entries owned by the admin ID (you need to edit script to put in the correct ID)

Pre Requisites:
1 - First make sure you replace the \"TablePREFIX\" string in the script 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:
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\"

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:
select (max(`catid`)+1) from `TablePREFIX_sobi2_categories`;

5 - Replace VALUE with result from above line and RUN SQL

ALTER TABLE `TablePREFIX_sobi2_categories` Auto_increment=VLAUE;

6 - Edit properties on table TablePREFIX_sobi2_item, TURN OFF AUTO INCREMENT itemid
7 - Run the following SQL: (Change 99 to the administratorID in TablePREFIX_users table)
   
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`;

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`);

8 - Edit properties on table TablePREFIX_sobi2_item , TURN ON AUTO INCREMENT ON catid
9 - Run the following SQL:

select max(`itemid`)+1 from `TablePREFIX_sobi2_item`;

10 - Replace VALUE with result from above line and run SQL

ALTER TABLE `TablePREFIX_sobi2_item` Auto_increment=VALUE;

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

Post edited by: aquadust, at: 2006/10/21 09:10

[aquadust]

B)

Post edited by: aquadust, at: 2006/10/21 08:50