Jump to content

Exception: You are not allowed to disable the module


Recommended Posts

Hey guys,

Getting this error when installing a module:

Exception:
You are not allowed to disable the module eupago_multibanco.

  at src/Core/Addon/Module/ModuleManager.php:415
  at PrestaShop\PrestaShop\Core\Addon\Module\ModuleManager->disable('eupago_multibanco')
     (src/PrestaShopBundle/Controller/Admin/Improve/ModuleController.php:594)
  at PrestaShopBundle\Controller\Admin\Improve\ModuleController->importModuleAction(object(Request))
  at call_user_func_array(array(object(ModuleController), 'importModuleAction'), array(object(Request)))
     (var/cache/dev/classes.php:4663)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (var/cache/dev/classes.php:4618)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, false)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request), 1, false)
     (adminPS/index.php:88)

I appreciate any help.

Cheers

Link to comment
Share on other sites

  • 2 months later...
  • 2 months later...

I had this issue when I was developing module, and during development it was inside modules directory. So when I tried to upload zip file, it showed the error above. All I had to do is remove module from /modules (because it was uninstalled, just writing code there) and upload passed and got installed.

  • Like 1
Link to comment
Share on other sites

  • 5 months later...

I have exactly the same problem and EXACTLY the same debug alert message when trying to install another payment module (vivawallet).

I tried manually adding the module folder in /modules/ but it does not appear in the Backoffice modules list.

Problem still not solved.

Capture d’écran 2020-02-13 à 08.36.33.png

Link to comment
Share on other sites

