Tripp★

My comment wasn't aimed at the severity or the amount of bugs that there was; which is three that I found by the way: The Widget bug. The fact that answers are converted to SEO format and put in 'question_seo' instead of the question being converted to SEO format and put into 'question_seo'. The Moderator control panel is inaccessible. It was a comment about the above mentioned backtrace, and the fact that it was blocking my staff out of the ModCP with the 1054 MySQL error, nothing more. 😕

Yes; I know. Please read this carefully: Instead of storing the question in SEO format in the question_seo table, which looks like that's what it is supposed to be doing... it's storing the answer itself in SEO format in the question_seo table. That's what I said. In addition to the errors I have reported there is another bug affecting something outside of the FAQ application. Some of my staff are now no longer able to access the Moderator Control Panel because of this application. This is the error in the system logs: SELECT COUNT(*) as cnt FROM `faq_items` LEFT JOIN `faq_cats` ON faq_items.c_id=faq_cats.id WHERE open=0 AND faq_items.open < 2 AND faq_items.open!=-2 AND faq_items.c_id IN(1,2,3,4,5) IPS\Db\Exception: Column 'open' in where clause is ambiguous (1052) #0 /home/SITE/public_html/system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IPS\\Content\\_...', Array, true) #1 /home/SITE/public_html/system/Db/Select.php(440): IPS\Db\_Select->runQuery() #2 /home/SITE/public_html/system/Db/Select.php(361): IPS\Db\_Select->rewind() #3 /home/SITE/public_html/system/Content/Item.php(2651): IPS\Db\_Select->first() #4 /home/SITE/public_html/applications/faq/sources/Faq/Faq.php(96): IPS\Content\_Item::getItemsWithPermission(Array, 'faq_items.submi...', 1, 'read', true, 0, Object(IPS\Member), true, false, false, true, NULL, false, true, true, true, false) #5 /home/SITE/public_html/applications/core/extensions/core/ModCp/Unapproved.php(311): IPS\faq\_Faq::getItemsWithPermission(Array, NULL, 1, 'read', NULL, 0, Object(IPS\Member), true, false, false, true) #6 /home/SITE/public_html/applications/core/modules/front/modcp/modcp.php(94): IPS\core\extensions\core\ModCp\_Unapproved->getApprovalQueueCount(false) #7 /home/SITE/public_html/system/Dispatcher/Controller.php(96): IPS\core\modules\front\modcp\_modcp->manage() #8 /home/SITE/public_html/system/Dispatcher/Dispatcher.php(146): IPS\Dispatcher\_Controller->execute() #9 /home/SITE/public_html/index.php(13): IPS\_Dispatcher->run() #10 {main} Wew. This isn't looking good at all.

I am having problems too; namely when anyone tries to put in a Question/Answer: IPS\Db\Exception: Data too long for column 'question_seo' at row 1 (1406) #0 /home/SITE/public_html/system/Db/Db.php(807): IPS\_Db->preparedQuery('/*IPS\\Patterns\\...', Array) #1 /home/SITE/public_html/system/Patterns/ActiveRecord.php(459): IPS\_Db->insert('faq_items', Array) #2 [internal function]: IPS\Patterns\_ActiveRecord->save() #3 /home/SITE/public_html/init.php(460) : eval()'d code(120): call_user_func_array('parent::save', Array) #4 [internal function]: IPS\Patterns\rules_hook_ipsPatternsActiveRecord->save() #5 /home/SITE/public_html/init.php(460) : eval()'d code(324): call_user_func_array('parent::save', Array) #6 /home/SITE/public_html/applications/faq/modules/front/faq/main.php(183): IPS\rules_hook_ipsContent->save() #7 /home/SITE/public_html/system/Dispatcher/Controller.php(85): IPS\faq\modules\front\faq\_main->submitqnaform() #8 /home/SITE/public_html/applications/faq/modules/front/faq/main.php(25): IPS\Dispatcher\_Controller->execute() #9 /home/SITE/public_html/system/Dispatcher/Dispatcher.php(146): IPS\faq\modules\front\faq\_main->execute() #10 /home/SITE/public_html/index.php(13): IPS\_Dispatcher->run() #11 {main} After modifying the DB structure to the following: It seems to be a work around... But "question_seo" is storing the answer in SEO format, not the question... Which is why, this would need to be fixed, as it's clearly a bug. I also have another problem. When trying to make widgets of the FAQ's if it's set to all categories it displays this error: [[Template faq/front/widgets/faq is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

I'm having a few issues with the Duplicate Member Logger application; namely it doesn't seem to be sending out any PM's to the duplicate accounters.

I'll take that as a no then. I'll be asking for a refund.

@Fosters Has there been any update to this?

That's wonderful news; as I said Fosters if you want me to test this out for you, I am more than happy to do so.

Okay, yes. There is a different section in the Moderator Control Panel, and all the moderators can see it; and that all works and such... But there are some pretty major problems with this application: I expected everything to appear in the report centre, not have a completely new clone of the report centre made up just for it. This, right now, is rather inefficient and a pointless waste of space & time. None of the moderators can even use the report profile function; they only see the report profile button in their profiles, it doesn't appear in anyone else's. I believe this is true for all the members too. So it rather defeats the purpose if all anyone can do is report their own profiles. There are no moderator permissions that I could see in the ACP, that would pertain to this at all. Bad Templates... IPS Focus themes don't want to display this properly, but yet everything else works fine in IPS Focus themes, this means it's not using a standard IPS coding, because if it was it'd be working in IPS Focus themes: The button in the profile is a strange colour in (Screenshot Attached) The ModCP section is not properly coded either, as a result there is white text against a white background (Screenshot Attached) Screenshot 1: Screenshot 2: I am not very happy with this application at all. As it stands it is completely broken, if no one can even report anyone but themselves thus this app cannot by definition serve its purpose. Please fix this, @Fosters. I am happy to help out in anyway I can with testing and what have you, but this has to be fixed. 🙂

"You'd be surprised what random vehicle components are capable of causing fires" Yeah, no kidding.

Oh then there appears to have been a misunderstanding on my part then. I will take another look and get back to you on that. Is there anyway of merging it in with the report centre at all? It doesn't seem to make sense to me that these are separated, but then again it doesn't make any sense to me that there is no report button on profiles by default with the stock software in the first place. So I shouldn't really complain.

This doesn't seem to work on the latest IPS release (4.3.5). I click on the oddly coloured report button, and fill in the information. I submit the report. It says "Thanks for submitting the report", however no report is filed to the report centre. Please advise.

PM Sent.

This certainly isn't happening for me, it goes back to the homepage of my site. I'm not sure if that's because I've modified the friendly URL's of it or not. Do you want me to PM you my site link?

Oh really? I didn't know about this! Thanks @Daniel F!