mysql 5.7.9 php7 rc7 can't install

If you run tt-rss on an officially unsupported platform (shared hosting, Windows, etc.) post here
ptsa
Bear Rating Trainee
Bear Rating Trainee
Posts: 26
Joined: 08 Jul 2015, 05:21

mysql 5.7.9 php7 rc7 can't install

Postby ptsa » 17 Nov 2015, 16:06

mysql 5.7.9 php7 rc7 can't install

can't install database

Initializing database...

Code: Select all

Query create table ttrss_feeds (id integer not null auto_increment primary key,   owner_uid integer not null,   title varchar(200) not null,   cat_id integer default null,   feed_url text not null,   icon_url varchar(250) not null default '',   update_interval integer not null default 0,   purge_interval integer not null default 0,   last_updated datetime default 0,   last_error varchar(250) not null default '',   favicon_avg_color varchar(11) default null,   site_url varchar(250) not null default '',   auth_login varchar(250) not null default '',   auth_pass varchar(250) not null default '',   parent_feed integer default null,   private bool not null default false, rtl_content bool not null default false,   hidden bool not null default false,   include_in_digest boolean not null default true, cache_images boolean not null default false,   hide_images boolean not null default false,   cache_content boolean not null default false,   auth_pass_encrypted boolean not null default false,   last_viewed datetime default null,   last_update_started datetime default null,   always_display_enclosures boolean not null default false,   update_method integer not null default 0, order_id integer not null default 0,   mark_unread_on_update boolean not null default false,   update_on_checksum_change boolean not null default false,   strip_images boolean not null default false,   view_settings varchar(250) not null default '', pubsub_state integer not null default 0,   favicon_last_checked datetime default null,   feed_language varchar(100) not null default '',   foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE,   foreign key (cat_id) references ttrss_feed_categories(id) ON DELETE SET NULL,   foreign key (parent_feed) references ttrss_feeds(id) ON DELETE SET NULL) ENGINE=InnoDB DEFAULT CHARSET=UTF8 failed: Invalid default value for 'last_updated'

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: mysql 5.7.9 php7 rc7 can't install

Postby fox » 17 Nov 2015, 16:30

thanks for sharing, op

ptsa
Bear Rating Trainee
Bear Rating Trainee
Posts: 26
Joined: 08 Jul 2015, 05:21

Re: mysql 5.7.9 php7 rc7 can't install

Postby ptsa » 17 Nov 2015, 16:50

it's bug or compatible problem
Hope can quickly repair

ptsa
Bear Rating Trainee
Bear Rating Trainee
Posts: 26
Joined: 08 Jul 2015, 05:21

Re: mysql 5.7.9 php7 rc7 can't install

Postby ptsa » 17 Nov 2015, 17:22

and update_daemon2.php problem
Attachments
123.jpg
123.jpg (87.27 KiB) Viewed 13619 times

shabble
Bear Rating Trainee
Bear Rating Trainee
Posts: 33
Joined: 18 Mar 2013, 23:40

Re: mysql 5.7.9 php7 rc7 can't install

Postby shabble » 17 Nov 2015, 17:43

ptsa wrote:can't install database


Your brand new and shiny version of MySQL has introduced some backward-compatibility issues.

ptsa wrote:and update_daemon2.php problem


Probably because you don't have a (complete) database for it to work with. How could you expect it to work flawlessly?

ptsa
Bear Rating Trainee
Bear Rating Trainee
Posts: 26
Joined: 08 Jul 2015, 05:21

Re: mysql 5.7.9 php7 rc7 can't install

Postby ptsa » 17 Nov 2015, 17:54

shabble wrote:
ptsa wrote:can't install database


Your brand new and shiny version of MySQL has introduced some backward-compatibility issues.


PostgreSQL (9.1 or newer) or MySQL (InnoDB is required, MyISAM will not work). (as of 2015.08.24 tt-rss is incompatible with mysql 5.7)

wiki say incompatible with mysql 5.7


shabble wrote:
ptsa wrote:and update_daemon2.php problem


Probably because you don't have a (complete) database for it to work with. How could you expect it to work flawlessly?


this Probably have a (complete) database for it to work with.
Attachments
113.jpg
113.jpg (121.69 KiB) Viewed 13532 times
Last edited by sleeper_service on 18 Nov 2015, 22:09, edited 2 times in total.
Reason: fix bad quoting so the comedy is more clear.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: mysql 5.7.9 php7 rc7 can't install

