1117 Posted September 29, 2013 Share Posted September 29, 2013 I've been noticing that a while ago, problems have arisen quite strange and without anyone touching the site. Today, very strange for no apparent reason. The quantities of all products became zero. Is this happened to somebody else? And my luck was, I make backups in every nights. Link to comment Share on other sites More sharing options...
El Patron Posted September 29, 2013 Share Posted September 29, 2013 please post your ps version, helps when searching I did some searches and the similar posts have gone unresolved...so far when I see something like this and search and see similar issues with no resolution, my money would be on a module that is hooking into my product update path...just a guess modules-->positions-->select Display non-positionable hooks look for a module maybe hooked here, again a guess...but you get the idea http://screencast.com/t/IL2omeToN Link to comment Share on other sites More sharing options...
Sphyrna Posted September 30, 2013 Share Posted September 30, 2013 (edited) Hi, I also had this issue and it has happened again, all products are reset to 0 in stock. What is the recommended action? Should I go though and eliminate all possible modules? Is the security integrity of the site maintained? 1117 if you want to compare a list of modules to see if we can narrow it down I've posted the list installed on my store below. Sorry it's so long. Thanks Artichow INSTALLED Developed by :PrestaShop| Version :1 | Category :Administration Description : Artichow is a library that enables the display of simple picture-based graphs using PHP and GD. Best categories INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : A list of the best categories Best customers INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : A list of best customers. Best suppliers INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : A list of the best suppliers Best vouchers INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : A list of the best vouchers Bloc publicité INSTALLED Developed by :PrestaShop| Version :0.5 | Category :Advertising and Marketing Description : Ajoute un bloc affichant une publicité Block contact info INSTALLED Version :1.0 | Category :Front Office Features Description : This module will allow you to display your e-store's contact information in a customizable block. CMS Block INSTALLED Developed by :PrestaShop| Version :1.1.1 | Category :Front Office Features Description : Adds a block with several CMS links. Carrier distribution INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display each carriers' distribution. Cart block INSTALLED Developed by :PrestaShop| Version :1.2 | Category :Front Office Features Description : Adds a block containing the customer's shopping cart. Catalog evaluation INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Quick evaluation of your catalog quality. Catalog statistics INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : General statistics about your catalog. Categories block INSTALLED Developed by :PrestaShop| Version :2.0 | Category :Front Office Features Description : Adds a block featuring product categories. Connect to USPS INSTALLED Developed by :PrestaShop| Version :1.3 (Update 1.3.1 Available on PrestaShop Addons) | Category :Shipping and Logistics Description : Calculates shipping rates for United States Postal Service for Domestic shipping within the USA. Contact Block INSTALLED Version :1.0 | Category :Front Office Features Description : Allows you to add additional information about your store's customer service. Currency block INSTALLED Developed by :PrestaShop| Version :0.1 | Category :Front Office Features Description : Adds a block allowing customers to choose their preferred shopping currency. Customer accounts INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display registration progress. Customer data privacy block. INSTALLED Developed by :PrestaShop| Version :1.0 | Category :Front Office Features Description : Adds a block displaying a message about a customer's privacy data. Customer reassurance block INSTALLED Version :2.0 | Category :Front Office Features Description : Adds an information block aimed at offering helpful information to reassure customers that your store is trustworthy. Data mining for statistics INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : This module must be enabled if you want to use statistics. Facebook sharing block. INSTALLED Version :1.0 | Category :Front Office Features Description : Allows customers to share your products -- or website content -- on Facebook. Favorite Products INSTALLED Developed by :PrestaShop| Version :1 | Category :Front Office Features Description : Display a page featuring the customer's favorite products. Featured products on the homepage. INSTALLED Developed by :PrestaShop| Version :0.9 | Category :Front Office Features Description : Displays featured products in the middle of your homepage. Google Chart INSTALLED Developed by :PrestaShop| Version :1 | Category :Administration Description : The Google Chart API lets you dynamically generate charts. Image slider for your homepage. INSTALLED Developed by :PrestaShop| Version :1.2.1 | Category :Front Office Features Description : Adds an image slider to your homepage. Import/export a theme INSTALLED Developed by :PrestaShop| Version :2.4 | Category :Administration Description : Export or Install a theme and its modules on your shop. Language block INSTALLED Developed by :PrestaShop| Version :1.1 | Category :Front Office Features Description : Adds a block allowing customers to select a website language. Manufacturers block INSTALLED Developed by :PrestaShop| Version :1 | Category :Front Office Features Description : Displays a block listing product manufacturers and/or brands. Merchant Expertise INSTALLED Developed by :PrestaShop| Version :1.4.5 (Update 1.5.1 Available on PrestaShop Addons) | Category :Administration Description : Become an e-commerce expert within the blink of an eye! My Account block INSTALLED Developed by :PrestaShop| Version :1.2 | Category :Front Office Features Description : Displays a block with links relative to a user's account. My account block for your website's footer INSTALLED Developed by :PrestaShop| Version :1.2 | Category :Front Office Features Description : Displays a block with links relative to user accounts. New products block INSTALLED Developed by :PrestaShop| Version :0.9 | Category :Front Office Features Description : Displays a block featuring your store's newest products. Newsletter INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display newsletter registrations. Newsletter block INSTALLED Developed by :PrestaShop| Version :1.4 | Category :Front Office Features Description : Adds a block for newsletter subscription. Pages not found INSTALLED Developed by :PrestaShop| Version :1.1 | Category :Analytics and Stats Description : Display the pages requested by your visitors that have not been found. PayPal USA, Canada INSTALLED Version :1.2.1 (Update 1.2.6 Available on PrestaShop Addons) | Category :Payments and Gateways Description : Accept payments using PayPal's Express Checkout, PayPal Payments Standard, Advanced, Pro, or Payflow. Payment logo block. INSTALLED Developed by :PrestaShop| Version :0.2 | Category :Front Office Features Description : This block will display all of your payment logos. Permanent links block INSTALLED Developed by :PrestaShop| Version :0.1 | Category :Front Office Features Description : Adds a block that displays permanent links such as sitemap, contact, etc... PrestaShop Cleaner INSTALLED Developed by :PrestaShop| Version :0.9 | Category :Administration Description : Check and fix functional integrity constraints and remove default data Product details INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Get detailed statistics for each product. Quick search block INSTALLED Developed by :PrestaShop| Version :1.2 | Category :Search and Filter Description : Adds a quick search field to your website. RSS products feed. INSTALLED Developed by :PrestaShop| Version :0.3 | Category :Front Office Features Description : Generate an RSS products feed. Registered customer information INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display characteristics such as gender and age. Sales and orders INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display sales evolution and orders by status. Search engine keywords INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display which keywords have led visitors to your website. Shop search INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display which keywords have been searched by your store's visitors. Simple HTML table display. INSTALLED Developed by :PrestaShop| Version :1 | Category :Administration Social networking block INSTALLED Version :1.0 | Category :Front Office Features Description : Allows you to add information about your brand's social networking sites. Software INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display the software used by visitors. Stats Dashboard INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Stats on available quantities. INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Store locator block INSTALLED Developed by :PrestaShop| Version :1 | Category :Front Office Features Description : Displays a store locator link directly on your webiste. Suppliers block INSTALLED Developed by :PrestaShop| Version :1 | Category :Front Office Features Description : Adds a block displaying product suppliers. Tags block INSTALLED Developed by :PrestaShop| Version :1.1 | Category :Front Office Features Description : Adds a block containing product tags. Top horizontal menu INSTALLED Developed by :PrestaShop| Version :1.5 | Category :Front Office Features Description : Add a new horizontal menu to the top of your e-commerce website. Top-seller block INSTALLED Developed by :PrestaShop| Version :1.1 | Category :Front Office Features Description : Add a block displaying your store's top-selling products. User info block INSTALLED Developed by :PrestaShop| Version :0.1 | Category :Front Office Features Description : Adds a block that displays information about the customer. Viewed products block. INSTALLED Developed by :PrestaShop| Version :0.9 | Category :Front Office Features Description : Adds a block displaying recently viewed products. Visifire INSTALLED Developed by :PrestaShop| Version :1 | Category :Administration Description : Visifire is a set of open-source data visualization components -- Powered by Microsoft Silverlight 2 (beta 2). Visitors online INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display the list of customers and visitors currently online. Visitors origin INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Display the website(s) your visitors came from. Visits and Visitors INSTALLED Developed by :PrestaShop| Version :1 | Category :Analytics and Stats Description : Displays statistics about your visits and visitors. Watermark INSTALLED Developed by :PrestaShop| Version :0.3 | Category :Administration Description : Protect image by watermark. XML/SWF Charts INSTALLED Developed by :PrestaShop| Version :1 | Category :Administration Description : XML/SWF Charts are simple, yet powerful tools using Adobe Flash to create attractive web charts and graphs from dynamic data. Edited September 30, 2013 by Sphyrna (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted September 30, 2013 Share Posted September 30, 2013 probably only care about Display non-positionable hooks, I would look at all third party modules first...listing like you did doesn't get us far because I have a short attention span and won't read all that Also check your configuration from the back office, look for the differences between your shop and the native prestashop..it runs a report...but to debug this sort of issue given search results in a forum...is going to be rather difficult. You should also a bug report, they are very good at looking at issues...http://forge.prestashop.com/secure/Dashboard.jspa make sure to include this post link there...then post the forge bug report back here so we can vote it up.. Link to comment Share on other sites More sharing options...
Sphyrna Posted September 30, 2013 Share Posted September 30, 2013 Hi, Thanks for the response, I wasn't really expecting anyone to go through those that wasn't actually suffering from the problem. :-) I reported it here: http://forge.prestashop.com/browse/PSCFV-10540 Guess we will have to wait and see. Thanks! 1 Link to comment Share on other sites More sharing options...
Sphyrna Posted October 19, 2013 Share Posted October 19, 2013 I think I have discovered that this is linked to the prestashop cleaner module. It is reporting this as cleaned "The following queries successfuly fixed broken data: DELETE FROM `prstshp_stock_available` WHERE `id_shop_group` NOT IN (SELECT `id_shop_group` FROM `prstshp_shop_group`) 9 line(s)" I don't know why this would be considered broken code. Link to comment Share on other sites More sharing options...
vekia Posted October 19, 2013 Share Posted October 19, 2013 you use prestashop cleaner module on store which works normally and isn't dev version? Link to comment Share on other sites More sharing options...
Sphyrna Posted October 19, 2013 Share Posted October 19, 2013 Hi, Yes, this is an updated store from 1.5.4 to 1.5.6 and cleaners version .9. Everything else seems to be working okay. Link to comment Share on other sites More sharing options...
Recommended Posts