+- 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: MySQL Error at checkin (/thread-180.html)
MySQL Error at checkin - garfield - 02-16-2010
Hi
I am new here - hopa to get help :-)
OpenDocMan is great. Install and use works fine, till to this point...
I try to checkin a document (posted and checkout allready)
In checkin dialog I get the following error after selecting the file and pressing "Check Document In":
Error in query: UPDATE odm_log set revision={(1 - 1)} WHERE id = 2 and revision = 'current'. 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 '(1 - 1)} WHERE id = 2 and revision = 'current'' at line 1
Seams that I just have a problem while writeing someting in the logfile - but program stops and files is not checked in ...
Knows someone a hint?
Thanks in advance.
Marco
Re: MySQL Error at checkin - Stephen - 02-17-2010
Thanks for reporting the issue. I have listed a patch to fix it here:
<!-- l --><a class="postlink-local" href="http://www.opendocman.com/forum/viewtopic.php?f=8&t=186">viewtopic.php?f=8&t=186</a><!-- l -->
Re: MySQL Error at checkin - garfield - 02-18-2010
Thanks for you fast support - works fine now!
Marco