Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cooluri Typo3 8.7 can't create Tables #74

Open
prdt3e opened this issue Aug 1, 2017 · 1 comment
Open

Cooluri Typo3 8.7 can't create Tables #74

prdt3e opened this issue Aug 1, 2017 · 1 comment

Comments

@prdt3e
Copy link

prdt3e commented Aug 1, 2017

Compare current database with specification says:

CREATE TABLE link_cache (id INT UNSIGNED AUTO_INCREMENT NOT NULL, params BLOB DEFAULT NULL, url VARCHAR(255) DEFAULT NULL, tstamp DATETIME DEFAULT CURRENT_TIMESTAMP, crdatetime DATETIME DEFAULT NULL, sticky SMALLINT UNSIGNED DEFAULT 0, INDEX url (url(255)), INDEX params (params(255)), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB

CREATE TABLE link_oldlinks (id INT UNSIGNED AUTO_INCREMENT NOT NULL, link_id INT UNSIGNED DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT NULL, tstamp DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, sticky SMALLINT UNSIGNED DEFAULT 0, UNIQUE INDEX id (id), INDEX url (url(255)), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB

after execute:
Database update failed
Error: Invalid default value for 'tstamp'

PHP-Version: 5.6.30
Mysql: 5.5.55
Typo3: 8.7.1

Thanks

@prdt3e
Copy link
Author

prdt3e commented Sep 4, 2017

Fix: tstamp timestamp default '0000-00-00 00:00:00'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant