[ SOLVED ] Add to cart button not working with debug error!

[jamesharps]

Hey, I need some help as it seems the add to cart button has broken.  I tried it on my Mac and Windows laptop so it would definitely be an error for the public as well.

This is the debug error above the item in the product description page.:

vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `jos_virtuemart_products` as `p` JOIN `jos_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `jos_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)   LEFT JOIN `jos_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)   WHERE `virtuemart_category_id` = 2 and `slug` < "10kps3" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price DESC LIMIT 0,1

vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `jos_virtuemart_products` as `p` JOIN `jos_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `jos_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)   LEFT JOIN `jos_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)   WHERE `virtuemart_category_id` = 2 and `slug` > "10kps3" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price ASC LIMIT 0,1


You can test it out here: http://www.buyultimatecoins.com/ps3/10kps3-detail

I am kind of at a loss here and can't quite figure it out.  I noticed there used to be VM file in the cache under maintenance, but it does not appear to be there anymore.  Don't know if that has anything to do with it.

Thanks for any help!

Cheers

EDIT: It would appear the plugin I installed aiRedirectwww is interfering with Virtuemart.  Any ideas how I can still have the www redirect and not have any issues with Virtuemart

EDIT 2:  I fixed the error by searching, but as I assumed it was totally unrelated to the issue I am having with the add to cart button.  I also just discovered the add to cart button only works when the www is not in the URL.  Any ideas?

Doesn't work with the WWW: http://www.buyultimatecoins.com/xbox360

Works without the WWW? http://buyultimatecoins.com/xbox360

As it stands I am completely lost.

[jamesharps]

After a couple stressful hours of searching for an explanation.  I noticed the configuration.php file didn't have www. at the beginning of "$live_site".  A simple but aggravating hidden fix.  Hopefully someone finds this if they run into the same issues.