- Seo improvements:
- Add categories in Sitemap
- Add category title and description tags
- Add new field description for categories
- Possibility to collapse categories in sidebar
Request: Sitemap inclusion and SEO improvements
It would be nice if the FAQ pages were automatically included within the sitemap (or an option for it).
Also, currently all FAQ pages have the same page title: "Frequently Asked Questions" and are missing a page description all together. It would be nice if the page title reflected the category or question and the description took the first 150 characters of the answer - or something similar. Anything would be an improvement and help get the FAQ pages indexed by search engines.
And the support link under the add-on in the admincp is old/wrong. It currently points to a non-existent forum.
View attachment 220192
...tried to post this on your support site (word for word as above) and it was flagged as spam
View attachment 220190
That would be nice, so that it uncollapse on mouseclick, and then you see the questions in that categorie. Dont know if its necessary, but for me it would be a dream and it would solve the problem, if you really have many questions and categories.
XF\Db\InvalidQueryException: xfa_faq_category: MySQL statement prepare error [1101]: BLOB/TEXT column 'description' can't have a default value src/XF/Db/AbstractStatement.php:217
Stack-Trace
ALTER TABLE `xfa_faq_category`
ADD `description` MEDIUMTEXT NOT NULL DEFAULT ''
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1101, '42000')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1101, '42000')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/Schema/AbstractDdl.php(151): XF\Db\AbstractAdapter->query('ALTER TABLE `xf...')
#5 src/XF/Db/SchemaManager.php(149): XF\Db\Schema\AbstractDdl->apply()
#6 src/addons/XFA/FrequentlyAskedQuestions/Install/Upgrade/Upgrade0901040090.php(26): XF\Db\SchemaManager->alterTable('xfa_faq_categor...', Object(Closure))
#7 src/addons/XFA/FrequentlyAskedQuestions/Setup.php(68): XFA\FrequentlyAskedQuestions\Install\Upgrade\Upgrade0901040090::runStep1(Object(XF\Db\SchemaManager))
#8 src/XF/AddOn/StepRunnerUpgradeTrait.php(122): XFA\FrequentlyAskedQuestions\Setup->upgrade901040090Step1(Array)
#9 src/XF/AddOn/StepRunnerUpgradeTrait.php(71): XFA\FrequentlyAskedQuestions\Setup->upgradeStepRunner(901040090, 1, Array, NULL)
#10 src/XF/Admin/Controller/AddOn.php(576): XFA\FrequentlyAskedQuestions\Setup->upgrade(Array)
#11 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', Object(XF\Mvc\RouteMatch), Object(xenMade\ACPE\XF\Admin\Controller\AddOn), NULL)
#13 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(xenMade\ACPE\XF\Admin\Controller\AddOn), NULL)
#14 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#16 src/XF.php(390): XF\App->run()
#17 admin.php(13): XF::runApp('XF\\Admin\\App')
#18 {main}
@Fredxd ,
the first update of today went smooth, but the second won´t install and the updater aborts with this error:
Code:XF\Db\InvalidQueryException: xfa_faq_category: MySQL statement prepare error [1101]: BLOB/TEXT column 'description' can't have a default value src/XF/Db/AbstractStatement.php:217 Stack-Trace ALTER TABLE `xfa_faq_category` ADD `description` MEDIUMTEXT NOT NULL DEFAULT '' ------------ #0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1101, '42000') #1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1101, '42000') #2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare() #3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute() #4 src/XF/Db/Schema/AbstractDdl.php(151): XF\Db\AbstractAdapter->query('ALTER TABLE `xf...') #5 src/XF/Db/SchemaManager.php(149): XF\Db\Schema\AbstractDdl->apply() #6 src/addons/XFA/FrequentlyAskedQuestions/Install/Upgrade/Upgrade0901040090.php(26): XF\Db\SchemaManager->alterTable('xfa_faq_categor...', Object(Closure)) #7 src/addons/XFA/FrequentlyAskedQuestions/Setup.php(68): XFA\FrequentlyAskedQuestions\Install\Upgrade\Upgrade0901040090::runStep1(Object(XF\Db\SchemaManager)) #8 src/XF/AddOn/StepRunnerUpgradeTrait.php(122): XFA\FrequentlyAskedQuestions\Setup->upgrade901040090Step1(Array) #9 src/XF/AddOn/StepRunnerUpgradeTrait.php(71): XFA\FrequentlyAskedQuestions\Setup->upgradeStepRunner(901040090, 1, Array, NULL) #10 src/XF/Admin/Controller/AddOn.php(576): XFA\FrequentlyAskedQuestions\Setup->upgrade(Array) #11 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag)) #12 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', Object(XF\Mvc\RouteMatch), Object(xenMade\ACPE\XF\Admin\Controller\AddOn), NULL) #13 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(xenMade\ACPE\XF\Admin\Controller\AddOn), NULL) #14 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch)) #15 src/XF/App.php(2178): XF\Mvc\Dispatcher->run() #16 src/XF.php(390): XF\App->run() #17 admin.php(13): XF::runApp('XF\\Admin\\App') #18 {main}
Guess you have to release another update
- XF\Db\InvalidQueryException: xfa_faq_category: MySQL statement prepare error [1101]: BLOB/TEXT column 'description' can't have a default value
- Template error: Illegal string offset 'faq_category_id'
Hi Fred my friend, can these be nested and drop down etc?
Okay cheers mate.Hi
Questions and categories can’t be nested sorry
Regards
Is it possible to set usergroup permission pr. category? If not, maybe this is a good idea. There might be some info you dont want to show to all usergroups.
I don’t know 2.2 just released and i am currently on holidays so...Works with 2.2?
We use essential cookies to make this site work, and optional cookies to enhance your experience.