Easy Populate: 3 partially deleted product(s) found

Hi,

I uploaded the files for the free version of the Easy Populate. I went to Admin -> Tools -> Easy Populate and typed in https://www.dealbyethan.com?langer=remove after /easypopulate.php to install Easy Populate. I received the following message.
Easy Populate Configuration Missing. Please install your configuration by clicking here.
Warning Easy Populate uploads folder not found!
NIX SERVERS: Your uploads folder is either missing, or you have altered the name and/or directory of your uploads folder without configuring this in Easy Populate.
WINDOWS SERVERS: Please request your web host to assign write permissions to the uploads folder. This is usually granted through Windows server user account IUSR_COMPUTERNAME.
Your configuration indicates that your uploads folder is named EASYPOPULATE_CONFIG_TEMP_DIR/, and is located in /home/dealbyet/public_html/, however this cannot be found.
Easy Populate cannot upload files until you have provided an uploads folder with read/write/execute permissions for the site owner (usually chmod 700 but you may require chmod 777)

So I went to change the file permission of the temp folder and clicked on the link for installation. Then it said installation successful and that...
3 partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here.
You are seeing this because there are references in tables to a product that no longer exists, which is usually caused by an incomplete product deletion. This can cause Zen Cart to misbehave in certain circumstances.

Is it save to delete them?

Hi

I went ahead to delete them. I received the following message:

Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

What should I do now?

Hi dealbyethan,

Having exactly the same problem - can someone help us out here pls!

With my current Easy Populate 1.2.5.4 sometimes when I try to upload a file I get "ERROR: The requested URL could not be retrieved" (see screenshot) (the data still seems to be uploaded fine though)

I then get a yellow error message up the top:

*1 partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here.
You are seeing this because there are references in tables to a product that no longer exists, which is usually caused by an incomplete product deletion. This can cause Zen Cart to misbehave in certain circumstances. *

When I click the next page still has the yellow error message:

Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

Do you have any idea how to fix this?

I am running Zen v1.2.6D about to upgrade to v1.3.7? Would upgrading Zen Cart or even upgrading to Easy Populate Advanced solve the problem?

Here are the error messages:
http://www.apeshop.com/error_requested_url_could_not_be_received.jpg
http://www.apeshop.com/error_partially_deleted_product_found.jpg
http://www.apeshop.com/error_deleting_of_product_debris_failed.jpg

Hi apemusic,

I am using zencart v.1.3.7 and EP1.2.5.4. I don't think upgrading your zencart would solve this problem. I know with the advance easy populate, you get to do more things in bulk.

Regards,
Ethan

If you search threw the EP main thread you should see this is a bug, there is a fix for this.EP main thread

Found it for you .....

sorry for not being available the last few weeks. A little 4.5kg boy is keeping me busy

I'll address any unanswered questions in turn. regarding the dross not being dleted, this is a bug. Ignore the error message for now. You can, if you wish, remove the offending table names the function checks in /admin/includes/functions/extra_functions/easypopulate.php:

Code:

TABLE_CUSTOMERS_BASKET,
TABLE_CUSTOMERS_BASKET_ATTRIBUTES

I am working very hard to release the 1st advanced version in the next 2 weeks, and will at that time apply the bugfixes to the free version for all to enjoy.

---

Nicholas

Well... I too am having this problem. Same exact situation. When I delete, it tells me to

"Deleting of product data debris failed! Please see the debug log in your uploads directory for further information."

What am I supposed to do? Ignore it? Delete the "code" All I know is that the warning says this problem will cause Zen to have other problems.

I sold an item and deleted it from the product line up. Later when I shipped it, I clicked the product shipped...and the error came. When I ship and sell, the inventory is not updated so I delete it when sold to avoid confusion. Is this what is causing it? Have I messed up my Zen Cart or is it fixable?

Thanks

Same problem. I keep getting a yellow warning bar at the top of the screen saying I have a partially deleted product click here to delete the dross...but after clicking more than once...the warning keeps coming back.

Just spent ages trying to sort this out myself and managed to clear the message. :clap: A customer had purchased items, the items were subsequently deleted using easy populate. But the message is appearing as the basket refers to non-existent items.

If you delete the lines of code as scrat says that will work.

Alternatively, I was able to delete all items from the tables
TABLE_CUSTOMERS_BASKET,
TABLE_CUSTOMERS_BASKET_ATTRIBUTES
using phpadmin in the cpanel (my store is not live yet). Obviously only use this method if you're sure you can identify the items. If you can't then use scrat's method, it will just mean these tables will not be checked for orphan data.

