config_default' doesn't have a default value

[anasri]

I have a webpage which shows a blank page and when I look at proxsql log, I see some entries like this one.

2017-12-12 14:13:49 MySQL_Session.cpp:2763:handler(): [WARNING] Error during query on (0,xxxx.91,3306): 1364, Field 'config_default' doesn't have a default value

Also I have a trouble with some pages that don't show its connects properly, CMS is joomla.

[anasri]

I also get this error when I want to reset my client password in my website. Error during query on (0,xxxxx.91,3306): 1364, Field 'opendate' doesn't have a default value P.S: when I route query to master ( directly) the page shows its contents and password reset works but through proxysql I get those errors.

[renecannao]

Do you have any errors in proxysql error log related to SQL_MODE ? If not, this is probably a client issue, or a database misconfiguration.

[anasri]

No, there is no errors about that, I also tried to enable query logging which gave me the following error in error log. 2017-12-12 14:41:10 Query_Processor.cpp:481:new_query_rule(): [ERROR] Incorrect digest for rule_id 3 : . According to this link https://github.com/sysown/proxysql/wiki/Query-Logging

[renecannao]

I updated the wiki, I see there was some incorrectness.

I don't see any error related to SQL_MODE, therefore most probably either your application or your database are configured incorrectly. Please refer to https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

[anasri]

Thank you dear,

I have two problems right now:

1- the compilation of the eventslog_reader_sample.cpp gives the following error, it seems something is wrong with the MakeFile : Makefile:3: *** missing separator. Stop.

2- I know the second question is beyond your support but maybe you had faced with that When I change database to master's IP in configuration.php file -Joomla- everything works fine but when I use proxysql I get this error in php error log ( also on website).

Warning: require_once(/home/applenic/public_html/libraries/joomla/document/html/renderer/head.php): failed to open stream: No such file or directory in /home/applenic/public_html/templates/nicapplestore/error.php on line 42

Fatal error: require_once(): Failed opening required '/home/xxxxx/public_html/libraries/joomla/document/html/renderer/head.php' (include_path='/home/xxxxx/public_html/plugins/system/shlib/shl_packages//ZendFramework-1.11.7-minimal/library:.:/opt/cpanel/ea-php70/root/usr/share/pear') in /home/xxxxx/public_html/templates/nicapplestore/error.php on line 42

there is no document directory in my server,it's really weird.

I'm gonna ask our developers to figure it out.

[anasri]

@renecannao Thank you dear, Our developers fixed the problem by upgrading joomla and changing public $session_handler = 'none'; to public $session_handler = 'database'; in joomla configuration file For whom has similar issue, should consider about this.