Cannot update Media - get error and cannot correct error

Updated from which previous release?

Try manually deleting square_thumbnail image style found in admin/config/media/image-styles
Click on square_thumbnail and delete it. Then retry upgrade

You may need to also then recreate square_thumbnail image style , suggest 180px by 180px. Unless already correct after upgrade

This error says that there is no default value for isid on the image_styles table, meaning your schema (image_styles) table lacks a default or more likely, there should not be a default for an ID column such as isid. isid is a unique id or should be. More info: the image module is a core module, for a similar workaround/fix see https://drupal.org/node/1428176

We haven't seen other reports of this issue. Hard to say if this is a bug yet. Wait and see if others upgrading from 1.x report this; between 10000 and 20000 media 1.x to 2.x upgrades have been performed since 7.x-2.0 was released. Very few reported issues. None like this. This is why I say, wait and see. I could try myself doing a 7.x-1.6 to 7.x-2.8 upgrade, last time I tested that upgrade was I think 7.x-1.6 to 7.x-2.3 and it went fine easy as pie.

Qu'est ce qu'un default fait sur un champ unique ***EDIT*** frustration

can you log into mysql and type this:
describe image_styles;

mysql> describe image_styles;

+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| isid  | int(11)      | NO   | PRI | NULL    | auto_increment |
| name  | varchar(255) | NO   |     | NULL    |                |
| label | varchar(255) | NO   |     |         |                |
+-------+--------------+------+-----+---------+----------------+

Does your image_styles table look similar to this?

mysql> select * from image_styles;

+------+------------------------+------------------------+
| isid | name                   | label                  |
+------+------------------------+------------------------+
|    1 | original_image         | original_image         |
|    2 | media_item_thumbnail   | Media Item Thumbnail   |
|    3 | square_thumbnail       | square_thumbnail       |
+------+------------------------+------------------------+

I suspect that you've got multiple copies of the media module on your filesystem.

To diagnose your system, it would be recommended to run the duplicate module finder module to find the duplicate copies. You should then remove the 'extra' copies of the modules.
https://www.drupal.org/project/dmf

without feedback there's not much we can do here.

please run the command in phpMyAdmin
use drupalDatabaseNameForJensPeterSystems;
describe image_styles;
compare it with the table describe that I did.

if you are using a prefix in your settings php the image_styles table might be called prefix_image_styles

otherwise try this; install registry_rebuild for drush
and then run
drush rr --fire-bazooka

wrong issue

edit