Location: Forum Index > Sharing & Voicing > People's Say (Forum ID: 14)
Description of Issue:
When posting a reply in this section, a MariaDB syntax error occurs. While the post does successfully save inside the thread, the thread is not being "bumped" to the top of the Recent Posts list. The forum index still shows the previous user and timestamp as the "Last Post."
Error Message:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE forum_id = 14' at line 1
UPDATE msf_forums SET forum_last_post_id = WHERE forum_id = 14
Impact:
Because the forum_last_post_id is failing to update, new activity in the "People's Say" section is invisible on the main forum index and "Recent Posts" feed.
Check Variable Assignment: Locate the code responsible for updating the msf_forums table after a post is saved. Ensure the variable (e.g., $new_post_id) is correctly captured from the database's "insert id" before the update query is run.
Add a Conditional Check: Wrap the update query in a simple if statement so it only runs if the ID is not empty.
Logic: if (post_id is not empty)
run UPDATE msf_forums ...
Database Sync: Once the code is fixed, the "People's Say" (ID: 14) statistics may need a manual "Resync" from the Admin Control Panel to show the correct latest post.
You are here: Forum Index » Extra » Help & Support [BUG] "People's Say" section not updating in Recent Posts (SQL Error)
###
Award Rep
Award reps to ... for this post
This cannot be undone and I am sure it will be greatly appreciated.
We apologise but you have been denied access to report posts in this thread. This could be due to excessively reporting posts and not understanding our forum rules. For assistance or information, please use the forum help thread to request more information. Jazakallah
