Forum OpenACS Q&A: Response to ecommerce module throws error when trying to view orders

The count(*)'s in the two halves of the UNION don't appear in the same column slot.  Try shuffling one or the other to the right position and let us know what happens.  If that works, please submit the patch and bug report to the SDM!