#1 2016-05-08 15:22:59

acapavia
Member
Registered: 2012-05-07
Posts: 7

Error Call to a member function field_data() on boolean

In the installation process, after set database credentials, I'm getting this error

Call to a member function field_data() on boolean...   database/DB_driver.php on line 891

I changed the value db_debug to TRUE to see what is going on in the query but the pocess updated to FALSE automatically so I can't see the database error

Any ideas

Last edited by acapavia (2016-05-08 15:24:57)

Offline

#2 2016-05-08 15:59:17

acapavia
Member
Registered: 2012-05-07
Posts: 7

Re: Error Call to a member function field_data() on boolean

Here is the issue, I cannot create this field with default value '0000-00-00 00:00:00'

created datetime NOT NULL DEFAULT '0000-00-00 00:00:00'

[Err] 1067 - Invalid default value for 'created'

Offline

#3 2016-05-10 01:36:11

acapavia
Member
Registered: 2012-05-07
Posts: 7

Re: Error Call to a member function field_data() on boolean

Finally I get what's really the issue. I have Mysql 5.7.12 version installed in my server. This new version does not allow insert fields type datetime with this format '0000-00-00 00:00:00'. but it seems they are a bunch of things different that this version are not compatible with Ionize cms installation.

Here I give you some examples

sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

The mode STRICT_TRANS_TABLES does not allow datetime with this format '0000-00-00 00:00:00'
and ONLY_FULL_GROUP_BY gives this error when installation process is trying to create the table article


[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

If someone can help me with this I'll appreciate it A LOT!

Last edited by acapavia (2016-05-10 01:38:07)

Offline

What's Ionize ?

Ionize is an Open Source Content Management System created by webdesigners for webdesigners.

Created and maintained by Partikule and Toopixel, Ionize wants to be the easiest and most powerful CMS.

Can I help ?

Because talent is nothing without involvement, we are looking for motivated coders and webdesigners to join the project team.

Resources

Website : ionizecms.com
Documentation : doc.ionizecms.com

Development : Ionize on GitHub
Translations : Ionize Translations