Support » Plugin: Events Manager - Calendar, Bookings, Tickets, and more! » Update db for new TZ in Pantheon TEST/LIVE env

  • Resolved dismalwizard

    (@dismalwizard)


    Updating to EM 5.9.8, things went crazy. DEV went OK as updated WP to 5.5.3 here, switched from GIT to SFTP, and pulled plugin updates here. EM initialization swabbed the DEV db and life was good.

    Switched back to GIT mode and pulled updated code to TEST. Updated DB and files from DEV. All was good. Pulled production DB and files from LIVE and started pulling non-numerical value in field of the new date-time-tz type at admin login.

    The catch is that when I pull the code to LIVE where my current content is, I am stuck. No idea how to update DB tables for the new EVENT objects. WP TZ and EM TZ are both set (New York). Issue is that tables and field values need fixed in live. Most plugins catch the old table schema and run their updaters. This didn’t happen with EM 5.9.8.

    Any hints? Former modeling and sim guy with enough WP to be dangerous. Pantheon restricts all development to happen in DEV including GIT pulls to local host or LAMPS test environments run locally. Strict migration DEV -> TEST -> LIVE, with GIT revision control and manual data and files backups.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter dismalwizard

    (@dismalwizard)

    Have reverted LIVE to WP 5.5.1 and EM 5.9.8.1 so it is something about the Pantheon port of 5.5.3 (runtime environment is Google cluster, big tables, and cluster file system) so we’re bound to use their WP version. Pantheon advised and helping some. Fearing a classic Mexican finger pointing standoff as both work separately.

    Pantheon support on chat session 51746600292519
    Yep, we’re poor church mice willing to pay a bit extra per month to work with a net.

    Here’s the traceback

    Warning: A non-numeric value encountered in /code/wp-includes/functions.php on line 74 Warning: A non-numeric value encountered in /code/wp-includes/functions.php on line 74

    Fatal error: Uncaught Exception: DateTimeZone::__construct(): Unknown or bad timezone () in /code/wp-content/plugins/events-manager/classes/em-datetime.php:575

    Stack trace: #0 /code/wp-content/plugins/events-manager/classes/em-datetime.php(575): DateTimeZone->__construct(”)

    #1 /code/wp-content/plugins/events-manager/classes/em-datetime.php(601): EM_DateTimeZone->__construct(”)

    #2 /code/wp-content/plugins/events-manager/classes/em-datetime.php(37): EM_DateTimeZone::create(”)

    #3 /code/wp-content/plugins/events-manager/classes/em-object.php(363): EM_DateTime->__construct()

    #4 /code/wp-content/plugins/events-manager/classes/em-events.php(523): EM_Object::build_sql_conditions(Array)

    #5 /code/wp-content/plugins/events-manager/classes/em-events.php(117): EM_Events::build_sql_conditions(Array)

    #6 /code/wp-content/plugins/events-manager/classes/em-events.php(256): EM_Events::get(Array, true) #7 /code/wp-content/plugins/events-manager/admin/em-admin.php(21): EM_Events::count(Array)

    #8 /code/wp-includes/class-wp-hook.php(287): em in /code/wp-content/plugins/events-manager/classes/em-datetime.php on line 575

    There has been a critical error on your website. Please check your site admin email inbox for instructions.

    Thread Starter dismalwizard

    (@dismalwizard)

    https://pantheon.io has info to set up a test environment at Pantheon
    Start a free trial, put in wordpress, switch from GIT to SFTP, and add the Event Manager plugin.

    It will probably work flawlessly. The issue comes out of hiding when we put the new 5.5.3 in Dev, push to test, and pull 5.5.1 DB and files to test for regression testing. Pull DB and files from DEV and it works like a champ so something about 5.5.1 DB records. Pulling DB and files from DEV heals problem. Pulling from 5.5.1 LIVE makes it come back.

    I don’t know enough to dump the table schema for you over there. It’s acting like a call from wp-admin is choking with 5.5.1 environment db schema.

    Thread Starter dismalwizard

    (@dismalwizard)

    Spun up a virgin WP at Pantheon and added Events Manager and Full Calendar without incident. Can log in as admin from the front end, create events, and view the calendar grid.

    At this point, the best way forward appears to be to rebuild the site and reload the content in a new Pantheon environment and shift services over. I’m thinking that Events Manager init from wp-admin is just the unlucky victim of a landmine as we have been operating the site for 6 years since UUA Congregation Theme entered congregation beta status.

    Plugin Support angelo_nwl

    (@angelo_nwl)

    You can try the latest EM dev version 5.9.8.5; for dev updates – http://wp-events-plugin.com/documentation/upgrade-dev-version/

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Update db for new TZ in Pantheon TEST/LIVE env’ is closed to new replies.