View Single Post
  #29  
Old 01-11-2006, 11:17 AM
  Jon's Avatar 
Jon Jon is offline
 

X-Guru
  
Join Date: Oct 2002
Location: Vancouver, Canada
Posts: 4,200
 

Default Re: Mulitple ship to addresses

Quote:
Originally Posted by robin
I also get this error

INVALID SQL: 1064 : You have an error in your SQL syntax near 's Goldberg Variations";s:12:"product_type";s:0:"";s:5:"price" ;d:13.99;s:5:"taxes' at line 1
SQL QUERY FAILURE: update xcart_sessions_data set data = 'a:44:

This occurs because the sessions are completely regenerated, which means re-establishing your cart contents.

If one of your cart contents has an apostrophe or quote in it, then it will cause the SQL to break.

To fix this find:

Code:
$new[$key] = $value;

Replace with:

Code:
$new[$key] = addslashes($value);
Reply With Quote