Update the version of TINA

TEST UPDATING TINA VERSION

The updater is only CHECKING that everything is ok.

Date and time: 17-07-2026 20:28:15

Update FROM version: 3889

Update TO version: 3889

SUCCESS: NO

1. TINA directory does not exist - probably a previous update did not ended successfully.

2. TINA scripts for the new version do not exist - current downloaded archive may have been broken.

3. Database var `nextBuild` is different than the version set in the scripts that are about to be installed.

UPDATER STEPS:

1. MySQL connection successfully established.

2. Agency code was selected from database: DANDEVEL.

3. Version updater configurations file loaded.

show/hide details SQLS AND SCRIPTS DETAILS:

-- Element 1. Type: simpleSql. [mandatory]
ALTER TABLE `qcRules` CHANGE `entity` `entity` ENUM('User','Office','Corporate','Customer','Supplier','SupplierProduct','Order','Service','Offer','Invoice','DocumentInvoice','InvoiceCashing','SupplierInvoice','SupplierInvoicePayment') COLLATE 'utf8_unicode_ci' NOT NULL AFTER `active`;

-- Element 2. Type: simpleSql. [mandatory]
UPDATE `usersAccess` set idSection = 'Plugins/RadiusReport' where idSection = 'RadiusReport';

-- Element 3. Type: simpleSql. [mandatory]
UPDATE `usersAccess` set idSection = 'Plugins/RadiusReport/Reports' where idSection = 'RadiusReport_reports';

-- Element 4. Type: simpleSql. [mandatory]
UPDATE `usersAccess` set idSection = 'Plugins/RadiusReport/Config' where idSection = 'RadiusReport_config';

-- Element 5. Type: simpleSql. [mandatory]
UPDATE `usersProfilesAccess` set idSection = 'Plugins/RadiusReport' where idSection = 'RadiusReport';

-- Element 6. Type: simpleSql. [mandatory]
UPDATE `usersProfilesAccess` set idSection = 'Plugins/RadiusReport/Reports' where idSection = 'RadiusReport_reports';

-- Element 7. Type: simpleSql. [mandatory]
UPDATE `usersProfilesAccess` set idSection = 'Plugins/RadiusReport/Config' where idSection = 'RadiusReport_config';

