sql errors on install
|
OleRastus
Joined: 2005-01-27
Posts: 8 |
Posted: Tue, 2012-06-19 19:04
|
|
when trying to install gallery 3.0.4 I get the errors below. I have drop the DB, created a new one, created a new user & password. all with the same results. 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` binary(1) NOT NULL DEFAULT \'0\',`add_1` binary(1) NOT NULL DEFAU' at line 1 my server stats are: PHP 5.3.13 |
|
Posts: 3
I have the same problem on a new host. I've tried to import the sql schema manually:
mysql -p -e "create database gallery_test;"
cd /var/www/html/gallery3/installer
mysql -p gallery_test < install.sql
This gives an error similar to the web based installer.
From a working gallery 3.0.4 I backed up the schema with mysqldump -p gallery3 --no-data -d --compact > g3.sql and copied the g3.sql file in place of the install.sql on the new server.
This produced the same error. However, the install.sql imported fine with mysql -p gallery3 < install.sql
Posts: 3
Fixed this the roundabout way:
Spin up a fresh CentOS virtual machine
Set up Gallery3
Dump the database and tarball it with the web directory
Overwrite the non-working version
The error was limited to the database setup. A running start worked without a hitch
Posts: 8
I did not have time to bother fixing the install script. I installed G2 and was up and running. Been using Gallery for years, I know the Dev's will fix the broken script, I just did not have time to wait or to try and do it myself. thanks for the replies.
OleRastus
Posts: 1
I got the same error message on installation & tried creating a new DB. I'm going to wait too. Hopefully we'll be advised of a fix soon.
_________
Yeti3