G3 installer SQL's Error

wongsiu

Joined: 2009-10-31
Posts: 15
Posted: Sat, 2009-10-31 04:18

localhost via TCP/IP
MySQL 5.1.37
UTF-8 Unicode (utf8)

Apache/2.2.12 (Win32)
PHP/5.3.0
MySQL: 5.1.37
PHP extension: mysqli

phpMyAdmin: 3.2.0.1

----------------------------------------------------------------

I downloaded gallery-3.0-beta-3.zip. I am trying to create a new forum for my schoolmates.

I created a new database in phpadmin, then ran a gallery SQL. I get the following error message:(also please open attachment)

SQL :

CREATE TABLE {access_caches}(

`id` INT( 9 ) NOT NULL AUTO_INCREMENT ,
`item_id` INT( 9 ) DEFAULT NULL ,
`view_full_1` BINARY( 1 ) NOT NULL DEFAULT '0',
`edit_1` BINARY( 1 ) NOT NULL DEFAULT '0',
`add_1` BINARY( 1 ) NOT NULL DEFAULT '0',
`view_full_2` BINARY( 1 ) NOT NULL DEFAULT '0',
`edit_2` BINARY( 1 ) NOT NULL DEFAULT '0',
`add_2` BINARY( 1 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` )
) AUTO_INCREMENT =2 DEFAULT CHARSET = utf8;

MySQL :

#1064 - 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 '{access_caches} (
`id` int(9) NOT NULL auto_increment,
`item_id` int(9) de' at line 1

Can anyone tell me how to fix?

Thanks,

AttachmentSize
g3error.doc160 KB
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7934
Posted: Sun, 2009-11-01 18:11

You can't run the Gallery SQL directly. The installer will do that for you. Installation is really easy. Just unpack the code (sounds like you've already done that) and then point your web browser at the location where you unpacked it (in your case, something like http://localhost/gallery3).
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git

 
wongsiu

Joined: 2009-10-31
Posts: 15
Posted: Sat, 2009-11-14 17:33

I get it, thanks...