Closed

Fix error in Opencart e-commerce

if i add product on opencart, it will take other product name "Peruskone 1"

Maybe it is because product takes wrong ID from MySql????

After i edit that product it gives error:

"Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/datastoppi/system/library/db/[login to view URL] on line 19Notice: Error: Subquery returns more than 1 row

Error No: 1242

SELECT DISTINCT *, TRIM(LEADING '0' FROM [login to view URL]), (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=113') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113' AND pd.language_id = '1' in /var/www/datastoppi/system/library/db/[login to view URL] on line 41Notice: Trying to get property of non-object in /var/www/datastoppi/vqmod/vqcache/[login to view URL] on line 648Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/datastoppi/system/library/db/[login to view URL] on line 19Notice: Error: Subquery returns more than 1 row

Error No: 1242

SELECT DISTINCT *, TRIM(LEADING '0' FROM [login to view URL]), (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=113') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113' AND pd.language_id = '1' in /var/www/datastoppi/system/library/db/[login to view URL] on line 41Notice: Trying to get property of non-object in /var/www/datastoppi/vqmod/vqcache/[login to view URL] on line 648"

Can someone help me for this problem?

Skills: PHP, MySQL, HTML, Open Cart

About the Client:
( 0 reviews ) Cheras, Malaysia

Project ID: #34039228

21 freelancers are bidding on average $36 for this job

GetReal

Hello, let me fix the error for you. I have vast experience in opencart and ecommerce. Ready to start now and do ot for you asap. Look forward to work with you. Thanks

$30 USD in 1 day
(1021 Reviews)
8.5
(505 Reviews)
8.2
(418 Reviews)
7.5
(248 Reviews)
7.0
BitLabs

Hello, I have gone through your outsourced requirements " Fix error in Opencart e-commerce " and have analyzed that I have right skills ( PHP MySQL HTML Open Cart ) to execute your esteemed project. I will compl More

$20 USD in 7 days
(134 Reviews)
6.8
(210 Reviews)
6.6
(103 Reviews)
6.7
oliviainfotech

Hi greetings of the day I am a Experienced Full Stack Developer based out in Chennai,India. I am Ready to start now. Thanking you, All the very best, Cheers!!! Saurav

$55 USD in 1 day
(145 Reviews)
6.1
(41 Reviews)
5.7
munjalmayank

Dear Customer, Greetings from Microprixs Solution! ---------------------------------- This is not automated proposal ---------------------------------- We have understood the requirement and we can complete tha More

$25 USD in 1 day
(148 Reviews)
5.8
Kavita9166

Hello I am a good fit for this Job I have lots of experience in this sector. I have worked for many Client before on other platforms. Thank you in advance for your time and consideration. Thanks Rajesh Jangid

$20 USD in 7 days
(28 Reviews)
4.2
ajythakur

Good day!! I am ready to start now and will fix the issue asap. The issue seems in your database tables. Please connect for further discussion. Thanks

$20 USD in 2 days
(13 Reviews)
4.1
neel4help

As you are looking for Opencart developer So I am a highly skilled Opencart development with more than 6+ years of quality experience in designing & developing wide range of responsive websites. I Have read your proj More

$20 USD in 1 day
(16 Reviews)
4.1
(20 Reviews)
3.7
karlmarkus609

Hello! I have just seen your project requiring; PHP, MySQL, HTML I believe that my 8+year experience in this field is what you need right away. As u can see my profile, I have 8+years experience of Website Design. I c More

$30 USD in 2 days
(1 Review)
0.6
cometrue1003

Hi! Hope you are well. I am skilled laravel coder. I am familiar with Laravel and I have a lot of work experiences in HTML, Laravel, MySQL, Website Design and PHP. I can start right away. Please send a message to discu More

$140 USD in 7 days
(0 Reviews)
0.0
Alchemist98

Hi there I have been working on Oracle, Mysql database and have a good amount of experience. It seems to be a quickly solvable problem. But to solve the problem will need to see the schema design and the relation betwe More

$15 USD in 7 days
(0 Reviews)
0.0
Shahidi001

I can fix the problems you are facing here. Here's some fields I'm expert at, web design, customize, development, adding features etc. This for website, I'm also good at mobile app creating and development.

$40 USD in 7 days
(0 Reviews)
0.0
zubairgeeks

Greetings Sir Sir you mentioned in deep explanation about Sql error you see when edit admin product form Sir my name is Zubair and i have been working as a web developer since 2014. Sir i can develop/fix Opencart websi More

$30 USD in 3 days
(0 Reviews)
0.0
hafizmabuzar

Hi, Please share more details about issue and please let me know if you can give access of source code then let’s discuss and get it resolved asap. Feel free to contact.

$30 USD in 3 days
(0 Reviews)
0.0