I am getting the following error when running support tool on 4.5:
There are some problems with your database. Normally it is safe to try to fix these problems automatically however if your community is large, you may want to run the necessary queries manually. If so, the queries to run are:
CREATE TABLE `membersshop_mediauploader_points` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID Number',
`cat_id` INT NULL ,
`points_per_upload` INT NULL DEFAULT 0 ,
`points_per_download` INT NULL DEFAULT 0 ,
`points_per_review` INT NULL DEFAULT 0 ,
`points_per_comment` INT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
UPDATE `classifieds_cats` SET `cl_cat_id`='' WHERE `cl_cat_id` IS NULL;
UPDATE `classifieds_cats` SET `cl_cat_last_advert_member`=0 WHERE `cl_cat_last_advert_member` IS NULL;
UPDATE `classifieds_cats` SET `cl_cat_last_advert_member_name`='' WHERE `cl_cat_last_advert_member_name` IS NULL;
ALTER TABLE `classifieds_cats` CHANGE COLUMN `cl_cat_id` `cl_cat_id` INT UNSIGNED NOT NULL AUTO_INCREMENT , CHANGE COLUMN `cl_cat_last_advert_title` `cl_cat_last_advert_title` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , CHANGE COLUMN `cl_cat_last_advert_title_seo` `cl_cat_last_advert_title_seo` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , CHANGE COLUMN `cl_cat_last_advert_member` `cl_cat_last_advert_member` BIGINT NOT NULL DEFAULT 0 , CHANGE COLUMN `cl_cat_last_advert_member_name` `cl_cat_last_advert_member_name` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ;
ALTER TABLE `classifieds_membersdata` CHANGE COLUMN `classifieds_store_homepage` `classifieds_store_homepage` TINYINT NULL DEFAULT 0 ;