Contao 3.2.3 installation on hostgator

[lupomas]

Hello,
I am unable to install a new version of contao 3.2.X on my hoster hostgator. I already precise that versions 3.1.X works perfectly.
The problem comes once the installation asks me to create the tables. I click on proceed and then I have a timeout and nothing is working anymore.
Really strange. I saw several persons having the same issue.
I'll appreciate any help
Thanks in advance
Massimo

[xchs]

I have no clue what's going on. What's the value for the "Max Execution Time" PHP setting?

[lupomas]

I have no clue what's going on. What's the value for the "Max Execution Time" PHP setting?

Thank you.
max_execution_time 30

[xchs]

That should – in any case – be enough.

How do you connect to the database server, via localhost or via an external server?

[lupomas]

That should – in any case – be enough.

How do you connect to the database server, via localhost or via an external server?

localhost. I attach a pdf file of phpinfo. Reading some of your posts I also switched between mysqli and mysql and it does not work neither

Thanks

[xchs]

Hmm, strange. I can offer you to take a (short) look on the problem. I would then try to perform the installation task by myself.

[lupomas]

Hmm, strange. I can offer you to take a (short) look on the problem. I would then try to perform the installation task by myself.

Thanks. What should I do ?

[xchs]

I need the credentials (FTP, database, etc.). For this, please contact me by PM.

[lupomas]

I need the credentials (FTP, database, etc.). For this, please contact me by PM.

Thank you very much. I'll PM everything in a couple of minutes (well I hope, first time I do this ).

[lupomas]

Hello,

Just to keep the community update on this issue, I got an answer from my hosting provider hostgator which you can find below. In my search I saw that other users have similar issue with other providers http://forum.contao.fr/installation/...-t2926-15.html
I tried the suggested solution (inserting sql tables manually) it seems to work but once I install the modules through the backend it does not work anymore.
Now I am facing with a dilemma ... changing provider or change CMS

Best regards

Massimo

------------------------------
Hello,

Thank you for contacting us!

We have taken a look at the issue and it appears that the problem is due to the SQL syntax and the shared environment of the server. The SQL code which the script attemps to run queries "INFORMATION_SCHEMA" directly, which is rather slow due to the sheer amount of data in this database. It takes longer to query this than the maximum execution time permits, which causes it to fail.

The error message which pointed os in this direction is below:

Fatal error: Uncaught exception Exception with message Query error: Lost connection to MySQL server during query (SELECT * FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` LIKE 'lupomas_csce32' AND `TABLE_NAME` LIKE '%tl_article') thrown in system/modules/core/library/Contao/Database/Statement.php on line 282

The particular parts of interest are "lost connection to mysql server.." and "SELECT * FROM `INFORMATION_SCHEMA`". It times out while attempting to pull that data. It does this because the shared environment of our shared servers causes there to be a rather large amount of data present there.

Unfortunately it appears that the only way to complete the installation would be direct database import without the use of the script. This is because the way the script is configured to run right now is not ideal for our shared services.

Please let us know if you have any other questions or concerns!

Thank you,

[xchs]

Would it work if you do not update all the database tables at once? That is, only one table at a time.

[lupomas]

Would it work if you do not update all the database tables at once? That is, only one table at a time.

No it does not work. Once executed, timeout.

[xchs]

Too bad. Then, I would consider changing the hosting service. Really!

[lupomas]

Too bad. Then, I would consider changing the hosting service. Really!

Yes thats what I will do. I already tested the one proposed in the french threads above. It is working perfectly.
Thanks for your support.

Massimo

[xchs]

Great. And good to hear.