Afrodude Posted February 17, 2023 Posted February 17, 2023 (edited) @Adriano Faria is this available in version 1.2.0 ? Because I cannot find or see how to enable it anywhere. Edited February 17, 2023 by Afrodude
Adriano Faria Posted February 17, 2023 Author Posted February 17, 2023 19 minutes ago, Afrodude said: @Adriano Faria is this available in version 1.2.0 ? Because I cannot find or see how to enable it anywhere. It is. There’s no specific setting for this. It will appear for moderators who can ban/unban people from topics, in posts that their authors can be banned and in forums NOT selected in the exclude setting. Afrodude 1
Afrodude Posted February 17, 2023 Posted February 17, 2023 20 minutes ago, Adriano Faria said: It is. There’s no specific setting for this. It will appear for moderators who can ban/unban people from topics, in posts that their authors can be banned and in forums NOT selected in the exclude setting. Sad, I had to lose the banned members data because I removed the app and reinstall it to see what causing the issue. I found that this plugin causing an issue with the new update. Once this plugin is disabled the new option shows fine.
Adriano Faria Posted February 17, 2023 Author Posted February 17, 2023 Probably this other one isn’t extending the post class or template hook in a proper way, which will cause mine to stop working. Try to switch their positions to see if something changes. You can send it to me via message. I can try to identify the problem (tomorrow) then you ask to the other dev to update it. Also, have you tried to change the @ position? It may works. Afrodude 1
Afrodude Posted February 17, 2023 Posted February 17, 2023 (edited) It would be nice whenever you have time to include this to mobile view too. Also, add a setting to disable/enable it because maybe some admins don't want to see it. Edited February 17, 2023 by Afrodude Adriano Faria and AlexJ 2
RevengeFNF Posted February 17, 2023 Posted February 17, 2023 @Adriano Fariai updated the to the new 1.2.0 version, and my members started to not being able to edit their posts. I disabled the application, and the bug disappeared. Adriano Faria 1
Adriano Faria Posted February 17, 2023 Author Posted February 17, 2023 47 minutes ago, RevengeFNF said: @Adriano Fariai updated the to the new 1.2.0 version, and my members started to not being able to edit their posts. I disabled the application, and the bug disappeared. Thank you. I have fixed it. I still have to add a setting and enhance the task; it should be done within the next hour. Let me know if you have FTP access to upload a fix while waiting for the new version review. sofos 1
AlexJ Posted February 18, 2023 Posted February 18, 2023 (edited) I have the similar issue. I also noticed below error: UPDATE `ipb_forums_posts` `forums_posts` SET `banFromTopic`=0,`queued`=-1 WHERE pid=1012488 Unknown column 'banFromTopic' in 'field list' For now i removed the app. Edited February 18, 2023 by AlexJ Afrodude 1
Adriano Faria Posted February 18, 2023 Author Posted February 18, 2023 6 minutes ago, AlexJ said: I have the similar issue. I also noticed below error: UPDATE `ipb_forums_posts` `forums_posts` SET `banFromTopic`=0,`queued`=-1 WHERE pid=1012488 Unknown column 'banFromTopic' in 'field list' For now i removed the app. This app does not add any columns to core tables. Not sure why you have this error. There's a new version pending approval currently. I requested urgency to approve it faster but no reply to the email too. Install it back when it's released and let me know if you still find this (or any other) issue. AlexJ 1
AlexJ Posted February 18, 2023 Posted February 18, 2023 (edited) Thank you. Will reinstall the after the new version is approved. Edited February 18, 2023 by AlexJ
Afrodude Posted February 19, 2023 Posted February 19, 2023 @Adriano Faria I have same error whenever it's enabled that @AlexJ mentioned. IPS\Db\Exception::1054 UPDATE `ibf_forums_posts` `forums_posts` SET `banFromTopic`=0,`edit_time`=1676595929,`edit_name`='MrGray',`append_edit`=true,`post`='<blockquote class="ipsQuote" data-ipsquote="" data-ipsquote-contentapp="forums" data-ipsquote-contentclass="forums_Topic" data-ipsquote-contentcommentid="1779341" data-ipsquote-contentid="435235" data-ipsquote-contenttype="forums" data-ipsquote-timestamp="1676585418" data-ipsquote-userid="99324" data-ipsquote-username="MiceY"> #0 /forums/system/Db/Db.php(1159): IPS\_Db->preparedQuery('/*forums::nsane...', Array) #1 /forums/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`ibf_forums_pos...', '`banFromTopic`=...', 'WHERE pid=?') #2 /forums/applications/forums/sources/Topic/Post.php(353): IPS\Patterns\_ActiveRecord->save() #3 /forums/system/Content/Comment.php(799): IPS\forums\Topic\_Post->save() #4 /forums/system/Content/Controller.php(2659): IPS\Content\_Comment->editContents('<blockquote cla...') #5 /forums/applications/forums/modules/front/forums/topic.php(1212): IPS\Content\_Controller->_edit('IPS\\forums\\Topi...', Object(IPS\forums\Topic\Post), Object(IPS\forums\Topic)) #6 /forums/system/Content/Controller.php(2307): IPS\forums\modules\front\forums\_topic->_edit('IPS\\forums\\Topi...', Object(IPS\forums\Topic\Post), Object(IPS\forums\Topic)) #7 /forums/applications/forums/modules/front/forums/topic.php(1240): IPS\Content\_Controller->__call('_edit', Array) #8 /forums/system/Dispatcher/Controller.php(107): IPS\forums\modules\front\forums\_topic->__call('editComment', Array) #9 /forums/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute() #10 /forums/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute() #11 /forums/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_topic->execute() #12 /forums/index.php(13): IPS\_Dispatcher->run() #13 {main} It happens on editing https://mysite.com/topic/898711-jokes-of-2023/?do=editComment&comment=1779358 Adriano Faria and AlexJ 2
Adriano Faria Posted February 19, 2023 Author Posted February 19, 2023 Guess I’ll have some work for the carnival holiday. 🤡 Afrodude 1
Adriano Faria Posted February 19, 2023 Author Posted February 19, 2023 @AlexJ @Afrodude When did yiu get that error? When trying to edit a post? If so, the version currently pending fix the edit issue. Let me know if you can reproduce after update to new versions. Afrodude and AlexJ 1 1
Afrodude Posted February 19, 2023 Posted February 19, 2023 11 hours ago, Adriano Faria said: Guess I’ll have some work for the carnival holiday. 🤡 If it pays good, count me in lol. Adriano Faria 1
Adriano Faria Posted February 19, 2023 Author Posted February 19, 2023 1 minute ago, Afrodude said: If it pays good, count me in lol. I wish. Afrodude 1
AlexJ Posted February 19, 2023 Posted February 19, 2023 7 hours ago, Adriano Faria said: @AlexJ @Afrodude When did yiu get that error? When trying to edit a post? If so, the version currently pending fix the edit issue. Let me know if you can reproduce after update to new versions. Yes for edit and hide. I see hide in the error log: do=hideComment&comment=1011852 UPDATE `ipb_forums_posts` `forums_posts` SET `banFromTopic`=0,`queued`=-1 WHERE pid=1011852 Unknown column 'banFromTopic' in 'field list'
Adriano Faria Posted February 19, 2023 Author Posted February 19, 2023 4 hours ago, AlexJ said: Yes for edit and hide. Just tested hiding a post and it's fixed too. It's just wait for the new version. 👍
AlexJ Posted February 19, 2023 Posted February 19, 2023 53 minutes ago, Adriano Faria said: Just tested hiding a post and it's fixed too. It's just wait for the new version. 👍 Thank you!
Adriano Faria Posted February 20, 2023 Author Posted February 20, 2023 What's New in Version 1.2.1: New setting to admin choose if wants to show links to ban/unban members directly in their posts Add the link to ban/unban in posts on mobile devices Fix: https://invisioncommunity.com/forums/topic/452864-ban-members-from-topics/?do=findComment&comment=2927562 Afrodude 1
Afrodude Posted February 21, 2023 Posted February 21, 2023 @Adriano Faria sorry mate the error me and Alex mentioned still occur. UPDATE `ibf_forums_posts` `forums_posts` SET `banFromTopic`=0,` ' WHERE pid=9649 IPS\Db\Exception: Unknown column 'banFromTopic' in 'field list' (1054) #0 /forums/system/Db/Db.php(1159): IPS\_Db->preparedQuery('/*forums::nsane...', Array) #1 /forums/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`ibf_forums_pos...', '`banFromTopic`=...', 'WHERE pid=?') #2 /forums/applications/forums/sources/Topic/Post.php(353): IPS\Patterns\_ActiveRecord->save() #3 /forums/system/Content/Item.php(1260): IPS\forums\Topic\_Post->save() #4 /forums/applications/forums/sources/Topic/Topic.php(667): IPS\Content\_Item->processAfterEdit(Array) #5 /forums/applications/forums/modules/front/forums/topic.php(678): IPS\forums\_Topic->processAfterEdit(Array) #6 /forums/system/Dispatcher/Controller.php(107): IPS\forums\modules\front\forums\_topic->edit() #7 /forums/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute() #8 /forums/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute() #9 /forums/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_topic->execute() #10 /forums/index.php(13): IPS\_Dispatcher->run() #11 {main} BACKTRACE #0 /forums/init.php(1037): IPS\_Log::log('UPDATE `ibf_for...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main} On ?do=edits AlexJ 1
AlexJ Posted February 21, 2023 Posted February 21, 2023 Thanks @Afrodude for checking. I am going to skip installing then 🙂
Adriano Faria Posted February 21, 2023 Author Posted February 21, 2023 (edited) 7 hours ago, Afrodude said: sorry mate the error me and Alex mentioned still occur. That’s weird. Works to me. Need more information. Who’s editing the post? The author? A moderator? Is the post edited authored by someone banned or not banned? Is the topic in a forum in the EXCLUDE setting? Can members be banned from topics in this forum? Edited February 21, 2023 by Adriano Faria
Adriano Faria Posted February 21, 2023 Author Posted February 21, 2023 9 hours ago, Afrodude said: @Adriano Faria sorry mate the error me and Alex mentioned still occur. UPDATE `ibf_forums_posts` `forums_posts` SET `banFromTopic`=0,` ' WHERE pid=9649 IPS\Db\Exception: Unknown column 'banFromTopic' in 'field list' (1054) #0 /forums/system/Db/Db.php(1159): IPS\_Db->preparedQuery('/*forums::nsane...', Array) #1 /forums/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`ibf_forums_pos...', '`banFromTopic`=...', 'WHERE pid=?') #2 /forums/applications/forums/sources/Topic/Post.php(353): IPS\Patterns\_ActiveRecord->save() #3 /forums/system/Content/Item.php(1260): IPS\forums\Topic\_Post->save() #4 /forums/applications/forums/sources/Topic/Topic.php(667): IPS\Content\_Item->processAfterEdit(Array) #5 /forums/applications/forums/modules/front/forums/topic.php(678): IPS\forums\_Topic->processAfterEdit(Array) #6 /forums/system/Dispatcher/Controller.php(107): IPS\forums\modules\front\forums\_topic->edit() #7 /forums/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute() #8 /forums/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute() #9 /forums/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_topic->execute() #10 /forums/index.php(13): IPS\_Dispatcher->run() #11 {main} BACKTRACE #0 /forums/init.php(1037): IPS\_Log::log('UPDATE `ibf_for...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main} On ?do=edits 3 hours ago, Adriano Faria said: That’s weird. Works to me. After an extensive test, I can only replicate this when merging posts. I have no issue when editing, as an admin or even a member with no moderator rights: I will try to fix the merging issue and will send you both a message with a file to upload. If it isn't working for you (as it is to me as you can see in the video), I will remove this feature (post buttons).
Afrodude Posted February 21, 2023 Posted February 21, 2023 Just enabled it again and tried to edit some random topics that I am the author and other members, I still see same issue. Once I come back from work. I will remove it completely and install it back, and then do some testing. I will let know what happen.
Afrodude Posted February 21, 2023 Posted February 21, 2023 @Adriano Faria after the testing again, the issue still occurs. On my dev site it doesn't, and the only different between the live and dev site that I use database prefix. The issue occurs only on a database has prefix tables. Also, from what I noticed that @AlexJ has prefix for his database tables "ipb_" and me I have "ibf_". As I mentioned above on my dev site where is no prefix the issue never occurs. AlexJ and Adriano Faria 2
Recommended Posts