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

Kemahiran: Troli Membeli-belah

Lihat lagi: 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

Tentang Majikan:
( 64 ulasan ) sabro, Denmark

ID Projek: #284533

Dianugerahkan kepada:


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

$30 USD dalam sehari
(21 Ulasan)

2 pekerja bebas membida secara purata $40 untuk pekerjaan ini


hi, please check the PM

$50 USD dalam 0 hari
(35 Ulasan)