Guest Posted November 18, 2009 Share Posted November 18, 2009 Major Problem It seems the queries is stopping mysql and i check everything, the problem is the script of cubecart (my hosting company told me) Please find below the queries: 750 root localhost mysql 0 Query show full processlist 781 parfumeri localhost parfumerie 0 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 780 parfumeri localhost parfumerie 1 Query SELECT `useStockLevel` FROM CubeCart_inventory WHERE `productId` = '10413' 779 parfumeri localhost parfumerie 3 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 778 parfumeri localhost parfumerie 4 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 777 parfumeri localhost parfumerie 7 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 776 parfumeri localhost parfumerie 11 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 775 parfumeri localhost parfumerie 13 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 774 parfumeri localhost parfumerie 14 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 768 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 769 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 770 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 771 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 772 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 766 parfumeri localhost parfumerie 17 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 767 parfumeri localhost parfumerie 17 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 762 parfumeri localhost parfumerie 18 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 763 parfumeri localhost parfumerie 18 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 764 parfumeri localhost parfumerie 18 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 765 parfumeri localhost parfumerie 18 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 758 parfumeri localhost parfumerie 19 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 759 parfumeri localhost parfumerie 19 Query SELECT count(productId) as noProducts FROM CubeCart_inventory 761 parfumeri localhost parfumerie 19 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 757 parfumeri localhost parfumerie 20 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 756 parfumeri localhost parfumerie 21 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 755 parfumeri localhost parfumerie 23 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 754 parfumeri localhost parfumerie 24 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 753 parfumeri localhost parfumerie 26 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 751 parfumeri localhost parfumerie 29 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 752 parfumeri localhost parfumerie 29 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 749 parfumeri localhost parfumerie 30 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 748 parfumeri localhost parfumerie 34 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 747 parfumeri localhost parfumerie 35 Query SELECT CubeCart_inventory.productId AS id, CubeCart_inventory.name AS name, CubeCart_inventory 744 parfumeri localhost parfumerie 36 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 746 parfumeri localhost parfumerie 36 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 743 parfumeri localhost parfumerie 40 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 742 parfumeri localhost parfumerie 42 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 741 parfumeri localhost parfumerie 43 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 738 parfumeri localhost parfumerie 44 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 739 parfumeri localhost parfumerie 44 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 740 parfumeri localhost parfumerie 44 Query SELECT I.*, C.cat_name, C.cat_father_id FROM CubeCart_inventory AS I LEFT JOIN CubeCart_catego 736 parfumeri localhost parfumerie 46 Sleep 737 parfumeri localhost parfumerie 46 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 734 parfumeri localhost parfumerie 51 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 735 parfumeri localhost parfumerie 51 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 733 parfumeri localhost parfumerie 54 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 730 parfumeri localhost parfumerie 57 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 731 parfumeri localhost parfumerie 57 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 732 parfumeri localhost parfumerie 57 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted November 20, 2009 Share Posted November 20, 2009 What version of CubeCart are you running ? I have had several problems with clients that have had large stores (number of products and categories) and have worked with Al to get these sorted - these changes are now part of the latest versions of CubeCart. However, other issues such as MySQL not being configured correctly or the CubeCart database not being installed correctly can also cause major issues Ian Major Problem It seems the queries is stopping mysql and i check everything, the problem is the script of cubecart (my hosting company told me) Please find below the queries: 750 root localhost mysql 0 Query show full processlist 781 parfumeri localhost parfumerie 0 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 780 parfumeri localhost parfumerie 1 Query SELECT `useStockLevel` FROM CubeCart_inventory WHERE `productId` = '10413' 779 parfumeri localhost parfumerie 3 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 778 parfumeri localhost parfumerie 4 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 777 parfumeri localhost parfumerie 7 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 776 parfumeri localhost parfumerie 11 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 775 parfumeri localhost parfumerie 13 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 774 parfumeri localhost parfumerie 14 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 768 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 769 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 770 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 771 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 772 parfumeri localhost parfumerie 16 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 766 parfumeri localhost parfumerie 17 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 767 parfumeri localhost parfumerie 17 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 762 parfumeri localhost parfumerie 18 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 763 parfumeri localhost parfumerie 18 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 764 parfumeri localhost parfumerie 18 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 765 parfumeri localhost parfumerie 18 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 758 parfumeri localhost parfumerie 19 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 759 parfumeri localhost parfumerie 19 Query SELECT count(productId) as noProducts FROM CubeCart_inventory 761 parfumeri localhost parfumerie 19 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 757 parfumeri localhost parfumerie 20 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 756 parfumeri localhost parfumerie 21 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 755 parfumeri localhost parfumerie 23 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 754 parfumeri localhost parfumerie 24 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 753 parfumeri localhost parfumerie 26 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 751 parfumeri localhost parfumerie 29 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 752 parfumeri localhost parfumerie 29 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 749 parfumeri localhost parfumerie 30 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 748 parfumeri localhost parfumerie 34 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 747 parfumeri localhost parfumerie 35 Query SELECT CubeCart_inventory.productId AS id, CubeCart_inventory.name AS name, CubeCart_inventory 744 parfumeri localhost parfumerie 36 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 746 parfumeri localhost parfumerie 36 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 743 parfumeri localhost parfumerie 40 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 742 parfumeri localhost parfumerie 42 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 741 parfumeri localhost parfumerie 43 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 738 parfumeri localhost parfumerie 44 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 739 parfumeri localhost parfumerie 44 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 740 parfumeri localhost parfumerie 44 Query SELECT I.*, C.cat_name, C.cat_father_id FROM CubeCart_inventory AS I LEFT JOIN CubeCart_catego 736 parfumeri localhost parfumerie 46 Sleep 737 parfumeri localhost parfumerie 46 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 734 parfumeri localhost parfumerie 51 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 735 parfumeri localhost parfumerie 51 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 733 parfumeri localhost parfumerie 54 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 730 parfumeri localhost parfumerie 57 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 731 parfumeri localhost parfumerie 57 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE 732 parfumeri localhost parfumerie 57 Query SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE Quote Link to comment Share on other sites More sharing options...
Guest Roger Huston Posted November 20, 2009 Share Posted November 20, 2009 You have an older version of CubeCart installed. That sql stuff is from the Like Product look-ups which have been disabled in the more current versions. You can search the forums here, many people have reported it. - Roger Quote Link to comment Share on other sites More sharing options...
Guest Posted November 23, 2009 Share Posted November 23, 2009 i`m using the latest version of Cubecart 4.3.6 My site is getting stuck every 10/15 minutes, i asked for help from cubecart but they can`t find the problem :-( Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted November 23, 2009 Share Posted November 23, 2009 i`m using the latest version of Cubecart 4.3.6 My site is getting stuck every 10/15 minutes, i asked for help from cubecart but they can`t find the problem :-( What mods do you have installed ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.