Well actually this was possibly a very good suggestion as all other searches for a solution have been unsuccessful. But sadly there is absolutely nothing in the _authorization_role table that remotely mentions the vivawallet module or any other element which can cause this issue. Here is the list from that table, maybe I can't see something:

         753     ROLE_MOD_MODULE_BLOCKREASSURANCE_CREATE
        756     ROLE_MOD_MODULE_BLOCKREASSURANCE_DELETE
        754     ROLE_MOD_MODULE_BLOCKREASSURANCE_READ
        755     ROLE_MOD_MODULE_BLOCKREASSURANCE_UPDATE
        757     ROLE_MOD_MODULE_COLISSIMO_CREATE
        760     ROLE_MOD_MODULE_COLISSIMO_DELETE
        758     ROLE_MOD_MODULE_COLISSIMO_READ
        759     ROLE_MOD_MODULE_COLISSIMO_UPDATE
        453     ROLE_MOD_MODULE_CONTACTFORM_CREATE
        456     ROLE_MOD_MODULE_CONTACTFORM_DELETE
        454     ROLE_MOD_MODULE_CONTACTFORM_READ
        455     ROLE_MOD_MODULE_CONTACTFORM_UPDATE
        457     ROLE_MOD_MODULE_DASHACTIVITY_CREATE
        460     ROLE_MOD_MODULE_DASHACTIVITY_DELETE
        458     ROLE_MOD_MODULE_DASHACTIVITY_READ
        459     ROLE_MOD_MODULE_DASHACTIVITY_UPDATE
        469     ROLE_MOD_MODULE_DASHGOALS_CREATE
        472     ROLE_MOD_MODULE_DASHGOALS_DELETE
        470     ROLE_MOD_MODULE_DASHGOALS_READ
        471     ROLE_MOD_MODULE_DASHGOALS_UPDATE
        473     ROLE_MOD_MODULE_DASHPRODUCTS_CREATE
        476     ROLE_MOD_MODULE_DASHPRODUCTS_DELETE
        474     ROLE_MOD_MODULE_DASHPRODUCTS_READ
        475     ROLE_MOD_MODULE_DASHPRODUCTS_UPDATE
        461     ROLE_MOD_MODULE_DASHTRENDS_CREATE
        464     ROLE_MOD_MODULE_DASHTRENDS_DELETE
        462     ROLE_MOD_MODULE_DASHTRENDS_READ
        463     ROLE_MOD_MODULE_DASHTRENDS_UPDATE
        697     ROLE_MOD_MODULE_EMARKETING_CREATE
        700     ROLE_MOD_MODULE_EMARKETING_DELETE
        698     ROLE_MOD_MODULE_EMARKETING_READ
        699     ROLE_MOD_MODULE_EMARKETING_UPDATE
        693     ROLE_MOD_MODULE_GAMIFICATION_CREATE
        696     ROLE_MOD_MODULE_GAMIFICATION_DELETE
        694     ROLE_MOD_MODULE_GAMIFICATION_READ
        695     ROLE_MOD_MODULE_GAMIFICATION_UPDATE
        477     ROLE_MOD_MODULE_GRAPHNVD3_CREATE
        480     ROLE_MOD_MODULE_GRAPHNVD3_DELETE
        478     ROLE_MOD_MODULE_GRAPHNVD3_READ
        479     ROLE_MOD_MODULE_GRAPHNVD3_UPDATE
        481     ROLE_MOD_MODULE_GRIDHTML_CREATE
        484     ROLE_MOD_MODULE_GRIDHTML_DELETE
        482     ROLE_MOD_MODULE_GRIDHTML_READ
        483     ROLE_MOD_MODULE_GRIDHTML_UPDATE
        485     ROLE_MOD_MODULE_GSITEMAP_CREATE
        488     ROLE_MOD_MODULE_GSITEMAP_DELETE
        486     ROLE_MOD_MODULE_GSITEMAP_READ
        487     ROLE_MOD_MODULE_GSITEMAP_UPDATE
        765     ROLE_MOD_MODULE_MOLLIE_CREATE
        768     ROLE_MOD_MODULE_MOLLIE_DELETE
        766     ROLE_MOD_MODULE_MOLLIE_READ
        767     ROLE_MOD_MODULE_MOLLIE_UPDATE
        589     ROLE_MOD_MODULE_PAGESNOTFOUND_CREATE
        592     ROLE_MOD_MODULE_PAGESNOTFOUND_DELETE
        590     ROLE_MOD_MODULE_PAGESNOTFOUND_READ
        591     ROLE_MOD_MODULE_PAGESNOTFOUND_UPDATE
        769     ROLE_MOD_MODULE_PAYLIKEPAYMENT_CREATE
        772     ROLE_MOD_MODULE_PAYLIKEPAYMENT_DELETE
        770     ROLE_MOD_MODULE_PAYLIKEPAYMENT_READ
        771     ROLE_MOD_MODULE_PAYLIKEPAYMENT_UPDATE
        785     ROLE_MOD_MODULE_PAYPAL_CREATE
        788     ROLE_MOD_MODULE_PAYPAL_DELETE
        786     ROLE_MOD_MODULE_PAYPAL_READ
        787     ROLE_MOD_MODULE_PAYPAL_UPDATE
        705     ROLE_MOD_MODULE_PSADDONSCONNECT_CREATE
        708     ROLE_MOD_MODULE_PSADDONSCONNECT_DELETE
        706     ROLE_MOD_MODULE_PSADDONSCONNECT_READ
        707     ROLE_MOD_MODULE_PSADDONSCONNECT_UPDATE
        709     ROLE_MOD_MODULE_PSGDPR_CREATE
        712     ROLE_MOD_MODULE_PSGDPR_DELETE
        710     ROLE_MOD_MODULE_PSGDPR_READ
        711     ROLE_MOD_MODULE_PSGDPR_UPDATE
        489     ROLE_MOD_MODULE_PS_BANNER_CREATE
        492     ROLE_MOD_MODULE_PS_BANNER_DELETE
        490     ROLE_MOD_MODULE_PS_BANNER_READ
        491     ROLE_MOD_MODULE_PS_BANNER_UPDATE
        733     ROLE_MOD_MODULE_PS_BUYBUTTONLITE_CREATE
        736     ROLE_MOD_MODULE_PS_BUYBUTTONLITE_DELETE
        734     ROLE_MOD_MODULE_PS_BUYBUTTONLITE_READ
        735     ROLE_MOD_MODULE_PS_BUYBUTTONLITE_UPDATE
        493     ROLE_MOD_MODULE_PS_CATEGORYTREE_CREATE
        496     ROLE_MOD_MODULE_PS_CATEGORYTREE_DELETE
        494     ROLE_MOD_MODULE_PS_CATEGORYTREE_READ
        495     ROLE_MOD_MODULE_PS_CATEGORYTREE_UPDATE
        741     ROLE_MOD_MODULE_PS_CHECKOUT_CREATE
        744     ROLE_MOD_MODULE_PS_CHECKOUT_DELETE
        742     ROLE_MOD_MODULE_PS_CHECKOUT_READ
        743     ROLE_MOD_MODULE_PS_CHECKOUT_UPDATE
        497     ROLE_MOD_MODULE_PS_CHECKPAYMENT_CREATE
        500     ROLE_MOD_MODULE_PS_CHECKPAYMENT_DELETE
        498     ROLE_MOD_MODULE_PS_CHECKPAYMENT_READ
        499     ROLE_MOD_MODULE_PS_CHECKPAYMENT_UPDATE
        501     ROLE_MOD_MODULE_PS_CONTACTINFO_CREATE
        504     ROLE_MOD_MODULE_PS_CONTACTINFO_DELETE
        502     ROLE_MOD_MODULE_PS_CONTACTINFO_READ
        503     ROLE_MOD_MODULE_PS_CONTACTINFO_UPDATE
        505     ROLE_MOD_MODULE_PS_CURRENCYSELECTOR_CREATE
        508     ROLE_MOD_MODULE_PS_CURRENCYSELECTOR_DELETE
        506     ROLE_MOD_MODULE_PS_CURRENCYSELECTOR_READ
        507     ROLE_MOD_MODULE_PS_CURRENCYSELECTOR_UPDATE
      id_authorization_role     slug
        509     ROLE_MOD_MODULE_PS_CUSTOMERACCOUNTLINKS_CREATE
        512     ROLE_MOD_MODULE_PS_CUSTOMERACCOUNTLINKS_DELETE
        510     ROLE_MOD_MODULE_PS_CUSTOMERACCOUNTLINKS_READ
        511     ROLE_MOD_MODULE_PS_CUSTOMERACCOUNTLINKS_UPDATE
        513     ROLE_MOD_MODULE_PS_CUSTOMERSIGNIN_CREATE
        516     ROLE_MOD_MODULE_PS_CUSTOMERSIGNIN_DELETE
        514     ROLE_MOD_MODULE_PS_CUSTOMERSIGNIN_READ
        515     ROLE_MOD_MODULE_PS_CUSTOMERSIGNIN_UPDATE
        517     ROLE_MOD_MODULE_PS_CUSTOMTEXT_CREATE
        520     ROLE_MOD_MODULE_PS_CUSTOMTEXT_DELETE
        518     ROLE_MOD_MODULE_PS_CUSTOMTEXT_READ
        519     ROLE_MOD_MODULE_PS_CUSTOMTEXT_UPDATE
        521     ROLE_MOD_MODULE_PS_EMAILSUBSCRIPTION_CREATE
        524     ROLE_MOD_MODULE_PS_EMAILSUBSCRIPTION_DELETE
        522     ROLE_MOD_MODULE_PS_EMAILSUBSCRIPTION_READ
        523     ROLE_MOD_MODULE_PS_EMAILSUBSCRIPTION_UPDATE
        525     ROLE_MOD_MODULE_PS_FACETEDSEARCH_CREATE
        528     ROLE_MOD_MODULE_PS_FACETEDSEARCH_DELETE
        526     ROLE_MOD_MODULE_PS_FACETEDSEARCH_READ
        527     ROLE_MOD_MODULE_PS_FACETEDSEARCH_UPDATE
        533     ROLE_MOD_MODULE_PS_IMAGESLIDER_CREATE
        536     ROLE_MOD_MODULE_PS_IMAGESLIDER_DELETE
        534     ROLE_MOD_MODULE_PS_IMAGESLIDER_READ
        535     ROLE_MOD_MODULE_PS_IMAGESLIDER_UPDATE
        537     ROLE_MOD_MODULE_PS_LANGUAGESELECTOR_CREATE
        540     ROLE_MOD_MODULE_PS_LANGUAGESELECTOR_DELETE
        538     ROLE_MOD_MODULE_PS_LANGUAGESELECTOR_READ
        539     ROLE_MOD_MODULE_PS_LANGUAGESELECTOR_UPDATE
        541     ROLE_MOD_MODULE_PS_LINKLIST_CREATE
        544     ROLE_MOD_MODULE_PS_LINKLIST_DELETE
        542     ROLE_MOD_MODULE_PS_LINKLIST_READ
        543     ROLE_MOD_MODULE_PS_LINKLIST_UPDATE
        549     ROLE_MOD_MODULE_PS_MAINMENU_CREATE
        552     ROLE_MOD_MODULE_PS_MAINMENU_DELETE
        550     ROLE_MOD_MODULE_PS_MAINMENU_READ
        551     ROLE_MOD_MODULE_PS_MAINMENU_UPDATE
        721     ROLE_MOD_MODULE_PS_MBO_CREATE
        724     ROLE_MOD_MODULE_PS_MBO_DELETE
        722     ROLE_MOD_MODULE_PS_MBO_READ
        723     ROLE_MOD_MODULE_PS_MBO_UPDATE
        553     ROLE_MOD_MODULE_PS_SEARCHBAR_CREATE
        556     ROLE_MOD_MODULE_PS_SEARCHBAR_DELETE
        554     ROLE_MOD_MODULE_PS_SEARCHBAR_READ
        555     ROLE_MOD_MODULE_PS_SEARCHBAR_UPDATE
        557     ROLE_MOD_MODULE_PS_SHAREBUTTONS_CREATE
        560     ROLE_MOD_MODULE_PS_SHAREBUTTONS_DELETE
        558     ROLE_MOD_MODULE_PS_SHAREBUTTONS_READ
        559     ROLE_MOD_MODULE_PS_SHAREBUTTONS_UPDATE
        561     ROLE_MOD_MODULE_PS_SHOPPINGCART_CREATE
        564     ROLE_MOD_MODULE_PS_SHOPPINGCART_DELETE
        562     ROLE_MOD_MODULE_PS_SHOPPINGCART_READ
        563     ROLE_MOD_MODULE_PS_SHOPPINGCART_UPDATE
        565     ROLE_MOD_MODULE_PS_SOCIALFOLLOW_CREATE
        568     ROLE_MOD_MODULE_PS_SOCIALFOLLOW_DELETE
        566     ROLE_MOD_MODULE_PS_SOCIALFOLLOW_READ
        567     ROLE_MOD_MODULE_PS_SOCIALFOLLOW_UPDATE
        569     ROLE_MOD_MODULE_PS_THEMECUSTO_CREATE
        572     ROLE_MOD_MODULE_PS_THEMECUSTO_DELETE
        570     ROLE_MOD_MODULE_PS_THEMECUSTO_READ
        571     ROLE_MOD_MODULE_PS_THEMECUSTO_UPDATE
        585     ROLE_MOD_MODULE_PS_WIREPAYMENT_CREATE
        588     ROLE_MOD_MODULE_PS_WIREPAYMENT_DELETE
        586     ROLE_MOD_MODULE_PS_WIREPAYMENT_READ
        587     ROLE_MOD_MODULE_PS_WIREPAYMENT_UPDATE
        593     ROLE_MOD_MODULE_SEKEYWORDS_CREATE
        596     ROLE_MOD_MODULE_SEKEYWORDS_DELETE
        594     ROLE_MOD_MODULE_SEKEYWORDS_READ
        595     ROLE_MOD_MODULE_SEKEYWORDS_UPDATE
        597     ROLE_MOD_MODULE_STATSBESTCATEGORIES_CREATE
        600     ROLE_MOD_MODULE_STATSBESTCATEGORIES_DELETE
        598     ROLE_MOD_MODULE_STATSBESTCATEGORIES_READ
        599     ROLE_MOD_MODULE_STATSBESTCATEGORIES_UPDATE
        601     ROLE_MOD_MODULE_STATSBESTCUSTOMERS_CREATE
        604     ROLE_MOD_MODULE_STATSBESTCUSTOMERS_DELETE
        602     ROLE_MOD_MODULE_STATSBESTCUSTOMERS_READ
        603     ROLE_MOD_MODULE_STATSBESTCUSTOMERS_UPDATE
        605     ROLE_MOD_MODULE_STATSBESTPRODUCTS_CREATE
        608     ROLE_MOD_MODULE_STATSBESTPRODUCTS_DELETE
        606     ROLE_MOD_MODULE_STATSBESTPRODUCTS_READ
        607     ROLE_MOD_MODULE_STATSBESTPRODUCTS_UPDATE
        609     ROLE_MOD_MODULE_STATSBESTSUPPLIERS_CREATE
        612     ROLE_MOD_MODULE_STATSBESTSUPPLIERS_DELETE
        610     ROLE_MOD_MODULE_STATSBESTSUPPLIERS_READ
        611     ROLE_MOD_MODULE_STATSBESTSUPPLIERS_UPDATE
        613     ROLE_MOD_MODULE_STATSBESTVOUCHERS_CREATE
        616     ROLE_MOD_MODULE_STATSBESTVOUCHERS_DELETE
        614     ROLE_MOD_MODULE_STATSBESTVOUCHERS_READ
        615     ROLE_MOD_MODULE_STATSBESTVOUCHERS_UPDATE
        617     ROLE_MOD_MODULE_STATSCARRIER_CREATE
        620     ROLE_MOD_MODULE_STATSCARRIER_DELETE
        618     ROLE_MOD_MODULE_STATSCARRIER_READ
        619     ROLE_MOD_MODULE_STATSCARRIER_UPDATE
        621     ROLE_MOD_MODULE_STATSCATALOG_CREATE
        624     ROLE_MOD_MODULE_STATSCATALOG_DELETE
        622     ROLE_MOD_MODULE_STATSCATALOG_READ
        623     ROLE_MOD_MODULE_STATSCATALOG_UPDATE
        625     ROLE_MOD_MODULE_STATSCHECKUP_CREATE
        628     ROLE_MOD_MODULE_STATSCHECKUP_DELETE
        626     ROLE_MOD_MODULE_STATSCHECKUP_READ
        627     ROLE_MOD_MODULE_STATSCHECKUP_UPDATE
      id_authorization_role     slug
        629     ROLE_MOD_MODULE_STATSDATA_CREATE
        632     ROLE_MOD_MODULE_STATSDATA_DELETE
        630     ROLE_MOD_MODULE_STATSDATA_READ
        631     ROLE_MOD_MODULE_STATSDATA_UPDATE
        633     ROLE_MOD_MODULE_STATSEQUIPMENT_CREATE
        636     ROLE_MOD_MODULE_STATSEQUIPMENT_DELETE
        634     ROLE_MOD_MODULE_STATSEQUIPMENT_READ
        635     ROLE_MOD_MODULE_STATSEQUIPMENT_UPDATE
        637     ROLE_MOD_MODULE_STATSFORECAST_CREATE
        640     ROLE_MOD_MODULE_STATSFORECAST_DELETE
        638     ROLE_MOD_MODULE_STATSFORECAST_READ
        639     ROLE_MOD_MODULE_STATSFORECAST_UPDATE
        641     ROLE_MOD_MODULE_STATSLIVE_CREATE
        644     ROLE_MOD_MODULE_STATSLIVE_DELETE
        642     ROLE_MOD_MODULE_STATSLIVE_READ
        643     ROLE_MOD_MODULE_STATSLIVE_UPDATE
        645     ROLE_MOD_MODULE_STATSNEWSLETTER_CREATE
        648     ROLE_MOD_MODULE_STATSNEWSLETTER_DELETE
        646     ROLE_MOD_MODULE_STATSNEWSLETTER_READ
        647     ROLE_MOD_MODULE_STATSNEWSLETTER_UPDATE
        649     ROLE_MOD_MODULE_STATSORIGIN_CREATE
        652     ROLE_MOD_MODULE_STATSORIGIN_DELETE
        650     ROLE_MOD_MODULE_STATSORIGIN_READ
        651     ROLE_MOD_MODULE_STATSORIGIN_UPDATE
        653     ROLE_MOD_MODULE_STATSPERSONALINFOS_CREATE
        656     ROLE_MOD_MODULE_STATSPERSONALINFOS_DELETE
        654     ROLE_MOD_MODULE_STATSPERSONALINFOS_READ
        655     ROLE_MOD_MODULE_STATSPERSONALINFOS_UPDATE
        657     ROLE_MOD_MODULE_STATSPRODUCT_CREATE
        660     ROLE_MOD_MODULE_STATSPRODUCT_DELETE
        658     ROLE_MOD_MODULE_STATSPRODUCT_READ
        659     ROLE_MOD_MODULE_STATSPRODUCT_UPDATE
        661     ROLE_MOD_MODULE_STATSREGISTRATIONS_CREATE
        664     ROLE_MOD_MODULE_STATSREGISTRATIONS_DELETE
        662     ROLE_MOD_MODULE_STATSREGISTRATIONS_READ
        663     ROLE_MOD_MODULE_STATSREGISTRATIONS_UPDATE
        665     ROLE_MOD_MODULE_STATSSALES_CREATE
        668     ROLE_MOD_MODULE_STATSSALES_DELETE
        666     ROLE_MOD_MODULE_STATSSALES_READ
        667     ROLE_MOD_MODULE_STATSSALES_UPDATE
        669     ROLE_MOD_MODULE_STATSSEARCH_CREATE
        672     ROLE_MOD_MODULE_STATSSEARCH_DELETE
        670     ROLE_MOD_MODULE_STATSSEARCH_READ
        671     ROLE_MOD_MODULE_STATSSEARCH_UPDATE
        673     ROLE_MOD_MODULE_STATSSTOCK_CREATE
        676     ROLE_MOD_MODULE_STATSSTOCK_DELETE
        674     ROLE_MOD_MODULE_STATSSTOCK_READ
        675     ROLE_MOD_MODULE_STATSSTOCK_UPDATE
        677     ROLE_MOD_MODULE_STATSVISITS_CREATE
        680     ROLE_MOD_MODULE_STATSVISITS_DELETE
        678     ROLE_MOD_MODULE_STATSVISITS_READ
        679     ROLE_MOD_MODULE_STATSVISITS_UPDATE
        761     ROLE_MOD_MODULE_SYSTEMPAY_CREATE
        764     ROLE_MOD_MODULE_SYSTEMPAY_DELETE
        762     ROLE_MOD_MODULE_SYSTEMPAY_READ
        763     ROLE_MOD_MODULE_SYSTEMPAY_UPDATE
        681     ROLE_MOD_MODULE_WELCOME_CREATE
        684     ROLE_MOD_MODULE_WELCOME_DELETE
        682     ROLE_MOD_MODULE_WELCOME_READ
        683     ROLE_MOD_MODULE_WELCOME_UPDATE

