Continuing the debugging process,here is they MySQL transactions that occour
when this error happens( I've placed a **** in front of the line that is the
apparent error):
010103 23:53:40 14 Connect interch@localhost on homespun_sampler
14 Query select sku from merchandising where sku =
'hssr0011'
14 Query update merchandising SET blurb_end = NULL
where sku = 'hssr0011'
14 Query select sku from merchandising where sku =
'hssr0011'
14 Query update merchandising SET finish_date =
'20010103' where sku = 'hssr0011'
14 Query select sku from merchandising where sku =
'hssr0011'
14 Query update merchandising SET blurb_begin =
NULL where sku = 'hssr0011'
14 Query select sku from merchandising where sku =
'hssr0011'
14 Query update merchandising SET timed_promotion
= NULL where sku = 'hssr0011'
14 Query select sku from merchandising where sku =
'hssr0011'
14 Query update merchandising SET start_date =
'20010103' where sku = 'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
****14 Query update products SET = NULL where sku =
'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select description from products where
sku = 'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select category from products where sku =
'hssr0011'
14 Query select DISTINCT category, category FROM
products ORDER BY category
14 Query select sku from products where sku =
'hssr0011'
14 Query select price from products where sku =
'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select image from products where sku =
'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select display from products where sku =
'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select comment from products where sku =
'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select size from products where sku =
'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select color from products where sku =
'hssr0011'
14 Query select sku from products where sku =
'hssr0011'
14 Query select weight from products where sku =
'hssr0011'
14 Quit
-----Original Message-----
From: Jake Thompson [mailto:JThompson@ztechnet.com]
Sent: Wednesday, January 03, 2001 10:40 PM
To: 'interchange-users@lists.akopia.com'
Subject: RE: [ic] Merchandising Help
This appears to be the same Inventory issue seen throughout too!
Unfortunately, I have seen no true fix to the problem.
Thanks,
Jake
-----Original Message-----
From: Jake Thompson [mailto:JThompson@ztechnet.com]
Sent: Wednesday, January 03, 2001 10:18 PM
To: interchange-users@lists.akopia.com
Subject: [ic] Merchandising Help
Hi all,
I hope this has not been passed around in the past, I could not find the
same error anywhere.
Basics: RedHat 7.0 Interchange 2.6.1, and MySQL 3.23.24
When I add merchandising to an item, I get pushed back to the item details
page with the following message displayed on the top of the page.
Sorry, there was an error in processing this form action. Please report the
error or try again later. (You have an error in your SQL syntax near '= NULL
where sku = 'hssr0011' ' at line 1 )
It adds into the merchandising table, but the featured column is '', not
NULL sku is correct , everything else is NULL , except cross_category is ''
also.
Any thoughts on why this is happening?
Thanks,
Jake Thompson
jthompson@ztechnet.com
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users _______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users