Cant see pictures after upgrade

[thekingster]

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.

[kegobeer]

How about creating a test user so I can look around?  Post the username/password here or PM the info to me.

[thekingster]

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.

[kegobeer]

http://coppermine-gallery.com/forum/index.php?topic=380

[thekingster]

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.

[DJMaze]

Can you send a copy of the 1.0 database to me, cos i don't have that.

[thekingster]

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.

[thekingster]

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!

[kegobeer]

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.

[thekingster]

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?

[kegobeer]

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.

[thekingster]

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

[thekingster]

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