SQL Error when selecting "View Orders"

[pensive612]

Hi everyone,

I'm getting this SQL error when I click on the "View Orders" Button in the My Account page:

1054 Unknown column 'osh.comment_by' in 'field list'
in:
[SELECT os.orders_status_name, osh.date_added, osh.comments, osh.comment_by FROM zen_orders_status os, zen_orders_status_history osh WHERE osh.orders_id = 15 AND osh.orders_status_id = os.orders_status_id AND os.language_id = 1 ORDER BY osh.date_added]

Does anyone know where I need to start looking?

Thank you very much.

Adam.

[clydejones]

Hi everyone,

I'm getting this SQL error when I click on the "View Orders" Button in the My Account page:



Does anyone know where I need to start looking?

Thank you very much.

Adam.

Its looking for a field called "comment_by" in the "orders_status_history" table.

and can't find it because that particular field is not in the table.

What add ons have you added recently?

[pensive612]

Oh, thank you for the translation Clyde..!

After that, I traced it back to the Order Questions Mod.

I must not have installed the SQL update after rebuild.

Works perfect now!


Thank you again...

[clydejones]

Oh, thank you for the translation Clyde..!

After that, I traced it back to the Order Questions Mod.

I must not have installed the SQL update after rebuild.

Works perfect now!


Thank you again...

Glad to help