Migration to coppermine, having small album issue Migration to coppermine, having small album issue
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Migration to coppermine, having small album issue

Started by darrenkemp, September 23, 2009, 03:50:41 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

darrenkemp

I'm hoping someone can point me in the right direction.
I have developed a small script to migrate a pretty sizable emAlbum into a new gallery 1.4 install.
Everything seems to have migrated properly in the initial album. Once i enter a category I see all the albums, with thumbnail, with the proper file count for the album. However, once i click into the album i see all pictures in the category, not just the ones that are supposed to be in that particular album. All pictures have the proper album ID.

Here is a sample of the album and picture MYSQL inserts I am doing: (Animals is category 3)

INSERT INTO `cpg14x_albums` VALUES (11,"Butterflies","Monarchs",0,'NO','Y
ES','YES',100,3,0,'butterfly','','');

INSERT INTO `cpg14x_pictures` VALUES (155,11,'Animals/Butterflies/','PX_01-41.
jpg',223641,278922,496,744,0,'','','1','admin',0,0,'','','butterfly','YES',0,'','',''
,'',0,'','',NULL,0);

INSERT INTO `cpg14x_pictures` VALUES (156,11,'Animals/Butterflies/','PX_01-50.
jpg',213400,269297,504,744,0,'','','1','admin',0,0,'','','butterfly','YES',0,'','',''
,'',0,'','',NULL,0);

Why am i seeing all files in each album?

Thanks much for anything that can get me headed in the right direction.

Thanks

-D