search

mageprince / magento2-FAQ

This module adds an easy way to use FAQ Section to your Magento store with jQuery Accordion. In this module, admin can add and update FAQ. Admin can also create FAQ group with group icon.
57 stars 37 forks source link

magento2.prince_faqgroup' doesn't exist #37

Closed Pastrone closed 4 years ago

Pastrone commented 4 years ago

Table 'magento2.prince_faqgroup' doesn't exist, query was: SELECT COUNT(*) FROM prince_faqgroup AS main_table

I installed it manually today (magento 2.3.5-p1) and I have this error on ManageFAQ and ManageFAQGroup.

On ManageFAQ it gets:

There has been an error processing your request Exception printing is disabled by default for security reasons.

Error log record number: f41e8f6d4cab93c9c328f9e0ae351ef82b9e170f5cfe57dd8e4d4845282baeaa

What am I missing ?

Any ideas?

Pastrone commented 4 years ago

I answer to myself as maybe somebody will be in the same position as I was.

On first install, because of writing module name into setup_module table, after this first attempt to install (failed), later attempts will not execute the script to create DB tables prince_faq & prince_faqgroup.

To recreate a correct install proceed as follow:

  1. Remove the module entry from setup_module table (delete from setup_module where module ='Mageprince_Faq';) or by using phpmyadmin

  2. Execute following commands: php bin/magento setup:db-schema:upgrade php bin/magento setup:di:compile php bin/magento cache:clean

  3. In app/core create folder Mageprince and in Mageprince the folder Faq and copy the content of archive.zip in Mageprince/Faq

  4. Execute following commands: php bin/magento module:enable Mageprince_Faq php bin/magento setup:upgrade

  5. If there is something to deploy: php bin/magento setup:static-content:deploy ( you can add also -f option at the end)

  6. Change the owner recursively of you root Magento2 folder to mathe the user and group of your www server.

  7. Be happy