Community Support for OpenDocMan (Deprecated)
MySQL Error at checkin - Printable Version

+- Community Support for OpenDocMan (Deprecated) (
+-- Forum: OpenDocMan Community Discussion (
+--- Forum: OpenDocMan Support - Community Based (
+--- Thread: MySQL Error at checkin (/thread-180.html)

MySQL Error at checkin - garfield - 02-16-2010


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.

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="">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!