caytre Posted December 22, 2011 Share Posted December 22, 2011 Hi everybody, I have problems with cart.php and wishlist.php like Devilboy97, I droped all stored procedures and upload them again, but it didn't help. Why ? Can you help me ? My web site is : www.caytre.ugu.pl Thanks Link to comment Share on other sites More sharing options...
Jonathon Posted December 22, 2011 Share Posted December 22, 2011 Run the query in PHPmyAdmin and see what the error says. Link to comment Share on other sites More sharing options...
caytre Posted December 22, 2011 Author Share Posted December 22, 2011 Hi Jonathon, How can I run the query in PHPMyAdmin? Like that : RUN PROCEDURE add_to_cart or ... Link to comment Share on other sites More sharing options...
Jonathon Posted December 22, 2011 Share Posted December 22, 2011 CALL Select_Sale_Items( 1 ) Click the SQL tab inside your database in PHPMyAdmin Link to comment Share on other sites More sharing options...
caytre Posted December 22, 2011 Author Share Posted December 22, 2011 I put "CALL Select_Sale_Items ( 1 ) and klicked the SQL, nothing has changed, but when I put "CALL Select_sale_items( 1 ) ", the answer is :" #1046 - No database selected " Link to comment Share on other sites More sharing options...
caytre Posted December 22, 2011 Author Share Posted December 22, 2011 But when I tried to upload PROCEDURE select_sale_items again, it was informed : PROCEDURE select_sale_items already exists Link to comment Share on other sites More sharing options...
caytre Posted December 23, 2011 Author Share Posted December 23, 2011 when I put : CALL update_cart ( 4 ) , I got : #1318 - Incorrect number of arguments for PROCEDURE db229174.update_cart; expected 4, got 1, when I put CALL add_to_cart ( 4 ) I got : #1305 - PROCEDURE db229174.add_to_cart does not exist and I don't know why I havn't PROCEDURE add_to_cart because I just installed it again. Link to comment Share on other sites More sharing options...
Jonathon Posted December 23, 2011 Share Posted December 23, 2011 Add_to_cart() you need the parenthesis and the error about providing the correct number of arguments means you need to see what arguments the procedure takes and call it with the correct number and type of arguments. Link to comment Share on other sites More sharing options...
Larry Posted December 23, 2011 Share Posted December 23, 2011 Also, don't start two threads for the same problem. It makes no sense to do that whatsoever and you'll end up wasting people's time when they're helping. Link to comment Share on other sites More sharing options...
Recommended Posts