Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted October 20, 20231 yr Hey everyone. I updated to the recent Beta and started receiving an error on all of my page articles Example Page: https://www.fanclubs.org/articles/entertainment/movies/movies-like-the-town/ Beginning of the log: Quote SELECT cms_database_comments.*, author.* FROM `cms_database_comments` LEFT JOIN `core_members` AS `author` ON author.member_id = cms_database_comments.comment_user WHERE cms_database_comments.comment_record_id=466 AND cms_database_comments.comment_approved!=-2 AND cms_database_comments.comment_approved!=-3 AND comment_database_id=2 ORDER BY comment_date asc LIMIT 0,-1 IPS\Db\Exception: 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 '-1' at line 1 (1064) Outside of disabling plugins and applications and clearing the cache, I'm not sure what else to try. I appreciate any help anyone can provide. Thank you.
October 20, 20231 yr Community Expert Thank you for letting us know. This is one we are aware of, and have resolved in the next beta
October 20, 20231 yr Author Thank you for letting us know. This is one we are aware of, and have resolved in the next beta I was hoping that was the case and it wasn't anything on my end. Thank you for the update! One other question if you don't mind. Would re-uploading the files from the stable version be the correct method to roll back? Thanks again! 🤘
October 20, 20231 yr Community Expert Would re-uploading the files from the stable version be the correct method to roll back? No, the only way to roll back is to restore a backup made before the upgrade.
October 20, 20231 yr Community Expert Edit the Pages database and select 'inherit' for the new 'comments per page' setting. This will solve the issue.
October 20, 20231 yr Author Edit the Pages database and select 'inherit' for the new 'comments per page' setting. This will solve the issue. Thank you for sharing the fix, @Stuart Silvester
October 20, 20231 yr Edit the Pages database and select 'inherit' for the new 'comments per page' setting. This will solve the issue. I'm not finding this setting, but I'm getting the error.
October 21, 20231 yr Edit the Pages database and select 'inherit' for the new 'comments per page' setting. This will solve the issue. perfect thanks
October 21, 20231 yr Community Expert I'm not finding this setting, but I'm getting the error. Pages > Databases > Edit > Options Tab > Scroll to 'Field Options' > Comments per page
October 21, 20231 yr Pages > Databases > Edit > Options Tab > Scroll to 'Field Options' > Comments per page Thanks, got it!
