When I add records or any values I have this message: "incorrect integer value: for column 'count' at row 1" - LabCollector

Search Knowledge Base by Keyword

When I add records or any values I have this message: “incorrect integer value: for column ‘count’ at row 1”

You are here:
← All Topics

With recent MySQL, the configuration is restrictive by default.

Find the following line in my.cnf/my.ini:

sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

Now, comment it out with # and restart your MySQL server.