Comment to 'Pruning Table'
Comment to Pruning Table
  • The sys_storage_tokens table is already 10.1GB in my database. Can it be safely emptied?

    @Andrey Yasko @Alex T⚜️ @Leonid S

    • Hello @Antonio !

      You may try to launch the following commands in your UNA database managing panel:

      RENAME TABLE `sys_storage_tokens` TO `sys_storage_tokens_old`;
      CREATE TABLE IF NOT EXISTS `sys_storage_tokens` (
       `iid` int(11) NOT NULL AUTO_INCREMENT,
       `id` int(11) NOT NULL,
       `object` varchar(64) NOT NULL,
       `hash` varchar(32) NOT NULL,
       `created` int(10) unsigned NOT NULL,
       PRIMARY KEY (`iid`),
       UNIQUE KEY `id` (`id`,`object`,`hash`),
       KEY `created` (`created`)
      );
      

      And check the work of your UNA site. If it is OK - then drop the `sys_storage_tokens_old` table.