Search the Community
Showing results for tags 'sql'.
Hello All, Our webshop is getting bigger and our database is growing. However we also got a lot of spider/crawls traffic that causes our server outage yesterday. I talked with our hosting provider and they blame the developers or the system administrator of the serer. I am sure it is not the development, because Cubecart is a paid shopping cart solution with a lot of customers. Is anyone able to help me setting up the server in a correct way? PS: This is my hardware:VPS, 2.69 GHZ, RAM 1824 MB, Disk Space 80 GB, Bandwidth 1425 GB Helpdesk summary conversation: (9:00:13pm)helpdesk.:Hello! How can I help with this today? (9:25:04pm)helpdesk.:Hmm, I would highly suggest contacting a developer to assist you with optimizing the site's usage of CPU, masterunix. (9:27:00pm)helpdesk.:masterunix, it had just recently used up too much of the server's MySQL service. Which means that it is needed to be optimized to handle mysql queries better. (9:27:38pm)masterunix:any server upgrade will help? (9:28:11pm)helpdesk.:It will not help, however you can save money by simply optimizing the site. (9:29:40pm)helpdesk.:It would mean that it is worked on to handle services better, as right now, it's causing issues on MySQL. (9:29:57pm)masterunix:can you suggest what and how to optimize it? (9:33:17pm)helpdesk.:As mentioned, fixing up the MySQL configurations, as well as the site's handling of MySQL queries would be great.
I am not even 48 hours online with cubecart after migrating from opencart and i got this: Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/viviclot/public_html/classes/db/mysqli.class.php on line 22 Fatal error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/viviclot/public_html/classes/db/mysqli.class.php on line 24 Contact with hoster: (9:46:35pm)marcello:Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/viviclot/public_html/classes/db/mysqli.class.php on line 22 Fatal error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/viviclot/public_html/classes/db/mysqli.class.php on line 24 (9:47:05pm)Josh H.:I am working on this for you. (9:49:11pm)Josh H.:Can you please take a look now? (9:49:46pm)marcello:yes it works (9:49:55pm)marcello:did you reboot the server or mysql service? (9:50:12pm)marcello:i can think of that myself .. but it doesnt solve my problem (9:50:18pm)marcello:i want to know WHY it happend (9:50:19pm)Josh H.:The mysql (9:50:28pm)marcello:for future prevention (9:50:38pm)Josh H.:There was a heavy load spike. (9:50:57pm)marcello:caused by .. ? (9:51:44pm)Josh H.:Traffic, it is hard to say, most likely traffic (9:52:40pm)marcello:i dont understand currently 4 visitors online (9:52:47pm)marcello:how can that take down my whole site (9:53:22pm)Josh H.:It is hard to say without a monitor watching we can install a snapshot if you like and if it happens again we will know exactly what it was (9:53:37pm)marcello:yes please do this! (9:53:41pm)marcello:i need to know (9:53:54pm)marcello:because if its happening again i still dont know why and i cant fix it Well soon we will find out if its the software (Cubecart) or not ... if so i want my refund ... reason why i stopped using Opencart was also too much downtime and checkout problems ... i swtiched also hosting providers so that was not the issue. I guess i am ready for Magento ...
Hello All, I am new here and i run a very serious webshop that i just migrated from Opencart to Cubecart. I bought the full license and copyright removal and i will buy this for at least 3 or 4 sites. So far so good very happy with Cubecart. However i am missing some features, but most of them not very important and i can hard code them in the templates files. However i am not a great programmer, but i do have ICT experience for more then 13 years and in daily life i am a freelancer based on Linux administrator, Windows enginering and sometimes supporting or management in the ITIL section like change management, so i do understand much. What i really miss is a feature to add one specific product option to ALL products! I have 11.000 products and i just go live with my webshop after migrating and i forgot the product options! Normally all webshops i worked with (different systems) has a add product option to ALL products ... cubecart don't have this? Why? I figured myself out this query: INSERT INTO `CubeCart_options_set_product` (`set_product_id`, `set_id`, `product_id`) VALUES (1, 2, 1); This will add product options to product id 1. If i want to add the product option to product id 2 it will be: INSERT INTO `CubeCart_options_set_product` (`set_product_id`, `set_id`, `product_id`) VALUES (2, 2, 2); If i want to add this on product id 3 it will be: INSERT INTO `CubeCart_options_set_product` (`set_product_id`, `set_id`, `product_id`) VALUES (3, 2, 3); Ok so we get the idea ... now ... how can i do this to ALL of my 11.000 products? Can someone PLEASE share a MYSQL query that will apply this to ALL product IDs? So i can make a cronjob of this activity? Lets say: create product option to product id if not exists. if exists update. Somethin like this. And for you third party developers ... if this is easy for you, please make a module of it in admin i will pay you! I need it URGENTLY, because i am live now and i lose orders, because people can not fill in their sizes or colors. Thank you all.