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, 1054 unknown column osdownloads_flag clause, oscommerce error messages, error_message oscommerce, message error, OPD, op, message, error, unknown database, sql select order, 1054 unknown column select, 1054 php, 1054 unknown, 1054, 1054 unknown column language_id clause, oscommerce table, unknown column php, table error, database table structure, error cart, error oscommerce php, database structure oscommerce

Tietoa työnantajasta:
( 2 arvostelua ) Glasgow, United Kingdom

Projektin tunnus: #440053