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

    • 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

          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

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

                Dates

                Created:
                Updated:
                Resolved: