Jump to content

[SOLVED] Reset COD module triggers PrestaShopDatabaseException


Recommended Posts

In order to get to the bottom of a problem with Cash on Delivery (CoD) I figured I'd try resetting the module, or even uninstall, delete and reinstall it.

 

Regardless of the two approaches, I get a prestashop database exceiption: Take a look.

 

The module installs, but doesn't seem to show up during checkout, even if it is enable as a valid payment method (bottomg of payments).

 

Cheers, K

 

edit: Yes, I've cleared cache :) On both server, prestashop and browser and forced compiling.

Edited by ktraving (see edit history)
Link to comment
Share on other sites

Based on the error, the module does not reset properly.

I suspect your database is having some inconsistencies such as duplicate module or the like.

Because the error occur, the module did not get hooked on the payment, hence does not appear.

 

Closely inspect the table ps_module, ps_hook_module, ps_module_currency, ps_module_group.

Remove the references to the module(s).

Once done, reinstall the module.

 

If you have no clues how to do such PM i'll have a quick jump on your system an fix-it.

  • Like 1
Link to comment
Share on other sites

I've had a look at the ps_module tables (access, country, currency.....etc)

 

Upon uninstall and delete, the module is removed from all of the above.

 

Upon reinstall the module also reappeares (with a new ID ofcourse) in all tables.

 

Cheers, K

 

Edit: Any chance you know the name of the table for what groups have access to specific payment options?

Edited by ktraving (see edit history)
Link to comment
Share on other sites

Not clear from your last message if the problem get fixed or not.

 

The table making the relation from payment modules/group is ps_module_group.

That your module reappear upon installation on the tables is expected, what is not expected is the duplicate-key.

 

Which version of COD do you have?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...