Link to comment
Share on other sites

But I didn't try to modify any module. The module did not appear on the front end and after trying for several days to understand why, I deactivated it. Then I uninstalled the deactivated module. Then I tried to reinstall using the latest version of the same module. It is the re-installation attempt that returns the alert "you are not authorised to deactivate...". Despite this alert, the new module folder is uploaded to the /modules/ folder but does not appear in Module manager Backoffice so a full installation is impossible. I even tried manually adding the module fields in the DB but it still does not appear anywhere, so any config is impossible. The table ps_access has 716 entries corresponding to the entries in the ps_authorization_role table but as no entry in the ps_authorization_role  table corresponds to this module (see previous post) then where should I look?

Link to comment
Share on other sites

Thanks for this, I appreaciate.

I have been through every table in DB ps_module_xxx including the ps_module table (see below) which does not include the vivawallet module.

I am very happy to add something "by hand", but what and where?

I have been designing websites for over 25 years (yes) and working with Prestashop for at least 5 or 6 years, this is the first time I have gone through an nightmare like this. And this is really one of the first times I really do not understand what is going on. All I can think of is that the Vivawallet module has some special hidden security measures built in somewhere which requires it to be deactivated and re-installed in a special way?? Or, more likely, there is a real bug (this is a clean new PS install on recent updated server with other working PS sites also hosted).

 

