Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


Guest

Recommended Posts

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.

Link to comment
Share on other sites

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!

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...