Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Fix bug #25665: Type of column for timestamp changed to signed#25667

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 ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Closed
WhiteEagle88 wants to merge2 commits intosymfony:2.7fromWhiteEagle88:fix_25665

Conversation

@WhiteEagle88
Copy link

QA
Branch?2.7
Bug fix?yes
New feature?no
BC breaks?no
Deprecations?no
Tests pass?yes
Fixed tickets#25665
LicenseMIT
Doc PRsymfony/symfony-docs#8966

Fix PDO session timestamp out of range for MySQL

@nicolas-grekas
Copy link
Member

this will not fix the issue for people that already have created the table
can we find a solution that doesn't require a DB migration - ie just tweak the query?

@nicolas-grekas
Copy link
Member

ping@WhiteEagle88 ?

Status: needs work


// delete the session records that have expired
$sql ="DELETE FROM$this->table WHERE$this->lifetimeCol < :time -$this->timeCol";
$sql ="DELETE FROM$this->table WHERE$this->lifetimeCol < :time -CAST($this->timeCol AS SIGNED)";
Copy link
Member

@nicolas-grekasnicolas-grekasJan 21, 2018
edited
Loading

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

would it make sense to just change this to$this->lifetimeCol + $this->timeCol < :time? (thus revert the change on the "create table")

@nicolas-grekas
Copy link
Member

Closing in favor of#25922, thanks for proposing.

Sign up for freeto join this conversation on GitHub. Already have an account?Sign in to comment

Reviewers

@nicolas-grekasnicolas-grekasnicolas-grekas left review comments

Assignees

No one assigned

Projects

None yet

Milestone

2.7

Development

Successfully merging this pull request may close these issues.

4 participants

@WhiteEagle88@nicolas-grekas@xabbuh@carsonbot

[8]ページ先頭

©2009-2025 Movatter.jp