- Thread listings changes:
- Title is broken into multiple lines when longer than max, to better indicate where the "limit" is for the person doing cleaning
- Under title also shows: Author, create date, forum, last post username and date
- Statistics column:
- Reply count
- View count
- Thread age (in days)
- Views per day..
- This can be useful to know which thread is more popular over time..
- 3 action buttons
- ...
Yes this would make senseWould be a nice addition if this could show the user when posting:
The title of their post is too short
The title of their post is too long
Hmmm well poop...
[LIST]
[*]XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\xA7\xB5 T...' for column `table`.`xf_phrase`.`phrase_text` at row 1
[*]src/XF/Db/AbstractStatement.php:230
[/LIST]
[HEADING=2]Stack trace[/HEADING]
INSERT INTO `xf_phrase` (`addon_id`, `title`, `version_id`, `version_string`, `language_id`, `global_cache`, `phrase_text`, `phrase_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1516): XF\Db\AbstractAdapter->insert('xf_phrase', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1248): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/AddOn/DataType/Phrase.php(100): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Job/AddOnData.php(110): XF\AddOn\DataType\Phrase->importAddOnData('AV/ThreadTitles', Object(SimpleXMLElement), 0, 8)
#8 src/XF/Job/Manager.php(260): XF\Job\AddOnData->run(8)
#9 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8)
#10 src/XF/Job/Manager.php(118): XF\Job\Manager->runJobEntry(Array, 8)
#11 src/XF/Admin/Controller/Tools.php(122): XF\Job\Manager->runByIds(Array, 8)
#12 src/XF/Mvc/Dispatcher.php(352): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(X0815\ChkTables\XF\Admin\Controller\Tools), NULL)
#14 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(X0815\ChkTables\XF\Admin\Controller\Tools), NULL)
#15 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2353): XF\Mvc\Dispatcher->run()
#17 src/XF.php(524): XF\App->run()
#18 admin.php(13): XF::runApp('XF\\Admin\\App')
#19 {main}
Yep I'll need to fix that.. Did you try to uninstall and install?Code:[LIST] [*]XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\xA7\xB5 T...' for column `table`.`xf_phrase`.`phrase_text` at row 1 [*]src/XF/Db/AbstractStatement.php:230 [/LIST] [HEADING=2]Stack trace[/HEADING] INSERT INTO `xf_phrase` (`addon_id`, `title`, `version_id`, `version_string`, `language_id`, `global_cache`, `phrase_text`, `phrase_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ------------ #0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007') #1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007') #2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute() #3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array) #4 src/XF/Mvc/Entity/Entity.php(1516): XF\Db\AbstractAdapter->insert('xf_phrase', Array, false) #5 src/XF/Mvc/Entity/Entity.php(1248): XF\Mvc\Entity\Entity->_saveToSource() #6 src/XF/AddOn/DataType/Phrase.php(100): XF\Mvc\Entity\Entity->save(true, false) #7 src/XF/Job/AddOnData.php(110): XF\AddOn\DataType\Phrase->importAddOnData('AV/ThreadTitles', Object(SimpleXMLElement), 0, 8) #8 src/XF/Job/Manager.php(260): XF\Job\AddOnData->run(8) #9 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8) #10 src/XF/Job/Manager.php(118): XF\Job\Manager->runJobEntry(Array, 8) #11 src/XF/Admin/Controller/Tools.php(122): XF\Job\Manager->runByIds(Array, 8) #12 src/XF/Mvc/Dispatcher.php(352): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag)) #13 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(X0815\ChkTables\XF\Admin\Controller\Tools), NULL) #14 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(X0815\ChkTables\XF\Admin\Controller\Tools), NULL) #15 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch)) #16 src/XF/App.php(2353): XF\Mvc\Dispatcher->run() #17 src/XF.php(524): XF\App->run() #18 admin.php(13): XF::runApp('XF\\Admin\\App') #19 {main}
I got this also when trying to install (for the first time)Code:[LIST] [*]XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\xA7\xB5 T...' for column `table`.`xf_phrase`.`phrase_text` at row 1 [*]src/XF/Db/AbstractStatement.php:230 [/LIST] [HEADING=2]Stack trace[/HEADING] INSERT INTO `xf_phrase` (`addon_id`, `title`, `version_id`, `version_string`, `language_id`, `global_cache`, `phrase_text`, `phrase_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ------------ #0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007') #1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007') #2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute() #3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array) #4 src/XF/Mvc/Entity/Entity.php(1516): XF\Db\AbstractAdapter->insert('xf_phrase', Array, false) #5 src/XF/Mvc/Entity/Entity.php(1248): XF\Mvc\Entity\Entity->_saveToSource() #6 src/XF/AddOn/DataType/Phrase.php(100): XF\Mvc\Entity\Entity->save(true, false) #7 src/XF/Job/AddOnData.php(110): XF\AddOn\DataType\Phrase->importAddOnData('AV/ThreadTitles', Object(SimpleXMLElement), 0, 8) #8 src/XF/Job/Manager.php(260): XF\Job\AddOnData->run(8) #9 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8) #10 src/XF/Job/Manager.php(118): XF\Job\Manager->runJobEntry(Array, 8) #11 src/XF/Admin/Controller/Tools.php(122): XF\Job\Manager->runByIds(Array, 8) #12 src/XF/Mvc/Dispatcher.php(352): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag)) #13 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(X0815\ChkTables\XF\Admin\Controller\Tools), NULL) #14 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(X0815\ChkTables\XF\Admin\Controller\Tools), NULL) #15 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch)) #16 src/XF/App.php(2353): XF\Mvc\Dispatcher->run() #17 src/XF.php(524): XF\App->run() #18 admin.php(13): XF::runApp('XF\\Admin\\App') #19 {main}
- Fixed bug where forums using
utf8mb3
encoding couldn't install it (only those onutf8mb4
could)- Long thread titles are now broken like as follows:
Code:this is a long title blah blah blah blah blah blah blah blah... ...here is the rest of the text
Perhaps? I don't see why not... Are those part of some addon or core XF functionality?Would;d it be possible to also automatically ignore public but no indexed forums?
It currently will always be there, but could make it also hideable or move it somewhere elsenoticed when taking care of my threads with too long of titles, that it leaves this messages up at the top. Does it ever go away? I mean since I fixed them, the found 291 should no longer show up? I noticed that the too short or duplicate areas they stay clear.
It doesn't need any cron job and all threads are fetched when you load the management pagesAlso, does this run a cron job, or scan the database in case future threads are created that will show up under either too short, too long, or duplicate? So in case members make new threads in the future I can adjust them again.
We use essential cookies to make this site work, and optional cookies to enhance your experience.