Jump to content
  • 0

Freebds 9.2 & Mysql 5.6 item creat


Tasho

Question

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

4 answers to this question

Recommended Posts

  • 0

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
  • 0
  • VIP

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

  • Love 1

 

 

Link to comment
  • 0

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.