Re-installing module, mysql error

i did uninstall some of my modules and then when i  tryed to install them again the store module and membership modules  gave errors..

INSERT INTO `bx_pmt_modules`(`uri`) VALUES ('membership');

you need to install the payment module first.   its basicly saying it cant find the table for payments...

Yea. Agreed.

But that is a bug. The module install should have detected that and reported the payment module needs to be installed.

i think it will on first install after a clean setup.  i noticed alot of them just give an error like that  when you remove then add it back after first install.

i had actually uninstalled both payment and store modules but it gave errors on uninstalling payment module

Now it says that payment module is installed  but i cannot uninstall it .

And store module is not installed and i do get error if i try to install it.. so ıt doesnt work neither way

SET @iCategoryId = (SELECT `ID` FROM `sys_options_cats` WHERE `name`=@sModuleName LIMIT 1);

DELETE FROM `sys_options_cats` WHERE `name`=@sModuleName LIMIT 1;

/BUMP/

İ will try to explain it clearer..

i did uninstall several modules including payment and store..

Store module got uninstalled but payment failed..

i tryed to uninstall payment again but it always failed and installation of store/membership modules gives me also error.

My problem is that i cannot uninstall-payment and i cannot install-store/membership

INSERT INTO `bx_pmt_modules`(`uri`) VALUES ('membership');

SET @iCategoryId = (SELECT `ID` FROM `sys_options_cats` WHERE `name`=@sModuleName LIMIT 1);

DELETE FROM `sys_options_cats` WHERE `name`=@sModuleName LIMIT 1;

For some reason your database collations got messed up.

Your not going to be able to get the membership module installed until the payment module is properly installed. So the payment module needs to come out first so it can be reinstalled.

So, because of these errors, the payment module will need to be removed from the database by hand using phpmyadmin.


I can come up with a procedure to do that. I'll need a little time to work it all out.