Fatal error after period and goes offline

[godyn]

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?

Code Select Expand

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


[SaWey]

Try checking the error log of your server and a link might help as well.

[godyn]

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

[SaWey]

It seems like your sessions table is crashing, a search on the forum got me this:

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.

[godyn]

I asked my hoster, but he has a different opinion.

Yes 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.

[SaWey]

I can't give you any more advice, I hope someone else will be able to help you.

[godyn]

ok thanks anyway.
I'll guess I'll have to find an other hoster after all...

[Nibbler]

Consider bridging. That would avoid the use of the sessions table completely.

[godyn]

would you have a link to this?
I'm not sure what you mean...

[Nibbler]

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.