Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL syntax error


kelly34

Recommended Posts

Posted

Could someone please tell me what this error means.

 

1064 - You have an error in your SQL syntax near 's')' at line 1

 

insert into user_tracking (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('', 'Guest', '1806b5567e9cbd3cf78a47a968c02d3a', '203.20.58.1', '1105158152', '1105158152', '/shop/index.php?cPath=13_22_23', '2005 Bikini's')

 

[TEP STOP]

Posted
Could someone please tell me what this error means.

 

1064 - You have an error in your SQL syntax near 's')' at line 1

 

insert into user_tracking (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('', 'Guest', '1806b5567e9cbd3cf78a47a968c02d3a', '203.20.58.1', '1105158152', '1105158152', '/shop/index.php?cPath=13_22_23', '2005 Bikini's')

 

[TEP STOP]

 

[B]'2005 Bikini's'[/B]

 

2005 Bikini's - I guess this is a discription?

 

every apostrophe should be preceded by a slash. So it should be:

 

2005 Bikini\'s

 

not

 

2005 Bikini's

 

 

HTH,

 

goodluck

Archived

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

×
×
  • Create New...