Bug fixing

Bug fixing is project number 284533 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider TakeReal
Budget:	$30-250
Created:	07/08/2008 at 18:32 EDT
Bidding Ends:	07/09/2008 at 18:32 EDT
Project Creator:	straszek   Buyer Rating: (7 reviews)
Description:	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
Job Type:	OsCommerce
Database:	MySQL
Operating system:	Linux
Bid count:	2
Average bid:	$ 40