Peruttu

OSCOMMERCE ERROR MESSAGE

hi i am getting this error message after CHECKING OUT on OSCOMMERCE

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 = '138' and o.orders_id = '528' 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'

i recently imported a database from an old cart table structure slightly different

THE ORDER IS GOING THRU OK and EMAIL NOTIFICATION WORKS

IF U CAN FIX THIS THAT WOULD BE AWESOME

Taidot: PHP, SQL

Näytä lisää: this error, message on, oscommerce error message, oscommerce error messages, message error, opd, op, message, error, unknown database, sql select order, 1054 unknown column select, 1054 php, 1054 unknown, 1054, oscommerce table, unknown column php, table error, database Table Structure, error cart, error oscommerce php, database structure oscommerce, email checking, unknown order oscommerce, sql php oscommerce

About the Employer:
( 2 reviews ) Glasgow, United Kingdom

Projektin tunnus: #440053