concrete sites have went down!!!
Permalink
Yesterday 3 of our concrete sites went down and showing the message of:
We have managed to get one of the site back up and running but had to fresh install, but with the fresh install of 5.3.0 concrete doesn't remember the admin password after signing out.
And just today another concrete site has went down with the following error message:
This site is hosted with another company and this is perflexing us.
Would any generic hosting provider upgrading or maintenance cause these issues, does anyone have any idea on what we can do?
Parse error: syntax error, unexpected '<' in /home/fhlinux161/l/lighthousecaledonia.com/user/htdocs/index.php on line 3
We have managed to get one of the site back up and running but had to fresh install, but with the fresh install of 5.3.0 concrete doesn't remember the admin password after signing out.
And just today another concrete site has went down with the following error message:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1142: INSERT command denied to user 'uchardf_248175_1'@'linweb13.atlas.pipex.net' for table 'adodb_logsql'] in EXECUTE("insert into adodb_logsql (created,sql0,sql1,params,tracer,timer) values( NOW(),'104.1910745940','select cgPermissions, cgStartDate, cgEndDate, gID from PagePermissions where cID = \'1\' and (gID in (1) )','','<br>www.chardfm.com/index.php','0.000247')") ' in /websites/LinuxPackage04/ch/ar/df/chardfm.com/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /websites/LinuxPackage04/ch/ar/df/chardfm.com/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(918): adodb_throw('mysql', 'EXECUTE', 1142, 'INSERT command ...', 'insert into ado...', false, Object(ADODB_mysql)) #1 /websites/LinuxPackage04/ch/ar/df/chardfm.com/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(874): ADOConnection->_Execute('insert into ado...') #2 /websites/LinuxPackage04/ch/ar/df/chardfm.com/public_html/ in /websites/LinuxPackage04/ch/ar/df/chardfm.com/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
This site is hosted with another company and this is perflexing us.
Would any generic hosting provider upgrading or maintenance cause these issues, does anyone have any idea on what we can do?
The problem with the first error is that we had not been doing anything with the website and all of a sudden, this error message appeared. Plus it only affected 3 of the 6 sites we have done in concrete all hosted with the same provider.
I could understand if we had been making changes to the pages, but one of the sites had not been changed in over a week and was fine for a week then all of a sudden, the error message.
Any other ideas?
I could understand if we had been making changes to the pages, but one of the sites had not been changed in over a week and was fine for a week then all of a sudden, the error message.
Any other ideas?
Also, we fixed this, thanks, it was down to the adodb_logsql table in the database, it was overflowing with information. 150Mb and 77k entries to be precise, how can we stop this from happening in future?
Maybe the first error is the result of someone trying to inject code into your site?
I have no idea how you would try to find that out or what the concrete5 developers have coded to try to prevent it from happening.
Try looking in the logs for strange content submissions.
Also check the permissions for files on the server. You want everything chmoded to 775 apart from the top level files directory, which I guess should be 777.
With the database issue, I think that you should bug report it.
I have no idea if concrete5 is adding too much to that table or if you have server side settings that are causing the problem.
I have no idea how you would try to find that out or what the concrete5 developers have coded to try to prevent it from happening.
Try looking in the logs for strange content submissions.
Also check the permissions for files on the server. You want everything chmoded to 775 apart from the top level files directory, which I guess should be 777.
With the database issue, I think that you should bug report it.
I have no idea if concrete5 is adding too much to that table or if you have server side settings that are causing the problem.
you can turn off what is being logged in the Sitewide Settings/debug screen.
Definitely uncheck "Log Database Queries" in the debug section of the settings dashboard screen. It will fill up wildly if left on for longer than necessary.
Is this still causing problems? The first issue is definitely something outside of concrete5's control (perhaps an aborted transfer that got some information but not all - or some kind of weirdly malformed upload?)
Is this still causing problems? The first issue is definitely something outside of concrete5's control (perhaps an aborted transfer that got some information but not all - or some kind of weirdly malformed upload?)
Problems like that can be avoided if you validate your pages using the w3c's validator.
The second error is database corruption caused usually by a poorly configured host server.
You can try to use phpmyadmin to repair the tables or restore a database backup.
You made a backup, right?