SteitSlings, Thank You - That is perfect!
Nicusor (azzido), I will check this thread several times a day until you say your problem is solved.
If you would prefer a vQmod for this, just let me know.
I'm pretty sure the error message you're seeing has truncated SQL. One way to know is to edit your catalog/model/catalog/product.php file as follows: Before the third occurrence of
Code: Select all
$query = $this->db->query($sql);
Code: Select all
// Save $sql to a file for debugging
$myFile = "mysql_debug.txt";
$fh = fopen($myFile, 'w') or die("can't open file");
fwrite($fh, $sql);
fclose($fh);
Another way would be to compare your catalog/model/catalog/product.php to the one I use. Here is the 1.5.5.1 catalog/model/catalog/product.php I use: Please let me know if this helps.
Regards,
midgette