Skip site navigation (1)Skip section navigation (2)
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>