+- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com)
+-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html)
+--- Forum: OpenDocMan Support - Community Based (https://forum.opendocman.com/forum-6.html)
+--- Thread: Post installation issue (/thread-672.html)
Post installation issue - ketil - 02-17-2014
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.
Re: Post installation issue - ketil - 02-17-2014
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.