Search the Community

Hi All , I migrated prestashop 1.7.4 to 1.7.6. everything works fine. when I click on "New Product" on the catalog, it redirects me to the backoffice home page. I activated the debug mode, and I get the following message : ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ PrestaShopDatabaseException HTTP 500 Internal Server Error Out of range value for column 'id_product' at row 1<br /><br /><pre>INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '1', '2', '1', '0', '0', '0', '1', NULL, '0', '0', '0', '', '0', '0', '0', '0', '0', '1', '', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2019-11-30 12:51:51', '2019-11-30 12:51:51', '3')</pre> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ PrestaShopDatabaseException in classes/db/Db.php (line 769) if ($webservice_call && $errno) { $dbg = debug_backtrace(); WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { if ($sql) { throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); } throw new PrestaShopDatabaseException($this->getMsgError()); } } DbCore->displayError('INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES (\'1\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'1\', \'2\', \'1\', \'0\', \'0\', \'0\', \'1\', NULL, \'0\', \'0\', \'0\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'1\', \'\', \'0\', \'1\', \'0000-00-00\', \'0\', \'new\', \'1\', \'0\', \'both\', \'0\', \'0\', \'2019-11-30 12:51:51\', \'2019-11-30 12:51:51\', \'3\')')in classes/db/Db.php (line 385) DbCore->query('INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES (\'1\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'1\', \'2\', \'1\', \'0\', \'0\', \'0\', \'1\', NULL, \'0\', \'0\', \'0\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'1\', \'\', \'0\', \'1\', \'0000-00-00\', \'0\', \'new\', \'1\', \'0\', \'both\', \'0\', \'0\', \'2019-11-30 12:51:51\', \'2019-11-30 12:51:51\', \'3\')')in classes/db/Db.php (line 740) DbCore->q('INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES (\'1\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'1\', \'2\', \'1\', \'0\', \'0\', \'0\', \'1\', NULL, \'0\', \'0\', \'0\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'1\', \'\', \'0\', \'1\', \'0000-00-00\', \'0\', \'new\', \'1\', \'0\', \'both\', \'0\', \'0\', \'2019-11-30 12:51:51\', \'2019-11-30 12:51:51\', \'3\')', true)in classes/db/Db.php (line 476) DbCore->insert('product', array('id_shop_default' => 1, 'id_manufacturer' => 0, 'id_supplier' => 0, 'reference' => '', 'supplier_reference' => '', 'location' => '', 'width' => 0, 'height' => 0, 'depth' => 0, 'weight' => 0, 'quantity_discount' => 0, 'ean13' => '', 'isbn' => '', 'upc' => '', 'cache_is_pack' => 0, 'cache_has_attachments' => 0, 'is_virtual' => 0, 'state' => 0, 'additional_delivery_times' => 1, 'id_category_default' => 2, 'id_tax_rules_group' => 1, 'on_sale' => 0, 'online_only' => 0, 'ecotax' => 0, 'minimal_quantity' => 1, 'low_stock_threshold' => array('type' => 'sql', 'value' => 'NULL'), 'low_stock_alert' => 0, 'price' => 0, 'wholesale_price' => 0, 'unity' => '', 'unit_price_ratio' => 0, 'additional_shipping_cost' => 0, 'customizable' => 0, 'text_fields' => 0, 'uploadable_files' => 0, 'active' => 1, 'redirect_type' => '', 'id_type_redirected' => 0, 'available_for_order' => 1, 'available_date' => '0000-00-00', 'show_condition' => 0, 'condition' => 'new', 'show_price' => 1, 'indexed' => 0, 'visibility' => 'both', 'cache_default_attribute' => 0, 'advanced_stock_management' => 0, 'date_add' => '2019-11-30 12:51:51', 'date_upd' => '2019-11-30 12:51:51', 'pack_stock_type' => 3), false)in classes/ObjectModel.php (line 561) ObjectModelCore->add(true, false)in classes/Product.php (line 603) ProductCore->add(true, false)in classes/ObjectModel.php (line 516) ObjectModelCore->save()in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 407) ProductController->newAction() call_user_func_array(array(object(ProductController), 'newAction'), array())in var/cache/dev/classes.php (line 4581) HttpKernel->handleRaw(object(Request), 1)in var/cache/dev/classes.php (line 4536) HttpKernel->handle(object(Request), 1, false)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200) Kernel->handle(object(Request), 1, false)in administration-bo/index.php (line 86) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Version de PrestaShop : 1.7.6.1 Version de MySQL : 5.5.64-MariaDB Version du logiciel serveur : Apache/2.4.6 Version de PHP : 5.6.40 Limite de mémoire : 256M Temps maximal d'exécution : 300 I hope someone can help me to fix the problem :(. Thank you for any help.

Hi, there is a bug creating products. when you click add a new product and you do not type anything, just jump to other part let say attribute on the left menu, the system create a empty product that is show on the front end but not on the list of products on the back end. To solve the issue you have to go to the DB and erase manually the empty product on all DB that is created.

