duplicating products in same folder?

**blackhawk** · 12-10-2009, 07:09 AM

Is there a way to duplicate a product within the same product folder on the fly. I get an sql error for trying to do it initially.

**ridexbuilder** · 12-10-2009, 07:44 AM

Coincidently, I spotted that today - seems there's a rogue 0 being entered in the SQL statement in admin/categories.php around line 437 (near the end of the line). Was going to fix but have been doing loads of other stuff to the same file (which didn't work), so need a break, for now. Later.

Try removing

Code:

'0',

Post the error statement for a better guess

**blackhawk** · 12-10-2009, 05:18 PM

oddly enough i have it partially fixed, I had a quote missing on one of my sql value fields. The issue still arises when I try to duplicate what I just duplicated. Give it a shot. Just doesnt work for me. I have a feeling it has to do with the date the product was added , or modified. it sets it to "00000:000:0000" - but i don't know if thats the core reason - still investigating but not that big of a deal at the moment.

**JohnW** · 12-29-2009, 07:08 PM

Are you getting the error on the products table or products description? The date added should be now and the other dates should come up null. Make sure your fields match your values in count and order. If one is missing or out of order it's a problem.

I started to fix this a long time ago and forgot about it until I read this thread. I basically had it working on my live site but a couple values were crossed. The '0' at the end of the statement is correct as it is the products viewed number. I think you're missing a value but post your error and if you want that section of your file.

This is actually the first time I've had the duplicate work correctly since 2002, but now I don't really need it