error loading GalleryItemPropertiesMap.sql

paco

Joined: 2002-09-23
Posts: 1
Posted: Mon, 2002-09-23 03:32

Hi,
I get this message when running setup.php:

"1064: You have an error in your SQL syntax near 'varchar(128),
value text,
UNIQUE KEY (itemId,
key),
IN' at line 9"

I noticed the definition of column "key varchar(128),".
I believe "key" is a reserved word in MySQL.
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Tue, 2002-09-24 09:08

Yes, it is a reserved word. That's why we have a column prefix that we prepend to all columns. The config.php-dist has:

$storeConfig['tablePrefix'] = 'g2_';
$storeConfig['columnPrefix'] = 'g_';

did you take those out of your config.php? If those lines are in your config.php then we may have a bug. Thanks,