Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Web host stuffed up my site  (Read 5652 times)

0 Members and 1 Guest are viewing this topic.

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Web host stuffed up my site
« on: November 11, 2013, 10:58:58 pm »

 My web host had server trouble or something and shifted my site, along with others, to a new one I believe. My website’s html pages all moved okay, but my gallery went haywire.
I had about 14,500 photos in about 100 albums in about 5 categories. I now have only one album and category showing! Grrrr. They seem unable to restore the gallery. Their latest comment: “This is not an issue with the database since we have dumped the latest one.
 I really can't figure out on why Coppermine isn't showing the folders - the files are there and the database is the latest.”


I’m a novice at this kind of thing, but I poked around my site’s Control Panel and found how to get to the phpMyAdmin and look at a few things in the database, way too scared to try anything without advice though.


All my photos still reside in their original location on my website (gallery/albums/xxxx), so I don’t have to upload them again at least.


When I click on my “database name>cpg15x_albums”, I can still see all the albums in there (see attachment), similarly the categories are all still there, and the photos are there in the “cpg15x_pictures”. So it’s like I just have to click something to get everything back to normal.


Any ideas to try?
 

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Web host stuffed up my site
« Reply #1 on: November 11, 2013, 11:23:48 pm »

Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Re: Web host stuffed up my site
« Reply #2 on: November 11, 2013, 11:33:35 pm »

Nope, though I leave the selection as "All Albums" it still just prcesses the one album that is showing.

I now notice that in the "tables" list on the left, under "albums" it only shows the one album that appears on the website (see attachment). If I can get the albums into there i guess I'm away laughing..

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Web host stuffed up my site
« Reply #3 on: November 11, 2013, 11:42:35 pm »

in your include/config.inc.php check your prefix.
looks like you want it to be:
Code: [Select]
$CONFIG['TABLE_PREFIX'] =                'cpg15x_';
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Re: Web host stuffed up my site
« Reply #4 on: November 11, 2013, 11:48:12 pm »

Already like that i believe - see attachment
« Last Edit: November 11, 2013, 11:48:57 pm by Jeff Bailey »
Logged

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Re: Web host stuffed up my site
« Reply #5 on: November 11, 2013, 11:49:00 pm »

aauuggh please delete that

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Web host stuffed up my site
« Reply #6 on: November 11, 2013, 11:49:16 pm »

i just did. probably should change your password also now.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Re: Web host stuffed up my site
« Reply #7 on: November 11, 2013, 11:50:17 pm »

cheers!  :-[
 
I should read it first!!  ::)
 
anyway I think it showed the prefix is correct?

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Web host stuffed up my site
« Reply #8 on: November 11, 2013, 11:51:52 pm »

It did, the question is why is your database duplicated and why does one have a prefix and the other doesn't.

Did you have 2 galleries installed with the same database?
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Re: Web host stuffed up my site
« Reply #9 on: November 11, 2013, 11:54:58 pm »

No, only one. Must be something to do with the shift they did?

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Re: Web host stuffed up my site
« Reply #10 on: November 11, 2013, 11:56:27 pm »

Just checked - when I go to "Databases", it only shows the one: coppermine_a

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Web host stuffed up my site
« Reply #11 on: November 11, 2013, 11:58:24 pm »

Yes but you have two sets of each table ... one with a prefix and one without. In the first image you show the 'cpg15x_ablums' table and in the second image you show the 'albums' table. There should only be one set.

try backing up your database then delete all the tables that don't have a prefix, or the group of tables that don't have the correct albums.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Web host stuffed up my site
« Reply #12 on: November 12, 2013, 12:02:22 am »

have you ran update.php? that would show the tables and possibly fix any errors.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Re: Web host stuffed up my site
« Reply #13 on: November 12, 2013, 12:09:56 am »

have you ran update.php? that would show the tables and possibly fix any errors.
Just did that, everything said "Already Done", and nothing changed!
Still trying to figure out how to back it up before changing it for your previous suggestion.

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Web host stuffed up my site
« Reply #14 on: November 12, 2013, 12:14:39 am »

Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Re: Web host stuffed up my site
« Reply #15 on: November 12, 2013, 12:31:01 am »

Got it!!

I deleted all those tables without cgp15x_ in front. The gallery spat the dummy and gave me a clue that it couldn't find the table prefix. So I went back to config.inc.php, and that line saying table prefix had no prefix, so I copied and pasted you line above in your 2nd reply into the config file and saved. Now the gallery works!! Wahoo!! So although it was right the first time, the gallery just wasn't reading it right or something, it needed to "reboot" that file.

Russ_

  • Coppermine regular visitor
  • **
  • Country: nz
  • Offline Offline
  • Posts: 57
Re: Web host stuffed up my site
« Reply #16 on: November 12, 2013, 12:32:35 am »

Thank you, thank you, thank you, thank you, thank you, thank you!
 :) :D ;D 8)

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Web host stuffed up my site
« Reply #17 on: November 12, 2013, 12:36:01 am »

No problem. Strange that the image you uploaded had the prefix though.

Please mark the thread as solved.
http://forum.coppermine-gallery.net/index.php/topic,55415.msg270631.html#msg270631
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford
Pages: [1]   Go Up
 

Page created in 0.031 seconds with 19 queries.