Postby fox » 17 Nov 2015, 17:55

thanks again for sharing your issues with pre-release software with us, op

hopefully someone out there cares

ptsa
Bear Rating Trainee
Bear Rating Trainee
Posts: 26
Joined: 08 Jul 2015, 05:21

Re: mysql 5.7.9 php7 rc7 can't install

Postby ptsa » 17 Nov 2015, 18:26

use old database

Code: Select all

E_USER_ERROR (256)   classes/db/mysqli.php:33   Query INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id, auth_login,auth_pass,update_method,auth_pass_encrypted) VALUES ('1', 'https://tt-rss.org/gitlab/fox/tt-rss.atom', '[Unknown]', NULL, '', 'QES11lfzQUY4/GlL81O+BQ==:Z6X3lyWF74F5kjtpnsdqDA==', 0, true) failed: Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_updated' at row 1   ptsa   23:20
E_WARNING (2)   classes/db/mysqli.php:45   mysqli_num_rows() expects parameter 1 to be mysqli_result, integer given   ptsa   23:07
Attachments
1114.jpg
1114.jpg (22 KiB) Viewed 13372 times

ptsa
Bear Rating Trainee
Bear Rating Trainee
Posts: 26
Joined: 08 Jul 2015, 05:21

Re: mysql 5.7.9 php7 rc7 can't install

Postby ptsa » 18 Nov 2015, 13:32

fox wrote:thanks again for sharing your issues with pre-release software with us, op

hopefully someone out there cares


MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

ttrss DATETIME values is 0000-00-00 00:00:00

shabble
Bear Rating Trainee
Bear Rating Trainee
Posts: 33
Joined: 18 Mar 2013, 23:40

Re: mysql 5.7.9 php7 rc7 can't install

Postby shabble » 18 Nov 2015, 13:46

You've found out what your problem is, why are you still posting?

The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.


Not always.

ptsa
Bear Rating Trainee
Bear Rating Trainee
Posts: 26
Joined: 08 Jul 2015, 05:21

Re: mysql 5.7.9 php7 rc7 can't install

Postby ptsa » 18 Nov 2015, 13:52

shabble wrote:You've found out what your problem is, why are you still posting?

The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.


Not always.



problem is mysql 5.7 DATETIME
The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

ttrss install sql
last_updated datetime default 0, meaning 0000-00-00 00:00:00

if
last_updated datetime default null
maybe ok??

shabble
Bear Rating Trainee
Bear Rating Trainee
Posts: 33
Joined: 18 Mar 2013, 23:40

Re: mysql 5.7.9 php7 rc7 can't install

Postby shabble » 18 Nov 2015, 14:07

problem is mysql 5.7


Exactly. But you keep repeating that, yet fail to do anything about it.

Either use an earlier version, or make the requisite config changes to disable MySQL's breaking behaviour. (Hint: NO_ZERO_DATE.)

if
last_updated datetime default null
maybe ok??


Or not.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: mysql 5.7.9 php7 rc7 can't install

Postby fox » 18 Nov 2015, 14:09

would you please go away already, nobody here gives a shit about mysql in general, let along broken beta versions of it

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: mysql 5.7.9 php7 rc7 can't install

Postby fox » 18 Nov 2015, 14:11

shabble wrote:
problem is mysql 5.7


Exactly. But you keep repeating that, yet fail to do anything about it.


i for one am ready for him to start editing tt-rss schema files and subsequently reporting in broken english various other issues that will inevitably arise

it's going to be a long and painful journey for this entire forum, i'm sure

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: mysql 5.7.9 php7 rc7 can't install

Postby fox » 18 Nov 2015, 14:20

ok so let me get this straight

he updated or something to mysql 5.7-rc which now has ~strict mode~ enabled by default which forbids inserting an integer into datetime column which is a change i have no problem with per se, well overdue imo

only he had a preexisting table with this default value already set and the upgrade script never complained about the table now being in a broken state because it literally has an invalid default value for the column. is this real because holy lol

e: additionally, this is the only place in tt-rss where such a default exists (not sure wtf i was thinking there, it might as well default to null, most likely a copy-paste thing gone wrong)


Return to “Unsupported platforms”

Who is online

Users browsing this forum: No registered users and 1 guest