G3 beta1 Instalation error

foxbox

Joined: 2009-06-09
Posts: 2
Posted: Tue, 2009-06-09 20:48

Hi, month ago i tried to install gallery3 alpha version, but got mysql related errors, so i thought that it is in early stage and soon it'll be fixed. Today i tried againg to install g3 beta and also g3 current from git repo, but still the same problem, which is:

Just after typing mysql info (needed to create mysql structure), got this error:

Failed to create tables in your database: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 '0'', `edit_1` smallint(6) NOT NULL default ''0'', `add_1` smallint(6) NOT NU' at line 4

there are no logs in var/logs/ and i tried to manually execute install.sql in mysql and it worked fine (when i removed { and } from table names).

This is extremely strange for me, couldn't find anybody with same problem. Please tell me what to do ;/

Thanks in advance.

 
foxbox

Joined: 2009-06-09
Posts: 2
Posted: Tue, 2009-06-09 20:57

Okay, i found out what was the problem. Php magic quotes have to be off!

php_flag magic_quotes_gpc Off
php_flag magic_quotes_sybase Off
php_flag magic_quotes_runtime Off

helped.

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Fri, 2009-06-12 08:59

Thanks for the followup! I created this ticket: http://sourceforge.net/apps/trac/gallery/ticket/394
---
Problems? Check gallery3/var/logs before you post! and file bugs here!
Latest zip: http://github.com/gallery/gallery3/zipball/master
Latest git: http://codex.gallery2.org/Gallery:Using_Git