Fix PHP Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax;

£5-10 GBP / hour

Closed

Posted

over 7 years ago

£5-10 GBP / hour

[12-Dec-2016 23:45:40 Europe/London] PHP Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-15, 15' at line 22<br />Error No: 1064<br />SELECT SQL_CALC_FOUND_ROWS CONCAT([login to view URL], ' ', [login to view URL]) as '[login to view URL]', (SELECT count(*) as total FROM oc_order_product op LEFT JOIN oc_ms_product mp USING (product_id) WHERE seller_id = ms.seller_id) as total_sales, [login to view URL] as '[login to view URL]', ms.seller_id as 'seller_id', [login to view URL] as '[login to view URL]', ms.seller_status as 'ms.seller_status', ms.seller_approved as 'ms.seller_approved', ms.date_created as 'ms.date_created', [login to view URL] as '[login to view URL]', [login to view URL] as 'banner', [login to view URL] as '[login to view URL]' FROM `oc_customer` c INNER JOIN `oc_ms_seller` ms ON (c.customer_id = ms.seller_id) LEFT JOIN `oc_ms_product` mp ON (c.customer_id = mp.seller_id) WHERE 1 = 1 AND seller_status IN (1) GROU in /home/thepatc2/public_html/system/library/db/[login to view URL] on line 40

eCommerce

MySQL

PHP

Project ID: 12493858

About the project

16 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

16 freelancers are bidding on average £10 GBP/hour for this job

@AMsolutions1

READY TO SOLVE NOW!!!! Please share website detail so we can start to solve the error. Looking forward. Thanks

£8 GBP in 5 days

5.0

(206 reviews)

7.8

@prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore your needs, which will yield a clear picture of implementation phase. Prior undertaking project, I want to show demo of the work done previously. Apart from demo, I will be sharing following documentation which will turn your project into Quality and Successful delivery: - Technical Project Proposal - Designs - Flow chart for this Project - Execution plan

£15 GBP in 1 day

4.9

(68 reviews)

7.3

@mvaqasuddin

hi there, how are you doing ? send ftp details. I will fix the query issue right away. I am available over chat. Thanks

£8 GBP in 1 day

4.8

(298 reviews)

7.0

@jiitendra

Hi, I have reviewed your requirement and I can do this job as per your requirement. I have a advanced skills in WORDPRESS ,PHP, MYSQL, JavaScript, HTML, Jquery, Magento, HTML 5 ,YII frame, PSD to HTML and CSS to name a few. I have worked more than 100 website in Magento and WordPress including theme and customized theme as well. I am looking for long term work relationship from you. Looking forward for your positive response. For more reference please see portfolio herewith. Regards, Jitendar

£8 GBP in 1 day

4.6

(39 reviews)

6.0

@syncnologies

Hello Sir/ Ma’am, We have pool of dedicated team consisting of certified developers capable enough to handle your project exactly according to requirements and within said time frame. As per shared project description we find ourselves fit for project work, as we have developed several projects with approx. similar features and functionalities. Looking forward for small conversation to discuss your complete scope of work and suggest/recommend you complete solution. Thanks

£6 GBP in 10 days