Post by livewire » Tue Apr 11, 2017 3:19 pm

When i was adding a product , suddenly there was an SQL error. But now im unable to edit or delete that product coz there is no product ID. On my product list when i try to edit everything appears blank.

Can someone tell me how can i delete this product ?

Thanks

New member

Posts

Joined
Thu Mar 14, 2013 3:28 pm

Post by sachin6609 » Tue Apr 11, 2017 6:06 pm

livewire wrote:
Tue Apr 11, 2017 3:19 pm
When i was adding a product , suddenly there was an SQL error. But now im unable to edit or delete that product coz there is no product ID. On my product list when i try to edit everything appears blank.

Can someone tell me how can i delete this product ?

Thanks
Hii

Copy Paste the error here man

Thanks

Sachin

Active Member

Posts

Joined
Thu Jul 23, 2015 2:57 pm

Post by harsh.k1987 » Tue Apr 11, 2017 6:10 pm

you can enable show error from backend of opencart that will show you the error.
For direct delete you can go in phpmyadmin and delete that particular product from product table.

Best Regards
Harry Kumar
hkdev1987@gmail.com
skype : hk.dev


New member

Posts

Joined
Tue May 26, 2015 7:59 pm
Location - india

Post by livewire » Wed Apr 12, 2017 2:14 am

The sql error came only once. When i refreshed it went away..
From the admin it shows the product but when i edit, the content is empty

The reason is that the product_id= has no number

New member

Posts

Joined
Thu Mar 14, 2013 3:28 pm

Post by furkeen » Thu Dec 06, 2018 11:50 am

Hello I have same problem, some of the product ID is missing in the link so the content is empty when I click edit button. My opencart version 2.1.0.1 how did you solve? Or did you solve?

Newbie

Posts

Joined
Sat Apr 23, 2016 12:47 am

Post by furkeen » Thu Dec 06, 2018 1:07 pm

Hello again I solved problem, if the product has no category the problem appaer so I add all product, all product category the problem disappear.

Newbie

Posts

Joined
Sat Apr 23, 2016 12:47 am
Who is online

Users browsing this forum: No registered users and 330 guests