|
From: Sorin S. <Sor...@or...> - 2015-11-30 10:39:39
|
Hi all, I inherited an ancient Ambit2-appliance running off of a virtualised instance of Linux Mint 13, aka Maya. A few hours ago I set out to update Ambit to run off of our standard virtualised Linux environment by using CentOS 6.7 x64. I found and used the guide available on http://ambit.sourceforge.net/install_ambitrest.html. Managed to install Java, Tomcat and MySQL, and all three work properly. Next step was to use the script on the above link, and I immediately ran into some problems. Please note that my sql-proficency is pretty basic at best, I can list databases, drop them etc., therefore the below error put me pretty much out of my league. Some google searches later I learned that I can't use the same time stamps or something to that effect. root@ambit ~/ [0]# mysql ambit2 -u root -p < ~/Downloads/create_tables.sql Enter password: ERROR 1293 (HY000) at line 240: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause root@ambit ~/ [0]# Seems it's the two lines in the "bundle"-table that are the culprits. `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, ... `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, However, I've no idea how to go about this. Could somebody with more knowledge please give me a hint to a fix, or maybe suggest some further reading in order to fix this? Thanks. -- BW, Sorin ----------------------------------------------------------- # Sorin Srbu, Sysadmin # Uppsala University # Dept of Medicinal Chemistry # Div of Org Pharm Chem # Box 574 # SE-75123 Uppsala # Sweden# # Phone: +46 (0)18-4714482 # Visit: BMC, Husargatan 3, D5:512b # Web: http://www.orgfarm.uu.se ----------------------------------------------------------- # () ASCII ribbon campaign - Against html E-mail # /\ # # This message was not sent from an iProduct! # # Please consider the environment before printing this email. # Join the campaign at http://thinkBeforePrinting.org # # MotD follows: # Hospitality: Making your guests feel at home, even though you wish they were. |