+- 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: New Install Error (/thread-733.html)
New Install Error - fargo - 09-21-2014
Hi Guys
Trying to install the latest version, but I keep getting the same error:
Quote:Checking that templates_c folder is writeable... OK
installing...
Database Created
Database Selected
Could not create odm_access_log table. Error was:You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `action` enum('A','B','C','V','' at line 5
Quote:SQL query:
# MySQL dump of OpenDocMan
#
#--------------------------------------------------------
#
# Table structure for table 'odm_access_log'
#
CREATE TABLE `odm_access_log` (
`file_id` INT( 11 ) NOT NULL ,
`user_id` INT( 11 ) NOT NULL ,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`action` ENUM( 'A', 'B', 'C', 'V', 'D', 'M', 'X', 'I', 'O', 'Y', 'R' ) NOT NULL
) ENGINE = MYISAM
MySQL said: Documentation
#1064 - You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`action` enum('A','B','C','V',' at line 12
This also happens with the last version.
I have tried the install-procedure and also running the database.sql directly on the MySQL server, no luck.
Can anybody point me in the right direction?
Thanks
RE: New Install Error - adminla - 09-25-2014
What version of MySQL are you using?
(09-21-2014, 08:37 AM)fargo Wrote: Hi Guys
Trying to install the latest version, but I keep getting the same error:
Quote:Checking that templates_c folder is writeable... OK
installing...
Database Created
Database Selected
Could not create odm_access_log table. Error was:You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `action` enum('A','B','C','V','' at line 5
Quote:SQL query:
# MySQL dump of OpenDocMan
#
#--------------------------------------------------------
#
# Table structure for table 'odm_access_log'
#
CREATE TABLE `odm_access_log` (
`file_id` INT( 11 ) NOT NULL ,
`user_id` INT( 11 ) NOT NULL ,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`action` ENUM( 'A', 'B', 'C', 'V', 'D', 'M', 'X', 'I', 'O', 'Y', 'R' ) NOT NULL
) ENGINE = MYISAM
MySQL said: Documentation
#1064 - You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`action` enum('A','B','C','V',' at line 12
This also happens with the last version.
I have tried the install-procedure and also running the database.sql directly on the MySQL server, no luck.
Can anybody point me in the right direction?
Thanks