Freebds 9.2 & Mysql 5.6 item creat

[Tasho 275]

Hi devs, I have a problem when I want to creat a item with Admin pannel (site) ... I have this error:

Incorrect integer value: '' for column 'attrvalue0' at row 1

On frebds 8.2 I didn't have this error ...

 

 

What can I do?

[Shogun 5755]

ee /etc/my.cnf

 

Paste this:

sql_mode=""

Then restart:

 

service mysql-server restart

[Tasho 275]

my conf is in temp/ -- i don`t think this is a problem ... I`ve edited like this :

[mysqld]
sql_mode=""
max_connections = 4000
max_connect_errors=20000
query_cache_type=1
query_cache_limit=20M
query_cache_size=256M
log-slow-queries=slow.log
long_query_time=2

still : Incorrect integer value: '' for column 'attrvalue0' at row 1

[Shogun 5755]

mysql reads the config from /etc/my.cnf or /var/db/mysql/my.cnf not from temp

 

Also 4000 max connections is crazy like 20000 connect errors

[Tasho 275]

mysql reads the config from /etc/my.cnf or /var/db/mysql/my.cnf not from temp

 

Also 4000 max connections is crazy like 20000 connect errors

 

yah your right ... my.conf was running from /usr/db/mysql ... I've added 

sql_mode="" and it is working.

 

Thank you so much.