--------------32F14B9674A46ACA12132458 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit it happens to me too.... But I wasn't able to delete the price from the products table (using MySQL) due to the fact that the price column cannot be empty and if I set it to 0.... pricing still doesn't take effect. sql error when price is empty (shows on the html). --------------snip--------------- 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 'where sku = 'br10001' ' at line 1 ) --------------snip--------------- --------------snip--------------- mysql> select sku, description, price from products where sku='br10001'; +---------+------------------------+-------+ | sku | description | price | +---------+------------------------+-------+ | br10001 | Opera v4.0b2 for Linux | 0.00 | +---------+------------------------+-------+ 1 row in set (0.00 sec) --------------snip--------------- Chris Wenham wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > I have one product in a catalog with quantity pricing, however the > pricing does not take affect when the item is ordered. > > The strange thing is that when I -delete- the price from the products > table (leaving only the data in the pricing table), the shopping cart > display reflects the quantity price for all quantities greater than > 1. But for a quantity of 1, the price is naturally zero. > > How do I fix this? > > Regards, > > Chris Wenham > NetMonger Communications > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.4 (FreeBSD) > Comment: Processed by Mailcrypt 3.5.5 and Gnu Privacy Guard <http://www.gnupg.org/> > > iEYEARECAAYFAjoixk0ACgkQw4VAKENtJO+5SACfbeNYlfWxCvqDR2o7uBl9FCdz > cigAn1YBCvbCHfbUCmFoR1Dx/RkgNyDI > =2ybO > -----END PGP SIGNATURE----- > > _______________________________________________ > Interchange-users mailing list > Interchange-users@www.minivend.com > http://www.minivend.com/mailman/listinfo/interchange-users -- Marcel Montes [marcel(at)multimake(dot)com] - Programmer "If our brain were so simple that we could understand it, we would be so stupid that we couldn't do so" -------------------------- EOF ---------------------------- --------------32F14B9674A46ACA12132458 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> it happens to me too....
But I wasn't able to delete the price from the products table (using MySQL)
due to the fact that the price column cannot be empty and if I set it to 0....
pricing still doesn't take effect.sql error when price is empty (shows on the html).
--------------snip---------------
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 'where sku
= 'br10001' ' at line 1 )
--------------snip---------------
--------------snip---------------
mysql> select sku, description, price from products where sku='br10001';
+---------+------------------------+-------+
| sku | description | price |
+---------+------------------------+-------+
| br10001 | Opera v4.0b2 for Linux | 0.00 |
+---------+------------------------+-------+
1 row in set (0.00 sec)
--------------snip---------------Chris Wenham wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1I have one product in a catalog with quantity pricing, however the
pricing does not take affect when the item is ordered.The strange thing is that when I -delete- the price from the products
table (leaving only the data in the pricing table), the shopping cart
display reflects the quantity price for all quantities greater than
1. But for a quantity of 1, the price is naturally zero.How do I fix this?
Regards,
Chris Wenham
NetMonger Communications-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (FreeBSD)
Comment: Processed by Mailcrypt 3.5.5 and Gnu Privacy Guard <http://www.gnupg.org/>iEYEARECAAYFAjoixk0ACgkQw4VAKENtJO+5SACfbeNYlfWxCvqDR2o7uBl9FCdz
cigAn1YBCvbCHfbUCmFoR1Dx/RkgNyDI
=2ybO
-----END PGP SIGNATURE-----_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users-- Marcel Montes [marcel(at)multimake(dot)com] - Programmer "If our brain were so simple that we could understand it, we would be so stupid that we couldn't do so" -------------------------- EOF ----------------------------