coupons in order table view in Ubercart drupal 7-Collection of common programming errors

Am using drupal 7 and am in need of create a view for the custom reports. The views must contains the first name, last name, address, email, phone number, order date, order id, price paid, shipping paid, taxes paid, coupons, product ordered, referred by, recurring order and order total.

So am creating a view by choosing the order from the content in creating views. While adding coupon based field it shows the error:

“SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘uc_coupons.order_id’ in ‘on clause’ “

How to rectify the errors and also how to add the referred by field in this view? Please suggest some ideas.

Originally posted 2013-11-09 22:56:42.