· 6 years ago · Oct 21, 2019, 08:56 AM
1root@portal1:/var/www/stalker_portal/deploy# phing
2Buildfile: /var/www/stalker_portal/deploy/build.xml
3 [property] Loading /var/www/stalker_portal/deploy/../server/custom.ini
4 [property] Loading /var/www/stalker_portal/deploy/../server/config.ini
5
6stalker_portal > build:
7
8 [exec] Executing command: lsb_release -r -s 2>&1
9 [echo] Ubuntu version: 14.04
10 [echo] Project path: /var/www/stalker_portal
11 [php] Evaluating PHP expression: substr(phpversion(), 0, 3);
12 [echo] PHP version: 5.5
13 [exec] Executing command: apt-get update 2>&1
14 [exec] Executing command: apt-get -y install zlibc curl php5-sqlite php-soap php5-intl php-gettext php5-memcache php5-curl php5-mysql php5-mcrypt php5-tidy php5-imagick php5-geoip curl npm git zip unzip 2>&1
15 [exec] Executing command: phpenmod mcrypt 2>&1
16 [exec] Executing command: phpdismod opcache 2>&1
17 [exec] Executing command: cp -r -v /var/www/stalker_portal/deploy/composer/locks/composer-5.5.9.lock /var/www/stalker_portal/deploy/composer.lock 2>&1
18 [exec] Executing command: cp -r -v /var/www/stalker_portal/deploy/composer/locks/composer-5.5.9-ministra.lock /var/www/stalker_portal/deploy/ministra/composer.lock 2>&1
19 [exec] Executing command: a2enmod rewrite 2>&1
20 [exec] Executing command: curl -sS https://getcomposer.org/installer | php -- --install-dir=/var/www/stalker_portal/deploy/composer/ --filename=composer.deploy.phar 2>&1
21 [exec] Executing command: chmod +x /var/www/stalker_portal/storage/tvarchive.sh 2>&1
22 [exec] Executing command: rm -f /var/www/stalker_portal/deploy/ministra/composer.lock 2>&1
23 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar global require hirak/prestissimo --no-interaction 2>&1
24 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/deploy/ install --no-dev --no-suggest --no-interaction 2>&1
25 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/deploy/ dump-autoload --no-dev 2>&1
26 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/deploy/ministra install --no-dev --no-suggest --no-interaction 2>&1
27 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/deploy/ministra dump-autoload --no-dev 2>&1
28 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/storage install --no-dev --no-suggest --no-interaction 2>&1
29 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/storage dump-autoload --no-dev 2>&1
30 [exec] Executing command: stop stalkerd 2>&1
31 [exec] Executing command: nodejs -v 2>&1
32 [copy] Copying 1 file to /etc/cron.d
33 [chmod] Changed file mode on '/etc/cron.d/stalker_70439ea2348d37ccfc8c52d63fff51eb' to 755
34 [copy] Copying 1 file to /etc/logrotate.d
35 [echo] /var/www/stalker_portal
36 [copy] Copying 1 file to /tmp
37 [php] Evaluating PHP expression: ini_get('extension_dir');
38 [echo] PHP extension dir: /usr/lib/php5/20121212
39 [php] Evaluating PHP expression: PHP_INT_SIZE === 8 ? 64 : 32
40 [echo] OS: 64 bit
41 [copy] Copying 1 file to /usr/lib/php5/20121212
42 [chmod] Changed file mode on '/usr/lib/php5/20121212/ioncube_loader_lin_5.5.so' to 644
43 [exec] Executing command: php -v | grep -i ioncube | wc -l 2>&1
44 [echo] IonCube installed: 1
45 [exec] Executing command: cp -r -v /var/www/stalker_portal/deploy/src/core/53/* /var/www/stalker_portal 2>&1
46 [exec] Executing command: php /var/www/stalker_portal/admin/bin/console mtv:migrations:upgrade --no-interaction 2>&1
47 [exec] Executing command: php /var/www/stalker_portal/admin/bin/console mtv:migrations:deploy --no-interaction 2>&1
48 [echo] Loading configuration from the integration code of your framework (setter).
49
50 Ministra DB Migrations
51
52
53WARNING! You have 2 previously executed migrations in the database that are not registered migrations.
54 >> ()
55 >> ()
56Migrating up to 20190927081556 from 1535720165
57
58 ++ migrating 1535720166
59
60 -> --
61CREATE TABLE `themes` (
62 `id` INT NOT NULL AUTO_INCREMENT,
63 `alias` VARCHAR(64) NOT NULL DEFAULT '',
64 `variables` TEXT,
65 `added` TIMESTAMP NULL DEFAULT NULL,
66 `updated` TIMESTAMP NULL DEFAULT NULL,
67 UNIQUE INDEX `alias` (`alias`),
68 PRIMARY KEY (`id`)
69) DEFAULT CHARSET = UTF8;
70
71 ++ migrated (0.04s)
72
73 ++ migrating 1535720167
74
75 -> ALTER TABLE `settings` ADD `default_launcher_template` varchar(255) NOT NULL DEFAULT 'smart_launcher:magcore-theme-graphite';
76
77 ++ migrated (0.8s)
78
79 ++ migrating 1535720168
80
81 -> --
82ALTER TABLE `video_season_series` MODIFY `series_number` INT NOT NULL;
83
84 ++ migrated (0s)
85
86 ++ migrating 1535720169
87
88 -> --
89INSERT INTO `adm_grp_action_access`
90 (`controller_name`, `action_name`, `is_ajax`, `description` )
91VALUES ('settings', 'themes-edit', 0, 'Page for editing theme'),
92 ('settings', 'upload-theme-img', 1, 'Uploading theme images'),
93 ('settings', 'themes-reset-to-default', 1, 'Resetting launcher themes to default settings');
94
95 ++ migrated (0s)
96
97 ++ migrating 1535720170
98
99 -> --
100INSERT INTO `adm_grp_action_access`
101 (`controller_name`, `action_name`, `is_ajax`, `description` )
102VALUES ('tariffs', 'set-tvarchive-settings', 1, 'Set tv-archive settings from service-package edit page ');
103
104 ++ migrated (0s)
105
106 ++ migrating 1535720171
107
108 -> --
109UPDATE adm_grp_action_access SET `description` = REPLACE(`description`, 'Activation code', 'License key');
110UPDATE adm_grp_action_access SET `description` = REPLACE(`description`, 'activation code', 'license key');
111
112 ++ migrated (0.01s)
113
114 ++ migrating 1535720172
115
116 -> --
117UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`, 'Middleware Ministra', 'Ministra TV Platform');
118UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`, 'Ministra', 'Ministra');
119UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`, '174 Bay 49</span><sup><span>th</span></sup><span> Street, Brooklyn, NY 11214', 'Route de Chêne 30, 1207 Geneva, Switzerland');
120UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`, 'Infomir, LLC', 'Infomir, SA');
121UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`, '2015 Infomir', '2017 Infomir');
122UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`, '2016 Infomir', '2017 Infomir');
123UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`, 'October 1, 2015', 'Effective as of January 26, 2018');
124UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`, 'July 1, 2016', 'Effective as of January 26, 2018');
125UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`,
126'<p>
127<span><b>4. Miscellaneous</b></span>
128</p>',
129'<h2>
130<span>4. Miscellaneous</span>
131</h2>'
132);
133
134 ++ migrated (0s)
135
136 ++ migrating 1535720173
137
138 -> --
139ALTER TABLE users ADD COLUMN clock_format ENUM('12h', '24h') NULL DEFAULT NULL;
140
141 ++ migrated (1.88s)
142
143 ++ migrating 1535720174
144
145 -> --
146UPDATE `filters` SET `title`= 'Status' WHERE `title` = 'State' AND `method` = 'getUsersByStatus';
147UPDATE `filters` SET `title`= 'State' WHERE `title` = 'Status' AND `method` = 'getUsersByState';
148
149 ++ migrated (0s)
150
151 ++ migrating 1535720175
152
153 -> --
154UPDATE `apps_tos` SET `tos_en`=replace(`tos_en`, 'VertaMedia', 'Adtelligent');
155
156 ++ migrated (0s)
157
158 ++ migrating 1535720176
159
160 -> --
161UPDATE `itv` set `wowza_dvr` = (`tv_archive_type` = 'wowza_dvr');
162UPDATE `itv` set `flussonic_dvr` = (`tv_archive_type` = 'flussonic_dvr');
163UPDATE `itv` set `nimble_dvr` = (`tv_archive_type` = 'nimble_dvr');
164
165 ++ migrated (0.03s)
166
167 ++ migrating 1535720177
168
169 -> --
170UPDATE `adm_grp_action_access` SET `controller_name`=replace(`controller_name`, 'activation-codes', 'license-keys');
171UPDATE `adm_grp_action_access` SET `action_name`=replace(`action_name`, 'activation-codes', 'license-keys');
172UPDATE `adm_grp_action_access` SET `action_name`=replace(`action_name`, '-code-', '-key-');
173
174 ++ migrated (0.01s)
175
176 ++ migrating 1535720178
177
178 -> --
179DELETE `f1`.* FROM `filters` AS `f1`
180 LEFT JOIN (SELECT `id` FROM `filters` GROUP BY `method`, `values_set`) AS `f2`
181 ON `f1`.`id` = `f2`.`id`
182WHERE `f2`.`id` IS NULL;
183
184 ++ migrated (0s)
185
186 ++ migrating 1535720179
187
188 -> --
189ALTER TABLE `media_claims` ADD INDEX `media_type_id` (`media_type` ASC, `media_id` ASC);
190ALTER TABLE `video_series_files` ADD INDEX `video_id_idx` (`video_id` ASC);
191
192 ++ migrated (0.07s)
193
194 ++ migrating 1535720180
195
196 -> --
197UPDATE `video` SET `rating_imdb` = `rating_kinopoisk`, `rating_kinopoisk` = '' WHERE NOT(`rating_imdb`) AND `autocomplete_provider` = 'tmdb';
198UPDATE `video` SET `rating_count_imdb` = `rating_count_kinopoisk`, `rating_count_kinopoisk` = '' WHERE NOT(`rating_count_imdb`) AND `autocomplete_provider` = 'tmdb';
199
200 ++ migrated (0.39s)
201
202 ++ migrating 1535720181
203
204 -> ALTER TABLE `ch_links` ADD `flexcdn_auth_support` tinyint default 0;
205
206 ++ migrated (0.89s)
207
208 ++ migrating 1535720182
209
210 -> --
211ALTER TABLE `video` MODIFY `rating_kinopoisk` FLOAT(7,5) DEFAULT 0;
212ALTER TABLE `video` MODIFY `rating_count_kinopoisk` INTEGER UNSIGNED DEFAULT 0;
213ALTER TABLE `video` MODIFY `rating_imdb` FLOAT(7,5) DEFAULT 0;
214ALTER TABLE `video` MODIFY `rating_count_imdb` INTEGER UNSIGNED DEFAULT 0;
215
216 ++ migrated (2.42s)
217
218 ++ migrating 1535720183
219
220 -> ALTER TABLE `smac_certificates` ADD `repaired_date` INT DEFAULT 0;
221
222 ++ migrated (0.87s)
223
224 ++ migrating 1535720184
225
226 -> --
227truncate table `course_cache`;
228ALTER TABLE `course_cache` DROP COLUMN `url`;
229ALTER TABLE `course_cache` DROP COLUMN `content`;
230ALTER TABLE `course_cache` DROP COLUMN `crc`;
231ALTER TABLE `course_cache` ADD COLUMN `provider` varchar(10) NOT NULL AFTER `id`;
232ALTER TABLE `course_cache` ADD COLUMN `exchange_date` DATE NOT NULL AFTER `provider`;
233ALTER TABLE `course_cache` ADD COLUMN `code` varchar(10) NOT NULL AFTER `exchange_date`;
234ALTER TABLE `course_cache` ADD COLUMN `currency` varchar(10) NOT NULL AFTER `code`;
235ALTER TABLE `course_cache` ADD COLUMN `nominal` int NOT NULL default 1 AFTER currency;
236ALTER TABLE `course_cache` ADD COLUMN `value` DECIMAL(10,8) NOT NULL AFTER `nominal`;
237ALTER TABLE `course_cache` ADD INDEX (`provider`);
238
239 ++ migrated (0.91s)
240
241 ++ migrating 1535720185
242
243 -> ALTER TABLE `karaoke` ADD `protocol_old` VARCHAR(64) DEFAULT '';
244 -> --
245
246UPDATE `karaoke` SET `protocol_old` = `protocol`;
247UPDATE `karaoke` SET `protocol` = IF(`protocol` = 'nfs', 'http', `protocol`);
248UPDATE `karaoke` SET `rtsp_url` = IF(`protocol` = 'http', '', `rtsp_url`);
249
250 ++ migrated (0.86s)
251
252 ++ migrating 1535720186
253
254 -> ALTER TABLE `notification_feed` ADD COLUMN `deleted` tinyint NOT NULL default 0 AFTER `read`;
255 -> --
256
257update `notification_feed` set `deleted` = 0 where `read` = 0;
258update `notification_feed` set `deleted` = 1 where `read` = 1;
259ALTER TABLE `notification_feed` ADD INDEX `deleted` (`deleted`);
260INSERT INTO `adm_grp_action_access`
261 (`controller_name`, `action_name`, `is_ajax`, `description`, `hidden`,`only_top_admin`)
262VALUES ('index', 'note-list-mark-deleted', 1, 'Mark notification as deleted, set "deleted" flag', 1, 1);
263
264 ++ migrated (0.88s)
265
266 ++ migrating 1535720187
267
268 -> ALTER TABLE `video` ADD COLUMN `admin_id` INTEGER DEFAULT null AFTER `added`;
269
270 ++ migrated (1.16s)
271
272 ++ migrating 1535720188
273
274 -> --
275CREATE TABLE `resellers_ips_ranges` (
276 `id` INT NOT NULL AUTO_INCREMENT,
277 `reseller_id` INT NOT NULL DEFAULT 0,
278 `ip_range` VARCHAR(32) NOT NULL DEFAULT '',
279 `calculated_range_begin` INT UNSIGNED NOT NULL DEFAULT 0,
280 `calculated_range_end` INT UNSIGNED NOT NULL DEFAULT 0,
281 INDEX `idx_reseller_id` (`reseller_id`),
282 PRIMARY KEY (`id`)
283) DEFAULT CHARSET = UTF8;
284ALTER TABLE users ADD COLUMN last_change_ip VARCHAR(64) NOT NULL DEFAULT '{}';
285ALTER TABLE reseller ADD COLUMN use_ip_ranges TINYINT NOT NULL DEFAULT 0;
286
287 ++ migrated (1.12s)
288
289 ++ migrating 1535720189
290
291 -> --
292INSERT INTO `adm_grp_action_access`
293 (`controller_name`, `action_name`, `is_ajax`, `description`, `only_top_admin`)
294VALUES ( 'admins', 'resellers-check-name', 1, 'Check if available this name for reseller', 1),
295 ( 'admins','check-ip-range-intersection', 1, 'Сheck for use of the current address or address range by another reseller', 1);
296
297 ++ migrated (0s)
298
299 ++ migrating 1535720190
300
301 -> --
302INSERT INTO `adm_grp_action_access`
303(`controller_name`, `action_name`, `is_ajax`, `description`)
304VALUES ('users', 'user-tariff-plan', 1, 'Getting packets of tariff\'s plan');
305
306 ++ migrated (0s)
307
308 ++ migrating 1535720191
309
310 -> --
311DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='index-datatable1-list-json';
312DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='index-datatable2-list-json';
313DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='index-datatable3-list-json';
314INSERT INTO `adm_grp_action_access`
315(`controller_name`, `action_name`, `is_ajax`, `view_access`, `edit_access`, `action_access`, `description`, `hidden`)
316VALUES ('index', 'datatable-devices', 1, 1, 1, 1, 'Getting data for devices table', 1),
317 ('index', 'datatable-content', 1, 1, 1, 1, 'Getting data for content table', 1),
318 ('index', 'datatable-licenses', 1, 1, 1, 1, 'Getting data for licenses keys table', 1),
319 ('index', 'datatable-storages', 1, 1, 1, 1, 'Getting data for Storages', 1),
320 ('index', 'datatable-streaming', 1, 1, 1, 1, 'Getting data for Streaming', 1);
321
322 ++ migrated (0.01s)
323
324 ++ migrating 1535720192
325
326 -> --
327INSERT INTO `adm_grp_action_access`
328(`controller_name`, `action_name`, `is_ajax`, `description`)
329VALUES
330('users', 'toggle-status', 1, 'Status changed for users'),
331('users', 'remove-users', 1, 'Remove users'),
332('users', 'change-users-reseller', 1, 'Reseller is assigned to users'),
333('users', 'clear-users-reseller', 1, 'Reseller is unassigned to users');
334
335 ++ migrated (0s)
336
337 ++ migrating 1535720193
338
339 -> --
340ALTER TABLE `video_season` MODIFY `season_number` SMALLINT NOT NULL;
341ALTER TABLE `video_season` MODIFY `season_series` SMALLINT NOT NULL DEFAULT 0;
342
343 ++ migrated (0.04s)
344
345 ++ migrating 1535720194
346
347 -> INSERT INTO `adm_grp_action_access`
348( `controller_name`, `action_name`, `is_ajax`, `description`)
349VALUES ('tv-channels', 'check-channel-name', 1, 'Checking channel name'),
350 ('tv-channels', 'check-channel-number', 1, 'Checking channel number');
351
352 ++ migrated (0s)
353
354 ++ migrating 1535720195
355
356 -> INSERT INTO `adm_grp_action_access`
357( `controller_name`, `action_name`, `is_ajax`, `description`)
358VALUES ('tariffs', 'check-tariff-name', 1, 'Checking tariff name'),
359 ('tariffs', 'check-package-name', 1, 'Checking package number');
360
361 ++ migrated (0s)
362
363 ++ migrating 1535720196
364
365 -> --
366update adm_grp_action_access set is_ajax = 0 where action_name = 'message-templates';
367
368 ++ migrated (0s)
369
370 ++ migrating 20190402162130
371
372 -> ALTER TABLE `user_log` ADD COLUMN `media_id` INT NULL DEFAULT 0;
373
374 ++ migrated (0.86s)
375
376 ++ migrating 20190402191636
377
378 -> ALTER TABLE smac_codes ADD expire_date BIGINT DEFAULT -1 NOT NULL, ADD count_cleared INT DEFAULT -1 NOT NULL, ADD count_clearing INT DEFAULT -1 NOT NULL
379
380 ++ migrated (0.85s)
381
382 ++ migrating 20190409113241
383
384Migration 20190409113241 was executed but did not result in any SQL statements.
385
386 ++ migrated (0s)
387
388 ++ migrating 20190411183424
389
390 -> ALTER TABLE smac_codes ADD end_cleared_date BIGINT DEFAULT -1 NOT NULL
391
392 ++ migrated (0.85s)
393
394 ++ migrating 20190415124322
395
396 -> --
397ALTER TABLE `smac_codes` MODIFY `status` ENUM("Not Activated", "Activated", "Blocked", "Manually entered", "Reserved")
398 DEFAULT "Not Activated";
399
400 ++ migrated (0s)
401
402 ++ migrating 20190415135112
403
404 -> ALTER TABLE smac_codes CHANGE end_cleared_date end_cleared_date BIGINT DEFAULT -1
405
406 ++ migrated (0.85s)
407
408 ++ migrating 20190422133134
409
410 -> UPDATE smac_codes SET status = "Reserved" WHERE status = "Blocked"
411
412 ++ migrated (0s)
413
414 ++ migrating 20190710145830
415
416 -> ALTER TABLE updates ADD history_hash VARCHAR(255) DEFAULT NULL
417
418 ++ migrated (0.88s)
419
420 ++ migrating 20190805112404
421
422 -> CREATE UNIQUE INDEX uid_idx ON stb_in_group (uid)
423
424 ++ migrated (0.88s)
425
426 ++ migrating 20190902093455
427
428 -> CREATE INDEX smac_certificates_uid_idx ON smac_certificates (uid)
429
430 ++ migrated (0.85s)
431
432 ++ migrating 20190902093456
433
434 -> CREATE TABLE users_devices_statistic (id INT AUTO_INCREMENT NOT NULL COMMENT 'Primary key, autoincrement', user_id INT NOT NULL COMMENT 'ID from table Users, not unique', mac VARCHAR(64) DEFAULT '' NOT NULL COMMENT 'MAC address of device, from table Users, if exists', version VARCHAR(64) DEFAULT '' NOT NULL COMMENT 'image_version of STB from table Users, can be empty string for other third party devices', operator_id VARCHAR(255) DEFAULT '' NOT NULL COMMENT 'Operator ID from config.ini, can be empty string', platform VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'client_type from table Users (STB, Android, iOS etc.), can be empty string', model VARCHAR(16) DEFAULT '' NOT NULL COMMENT 'stb_type from table Users (STB, Android, iOS etc.), can be empty string', license_key VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Users license key assigned to the current device', unique_device_hash VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'unique device hash from user devices data', fingerprint LONGBLOB NOT NULL COMMENT 'fingerprint from user devices data', added INT DEFAULT 0 NOT NULL COMMENT 'timestamp of date when device was added', UNIQUE INDEX unique_device_hash_idx (user_id, unique_device_hash), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB
435
436 ++ migrated (0.85s)
437
438 ++ migrating 20190902093702
439
440
441 [OK] Start write user device info to statistics table
442
443Migration 20190902093702 failed during Execution. Error An exception occured in driver: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
444
445In AbstractMySQLDriver.php line 103:
446
447 An exception occured in driver: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
448
449
450In PDOConnection.php line 47:
451
452 SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
453
454
455In PDOConnection.php line 43:
456
457 SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
458
459
460migrations:migrate [--write-sql] [--dry-run] [--query-time] [--allow-no-migration] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--] [<version>]
461
462Loading configuration from the integration code of your framework (setter).
463
464 Ministra DB Migrations
465
466
467WARNING! You have 2 previously executed migrations in the database that are not registered migrations.
468 >> ()
469 >> ()
470Migrating down to 1535720165 from 20190902093456
471
472 -- reverting 20190902093456
473
474 -> DROP TABLE users_devices_statistic
475
476 -- reverted (0.83s)
477
478 -- reverting 20190902093455
479
480 -> DROP INDEX smac_certificates_uid_idx ON smac_certificates
481
482 -- reverted (0.82s)
483
484 -- reverting 20190805112404
485
486 -> DROP INDEX uid_idx ON stb_in_group
487
488 -- reverted (0.86s)
489
490 -- reverting 20190710145830
491
492 -> ALTER TABLE updates DROP history_hash
493
494 -- reverted (0.89s)
495
496 -- reverting 20190422133134
497
498 -> UPDATE smac_codes SET status = "Blocked" WHERE status = "Reserved"
499
500 -- reverted (0s)
501
502 -- reverting 20190415135112
503
504 -> ALTER TABLE smac_codes CHANGE end_cleared_date end_cleared_date BIGINT DEFAULT -1 NOT NULL
505
506 -- reverted (0.87s)
507
508 -- reverting 20190415124322
509
510 -> ALTER TABLE `smac_codes` MODIFY `status` ENUM("Not Activated", "Activated", "Blocked") DEFAULT "Not Activated";
511--
512
513 -- reverted (0.01s)
514
515 -- reverting 20190411183424
516
517 -> ALTER TABLE smac_codes DROP end_cleared_date
518
519 -- reverted (0.87s)
520
521 -- reverting 20190409113241
522
523Migration 20190409113241 was executed but did not result in any SQL statements.
524
525 -- reverted (0s)
526
527 -- reverting 20190402191636
528
529 -> ALTER TABLE smac_codes DROP expire_date, DROP count_cleared, DROP count_clearing
530
531 -- reverted (0.89s)
532
533 -- reverting 20190402162130
534
535 -> ALTER TABLE `user_log` DROP COLUMN `media_id`;
536
537 -- reverted (0.03s)
538
539 -- reverting 1535720196
540
541Migration 1535720196 was executed but did not result in any SQL statements.
542
543 -- reverted (0s)
544
545 -- reverting 1535720195
546
547 -> DELETE FROM `adm_grp_action_access` WHERE controller_name='tariffs' AND action_name='check-package-name';
548DELETE FROM `adm_grp_action_access` WHERE controller_name='tariffs' AND action_name='check-tariff-name';
549--
550
551 -- reverted (0s)
552
553 -- reverting 1535720194
554
555 -> DELETE FROM `adm_grp_action_access` WHERE controller_name='tv-channels' AND action_name='check-channel-number';
556DELETE FROM `adm_grp_action_access` WHERE controller_name='tv-channels' AND action_name='check-channel-name';
557--
558
559 -- reverted (0s)
560
561 -- reverting 1535720193
562
563 -> ALTER TABLE `video_season` MODIFY `season_series` TINYINT NOT NULL DEFAULT 0;
564ALTER TABLE `video_season` MODIFY `season_number` TINYINT NOT NULL;
565--
566
567 -- reverted (0.04s)
568
569 -- reverting 1535720192
570
571 -> DELETE FROM `adm_grp_action_access` WHERE controller_name='users' AND action_name='toggle-status';
572DELETE FROM `adm_grp_action_access` WHERE controller_name='users' AND action_name='remove-users';
573DELETE FROM `adm_grp_action_access` WHERE controller_name='users' AND action_name='change-users-reseller';
574DELETE FROM `adm_grp_action_access` WHERE controller_name='users' AND action_name='clear-users-reseller';
575--
576
577 -- reverted (0.01s)
578
579 -- reverting 1535720191
580
581 -> DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-devices';
582DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-content';
583DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-licenses';
584DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-storages';
585DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-streaming';
586INSERT INTO `adm_grp_action_access`
587(`controller_name`, `action_name`, `is_ajax`, `view_access`, `edit_access`, `action_access`, `description`, `hidden`)
588VALUES ('index', 'index-datatable1-list-json', 1, 1, 1, 1, 'Getting data for index page', 1),
589 ('index', 'index-datatable2-list-json', 1, 1, 1, 1, 'Getting data for index page', 1),
590 ('index', 'index-datatable3-list-json', 1, 1, 1, 1, 'Getting data for index page', 1);
591--
592
593 -- reverted (0.01s)
594
595 -- reverting 1535720190
596
597Migration 1535720190 was executed but did not result in any SQL statements.
598
599 -- reverted (0s)
600
601 -- reverting 1535720189
602
603Migration 1535720189 was executed but did not result in any SQL statements.
604
605 -- reverted (0s)
606
607 -- reverting 1535720188
608
609 -> DROP TABLE `resellers_ips_ranges`;
610ALTER TABLE users DROP COLUMN last_change_ip;
611ALTER TABLE reseller DROP COLUMN use_ip_ranges;
612--
613
614 -- reverted (1.12s)
615
616 -- reverting 1535720187
617
618 -> ALTER TABLE `video` DROP `admin_id`;
619--
620
621 -- reverted (1.16s)
622
623 -- reverting 1535720186
624
625 -> ALTER TABLE `notification_feed` DROP INDEX `deleted`;
626ALTER TABLE `notification_feed` DROP COLUMN `deleted`;
627--
628
629 -- reverted (0.03s)
630
631 -- reverting 1535720185
632
633 -> UPDATE `karaoke` SET `protocol` = `protocol_old`;
634ALTER TABLE `karaoke` DROP `protocol_old`;
635--
636
637 -- reverted (0.01s)
638
639 -- reverting 1535720184
640
641 -> truncate table `course_cache`;
642ALTER TABLE `course_cache` DROP COLUMN `provider`;
643ALTER TABLE `course_cache` DROP COLUMN `exchange_date`;
644ALTER TABLE `course_cache` DROP COLUMN `code`;
645ALTER TABLE `course_cache` DROP COLUMN `currency`;
646ALTER TABLE `course_cache` DROP COLUMN `nominal`;
647ALTER TABLE `course_cache` DROP COLUMN `value`;
648ALTER TABLE `course_cache` ADD COLUMN `url` varchar(255) NOT NULL default '';
649ALTER TABLE `course_cache` ADD COLUMN `content` text;
650ALTER TABLE `course_cache` ADD COLUMN `crc` varchar(64) NOT NULL default '';
651ALTER TABLE `course_cache` ADD UNIQUE INDEX (`crc`);
652--
653
654 -- reverted (0.91s)
655
656 -- reverting 1535720183
657
658 -> ALTER TABLE `smac_certificates` DROP `repaired_date`;
659--
660
661 -- reverted (0.03s)
662
663 -- reverting 1535720182
664
665 -> ALTER TABLE `video` MODIFY `rating_kinopoisk` VARCHAR(64);
666ALTER TABLE `video` MODIFY `rating_count_kinopoisk` VARCHAR(64);
667ALTER TABLE `video` MODIFY `rating_imdb` VARCHAR(64);
668ALTER TABLE `video` MODIFY `rating_count_imdb` VARCHAR(64);
669--
670
671 -- reverted (2.39s)
672
673 -- reverting 1535720181
674
675 -> ALTER TABLE `ch_links` DROP `flexcdn_auth_support`;
676--
677
678 -- reverted (0.05s)
679
680 -- reverting 1535720180
681
682Migration 1535720180 was executed but did not result in any SQL statements.
683
684 -- reverted (0s)
685
686 -- reverting 1535720179
687
688 -> ALTER TABLE `media_claims` DROP INDEX `media_type_id`;
689ALTER TABLE `video_series_files` DROP INDEX `video_id_idx`;
690--
691
692 -- reverted (0.01s)
693
694 -- reverting 1535720178
695
696Migration 1535720178 was executed but did not result in any SQL statements.
697
698 -- reverted (0s)
699
700 -- reverting 1535720177
701
702Migration 1535720177 was executed but did not result in any SQL statements.
703
704 -- reverted (0s)
705
706 -- reverting 1535720176
707
708Migration 1535720176 was executed but did not result in any SQL statements.
709
710 -- reverted (0s)
711
712 -- reverting 1535720175
713
714Migration 1535720175 was executed but did not result in any SQL statements.
715
716 -- reverted (0s)
717
718 -- reverting 1535720174
719
720Migration 1535720174 was executed but did not result in any SQL statements.
721
722 -- reverted (0s)
723
724 -- reverting 1535720173
725
726 -> ALTER TABLE users DROP COLUMN clock_format;
727--
728
729 -- reverted (1.11s)
730
731 -- reverting 1535720172
732
733Migration 1535720172 was executed but did not result in any SQL statements.
734
735 -- reverted (0s)
736
737 -- reverting 1535720171
738
739Migration 1535720171 was executed but did not result in any SQL statements.
740
741 -- reverted (0s)
742
743 -- reverting 1535720170
744
745Migration 1535720170 was executed but did not result in any SQL statements.
746
747 -- reverted (0s)
748
749 -- reverting 1535720169
750
751Migration 1535720169 was executed but did not result in any SQL statements.
752
753 -- reverted (0s)
754
755 -- reverting 1535720168
756
757Migration 1535720168 was executed but did not result in any SQL statements.
758
759 -- reverted (0s)
760
761 -- reverting 1535720167
762
763 -> ALTER TABLE `settings` DROP `default_launcher_template`;
764--
765
766 -- reverted (0.03s)
767
768 -- reverting 1535720166
769
770 -> DROP TABLE `themes`;
771--
772
773 -- reverted (0s)
774
775 ------------------------
776
777 ++ finished in 12.98s
778 ++ 42 migrations executed
779 ++ 27 sql queries
780Failed run migration command
781
782BUILD FAILED
783/var/www/stalker_portal/deploy/build.xml:362:12: /var/www/stalker_portal/deploy/build.xml:368:26: Migrations run failed
784Total time: 1 minutes 2.07 seconds