forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Permissions & Access Rights => Topic started by: Hein Traag on January 09, 2005, 08:12:25 pm

Title: Switching MySql databases + searchnew question
Post by: Hein Traag on January 09, 2005, 08:12:25 pm
Hi all,

my o so gracious hoster who lets me host a couple of thousand of pictures and use his bandwidth is rearranging the way the server is being managed.

This resulted in a more structured organisation with prearranged names etc..
So i had to export my MySql data from one database to the other. Done that and with succes. Site is still running perfectly.
Except for one thing. When i now upload a new folder to the server via ftp it no longer shows up when i want to batch add files to the gallery.
I checked for the folder chmod status and that 777 all the way down the line.

So what it is ? Do i have to edit a other file besides connect.inc.php for cpg to function after a database switch ?
Title: Re: Switching MySql databases + searchnew question
Post by: Tranz on January 09, 2005, 09:22:16 pm
Did you mean config.inc.php?
Title: Re: Switching MySql databases + searchnew question
Post by: kegobeer on January 09, 2005, 09:55:40 pm
I'm assuming you don't ftp images into the userpics directory.  Did anything else change besides the database name?  Did any physical locations change as well?
Title: Re: Switching MySql databases + searchnew question
Post by: Hein Traag on January 10, 2005, 08:30:21 am
Nothing changed on the ftp side of the story. All folders still in place with all folder chmodded to 777 as usuall.

The only thing that has changed is the name of the mysql database coppermine uses for storing the info.
I exported the contents of the old database and imported it into the newly created database.
The site, pictures.scoutlink.net (http://pictures.scoutlink.net) , is running smoothly except for  me not being able to batch add pics.

I changed the settings in config.inc.php (  ;D Tranz ) so it points to the correct database.

When i choose batch add it does display all the ftp folders that were there before the switch but is does not display
the new folders i try to add now.
Title: Re: Switching MySql databases + searchnew question
Post by: Joachim Müller on January 10, 2005, 09:19:29 am
my guess is that not only the db was cleaned up by your webhost, but the coppermine files have been moved/duplicated as well. Did your webhost send you a new ftp logon? When a webhost changes stuff on webservers, they usually duplicate the files/folders in a customer's webspace to another machine and then switch that user just over - maybe your site is being run from the "new" server/webspace, while your ftp uploads still go to the old webspace. To test this, try ftp-uploading a pic (let's call it sample.jpg) to http://yoursite.tld/your_coppermine_folder/albums/your_testing_folder/ and then try accessing it by directly entering the url in your browser http://yoursite.tld/your_coppermine_folder/albums/your_testing_folder/sample.jpg - if you can't see the actual pic you just uploaded, my guess is right - you should contact your webhost then.

Joachim
Title: Re: Switching MySql databases + searchnew question
Post by: Hein Traag on January 10, 2005, 09:29:57 am
That might just be it. I did get a new ftp username and password, forgot to mention that because i am using the new name and it works.
I'll try your suggestion Joachim and i will let know if this works or not.
Thanks for the tip!
Title: Re: Switching MySql databases + searchnew question
Post by: Hein Traag on January 10, 2005, 09:38:29 am
And as it seems Joachim was right once again. I made a test folder and uploaded a smiley file called sad.gif which did not show up
when accessing it directly. So it does look like my ftp settings are not correct yet. I'll ask my host to look into this and again will
let know if this was it.

Thanks for the support.  :D
Title: Re: Switching MySql databases + searchnew question
Post by: Hein Traag on January 10, 2005, 11:46:36 am
We were on the right track. I was uploading to the correct account but it turned out it was the url which was pointing in the wrong direction.

Lesson learned, hopefully this will help others as wel when changing account and database.

- check that the mysql database of the new account is properly filled with the content of the old database
- make sure config.inc.php is edited to match the new database name and username
- See too it that the url of your site is poiting in the right direction

Not that this will apply to all problems but the above three lines were what i encountered when being thrown around on a server  ;D

Thanks again for the assist!