forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: just_some_guy on September 22, 2007, 12:22:05 am
-
Hey,
I have been using coppermine for about 3 months now and every thing has been going smoothly. But reacently i have noticed that i get the odd Internal Server Error. I just need to wait about 10 secs and refresh the page. And sometimes i get a "mysql connection error cannot locate host ****.*******.net"
Can you see anything wrong, or resource intensive?
The site is www.mysimtractor.com
login:
username - test
password - test123
Thanks!
-
There are way too many details on your index page, both in terms of resources as well as in terms of confusion for the visitor. I suggest turning off "Show first level album thumbnails in categories".
And sometimes i get a "mysql connection error cannot locate host ****.*******.net"
Ask your webhost for support on this issue.
-
Okay thanks very much, i will do that.
-
Hmm the problem is still occuring... Can you see a problem?
Thanks,
-
What did your webhost say?
-
This is a quote from the hosts website:
External/Third party software
Unfortunately we do not allow external server software/applications to be installed onto our shared servers.
This is due to both security and performance issues. Web based applications can be installed such as phpBB, Joomla,oscommerce etc, but unfortunately our support team are unable to provide support for the installation or maintenance of these applications.
They cannot help with maintenance with problems realting to third-pary web based software. I was hoping you guys could help me.
Thanks!
-
If they don't allow third party software on their servers at all, you should look for a new webhost. But my guess is that they refer to something else in this case: they won't allow you to install stuff on webserver-level (e.g. something like ImageMagick), but they probably allow you to run pre-made scripts on your webspace (because that's what coppermine actually is). Of course they will not support you with setup problems caused by coppermine, that is understandable. However, the mysql error message you see just shines through in coppermine: it's actually an error message that your webhost is responsible for: coppermine just calls the address of the mysql server you set up in coppermine's config. If the webserver is unable to resolve the address of the mysql database, the result will be an error message similar to the one you got. Bottom line: this is something that your webhost has to take care off. If they are reluctant to do so, refer to this thread. It's something in their webserver setup if the lookup for the database fails. So don't just look at some FAQ pages of your webhost, but file a support ticket. It's vital that you stress that you're not asking them to fix coppermine issues for you, but that they need to look into things that are directly related to their webserver setup.
-
Ok, thanks for making it more clear, i have subbmited a support ticket and will get a responce within 24hrs.
-
They would like to see the file(s) that cause the errors and the links to the error messages.
What would the files be?, i think it happens when viewing the index page and maybe images.
Where can i find the error message coppermine outputs when it cant connect?
Thanks,
-
The mysql access data are being stored in include/config.inc.php. The actual queries are being run in include/init.inc.php and include/functions.inc.php
If queries fail, Coppermine just echoes the message it got from mysql. Subsequently, if coppermine displaysmysql connection error cannot locate host ****.*******.net
, this error message actually comes from mysql and just shines through coppermine. Tell your webhost to review this thread - they should get all information they need.
-
I sent them a reply showing them which files to look at, and i also mentioned they should view this thread.
-
I got a reply from my host and they said they were not aware of a problem with my server and they will monitor the situation.
Thanks for the help GauGau,
-
I caught it in action, when i was editing a pictures file information and selected save this happened: see attached picture.
Coppermine critical error:
Unable to connect to database !
MySQL said: Unknown MySQL server host 'mysql11.streamline.net' (2)
-
As suggested: report the error message to your webhost.
-
Just got a "Critical error - error whilst proccessing a database query", on a similar screen to the above image. Will this be realted to the problem? what is that error in mysql, when it does not shine-through cpg?
-
http://coppermine-gallery.net/tutorial/debug_mode.php
-
The host would like to know the "mysql setting" what is the setting for cpg?
Thanks,
-
The phrase "mysql setting" is meaningless.
-
This is what the host said: "Can you please confirm the mysql setting so we can test this for you."
do you want to see the debug?
-
The host said that they have tested the access to the database and have found no issues. So its not a problem with the database or the webserver...strange...
-
So they just performed a basic check if they can connect to the database using the information in include/config.inc.php. That's not enough. As your issues don't happen every time you access your site, but only from time to time, they can not simply use a simple black/white check. There are many settings in mysql and PHP that determine the allowed number of mysql connections during a given period. In my opinion, your webhost is trying to make you shut up. I recommend asking them to check this very thread.
-
On that note, i got the error again this afternoon, i wrote to the host again and still waiting for a reply...soon see what they see...
-
The host said that they are not aware of a issue with the mysql server and their engineers are investigating.
Thanks GauGau for your support with this matter, really appreciated.
-
I cant seem to be able to access my coppermine directory. It just returns an internal server error (500). My website has a history this problem, but usally when you refresh the page it will show. But this time its not going away. Is this likely an error with the host or me?
www.mysimtractor.com
user: test
pass: test123
working page outside coppermine: http://www.mysimtractor.com/grounds/imrieimaging/index.html
thanks for the help and what shouild i do?
-
First contact should alwys be the webhost when you get an "500 internal server error". As the error message suggests, this is an error that is not being handled properly by the webserver. The webhost should be able to review the log files and tell you what actually is wrong.
-
Thats a sigh of relief , i thought i had done something to the CPG files. Well i have submitted a support ticket to the host, i checked thier server status page...and there were no issues concerning me. It will be 24hrs ish before i get a reply.
Thanks GauGau
-
It seems to be fixed, but i got a reply from the host saying it works no problem. But the problem will still occur, it just goes away before they has a chance to see it. What should i suggest to the them? what sort of things would cause the 500 error?
-
Let me answer your question with another question: What sort of disease makes people die?
What I'm trying to say: there can be a million things that cause a 500. It's an uncaught, generic error message that is being displayed if something went wrong that doesn't fall into the categories of the other, well known error messages (like 404 not found, 403 forbidden).
-
Ok, i will just say to the host that even though its here now, it will still occur.
-
Almost two months later i still get this error after repeatedly sending support tickets they have offered me a change of mysql server. This is probably the best option - am i right in thinking i just exchange the info in include/config.inc.php to the new info?
Thanks,
-
am i right in thinking i just exchange the info in include/config.inc.php to the new info?
Yes.