Завершен

update OSCOMMERCE

error messages and some client access functionality has been lost recently due to PHP upgrades by server I suspect.

Anyway - need to update the site and remove all error messages and allow for clients to register and log in and not be confused by these error messages

eg:

3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'dnssuppl_shop.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price, pd.products_name from products p, products_description pd left join products_to_categories p2c using(products_id) left join categories c using(categories_id) where p.products_id = pd.products_id and products_status = '1' and find_in_set('4', products_hide_from_groups) = 0 and find_in_set('4', categories_hide_from_groups) = 0 and pd.language_id = '1' order by p.products_date_added desc limit 9

[TEP STOP]

eg:

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'dnssuppl_shop.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p left join products_to_categories p2c using(products_id) left join categories c using(categories_id) where opa.products_id = '41664' and opa.orders_id = opb.orders_id and opb.products_id != '41664' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' and find_in_set('4', products_hide_from_groups) = 0 and find_in_set('4', categories_hide_from_groups) = 0 group by p.products_id order by o.date_purchased desc limit 6

Навыки: PHP, OSCommerce, MySQL, HTML, Zen Cart

Показать больше: shipping modules dont update oscommerce admin, quick update oscommerce description, price update oscommerce, easy csv products date update oscommerce, easy update oscommerce, products attributes update oscommerce, oscommerce product automatic sync sql mysql, update oscommerce 2009, products update oscommerce xml, debug mode sql error 1114 table phpbb_sessions full, price update oscommerce addon, update oscommerce xls, quick quantity update oscommerce

О работодателе:
( 1 отзыв ) East Lindfield, Australia

ID проекта: #28349486

Поручен:

satishkumarpawar

Hello, I am 10+ years experienced in php, mysql, osCommerce. I can fix errors of your site that are due to upgrade some configuration on server like php version. Thanks

$30 AUD за 3 дней(-я)
(1 отзыв)
0.7

10 фрилансеров(-а) готовы выполнить эту работу в среднем за $178

(127 отзывов(-а))
8.7
(624 отзывов(-а))
7.9
sat12

I will update osCommerce to latest version . are you currently using os 2.2 ? I am osCommerce,Wordpress,PHP programmer having 8 years of experience. I am very good in osCommerce,wordpress,php,mysql,joomla.

$170 AUD за 3 дней(-я)
(501 отзывов(-а))
7.2
techplusintl

Hi there, ★★★ PHP (osCommerce) Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to debug & fix errors on your website. Websites we built with osCommerce: ✔ [login to view URL] ✔ http Больше

$250 AUD за 3 дней(-я)
(201 отзывов(-а))
7.4
webmaestro2013

Dear Sir/Mam I will upgrade your site to latest version of oscommerce and resolve all issue PLEASE HAVE A LOOK AT MY PROFILE FOR MORE ABOUT MY RATING AND REVIEWS I will complete this job successfully. I have 10+ ye Больше

$150 AUD за 7 дней(-я)
(221 отзывов(-а))
7.1
kholmogorovadev

Hello I can help you as well I can fix your issues asap Please contact me best regards Aleksandra Kholmogorova

$250 AUD за 7 дней(-я)
(23 отзывов(-а))
5.6
paritoshikpaul

Greetings, I just came across your job posting for an expert OScommerce developer, I believe I have the ideal mix of skills and past experience to be a top candidate for this job and if you are looking for a profession Больше

$200 AUD за 10 дней(-я)
(10 отзывов(-а))
4.2
tracygearth

I will update osCommerce shopping cart source code to fix the errors. I have customize osCommerce and other shopping cart web code and made changes. I am working in open source since 8 years and in eCommerce last 6 yea Больше

$30 AUD за 1 день
(5 отзывов(-а))
1.8
faizanmaqbool695

Hi there, I have read your project description and I am confident about your project I can do perfectly. Please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. regard , fa Больше

$200 AUD за 1 день
(0 отзывов(-а))
0.0