8000 updated to fix uses of MySQL reserved words by initinfosec · Pull Request #3264 · forkcms/forkcms · GitHub
[go: up one dir, main page]

Skip to content

updated to fix uses of MySQL reserved words#3264

Merged
carakas merged 1 commit intoforkcms:masterfrom
initinfosec:patch-1
Jan 2, 2021
Merged

updated to fix uses of MySQL reserved words#3264
carakas merged 1 commit intoforkcms:masterfrom
initinfosec:patch-1

Conversation

@initinfosec
Copy link
Contributor
@initinfosec initinfosec commented Dec 23, 2020

Per #3260 (comment) - updated with temporary fix to address issues with mysql reserved words: user(s) and group(s). For now, uses of those table names are just encapsulated in literals e.g. SELECT * from `group`; although it may be better to change the installer code to create DB table prefixes. Creator notes that v6 branch has been refactored and this is a non-issue.

Type

Non critical bugfix

Resolves the following issues

Fixes #3260 in v5

Pull request description

Per #3260 (comment) - updated with temporary fix to address issues with mysql reserved words: user(s) and group(s). For now, uses of those table names are just encapsulated in literals e.g. SELECT * from `group`; although it may be better to change the installer code to create DB table prefixes. Creator notes that v6 branch has been refactored and this is a non-issue.

Per forkcms#3260 (comment) - updated with temporary fix to address issues with mysql reserved words: user(s) and group(s). For now, uses of those table names are just encapsulated in literals e.g. ```SELECT * from `group`;``` although it may be better to change the installer code to create DB table prefixes. Creator notes that v6 branch has been refactored and this is a non-issue.
@codecov
Copy link
codecov bot commented Dec 23, 2020

Codecov Report

Merging #3264 (adb1ad0) into master (f3b36e6) will not change coverage.
The diff coverage is 0.00%.

Impacted file tree graph

@@            Coverage Diff            @@
##             master    #3264   +/-   ##
=========================================
  Coverage     27.79%   27.79%           
  Complexity     8010     8010           
=========================================
  Files           568      568           
  Lines         30564    30564           
=========================================
  Hits           8496     8496           
  Misses        22068    22068           
Flag Coverage Δ Complexity Δ
functional 23.73% <0.00%> (-0.01%) 0.00 <0.00> (ø)
installer 3.86% <0.00%> (+<0.01%) 0.00 <0.00> (ø)
unit 7.63% <0.00%> (-0.01%) 0.00 <0.00> (ø)

Flags with carried forward coverage won't be shown. Click here to find out more.

Impacted Files Coverage Δ Complexity Δ
src/Backend/Modules/Groups/Engine/Model.php 14.51% <0.00%> (ø) 36.00 <0.00> (ø)
src/Common/Core/Init.php 81.81% <0.00%> (-9.10%) 6.00% <0.00%> (ø%)
...le/InstallerBundle/Service/RequirementsChecker.php 78.85% <0.00%> (+0.33%) 34.00% <0.00%> (ø%)

Continue to review full report at Codecov.

Legend - Click here to learn more
Δ = absolute <relative> (impact), ø = not affected, ? = missing data
Powered by Codecov. Last update f3b36e6...adb1ad0. Read the comment docs.

Copy link
Member
@jessedobbelaere jessedobbelaere left a comment

Choose a reason for hiding this comment

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

LGTM 👍 Thanks! 🙌

@carakas carakas added this to the 5.9.3 milestone Jan 2, 2021
@carakas carakas merged commit 2f012b1 into forkcms:master Jan 2, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

user(s) and group(s) are now reserved words in mysql 8.0.1 and beyond.

3 participants

0