I use a creloaded shop, with a lot of custom modifications. After moving the shop to a new server and upgrading to mysql 5.x, i have som bugs i need help removing:
one the index page i get this error-message:
1054 - Unknown column 'p.products_group_access' in 'where clause'
select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, if (isnull(pg.customers_group_price), p.products_price, pg.customers_group_price) as products_price, p.products_date_added, p.products_image from ((products p left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id = 'G') left join specials s on p.products_id = s.products_id), products_description pd where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.products_group_access like '%G%' and DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= p.products_date_added order by rand(), p.products_date_added desc limit 3
TEP_DB_ERRORR
And in the administration the text editor is, the one you use when creating new products and editing information, is missing