Bug fixing

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


And in the administration the text editor is, the one you use when creating new products and editing information, is missing

Evner: Indkøbsvogne

Se mere: 1054 unknown column pproducts_group_access clause, 1054 unknown column products_group_access clause, pproducts_group_access clause, 1054 unknown column customers_group_price, bug fixing freelancer, som, pg, pg 5+, P&G, error fixing, desc, editing fixing, error bug, 1054 unknown column select, 1054 unknown, need fixing, 1054, 1054 unknown column language_id clause, specials, oscommerce error message, oscommerce bug help, unknown order oscommerce, error message oscommerce, need bug, mysql server error

Om arbejdsgiveren:
( 64 bedømmelser ) sabro, Denmark

Projekt ID: #284533

Tildelt til:


I can fix this error today. I need FTP access to your site.

$30 USD på 1 dag
(21 bedømmelser)

2 freelancere byder i gennemsnit $40 på dette job


hi, please check the PM

$50 USD in 0 dage
(35 bedømmelser)