[ic] Merchandising Help

[Jake Thompson]

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