Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By zilla on
so i tried the image module and image assist and then dropped it, same for the abandoned img_filter module - finally went with imagefield/imagecache BUT when i go to phpmyadmin i see rows for:
image
image_attach
img
img_assist_map
img_comments
img_thumbnails
same for other modules i uninstalled like kudos, invite and so on..
some of these show 0 records, and others, though deleted, show records (11 for image and so on)
if i simply go to phymyadmin and 'drop' these rows - or empty them and then drop them, even where there are some records but the modules are gone, will it blow up my install???
could i just 'empty' them and then drop them and run update.php???
Comments
let me clarify: must i empty before dropping?
i've found tons of threads about this, stating that 'dropping' is fine, but none specify if i must empty them first! any insights?
........................................................................
i love to waste time: http://twitter.com/passingnotes
The safest way is to upload
The safest way is to upload those modules again and then go to the /admin/build/modules/uninstall page and see if they have an uninstall routine which you can run.
After that you can remove them again, and if there are any remaining entries in the database remove then as well (with some common sense).
yes, but a few did not have uninstall options!
thanks for the fast reply - a few didn't have uninstall options, including one that's dead now (img filter) - so would doing it via phpmyadmin achieve the same effect? and should i empty them first and then drop? i'd love to clean up these tables...
........................................................................
i love to waste time: http://twitter.com/passingnotes
If you are going to drop a
If you are going to drop a table, you don't need to empty it first. Just drop it.
You can find out about tables which a module created in its modulename.install file (if it has one). Also, they all have entries in the 'system' table, and possibly some entries beginning with the module's name in the 'variable' table.
You can also check for leftover files and directories (like files/images for the image module).
thanks - this worked
modules like 'event' did leave an entry in system table...couldn't find any in variables, but the whole thing went smoothly (knock on wood ;)
........................................................................
i love to waste time: http://twitter.com/passingnotes
pl elabrate what you did
For the benefit of others (read me :-) can you elaborate what worked for you.
1. If you found an entry in the system table - did you delete that entry?
2. For other modules if you found table(s) did you DROP using phpmyadmin?
sure, here's what i did:
in order of operations:
opened my drupal install, went to modules/ - deactivated whatever wasn't already disabled (that i wanted to get rid of)
went to admin/modules/uninstall and removed whichever ones were listed
left admin screen open and remained logged in...
opened ftp program, went to sites/all/modules and manually deleted folders for whatever modules still remained that i wanted to get rid of (some said 'uninstall' but folders remained)
opened new browser window for phpmyadmin and opened main tables list for the database for my install, went down the rows for these modules (eg. image, image_assist and others that were left over - whether they had 11 records or 0) and 'checked the little box' and then at bottom of screen selected to drop them all as a batch
went to system table via phpmyadmin and looked for any module instances (sometimes one or two will add crap here) - dropped from here too if they were there...
closed phpmyadmin
went back to my drupal install admin screen and ran update.php and then looked back at the modules screen to make sure the crap was all gone, also doublechecked 'content listings' to make sure there wasn't some odd test entry that made use of the module (which may call an error or oddity) -eg test postings that used image assist before i removed image and imageassist and so on...
that's about it. pretty easy and worked like a charm.
........................................................................
i love to waste time: http://twitter.com/passingnotes
subscribing to the thread
subscribing to the thread