I am trying to install Umbraco 7.5.8 with a MySql db 5.5 but am getting the following error.
ERROR: The database configuration failed with the following message: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
I am also facing the same issue, 3 of umbraco tables have 2 timestamp columns with default value current timestamp, for e.g. umbracoAccess table have createDate and updateDate with default value current timestamp. it is not allowed in mysql 5.5
I changed createdDate column default value to '0000-00-00 00:00:00' to solve this issue. It still works on my local environment but when i deploy it on godaddy, site starts redirecting to /umbraco/authorizeupgrade and then login but login also do not work.
If someone successfully ran umbraco with mysql 5.5 it would be helpful as godaddy do not support mysql 5.6 as of now.
Hello Victor,
What is your problem? Is it related to the lower case of MySQL Server tables?
Here in Brazil I had problems with hosts that could not change this global configuration. My output will handle the Umbraco source code. As I have described here:
Cannot install on MySql
Hi
I am trying to install Umbraco 7.5.8 with a MySql db 5.5 but am getting the following error.
ERROR: The database configuration failed with the following message: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Has anyone been able to get around this?
Thanks
Hi David,
Unfortunately umbraco is incompatible with MySQL in many situations. Your problem may be related to one I had:
https://our.umbraco.org/forum/getting-started/installing-umbraco/56448-Installing-Umbraco-71-with-a-MySQLLinux-backend-db#comment-265053
Thanks, but I'm not getting the erros about table name case I can't even install in the first place because of the CURRENT_TIMESTAMP error.
Umbraco docs say that MySql 5 or higher should work.
I am also facing the same issue, 3 of umbraco tables have 2 timestamp columns with default value current timestamp, for e.g. umbracoAccess table have createDate and updateDate with default value current timestamp. it is not allowed in mysql 5.5
I changed createdDate column default value to '0000-00-00 00:00:00' to solve this issue. It still works on my local environment but when i deploy it on godaddy, site starts redirecting to /umbraco/authorizeupgrade and then login but login also do not work.
If someone successfully ran umbraco with mysql 5.5 it would be helpful as godaddy do not support mysql 5.6 as of now.
Does anyone have an update on this? I'm having the same problem with Umbraco 7.7.7 and MySQL 5.1
Hello Victor, What is your problem? Is it related to the lower case of MySQL Server tables?
Here in Brazil I had problems with hosts that could not change this global configuration. My output will handle the Umbraco source code. As I have described here:
https://our.umbraco.org/forum/getting-started/installing-umbraco/56448-Installing-Umbraco-71-with-a-MySQLLinux-backend-db#comment-265053
is working on a reply...