Easy Populate Problem

**webmiss** · 29 Jan 2010, 12:25 AM

I have successfully added some products using the easy populate. Needed to add some more. I am now getting this error after importing the file for products.

An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer.

Can someone give me a clue as to what this is all about? This wasn't happening before when I uploaded some products using easy populate.

I really need some help here, pretty please.

**schoolboy** · 29 Jan 2010, 01:13 AM

In your spreadsheet you probably have an empty column without a column header...

**webmiss** · 29 Jan 2010, 10:55 PM

Originally Posted by schoolboy

In your spreadsheet you probably have an empty column without a column header...

I looked at the columns and each one has a column header. I used the extended store template to add the products to. Maybe I should use the other template. What do you think?

Thanks.

**schoolboy** · 29 Jan 2010, 11:01 PM

Originally Posted by webmiss

This wasn't happening before when I uploaded some products using easy populate.

... So there is clearly a "before" and an "after"...

What changes / add-ons / edits / code hacks / etc did you apply to your site just prior to the "after" situation was experienced?

In other words...
it was working - - - you did something - - - it stopped working...

... what EXACTLY was the "something" done to the site.

**webmiss** · 30 Jan 2010, 02:55 AM

I went from using the simple store template to the extended store template, changed the product status to 1 rather than 0 for each product, had to change out some of the categories and sub categories of some of the products to correct them (the vendor had them assigned to the wrong categories or categories that don't exist). The categories are in the correct format such as Parent Category~Sub Category~Sub Sub Category, I added some additional information for product description, that sort of thing. Nothing I can think of that would mess up the columns or column headers. I did delete the product ID column because I am using the Products Model instead. (When I tried to import with the Product ID column still there, I got an error)

Is there something in what I did above that could have messed things up?