Error: Duplicate column name 'num_cols'
(SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `esc311_categories` t1 LEFT JOIN `esc311_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `esc311_categories` t21 ON t1.`parent_id` = t21.`id` WHERE t1.`parent_id` = '-1' AND t1.`status` = 'active' AND t1.`hidden` = '0' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) ORDER BY `order`
Debug backtrace:
#0 esynDatabase->query((SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `esc311_categories` t1 LEFT JOIN `esc311_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `esc311_categories` t21 ON t1.`parent_id` = t21.`id` WHERE t1.`parent_id` = '-1' AND t1.`status` = 'active' AND t1.`hidden` = '0' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) ORDER BY `order`) called at [/var/www/vhosts/qualazampa.it/httpdocs/includes/classes/esynDatabase.php:259]
#1 esynDatabase->getAll((SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `esc311_categories` t1 LEFT JOIN `esc311_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `esc311_categories` t21 ON t1.`parent_id` = t21.`id` WHERE t1.`parent_id` = '-1' AND t1.`status` = 'active' AND t1.`hidden` = '0' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) ORDER BY `order`) called at [/var/www/vhosts/qualazampa.it/httpdocs/includes/classes/esynCategory.php:112]
#2 esynCategory->getAllByParent(-1, 0, ) called at [/var/www/vhosts/qualazampa.it/httpdocs/plugins/categoriesmap/index.php:48]
#3 print_sitemap(-1, , 0, ) called at [/var/www/vhosts/qualazampa.it/httpdocs/plugins/categoriesmap/index.php:34]
#4 require_once(/var/www/vhosts/qualazampa.it/httpdocs/plugins/categoriesmap/index.php) called at [/var/www/vhosts/qualazampa.it/httpdocs/controller.php:51]
Database query error: Error: Duplicate column name 'num_cols'(SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `esc311_categories` t1 LEFT JOIN `esc311_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `esc311_categories` t21 ON t1.`parent_id` = t21.`id` WHERE t1.`parent_id` = '-1' AND t1.`status` = 'active' AND t1.`hidden` = '0' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) ORDER BY `order`
Debug backtrace:
#0 esynDatabase->query((SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `esc311_categories` t1 LEFT JOIN `esc311_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `esc311_categories` t21 ON t1.`parent_id` = t21.`id` WHERE t1.`parent_id` = '-1' AND t1.`status` = 'active' AND t1.`hidden` = '0' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) ORDER BY `order`) called at [/var/www/vhosts/qualazampa.it/httpdocs/includes/classes/esynDatabase.php:259]
#1 esynDatabase->getAll((SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `esc311_categories` t1 LEFT JOIN `esc311_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `esc311_categories` t21 ON t1.`parent_id` = t21.`id` WHERE t1.`parent_id` = '-1' AND t1.`status` = 'active' AND t1.`hidden` = '0' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) ORDER BY `order`) called at [/var/www/vhosts/qualazampa.it/httpdocs/includes/classes/esynCategory.php:112]
#2 esynCategory->getAllByParent(-1, 0, ) called at [/var/www/vhosts/qualazampa.it/httpdocs/plugins/categoriesmap/index.php:48]
#3 print_sitemap(-1, , 0, ) called at [/var/www/vhosts/qualazampa.it/httpdocs/plugins/categoriesmap/index.php:34]
#4 require_once(/var/www/vhosts/qualazampa.it/httpdocs/plugins/categoriesmap/index.php) called at [/var/www/vhosts/qualazampa.it/httpdocs/controller.php:51]
:: eSyndiCat Directory Software 3.1.1
Database query error: Error: Duplicate column name 'num_cols'(SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `esc311_categories` t1 LEFT JOIN `esc311_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `esc311_categories` t21 ON t1.`parent_id` = t21.`id` WHERE t1.`parent_id` = '-1' AND t1.`status` = 'active' AND t1.`hidden` = '0' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) ORDER BY `order`
Debug backtrace:
#0 esynDatabase->query((SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `esc311_categories` t1 LEFT JOIN `esc311_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `esc311_categories` t21 ON t1.`parent_id` = t21.`id` WHERE t1.`parent_id` = '-1' AND t1.`status` = 'active' AND t1.`hidden` = '0' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) ORDER BY `order`) called at [/var/www/vhosts/qualazampa.it/httpdocs/includes/classes/esynDatabase.php:259]
#1 esynDatabase->getAll((SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `esc311_categories` t1 LEFT JOIN `esc311_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `esc311_categories` t21 ON t1.`parent_id` = t21.`id` WHERE t1.`parent_id` = '-1' AND t1.`status` = 'active' AND t1.`hidden` = '0' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) ORDER BY `order`) called at [/var/www/vhosts/qualazampa.it/httpdocs/includes/classes/esynCategory.php:112]
#2 esynCategory->getAllByParent(-1, 0, ) called at [/var/www/vhosts/qualazampa.it/httpdocs/plugins/categoriesmap/index.php:48]
#3 print_sitemap(-1, , 0, ) called at [/var/www/vhosts/qualazampa.it/httpdocs/plugins/categoriesmap/index.php:34]
#4 require_once(/var/www/vhosts/qualazampa.it/httpdocs/plugins/categoriesmap/index.php) called at [/var/www/vhosts/qualazampa.it/httpdocs/controller.php:51]
If you are not sure what this error means you can always visit eSyndiCat Support Forums or try these solutions.