Tasho 244 Posted May 8, 2014 Share Posted May 8, 2014 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? Link to comment Share on other sites More sharing options...
Premium Solution Shogun 4608 Posted May 8, 2014 Premium Solution Share Posted May 8, 2014 ee /etc/my.cnf Paste this: sql_mode="" Then restart: service mysql-server restart 1 Link to comment Share on other sites More sharing options...
Tasho 244 Posted May 8, 2014 Author Share Posted May 8, 2014 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 Link to comment Share on other sites More sharing options...
Premium Shogun 4608 Posted May 8, 2014 Premium Share Posted May 8, 2014 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 1 Link to comment Share on other sites More sharing options...
Tasho 244 Posted May 8, 2014 Author Share Posted May 8, 2014 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now