From owner-freebsd-bugs@FreeBSD.ORG Thu Sep 20 04:20:06 2012 Return-Path: Delivered-To: freebsd-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 9DC7C106566B for ; Thu, 20 Sep 2012 04:20:06 +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 5941E8FC15 for ; Thu, 20 Sep 2012 04:20:06 +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 q8K4K68X038179 for ; Thu, 20 Sep 2012 04:20:06 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.5/8.14.5/Submit) id q8K4K614038178; Thu, 20 Sep 2012 04:20:06 GMT (envelope-from gnats) Resent-Date: Thu, 20 Sep 2012 04:20:06 GMT Resent-Message-Id: <201209200420.q8K4K614038178@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Imil Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id AD9C3106566C for ; Thu, 20 Sep 2012 04:17:49 +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 994308FC0C for ; Thu, 20 Sep 2012 04:17:49 +0000 (UTC) Received: from red.freebsd.org (localhost [127.0.0.1]) by red.freebsd.org (8.14.5/8.14.5) with ESMTP id q8K4Hmt2025565 for ; Thu, 20 Sep 2012 04:17:48 GMT (envelope-from nobody@red.freebsd.org) Received: (from nobody@localhost) by red.freebsd.org (8.14.5/8.14.5/Submit) id q8K4HmsS025564; Thu, 20 Sep 2012 04:17:48 GMT (envelope-from nobody) Message-Id: <201209200417.q8K4HmsS025564@red.freebsd.org> Date: Thu, 20 Sep 2012 04:17:48 GMT From: Imil To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: misc/171801: Problem with creating MySQL database from squid_db.sql. X-BeenThere: freebsd-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Sep 2012 04:20:06 -0000 >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 root@almeida.cse.buffalo.edu:/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: