Introducing Quests: Tailored gamification & bridging in-person events with your community Mike Gitkos 10 hours ago10 hr
Posted November 2, 20222 yr 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!
November 2, 20222 yr 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.
November 3, 20222 yr Author That's actually a fair point, I hadn't thought about that. Thanks @Jim M!
November 4, 20222 yr Hi @Ghust, Happy you got through it without any further issues. Please let us know if you need help with anything else.