Jump to content

Sterminous

Members
  • Posts

    38
  • Joined

  • Last visited

Everything posted by Sterminous

  1. I got this problem solved, my template had demo store files and those files were messed up. Removed demo store files and did clean prestashop install and everything is working.
  2. MySQL says this error when i ran the first command: "#1091 - Can't DROP 'id_specific_price_rule_2'; check that column/key exists." And when i ran second command it says error: "#1061 - Duplicate key name 'id_product_2' ", i checked the table "ps_specific_price" and there is no column called id_product_2 Still can't add products
  3. I went to my phpmyadmin, selected database that i use, pressed the "SQL" tab and entered that command.
  4. When i tried to add products i got this error: " An error occurred while creating an object. product ", then i enabled debug mode and when i go to my store it says this error: " Key 'id_product_2' doesn't exist in table 'ps_specific_price' " SELECT *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` USE INDEX (id_product_2) WHERE `id_product` IN (0, 2) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2015-07-27 04:30:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2015-07-27 04:30:00' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 How to fix this? I reinstalled it many times, but always the same error. EDIT: I use Prestashop 1.6.1.0
  5. Error 1: Warning: File ./htdocs/header.php is deprecated in ./htdocs/classes/Tools.php on line 2137 Error 2: Warning: Function displayFooter() is deprecated in ./htdocs/footer.php on line 39 in ./htdocs/classes/Tools.php on line 2137 Error 3: Notice: ob_end_clean(): failed to delete buffer. No buffer to delete in ./controllers/admin/AdminCustomerThreadsController.php on line 478 Warning: Cannot modify header information - headers already sent by (output started at ./controllers/admin/AdminCustomerThreadsController.php:478) in ./controllers/admin/AdminCustomerThreadsController.php on line 479 Warning: Cannot modify header information - headers already sent by (output started at ./controllers/admin/AdminCustomerThreadsController.php:478) in ./controllers/admin/AdminCustomerThreadsController.php on line 480 Using prestashop 1.5.6.1
  6. If i try to change products per page, then it will give me this message [Debug] This page has moved Please use the following URL instead: ./index.php?id_category=13&controller=category&n=24 How to fix it, i couldn't find that place in FrontController.php, product-sort.tpl and pagination.tpl.
  7. Problem solved, these pages were disabled-.-
  8. I'm getting this error if i go to about us for footer cms block Warning: File ./htdocs/cms.php is deprecated in ./classes/Tools.php on line 2137 Warning: Cannot modify header information - headers already sent by (output started at ./classes/Tools.php:2137) in ./classes/Tools.php on line 105 Warning: Cannot modify header information - headers already sent by (output started at ./classes/Tools.php:2137) in ./classes/Tools.php on line 108 And if i try to go contact from the footer cms block, them i will get this error: Warning: File ./contact-form.php is deprecated in ./classes/Tools.php on line 2137 Warning: Cannot modify header information - headers already sent by (output started at ./classes/Tools.php:2137) in ./classes/Tools.php on line 105 Warning: Cannot modify header information - headers already sent by (output started at ./classes/Tools.php:2137) in ./classes/Tools.php on line 108 And where can i edit the footer cms block?
  9. In admin panel, Localization > Translations and i'm using gameworld theme
  10. I can't translate/edit email messages, i get this error: Notice: Use of undefined constant path - assumed 'path' in ./controllers/admin/AdminTranslationsController.php on line 2500 Warning: Cannot modify header information - headers already sent by (output started at ./controllers/admin/AdminTranslationsController.php:2500) in ./classes/Tools.php on line 141
  11. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY product_shop.id_product ORDER BY `sales` DESC LIMIT 0, 6' at line 29 SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new FROM `prestashop_product_sale` ps LEFT JOIN `prestashop_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN prestashop_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `prestashop_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 LEFT JOIN `prestashop_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN prestashop_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `prestashop_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2) LEFT JOIN `prestashop_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `prestashop_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 86 AND tr.`id_state` = 0 LEFT JOIN `prestashop_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN prestashop_stock_available stock ON (stock.id_product = p.id_product AND stock.id_shop = 1 ) WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND p.`id_product` IN () GROUP BY product_shop.id_product ORDER BY `sales` DESC LIMIT 0, 6 - now i have this error
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More