June 16, 2020 at 11:46 am #75039ajm22Participant
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
Other installed plugins are
Advanced Custom Fields PRO
Advanced Custom Fields: Font Awesome
Ajax Load More
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
meta_key= ‘gender’ left join
meta_key= ‘marital_status’ where
status= ‘active’ and
deleted_atis null order by
hiring_datedesc 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 #75040JayParticipant
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.
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.
June 13, 2022 at 8:40 am #108056InterpolatParticipant
Was this ever resolved for either of you guys? Would appreciate pointers on how to resolve as I facing similar issue now.
- You must be logged in to reply to this topic.