table #__survey_custom_reports does not exist from file 6.4.1.sql

patgaytx
patgaytx
  • patgaytx
  • 4 days ago

Joomla is telling me table #__survey_custom_reports(' does not exist from file 6.4.1.sql.)

I checked the 6.4.1.sql file and i see that it's there (see below).  I also checked the database directly and the table does exist there as well.

CREATE TABLE IF NOT EXISTS `#__survey_custom_reports`
(
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(256) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`alias` VARCHAR(256) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`survey_id` INT UNSIGNED NOT NULL DEFAULT '0',
`report_file` VARCHAR(256) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`processed_records` INT UNSIGNED NOT NULL DEFAULT '0',
`created_by` INT UNSIGNED NOT NULL DEFAULT '0',
`created` DATETIME NULL DEFAULT NULL,
`completed` DATETIME NULL DEFAULT NULL,
`state` TINYINT UNSIGNED NULL DEFAULT '0',
`params` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
DEFAULT COLLATE = utf8mb4_unicode_ci;

#NameTypeCollationAttributesNullDefaultCommentsExtraAction
1int(10) UNSIGNEDNoNone AUTO_INCREMENTChange ChangeDrop Drop
2varchar(256)utf8mb4_unicode_ci NoNone  Change ChangeDrop Drop
3varchar(256)utf8mb4_unicode_ci NoNone  Change ChangeDrop Drop
4int(10) UNSIGNEDNo0  Change ChangeDrop Drop
5varchar(256)utf8mb4_unicode_ci YesNULL  Change ChangeDrop Drop
6int(10) UNSIGNEDNo0  Change ChangeDrop Drop
7int(10) UNSIGNEDNo0  Change ChangeDrop Drop
8datetime  YesNULL  Change ChangeDrop Drop
9datetime  YesNULL  Change ChangeDrop Drop
10tinyint(3) UNSIGNEDYes0  Change ChangeDrop Drop
11textutf8mb4_unicode_ci YesNULL  Change ChangeDrop Drop

Access to viewing replies is restricted.
Showing 4 of 4 replies
You do not have permissions for replying to this topic.
Loading...
Confirm delete? This action is irreversible and the data will be deleted permanently. Do you want to continue? Confirm Add New Delete Unpublish Cancel Import Uninstall The selected item successfully deleted.
Shondalai