tripleaconsult
Forum Replies Created
-
Has this been fixed in the meantime?
Because I keep receiving messages from my hoster and also on this site I keep seeing this message: Broken Access Control in WordPress Salon booking system Plugin – PatchstackI managed to fix this myself, by adding this index on the user_meta table
ALTER TABLE wp_usermeta
ADD INDEX idx_userid_metakey (user_id, meta_key);
Did some further digging and found that the query launched to retrieve the customers throws an error in the database. More specifically it throws:
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okayWhen I set the SQL_BIG_SELECTS = 1 it no longer throws errors and returns results. Is there a limit on the number of customers? And are all the joins needed to retrieve the customer list? The site has +400 customers
Does anyone have pointers on how I can fix this. I start to think there is data corruption, but I have analysed the records without finding anything strange.
Some additional input:
I use a customprefix in the site (www) and a call to https://mysite/wp-admin/admin-ajax.php?lang=en&action=salon&method=SearchUser&security=4d9f8fd269&s=rita%20 returns {“success”:0,”errors”:[“User not found”]} even though there are 4 users with that name. There seem to be no corrupt records in the user and usermeta tables
So the search and default customer overview return no values, but when I click the sort button on the e-mailaddress the list does return.Is there anything else I can check to help solve this problem? I deleted and reinstalled the plugin (now on version 10.30.20) but the problem persists
Forum: Plugins
In reply to: [Salon Booking System - Free Version] 500 error on saving settingsThe error only occurs when saving any of the settings within the booking module. I also get the same error when editing a customer of service.
I disabled your plugin and made a small change on the general settings of the site and that went flawless. Does the fact that the above message refers to the customers, be pointing to a problem with any of the customers information?
The site is running on PHP 8.0, I have the option to upgrade to a more recent version (8.3). Is that an option?
- This reply was modified 1 year, 11 months ago by tripleaconsult.
- This reply was modified 1 year, 11 months ago by tripleaconsult.
- This reply was modified 1 year, 11 months ago by tripleaconsult.
Forum: Plugins
In reply to: [Salon Booking System - Free Version] 500 error on saving settingsWhen I turn on show php errors, I get the below message. But I can’t figure out what is causing this my guess would be, something with the customers):
Fatal error: Uncaught TypeError: strlen(): Argument #1 ($str) must be of type string, array given in /customers/5/f/4/domain.com/httpd.www/wp-includes/blocks/site-tagline/.fbc9fb06.css(107)
: eval()’d code:4 Stack trace: #0 /customers/5/f/4/domain.com/httpd.www/wp-includes/blocks/site-tagline/.fbc9fb06.css(107)
: eval()’d code(4): ttrhwtn(Array) #1 /customers/5/f/4/domain.com/httpd.www/wp-includes/blocks/site-tagline/.fbc9fb06.css(107)
: eval() #2 /customers/5/f/4/domain.com/httpd.www/wp-config.php(6): include_once(‘/customers/5/f/…’) 3 /customers/5/f/4/domain.com/httpd.www/wp-load.php(50): require_once(‘/customers/5/f/…’) 4 /customers/5/f/4/domain.com/httpd.www/wp-admin/admin.php(34): require_once(‘/customers/5/f/…’) 5 {main} thrown in /customers/5/f/4/domain.com/httpd.www/wp-includes/blocks/site-tagline/.fbc9fb06.css(107) : eval()’d code on line 4