Once again suggestions welcome

NC

Link to comment
Share on other sites

  • 1 month later...
  • 1 month later...
  • 4 months later...

I just had the same problem with my own module. After hours of debugging I discovered it was a problem in my

public function install()

function. I had a

Db::getInstance()->execute

with some bugged SQL query ("NUT NULL" instead of "NOT NULL") and that was triggering that meaningless "You are not allowed to disable the module".

I hope it helps someone (although debugging such issues is a pain).

Link to comment
Share on other sites

  • 1 month later...
  • 3 months later...

Same problem with VivaWallet here.

I don't know why (I am a newbie with PS - maybe the problem is that the module uses the table "vivawallet_data" without the prefix?) but the error raises due to the install.sql file. To solve:

NOTE: if you tried without success to install the module adding manually the rows in the ps_authorization_role and ps_access tables, remove that lines and follow these steps.

1) execute the install query from the "install.sql" by hand (for example through PhpMyAdmin)
2) comment the rows from 72 to 78

		/*
		if (!file_exists(dirname(__FILE__).'/'.self::INSTALL_SQL_FILE))
			die('error 1');
		elseif (!$sql = file_get_contents(dirname(__FILE__).'/'.self::INSTALL_SQL_FILE))
			die('error 2');
		$sql = preg_split("/;\s*[\r\n]+/", $sql);
		foreach ($sql as $query)
			if ($query AND sizeof($query) AND !Db::getInstance()->Execute(trim($query)))
				return false;
		*/

