I gang

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

Færdigheder: Indkøbsvogne

Se mere: bug fixing freelancer, som, pg, error fixing, desc, editing fixing, error bug, 1054 unknown column select, 1054 unknown, need fixing, 1054, specials, oscommerce error message, oscommerce bug help, unknown order oscommerce, error message oscommerce, need bug, mysql server error, custom modifications oscommerce, oscommerce order editor bug, unknown column clause 1054, editing oscommerce, limit order, bug custom shop, oscommerce page custom

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 for dette job


hi, please check the PM

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