{"id":14651897,"date":"2021-07-12T14:52:13","date_gmt":"2021-07-12T14:52:13","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-error-49\/"},"modified":"2021-07-12T14:52:13","modified_gmt":"2021-07-12T14:52:13","slug":"sql-error-49","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-error-49\/","title":{"rendered":"SQL error?"},"content":{"rendered":"

I commented this on the video slider, so thanks to @richteam for letting me know it was the wrong place!
\n__________________<\/p>\n

Hi,<\/p>\n

I\u2019m getting a 500 error that seems to go back to these (2?) SQL queries from Rich-Web-Slider-Widget.php file. Here are the debug logs:<\/p>\n

[08-Jul-2021 18:51:00 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 1 for query SELECT * FROM wp_ WHERE  = ''  made by require('wp-blog-header.php'), require_once('wp-includes\/template-loader.php'), include('\/themes\/thistheme\/page.php'), get_template_part, locate_template, load_template, require('\/themes\/thistheme\/templates\/content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, Rich_Web_Slider_ID, Rich_Web_Draw_Short_Slider, Rich_Web_Photo_Slider->widget\n\n[08-Jul-2021 18:51:00 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 1 for query SELECT * FROM wp__Loader WHERE  = '' made by require('wp-blog-header.php'), require_once('wp-includes\/template-loader.php'), include('\/themes\/thistheme\/page.php'), get_template_part, locate_template, load_template, require('\/themes\/thistheme\/templates\/content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, Rich_Web_Slider_ID, Rich_Web_Draw_Short_Slider, Rich_Web_Photo_Slider->widget<\/code><\/pre>\n
Help? It seems $query_array[0] is blank, and maybe that\u2019s why it 500\u2019d?<\/p>\n
On further inspection, did one of the updates delete all the photos from the one matching [Rich_Web_Slider id=\u201d1\u2033]?<\/p>\n
In the admin menu, it says it has 4 images, but it doesn\u2019t show any from the edit slider page.<\/p>\n
If I change the slider ID to one that isn\u2019t acting weird, it works. The problem seems to be that Slider ID #1 got screwed up and doesn\u2019t remember it has 4 images.<\/p>\n
Any idea how I can re-map it to the correct images? Thanks!<\/p>\n","protected":false},"template":"","class_list":["post-14651897","topic","type-topic","status-publish","hentry","topic-tag-500-error","topic-tag-sql-error"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14651897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14651897\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=14651897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}