Missing users table | Support | Forum

Please consider registering
Guest

Search

— 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
cbote
New Member
Members
Forum Posts: 1
Member Since:
September 8, 2017
sp_UserOfflineSmall Offline
1
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:
https://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field

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 Timezone: America/New_York

Most Users Ever Online: 27

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Adam Burton: 103

DrCrash: 74

cyrus: 60

lipsmega: 46

OxyThemes: 36

Newest Members:

RapiChat Micro Blog

kabir

geronimo651

Colin

Ricky Sechler

houseremovals

Mark Fisher

Purplescoops

Ashu

Pradeep Kumar

Forum Stats:

Groups: 1

Forums: 8

Topics: 314

Posts: 1718

 

Member Stats:

Guest Posters: 2

Members: 1160

Moderators: 2

Admins: 1

Administrators: ChuckRoast

Moderators: Kshitij Kumar, Mthobisi