Once I finish the install process - which goessmoothly every time - I get the little green screen - "Go to blog, or go to Admin Panel." As it should be.
But when I click on either, I get this error:
Database Error: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'updated'
SQL: ALTER TABLE anchor_posts
ADD COLUMN updated
DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER created
The error has been logged in /anchor/errors.log
Origin at system/database/connector.php on line 53
I looked around online and found this:
https://stackoverflow.com/questions/4897002/mysql-current-timestamp-on-create-and-on-update#4897134
I don't know anything about databases, but it seems like the problem is CURRENT_TIMESTAMP and mySQL versions. My version is below 5.6 (5.5+). Anchor says that it only requires mySQL 5.2+, so in theory itshould work?
But then again I might be misunderstanding this completely.
Anyone else had this problem? Any suggestions?
Pasting the SQL query manually got me the same result.
Thanks