Missing users table | Support | Forum

Please consider registering


— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_TopicIcon
Missing users table
Forum Posts: 3
Member Since:
September 8, 2017
sp_UserOfflineSmall Offline
September 8, 2017 - 9:19 am
sp_Permalink sp_Print

Hi team,
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 🙂

Forum Posts: 3
Member Since:
September 8, 2017
sp_UserOfflineSmall Offline
September 25, 2017 - 2:41 pm
sp_Permalink sp_Print

Hi team,
Are you there?

Forum Timezone: America/New_York

Most Users Ever Online: 49

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Adam Burton: 103

DrCrash: 74

cyrus: 60

lipsmega: 50

OxyThemes: 36

Newest Members:

Desmond Doe

Abhishek Lavaniya

Marios Frixou


Nathan Moloto




Monica White


Forum Stats:

Groups: 1

Forums: 8

Topics: 386

Posts: 1813


Member Stats:

Guest Posters: 2

Members: 1295

Moderators: 2

Admins: 1

Administrators: ChuckRoast

Moderators: Kshitij Kumar, Mthobisi