EE Version 2.5 Install Issue

[ghost]

On a fresh install of EE, version 2.5, been getting an error when I try to do an installation of the extension.

I believe this is the same error as http://devot-ee.com/add-ons/support/draggable/viewthread/3031

A Database Error Occurred

Error Number: 1364

Field 'settings' doesn't have a default value

INSERT INTO exp_extensions (class, method, hook, priority, version, enabled) VALUES ('Draggable_ext', 'update_order', 'sessions_end', 10, '1.3', 'y')

Filename: codeigniter\system\database\DB_driver.php

Line Number: 330

---

Thanks!

[kevinthompson]

Sorry for the delay in responding to this. Are you still experiencing this issue? I've just gotten around to setting up a local development environment for ExpressionEngine after being away from it for several months and Draggable seems to install fine on a fresh EE 2.5.2 installation.

Please let me know if you're still having issues with this.

[ghost]

Hey Kevin,

We finally uncovered what the problem was. Apologies for the delay on our end as well. So, our DB was running with STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. We experienced odd behavior with a few other plugins that lead us to discover this.

It is our guess that on a lot of shared hosting services, none of these modes are set in MySql which is why in the past we had no problems with the plugin. In this case, we were not using a shared hosting site.

There was two possible solutions for this. Disable all modes globally, or per session. We opted for the later and all is good.

Thanks for the response! Hopefully somebody finds this useful.