DB config fails during installation

markp

Joined: 2005-05-31
Posts: 1
Posted: Thu, 2009-08-20 16:47

I'm getting stuck after entering the DB connection details. If I specify the table prefix as "gallery3-" I get the following:

Quote:
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 '-users SET `password` = 'kdF912e92eac2cb85e15337047df07e2a591' WHERE `id` = 2' at line 1

If I remove the prefix, I get:

Quote:
Table 'database.users' doesn't exist

Various files are created in /var. If I refresh the installer page, I'm told that I'm ready to use the Gallery - but none of the tables have been created in the DB, so nothing works. The credentials must be correct, as the errors are coming from MySQL.

Any ideas?

Thanks,
Mark
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Thu, 2009-08-20 17:02

Is this a fresh install into a fresh DB?

If you leave the prefix off it looks like there are already tables from either a previous G3 install or some other application.

I don't know if the dash is doing anything I typically name my prefix something like g3_
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
jdr0606

Joined: 2003-01-06
Posts: 63
Posted: Tue, 2009-09-01 01:42

I'm also receiving a similar message and I've tried leaving the prefix off without any change in the result.
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 26107
Posted: Tue, 2009-09-01 06:04

Try a Experimental version:
FAQ: How do I upgrade?

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
 
jdr0606

Joined: 2003-01-06
Posts: 63
Posted: Thu, 2009-09-03 04:06

I used the latest experimental version and the install worked just fine.