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.

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

SQL error for image with special character #960

Open
Khadreal opened this issue Jan 24, 2025 · 0 comments
Open

SQL error for image with special character #960

Khadreal opened this issue Jan 24, 2025 · 0 comments
Labels
priority: low Issues that can wait type: bug

Comments

@Khadreal
Copy link
Contributor

Before submitting an issue please check that you’ve completed the following steps:

  • Made sure you’re on the latest version => 2.2.4
  • Used the search feature to ensure that the bug hasn’t been reported before

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

  1. Add rocket-test-data folder in wp-content
  2. Upload some images
  3. Install and activate imagify
  4. Active theme (2025) and add rocket-test-data/images in settings of imagify and save /gotobulk
  5. Imagify all
  6. Check the debug.log and you'll see the error
    WordPress database error 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 'high\\'.jpg','{{CONTENT}}/rocket-test-data/images/600px-Mapang-test.gif','{{CONT' at line 1 for query SELECT file_id, folder_id, path, optimization_level, status FROM wp_imagify_files WHERE path IN (

Expected behavior
There shouldn't be any error, image with special character should be process and no error in the debug.log

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
https://wp-media.slack.com/archives/CU0F6EGQ1/p1737720196336289

Acceptance Criteria (for WP Media team use only)
Clear instructions for developers, to be added before the grooming

@Khadreal Khadreal added priority: low Issues that can wait type: bug labels Jan 24, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
priority: low Issues that can wait type: bug
Projects
None yet
Development

No branches or pull requests

1 participant