Hi friends By mistake i have added a new product but with out name or photo. and now i can not delete this product because is not in the products catalog, although is in my shop.. how can i delete this ghost product? please help and advise Thank you in advance Vasilios

Hello i have one little problem with my prestahop. After I imported products, I can not add new one. Can you help me? Version of prestashop: 1.7.0.4

Everything i'll mention happened suddenly without changing anything. I'm using Prestashop v.1.6.0.9. The last thing i changed at the code was weeks before that and everything worked like charm. So, 3 days before, I was adding products normally for hours and then that happened: Back Office: -Calalogue -> Products -> When i create a new product or replicate one, it appears normally and then if i refresh the page it disappears, then if i refresh again it appears etc. If i enable it, then i can't disable it. -Preferences -> Search -> "Add missing products to the index" -> when i click it, it appears like it was indexed as i get a plus one number to the one i had and then if i refresh the page i get the number before indexing. -Modules -> Modules -> If i choose to see for example the disable modules, the page reloads and i still see the last option and not the one i chose. -Advanced Parameters -> Performance -> Features were disabled by itself. Then I changed it back to enable, i saved it and nothing changed. I had to try a lot of times to make it enabled. Front Office: -Language Change -> when I try to click the different language, the Languages "Window" go up and down so i can't click one. -Carousels with "New Products", "Feature Products" and "Manufacturers" change (turn around to the next "page") with huge speed The problem is that if i change something, i can undo it. But now i have no idea why site crashed like that, when the last changes i made happened weeks before from the day all these problems appeared at the same moment. I also created a ticket, but noone could help me. If anyone has any idea, please tell me. Thank you in advance, Theodora

Hello, I use Advanced Stock Management, when I add a new product in the database the field 'advanced_stock_management' stays 0 instead of 1 (in ps_products and ps_products_shop). In the product preferences the 'New products use advanced stock management' is checked and the 'Default warehouse on new products' is set to my warehouse. What is wrong, It's a clean installation version 1.6.1.18 Regards, Koen

Hello everyone, Currently my store (over 1500 products) is on sale for seasonal change, for this I use a catalog price rule. Now I want to upload products of the new season and, until now, so that they do not have the discount, I used a specific price rule of 0% discount. The problem is that the tab with the offers shows all products with a specific price assigned, even if it is 0%. The ideal scenario would be to have only the discounted products in the Offers tab. I tried, instead of assigning a specific price of 0%, assign a "New Season" category to then configure the conditions in the catalog price rule. However, this solution does not work in my case, since all products are in more than one category, so they end up showing anyway. I've been searching the forum and the Internet, even for some code solution that excludes new products from the catalog price rule, or some code that keep out 0% discounted products from the Offers tab, but I can not find anything! Has anyone had the same problem and has managed to fix it? Thank you very much in advance!

Hi, I have updated the colors in Attributes, adding some new and changing all their names (to Italian) and color codes, but I see different colors in the New Product page, Combinations tag. Please see the images below. Any chance to show them correctly? Many thanks Color list: Colors shown in the Combinations tag of New Product page:

Hi first sorry for my bad English. Is there a way to change some character of product name when the new product submitted? for example, replace all 'Z' with 'z' in the new product name. in other words, i need to know which PHP file or function get new product informations such as product name to save on DB. for more detail, i need this feature because my products names have Persian characters. some of my co-workers have Arabic keyboard and "ی" in Persian has different code with "ي" in Arabic. so some product written with Arabic chars and some with Persian chars. and it cause many problems in search module and ... . Thanks.

Hello! Is it possible to change the default product quantity when adding a new product? My client buys most products in bulk so it would save alot of time. The shop is using PS: 1.6.1.13 Thanks in advance! Regards, Frank

Hi Does anyone know if a module is available for shop owner to change a product to new or not? As standard Prestashop has several days where a new added product will be shown as new, but is there a module that can disable this config and let the shopowner deside if the product is new or not? It should be for Prestashop 1.5.

When i create a product and click save and stay i get this url: http://www.glamourshoesaccessori.it/gestione/index.php?controller=AdminProducts&token=d218ae093c2d768c769c84fa563e8654&addproduct If u see there's no the product ID of generated product so the product is generated but i am redirected to new product page, so to complete the product details with images and variations i have to back to all products, search that product and edit, so this is not simply and is annoyng for my employees, how can i solve that?

Buongiorno a tutti, sono nuovo del forum, vi scrivo perchè è da circa 1 settimana che riscontro questo problema, non riesco ad inserire e/o modificare un prodotto. I pulsanti in basso di "Salva" e "Salva e Rimani" caricano in continuazione senza fermarsi mai, ho provato a fare dei downgrade delle versioni e l'unico che funziona è la versione 1.6.0.9, le successive mi danno sempre lo stesso problema, mi potete aiutare ???? Vi allego le immagini del problema e le informazioni del sistema Grazie in anticipo!

