Jump to content

leonetrek

Members
 View Profile  See their activity

  • Posts

    20

  • Joined

  • Last visited

2 Followers

Profile Information

  • Activity
    User/Merchant

leonetrek's Achievements

Newbie

Newbie (1/14)

3

Reputation

  1. vekia started following leonetrek
  2. leonetrek
    I solved the issue and now the site works fast with 100,000 discount codes. I deleted the following on line 255 in /classes/cartRule.php: $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT * FROM `'._DB_PREFIX_.'cart_rule` cr LEFT JOIN `'._DB_PREFIX_.'cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = '.(int)$id_lang.') WHERE ( cr.`id_customer` = '.(int)$id_customer.' OR cr.group_restriction = 1 '.($includeGeneric ? 'OR cr.`id_customer` = 0' : '').' ) AND cr.date_from < "'.date('Y-m-d H:i:s').'" AND cr.date_to > "'.date('Y-m-d H:i:s').'" '.($active ? 'AND cr.`active` = 1' : '').' '.($inStock ? 'AND cr.`quantity` > 0' : '')); If anyone knows, would this affect the site somehow?
  3. leonetrek
    Yes, that line is deleted now
  4. leonetrek
    On another domain I installed Prestashop 1.5.6.2 and uploaded 60,000 discount codes and everything works perfectly except for a slight delay when inputing the actual code in the cart.
  5. leonetrek
    When I tried out what you suggested, the site started working faster. I added all the 5,000 discount codes but then it drastically slowed down again and the number of queries into the database didn't decrease. SQL Queries: 30154 queries in 39235 ms - 5,000 discount codes
  6. leonetrek
    Thanks for the reply. But this does not solve the problem
  7. leonetrek
    I turned on Debug mode and saw that there were over 150 number of queries into the database, without the coupons. After I added coupons, the number of queries increased to over 80000. Why are there queries sent into the database if I simply added the coupons and that's it. The site is currently in debug mode and I left 3 coupons. With each coupon I add, increases the number of queries 4 times.
  8. leonetrek
    I added 21,000 discount codes to the cart rules with different numbers. 7,000 for one item 7,000 for second item 7,000 for the third item After this, the site is very slow after adding anything to the cart (it loads slowly and adding to cart or deleting an item from the cart is very slow). I checked the database, and saw that the entries for these codes are located in 5 tables with 100,000 entries in those tables. Can this affect the site speed? I using Prestashop 1.6.0.11 Here is the link to the site on a test domain so you can check how slow the site is loading - http://www2.sovkaz.com/
  9. leonetrek
    tuk66 thanks for the reply. And you can details? I'm not very good at PHP
  10. leonetrek
    Tried classes/order/OrderInvoice.php: change: public function getProductsDetail() { return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT * FROM `'._DB_PREFIX_.'order_detail` od LEFT JOIN `'._DB_PREFIX_.'product` p ON p.id_product = od.product_id LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop) WHERE od.`id_order` = '.(int)$this->id_order.' AND od.`id_order_invoice` = '.(int)$this->id); } to: public function getProductsDetail() { return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT * FROM `'._DB_PREFIX_.'order_detail` od LEFT JOIN `'._DB_PREFIX_.'product` p ON p.id_product = od.product_id LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON pl.id_product = od.product_id LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop) WHERE od.`id_order` = '.(int)$this->id_order.' AND od.`id_order_invoice` = '.(int)$this->id); } Didn't work 1.6.0.9
  11. leonetrek
    How to Add Product Short Description into invoice pdf? Prestashop 1.6.0.9
  12. leonetrek
    Actual question!
  13. leonetrek
    Yes. Thank that have responded. I have already solved this problem. On my 1.5.4.1 It works Here's a link to solve http://www.prestashop.com/forums/topic/228277-get-customer-group-id-in-smarty/
  14. leonetrek
    Hello. How can I show the name of the group user on all pages near the price? And in the heder near basket? Thank`s Prestashop 1.5.4.1
  15. leonetrek
    Я так понял, человек говорит, что стандартный css подгоняли под шаблон сайта. Вот поэтому, расположение и стили при полном обновлении слетят. Стили можно сохранить отдельно, что бы они не перезаписались. А вот если менялись хуки (изменения в php файле), то я не знаю чем помочь, так как не знаю где именно была проблема с этим модулем и после полного обновления все удалится!
  16. leonetrek
    Поставил вот такой модуль http://addons.prestashop.com/en/front-office-features-prestashop-modules/7497-request-callback.html Был очень рад его работой. Но потом, прошло какое то время и я заметил, что звонки, которые приходят в админку не возможно редактировать - не появляется всплывающая таблица. Я его удалил и поставил заново. Проблема осталась та же. Сам модуль рабочий, а вот в админке теперь у меня все заказанные звонки висят со статусом "не обработанный". Поставил этот модуль на чистый престашоп - там работает. Посмотрел через firebug и заметил вот такую штутку. После нажатия на редактирование звонка появляется вот такая строка <tr id="frcallbacks_edit_form" style=""></tr>, но она пустая - туда ничего не подгрузилось. Кто сталкивался с такой проблемой и смогу ее решить - отпишитесь плиз
×
×
  • Create New...