Oscommerce Project
i need errors fixed in my coding my host is saying. please bid if you have experience in field and can fix all errors im running into. maby a diagnostics can be ran so all errors are resolved in code….i do not want anyone that wants to get payed before errors are fixed. i had a programmer who said can do it and after he got in said everything looks fine. after errors resolved i will gladly pay… below is wut host said and under are 2 main error messages i am receiving on 2 different sites
This error is caused by the query you are running in the screenshot not completing in time when writing to the MySQL database which in turn is using too many resources which is then terminated before it continues to cause a high load on the server.
———-
http://www.jordansnyc.com/productsnew.php
1053 – Server shutdown in progress
select distinct p.products_id, p.products_date_available, p.products_date_added, p.products_image, p.products_tax_class_id, pd.products_description, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_status = ‘1’ and p.products_id = pd.products_id and pd.language_id = ‘1’ order by p.products_date_added desc limit 9
[TEP STOP]
2013 – Lost connection to MySQL server during query
select count(*) as total from sessions where sesskey = ‘5ce9e931df00fd34478995d50783f3cd’
[TEP STOP]
&
1053 – Server shutdown in progress
update products_description set products_viewed = products_viewed+1 where products_id = ‘1186’ and language_id = ‘1’
[TEP STOP]
2006 – MySQL server has gone away
select count(*) as total from sessions where sesskey = ‘5ce9e931df00fd34478995d50783f3cd’
[TEP STOP]
need site to load faster again since error is causing load to slow down.
MAKE SURE YOU KNOW WhAT TO DO BEFORE BIDDING