Hi CPG people,
At my US hoster my album goes offline after a while. I get a "Fatal error:"
That's all I see. No error code or so. Only repairing fixes it (see below)
My hoster keeps telling it's CPG problem, he even moved my album to another server.
This is very anoying, since this album gets allot of visitors from day to day.
What could cause this?
I have the latest version (on an other install on the same server, I get the same problem also)
Any suggestions?
gsf_album.cpg14x_albums OK
gsf_album.cpg14x_banned OK
gsf_album.cpg14x_bridge OK
gsf_album.cpg14x_categories OK
gsf_album.cpg14x_comments OK
gsf_album.cpg14x_config OK
gsf_album.cpg14x_dict OK
gsf_album.cpg14x_ecards OK
gsf_album.cpg14x_exif OK
gsf_album.cpg14x_favpics OK
gsf_album.cpg14x_filetypes OK
gsf_album.cpg14x_hit_stats OK
gsf_album.cpg14x_pictures OK
gsf_album.cpg14x_plugins OK
gsf_album.cpg14x_sessions
warning : Number of rows changed from 60 to 40
status : OK
gsf_album.cpg14x_temp_data OK
gsf_album.cpg14x_usergroups OK
gsf_album.cpg14x_users OK
gsf_album.cpg14x_vote_stats OK
gsf_album.cpg14x_votes OK
Try checking the error log of your server and a link (http://forum.coppermine-gallery.net/index.php/topic,55415.msg270616.html#msg270616) might help as well.
Wow, Thanks for the quick reply.
Link is:
http://www.encountersmedia.be/gsfalbum/
Hmm, error log won't help me much:
[Mon Oct 06 14:16:37 2008] [error] [client 81.165.97.165] File does not exist: /home/gsf/public_html/404.shtml
<[Mon Oct 06 14:16:37 2008] [error] [client 81.165.97.165] File does not exist: /home/gsf/public_html/favicon.ico
[Mon Oct 06 14:16:34 2008] [error] [client 81.165.97.165] File does not exist: /home/gsf/public_html/404.shtml, referer: http://www.encountersmedia.be/gsfalbum/
Host: secure.[Mon Oct 06 14:16:34 2008] [error] [client 81.165.97.165] File does not exist: /home/gsf/public_html/gsfalbum/style.css, referer: http://www.encountersmedia.be/gsfalbum/
[Mon Oct 06 14:11:00 2008] [error] [client 67.195.37.109] File does not exist: /home/gsf/public_html/404.shtml, referer: http://www.encountersmedia.be/gsfalbum/displayimage.php?album=6&pos=37
[Mon Oct 06 14:11:00 2008] [error] [client 67.195.37.109] File does not exist: /home/gsf/public_html/gsfalbum/style.css, referer: http://www.encountersmedia.be/gsfalbum/displayimage.php?album=6&pos=37
It seems like your sessions table is crashing, a search on the forum got me this:
Quote from: Nibbler on March 05, 2007, 09:06:39 PM
Database error messages are not shown to website visitors for security reasons. There are instructions on how to get the detailed message and how to repair a crashed table available on this site. The most common cause for the tables to become corrupted is the MySQL server shutting down or restarting unexpectedly.
My guess is you are having the same problem, you might want to ask your host about this.
I asked my hoster, but he has a different opinion.
QuoteYes but it is -not- restarting frequently, you can use a monitor
to see the server uptime. This is certainly not the case.
Any other idea's :-(
I'm getting desperate here.
I can't give you any more advice, I hope someone else will be able to help you.
ok thanks anyway.
I'll guess I'll have to find an other hoster after all...
Consider bridging. That would avoid the use of the sessions table completely.
would you have a link to this?
I'm not sure what you mean...
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#integrating
You use a forum for user management, logins, sessions etc. Might not be what you want for your site, just a thought.