[ZBX-6936] insert into mysql 5.6 table failed because TEXT columns cannot be assigned a default value Created: 2013 Aug 29 Updated: 2017 May 30 Resolved: 2013 Sep 03 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Proxy (P) |
Affects Version/s: | 2.0.8 |
Fix Version/s: | 2.0.9rc1, 2.1.4 |
Type: | Incident report | Priority: | Critical |
Reporter: | Eugene Turovsky | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | mysql | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
linux, MySQL-server-5.6.13 |
Description |
I try create new item on proxy host with mysql database 5.6.13 (zabbix-proxy 2.0.8). Item don't have field 'Description'. Log error on proxy: This work on 5.1 database, but on MySQL 5.6 TEXT columns cannot be assigned a default value, that is if insert don't have 'description' column in statement, query is failed.
|
Comments |
Comment by Alexander Vladishev [ 2013 Aug 30 ] |
I confirm the issue. |
Comment by Alexander Vladishev [ 2013 Sep 02 ] |
Fixed in the development branches:
|
Comment by Andris Zeila [ 2013 Sep 02 ] |
Successfully tested |
Comment by Alexander Vladishev [ 2013 Sep 02 ] |
Fixed in pre-2.0.9 r38274 and pre-2.1.4 (trunk) r38275. |