What's the best way go go about removing bad products?

I'm helping a buddy of mine upgrade his site, and he has a few old products installed that don't have table entries anymore. I get errors like this:

Invalid SQL:
SELECT TITLE FROM `vb3_cron` WHERE TITLE LIKE 'AboutToday';

MySQL Error : Unknown column 'TITLE' in 'field list'
Error Number : 1054
Request Date : Sunday, June 8th 2008 @ 11:01:46 AM

And this:

Database error in vBulletin 3.7.1:

Invalid SQL:
ALTER TABLE vb3_post DROP nowplaying;

MySQL Error : Can't DROP 'nowplaying'; check that column/key exists
Error Number : 1091
Request Date : Sunday, June 8th 2008 @ 11:03:00 AM

The products are disabled, but seeing them in the list and knowing that they're there is bothering me.

[Marco van Herwaarden]

Why doesn't your friend post himself?

Originally Posted by Marco van Herwaarden

Why doesn't your friend post himself?

Because he's running 12 pirate versions of vB run by sweatshop children working 19 hour shifts in a basement with Martha Stewart lording over them with an Indiana Jones whip in her hand.

Or because, if you read my post, I'm the one doing it, which is pretty obvious to everyone as is your insinuation that I'm working with a pirated copy of vB. In either case I don't appreciate it, and as usual, your smug, concescending tone towards a Jelsoft customer.

[Boofo]

Disabling them doesn't remove the db entries or the template edits. Have you tried removing them completely by uninstalling them? (You pirate, you.)

[harmor19]

I'm not sure if this will work bu edit the product and paste $db->hide_errors(); at the end of uninstall code.


If that doesn't work try...
You can edit the product, copy the install code and paste it into a PHP file.
Upload the PHP file, run it and it should add the tables. Then you can proceed to uninstall the product via the ACP.

[Marco van Herwaarden]

Originally Posted by Chris-777

Because he's running 12 pirate versions of vB run by sweatshop children working 19 hour shifts in a basement with Martha Stewart lording over them with an Indiana Jones whip in her hand.

Or because, if you read my post, I'm the one doing it, which is pretty obvious to everyone as is your insinuation that I'm working with a pirated copy of vB. In either case I don't appreciate it, and as usual, your smug, concescending tone towards a Jelsoft customer.

I asked a simple question. What you read in this i can not control. The question itself did not mention any piracy (but this is obviously on your mind) nor is it posted in a condensing tone.

Originally Posted by Marco van Herwaarden

I asked a simple question. What you read in this i can not control. The question itself did not mention any piracy (but this is obviously on your mind) nor is it posted in a condensing tone.

Marco,

If you can't answer my question or contribute to the discussion, please don't clutter my thread with nonsense. The person posting the question has nothing to do with the problem, so your comments are off the mark and unnecessary.