Issue updating to 4.7.4: tries to upgrade gallery table, difference in column count. [WORKAROUND]

[Ghust]

When upgrading I got an error saying a script "insert ignore select into gallery_images_uploads select * from gallery_images_uploads_new"

 

This is because my database had more columns in the "new" table.

This

 

I worked around this by manually adding the columns in mysql:

 

MariaDB [dbname]> alter table gallery_images_uploads add column upload_location text;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [dbname]> alter table gallery_images_uploads add column upload_unique_id bigint(20) unsigned NOT NULL;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [dbname]> alter table gallery_images_uploads add column upload_order int(10) unsigned;
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

 

This may be caused because I never upgraded anything else than Core and Forums. But I didn't have an option to deselect other features from this upgrade.

 

 

But anyway...

 

 

We survived! 

[Jim M]

You will always want to upgrade all applications together (one of the reason why we removed that option to deselect other core applications now). If you upgrade one application but not others, the others that are not upgraded will be disabled anyway so if you're not using Gallery, I'd suggest uninstalling it.

[Ghust]

That's actually a fair point, I hadn't thought about that. Thanks @Jim M!

[Gary]

Hi @Ghust,

Happy you got through it without any further issues. Please let us know if you need help with anything else.