Error with installing and activating WPERP

Home Forums General Error with installing and activating WPERP

Tagged: 

Viewing 5 reply threads
  • Author
    Posts
    • #79195
      Ghaith
      Participant

      Hello dears,
      I have just downloaded and installed a fresh version of xampp (php 7.2) and wordpress 5.5
      admin dashboard worked fine until I installed WP ERP plugin and tried to activate it
      the error reads:
      Fatal error: Uncaught Exception: Table ‘wperp.wp_erp_peoples’ doesn’t exist in C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\tareq1988\wp-eloquent\src\Eloquent\Database.php:150 Stack trace: #0 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Query\Builder.php(1705): WeDevs\ORM\Eloquent\Database->select(‘select * from `…’, Array, true) #1 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Query\Builder.php(1690): Illuminate\Database\Query\Builder->runSelect() #2 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Eloquent\Builder.php(462): Illuminate\Database\Query\Builder->get(Array) #3 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Eloquent\Builder.php(446): Illuminate\Database\Eloquent\Builder->getModels(Array) #4 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Concerns\BuildsQueries.php(75): Illuminate\Database\Eloquent\Builder->get(Array) #5 C:\xampp\htdocs\wordpress\wp-conte in C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\tareq1988\wp-eloquent\src\Eloquent\Database.php on line 150
      There has been a critical error on your website. Please check your site admin email inbox for instructions.

    • #79264
      Mehedi Hasan
      Moderator

      Hello,

      The error indicates somehow a required database table is missing while you have installed WP ERP. In this type of cases, installing WP ERP again by deactivating it solves the problem.

      Would you please try that and let us know? If that doesn’t help, then we’ll require to create the table manually on your database. Contact our support for the further help.

      Thanks

    • #79400
      Ghaith
      Participant

      Thanks a lot for your support,
      I checked that first of all, it didn’t work.
      I also thought of creating the table myself, but i couldn’t find its structure.
      would you please share that with me? and could it be of help to try to install a previous version?

    • #79483
      tobyg
      Participant

      HI there,

      I am getting the exact same issue as Ghaith. Is it a PHP version issue. I installed the plugin on a different site as a test running PHP v7.4.9 and works fine, but when I installed it on another site running PHP version 7.1.33 I get the exact same error above.

      I have uninstalled – re-installed and deactivated as suggestions above, with no luck!

      Do you have any feed back or a solution to this issue??

      Thank you in advance

    • #79572
      Ghaith
      Participant

      Hello again,
      I have just updated the plugin to 1.6.4, last version was 1.6.3.
      I was hoping this issue was fixed but now another one came up and I still don’t know whether this one was resolved or not.

      Anyway, the issue now is with another table “hr_dept”, same mistake which is that the table is missing. Can you please help us with this?

    • #79573
      Ghaith
      Participant

      Hello again second time 🙂
      I tried installing an old version 1.5.15, it works but database seems to be missing all tables from wp erp plugin, I noticed that the tables’ names are wp_erp_something (ex. wp_erp_hr_employees) but my db doesn’t contain any table that matches that even after installing and activating the plugin.
      the plugin doesn’t work with full features, HR and Accounting modules’ pages give similar error:

      HR Management

      Fatal error: Uncaught Exception: Table ‘wperp.wp_erp_hr_employees’ doesn’t exist in C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\tareq1988\wp-eloquent\src\Eloquent\Database.php:150 Stack trace: #0 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Query\Builder.php(1705): WeDevs\ORM\Eloquent\Database->select(‘select count(*)…’, Array, true) #1 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Query\Builder.php(1690): Illuminate\Database\Query\Builder->runSelect() #2 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Query\Builder.php(2025): Illuminate\Database\Query\Builder->get(Array) #3 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Query\Builder.php(1953): Illuminate\Database\Query\Builder->aggregate(‘count’, Array) #4 C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\illuminate\database\Eloquent\Builder.php(1251): Illuminate\Database\Query\Builder->count() #5 C:\xampp\htdocs\wordpress\wp-content\ in C:\xampp\htdocs\wordpress\wp-content\plugins\erp\vendor\tareq1988\wp-eloquent\src\Eloquent\Database.php on line 150
      There has been a critical error on your website. Please check your site admin email inbox for instructions.

      but other pages open up just fine.

      Thanks for your help

Viewing 5 reply threads
  • You must be logged in to reply to this topic.