Jump to content

Kanary

Members
  • Posts

    28
  • Joined

  • Last visited

Kanary's Achievements

Newbie

Newbie (1/14)

2

Reputation

  1. Dear Nemo1, I upgraded from 1.4.9 to 1.6 and turned the error on. Now please check the error and advise: http://www.kanaryluxurywatches.com/2013Test/en/ Thanks.
  2. Thank you tomerg for your answer. Your conclusion is based on the same query or also the other slow query log provided in the link? And how can we make sure, if the newer version of the layered navigation has solved these slow queries problems? Regards,
  3. Dear experts, I'm experiencing Server 503 errors and latency in loading pages specially in the BO because of my database slow queries. I'm running my website under a powerful VPS6 and My Hosting company have reposted that there are many SQL queries which are consuming the server resources and slowing down the whole website performance. The full slow queries log can be found here: http://kanaryluxuryw...om/slow-new.txt Here is a sample: # Time: 130616 9:34:35 # User@Host: canariwa_ps1502[canariwa_ps1502] @ localhost [] # Query_time: 8.607168 Lock_time: 7.531808 Rows_sent: 1 Rows_examined: 62512 SET timestamp=1371364475; SELECT fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value, COUNT(DISTINCT p.id_product) nbr, lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title , psi.price_min, psi.price_max, m.name FROM ps144_feature_product fp INNER JOIN ps144_product p ON (p.id_product = fp.id_product) LEFT JOIN ps144_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1) INNER JOIN ps144_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0)) LEFT JOIN ps144_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps144_layered_indexable_feature_lang_value lifl ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1) LEFT JOIN ps144_layered_indexable_feature_value_lang_value lifvl ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) INNER JOIN `ps144_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = 14) LEFT JOIN `ps144_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) WHERE p.`active` = 1 AND fp.id_feature = 16 AND p.id_product IN ( SELECT id_product FROM ps144_category_product cp INNER JOIN ps144_category c ON (c.id_category = cp.id_category AND c.nleft >= 54 AND c.nright <= 59 AND c.active = 1)) AND p.id_product IN (SELECT id_product FROM ps144_feature_product fp WHERE fp.`id_feature_value` = 67) AND p.id_product IN (SELECT id_product FROM ps144_feature_product fp WHERE fp.`id_feature_value` = 45) AND p.id_manufacturer IN (11) I need an expert who can help me optimize these queries, please help me know which module is causing this slow queries and how to modify them. Waiting your expert reply, Regards, Kanary.
  4. Dear experts, I'm facing difficulties understanding how the admin controllers are working and how I can edit the Product prices admin page. For example in PS 1.4.4 to add a new field in the product admin page, you go to admin/tabs/AdminProducts.php and edit there. But in PS 1.5, it has left tabs, so how can you add a new field in the Prices tab? Waiting your kind reply, Regards,
  5. Hello experts, Thank you for the excellent addon. I've installed it successfully in my shop: kanaryluxurywatches.com you can find an example using google rich snippet from here: http://www.google.co...ne-diamond.html But I've two questions please: 1) The prices appears like this: AED749.00. I need to add a space between the currency and the price. how can i do it? 2) The product thumbnail doesn't show up. Please advise Thanks again for the tool. I'm wondering when will google start showing up these snippets in the SERP! Regards,
  6. dear experts, I'm wondering how can i have an option to limit the availability of COD to a maximum price amount. For example if the product is over $1000, the COD won't be available. below the $1000 the COD courier service is available. please advise. thanks.
  7. Hello Mike, Is the English version available now for everybody? I want to enable it for my shop: www.canariwatches.com which has two languages: Arabic & English. I reside in UAE. Please advise... Thanks.
  8. Dear experts, All my shop's orders and invoices are without dates. It's completely empty field. please find attached. Appreciate your expert help because it's really a critical bug. Thanks, Hamouda
  9. Dear experts, mine is a more critical problem. I don't have dates in all Orders or invoices. Dates are simple not there. appreciate your expert advise please... thanks, Hamouda
  10. dear experts, My Categories Block suddenly started displaying the category ID in a strange manner. This problem appeared after moving my shop from a folder to the root directory. You can visit my website to see the problem: www.canariwatches.com Attached the problem snapshot. Waiting your expert help to remove these wrong IDs. Thanks & Regards, Hamouda
  11. dear experts, I'm having difficulties in PDF invoices because it displays ???? when it has non-english characters. So, i want to force the PDF invoices to display all the information using only one language (English), not the customer selected language. How can i do that? Appreciate your precious help, Regards.
×
×
  • Create New...