coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: sb on July 05, 2006, 07:33:13 PM

Title: MySQL upgrade - Albums path now has extra / - now cannot see pictures
Post by: sb on July 05, 2006, 07:33:13 PM
Have just upgrade MySQL from 4.0 to 4.1.

In the process, when restoring the coppermine database seemed to have lost users and usergroup tables. Everything else appears to be there.

From basic.sql, manually ran the sql line to insert the admin usergroup. Then manually inserted an admin user.

Can now login - but albums path is prefixed by extra / (slash) at start and end - making albums folder 'lost' to coppermine. /W:\server-root\gallery\albums/
it seems to think it is on *nix despite working quite happily before under IIS5.

Cannot find where the albums path is stored - any help here would be much appreciated.
Of course - I need to put back all the usergroups and users (approx 10 of each - not too many) - perhaps it would be easier to backup the albums folder and then do a clean install of the latest version, putting the pictures back. That way I would know *nothing* else was missing.

Comments welcome.

TIA



Title: Re: MySQL upgrade - Albums path now has extra / - now cannot see pictures
Post by: Sami on July 05, 2006, 07:42:57 PM
it's on your xxx_config table
name=fullpath
value=albums/
I'm using this on IIS too and don't have any problem !
/ is not your issue it should be somthing else
what is the error of Mysql?
Title: Re: MySQL upgrade - Albums path now has extra / - now cannot see pictures
Post by: sb on July 06, 2006, 05:24:57 PM
Thanks for reply. not sure of MySQL error.

After sleeping on it, have decided to reinstall latest version from scratch and will set up albums again (yawn) by batch import from existing folders.

Means we have latest more secure code and gives me a chance to get head round groups and permissions from anew.

Thanks again.