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

Fresh installation, can not import schema.sql

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.0rc4
    • 2.0.0rc5
    • Installation (I)
    • None
    • 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

          duplicates

          Incident report - Incident report ZBX-4866 Installing schema.sql Error 1064 (42000) at line 816

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Incident report - Incident report ZBX-1471 Database upgrade failed because of missing backtick (`) in column names

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: