Fatal error</b>: Class 'PEAR5' not found in....

Can someone please help me? I have spent the last two days just trying to get 50 new products uploaded to my store and I am majorly frustrated right now as I have at least 500 more products to add. I have exported the spreadsheet, spent a day to get these 50 products and options added to the spreadsheets, imported the spreadsheet back in. I do have those 50 items on, but now I am trying to export the spreadsheet again so I can work on adding more products. I am doing this in stages so it will be easier to narrow down if there is a problem with an upload.

Anyway - Now when I export the spreadsheet from Open Cart, this is what is in the spreadsheet.

<br />
<b>Fatal error</b>: Class 'PEAR5' not found in <b>/home/.../public_html/system/pear/PEAR.php</b> on line <b>838</b><br />

This is so frustrating and time consuming, I am about to move my store back to Yahoo where I had it for the first year. I prefer not to do that, but my store is going down the tubes as I have not been able to post new products since I migrated to Open Cart. Any help will be greatly appreciated!! Thanks in advance.

Not to be a jerk (which means I'm probably about to be a jerk here) but if JN's excel import/export module says it requires PEAR5 to be installed on your server to function and it isn't whose fault is that?

Not to be a jerk back, but it is installed.

This did work twice already, and now it stopped working. I even contacted my host and below is their response:

"I see pear was loaded on this server can you provide a way for us to replicate this issue so we can further investigate ?"

Also, I am not a developer. I paid someone to set this store up for me and now I need support. I was not aware of the lack of support that comes with OpenCart or I would not have used it when it was suggested to me, since I am not a developer myself. Since I already paid for this site to be developed, I was hoping to continue using it until I get a return back on my investment, but now that this is broken, I guess I am going to have to find another shopping cart solution. This is a great solution for a programmer/web developer. It would even be great for me if there were answers on things like this. Tell me what I need to look for and I will figure it out.

I thought these forums were to get help and not for people to attack someone that is not familiar with this stuff? I am an IT professional, however, not in web development so I count on recommendation from people I hire to do the development end of things and take it from there.

So that being said, since PEAR is installed, why all of a sudden is this not working? I was able to export my entire product tables yesterday and several times before. I added 50+ new products to the table and imported them. My store has the products out there, but now I need to export these tables again so I can add more products. If anyone could help instead of attack, it would be greatly appreciated.

PS - What I meant by "I have not been able to upload new products for months", is that I was informed to be careful as downloading all the products (3000+) and uploading them back up, there is a chance of corrupting the database. So I was waiting for my developer to create an import/export tool which would allow me to append. Unfortunately, I am unable to wait as all my vendors put out hundreds of new products and I am way behind. So yes, it is my fault at this point that I have not been uploading these products sooner. BUT now that I attempted this, and it worked twice already, all of a sudden it stopped working, so maybe I did corrupt the database. However, the store is still functioning so I wouldn't think this is the case.

So if anyone can PLEASE point me in the right direction, it would be greatly appreciated. I have even attached a screenshot of my system/PEAR directory as well as the Pear & Pear5 php files. Thanks in advance.

The jerk bit was a lame attempt at humor. There's no need to take offense.

I'll be straight with you. This is a volunteer forum and it has a real workman philosophy. You get out what you put into it and you didn't even put enough into it to read the big 'BEFORE YOU POST' sticky.

Your problem is with JNeuhoff's import/export extension (which he's been incredibly gracious to spend countless hours developing and porting between Opencart versions for the community), not Opencart proper. Threatening to stop using the entire cart over it is silly.

Taking a guess here, it looks like there was an error running the extension. It can't find the proper PEAR5 class (PEAR5::getStaticProperty) to output the error which in turn causes the error you're getting. It didn't happen before now because it didn't get an error before now.

So that probably means there's an error in the spreadsheet or the way you're using the extension underneath the existing PEAR5 issue. I'd start by making sure JN's extension can actually do incremental product uploads (I don't remember it being able to but that was a number of years and different versions ago).

Certainly if you've paid someone to set this all up make them support it. Any legit business person will.

Thanks for the information. I am not blaming anyone or threatening and figured the error message was enough to go off of based on what I was doing. I wish I could continue to use OpenCart, but I am told that it is not a good solution for a store my size. Someone said that it is designed for stores that are not so dynamic. I have 3000+ products that are constantly changing. Whether that is the case or not, I don't know and I have nothing to compare to. I am not familiar with other cart solutions besides Yahoo Store.

I understand that there is not away to append products which is why my developer advised me against trying to bulk upload until he found a way to append to the current inventory. However, with the amount of changes, I couldn't wait any longer so I attempted it. The import/export seemed to work. But now that you are saying about an error in the spreadsheet, maybe one of the new products I entered generated an error. It allowed me to do the import, and the products look ok on my store for the most part, I had to manually make some changes. Since I now can't do an export, that is probably what happened. The error is probably just enough that it allowed the import but is choking on the export. *sigh*

The developer that did my site is a freelance developer and he is quite busy which is why I decided to move forward with using the current import/export function. I guess at this stage since it is now FUBAR for me, I need to look into getting a new developer to either fix this and write a program to do incremental bulk uploads, or to do a whole new design.

seduction wrote:Someone said that it is designed for stores that are not so dynamic. I have 3000+ products that are constantly changing.

Opencart's not designed to bulk edit products right out of the box but it can certainly handle 3000 products in the store. I got one running with nearly twice that many products with only minor tweaking.

There are also commercial extensions like Q's jqListEdit which let you quickly change basic product information from the admin product list.

I understand that there is not away to append products which is why my developer advised me against trying to bulk upload until he found a way to append to the current inventory.

You were told it wouldn't work but did it anyway?

Honestly your best bet here (probably your only bet) is to clear out the database then upload again with all your products (of course do a test with a limited number first then re-clear the database).

OK. Thanks. I will check out the jqListEdit.

Well, he said the import/export tool works, but it risky with the amount of products I have. He said if I attempt it, to make sure I have a good back up.

How do I clear out the database? I have the original backup of the spreadsheet. I guess I can import that to overwrite all the other products I added. Then if I can export at that point, I can try adding a few of those products at a time to determine which line item is causing the error. Or maybe I will see it when I evaluate the rows.

Thanks for all your help!

Wooohooo!!! I resolved the problem thanks to you and now able to export the spreadsheet! When you mentioned there could be an error in the spreadsheet, I went into the newly uploaded products and saw that something happened to the date available. There were invalid dates in most the new products that I uploaded. It must have happened during the exporting of the tables between Access & Excel. Plus when I manipulate the Excel spreadsheet, I pull it in on my Mac. I think I will stick with doing it on my PC instead so there will be less chance of error. I am glad I don't have to overwrite the 50+ new products. I am also glad to know that there are other stores with more products than mine. It makes me more comfortable doing the import/export to upload the entire product base.

Thanks again for your help!