Resource icon

[CZ] Title Length Modifier 2020-01-13

No permission to download
Trying to uninstall this and I get errors:

Code:
    XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'title' in 'field list' in src/XF/Db/AbstractStatement.php at line 228
    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 39
    XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    XF\Db\AbstractAdapter->query() in src/addons/CZ/TitleLength/Setup.php at line 76
    CZ\TitleLength\Setup->uninstall() in src/XF/Admin/Controller/AddOn.php at line 636
    XF\Admin\Controller\AddOn->actionUninstall() in src/XF/Mvc/Dispatcher.php at line 350
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    XF\App->run() in src/XF.php at line 391
    XF::runApp() in admin.php at line 13

Code:
Server error log

    XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'title' in 'field list' src/XF/Db/AbstractStatement.php:228

    Generated by: djbaxter Aug 18, 2020 at 4:55 PM

Stack trace

UPDATE xf_user set custom_title = SUBSTRING(title, 1, 50) where length(custom_title) > 150;
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#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/addons/CZ/TitleLength/Setup.php(76): XF\Db\AbstractAdapter->query('UPDATE xf_user ...')
#5 src/XF/Admin/Controller/AddOn.php(636): CZ\TitleLength\Setup->uninstall(Array)
#6 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\AddOn->actionUninstall(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Uninstall', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#8 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#9 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2190): XF\Mvc\Dispatcher->run()
#11 src/XF.php(391): XF\App->run()
#12 admin.php(13): XF::runApp('XF\\Admin\\App')
#13 {main}

Request state

array(4) {
  ["url"] => string(43) "/admin.php?add-ons/CZ-TitleLength/uninstall"
  ["referrer"] => string(75) "https://domain.com/admin.php?add-ons/CZ-TitleLength/uninstall"
  ["_GET"] => array(1) {
    ["add-ons/CZ-TitleLength/uninstall"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["_xfProcessing"] => string(1) "1"
    ["continue"] => string(1) "1"
    ["confirm"] => string(1) "1"
    ["params"] => string(2) "[]"
    ["count"] => string(1) "1"
    ["finished"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
  }
}
 
Last edited:
Amazing what you can find if you look hard enough..

I was about to start tinkering with some code that allowed me to increase the custom user title size and allow HTML if set by an admin. I've found existing add-ons to both, albeit separately.. 😎
 
Top Bottom