mysql 5.7.9 php7 rc7 can't install

[shabble]

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

Nope.

The NO_ZERO_DATE mode affects whether the server permits '0000-00-00' as a valid date. Its effect also depends on whether strict SQL mode is enabled.

• If this mode is not enabled, '0000-00-00' is permitted and inserts produce no warning.
  
• If this mode is enabled, '0000-00-00' is permitted and inserts produce a warning.
  
• If this mode and strict mode are enabled, '0000-00-00' is not permitted and inserts produce an error, unless IGNORE is given as well. For INSERT IGNORE and UPDATE IGNORE, '0000-00-00' is permitted and inserts produce a warning.

And

As of MySQL 5.7.4, NO_ZERO_DATE is deprecated. In MySQL 5.7.4 through 5.7.7, NO_ZERO_DATE does nothing when named explicitly. Instead, its effect is included in the effects of strict SQL mode. In MySQL 5.7.8 and later, NO_ZERO_DATE does have an effect when named explicitly and is not part of strict mode, as before MySQL 5.7.4. However, it should be used in conjunction with strict mode and is enabled by default. A warning occurs if NO_ZERO_DATE is enabled without also enabling strict mode or vice versa.

Someone's playing The Hokey Cokey with parts of the source code by the looks of it.

[fox]

well he mentioned old database, and posted an error which would be caused by this default value being present (there's no implicit setting last_updated to 0 in the subscribe-to-feed query)

anyway https://tt-rss.org/gitlab/fox/tt-rss/co ... 803641fbb4

[ptsa]

sorry ，My English is very poor indeed
My English is translated by Google

mysql not rc ，it's ga

php7 is rc


this problem

After the error
lock directory
update_daemon-xxxx.lock file has not been removed

My ability is not enough，I do not know how to debug
mybe is php7 bug？
I wait for him GA（2015-11-26）

[fox]

try updating from git first which should hopefully solve your sql problem

as for php 5.7 i can only suggest using stable php versions

[ptsa]

try updating from git first which should hopefully solve your sql problem

as for php 5.7 i can only suggest using stable php versions

Thank you
git
Then I wait stable php versions
I hope that the issue will be ok

[ptsa]

viewtopic.php?f=10&t=3376&start=30#p20113

I found my problem like this

maybe feed is the reason

how can Recording problem feed. than I can find it（Find out why，Delete or...）

They are ALL in(preferences>feeds>feeds with errors)？


Perhaps recorded log to （system>error log） can easily find the problem

[fox]

other than looking at the log and waiting for the process to hang i'm afraid there's no easy way to see this

you can temporarily set max process limit to 1 or use non-forking update daemon (i.e. update.php --feeds) to see which feed is the problematic one

making this easier to debug is on the agenda but who know when that happens