Mike G. Posted October 20, 2023 Share Posted October 20, 2023 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. Link to comment Share on other sites More sharing options...
Marc Posted October 20, 2023 Share Posted October 20, 2023 Thank you for letting us know. This is one we are aware of, and have resolved in the next beta Link to comment Share on other sites More sharing options...
Mike G. Posted October 20, 2023 Author Share Posted October 20, 2023 2 minutes ago, Marc Stridgen said: 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! 🤘 Link to comment Share on other sites More sharing options...
teraßyte Posted October 20, 2023 Share Posted October 20, 2023 7 minutes ago, FanClub Mike said: 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. Mike G. 1 Link to comment Share on other sites More sharing options...
Stuart Silvester Posted October 20, 2023 Share Posted October 20, 2023 Edit the Pages database and select 'inherit' for the new 'comments per page' setting. This will solve the issue. Mike G., SeNioR- and SoloInter 2 1 Link to comment Share on other sites More sharing options...
Mike G. Posted October 20, 2023 Author Share Posted October 20, 2023 4 minutes ago, Stuart Silvester said: 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 Stuart Silvester 1 Link to comment Share on other sites More sharing options...
CheersnGears Posted October 20, 2023 Share Posted October 20, 2023 6 hours ago, Stuart Silvester said: 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. Link to comment Share on other sites More sharing options...
SoloInter Posted October 21, 2023 Share Posted October 21, 2023 16 hours ago, Stuart Silvester said: Edit the Pages database and select 'inherit' for the new 'comments per page' setting. This will solve the issue. perfect thanks Link to comment Share on other sites More sharing options...
Stuart Silvester Posted October 21, 2023 Share Posted October 21, 2023 10 hours ago, CheersnGears said: I'm not finding this setting, but I'm getting the error. Pages > Databases > Edit > Options Tab > Scroll to 'Field Options' > Comments per page CheersnGears and SeNioR- 1 1 Link to comment Share on other sites More sharing options...
CheersnGears Posted October 21, 2023 Share Posted October 21, 2023 6 hours ago, Stuart Silvester said: Pages > Databases > Edit > Options Tab > Scroll to 'Field Options' > Comments per page Thanks, got it! Stuart Silvester 1 Link to comment Share on other sites More sharing options...
Recommended Posts