I am using Prestashop 1.5.6.2 for my website, I have installed New Product Block module and Featured Product on the homepage Module, Now i have having below error / problem while displaying new products. 1) When i upload a new product and associate with "Home" category it displayes that product in both "new product block" and "featured product block". 2) When i upload a new product and DO NOT ASSOCIATE it with "home" category it does not display the product in any of the above blocks Number of days for which the product is considered 'new' is kept 10 Days Pls guide me on the same on how to proceed further. Awaiting reply and guidance from seniors.

Good morning! I need help : When I load my homepage, it does not display automatically the content of my first (and only one) tab (Block New Product), I must click on the tab "New product" to show the block. I need to show it as soon as my page is loaded! It is the same problem with every module I tried (home-feature, best-sales, etc). It did work correctly, at the begining! And I can't understand why it doesn't work anymore, because all I basicly did was changing CSS and modul's positions. But if you have an idea to help me, it will be great! Thank you!

Hello Can anyone please tell me how to Hook lof new product to home i couldn't find any hooking option to homepage below see the images A little description will great about how to do it. I need this urgent

Problem in selecting category..I cannot see the new category in the association tab when adding products....But I am able to see it after about one day...Can you tell me what is the issue ..and how to fix it?

Being a complete novice at Prestashop (and NOT a coder), is there an easy way to replace the "New" product label with another image? Using 1.5.4 default theme and a custom theme.

When i try to add new virtual product to prestashop, i get some error, which i dont know how to fix. Error code: Fatal error: Uncaught exception 'UnexpectedValueException' with message 'RecursiveDirectoryIterator::__construct(/home/relectne/relect.net/html/shop/cache/smarty/cache/blocknewproducts/20141018): failed to open dir: Permission denied' in /home/relectne/relect.net/html/shop/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php:196 Stack trace: #0 [internal function]: RecursiveDirectoryIterator->__construct('/home/relectne/...', 0) #1 /home/relectne/relect.net/html/shop/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php(196): RecursiveDirectoryIterator->getChildren() #2 /home/relectne/relect.net/html/shop/tools/smarty/Smarty.class.php(837): Smarty_Internal_CacheResource_File->clear(Object(Smarty), '/home/relectne/...', 'blocknewproduct...', NULL, NULL) #3 /home/relectne/relect.net/html/shop/classes/Tools.php(2596): Smarty->clearCache('/home/relectne/...', 'blocknewproduct...', NULL) #4 /home/relectne/relect.net/html/shop/classes/module/Module.php(2118): ToolsCore::clearCache(Object(Smarty), '/home/relec in /home/relectne/relect.net/html/shop/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php on line 196 Anyone knows how to repair this?

Hi thre , I am new to prestashop . I have a Alysum template for my e-commerce site.I'm facing two issues 1. since over a week i am unable to create new products in the catalogue. Each time i want to do that it gives me an error message, plus says I first have to add it in a category first (which was never the case before). this is the error message: "A server error occured while loading the tabs: some tabs could not be loaded. Please try again by refreshing the page. (that doesn't work) If you are still encountering this problem please check your server logs or contact your hosting provider for assistance. " 2. when creating categories, i cant see any parent categories anymore. when getting rid of all the default categories, the parent categories dissapeared and now even when creating new categories, there arent any parent categories anymore. 3. How do i create subcategories in the flexmenu for Alysum? for instance -THE BRAND (categorie) - About the brand (subcategory) : when you click on this you should have text about the brand. - Collection - Lookbook : when you click on it you should see pictures of the lookbook.

Sono un nuovo utilizzatore di PrestaShop ma alla prima installazione (dopo l'entusiasmo iniziale per potenzialità, caratteristiche e gestione della vendita di file digitali) trovo il primo intoppo: al momento di aggiungere nuovo prodotti o editare quelli esistenti (installazione appena effettuata, sui dati dimostrativi) mi viene mostrata una pagina bianca: Ho provato a re-installare tutto ma niente: ottengo sempre lo stesso risultato. Dove sta l'inghippo? CIao

I get this error " An error occurred while updating an object. product () " when I try and edit a existing product or if I try and make a new product I get this error " An error occurred while creating an object. product " anyone have an idea how to solve this...

Hello all, Not sure if many may find this useful.... but I had a bit of a problem... see I wanted the new product module block to show the oldest - newst products first... That way after the time is up where products are no longer consider new it moves on to the second to oldest etc.... I found that if you edit file: classes/Product.php around line 2033 if (empty($order_way)) $order_way = 'DESC'; to if (empty($order_way)) $order_way = 'ASC'; Save. I am sure there is a way to edit the function call in thew new product block module... but since

Hi I want to both translate and to add words at the "Product status". (New, Used, Refurbished) I need to add "Demo-model" (Demonstration-model) to the dropdownlist ... and translate to Danish also. Can anyone tell me where I do this? www.ani-event.dk

Hi, Since 2 days I am not anymore able to load CSV files or reindex the products. About CSV the website return timout error even with one only product or category. About reindex when I click on add missing product to the index the website return operation sussesfull but no actions are execute and no products are added. The website works properly http://store.otticapomezia.it but I am not able to update it anymore via CSV. Please suggest me some actions to take, it could be a problem with DB, my hosting is OVH with a private Sql. Everythings worked fine about one month ago, maybe the statistics create problems in the last period.