Post by CaptainHaddock » Fri Aug 19, 2016 6:38 am

Hi,
How do I completely delete a product in the database using phpmyadmin ?
My open cart admin products page has stopped working
I need to delete a product I added yesterday as I suspect it is causing this problem due to one of the fields being empty or having funny characters in it etc. (Yesterday I set up a new multistore with one category, manufacturer and product - I did it in a bit of a rush)

I can see many tables in the database with product in their name.

How do I completely delete a product in the database using phpmyadmin ?

Thanks very much

Opencart 1.5.5.1
VQMOD
Extensions installed:
Journal Theme
SEO Pack Pro
All Products From Subcategory in Parent Category
All Products From Subcategories in Parent Category Filters
Remove Return Links

Bug fixes applied:
Fix for Tag Filters not working (see OpenCart 1.5.5 Bug Thread)


New member

Posts

Joined
Tue Jul 02, 2013 7:01 am


Post by IP_CAM » Fri Aug 19, 2016 9:56 am

Technically, delete a Product on a DB as shown on the image below. The handling depends a little
on the Tool used, depending on the Hoster Server Setup. But for smaller Job's, it may be more convenient
to implement your own MyPHP Admin Tool into your Admin Section, by using the famous Sql-Buddy
for this Job, and you run an OC-Version, probably able to get along with the VqMod Linking just fine.
OC v.2.x Versions will probably use another way of the VqModded linking, but other than that, it should
work with OC-2 as well. One just as to pass the admin credentials with/in the link, to make it work.

Just to mention it! ;)
And if you removed the Product, refresh/optimize your DB again.

But check on this nice little Helper, when it comes to handling a DB from the Shop Admin:

OpenShop Admin SQLBuddy free, OC v.1.5.6.x - VqMod-linked to work with OC v.1.5.6.x Admin,
updated and tested and works with PHP 7.1.xx, as it comes...:
http://www.ipc.li/os/My_Sqlbuddy.zip

This MySql Buddy Extension will change NOTHING in your existing Shop. Everything, exept for the VqMod,
is added into a separate Subdirectory within the Admin Section, and may be deleted anytime, without
leaving any traces of this anywhere!
JUST BE AWARE, that you could destroy your DB, if you do not know, what you're doing! ;)
---
Another MySQL_Buddy exists, implemented/working like/as a regular OC-Module, but I personally like it better
this way, originally beeing part of MaxD's famous OpenShop Extension, when it comes/works in a
separate Window, and is not a moduled and so 'fixed' part of OC. I have both installed, the 'built-into the OC-Frame' Buddy leaves much less working-space to really see much without scrolling on a steady bases.
Despite of the Fact, that this way may be a little less secure, access-wise, compared to the moduled-Version.
As Info ! So much to this.
---
but don't forget, to read and get here, how to unleash the Power of your DB, by use of the famous:

ATOMIX TURBO InnoDB DB-Engine Changer + Full DB all OC-Version Indexer Tool!
http://forum.opencart.com/viewtopic.php ... 71#p580125
---
Good Luck !
Ernie
---

Attachments

my_sql_buddy_opencart_156.jpg

MySQLBuddy Admin Database Interface - my_sql_buddy_opencart_156.jpg (97.75 KiB) Viewed 1514 times


Please don't send me OC Forum Personal Messages, just contact: jti@jacob.ch
---
OC 1.5.6.5 LIGHT Test Site: http://www.bigmax.ch/shop/
OC 1.5.6.5 V-PRO Test Site: http://www.jacob.ch/shop/
My Github OC Site: https://github.com/IP-CAM
2'600+ FREE OC Extensions on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 45 guests