Jump to content

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


Go to solution Solved by Jim M,

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...