Dragonfly CMS v9 ⇒ Coppermine ⇒ Migrate to standalone CPG ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum Index Modules & Blocks Coppermine

Migrate to standalone CPG Reply to topic


Holas

Are there any instructions anywhere for migrating from a DF coppermine to standlone coppermine?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Centos 4,5/2.2/4/5.3/9.0.6.1


No instructions but tables are still pretty similar.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


Howdy

I am trying to do this now - tried to import from DF CPG 1.3.1 to currnt CPG 1.5.x by deleting those fields that no longer existing in structure of present version and adding those that do and then copying the table over.

It is working - sortof - clearly stuff missing.

Would it be better if I got a version of CPG 1.3.1 and did it to CPG 1.3.1 first and then upgraded from there?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Centos 4,5/2.2/4/5.3/9.0.6.1


No idea on this, sorry I can't help you but if you go back to CPG 1.3.1 you might have better chances.

Off course CPG as made many progresses while our version is stale, but what are your needs?

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


I have gone back to 1.3.1 and not succeeded yet.

It is a 5G DF CPG gallery which I am trying to migrate into a standalone gallery.

The gallery is presently on an offline system so I cannot share it with you yet, but I basically did the following:

1. Created a new DB with only the cpg tables extracted from the DF DB.
2. Installed CPG 1.3.1 (matching the version used by DF) using a different DB
3. Compared the table structure and amended the copied DF tables to match
4. Copied all the data from the DF albums, categories, comments and pictures tables to the tables of the newly installed CPG 1.3.1 (replacing anything that was there).

Because all the user data was stored in DF, there is no users table - but that shouldn't matter for my purposes (migrating to IP.Gallery with IP.Board or migrating to a standalone CPG bridged with phpBB 3).

What I need help with is that the above process has not produced and entirely working CPG (sans users). The Default listing of galleries on the front page shows no thumbnail pic and 0 files - and I need to fix that. I don't know what else is broken.

I will share the whole process with the broader community.

Details:

enable register_long_arrays in /etc/php.ini

ALTER TABLE `cpg_albums` ADD `keyword` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL ;
ALTER TABLE `cpg_albums` CHANGE `last_addition` `last_addition` DATETIME NOT NULL DEFAULT '0'
INSERT INTO `cpg`.`cpg131_albums` SELECT * FROM `cpg13`.`cpg_albums` ;

ALTER TABLE `cpg_categories` CHANGE `catname` `name` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
ALTER TABLE `cpg_categories` ADD `thumb` INT NOT NULL AFTER `parent` ;
INSERT INTO `cpg`.`cpg131_categories` SELECT * FROM `cpg13`.`cpg_categories` ;

INSERT INTO `cpg`.`cpg131_comments` SELECT * FROM `cpg13`.`cpg_comments` ;

INSERT INTO `cpg`.`cpg131_pictures` SELECT * FROM `cpg13`.`cpg_pictures`;

update cpg131_pictures set filepath = replace(filepath, 'modules/coppermine/albums/userpics','albums/userpics');

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Centos 4,5/2.2/4/5.3/9.0.6.1

All times are UTC


Jump to: