Page 1 of 2

mysql 5.7.9 php7 rc7 can't install

Posted: 17 Nov 2015, 16:06
by ptsa
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'

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 17 Nov 2015, 16:30
by fox
thanks for sharing, op

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 17 Nov 2015, 16:50
by ptsa
it's bug or compatible problem
Hope can quickly repair

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 17 Nov 2015, 17:22
by ptsa
and update_daemon2.php problem

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 17 Nov 2015, 17:43
by shabble
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?

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 17 Nov 2015, 17:54
by ptsa
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.

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 17 Nov 2015, 17:55
by fox
thanks again for sharing your issues with pre-release software with us, op

hopefully someone out there cares

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 17 Nov 2015, 18:26
by ptsa
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

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 18 Nov 2015, 13:32
by ptsa
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

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 18 Nov 2015, 13:46
by shabble
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.

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 18 Nov 2015, 13:52
by ptsa
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??

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 18 Nov 2015, 14:07
by shabble
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.

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 18 Nov 2015, 14:09
by fox
would you please go away already, nobody here gives a shit about mysql in general, let along broken beta versions of it

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 18 Nov 2015, 14:11
by fox
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

Re: mysql 5.7.9 php7 rc7 can't install

Posted: 18 Nov 2015, 14:20
by fox
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)