coppermine-gallery.com/forum

Support => Older/other versions => cpg1.1d PHPnuke Support (deprecated) => Topic started by: thekingster on October 26, 2003, 03:09:59 AM

Title: Cant see pictures after upgrade
Post by: thekingster on October 26, 2003, 03:09:59 AM
Hi all,

I have just upgraded from coppermine 1.0 to 1.1D.

I had a problem with the template thing which I have now overcome, and I couldnt use the upgrade script as it wouldnt work with another template error, so had to use Phpmyadmin to enter the sql queries into. All my pictures now have the right comments next to the right picture etc etc, so all is good, EXCEPT, all my pictures are dead links.

I have moved the albums folder across OK, the problem is is the url when I look at the picture properties i s incorrect. I havent installed any mods.

The propery url actually misses out the module/coppermine/albums part, so they say http://www.kingys-world.co.uk/index/html/30thJuly2002/1.jpg

Get my drift?

All entries in the config settings look fine, albums points to modules/coppermine/albums etc etc.

Any help will be very appreciated and thanks in advance.
Title: Cant see pictures after upgrade
Post by: kegobeer on October 26, 2003, 03:32:33 AM
How about creating a test user so I can look around?  Post the username/password here or PM the info to me.
Title: Cant see pictures after upgrade
Post by: thekingster on October 26, 2003, 03:44:18 AM
Im not sure theres anything to really look at......it all looks like its working, expect the pictures are dead links and point to the incorrect place.

You can just goto www.kingys-world.co.uk and make an account if you wish to look.

There must be a variable somewhere or somewhere to set something that is missing the modules/coppermine etc part.
Title: Cant see pictures after upgrade
Post by: kegobeer on October 26, 2003, 03:47:38 AM
http://forum.coppermine-gallery.net/index.php?topic=380
Title: Cant see pictures after upgrade
Post by: thekingster on October 26, 2003, 03:57:35 AM
Phpnuke 6.5 running on win2k server IIS 5.0

Problem occurs with any theme, I have tried 5 or 6 different ones.

I have installed Coppermine 1.1D for phpnuke 6.5.

Any help appreciated.
Title: Cant see pictures after upgrade
Post by: DJMaze on October 26, 2003, 06:14:26 AM
Can you send a copy of the 1.0 database to me, cos i don't have that.
Title: Cant see pictures after upgrade
Post by: thekingster on October 26, 2003, 12:08:00 PM
Quote from: "DJMaze"Can you send a copy of the 1.0 database to me, cos i don't have that.

???
Dont see how that is relevant because the puctures database just holds the image name, not the full path.

It must be something simple, Im trying to find the php file where coppermine picks up the path when displaying the pictures, but cant find it.
Title: Cant see pictures after upgrade
Post by: thekingster on October 26, 2003, 01:21:37 PM
OK I see some people have had this problem and its ended up being the ecard path, however this is not the case with me.

My ecard path points direct to the gallery. Thing is, when I change the ecard path, it doesn't seem to have any effect to the path to the pictures anyway!
Title: Cant see pictures after upgrade
Post by: kegobeer on October 26, 2003, 04:04:55 PM
Have you looked at the filepath column in cpg_pictures?  I'm guessing the paths stored for each picture are still the standalone paths.  You may have to use phpMyAdmin to change each path to modules/coppermine/xxx.
Title: Cant see pictures after upgrade
Post by: thekingster on October 26, 2003, 04:14:03 PM
indeed the filepath just says the name of the album folder, inside albums.

do I have to add it then? I thought it would just use the "albums directory" variable on the config page?

I have installed phpmyadmin, is there anyway to easily update every record, rather than having to go through them all typing them in?
Title: Cant see pictures after upgrade
Post by: kegobeer on October 26, 2003, 04:18:55 PM
AFAIK, you'll have to edit each entry.  The filepath you set in config is only for new pics, not the old ones.

It's possible to write an upgrade script that will go thru the cpg_pictures table and change each filepath to modules/coppermine/xxx.  If I get time I'll work on it, but I can't give you a timeline.  Probably quicker to do a manual change.
Title: Cant see pictures after upgrade
Post by: thekingster on October 26, 2003, 04:25:11 PM
OK

it worked

weird thing tho, it did say www.kingys-world.co.uk/index/html/albumname/picname.jpg

and the db entry just said picname.jpg, so I thought if I add /modules/coppermine/albumname/ to the beginning of the filepath record, it will work. However it didnt, it made it into www.kingys-world.co.uk/modules/coppermine/albumname/picname.jpg

Anyway I'll have to edit the db!!

Thanks for your help
Title: Cant see pictures after upgrade
Post by: thekingster on October 26, 2003, 04:32:02 PM
Done it via phpmyadmin:

UPDATE `cpg_pictures` SET `filepath` = '/index/html/modules/coppermine/albums/5thAug/' WHERE `filepath` = '5thAug/';

Replacing the dat each time for each album of course!

Cheers