• Resolved happygojira

    (@happygojira)


    I was getting a SQL error when trying to submit. I turned on debug mode and when I visit the page this is the error I’m getting:

    Deprecated: Function create_function() is deprecated in /var/www/wp-content/plugins/book-a-room/bookaroom-meetings.php on line 423

Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Contributor Colin M Tomele

    (@maniacalv)

    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.

    Plugin Contributor Colin M Tomele

    (@maniacalv)

    Please try the latest update.

    Thread Starter happygojira

    (@happygojira)

    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
    Thread Starter happygojira

    (@happygojira)

    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
    Plugin Contributor Colin M Tomele

    (@maniacalv)

    Try the latest update, please?

    Thread Starter happygojira

    (@happygojira)

    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 1 year, 11 months ago by happygojira.
    Plugin Contributor Colin M Tomele

    (@maniacalv)

    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?

    Thread Starter happygojira

    (@happygojira)

    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
    Plugin Contributor Colin M Tomele

    (@maniacalv)

    The update routine for the database isn’t marking it as updated. I used set_ instead of update_, one sec!

    Plugin Contributor Colin M Tomele

    (@maniacalv)

    Okay, I added a new routine to check the tables and fixed the one typo. Try again, please?

    Thread Starter happygojira

    (@happygojira)

    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 1 year, 11 months ago by happygojira.
    • This reply was modified 1 year, 11 months ago by happygojira.
    • This reply was modified 1 year, 11 months ago by happygojira.
    • This reply was modified 1 year, 11 months ago by happygojira.
    Thread Starter happygojira

    (@happygojira)

    Looks like everything is fixed!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Create/Manage Events php error’ is closed to new replies.