Urgent - Please help!
I deleted and recreated the databased, reinstalled, and the same thing happened. I've tried clearing my caches, using Chrome, Firefox, and Safari, and nothing seems to help. Please help!!
I don't have an answer to your problem, but maybe you can tell us a bit more ?
Are you trying to install 188.8.131.52 or the release candidate 5.7.5rc1 ?
Are you sure that you have an empty database for concrete5 when you start the install ?
What host are you on ? Does it set limits ?
Do you have specs on your server ?
good luck !
I am hosting many concrete5 websites on my own private server and this is the first time I have seen this problem. The mySQL server is on the localhost. Yes, each time I try to install it, I remove all the tables that were created the last time.
That would point to a server setup problem...
It looks like the installer is trying to install the database tables twice because when you select the "back" link, it starts the instalation all over again and that's where the error, "there are already tables in this database", is coming from.
Watching the progress reporting, the installation gets up to the "installing dashboard" and fails at this point. The progress bar is showing not even half way complete.
This is not just a server problem since everything else including other C5 web sites are all good on this server. It's also a Concrete5 thing.
I am running Centos6.6 on a remote private server. MySQL is on the same machine and access is on the localhost. My file permissions are set to owner/group ownership are set correctly. I have tried permissions 755, 775, and 777 so it can't be a file permissions problem.
If anyone has any suggestion as to what could be causing this problem I really would like to hear you.
I'm not sure if I understand you correctly:
You mean the problem is not that concrete5 installs double tables by itself, but it only does this when you reload the install page ?
But there is a problem with the install: it halts halfway on installing the dashboard ?
If so, here are a few links that might help you:
Be sure to know what you are doing when you change any settings for your server. Especially when you have more sites on it already.
Hope this helps.
Thanks for the links that might help me. I'll go through them know.
By the way, I checked all logs and there is no errors being logged when it happens.
The installer process uses quite a bit of memory - despite how you are allocating it is there enough memory on the VPS/Server with the other stuff on there - you said a number of C5 sites and WHMCS - if you are running WHMCS are you also running Cpanel or are you running WHMCS APIs for other servers?
What are your resources like on the server? When you run the installer what happens to utilisation?
This is not a VPS. It is a dedicated server.
The site Memory usage will be dependent on the traffic to these sites and right now, the load is very light and everthing is running slick.
I do not use cPanel. I don't like what Plesk, WHM, and cPanel does to the file system. I use Webmin when needed.
phpinfo does reflect the changes I made. the following is from my php.ini.
; Resource Limits ;
; Maximum execution time of each script, in seconds
max_execution_time = 120
; Maximum amount of time each script may spend parsing request data. It's a good
; idea to limit this time on productions servers in order to eliminate unexpectedly
; long running scripts.
; Default Value: -1 (Unlimited)
; Development Value: 60 (60 seconds)
; Production Value: 60 (60 seconds)
max_input_time = 60
; Maximum input variable nesting level
;max_input_nesting_level = 64
; Maximum amount of memory a script may consume (128MB)
memory_limit = 512M
What do your error logs show immediately after the install fails the first time?
mySQL is on the same localhost and there are pleanty of resources to go arround. What I am looking for is what can be causing Apache to be throwing the "504 gateway time-out" error after 45 seconds. I can't find that timming anywhere in my configs. I even just got a reply back from my server provider that thay have no such proxy server on port 80 on their network.
Sorry AndyJ. In my haist, I hadn't noticed the change in helpers. I thought I was communicating with William.
If you do a traceroute to that particular website does it show anything noteworthy compared to other sites on the server?
Tomorrow, I guess I'll have to go into town and connect with WiFi to complete this installation.
Suggestion for future installer updates; On the client side, trap any errors that occure when the http connection closes and then report the errors with suggestions in the empty red error bar being displayed.
Hope your connection upgrade will do it's job
I'm got the same issue as these guys, I'm based in the UK with a standard broadband connection (Sky) - pretty fast and stable but still kept getting the multiple table issue.
On install I get the error message that C5 needs a clean database and that there are already 13x tables there. Which there are not - Just the empty DB and the Information Schema.
I asked my IT support to run it from their computers on a super fast connection and it took a while but worked! So perhaps there is something in the above timeout issue and C5's attempt to start adding tables again. However I just wanted to let you all know that it's not just very poor connections that may suffer.
As my first 7.5 installation I am a little underwhelmed. Can't wait to try my next one.
Hope this helps.
You get the database not empty error because when the install fails, it doesn't show what the error was, just an empty red field and a link to go back. You would expect that this would take you back to a previous display page in the install process with an explaination as to what the problem was. Instead, that back link takes the browser back to the beginning of the install process and starts the install all over again in silance and then you get the error message that the database isn't empty because on the first pass, it filled the database with tables.
To see what process is failing durring installation, first remove all the tables from the database and use a browser like Firefox with Firebug. In Firebug, click on the net tab and in that tab, it will show each process that the installation is performing. C5's install process, uses Ajax, from the browser side to issue a series of commands to the server CGIs and then waite for a result code which is also displayed. Each process should return a 200 ok code. If your problem is the same as mine, when my installation got to the install dashboard process, after 45 seconds I got the error 504 "gateway time-out" and the install process just died. This was as a result of AT&T Cellular through which I was connecting pushes the http protocal through a proxy service and this proxy times out after 45 seconds. If you see this 504 error in Firebug while the install is running, it is a good bet that you also have a proxy server at the head end of your ISP that is timing out and slamming the door on you to.
The install dashboard process takes well over a minute maybe two to complete. The easiest sollution is to find an open hotspot somewhere in town and run it again. If that hotspot gives the same error, move on to the next untill you find one that is not using a proxy that times out.
The install said it was done, but lots of rows were missing from tables.
If we install locally and then upload the files and db, we have no problems running c5 on cloudsites, just can't do an install there.
I assumed it was something messing up with the install scripts, but I think you're on to something with proxy and timeouts.
Your timeout suggestion helped me track this down, as in my case the http request from the installer returned sucesfully.
This was due to my site being in a linux container behind a proxy (Apache Trafficserver)
The solution here was to increase the origin server connection timeout in Apache Trafficserver to 4 minutes.
Without this thread I would have wasted a lot more time on this .... So, thanks!
I have attempted install on 3 separate ISP's. Has anyone figured this one out?