Community Support for OpenDocMan (Deprecated)

Hi

After a New install, I tried to login, but received the following error:

Error in query: SELECT 4343424-dms.odm_user.username FROM 4343424-dms.odm_user WHERE 4343424-dms.odm_user.id = 1You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '4343424-dms.odm_user WHERE 4343424-dms.odm_user.id = 1' at line 1

I'm running my software on PHP 5.3 With MySQL 5.3.

How can I make the system available?

4343424-dms is the schema instance, and is correct. The same Query will work correctly if scheme is selected, and name removed from the Select Query.

I've found the solution, and it is a known error caused by '-' within the database name.

The quick-and-dirty solution is described here: <!-- l --><a class="postlink-local" href="http://www.opendocman.com/forum/viewtopic.php?f=4&t=665">viewtopic.php?f=4&t=665</a><!-- l -->

Hope this helps someone.