Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Downloads Controller Problems


denyse

Recommended Posts

Posted

I have a few problems after I installed the Downloads Controller.

 

One.... during checkout I get this error... it does not seem to know what to do with the comments section. Error occurs when you try to confirm the order.

 

You can recreate the problem at www.shopdaystar.com/catalog/ I set up one download to test with in the Wallpaper section ... called Candy Buttons.

---------

1054 - Unknown column 'comments' in 'field list'

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, last_modified, orders_status, comments, currency, currency_value) values ('2', 'Denyse Rackel', 'Dezines by Denyse', '2314 Westmoor Road', '', 'Rocky River', '44116-2519', 'Ohio', 'United States', '440-895-0097', '[email protected]', '2', 'Denyse Rackel', 'Dezines by Denyse', '2314 Westmoor Road', '', 'Rocky River', '44116-2519', 'Ohio', 'United States', '2', 'Denyse Rackel', 'Dezines by Denyse', '2314 Westmoor Road', '', 'Rocky River', '44116-2519', 'Ohio', 'United States', '2', 'The WebMakers Corner FREE CHARGE CARD', '', '', '', '', now(), now(), '3', 'doofus', 'USD', '1.00000000')

 

[TEP STOP]

 

---------------------------

 

However the order did go through because I received an email called Order Update and in it the comments section is blank. States the order was shipped. If I click on the link to view the order, at the bottom of the invoice it says in Red....

 

NOTE: Downloads are not available until payment has been confirmed.

 

---------------------

I never received a link or anything to actually download the zip file. How does the system know where the zip file is at? What it is called, etc?

---------------------

Now orders that should be charged shipping costs are getting the Free Shipping. How do I fix that?

----------------------

 

 

Can anyone help me out with this?

 

Thanks,

 

Denyse

Posted

Hi there...

 

I also get that above error message now on a product with cost... So it is now giving shipping away for free on products it should charge and it generates that same error message above on a product with a price...the error with the comments column.

 

Any help here? I really want to use this downloads controller.

 

Thanks,

 

Denyse

  • 1 month later...
Posted

I just installed this module. Other making sure any custom mods I made stayed intact it seems to work.

I don't use shipping costs.

 

Before installing this and after installing this module I still cannot get it to link to the download. The downloads exists. Just cannot execute the download.

 

Any ideas about this? I have the files in the download directory. I checked the table products_download and they have the correct images defined. I have tested changing the default delivery status.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...