Declaration of esynBanner::update() should be compatible with esynDatabase::update($fields, $where = '', $values = Array, $addit = NULL) [ 25 Jul 2014 10:56:28 ] in dir/plugins/banners/includes/classes/esynBanner.php:263

Error: Unknown column 'blocks.name' in 'where clause'
SELECT DISTINCT `blocks`.* FROM `v2303_blocks` `blocks` LEFT JOIN `v2303_block_show` `block_show` ON `blocks`.`id` = `block_show`.`block_id` WHERE `blocks`.`status` = 'active' AND `blocks`.`name` != 'account' AND (`blocks`.`sticky` = '1' OR `block_show`.`page` = 'view_listing' ) AND `blocks`.`plugin` IN('', 'kcaptcha','polls','listings_boxes','alphabetic_search','search_categories','listingstatus','extrastats','searches','import_csv','spider','gy_sitemap','claimlisting','googlemap','moneybookers','comments','banners','googletools','seostatistics','displayurl','contacts','recaptcha','categoriesmap','tell_friend','youtube','coupons','categories_boxes','paypal','googlesearch','whoisonline','faq','rss','badwordsfilter','alternate_payment') ORDER BY `blocks`.`position`, `blocks`.`order`

Debug backtrace:

#0 esynDatabase->query(SELECT DISTINCT `blocks`.* FROM `v2303_blocks` `blocks` LEFT JOIN `v2303_block_show` `block_show` ON `blocks`.`id` = `block_show`.`block_id` WHERE `blocks`.`status` = 'active' AND `blocks`.`name` != 'account' AND (`blocks`.`sticky` = '1' OR `block_show`.`page` = 'view_listing' ) AND `blocks`.`plugin` IN('', 'kcaptcha','polls','listings_boxes','alphabetic_search','search_categories','listingstatus','extrastats','searches','import_csv','spider','gy_sitemap','claimlisting','googlemap','moneybookers','comments','banners','googletools','seostatistics','displayurl','contacts','recaptcha','categoriesmap','tell_friend','youtube','coupons','categories_boxes','paypal','googlesearch','whoisonline','faq','rss','badwordsfilter','alternate_payment') ORDER BY `blocks`.`position`, `blocks`.`order`) called at [/home/compendi/public_html/dir/includes/classes/esynDatabase.php:259] #1 esynDatabase->getAll(SELECT DISTINCT `blocks`.* FROM `v2303_blocks` `blocks` LEFT JOIN `v2303_block_show` `block_show` ON `blocks`.`id` = `block_show`.`block_id` WHERE `blocks`.`status` = 'active' AND `blocks`.`name` != 'account' AND (`blocks`.`sticky` = '1' OR `block_show`.`page` = 'view_listing' ) AND `blocks`.`plugin` IN('', 'kcaptcha','polls','listings_boxes','alphabetic_search','search_categories','listingstatus','extrastats','searches','import_csv','spider','gy_sitemap','claimlisting','googlemap','moneybookers','comments','banners','googletools','seostatistics','displayurl','contacts','recaptcha','categoriesmap','tell_friend','youtube','coupons','categories_boxes','paypal','googlesearch','whoisonline','faq','rss','badwordsfilter','alternate_payment') ORDER BY `blocks`.`position`, `blocks`.`order`) called at [/home/compendi/public_html/dir/includes/view.inc.php:185] #2 require_once(/home/compendi/public_html/dir/includes/view.inc.php) called at [/home/compendi/public_html/dir/view-listing.php:40]
Database query error: Error: Unknown column 'blocks.name' in 'where clause'SELECT DISTINCT `blocks`.* FROM `v2303_blocks` `blocks` LEFT JOIN `v2303_block_show` `block_show` ON `blocks`.`id` = `block_show`.`block_id` WHERE `blocks`.`status` = 'active' AND `blocks`.`name` != 'account' AND (`blocks`.`sticky` = '1' OR `block_show`.`page` = 'view_listing' ) AND `blocks`.`plugin` IN('', 'kcaptcha','polls','listings_boxes','alphabetic_search','search_categories','listingstatus','extrastats','searches','import_csv','spider','gy_sitemap','claimlisting','googlemap','moneybookers','comments','banners','googletools','seostatistics','displayurl','contacts','recaptcha','categoriesmap','tell_friend','youtube','coupons','categories_boxes','paypal','googlesearch','whoisonline','faq','rss','badwordsfilter','alternate_payment') ORDER BY `blocks`.`position`, `blocks`.`order` Debug backtrace: #0 esynDatabase->query(SELECT DISTINCT `blocks`.* FROM `v2303_blocks` `blocks` LEFT JOIN `v2303_block_show` `block_show` ON `blocks`.`id` = `block_show`.`block_id` WHERE `blocks`.`status` = 'active' AND `blocks`.`name` != 'account' AND (`blocks`.`sticky` = '1' OR `block_show`.`page` = 'view_listing' ) AND `blocks`.`plugin` IN('', 'kcaptcha','polls','listings_boxes','alphabetic_search','search_categories','listingstatus','extrastats','searches','import_csv','spider','gy_sitemap','claimlisting','googlemap','moneybookers','comments','banners','googletools','seostatistics','displayurl','contacts','recaptcha','categoriesmap','tell_friend','youtube','coupons','categories_boxes','paypal','googlesearch','whoisonline','faq','rss','badwordsfilter','alternate_payment') ORDER BY `blocks`.`position`, `blocks`.`order`) called at [/home/compendi/public_html/dir/includes/classes/esynDatabase.php:259] #1 esynDatabase->getAll(SELECT DISTINCT `blocks`.* FROM `v2303_blocks` `blocks` LEFT JOIN `v2303_block_show` `block_show` ON `blocks`.`id` = `block_show`.`block_id` WHERE `blocks`.`status` = 'active' AND `blocks`.`name` != 'account' AND (`blocks`.`sticky` = '1' OR `block_show`.`page` = 'view_listing' ) AND `blocks`.`plugin` IN('', 'kcaptcha','polls','listings_boxes','alphabetic_search','search_categories','listingstatus','extrastats','searches','import_csv','spider','gy_sitemap','claimlisting','googlemap','moneybookers','comments','banners','googletools','seostatistics','displayurl','contacts','recaptcha','categoriesmap','tell_friend','youtube','coupons','categories_boxes','paypal','googlesearch','whoisonline','faq','rss','badwordsfilter','alternate_payment') ORDER BY `blocks`.`position`, `blocks`.`order`) called at [/home/compendi/public_html/dir/includes/view.inc.php:185] #2 require_once(/home/compendi/public_html/dir/includes/view.inc.php) called at [/home/compendi/public_html/dir/view-listing.php:40] :: eSyndiCat Directory Software 2.3.04

