{"id":18031713,"date":"2024-09-23T17:28:57","date_gmt":"2024-09-23T17:28:57","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-error-55\/"},"modified":"2024-09-23T17:28:57","modified_gmt":"2024-09-23T17:28:57","slug":"sql-error-55","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-error-55\/","title":{"rendered":"SQL Error"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The first time when the error popped up, I visited the plugins page. There was a notice next to the Namaste plugin stating that it needed to be updated, but the update was not compatible with my version of PHP. I updated PHP to v. 8.1, updated Namaste, but it is still the same. The [namaste-course-lessons 0 0 post_date ASC] shows nothing, while [namaste-enroll] shortcut results in the following:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>WordPress database error:<\/strong>&nbsp;[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 &#8216;ASC&#8217; at line 5]<br \/><code>SELECT * FROM bbb_posts tP JOIN bbb_postmeta tM ON tM.post_id = tP.ID AND tM.meta_key = 'namaste_course' AND tM.meta_value = 4903 WHERE post_type = 'namaste_lesson' AND (post_status='publish' OR post_status='draft') ORDER BY ASC<\/code><\/p>\n","protected":false},"template":"","class_list":["post-18031713","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18031713","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\/18031713\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18031713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}