Jump to content

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

Featured Replies

Posted

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...

 

Could contain: Page, Text

 

We survived! 

Could contain: Page, Text, Plot, Chart, Blackboard

Solved by Jim M

Go to solution
  • Community Expert
  • Solution

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.

  • Author

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

Hi @Ghust,

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

Recently Browsing 0

  • No registered users viewing this page.