Help! LOL I have a 1064 syntax error and am not sure

[Guest]

I have a weird error that I can't solve. I am not sure what file to edit or if it's the database that needs editing or what. Here is the error:

 

| 530112JET | 5301JET_sm | 5301-12-JE | | | | 5301 12mm | 5301 12mm | Swarovski | | | | | | | | | | | | | | | 6.2 | 6.2 | 6.05 | 5.9 | 0 | 1 | 3 | 5 | 0 | 1 | 10 | | 0000-00-00 | 36 | Swarovski | Swarovski | 5301 Bicon | 5301 - 12m | | | | | --none-- | Inactive Updated

| 500004ALEX | 5000ALEX_s | 5000-04-AL | | | | 5000 4mm S | | | | | | | | | | | | | | | | | | | | | 0 | 1 | 3 | 5 | 0 | 1 | 1 | | | 144 | Swarovski | Swarovski | 5000 Facet | 4mm | | | | | | Updated

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'products_url, products_head_title_tag, products_head_desc_ta' at line 7

 

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_short_desc products_url, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag) VALUES ( '1469', 1, '5000-04-ALEX', '', '', '', '5000 4mm Swarovski Crystal Round Beads in Alexandrite', '', '')

 

[TEP STOP]

 

By the way, this happens when I use easypopulate to upload my spreadsheets. The first part goes through just fine, but then when it gets to the ones I am now trying to add, I get the error. I am using a downloaded complete spreadsheet from my site so I haven't added any new fields or anything. I'm not understanding why the first part is going through but the second isn't. I have gone through the spreadsheet and everything seems to be in place there. I have even deleted the three columns (head title tag, desc tag and keywords tag) from the spreadsheet and it still doesn't work.

 

Can anyone guide me?

 

Thanks.

[♥Monika in Germany]

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_short_desc products_url, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag) VALUES ( '1469', 1, '5000-04-ALEX', '', '', '', '5000 4mm Swarovski Crystal Round Beads in Alexandrite', '', '')

 

I would use this and run in phpmyadmin. the error message may be clearer there ... let us know!

[Guest]

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_short_desc products_url, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag) VALUES ( '1469', 1, '5000-04-ALEX', '', '', '', '5000 4mm Swarovski Crystal Round Beads in Alexandrite', '', '')

 

I would use this and run in phpmyadmin. the error message may be clearer there ... let us know!

 

 

For some reason, this isn't working....it isn't pulling anything up. Guess I am back to the drawing board.

 

Thanks though.

 

Anyone else?

[dittones]

Dear Klynns,

Possibly the minus sign is causing the problem...could be executing

this as code put a \ in front of the minus sign of course the change would

be made in the datadase...

Hope this helps

Roman

[♥Monika in Germany]

For some reason, this isn't working....it isn't pulling anything up. Guess I am back to the drawing board.

 

Thanks though.

 

Anyone else?

does this mean you didn't get an error and the row went into the database?