New Clean Installation Failed.

Bernard_J_L

Joined: 2008-06-13
Posts: 10
Posted: Wed, 2009-10-28 18:57

We are not sure of what to make of this. We just started a completely fresh install of Gallery 3 to check it out. The installer stopped after the first screen (where you set the database access information) and provided this error:

Quote:
Oops!
Something unexpected happened and we can't finish your install. We'll try to provide some details about the specific problem below.

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 '-access_caches' at line 1

Any ideas on what this is about?

We are going to try to access the "sql" commands to build the tables manually.

Any advice is appreciated.
 
Bernard_J_L

Joined: 2008-06-13
Posts: 10
Posted: Wed, 2009-10-28 19:05

OK, could this be the problem:

We tried to use a table prefix of "G3-". When we re-installed we used just "G3" and things worked. Is the "-" (dash) not allowed in a prefix name for some reason? If so perhaps check for that on the first screen and not allow it to be entered.

Let us know. Thanks.
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Wed, 2009-10-28 19:37

What version of G3? Grab the latest experimental code:
http://codex.gallery2.org/Gallery3:Upgrading

(I know that's a link for "upgrading" but the steps can be used for grabbing the latest code)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here