3) re-pack the module and upload/install it as usual

Link to comment
Share on other sites

  • 4 months later...

Same problem here.

First, make sure that you have no errors in your SQL scripts in:
modules/
yourmodulename/sql/install.php.
modules/yourmodulename/upgrade/upgrade-x-x-x.php
in most cases this will be the problem.

My problem was caused by removing the module manually. Basically I removed record from ps_module tabel manually and then removed the folder from modules catalog. Its seems that there is more references to this module in our database which might cause an issue.

To investigate the issue check if you have any left over after non existing's module installation in your database table.

SELECT ms.id_module as "ps_module_shop id_module" , m.id_module as "module id_module" FROM ps_module as m
RIGHT JOIN ps_module_shop as ms ON m.id_module = ms.id_module
WHERE m.id_module IS NULL;

DELETE LAFTOVERS FROM ALL TABLES: 

DELETE FROM ps_module_shop 
WHERE id_module 
IN (
  SELECT ms.id_module as "ms id" , m.id_module as "m id" 
  FROM ps_module as m
  RIGHT JOIN ps_module_shop as ms 
  ON m.id_module = ms.id_module
  WHERE m.id_module IS NULL;
);

* The above sql will find all modules that does not exists in ps_module table but do exist in ps_module_shop table and removes them.

