khushbu soni Posted December 11, 2015 Share Posted December 11, 2015 SELECT bc.`id_cms_block`, bc.`id_cms_category`, bc.`display_store`, ccl.`link_rewrite`, ccl.`name` category_name, bcl.`name` block_name FROM `ps_cms_block` bc LEFT JOIN `ps_cms_block_shop` bcs ON (bcs.id_cms_block = bc.id_cms_block) INNER JOIN `ps_cms_category_lang` ccl ON (bc.`id_cms_category` = ccl.`id_cms_category`) INNER JOIN `ps_cms_block_lang` bcl ON (bc.`id_cms_block` = bcl.`id_cms_block`) WHERE bc.`location` = 0 AND ccl.`id_lang` = 1 AND bcl.`id_lang` = 1 AND bcs.id_shop = 1 AND ccl.`id_shop` = 1 ORDER BY `position` Unknown column 'ccl.id_shop' in 'where clause' and also Unknown column id_product in ps_image_shop table. I follow this step: move all files from one server to another server. and also import database in new server. I changed database name, username and password in setting.inc.php. in database, domain and domain_ssl change 'domainname.effective-internet.com' to 'www.domainname' in ps_shop_url table. Admin side not display product list How to solve this problem? Thank you in advance Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now