version upgrade from 6.2 to 6.3

Get help from the community here.

Moderator: Developers

gaetano119
Posts: 12
Joined: Sat Mar 31, 2018 2:55 pm

version upgrade from 6.2 to 6.3

Postby gaetano119 » Thu Feb 06, 2020 6:40 pm

hello, I can't update from 6.2 to 6.3 I have done various tests, nothing since always the same error, I did a local test by making a copy of what I have on the network and it worked, so I assume that the problem is with the server where the system is installed, here is the error that gives me ..
  • DROP TABLE IF EXISTS `go_mail_counter`;
    Converting ab_settings to utf8mb4
    Converting dbx_users to utf8mb4
    Converting go_clients to utf8mb4
    Converting go_links_ab_addresslists to utf8mb4
    UPDATE go_settings SET value=0 where name = 'version';
    ALTER TABLE `go_modules` ADD `package` VARCHAR(100) NULL DEFAULT NULL AFTER `id`;
    ALTER TABLE `go_modules` CHANGE `id` `id` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
    RENAME TABLE `go_modules` TO `core_module`;
    ALTER TABLE `core_module` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    ALTER TABLE `core_module` CHANGE `id` `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
    ALTER TABLE `core_module` DROP PRIMARY KEY;
    ALTER TABLE `core_module` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
    ALTER TABLE `core_module` ADD UNIQUE(`name`);
    ALTER TABLE `core_module` CHANGE `acl_id` `aclId` INT(11) NOT NULL;
    ALTER TABLE `core_module` ADD INDEX(`aclId`);
    ALTER TABLE `core_module` ADD CONSTRAINT `acl` FOREIGN KEY (`aclId`) REFERENCES `go_acl_items`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
    CREATE TABLE `core_auth_token` (
    `accessToken` varchar(100) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
    `userId` int(11) NOT NULL,
    `createdAt` datetime NOT NULL,
    `expiresAt` datetime NOT NULL,
    `remoteIpAddress` varchar(100) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
    `userAgent` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    CREATE TABLE `core_state` (
    `entityClass` varchar(190) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
    `highestModSeq` int(11) DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    ALTER TABLE `core_auth_token`
    ADD PRIMARY KEY (`accessToken`),
    ADD KEY `userId` (`userId`);
    ALTER TABLE `core_state`
    ADD PRIMARY KEY (`entityClass`);
    ALTER TABLE `go_groups` CHANGE `user_id` `createdBy` INT(11) NOT NULL DEFAULT '0';
    ALTER TABLE `go_groups` CHANGE `acl_id` `aclId` INT(11) NOT NULL;
    ALTER TABLE `go_groups` DROP `admin_only`;
    ALTER TABLE `go_groups` ADD `isUserGroupFor` INT NULL DEFAULT NULL AFTER `aclId`, ADD INDEX (`isUserGroupFor`);
    ALTER TABLE `go_acl` DROP INDEX `acl_id_2`;
    ALTER TABLE `go_acl` DROP INDEX `acl_id`;
    ALTER TABLE `go_acl` ADD INDEX(`level`);
    ALTER TABLE `go_groups` CHANGE `aclId` `aclId` INT(11) NULL DEFAULT NULL;
    ALTER TABLE `go_acl_items` CHANGE `user_id` `ownedBy` INT(11) NOT NULL;
    ALTER TABLE `go_acl_items` ADD `modifiedAt` DATETIME NULL DEFAULT NULL AFTER `mtime`;
    update `go_acl_items` set modifiedAt = from_unixtime(mtime);
    ALTER TABLE `go_acl_items` DROP `mtime`;
    delete from go_acl where user_id > 0 AND user_id not in (select id from go_users)
    delete from go_acl where group_id > 0 AND group_id not in (select id from go_groups)
    ALTER TABLE `go_acl` CHANGE `group_id` `groupId` INT(11) NOT NULL DEFAULT '0';
    ALTER TABLE `go_acl` CHANGE `acl_id` `aclId` INT(11) NOT NULL;
    ALTER TABLE `go_groups` CHANGE `name` `name` VARCHAR(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
    DROP TRIGGER IF EXISTS `Create ACL`;
    CREATE TRIGGER `Create ACL` BEFORE INSERT ON `go_groups` FOR EACH ROW BEGIN INSERT INTO `go_acl_items` (`ownedBy`, `description`) VALUES (NEW.createdBy, 'go_groups.aclId'); set NEW.aclId = (SELECT last_insert_id()); END
    ERROR: SQLSTATE[42000]: Syntax error or access violation: 1142 TRIGGER command denied to user 'Sql876352'@'62.139.141.14' for table 'go_groups' Query CREATE TRIGGER `Create ACL` BEFORE INSERT ON `go_groups` FOR EACH ROW BEGIN INSERT INTO `go_acl_items` (`ownedBy`, `description`) VALUES (NEW.createdBy, 'go_groups.aclId'); set NEW.aclId = (SELECT last_insert_id()); ENDERROR: A fatal upgrade error occurred. You will not be able to continue upgrading this database! Please report this error message.
mschering
Site Admin
Site Admin
Posts: 8354
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: version upgrade from 6.2 to 6.3

Postby mschering » Tue Feb 11, 2020 3:13 pm

Sorry, you need to be allowed to create a trigger on your database to do this upgrade.
Best regards,

Merijn Schering
Intermesh
gaetano119
Posts: 12
Joined: Sat Mar 31, 2018 2:55 pm

Re: version upgrade from 6.2 to 6.3

Postby gaetano119 » Thu Feb 13, 2020 2:39 pm

Thanks for the answer, I don't know what "trigger" is, I tried to find out, but it seems complicated and doubtful, however I solved my way .. I did a clean installation and I imported everything manually, in fact from the 1700s users I have lost all passwords. however despite it being a big job and I haven't finished yet, I think it is the shortest way.

Who is online

Users browsing this forum: No registered users and 3 guests