Fresh installation, can not import schema.sql

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Major
    • 2.0.0rc5
    • Affects Version/s: 2.0.0rc4
    • Component/s: Installation (I)
    • None
    • Environment:
      mysql Ver 14.12 Distrib 5.0.67, for suse-linux-gnu (x86_64) using readline 5.2

      ejpdxt4040:/var/tmp/zabbix-2.0.0rc4 # mysql -uzabbix -pzabbix zabbixtest < database/mysql/schema.sql
      ERROR 1064 (42000) at line 816: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

      Modified database/mysql/schema.sql line 821 from

      exp_delimiter varchar(1) DEFAULT '' NOT NULL,

      to

      `exp_delimiter` varchar(1) DEFAULT '' NOT NULL,

      and could succesfully import it

            Assignee:
            Unassigned
            Reporter:
            Marc Herren
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: