September 8, 2017
Recently i've installed kliqqi in a new installed ubuntu box that i had to downgrade it initial PHP version (from 7 to 5) and Percona/MariaDB to Mysql in order to get kliqqi requisites on way.
(Please, take your time but we would like to use to a upgraded, at least, database. I know you are working on it).
So, i suffered one thing in the install that needs your attention. When i followed all the steps solving the easy problems related to libraries, and i got the done screen, i was unable to enter to the install.
After many attempts i decided to dive into the logs and install ..and i discovered this in the install log
Invalid default value for 'create_date' timestamp field
And, in addition, two tables missing in the database (one of them was "users" table, that was the origin of my login failed error). I can't remember any error in front, but, after working on it i discovered that it depends of a issue in the mysql server config, or in the sql that you generate for the install.
You can see the error here:
The way to solve it is easy:
a) check if mysql server (from a fresh install) has the NO ZERO DATE option enabled , or
b) add a null date/default date on every timestamp field that needs it
c) both or them, or any other 🙂
I hope this could help any other user
Fantastic tool, team 🙂
Most Users Ever Online: 27
Currently Browsing this Page:
Adam Burton: 103
Guest Posters: 2
Moderators: Kshitij Kumar, Mthobisi