--------------------------------------

Now go to ps_hook_module table and remove the record in similar way. So run:

SELECT hm.id_module as "hm id" , m.id_module as "m id" FROM ps_module as m
RIGHT JOIN ps_hook_module as hm ON m.id_module = hm.id_module
WHERE m.id_module IS NULL;

-- DELETE FROM ps_hook_module WHERE id_module IN (SELECT ...);

---------------------------------------

We could do the same for ps_module_history table

SELECT mh.id_module as "mh id" , m.id_module as "m id" FROM ps_module as m
RIGHT JOIN ps_module_history as mh ON m.id_module = mh .id_module
WHERE m.id_module IS NULL;

-- DELETE FROM ps_module_history WHERE id_module IN (SELECT ...);

---------------------------------------

NOTE - If you remove module manually and try to reinstall it you might need to do this:

You should also see if there are any roles remained for you plugin name in ps_authorization_role table. My module name was "DEVWLH1" so this is what I search for. See the fallowing example:

SELECT * FROM `ps_authorization_role` WHERE slug LIKE "%DEVWLH1%";

* Just make sure to replace LIKE ... with your actual module name "%yourmodulname%";
*IMPORTNT! - Make a note of the IDs you will return (write them down before deleting them - you will need to know them in another table);

Then go to ps_module_access table and search for rows base on your previous findings from id_authorization_role table.
 image.thumb.png.458fa6e3d4cebd08a6ff4051f1a49bc3.png

 

Now you can delete them from ps_module_access table, and then do the same in ps_authorization_role table.

Edited by DevWL (see edit history)
  • Like 1
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...