Update from Cart 1.8.4 to 1.9 fails
Posted: Sun Apr 21, 2013 5:04 pm
Hi!
Running CMSMS 1.11.5, & Cart 1.8.4
When updating to Cart 1.9 the update returns a blanc screen in the admin panel.
Tried some other routes to this update as there are various CG modules who are in for an update, such as CGECommercebase needed update from 1.3.11 to 1.4.2. Whatever combination of updates, as soon as Cart is updated, the admin panel is a blanc (empty screen). After each succesful module update the cache is cleared on CMSMS as wel as the one in the local browser.
When I update to 1.11.6 first the problem remains.
Running PHP 5.3
Let me know if more information is needed.
[update: tried the manual update via ftp'ing cart 1.9 folder directly into /modules. result is the same. deinstall Cart 1.8.4 also wrecks the admin interface! Now running CMSMS 1.11.6 with al the modules updates except Cart.
updated another site with a similar configuration without any problems to cart 1.9.
not sure if this is related to an SQL error in one of the pages using the product database:
When retrieving all related Product pages I encounter for on set of product pages an SQL error:
INTERNAL ERROR: Query failed - SELECT SQL_CALC_FOUND_ROWS C.*,PH.hierarchy_id FROM cms_module_products C LEFT JOIN cms_module_products_prodtohier PH ON PH.product_id = C.id LEFT JOIN cms_module_products_categories cc ON cc.product_id = C.id WHERE C.status = 'published' AND cc.category_id = 2 ORDER BY product_name asc LIMIT 0, 10000 -- Unknown column 'cc.category_id' in 'where clause'
running Product 2.19.5
with regards
Marc
Running CMSMS 1.11.5, & Cart 1.8.4
When updating to Cart 1.9 the update returns a blanc screen in the admin panel.
Tried some other routes to this update as there are various CG modules who are in for an update, such as CGECommercebase needed update from 1.3.11 to 1.4.2. Whatever combination of updates, as soon as Cart is updated, the admin panel is a blanc (empty screen). After each succesful module update the cache is cleared on CMSMS as wel as the one in the local browser.
When I update to 1.11.6 first the problem remains.
Running PHP 5.3
Let me know if more information is needed.
[update: tried the manual update via ftp'ing cart 1.9 folder directly into /modules. result is the same. deinstall Cart 1.8.4 also wrecks the admin interface! Now running CMSMS 1.11.6 with al the modules updates except Cart.
updated another site with a similar configuration without any problems to cart 1.9.
not sure if this is related to an SQL error in one of the pages using the product database:
When retrieving all related Product pages I encounter for on set of product pages an SQL error:
INTERNAL ERROR: Query failed - SELECT SQL_CALC_FOUND_ROWS C.*,PH.hierarchy_id FROM cms_module_products C LEFT JOIN cms_module_products_prodtohier PH ON PH.product_id = C.id LEFT JOIN cms_module_products_categories cc ON cc.product_id = C.id WHERE C.status = 'published' AND cc.category_id = 2 ORDER BY product_name asc LIMIT 0, 10000 -- Unknown column 'cc.category_id' in 'where clause'
running Product 2.19.5
with regards
Marc