Warning: mysql_query. Query execution was interrupted

[mproject3000]

Hi

I'm not a developper or an IT person, so may be this question will seem strange to you, but here it is:

 

I'm importing items on my website through the CSV files. Everything is going fine, at least on the subcategory pages. But when I click on the "mother category" where all items from all subcategories are, I have this message.

 

Is it because of a big nomber of products ? (I uploaded about 150 items with different colours and sizes, so it's about 1500 combinations)

 

Thank you very much for your answer

 

Kind regards

 

 

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /var/www/u3120361/data/www/xxxxxxxxx-xxxx.xx/classes/MySQL.php on line 149

Query execution was interrupted

 

SELECT p.`id_product`, p.`condition`, p.`id_manufacturer`, p.`quantity`, p.`weight`,

(SELECT GROUP_CONCAT(`id_category`) FROM `ps_category_product` cp WHERE cp.`id_product` = p.`id_product`) as ids_cat,

(SELECT GROUP_CONCAT(`id_feature_value`) FROM `ps_feature_product` fp WHERE fp.`id_product` = p.`id_product`) as ids_feat,

(SELECT GROUP_CONCAT(DISTINCT(pac.`id_attribute`))

FROM `ps_product_attribute_combination` pac

LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`)

WHERE pa.`id_product` = p.`id_product` ) as ids_attr

FROM ps_product p

WHERE p.`active` = 1 AND p.`id_product` IN ( SELECT id_product FROM `ps_category_product` cp WHERE cp.`id_category` = 111 OR cp.`id_category` = 1111 OR cp.`id_category` = 1112 OR cp.`id_category` = 1113 OR cp.`id_category` = 1114 OR cp.`id_category` = 1115 OR cp.`id_category` = 1116 OR cp.`id_category` = 1117 OR cp.`id_category` = 1118 OR cp.`id_category` = 1119)

[El Patron]

can you tell us what version of mysql is on your server.

 

You should also try contacting your hosting provider.

[mproject3000]

can you tell us what version of mysql is on your server.

 

You should also try contacting your hosting provider.

 

Hi,

 

thank you for your answer.

I sent a message to the hosting provider to find out the mysql version is used on the server. I don't know if there is alink, but the PHP version is 5.2.

 

Also the provider told that it means the the scripts of the website are slow executed, so either I have to optimize it either I have to switch to a dedicated virtual VPS server.

For the moment I have 0 trafic and only 150 items on the website..

Do I really need to have a dedicated server ?

 

Thank you again for your answer

 

Kind regards,

[El Patron]

I suspect you are on a shared server environment. It's been some time since I used one of those. What I suggest is search the prestashop forum for your make of server environments, i.e. you hosting provider and plan to see what others think.

 

I would seriously consider moving to another hosting environment,PrestaShop has their own recommendations you can search for.

 

and no you do not need a dedicated or vps server, at least in my opinion. make sure whoever is your provider that they give you an IP address in the country you do business. if you do business in multiple countries than you need think of geotargeting, it's all the rage.

Edited September 6, 2012 by elpatron (see edit history)

[mproject3000]

I suspect you are on a shared server environment. It's been some time since I used one of those. What I suggest is search the prestashop forum for your make of server environments, i.e. you hosting provider and plan to see what others think.

 

I would seriously consider moving to another hosting environment,PrestaShop has their own recommendations you can search for.

 

and no you do not need a dedicated or vps server, at least in my opinion. make sure whoever is your provider that they give you an IP address in the country you do business. if you do business in multiple countries than you need think of geotargeting, it's all the rage.

 

Thanks again for your answer.

So if I understand you right, there is no configuration or prestashop problem in this issue, it's only the question of an appropriate hosting...

The actual hosting provider told me that some of requests to mysql database are executed over 30 seconds. Those requests are forced to be terminated by their scrips and they can not increase it if it's a shared server.

 

The website is to be used by Russian customers. If by chance you know a good provider for prestashop in this country, I would be greatful

[El Patron]

you should post on good hosting solutions separately so you get the most feedback. Just make sure you get a Russian IP address.