Anthony Parsons
Well-known member
Found the import, tried to use it, and got:
Code:
[LIST]
[*]XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'user_name' in 'order clause'
[*]
[*]src/XF/Db/AbstractStatement.php:212
[*]Generated by: anthony
[*]
[*]Jun 2, 2018 at 5:44 PM
[/LIST]
Stack trace
SELECT *
FROM xf_email_subscription
ORDER BY user_name ASC
------------
#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(79): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(96): XF\Db\AbstractAdapter->query('\n SELECT...', Array)
#5 src/addons/Andy/EmailSubscription/Pub/Controller/EmailSubscription.php(251): XF\Db\AbstractAdapter->fetchAll('\n SELECT...')
#6 src/XF/Mvc/Dispatcher.php(249): Andy\EmailSubscription\Pub\Controller\EmailSubscription->actionImport(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(87): XF\Mvc\Dispatcher->dispatchClass('Andy\\EmailSubsc...', 'Import', 'html', Object(XF\Mvc\ParameterBag), '', Object(Andy\EmailSubscription\Pub\Controller\EmailSubscription), NULL)
#8 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#9 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#10 src/XF.php(328): XF\App->run()
#11 index.php(13): XF::runApp('XF\\Pub\\App')
#12 {main}
Request state
array(4) {
["url"] => string(25) "/emailsubscription/import"
["referrer"] => bool(false)
["_GET"] => array(1) {
["/emailsubscription/import"] => string(0) ""
}
["_POST"] => array(0) {
}
}