After fail to upgrade the database from 2.3.7 to 2.4
I click continue, and when go to main page, select any item,
it gives internal server error (500)
when I profile it, it stop at this query:
2 Query SELECT oc_t_item.pk_i_id
FROM (oc_t_item)
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2012-05-04 20:58:42')
AND oc_t_item.fk_i_category_id IN (1, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)
ORDER BY dt_pub_date desc
LIMIT 1000
Actually the upgrade db process doesnt add column dt_expiration to table oc_t_item
