Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: schema.sql bad syntax?  (Read 4389 times)

0 Members and 1 Guest are viewing this topic.

paxlp

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
schema.sql bad syntax?
« on: November 03, 2010, 11:46:52 pm »

Getting this error when attempting to install:

Quote
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 COMMENT='Used to store albums'' at line 22 on query ' CREATE TABLE 111g_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', owner int(11) NOT NULL DEFAULT '1', thumb int(11) NOT NULL default '0', keyword VARCHAR( 50 ), alb_password VARCHAR( 32 ), alb_password_hint TEXT, moderator_group INT NOT NULL default 0, alb_hits INT( 10 ) NOT NULL default 0, PRIMARY KEY (aid), KEY alb_category (category), KEY `moderator_group` (`moderator_group`), KEY `visibility` (`visibility`) ) TYPE=MyISAM COMMENT='Used to store albums''

/usr/local/libexec/mysqld  Ver 5.5.5-m3
PHP 5.2.14 with Suhosin-Patch 0.9.7 (cli) (built: Sep  6 2010 20:40:40)
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
Server version: Apache/2.2.16 (FreeBSD)

Can't figure out what the syntax error is. It's occurring on every table it's trying to create (albums just happens to be the first one in the schema).

Thanks in advance!
« Last Edit: November 04, 2010, 12:14:15 am by Jeff Bailey »
Logged

Nibbler

  • Guest
Re: schema.sql bad syntax?
« Reply #1 on: November 04, 2010, 09:19:52 am »

Remove 'TYPE=MyISAM' from the sql files.
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.