Fatal error on multisite

Front Page Forums HRM Fatal error on multisite

Viewing 4 reply threads
  • Author
    • #75039

      I’ve been facing this error when clicking on HR – Employees on any subsites on a WP multisite install the main site works fine.

      I’ve only set this up in a local environment for testing and tried a number of different ways to troubleshoot it and check for any other known issues online.

      The WeDev plugins are not network activated and each subsite has to activate the plugin,
      all site permalinks are set to %postname%,
      up to date WordPress
      PHP 7.4.1
      MySQL 8.0.16
      Nginx webserver

      Other installed plugins are
      Advanced Custom Fields PRO
      Advanced Custom Fields: Font Awesome
      Ajax Load More
      Breadcrumb NavXT
      Contact Form 7

      I’ve tried uninstalling, reinstalling deleting all the created tables, and still getting the same error any help would be appreciated.

      ( ! ) Fatal error: Uncaught Exception: Table ‘local.wp_2_usermeta’ doesn’t exist in /Users/adam/Local Sites/buildingblocks/app/public/wp-content/plugins/wedevs-project-manager/vendor/tareq1988/wp-eloquent/src/Eloquent/Database.php on line 150
      ( ! ) Illuminate\Database\QueryException: Table ‘local.wp_2_usermeta’ doesn’t exist (SQL: select wp_2_erp_hr_employees.user_id, display_name from wp_2_erp_hr_employees left join wp_users on wp_2_erp_hr_employees.user_id = wp_users.ID left join wp_2_usermeta as gender on wp_2_erp_hr_employees.user_id = gender.user_id and gender.meta_key = ‘gender’ left join wp_2_usermeta as marital_status on wp_2_erp_hr_employees.user_id = marital_status.user_id and marital_status.meta_key = ‘marital_status’ where status = ‘active’ and wp_2_erp_hr_employees.deleted_at is null order by hiring_date desc limit 20 offset 0) in /Users/adam/Local Sites/buildingblocks/app/public/wp-content/plugins/wedevs-project-manager/vendor/tareq1988/wp-eloquent/src/Eloquent/Database.php on line 150

    • #75040
      Mehedi Hasan


      WPERP doesn’t support multisite in the network mode. You need to either use it on the single sites or a subsite only in the multisite but not under the network mode.


    • #75041

      Thanks for the reply, unless I’m confused about what you’re calling network mode. The plugins are not network activated but installed at a network level and each subsite you would go to plugins > activate to install WPERP all other functionality works fine from what I can see at this stage apart from HR.

    • #76047

      yup, getting the exact same error here too. and it’s specifically happening on the “add employee” page. so not able to add any employees to anything.

    • #76125

      is this due to the user tables in multisite being globally shared? i mean it’s looking of a specific instance of the usermeta table….like it’s part of the multisite table structure. when the usermeta is not. it’s a globally shared table.

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

Contact Us

Reach out to us for any inquiry

You must enter full name
You must enter email
You must enter message

We received your message

We will reach you with your email address soon. Thank you for the time!