Käynnissä

Fix OSCommerce problem

Getting this error since moving site to updated server:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where p.products_status = '1' and pd.products_id = p.products_id and [url removed, login to view]' at line 1

select count(p.products_id) as total from ((products p, products_description pd, manufacturers m) left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '16'

[TEP STOP]

Only occurs when using search or selecting manufacturer from drop down list. Believe problem is with [url removed, login to view] but unable to rectify it.

Taidot: PHP

Näytä lisää: search manufacturer fix oscommerce, search for manufacturers, products manufacturers, manufacturers products, manufacturer search, line in problem, number queries oscommerce problem fix, fix oscommerce, oscommerce using sql server, p sql, rectify, problem, manufacturers list, php sql syntax error, 1064 php, sql syntax error, php mysql 1064, mysql sql syntax, sql problem, fix line, error sql syntax site, sql syntax, drop list search mysql, manufacturer list oscommerce, oscommerce tep stop error

About the Employer:
( 9 reviews ) Shoreham by sea, United Kingdom

Projektin tunnus: #403316

Myönnetty käyttäjälle:

TakeReal

I can fix this issue. I need FTP access to start right now.

30 $ USD 1 päivässä
(1254 arvostelua)
7.5

8 freelanceria on tarjonnut keskimäärin 55 $ tähän työhön

tisindiadelhi

Hi! Please refer to PMB for details. Thanks & Regards Manoj

200 $ USD 1 päivässä
(36 arvostelua)
7.2
jexplorer

Please check PMB. jexplorer

30 $ USD 0 päivässä
(164 arvostelua)
7.1
eelance

i can fix that for you.np.

30 $ USD 0 päivässä
(343 arvostelua)
6.8
ichurakov

Please check PM. Thnx.

40 $ USD 1 päivässä
(215 arvostelua)
6.3
erwindraft

Hi i have fix this issue before, can start working right now.

30 $ USD 0 päivässä
(88 arvostelua)
5.8
Pektsekye

can you attach the file with the query ?

30 $ USD 1 päivässä
(107 arvostelua)
5.6
misulica

Please check PMb

50 $ USD 0 päivässä
(31 arvostelua)
4.8