>Number: 171801 >Category: misc >Synopsis: Problem with creating MySQL database from squid_db.sql. >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Thu Sep 20 04:20:05 UTC 2012 >Closed-Date: >Last-Modified: >Originator: Imil >Release: FreeBSD 8.0-RELEASE >Organization: >Environment: FreeBSD test.local 8.0-RELEASE FreeBSD 8.0-RELEASE #0: Sat Nov 21 15:48:17 UTC 2009 [email protected]:/usr/obj/usr/src/sys/GENERIC i386
>Description: I install /usr/ports/www/sams and /usr/ports/databases/mysql55-server/ . This problem appear with creating MySQL databases from /usr/local/share/sams/data/sams_db.sql . I enter "http://[My_IP_address]/sams/install.php"; in web-browser address string. Next, I press [Create Database] button in web-page. And get some messages: SAMS installations File squid_db.sql opened Please wait, database createst may take up to 30 minutes........ ERROR: line 6: query:[ CREATE TABLE `cache` ( `date` date, `time` time, `user` char(25), `domain` char(25), `size` BIGINT UNSIGNED NULL, `ipaddr` char(15) NOT NULL, `period` BIGINT UNSIGNED NULL, `url` char(100) NOT NULL, `hit` BIGINT UNSIGNED NULL, `method` char(15) NOT NULL ) TYPE=MyISAM] failed mysql error: 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 12 (err:1064) >How-To-Repeat: >Fix: >Release-Note: >Audit-Trail: >Unformatted: _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-bugs To unsubscribe, send any mail to "[email protected]"
