8WR Media Generator SQL issues

Apnix

Active member
Registered
Joined
Mar 5, 2020
Messages
35
Points
18

Reputation:

Code:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'ewr_medio_categories_Category_3.category_groups' in 'where clause'
src/XF/Db/AbstractStatement.php:228
Generated by: Apnix
Nov 2, 2020 at 2:49 PM
Stack trace

                SELECT COUNT(*)
FROM `ewr_medio_media`
LEFT JOIN `ewr_medio_categories` AS `ewr_medio_categories_Category_3` ON (`ewr_medio_categories_Category_3`.`category_id` = `ewr_medio_media`.`category_id`)
WHERE ((`ewr_medio_categories_Category_3`.`category_groups` = '') OR (FIND_IN_SET(7, `ewr_medio_categories_Category_3`.`category_groups`)) OR (FIND_IN_SET(5, `ewr_medio_categories_Category_3`.`category_groups`)) OR (FIND_IN_SET(8, `ewr_medio_categories_Category_3`.`category_groups`))) AND (`ewr_medio_media`.`media_state` = 'visible')

------------

#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/XF/Db/AbstractAdapter.php(150): XF\Db\AbstractAdapter->query('
SELECT COU...', Array)
#5 src/XF/Mvc/Entity/Finder.php(1334): XF\Db\AbstractAdapter->fetchOne('
SELECT COU...')
#6 src/addons/EWR/Medio/Pub/Controller/Media.php(225): XF\Mvc\Entity\Finder->total()
#7 src/XF/Mvc/Dispatcher.php(350): EWR\Medio\Pub\Controller\Media->actionIndex(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('EWR\\Medio:Media', 'Index', Object(XF\Mvc\RouteMatch), Object(EWR\Medio\Pub\Controller\Media), NULL)
#9 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(EWR\Medio\Pub\Controller\Media), NULL)
#10 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#12 src/XF.php(465): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}


Request state

array(4) {
["url"] => string(27) "/forum/index.php?ewr-medio/"
["referrer"] => string(38) "https://immortality.cc/forum/index.php"
["_GET"] => array(1) {
["ewr-medio/"] => string(0) ""
}
["_POST"] => array(0) {
}
}

Does anyone know how I can resolve this. I watched this thread but I can't really figure out whether that will fix it, since its a different/outdated version of the plugin (i think)

if anyone could help me please message me
 
Top