Problem un-installing module

Uploaded a module to a new site build, think the ftp got corrupted as file sizes were not matching the originals.

However, initially the module would show as installed in admin, page blocks would be added, but module functions were not working properly.

So, I have tried overwritting the module with an ftp using binary mode, but still no change

then tried to un-install and start over

at this point, it has removed all the page blocks of the module, but still shows as installed in admin.

when I click un-install, I get this error message in admin

-- -- There are errors in the following MySQL queries:
-- -- Error: 

DELETE FROM `a_gwall_handlers` WHERE `alert_unit` = 'agrp_palbums';

You will need to look at the install.sql file to see what changes the module made to the database and then do a manual check and manual removal to clean up the database.  As any time you are working with a database, make a backup first.

You can also look at the error messages and modify the uninstall.sql file to walk around something trivial in the uninstall process.