Fatal error on multisite

This topic has 14 replies, 7 voices, and was last updated 2 years, 10 months ago by Md. Yeasin Arafat Mamun.

Viewing 14 reply threads

Author

Posts
- June 16, 2020 at 11:46 am #75039
  
  ajm22
  Participant
  
  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 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
- June 16, 2020 at 11:52 am #75040
  
  Jay
  Participant
  
  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 #75041
  
  ajm22
  Participant
  
  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 #76047
  
  jjlast
  Participant
  
  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 #76125
  
  jjlast
  Participant
  
  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 #108056
  
  Interpolat
  Participant
  
  Was this ever resolved for either of you guys? Would appreciate pointers on how to resolve as I facing similar issue now.
- July 21, 2022 at 3:37 am #109272
  
  damiencal
  Participant
  
  Same issue here..
  
  Uncaught Exception: Table ‘itx_wpb.wpkc7f_7_usermeta’ doesn’t exist
  
  The table does exist but at itx_wpb.wpkc7f_usermeta
  
  Any quick solutions?
- September 29, 2022 at 9:27 am #111319
  
  Tanvir Chowdhury
  Participant
  
  Hello @damiencal @interpolat
  After the updates of WP ERP v1.11.1, this issue is not happening on my end.
  If you are still facing the issue, contact the support team so they can help you out.
  
  Thanks
- January 4, 2023 at 4:19 pm #114899
  
  Md. Yeasin Arafat Mamun
  Keymaster
  
  Hello there,
  
  I hope you are doing well.
  As this topic does not have any updates from September 29, 2022 at 9:27 am, I am going to close this topic now.
  Please feel free to contact us directly-> https://wperp.com/contact/ so that we can help you soon.
  
  Thanks,
- January 4, 2023 at 4:19 pm #114900
  
  Md. Yeasin Arafat Mamun
  Keymaster
  
  Hello there,
  
  I hope you are doing well.
  As this topic does not have any updates from September 29, 2022 at 9:27 am, I am going to close this topic now.
  Please feel free to contact us directly-> https://wperp.com/contact/ so that we can help you soon.
  
  Thanks,
- January 4, 2023 at 4:19 pm #114901
  
  Md. Yeasin Arafat Mamun
  Keymaster
  
  Hello there,
  
  I hope you are doing well.
  As this topic does not have any updates from September 29, 2022 at 9:27 am, I am going to close this topic now.
  Please feel free to contact us directly-> https://wperp.com/contact/ so that we can help you soon.
  
  Thanks,
- January 4, 2023 at 4:19 pm #114902
  
  Md. Yeasin Arafat Mamun
  Keymaster
  
  Hello there,
  
  I hope you are doing well.
  As this topic does not have any updates from September 29, 2022 at 9:27 am, I am going to close this topic now.
  Please feel free to contact us directly-> https://wperp.com/contact/ so that we can help you soon.
  
  Thanks,
- January 4, 2023 at 4:19 pm #114903
  
  Md. Yeasin Arafat Mamun
  Keymaster
  
  Hello there,
  
  I hope you are doing well.
  As this topic does not have any updates from September 29, 2022 at 9:27 am, I am going to close this topic now.
  Please feel free to contact us directly-> https://wperp.com/contact/ so that we can help you soon.
  
  Thanks,
- January 4, 2023 at 4:19 pm #114904
  
  Md. Yeasin Arafat Mamun
  Keymaster
  
  Hello there,
  
  I hope you are doing well.
  As this topic does not have any updates from September 29, 2022 at 9:27 am, I am going to close this topic now.
  Please feel free to contact us directly-> https://wperp.com/contact/ so that we can help you soon.
  
  Thanks,
- January 4, 2023 at 4:20 pm #114905
  
  Md. Yeasin Arafat Mamun
  Keymaster
  
  Hello there,
  
  I hope you are doing well.
  As this topic does not have any updates from September 29, 2022 at 9:27 am, I am going to close this topic now.
  Please feel free to contact us directly-> https://wperp.com/contact/ so that we can help you soon.
  
  Thanks,
Author

Posts