Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mikebt

Pioneers
  • Posts

    11
  • Joined

  • Last visited

Profile Information

  • Real Name
    mikeb

mikebt's Achievements

  1. Im getting an error at account history, order information. 1054 - Unknown column 'os.downloads_flag' in 'where clause' select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays from orders o, orders_products op, orders_products_download opd, orders_status os where o.customers_id = '20' and o.orders_id = '8' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != '' and o.orders_status = os.orders_status_id and os.downloads_flag = '1' and os.language_id = '1' Something about downloads? I do have a downloadable store. Anyone have an idea what this means?
  2. The account history seems to be working ok, its the ccbill error that I am worried about now. Any ideas on why when a customer completes an order, the download link that a customers get redirects to a page that doesnt work. It seems the approval urls from ccbill isnt the right urls. Could this be on my end. Any ideas?
  3. Thanks for responding, but where is this file in order to edit this?
  4. When I click to view the account history to go to customer account information, I see some error. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1 select count(*) as total from orders o, orders_status s where o.customers_id = '11' and o.orders_status = s.orders_status_id and s.language_id = '1' ' I have read there were errors about this type before but haven't found the right solution. Can someone please tell me what does this mean and is there a easy solution to this error?
  5. I have used the ccbill module and all seems to be working fine until ccbill helped me add the approval urls. When I start to test my store products and the credit card is approved, it redirects me to YAHOO, or it gives me a approval link url that doesn't work. What could be the cause of this? Could it be the wrong approval url or could it be some clinch in my store? Someone please help, any answers?
×
×
  • Create New...