zipicip Posted January 17, 2011 Share Posted January 17, 2011 (edited) protected $dependencies = array( 'cPath' => array( 'marker' => '-c-', 'query' => "SELECT cd2.categories_name AS pName, cd.categories_name AS cName FROM :TABLE_CATEGORIES c LEFT JOIN :TABLE_CATEGORIES_DESCRIPTION cd2 ON c.parent_id = cd2.categories_id AND c.parent_id = cd2.categories_id AND cd2.language_id = :languages_id, :TABLE_CATEGORIES_DESCRIPTION cd WHERE c.categories_id = cd.categories_id AND c.categories_id = :cid AND cd.language_id = :languages_id", page_modules/index.php There is a big problem with this query. If a client try to restore an old cart he get an mysql error 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cd.language_id = 1' at line 1 SELECT cd2.categories_name AS pName, cd.categories_name AS cName FROM categories c LEFT JOIN categories_description cd2 ON c.parent_id = cd2.categories_id AND c.parent_id = cd2.categories_id AND cd2.language_id = 1, categories_description cd WHERE c.categories_id = cd.categories_id AND c.categories_id = AND cd.language_id = 1 I guess somewhere should by a cast conversion to int to categories id ? You can test if you can enter in a client account . Take table CUSTOMERS_BASKET pick an customers id with an old cart change his password and login and go to shopping cart. Also there error came if a product from cart restore is out of stock now. Edited January 17, 2011 by zipicip Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.