SQL Syntax Error
-
Hi,
After the most recent update, db errors show up in debug when creating a new gallery. Also, after saving the draft, when I click on Edit Gallery, the dialogue shows the thumbnails of ALL image files. I tried the same in an existing gallery and then the dialogue shows the gallery thumbnails as expected.
[23-Mar-2019 11:49:02 UTC] 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 ')' at line 5 for query SELECT p.ID id, p.post_excerpt caption, m.meta_value meta FROM wp_pqjj_posts p, wp_pqjj_postmeta m WHERE m.meta_key = '_wp_attachment_metadata' AND p.ID = m.post_id AND p.ID IN (,) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Meow_Gallery_Run->preview, Meow_Gallery_Run->gallery, Meow_Tiles_Generator->build, Meow_Gallery_Generator->prepare_data
[23-Mar-2019 11:49:02 UTC] 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 ',,)' at line 5 for query SELECT p.ID id, p.post_excerpt caption, m.meta_value meta FROM wp_pqjj_posts p, wp_pqjj_postmeta m WHERE m.meta_key = '_wp_attachment_metadata' AND p.ID = m.post_id AND p.ID IN (,,,) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Meow_Gallery_Run->preview, Meow_Gallery_Run->gallery, Meow_Tiles_Generator->build, Meow_Gallery_Generator->prepare_data
AND p.ID IN (,,,)
iterates and then further down the list it starts to show the actual p.ID:[23-Mar-2019 11:49:06 UTC] 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 ',,,,)' at line 5 for query SELECT p.ID id, p.post_excerpt caption, m.meta_value meta FROM wp_pqjj_posts p, wp_pqjj_postmeta m WHERE m.meta_key = '_wp_attachment_metadata' AND p.ID = m.post_id AND p.ID IN (,,,,,) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Meow_Gallery_Run->preview, Meow_Gallery_Run->gallery, Meow_Tiles_Generator->build, Meow_Gallery_Generator->prepare_data [23-Mar-2019 11:49:09 UTC] 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 ',,,,,,,,,,,)' at line 5 for query SELECT p.ID id, p.post_excerpt caption, m.meta_value meta FROM wp_pqjj_posts p, wp_pqjj_postmeta m WHERE m.meta_key = '_wp_attachment_metadata' AND p.ID = m.post_id AND p.ID IN (8393,,,,,,,,,,,,,) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Meow_Gallery_Run->preview, Meow_Gallery_Run->gallery, Meow_Tiles_Generator->build, Meow_Gallery_Generator->prepare_data
Viewing 6 replies - 1 through 6 (of 6 total)
Viewing 6 replies - 1 through 6 (of 6 total)
- The topic ‘SQL Syntax Error’ is closed to new replies.