Products Disappeared After Updating Description

[stopshop]

The strangest thing happened this morning after updating a product's description as I've been doing on a daily basis and without any problems. All products disappeared from both front and back end, they're simply gone and no where to be found.

 

After updating a product's descripion, basically changing a "no" to a "yes", I received the following error message; "an error occurred while updating object product". At this point, all products are no longer visible although everything else in my BO seems to be ok. Not 100% sure of the version I'm using but I think it's 1.1 in case that matters.

 

I also had a look at the error log and found the following towards the bottom from the same time onwards that the problem happened;

 

[05-Jan-2012 14:41:49] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 698

[05-Jan-2012 14:41:49] PHP Warning: uasort() [<a href='function.uasort'>function.uasort</a>]: The argument should be an array in /home/stopshop/public_html/classes/Tools.php on line 701

[05-Jan-2012 14:41:49] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 704

[05-Jan-2012 14:41:56] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 698

[05-Jan-2012 14:41:56] PHP Warning: uasort() [<a href='function.uasort'>function.uasort</a>]: The argument should be an array in /home/stopshop/public_html/classes/Tools.php on line 701

[05-Jan-2012 14:41:56] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 704

[05-Jan-2012 14:42:51] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 698

[05-Jan-2012 14:42:51] PHP Warning: uasort() [<a href='function.uasort'>function.uasort</a>]: The argument should be an array in /home/stopshop/public_html/classes/Tools.php on line 703

[05-Jan-2012 14:42:51] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 704

[05-Jan-2012 14:45:11] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 698

[05-Jan-2012 14:45:11] PHP Warning: uasort() [<a href='function.uasort'>function.uasort</a>]: The argument should be an array in /home/stopshop/public_html/classes/Tools.php on line 703

[05-Jan-2012 14:45:11] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 704

[05-Jan-2012 14:50:36] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 698

[05-Jan-2012 14:50:36] PHP Warning: uasort() [<a href='function.uasort'>function.uasort</a>]: The argument should be an array in /home/stopshop/public_html/classes/Tools.php on line 701

[05-Jan-2012 14:50:36] PHP Warning: Invalid argument supplied for foreach() in /home/stopshop/public_html/classes/Tools.php on line 704

 

 

When this problem happened, I contacted Hostgator to restore my backup which they did and everything was working fine until I updated or at least tried to update the same product's description which now caused the same problem. So I don't think that paying Hostgator another 15$ for restoring the site is the solution because the problem actually needs to be resolved but I have absolutely no idea what's causing it.

 

BTW, I have another site (for the International market) with the exact same products and I just tried updating the same product's description and did so without any issues, so I'm 100% sure that the actual description is not the cause.

 

Any help, input or suggestions is appreciated!

[Guest Stephen Bromfield]

Hi stopshop,

 

I have a few questions. What version of PrestaShop are you using? Can you give me a link to product that is causing the error? Also, post what changes you were making to the product.

 

I will try to recreate the error on my machine and see if I can help you out.

 

-Stephen

[stopshop]

Hi Stephen, thanks for making the effort to assist.

 

I remember that I could see the version in the BO footer when PS was first installed but I have someone working on the site over 2 years ago and since then it just says Powered by StopShop which is the company name. I think it's version 1.1, is there another way to view the exact version I'm currently using?

 

As requested, the link of the product that I updated is as follows; http://www.stopshop.co.za/254-buy-audi-a3-dvd-gps-satnav

 

The only change I made was to copy the html, paste it into Frontpage and change one of the specifications from "no" to "yes". I then copied and pasted the new html into PS's BO and hit the update button as I always do (on a daily basis), this is when I got the error message "an error occurred while updating object product". Once the error appears, this is when all products go missing from the front end as well as from Catalog in my BO.

 

 

Once again, thanks for helping!

[Guest Stephen Bromfield]

You can check the version by loging in to your back office and looking at the bottom of the page. Can you verfity your version so I know I'm installing the right version?

 

Aslo, if you are running 1.1 you might want to think about updating your prestashop install.

 

-Stephen

[stopshop]

Ok, I managed to find the first backup so I replaced footer.inc.php with the original file which allows me to view the version in the BO - Version 1.0.0.4 - 0.210s

 

We changed so many things over the past 2 years that I got to worried about updating to the latest version, would probably end up causing more harm than good so I just left it the way it was :-s

 

I'm considering upgrading to a later version as well as to revamp the store with a new template, already contacted Template Monster to see if they can install a later version, new template and put my existing DB back into the new version. Do you know where I could get this done for a fair price?

 

 

Thanks..

[Guest Stephen Bromfield]

You can give us a call and I'm sure we can work something out. =) 1 (888) 947-6543. By the way, we are open from 9am to 6pm EST.

 

Also, I'm install that version of prestashop now and we will see if I can help you out. =)

[Guest Stephen Bromfield]

Hey stopshop,

 

I just sent you a PM.

[stopshop]

Thanks Stephen, is that a US number? Doesn't seem to work from here, can you please include the International dialing code and do I just for you?

 

I just asked Hostgator to restore the backup so that at least I have the site up and running for now cause I'll be travelling for a fews days so I don't want the site in maintenance mode until I get back. I think what I need done after I'm back is to get the latest version installed, a new template and my DB in the new version.

 

 

Thanks..

[Mike Kranzler]

Hi stopshop,

That is a US number, so there shouldn't be any issues. From South Africa (assuming you're located there along with your site) just dial 00 + 1 + 888 947 6543 (unless there are toll-free laws I'm not familiar with over there).

 

I hope this helps

 

-Mike

[stopshop]

Sorry for only replying now, just got back from a short trip. Had my host restore the latest backup so that the site would be up and running which is what I needed for now just to keep things on the go. I'm going to go ahead with the updating my current version to the latest which should hopefully get rid of some bugs, you'll be hearing from me Stephen via the support ticket.

 

Many thanks!