Error "Database update has failed" since updating

  • Resolved iplaygod

    (@iplaygod)


    9 years, 2 months ago

    Hello!
    Thankyou for providing this great plugin!

    I have a serious problem. Upgraded WordPress to v 4.4.1
    Also, I updated your calendar plugin to v2.3.5

    After that, the calendar dissapears from the site, and in admin i get the error message below.

    I have tried re-installing the plug-in files of the previously installed plugin version. However that did not fix the problem. So now i am back at v 2.3.5 (latest) and the problem persists.

    Please help me asap!

    Here is the error message:
    ————————
    All-in-One Event Calendar has been disabled due to an error:

    Database update has failed. Please make sure, that database user, defined in wp-config.php has permissions, to make changes (ALTER TABLE) to the database.

    Error encountered: Field wp_ai1ec_event_feeds.feed_url is of incompatible type

    Error Details:
    #0 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/lib/database/helper.php(283): Ai1ec_Database_Helper->_check_delta()
    #1 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/lib/calendar-feed/ics.php(281): Ai1ec_Database_Helper->apply_delta(‘CREATE TABLE wp…’)
    #2 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/lib/calendar-feed/ics.php(44): Ai1ecIcsConnectorPlugin->_install_schema()
    #3 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/lib/bootstrap/registry/object.php(160): Ai1ecIcsConnectorPlugin->__construct(Object(Ai1ec_Registry_Object))
    #4 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/lib/bootstrap/registry/object.php(108): Ai1ec_Registry_Object->initiate(‘Ai1ecIcsConnect…’, Array)
    #5 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/app/view/admin/calendar-feeds.php(84): Ai1ec_Registry_Object->get(‘calendar-feed.i…’)
    #6 [internal function]: Ai1ec_View_Calendar_Feeds->display_meta_box(NULL, Array)
    #7 /customers/d/6/c/slaa.se/httpd.www/wp/wp-admin/includes/template.php(1037): call_user_func(Array, NULL, Array)
    #8 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/public/admin/settings.php(15): do_meta_boxes(‘ai1ec_event_pag…’, ‘left’, NULL)
    #9 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/lib/theme/file/php.php(74): require(‘/customers/d/6/…’)
    #10 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/lib/theme/loader.php(333): Ai1ec_File_Php->process_file()
    #11 /customers/d/6/c/slaa.se/httpd.www/wp/wp-content/plugins/all-in-one-event-calendar/app/view/admin/calendar-feeds.php(72): Ai1ec_Theme_Loader->get_file(‘settings.php’, Array, true)
    #12 [internal function]: Ai1ec_View_Calendar_Feeds->display_page(”)
    #13 /customers/d/6/c/slaa.se/httpd.www/wp/wp-includes/plugin.php(525): call_user_func_array(Array, Array)
    #14 /customers/d/6/c/slaa.se/httpd.www/wp/wp-admin/admin.php(236): do_action(‘ai1ec_event_pag…’)
    #15 /customers/d/6/c/slaa.se/httpd.www/wp/wp-admin/edit.php(10): require_once(‘/customers/d/6/…’)
    #16 {main}

    Request Uri: /wp/wp-admin/edit.php?post_type=ai1ec_event&page=all-in-one-event-calendar-feeds

    https://www.ads-software.com/plugins/all-in-one-event-calendar/

Viewing 6 replies - 31 through 36 (of 36 total)

  • I’d like to retract my previous ranty post!

    This fix works perfectly for me.

    Thank you very much.

    Hi iplaygod!

    I’m sorry to hear that. Are you using the “Calendar feeds” subscription feature?

    Can you please run the following SQL command and paste here the output?

    describe wp_ai1ec_event_feeds;

    Thanks!

    Hey jamesrweeks,

    Regarding your previous post, in the last 6 months we worked hard to stabilize the plugin and add new features while becoming a very small team, with just one support person, (Ben), and a few developers (none from the ones that created the plugin) that have to clean-up old issues, refactor and test as well.

    Although the plugin and it’s add-ons is, as said my many, a very comprehensive and complex plugin and we do not offer support for free users, we actually do still check daily the support support forum and respond promptly considering again the very small team, as we do realize that issues like this may affect multiple users. You guys, our users are the purpose we are in business, so we do it with passion but to the limits (financial mainly) and pace that we can.
    We have to prioritize support for paying users as from that revenue we can actually continue going offering this plugin for free.

    Still, we just made our git repo public for anyone that wants to help us when we just can’t handle as prompt feedback as we would like to!

    Thank you for your understanding and support
    Aristotel Dascal
    VP of Product @ Time.ly

    The update to 2.3.7 seems to be working for me so far.

    THANK YOU!

    Also… I would pay for a pro version that has support. is that an option?

    Thread Starter iplaygod

    (@iplaygod)

    I can verify that the update to 2.3.7 DID fix the problem. I spoke too soon in my last post earlier in this thread.
    When I activated the plugin after the update, I first got an error message in the admin. But then I clicked “reactivate plugin”, and after that Everything has been fine!

    Thank you for your hard work and prompt response!

    So, the update to 2.3.7 solved my problem. I will mark the thread as resolved.

    Thanks
    Everything works as it should.

Viewing 6 replies - 31 through 36 (of 36 total)
  • The topic ‘Error "Database update has failed" since updating’ is closed to new replies.