Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-5003

Fresh installation, can not import schema.sql

    Details

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

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                marc.herren Marc Herren
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: