Ghust Posted November 2, 2022 Share Posted November 2, 2022 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! Link to comment Share on other sites More sharing options...
Solution Jim M Posted November 2, 2022 Solution Share Posted November 2, 2022 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 More sharing options...
Ghust Posted November 3, 2022 Author Share Posted November 3, 2022 That's actually a fair point, I hadn't thought about that. Thanks @Jim M! Link to comment Share on other sites More sharing options...
Gary Posted November 4, 2022 Share Posted November 4, 2022 Hi @Ghust, Happy you got through it without any further issues. Please let us know if you need help with anything else. Link to comment Share on other sites More sharing options...
Recommended Posts