There are a bunch of updates I need to do, but since we’re no longer using this at work, I am no longer able to maintain or update things at work, so I am trying to get ownership of the source and will update things soon in my free time.
Please try the latest update.
I’ll check it out!
If I create an event on the backend of wordpress I still get an error–“mysql error”. I checked my debug log in wp-content and see these errors
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 556
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 564
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 556
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 564
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
[27-Jul-2022 18:04:02 UTC] PHP Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
With debug mode turned on I see this:
WordPress database error: [Unknown column 'ev_regContactType' in 'field list']
INSERT INTO <code>wp_dyyaha3nq9_bookaroom_reservations</code> ( <code>res_created</code>, <code>ev_desc</code>, <code>ev_maxReg</code>, <code>ev_amenity</code>, <code>ev_waitingList</code>, <code>ev_presenter</code>, <code>ev_privateNotes</code>, <code>ev_publicEmail</code>, <code>ev_publicName</code>, <code>ev_publicPhone</code>, <code>ev_noPublish</code>, <code>ev_regStartDate</code>, <code>ev_regType</code>, <code>ev_submitter</code>, <code>ev_title</code>, <code>ev_website</code>, <code>ev_webText</code>, <code>ev_regContactType</code> ) VALUES( '2022-07-27 14:18:44', 'test', '', '', '', '', '', '', '', '', '0', '', 'no', 'Jack', 'test', '', '', '' )
Mysql Error
Try the latest update, please?
Darn now, I get a critical error and crash the entire site. Had to go back in disable the plugin. Tried to activate it again and again crashed the site.
version 2.8.5
-
This reply was modified 2 years, 5 months ago by
happygojira.
If you’re using PHP8, I just updated things for it. If not, let me know if there’s any more info or if you can turn on WP DEBUG and get me an error?
I’ll turn on debug and see what I get.
php 7.4
mysql 5.7
WordPress database error: [Duplicate column name 'ev_regContactType']
ALTER TABLE wp_dyyaha3nq9_bookaroom_reservations ADD <code>ev_regContactType</code> enum('both','phone','either','none','email') CHARACTER SET latin1 DEFAULT 'either';
WordPress database error: [Duplicate column name 'ev_regContactType']
ALTER TABLE wp_dyyaha3nq9_bookaroom_reservations_deleted ADD <code>ev_regContactType</code> enum('both','phone','either','none','email') CHARACTER SET latin1 DEFAULT 'either';
Fatal error: Uncaught Error: Call to undefined function set_option() in /var/www/wp-content/plugins/book-a-room/bookaroom.php:92 Stack trace: #0 /var/www/wp-content/plugins/book-a-room/bookaroom.php(55): update_bookaroom_database() #1 /var/www/wp-includes/class-wp-hook.php(307): bookaroom_script_enqueuer('') #2 /var/www/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array) #3 /var/www/wp-includes/plugin.php(476): WP_Hook->do_action(Array) #4 /var/www/wp-settings.php(598): do_action('init') #5 /var/www/wp-config.php(97): require_once('/var/www/wp-set...') #6 /var/www/wp-load.php(50): require_once('/var/www/wp-con...') #7 /var/www/wp-admin/admin.php(34): require_once('/var/www/wp-loa...') #8 /var/www/wp-admin/plugins.php(10): require_once('/var/www/wp-adm...') #9 {main} thrown in /var/www/wp-content/plugins/book-a-room/bookaroom.php on line 92
The update routine for the database isn’t marking it as updated. I used set_ instead of update_, one sec!
Okay, I added a new routine to check the tables and fixed the one typo. Try again, please?
Fixed. Was able to activate and was able to create an event on the backend. Beer is on me if we ever meet.
Just checked the public facing page and see this error in the time selection section:
Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 528
Warning: A non-numeric value encountered in /var/www/wp-content/plugins/book-a-room/templates/public/publicShowRooms_day.php on line 569
I was able to submit a request, but unable to change the date.
https://livonialibrary.org/reserve-a-room/?action=reserve&roomID=1
looks like i forgot to turn off debug mode.
-
This reply was modified 2 years, 5 months ago by happygojira.
-
This reply was modified 2 years, 5 months ago by happygojira.
-
This reply was modified 2 years, 5 months ago by happygojira.
-
This reply was modified 2 years, 5 months ago by happygojira.
Looks like everything is fixed!
