Hi,
Just imported our first product and are getting this error:
SELECT price FROM `printfulintegration_variants` WHERE product_id=1 ORDER BY CAST(JSON_UNQUOTE(JSON_EXTRACT(price, '$.default.value')) AS DECIMAL(4,2)) ASC LIMIT 0,1
IPS\Db\Exception: FUNCTION badhabi5_footforum.JSON_UNQUOTE does not exist (1305)
#0 /home/badhabi5/public_html/system/Db/Select.php(383): IPS\_Db->preparedQuery('/*badhabi5_foot...', Array, true)
#1 /home/badhabi5/public_html/system/Db/Select.php(441): IPS\Db\_Select->runQuery()
#2 /home/badhabi5/public_html/system/Db/Select.php(365): IPS\Db\_Select->rewind()
#3 /home/badhabi5/public_html/applications/printfulintegration/sources/Product/Product.php(163): IPS\Db\_Select->first()
#4 /home/badhabi5/public_html/system/Node/Model.php(1263): IPS\printfulintegration\_Product::constructFromData(Array)
#5 /home/badhabi5/public_html/system/Node/Model.php(1140): IPS\Node\_Model->children(NULL, NULL, true, NULL, Array)
#6 /home/badhabi5/public_html/system/Node/Model.php(1119): IPS\Node\_Model->childrenCount(NULL, NULL, true, Array)
#7 /home/badhabi5/public_html/system/Node/Model.php(1372): IPS\Node\_Model->hasChildren(NULL, NULL, true)
#8 /home/badhabi5/public_html/init.php(887) : eval()'d code(71): IPS\Node\_Model->getButtons(Object(IPS\Http\Url\Internal), false)
#9 /home/badhabi5/public_html/applications/printfulintegration/sources/Category/Category.php(93): IPS\Node\clubsenhancements_hook_ceNodeModel->getButtons(Object(IPS\Http\Url\Internal), false)
#10 /home/badhabi5/public_html/system/Node/Controller.php(199): IPS\printfulintegration\_Category->getButtons(Object(IPS\Http\Url\Internal), false)
#11 /home/badhabi5/public_html/system/Node/Controller.php(275): IPS\Node\_Controller->_getRow(2)
#12 /home/badhabi5/public_html/system/Helpers/Tree/Tree.php(135): IPS\Node\_Controller->_getChildren('2')
#13 /home/badhabi5/public_html/system/Node/Controller.php(92): IPS\Helpers\Tree\_Tree->__toString()
#14 /home/badhabi5/public_html/system/Dispatcher/Controller.php(101): IPS\Node\_Controller->manage()
#15 /home/badhabi5/public_html/init.php(887) : eval()'d code(14): IPS\Dispatcher\_Controller->execute()
#16 /home/badhabi5/public_html/system/Node/Controller.php(62): IPS\Dispatcher\hook3189->execute()
#17 /home/badhabi5/public_html/system/Dispatcher/Dispatcher.php(152): IPS\Node\_Controller->execute()
#18 /home/badhabi5/public_html/admin/index.php(14): IPS\_Dispatcher->run()
#19 {main}
Backtrace
#0 /home/badhabi5/public_html/init.php(989): IPS\_Log::log('SELECT price FR...', 'uncaught_except...')
#1 /home/badhabi5/public_html/system/Helpers/Tree/Tree.php(166): IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 /home/badhabi5/public_html/system/Node/Controller.php(92): IPS\Helpers\Tree\_Tree->__toString()
#3 /home/badhabi5/public_html/system/Dispatcher/Controller.php(101): IPS\Node\_Controller->manage()
#4 /home/badhabi5/public_html/init.php(887) : eval()'d code(14): IPS\Dispatcher\_Controller->execute()
#5 /home/badhabi5/public_html/system/Node/Controller.php(62): IPS\Dispatcher\hook3189->execute()
#6 /home/badhabi5/public_html/system/Dispatcher/Dispatcher.php(152): IPS\Node\_Controller->execute()
#7 /home/badhabi5/public_html/admin/index.php(14): IPS\_Dispatcher->run()
#8 {main}