-- Element 8. Type: simpleSql. [mandatory]
CREATE TABLE IF NOT EXISTS `autoProcess_logs` (
			  `id` bigint(15) NOT NULL AUTO_INCREMENT,
			  `idExecution` varchar(14) COLLATE utf8_unicode_ci NOT NULL,
			  `idRule` mediumint(8) NOT NULL,
			  `message` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
			  `type` enum('info','warning','error','success') COLLATE utf8_unicode_ci NOT NULL,
			  `entityType` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
			  `idEntity` bigint(15) UNSIGNED NOT NULL,
			  `entityOperation` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
			  `addTime` decimal(14,4) NOT NULL,
			  PRIMARY KEY (`id`),
			  KEY `idEntity` (`idEntity`),
			  KEY `idExecution` (`idExecution`),
			  KEY `addTime` (`addTime`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Element 9. Type: simpleSql. [SKIPPED BY AGENCY CODE]
-- DROP TABLE IF EXISTS `autoProcess_output`;

-- Element 10. Type: simpleSql. [mandatory]
ALTER TABLE `tasks` DROP INDEX `idPivot`, ADD INDEX compound(`pivot`, `idPivot`);

-- Element 11. Type: simpleSql. [mandatory]
INSERT INTO `cronJobs` (`id`, `active`, `scheduleOptions`, `settings`) VALUES ('DatabaseCleanupForAutoProcessLogs', '1', 'a:4:{s:4:"type";s:9:"scheduled";s:8:"weekDays";a:1:{i:0;s:1:"5";}s:9:"monthDays";a:31:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"4";i:4;s:1:"5";i:5;s:1:"6";i:6;s:1:"7";i:7;s:1:"8";i:8;s:1:"9";i:9;s:2:"10";i:10;s:2:"11";i:11;s:2:"12";i:12;s:2:"13";i:13;s:2:"14";i:14;s:2:"15";i:15;s:2:"16";i:16;s:2:"17";i:17;s:2:"18";i:18;s:2:"19";i:19;s:2:"20";i:20;s:2:"21";i:21;s:2:"22";i:22;s:2:"23";i:23;s:2:"24";i:24;s:2:"25";i:25;s:2:"26";i:26;s:2:"27";i:27;s:2:"28";i:28;s:2:"29";i:29;s:2:"30";i:30;s:2:"31";}s:11:"executeTime";s:8:"22:30:00";}', 'a:1:{s:10:"logsPeriod";s:2:"6m";}');

-- Element 12. Type: simpleSql. [mandatory]
REPLACE INTO `usersAccess` (`idUser`, `idSection`, `type`, `optionValue`) SELECT `idUser`, 'Group:Admin/AutoProcessRules', `type`, `optionValue` FROM `usersAccess` WHERE `idSection`= 'Modules/Admin/AutoProcessRules';

-- Element 13. Type: simpleSql. [mandatory]
REPLACE INTO `usersAccess` (`idUser`, `idSection`, `type`, `optionValue`) SELECT `idUser`, 'Modules/Admin/AutoProcessRulesLogs', `type`, `optionValue` FROM `usersAccess` WHERE `idSection`= 'Modules/Admin/AutoProcessRules';

-- Element 14. Type: simpleSql. [mandatory]
REPLACE INTO `usersProfilesAccess` (`idProfile`, `idSection`, `type`, `optionValue`) SELECT `idProfile`, 'Group:Admin/AutoProcessRules', `type`, `optionValue` FROM `usersProfilesAccess` WHERE `idSection`= 'Modules/Admin/AutoProcessRules';

-- Element 15. Type: simpleSql. [mandatory]
REPLACE INTO `usersProfilesAccess` (`idProfile`, `idSection`, `type`, `optionValue`) SELECT `idProfile`, 'Modules/Admin/AutoProcessRulesLogs', `type`, `optionValue` FROM `usersProfilesAccess` WHERE `idSection`= 'Modules/Admin/AutoProcessRules';

-- Element 16. Type: simpleSql. [mandatory]
DELETE FROM `cronJobs` WHERE id='ParavionAmadeusResellersAutoProcess';

-- Element 17. Type: simpleSql. [mandatory]
DELETE FROM `cronJobs` WHERE id='ParavionTicketsAutoProcess';

-- Element 18. Type: simpleSql. [SKIPPED BY AGENCY CODE]
-- DROP TABLE IF EXISTS `plugins_paravionTicketsQueue`;

-- Element 19. Type: simpleSql. [mandatory]
DELETE FROM `cronJobs` WHERE id='ParavionImportedServicesAutoProcess';

-- Element 20. Type: simpleSql. [mandatory]
DELETE FROM `usersAccess` WHERE `idSection` IN ('Plugins/ParavionImportedServicesAutoProcess/ImportQueue', 'Plugins/ParavionImportedServicesAutoProcess/WsSimulator');

-- Element 21. Type: simpleSql. [mandatory]
DELETE FROM `usersProfilesAccess` WHERE `idSection` IN ('Plugins/ParavionImportedServicesAutoProcess/ImportQueue', 'Plugins/ParavionImportedServicesAutoProcess/WsSimulator');

-- Element 22. Type: simpleSql. [SKIPPED BY AGENCY CODE]
-- DROP TABLE IF EXISTS `plugins_paravionWsOrdersQueue`;

-- Element 23. Type: simpleSql. [SKIPPED BY AGENCY CODE]
-- DROP TABLE IF EXISTS `plugins_paravionWsOrdersServices`;

-- Element 24. Type: simpleSql. [mandatory]
TRUNCATE TABLE `pivotTablesConfigs`;

-- Element 25. Type: simpleSql. [mandatory]
CREATE TABLE `errorLogs_archive` (
			  `id` int(11) unsigned NOT NULL,
			  `source` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
			  `logLevel` enum('critical','error','warning','info') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'info',
			  `message` text COLLATE utf8_unicode_ci NOT NULL,
			  `context` mediumblob NOT NULL,
			  `stacktrace` text COLLATE utf8_unicode_ci NOT NULL,
			  `idUser` smallint(5) unsigned NOT NULL,
			  `addTime` datetime NOT NULL,
			  `logSession` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
			  UNIQUE KEY (`id`),
			  UNIQUE KEY `addTime_id` (`addTime`,`id`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Element 26. Type: script.
MANUAL SCRIPT EXECUTED - ./versions/3889/_removeAtlasJetFolder.php