Forums / General Questions / Paypal module will not uninstall and re-install

Paypal module will not uninstall and re-install

Locked

Views: 1,711

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
3 Aug 2006, 2:57 PM
#1
chief_wiggum avatar

chief_wiggum

Zen Follower

Join Date:
Feb 2005
Location:
Manchester ~ UK
Posts:
107
Plugin Contributions:
0

Paypal module will not uninstall and re-install

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?

3 Aug 2006, 8:30 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Paypal module will not uninstall and re-install

You can manually remove the paypal module by running this SQL:```
delete from configuration where configuration_key like 'MODULE_PAYMENT_PAYPAL_%';

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Aug 2006, 10:37 AM
#3
chief_wiggum avatar

chief_wiggum

Zen Follower

Join Date:
Feb 2005
Location:
Manchester ~ UK
Posts:
107
Plugin Contributions:
0

Re: Paypal module will not uninstall and re-install

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

4 Aug 2006, 12:11 PM
#4
theoracle avatar

theoracle

Suspended

Join Date:
Aug 2004
Posts:
3,180
Plugin Contributions:
1

Re: Paypal module will not uninstall and re-install

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.