Please help! 1054 - Unknown column

[yvettekukoja]

Hi,

I would like to delete products from catalog, but when i press delete button i get this error message

 

1054 - Unknown column 'products_id' in 'where clause'

 

select popup_images from additional_images where products_id = '51'

 

I suppose i have to add or change something in database but dont know what :(

please,please help.

 

Regards,

Yvette

[Guest]

I'm using OSC v2.2 rc2a & getting this exact same error when I've completed a PayPal payment & am redirected back to my store

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 = '2' and o.orders_id = '118' 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'

[TEP STOP]

 

Otherwise the page looks correct. Below this message, I have the regular "Your order has been processed!" message.

 

I can imagine this doesn't inspire confidence in my customers.

 

And I don't know if this is related, but the PayPal Standard payment module isn't transferring the purchased items to PayPal - just the total price - the item shows up as my store name. I can look at the order in the admin panel & see which items were ordered, but my PayPal account only shows the total purchase as a lump sum.

 

Any help would be greatly appreciated!

[yvettekukoja]

My problem sorted :))

 

i had to add products_id field in database table additional_images.

 

Now everything works fine

[Guest]

Oops - mine is similar, not the same. But this thread helped to point me in the right direction!

[satish]

This should be a Mysql 5 related error.

 

 

So modify sql query looking into mysql 5 patches.

 

Satish

[callenords]

I have the same problem

 

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 = '1060' and o.orders_id = '767' 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 = '5'

 

Don't know what to do...

[callenords]

My problem was that I had to reinstall the "Super Download Shop" conrtibution.

[Guest]

If you are NOT offering downloadable products a simple fix is to comment out the inclusion of the downloads.php file.

 

On a stock install, around line 148, change

 

<? php if (DOWNLOAD_ENABLED == 'true') include(DIR_WS_MODULES . 'downloads.php'); ?>

 

to

 

<?

//php if (DOWNLOAD_ENABLED == 'true') include(DIR_WS_MODULES . 'downloads.php');

?>

 

Checkout success page should look beautiful.

[cindy0001]

Oops - mine is similar, not the same. But this thread helped to point me in the right direction!

 

oh hi there, i got the same problem as you. i was wondering how you solve this problem. any help very much appreciated by me thanks