Database query error: Error: Unknown column 'blocks.name' in 'where clause'SELECT DISTINCT `blocks`.* FROM `v2303_blocks` `blocks` LEFT JOIN `v2303_block_show` `block_show` ON `blocks`.`id` = `block_show`.`block_id` WHERE `blocks`.`status` = 'active' AND `blocks`.`name` != 'account' AND (`blocks`.`sticky` = '1' OR `block_show`.`page` = 'view_listing' ) AND `blocks`.`plugin` IN('', 'kcaptcha','polls','listings_boxes','alphabetic_search','search_categories','listingstatus','extrastats','searches','import_csv','spider','gy_sitemap','claimlisting','googlemap','moneybookers','comments','banners','googletools','seostatistics','displayurl','contacts','recaptcha','categoriesmap','tell_friend','youtube','coupons','categories_boxes','paypal','googlesearch','whoisonline','faq','rss','badwordsfilter','alternate_payment') ORDER BY `blocks`.`position`, `blocks`.`order` Debug backtrace: #0 esynDatabase->query(SELECT DISTINCT `blocks`.* FROM `v2303_blocks` `blocks` LEFT JOIN `v2303_block_show` `block_show` ON `blocks`.`id` = `block_show`.`block_id` WHERE `blocks`.`status` = 'active' AND `blocks`.`name` != 'account' AND (`blocks`.`sticky` = '1' OR `block_show`.`page` = 'view_listing' ) AND `blocks`.`plugin` IN('', 'kcaptcha','polls','listings_boxes','alphabetic_search','search_categories','listingstatus','extrastats','searches','import_csv','spider','gy_sitemap','claimlisting','googlemap','moneybookers','comments','banners','googletools','seostatistics','displayurl','contacts','recaptcha','categoriesmap','tell_friend','youtube','coupons','categories_boxes','paypal','googlesearch','whoisonline','faq','rss','badwordsfilter','alternate_payment') ORDER BY `blocks`.`position`, `blocks`.`order`) called at [/home/compendi/public_html/dir/includes/classes/esynDatabase.php:259] #1 esynDatabase->getAll(SELECT DISTINCT `blocks`.* FROM `v2303_blocks` `blocks` LEFT JOIN `v2303_block_show` `block_show` ON `blocks`.`id` = `block_show`.`block_id` WHERE `blocks`.`status` = 'active' AND `blocks`.`name` != 'account' AND (`blocks`.`sticky` = '1' OR `block_show`.`page` = 'view_listing' ) AND `blocks`.`plugin` IN('', 'kcaptcha','polls','listings_boxes','alphabetic_search','search_categories','listingstatus','extrastats','searches','import_csv','spider','gy_sitemap','claimlisting','googlemap','moneybookers','comments','banners','googletools','seostatistics','displayurl','contacts','recaptcha','categoriesmap','tell_friend','youtube','coupons','categories_boxes','paypal','googlesearch','whoisonline','faq','rss','badwordsfilter','alternate_payment') ORDER BY `blocks`.`position`, `blocks`.`order`) called at [/home/compendi/public_html/dir/includes/view.inc.php:185] #2 require_once(/home/compendi/public_html/dir/includes/view.inc.php) called at [/home/compendi/public_html/dir/view-listing.php:40]

 

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