Front Page › Forums › HRM › Fatal error on multisite
- This topic has 4 replies, 3 voices, and was last updated 4 years, 6 months ago by jjlast.
-
AuthorPosts
-
-
June 16, 2020 at 11:46 am #75039ajm22Participant
Hi,
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 webserverOther installed plugins are
Advanced Custom Fields PRO
Advanced Custom Fields: Font Awesome
Ajax Load More
Breadcrumb NavXT
Contact Form 7I’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: selectwp_2_erp_hr_employees
.user_id
,display_name
fromwp_2_erp_hr_employees
left joinwp_users
onwp_2_erp_hr_employees
.user_id
=wp_users
.ID
left joinwp_2_usermeta
asgender
onwp_2_erp_hr_employees
.user_id
=gender
.user_id
andgender
.meta_key
= ‘gender’ left joinwp_2_usermeta
asmarital_status
onwp_2_erp_hr_employees
.user_id
=marital_status
.user_id
andmarital_status
.meta_key
= ‘marital_status’ wherestatus
= ‘active’ andwp_2_erp_hr_employees
.deleted_at
is null order byhiring_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 -
June 16, 2020 at 11:52 am #75040Mehedi HasanMember
Hello
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.
Thanks
-
June 16, 2020 at 12:16 pm #75041ajm22Participant
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.
-
July 3, 2020 at 7:28 am #76047jjlastParticipant
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.
-
July 5, 2020 at 1:24 am #76125jjlastParticipant
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.
-
-
AuthorPosts
- You must be logged in to reply to this topic.