Jump to content

Very strange, the quantities of all products became zero.


Recommended Posts

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

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

 

09.29.2013-18.08.png
http://screencast.com/t/IL2omeToN

Link to comment
Share on other sites

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 by Sphyrna (see edit history)
Link to comment
Share on other sites

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

  • 3 weeks later...

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

×
×
  • Create New...