Hope this clarifies things a bit.

I get this error in Easy populate when you edit the product from Category/products: you get a warning message at the top that reads:

Warning: reset() [function.reset]: Passed variable is not an array or object in D:\Inetpub\bargaincitygifts\admin\includes\classes\object_info.php on line 29

Warning: Variable passed to each() is not an array or object in D:\Inetpub\bargaincitygifts\admin\includes\classes\object_info.php on line 30

when you scroll down to look at the product info the product information if completely blank. however if you dine this same product on the web site all information is posted.

I get the same error

bargaincitygifts & khopek what versions are you using? as it may depend on the version you are using to whether this fix works, this is known to work on V1.2.5.4 (Downloaded from Modhole not ZC download center.

Scrat:

bargaincitygifts & khopek what versions are you using? as it may depend on the version you are using to whether this fix works, this is known to work on V1.2.5.4 (Downloaded from Modhole not ZC download center.

I am using 1.2.5.6.csv.2 and Zen Cart 1.3.8.

khopek > I am using 1.2.5.6.csv.2

That is most likely your problem, as all these new versions of EP seem to be** VERY buggy**, my advice is down grade to Version 1.2.5.4 from Modhole which is proven with very little problems and it should work fine, I use this every day with out any problems.

ZC: 1.3.8a

Can anyone give me a proper description of the Easy Populate module's capabilities? Is there a page that describes, in detail, exactly what this module has to offer (real world examples). Nearly all the time, the descriptions for the modules are very vague and do not properly describe their capabilities (one just has to stumble upon a description through forum posts or hear about it elsewhere.

Before i install it, i would like to know exactly what it can do and if it meets my needs.

Thank you

For about a year now, a number of people have had a go at updating/upgrading Easy Populate (EP). One attempt by phaezi looked at enabling CSV formatted files to be used, instead of the traditional TXT (Tabbed Delimited) file that EP uses.

This CSV version seems to have limitations however, and is further restricted by the user's system requiring PHP version 5.2 .

I imagine that further improvements of phaezi's CSV module will also require PHP 5.2 .

I tried out version 1.2.5.6 a few months ago, and (despite my experience with EP), started getting a range of errors that I could not deal with, so my advice since then is not to use EP versions later than 1.2.5.4 .

I have EP 1.2.5.4 installed on about 100 zencart-driven sites - all of which are zencart 1.3.8a that are themselves fully patched and up-to-date.

Occasionally, I have a few issues with uploads, but these are almost always because of the use of "special characters" within the content of the TXT file, and other bad formatting (line breaks in the product description text).

Otherwise, we use EP 1.2.5.4 about 5 times a day on our clients' sites and have no problems using it.

My WIKI on 1.2.5.4 may be helpful to newbies:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

Scrat:

Version 1.2.5.4 from Modhole ...

Last I heard was that it (modhole) isn't there anymore.

Get 1.2.5.4 here:-
http://www.zen-cart.com/archived_contributions/admin-tools/

click the link that says: ep_v1.2.5.4.zip

DO NOT use any other version that is shown on that page...

I'd like a zen-cart team member to solve this problem. It's a real problem with the software and taking chances changing code isn't good...especially since I make a living using the Zen Cart!!

I just used phpMyAdmin, and looked for the following tables

TABLE_CUSTOMERS_BASKET,
TABLE_CUSTOMERS_BASKET_ATTRIBUTES

Then I browsed the tables and looked for the 'product debri' that was offending EP. You can look in the EP logs to see the products that failed to delete. For me it's always random numbers and letters like ae3490790s7d. Then just delete them from the tables above.

Sir Paolo:

I'd like a zen-cart team member to solve this problem. It's a real problem with the software and taking chances changing code isn't good...especially since I make a living using the Zen Cart!!

As you're now a zencart team member, why don't you have a go at resolving it?

Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

I know I will eventually figure out where to look for the uploads directory and the debug log. My debug tool wasn't reinstalled and turned on at the time of my upload, so I am at a loss at the moment. I checked my PHPMyAdmin and find no stray data in the customers_basket and customers_basket_attributes tables.

Where is the uploads directory and how does one access it? Is there a debug log if the debug tool is not installed?

Part of the problem is, if you click "here" on the message that you have stray data, you receive the above message, but the "log" that builds on uploading data to the Zencart, which is invisible because it is at the bottom of the screen, has already disappeared when you receive the above message, because you have obeyed the command to click "here" to get rid of the stray data.

Thanks for any response. I fear it will take me the rest of the day to find this answer, but if I do, I will post. I have tried to research it twice so far, amongst other things.