Community Support for OpenDocMan (Deprecated)
New Install Error - Printable Version

+- 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