Whether plugins supports MultiSite Install

Hello @w4cdev

WP ERP supports single or subsites only in a multisite network but not in the network mode. However, we are working to make it multisite compatible and we’ll use this error as a reference.

Thanks

So we have removed it from network of the multisite, as it only works in the main site by default. Although the subsite it is installed it effects on the rest of the subsites with ‘Critical Error Report’

Now we have installed on Multi Site, but activated on the subsite (not on main site)
Based on the below if the subsite are returning critical error, this does not works for us.
If not then atleast it should work on the on the other subsite [Task2] but not on main site. But the task2 returns error report below it. We don’t want to activate the erp on main site ‘site.com’ but on ‘sub1.site.com’ or ‘sub2.site.com’ if not on multiple site

Site id = 1 Main
Site id = 2 sub2site

Task 1
——-
site.com (Network site) [Installed on MultiSite]
site.com [Main Site] [Not Activate]
sub1.site.com [Activated] Breaks with Critical Error on Subsite
sub2.site.com [Not Activated] Breaks with Critical Error on Subsite
sub3.site.com [Not Activated] Breaks with Critical Error on Subsite
sub4.site.com [Activated] Breaks with Critical Error on Subsite

Task 2
——-
site.com (Network site) [Installed on MultiSite]
site.com [Main Site] [Activated] Works Fine
sub1.site.com [Activated] DashBoard work Critical Error on entry
sub2.site.com [Not Activated] Breaks with Critical Error on Subsite
sub3.site.com [Not Activated] Breaks with Critical Error on Subsite
sub4.site.com [Activated] Breaks with Critical Error on Subsite

Reported error we get:

[19-Nov-2020 18:55:17 UTC] WordPress database error Table ‘agestabc_wpunorg.wporg_2_usermeta’ doesn’t exist for query select wporg_2_erp_hr_employees.user_id, display_name from wporg_2_erp_hr_employees left join wporg_users on wporg_2_erp_hr_employees.user_id = wporg_users.ID left join wporg_2_usermeta as gender on wporg_2_erp_hr_employees.user_id = gender.user_id and gender.meta_key = ‘gender’ left join wporg_2_usermeta as marital_status on wporg_2_erp_hr_employees.user_id = marital_status.user_id and marital_status.meta_key = ‘marital_status’ where status = ‘active’ and wporg_2_erp_hr_employees.deleted_at is null order by hiring_date desc limit 20 offset 0 made by do_action(‘wp-erp_page_erp-hr’), WP_Hook->do_action, WP_Hook->apply_filters, WeDevs\ERP\HRM\Admin\Admin_Menu->router, call_user_func, WeDevs\ERP\HRM\Admin\Admin_Menu->employee_page, include(‘/plugins/erp/modules/hrm/views/employee.php’), WeDevs\ERP\HRM\Employee_List_Table->prepare_items, erp_hr_get_employees, Illuminate\Database\Eloquent\Builder->get, Illuminate\Database\Eloquent\Builder->getModels, Illuminate\Database\Query\Builder->get, Illuminate\Database\Query\Builder->runSelect, WeDevs\ORM\Eloquent\Database->select
[19-Nov-2020 18:55:17 UTC] PHP Fatal error: Uncaught Exception: Table ‘agestabc_wpunorg.wporg_2_usermeta’ doesn’t exist in /home/agestabc/public_html/unitionorg/wp-content/plugins/erp/vendor/tareq1988/wp-eloquent/src/Eloquent/Database.php:150
Stack trace:
#0 /user/wp-content/plugins/erp/vendor/illuminate/database/Query/Builder.php(1705): WeDevs\ORM\Eloquent\Database->select(‘select `wporg_2…’, Array, true)
#1 /user/wp-content/plugins/erp/vendor/illuminate/database/Query/Builder.php(1690): Illuminate\Database\Query\Builder->runSelect()
#2 /user/wp-content/plugins/erp/vendor/illuminate/database/Eloquent/Builder.php(462): Illuminate\Database\Query\Builder->get(Array)
#3 /user/wp-content/plugins/erp/vendor/illuminate/database/Eloquent/Builder.php(446): Illuminate\Database\Eloquent\Builder->getModels(Array)
#4 /user/wp-content/plugins/erp/modules/hrm/includes/functions-employee.php(147): Illuminate in /home/agestabc/public_html/unitionorg/wp-content/plugins/erp/vendor/tareq1988/wp-eloquent/src/Eloquent/Database.php on line 150
[19-Nov-2020 18:55:24 UTC] WordPress database error Table ‘root_wpunorg.wporg_2_sentry_groups’ doesn’t exist for query SELECT * FROM wporg_2_sentry_groups WHERE FIND_IN_SET(‘1’, member_list) made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array(‘posts_where’), WP_Hook->apply_filters, wp_sentry->query_mod
[19-Nov-2020 18:55:36 UTC] WordPress database error Table ‘root_wpunorg.wporg_2_sentry_groups’ doesn’t exist for query SELECT * FROM wporg_2_sentry_groups WHERE FIND_IN_SET(‘1’, member_list) made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array(‘posts_where’), WP_Hook->apply_filters, wp_sentry->query_mod

WE have tried once again with the clean install of WP and did the same process. But this time installed on Network Site and directly activated on sub1.site.com and not on site.com (mainsite), but the error rec’d is same

( ! ) Fatal error: Uncaught Exception: Table ‘agestabc_wpw4co.w4co3_usermeta’ doesn’t exist in /home/agestabc/public_html/page/concern/w4co/wp-content/plugins/wedevs-project-manager/vendor/tareq1988/wp-eloquent/src/Eloquent/Database.php on line 150

Another error just below it:

( ! ) Illuminate\Database\QueryException: Table ‘agestabc_wpw4co.w4co3_usermeta’ doesn’t exist (SQL: select w4co3_erp_hr_employees.user_id, display_name from w4co3_erp_hr_employees left join w4cousers on w4co3_erp_hr_employees.user_id = w4cousers.ID left join w4co3_usermeta as gender on w4co3_erp_hr_employees.user_id = gender.user_id and gender.meta_key = ‘gender’ left join w4co3_usermeta as marital_status on w4co3_erp_hr_employees.user_id = marital_status.user_id and marital_status.meta_key = ‘marital_status’ where status = ‘active’ and w4co3_erp_hr_employees.deleted_at is null order by hiring_date desc limit 20 offset 0) in /home/agestabc/public_html/page/concern/w4co/wp-content/plugins/wedevs-project-manager/vendor/tareq1988/wp-eloquent/src/Eloquent/Database.php on line 150

Please avoid multi-sites for now until we officially support it.

Thanks

You mean to say we need to forget the erp on the MultiSite

OR

Use of one subsite on the Multi Site

Hello @w4cdev

Yes, please use on the single site only until we officially support multisite. Also, as being open-sourced plugin, you can contribute/help to make WP ERP compatible with multisite. The codebase is open here: https://github.com/wp-erp/wp-erp

Thank you ??