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.

Sign up for GitHub

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

Jump to bottom

MySQL8 でインストールができない #2556

Closed
nanasess opened this issue Oct 12, 2017 · 3 comments
Closed

MySQL8 でインストールができない #2556

nanasess opened this issue Oct 12, 2017 · 3 comments
Labels
enhancement 機能追加
Milestone
4.0

Comments

@nanasess
Copy link
Contributor

概要(Overview)

MySQL8 でインストールができない

以下のようなエラーでインストールができない

PHP Fatal error:  Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank SMALLINT UNSIGNED NOT NULL, news_title VARCHAR(255) NOT NULL, news_comment ' at line 1 in /Users/nanasess/git-repos/ec-cube/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104

RANK() 関数ができたため、 カラム名に rank を使用する場合は引用符が必要となった
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-2.html#mysqld-8-0-2-optimizer

期待する内容(Expect) or 要望 (Requirement)

MySQL8 でインストールができる

再現手順(Procedure)

MySQL8 でインストールする

環境 (environment)

  • EC-CUBE: master
  • PHP: 7.1.8
  • DB: MySQL8.0.3-RC
@t-nagahashi t-nagahashi added this to the 3.0.16 milestone Oct 12, 2017
@t-nagahashi t-nagahashi added enhancement 機能追加 and removed enhancement 機能追加 labels Oct 12, 2017
@Yangsin Yangsin added the enhancement 機能追加 label Oct 12, 2017
@t-nagahashi t-nagahashi modified the milestones: 3.0.16, 3.n.0 Oct 12, 2017
@t-nagahashi
Copy link
Contributor

t-nagahashi commented Oct 12, 2017 •
edited
Loading

3.n.0で検討します。

@nanasess
Copy link
Contributor Author

https://travis-ci.org/nanasess/ec-cube/builds/287340411
PHP7, 7.1 では、 rank を position に変更することで、テストが通るのを確認できました。
5.6 はダメみたいです。

https://bugs.php.net/bug.php?id=74461
https://bugs.mysql.com/bug.php?id=85946

@nanasess nanasess mentioned this issue Oct 14, 2017
Merged
@okazy
Copy link
Contributor

okazy commented Sep 12, 2018

対応済

@okazy okazy closed this as completed Sep 12, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement 機能追加
Projects
None yet
Milestone
4.0
Development

No branches or pull requests
4 participants
@nanasess @Yangsin @t-nagahashi @okazy