Paypal module will not uninstall and re-install

[chief_wiggum]

Hello, the Paypal module on a clients website will not uninstall or reinstall itself, in fact all of the payment modules will not do this on this installation.

The zencart was installed for the client via fantastico on his C-Panel.

When clicking on the uninstall or reinstall modules buttons, the site is getting the following errors:

1062 Duplicate entry 'MODULE_PAYMENT_PAYPAL_STATUS' for key 2
in:
[insert into zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable PayPal Module', 'MODULE_PAYMENT_PAYPAL_STATUS', 'True', 'Do you want to accept PayPal payments?', '6', '0', 'zen_cfg_select_option(array(\'True\', \'False\'), ', now())]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

and this one for the credit card module:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'If an email address is entered, the middle digits of the credit card number will' at line 1
in:
[insert into zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Split Credit Card Email Address', 'MODULE_PAYMENT_CC_EMAIL', '\', 'If an email address is entered, the middle digits of the credit card number will be sent to the email address (the outside digits are stored in the database with the middle digits censored)', '6', '131', now())]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Please can anyone help with this?

[DrByte]

You can manually remove the paypal module by running this SQL:

delete from configuration where configuration_key like 'MODULE_PAYMENT_PAYPAL_%';

(change delete from configuration to delete from zen_configuration for this client)

[chief_wiggum]

Thanks Dr Byte, seems it was a Mysql version conflict with the code.

[TheOracle]

Note: For future reference, since it has not been mentionned where DrByte's modifications has to be executed, it is under the admin - > tools - > Install SQL Patches.