Ad Widget

Collapse

string storage in database (1.3.3)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • medic
    Member
    • Feb 2007
    • 58

    #1

    string storage in database (1.3.3)

    Sorry, i am sure i am bugging now:

    mysql> explain history_text;
    +--------+---------------------+------+-----+---------+-------+
    | Field | Type | Null | Key | Default | Extra |
    +--------+---------------------+------+-----+---------+-------+
    | id | bigint(20) unsigned | NO | PRI | 0 | |

    shouldn't id maybe be auto-increment ?
    because the server is trying to insert without giving ID field, which means it's null and cannot insert because of duplicate (primary uniq) key ..

    best regards
    Andreas

    P.S.: and thank you for being so patient with me
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    No, it shouldn't be auto incerement. Thanks for reporting this.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • Alexei
      Founder, CEO
      Zabbix Certified Trainer
      Zabbix Certified SpecialistZabbix Certified Professional
      • Sep 2004
      • 5654

      #3
      The issue has been fixed.
      Alexei Vladishev
      Creator of Zabbix, Product manager
      New York | Tokyo | Riga
      My Twitter

      Comment

      Working...