From owner-freebsd-ports-bugs@FreeBSD.ORG Sat Jan 14 06:40:09 2012 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id CA1EA106564A for ; Sat, 14 Jan 2012 06:40:09 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 8C3048FC0C for ; Sat, 14 Jan 2012 06:40:09 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id q0E6e9xg051212 for ; Sat, 14 Jan 2012 06:40:09 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.5/8.14.5/Submit) id q0E6e9Rn051211; Sat, 14 Jan 2012 06:40:09 GMT (envelope-from gnats) Resent-Date: Sat, 14 Jan 2012 06:40:09 GMT Resent-Message-Id: <201201140640.q0E6e9Rn051211@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Edwin Groothuis Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id C140C1065670 for ; Sat, 14 Jan 2012 06:32:47 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from red.freebsd.org (red.freebsd.org [IPv6:2001:4f8:fff6::22]) by mx1.freebsd.org (Postfix) with ESMTP id B063F8FC08 for ; Sat, 14 Jan 2012 06:32:47 +0000 (UTC) Received: from red.freebsd.org (localhost [127.0.0.1]) by red.freebsd.org (8.14.4/8.14.4) with ESMTP id q0E6WlbA006801 for ; Sat, 14 Jan 2012 06:32:47 GMT (envelope-from nobody@red.freebsd.org) Received: (from nobody@localhost) by red.freebsd.org (8.14.4/8.14.4/Submit) id q0E6Wlfg006800; Sat, 14 Jan 2012 06:32:47 GMT (envelope-from nobody) Message-Id: <201201140632.q0E6Wlfg006800@red.freebsd.org> Date: Sat, 14 Jan 2012 06:32:47 GMT From: Edwin Groothuis To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/164115: net-mgmt/cacti - cacti.sql does have old fashioned TYPE= statements X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 14 Jan 2012 06:40:09 -0000 >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: