Error: Duplicate column name 'num_cols'
(SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `v2305_categories` t1 LEFT JOIN `v2305_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `v2305_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 `v2305_categories` t1 LEFT JOIN `v2305_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `v2305_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 [/home/np50589/domains/bgdportal.com/public_html/includes/classes/esynDatabase.php:259] #1 esynDatabase->getAll((SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `v2305_categories` t1 LEFT JOIN `v2305_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `v2305_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 [/home/np50589/domains/bgdportal.com/public_html/includes/classes/esynCategory.php:112] #2 esynCategory->getAllByParent(-1, 0, ) called at [/home/np50589/domains/bgdportal.com/public_html/plugins/categoriesmap/index.php:48] #3 print_sitemap(-1, , 0, ) called at [/home/np50589/domains/bgdportal.com/public_html/plugins/categoriesmap/index.php:34] #4 require_once(/home/np50589/domains/bgdportal.com/public_html/plugins/categoriesmap/index.php) called at [/home/np50589/domains/bgdportal.com/public_html/controller.php:51]
Database query error: Error: Duplicate column name 'num_cols'(SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `v2305_categories` t1 LEFT JOIN `v2305_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `v2305_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 `v2305_categories` t1 LEFT JOIN `v2305_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `v2305_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 [/home/np50589/domains/bgdportal.com/public_html/includes/classes/esynDatabase.php:259] #1 esynDatabase->getAll((SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `v2305_categories` t1 LEFT JOIN `v2305_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `v2305_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 [/home/np50589/domains/bgdportal.com/public_html/includes/classes/esynCategory.php:112] #2 esynCategory->getAllByParent(-1, 0, ) called at [/home/np50589/domains/bgdportal.com/public_html/plugins/categoriesmap/index.php:48] #3 print_sitemap(-1, , 0, ) called at [/home/np50589/domains/bgdportal.com/public_html/plugins/categoriesmap/index.php:34] #4 require_once(/home/np50589/domains/bgdportal.com/public_html/plugins/categoriesmap/index.php) called at [/home/np50589/domains/bgdportal.com/public_html/controller.php:51] :: eSyndiCat Directory Software 3.0.7

Database query error: Error: Duplicate column name 'num_cols'(SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `v2305_categories` t1 LEFT JOIN `v2305_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `v2305_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 `v2305_categories` t1 LEFT JOIN `v2305_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `v2305_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 [/home/np50589/domains/bgdportal.com/public_html/includes/classes/esynDatabase.php:259] #1 esynDatabase->getAll((SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` FROM `v2305_categories` t1 LEFT JOIN `v2305_flat_structure` t2 ON t1.`id` = t2.`parent_id` LEFT JOIN `v2305_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 [/home/np50589/domains/bgdportal.com/public_html/includes/classes/esynCategory.php:112] #2 esynCategory->getAllByParent(-1, 0, ) called at [/home/np50589/domains/bgdportal.com/public_html/plugins/categoriesmap/index.php:48] #3 print_sitemap(-1, , 0, ) called at [/home/np50589/domains/bgdportal.com/public_html/plugins/categoriesmap/index.php:34] #4 require_once(/home/np50589/domains/bgdportal.com/public_html/plugins/categoriesmap/index.php) called at [/home/np50589/domains/bgdportal.com/public_html/controller.php:51]

 

If you are not sure what this error means you can always visit eSyndiCat Support Forums or try these solutions.