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

How to run a SET statement (SET block_encryption_mode = ...) without php errors? #967

Closed
GilbertWS opened this issue May 13, 2021 · 0 comments
Closed

How to run a SET statement (SET block_encryption_mode = ...) without php errors? #967

GilbertWS opened this issue May 13, 2021 · 0 comments

Comments

@GilbertWS
Copy link

How to run a SET statement (SET block_encryption_mode = ...)?
I am currently getting a php error "Undefined offset: 0 in /.../MysqliDb.php on line 559, although the statement HAS run successfully.
ThingEngineer added a commit that referenced this issue May 24, 2024
@ThingEngineer
fix: "Undefined offset: 0" for backtick delimiters and address relate…
469666d 
…d issues (#995, #967, #928)

This commit fixes the "Undefined offset: 0" error that occurred in the rawAddPrefix function when using backtick delimiters for table names in SQL queries. It also addresses issues reported in tickets #995, #967, and #928, which were likely related to the same underlying problem with table name identification.

Changes:

Updated the regular expression in rawAddPrefix to match backtick characters (\) as valid delimiters for table names.

This fix ensures that the function correctly identifies and prefixes table names regardless of the delimiter used.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@ThingEngineer @GilbertWS