Error "Database update has failed" since updating

I can add that if I click the button “try to reactivate the plugin”, the calendar comes back on the site and works as expected for 1 or 2 hours, then the error comes back and the calendar is inactivated again…

Hi,

It seems that your current database user does not have all needed permissions. Please change user grants and reactivate the plugin.

Hi,
I have the same problem.
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

Of course the database user is correct or nothing would work. With mine when I click on Calendar Feeds, it crashes. I can reactivate and it starts up.

This started today after I updated to v2.3.6, or at least that’s when I noticed it. WP v4.4.1

Thanks for your reply Benjamin.
As randalla says, i dont Think user permissions for database is the real issue. The plugin / user HAS created the tables it uses. So I dont see why an ALTER would be a problem? Please enlighten me if theres something im missing.

I tried updating the plugin to 2.3.6.
First it seemed to work. But as soon as I go to the admin plugin settings and press “Calendar Feeds” the error message appears and the plugin is again de-activated.

So (as the error message itself implies) the error is related to the feeds and something being wrong in the database.

I found a similar (not identical) error described here:
https://time.ly/forums/topic/data-update-issue-when-upgrading/

but in that thread they move to private messages to solve the problem, so I dont know what they did.

Please help. Thank you.

I have the same problem.

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

Looking for help to solve it?

This is really frustrating. It’s a great plugin, when it works, but I often have update problems.

The automatic update always completely crashes my site so I always need to manually rename the old version plugin folder, deactivate it, upload the new one, activate it, then delete the old one.

Now, the plugin continually deactivates itself after a short while due to the above-posted errors.

I’d be really grateful if a fix could be provided as soon as possible.

Many thanks.

I returned to 2.3.4: Everything is breaking. Thumbnails appear in events in widgets are either mixed or not displayed at all.

When uninstalled plugin and installed a new 2.3.6 all is well.
It’s just that all entries in the database are removed – I’m not going to add them again manually.

I’m getting desperate… this has wrecked one of the main features on my site.

I’d happily pay for support at this stage to fix it but there’s no way of getting through!

Getting the same issue. This is a multi-site install, so I have multiple websites that all have calendar issues now. Worked just fine for the past year before the update and DB user should have full rights. I have the latest version of everything, so let me know what we need to do here.

Database user does not have “alter” table permission, some web hosting block the command. So please contact hosting support.

I Have the same problem
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 a8dx_ai1ec_event_feeds.feed_url is of incompatible type.
rolled back to yesterdays backup and its all working again with wordpress updated to 4.4.1 All-in-One Event Calendar on 2.2.1
I have not made any changes to permissions so no idea why this should fail. the only change has been the update to All-in-One Event Calendar to 2.3.6.
I can write basic HTML and CSS and have customised the wordpress theme with a child theme and the layout of the calendar with customization as detailed on the website. but the last time i touched a DB was in DB3+ in 1992 so would have no idea how to change database user permissions.
Why has an update changed the permissions required?

That’s not really a solution.

Please can you detail what’s changed in the feed functionality of this update to cause this?

You surely can’t expect hosts to change their entire security measures due to the desired functionality changes of a single WordPress plugin of one client?

Bradley was convincing me to persist with you guys, this response doesn’t inspire me…

Please listen to the folk on the thread that this isn’t a trivial issue.

Hey, Benjamin…

How can we fix this by going into PHP MyAdmin?

As an update…

I went to my Dreamhost list of database users to find that my user HAS permission to “alter” the database. But, the plugin is still not able to “alter” the database.

WHAT NOW?!

Benjamin, if the plugin was working fine previously, and permissions for DB users have not changed (as specified by multiple people), it stands to reason that a change in your plugin architecture has caused this error.

Additionally, the plugin activates for a window of time and works fine, but then it reverts to this issue.

I am running a WP multisite with the regular calendar and the extended views addon. I tried both updating through WP as well as removing the plugin files via FTP and adding the latest version manually. Both have failed.

Error details:

#0 /home/bargetto/public_html/wp-content/plugins/all-in-one-event-calendar/lib/database/helper.php(283): Ai1ec_Database_Helper->_check_delta()
#1 /home/bargetto/public_html/wp-content/plugins/all-in-one-event-calendar/lib/calendar-feed/ics.php(281): Ai1ec_Database_Helper->apply_delta(‘CREATE TABLE wp…’)
#2 /home/bargetto/public_html/wp-content/plugins/all-in-one-event-calendar/lib/calendar-feed/ics.php(44): Ai1ecIcsConnectorPlugin->_install_schema()
#3 /home/bargetto/public_html/wp-content/plugins/all-in-one-event-calendar/lib/bootstrap/registry/object.php(160): Ai1ecIcsConnectorPlugin->__construct(Object(Ai1ec_Registry_Object))
#4 /home/bargetto/public_html/wp-content/plugins/all-in-one-event-calendar/lib/bootstrap/registry/object.php(108): Ai1ec_Registry_Object->initiate(‘Ai1ecIcsConnect…’, Array)
#5 /home/bargetto/public_html/wp-content/plugins/all-in-one-event-calendar/lib/bootstrap/registry/object.php(204): Ai1ec_Registry_Object->get(‘calendar-feed.i…’)
#6 /home/bargetto/public_html/wp-content/plugins/all-in-one-event-calendar/lib/event/callback/abstract.php(59): Ai1ec_Registry_Object->dispatch(‘calendar-feed.i…’, ‘cron’, Array)
#7 [internal function]: Ai1ec_Event_Callback_Abstract->run()
#8 /home/bargetto/public_html/wp-includes/plugin.php(601): call_user_func_array(Array, Array)
#9 /home/bargetto/public_html/wp-cron.php(117): do_action_ref_array(‘ai1ec_cron’, Array)
#10 {main}
Request Uri: /wp-cron.php?doing_wp_cron=1452831374.4316849708557128906250