Date: Sat, 14 Jan 2012 06:32:47 GMT From: Edwin Groothuis <edwin@mavetju.org> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/164115: net-mgmt/cacti - cacti.sql does have old fashioned TYPE= statements Message-ID: <201201140632.q0E6Wlfg006800@red.freebsd.org> Resent-Message-ID: <201201140640.q0E6e9Rn051211@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 164115 >Category: ports >Synopsis: net-mgmt/cacti - cacti.sql does have old fashioned TYPE= statements >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Sat Jan 14 06:40:09 UTC 2012 >Closed-Date: >Last-Modified: >Originator: Edwin Groothuis >Release: 9.0RC1 >Organization: - >Environment: [root@freebsd90 /usr/ports/net-mgmt/cacti]# make -V PORTVERSION 0.8.7g >Description: After the installation of Cacti, you are supposed to run mysql to import the schema. # mysql cacti < /usr/local/share/cacti/cacti.sql. ERROR 1064 (42000) at line 5: 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 'TYPE=MyISAM' at line 6 >From various websites: ------------ 8< ------------- The latest versions of MySQL removed support for the 'TYPE=' command. You'll end up with something like this when trying to import cacti.sql: Code: ERROR 1064 (42000) at line 5: 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 'TYPE=MyISAM' at line 6 Replacing 'TYPE=' with 'ENGINE=' (which has been supported for quite a while) will fix this. Note, the default engine in MySQL 5.5 is now InnoDB. ------------ 8< ------------- Consider adding a patch file for it. >How-To-Repeat: >Fix: >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201201140632.q0E6Wlfg006800>