Resource icon

Minimum Thread Title Length 1.0.1.0

No permission to download

Alfa1

Well-known member
Please add a way to set this up for hundreds of nodes. For example by adding the setting to categories and letting child nodes inherit it.
When trying to set this up for hundreds of nodes its a lot of work and easy to loose track of what has been done and what has not.

I'd like to set up the majority of my nodes with a 20 character minimum length. But there are some categories that need to have a lower minimum.
 

Alfa1

Well-known member
I am encountering this error when trying to run an importer:
Mysqli statement execute error : Field 'z61_character_min_enable' doesn't have a default value

There are two bugs with the Z61 Addon. The addon table hasn't set a default value for a column which it should have. This can be fixed by running a query.
But the other one is more complex to fix. The Z61 addon adds two columns to the forum table. For one it doesn't set a default value, which causes the error above (can be fixed by an alter query), but the second column is somehow being passed a string when it expects a number.
 
  • Like
Reactions: Z61

Z61

Well-known member
I am encountering this error when trying to run an importer:
Mysqli statement execute error : Field 'z61_character_min_enable' doesn't have a default value

There are two bugs with the Z61 Addon. The addon table hasn't set a default value for a column which it should have. This can be fixed by running a query.
But the other one is more complex to fix. The Z61 addon adds two columns to the forum table. For one it doesn't set a default value, which causes the error above (can be fixed by an alter query), but the second column is somehow being passed a string when it expects a number.
Thanks for the report, will look to getting a patch out soon.
 

Donny

Active member
I've upgraded to 2.0 and now have this error when trying to add a node.

Code:
XF\Db\Exception: MySQL query error [1364]: Field 'z61_character_min_enable' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 217
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1452
XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1184
XF\Mvc\Entity\Entity->save() in src/XF/Mvc/Entity/Entity.php at line 1202
XF\Mvc\Entity\Entity->save() in src/XF/Mvc/FormAction.php at line 69
XF\Mvc\FormAction->XF\Mvc\{closure}() in src/XF/Mvc/FormAction.php at line 187
XF\Mvc\FormAction->run() in src/XF/Admin/Controller/AbstractNode.php at line 110
XF\Admin\Controller\AbstractNode->actionSave() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13
Please help! @Z61
 

Z61

Well-known member
I've upgraded to 2.0 and now have this error when trying to add a node.

Code:
XF\Db\Exception: MySQL query error [1364]: Field 'z61_character_min_enable' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 217
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1452
XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1184
XF\Mvc\Entity\Entity->save() in src/XF/Mvc/Entity/Entity.php at line 1202
XF\Mvc\Entity\Entity->save() in src/XF/Mvc/FormAction.php at line 69
XF\Mvc\FormAction->XF\Mvc\{closure}() in src/XF/Mvc/FormAction.php at line 187
XF\Mvc\FormAction->run() in src/XF/Admin/Controller/AbstractNode.php at line 110
XF\Admin\Controller\AbstractNode->actionSave() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13
Please help! @Z61
Is that using the 2.0 version of the add-on? If not, installing this version should fix the issue. https://xenforo.com/community/resources/minimum-thread-title-length.6033/
 
Top