FAQ Manager by Iversia 3.2.0

[Iversia]

Got this error when trying to upgrade.

Are you sure you've uploaded all of the new and changed files? I just managed to upgrade two installations successfully.

 

[Scharesoft]

Great addon, thanks But there is a small bug with the search form and other custom searches.

Here you can see all searches:



But after selecting the faq search the custom searches are gone:



A search box in the sidebar of the faq area would be better I think

 

[Iversia]

Iversia updated [Iversia] FAQ Manager with a new update entry:

Small bugfix

Adds a missing template to the FAQ search form so that tabs no longer disappear.

Read the rest of this update entry...

 

[Iversia]

A search box in the sidebar of the faq area would be better I think

Just squashed that bug. I think I'm just a little torn on where I'd actually end up putting a search box. Some people might want it on the FAQ sidebar, maybe at the top of all of the questions, or maybe even as a widget that can be placed anywhere. That's a really great suggestion though, thanks!

 

[Stuart Wright]

Upgraded to 2.2.1. I always install addons the old school way. I upload the files and then run the upgrade script.
I use FTP daily so I know I uploaded all the files to the correct place.
The upgrade script ran fine. When I hit the FAQ, I get

Mysqli prepare error: Unknown column 'sticky' in 'order clause'

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
5. XenForo_Model->fetchAllKeyed() in Iversia/FAQ/Model/Question.php at line 25
6. Iversia_FAQ_Model_Question->getAll() in Iversia/FAQ/ControllerPublic/FAQ.php at line 32
7. Iversia_FAQ_ControllerPublic_FAQ->actionIndex() in XenForo/FrontController.php at line 337
8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
9. XenForo_FrontController->run() in /home/sites/xf.avforums.com/public_html/sandbox/index.php at line 13

 

[Iversia]

@Stuart Wright Well, the previous error suggested that you hadn't uploaded all of the new files. This error suggests that you did not run the add-on's upgrade script, or that it failed at some point (as it is the installer that adds the "sticky" field to the database). I suggest that you uninstall and then reinstall the add-on to completely clear it up.

 

[Stuart Wright]

@Stuart Wright Well, the previous error suggested that you hadn't uploaded all of the new files. This error suggests that you did not run the add-on's upgrade script, or that it failed at some point (as it is the installer that adds the "sticky" field to the database). I suggest that you uninstall and then reinstall the add-on to completely clear it up.

This worked, thank you.

 

[almql3]

Very Excellent

Thank you

 

[topcat]

Thankyou for adding the question display order so quickly.

Perfect now

 

[Stuart Wright]

By the way, I removed
secondaryContent
from

 <div class="discussionListItem faqListItem secondaryContent <xen:if is="{$question.sticky} == 1">sticky </xen:if><xen:if is="{$xenOptions.faqClickAction} == 'same_page'">faqSlide</xen:if>">

in the iversia_faq_questions template
because it appears to only add a margin which makes the questions very (too) spaced apart in my opinion.

 

[Live Free]

Unless I'm missing something, setting route filters doesn't work with this (categories or questions). Any idea why and if there might be a fix eventually?

 

[Iversia]

Unless I'm missing something, setting route filters doesn't work with this (categories or questions). Any idea why and if there might be a fix eventually?

This add-on works perfectly with XenForo's default route filter, so there is nothing to fix. Maybe learn more about how route filters work? http://xenforo.com/community/threads/route-filters.47946/

 

[Cool]

like the work!
but user-VIEW-permissions would be nice.

 

[Stuart Wright]

Found a bug, I'm afraid.
This in the FAQ works fine:

[IMG]http://www.avforums.com/styles/avf/faq/useful_searches.jpg[/IMG]

however, this in the FAQ:

[CENTER][IMG]http://www.avforums.com/styles/avf/faq/useful_searches.jpg[/IMG][/CENTER]

causes this

ErrorException: Fatal Error: Out of memory (allocated 17301504) (tried to allocate 18446744071642356377 bytes) - library/XenForo/Helper/String.php:409
Generated By: Chris Deeming, 2 minutes ago
Stack Trace
#0 [internal function]: XenForo_Application::handleFatalError('#\[(attach|medi...', '[\1]', '<div style="tex...')
#1 {main}
Request State
array(3) {
["url"] => string(46) "http://www.avforums.com/faq/about-searching.3/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Iversia]

Found a bug, I'm afraid.

Is that the exact BBcode you used, or is this board stripping some of it? I copied it to my own installation and there weren't any errors, so I'm unable to replicate. Do you perhaps have custom installed un-closed BBcode tags?

 

[bart]

Is it possible to skip the normal sidebar and only display the faq-sidebar? I would then like to see that one on the right side.

 

[KiF]

It'd be great if there was the ability to name categories, questions and answers with xenforo phrases. Thanks.

 

[Iversia]

Is it possible to skip the normal sidebar and only display the faq-sidebar? I would then like to see that one on the right side.

I'm not quite sure I understand what you want to do. What do you mean by the "normal sidebar"?

It'd be great if there was the ability to name categories, questions and answers with xenforo phrases. Thanks.

That sort of thing is far out of scope for this add-on. If the core version of XenForo ever adds something like multilingual support for forum titles/description, and page nodes, then it's something that I might consider. I recommend just creating a FAQ category for each language that you want, and simply divide up your questions that way.

 

[KiF]

Can you add The Description field to FAQ Categories/Questions (similar to XF categories(nodes)/forums)?

 

[KensonPlays]

When I installed it, no tab items appeared, and I enabled all groups to be able to 'like' the FAQ's and Administrators/Owners to be able to manage the FAQ. I checked on default theme and the custom theme we use. http://minersr.us

Maybe you could take a look at the code in the back-end?