L
Luchnikovv

  • Sep 2, 2019
  • Joined Nov 7, 2017
  • 0 best answers
  • In Deletion of old attachments

    Well, i've tested it on copy of server, and there slight issues with it:
    1. Custom backgrounds and logos also got included by querie ntozier posted, so i included filter by ost_file.key (or mabye its better by ost_file.id itslef?).
    2. There still icon of attachment on the ticket without attachment, which confuses people.

    this working fine for me (mysql Ver 14.14 Distrib 5.7.15):

    DELETE `ost_file`, `ost_file_chunk` FROM ost_file 
LEFT JOIN ost_file_chunk ON ost_file.id = ost_file_chunk.file_id 
WHERE ost_file.created < NOW() - INTERVAL 180 DAY AND ost_file.key
NOT IN('key_of_logo_1','key_of_scp_bg_1','key_of_logo_2','key_of_scp_bg_2',...etc);

    PS: im not responsible if you damage your production db by this query.

    ntozier always back up your database before you run any sql queries against it

      • In Deletion of old attachments

        Hello, i have moved my attachements from db to fs via plugin "Attachments on the filesystem", but files and folders are not in human readable format like (attachments_folder/month_of_uploading/date/*). How can i find and delete attachments older than 180 days?

      • In Drag&drop issues with regular files
      • In Drag&drop issues with regular files
      • In [resolved] osticket 1.10 pop up blank

        Well changining my webserver to apache2 fixed this problem

      • In [resolved] osticket 1.10 pop up blank
      • In [resolved] osticket 1.10 pop up blank

        nginx configserver {

        listen 80;

        server_name xxxxxx;

        root /var/www/html/osticket/upload/;

        access_log /var/log/nginx/access.log;

        error_log /var/log/nginx/error.log;

        index index.php;

        client_max_body_size 2000M;

        client_body_buffer_size 100M;

        client_header_buffer_size 10M;

        large_client_header_buffers 2 10M;

        client_body_timeout 12;

        client_header_timeout 12;

        keepalive_timeout 15;

        send_timeout 10;

        gzip on;

        gzip_comp_level 2;

        gzip_min_length 1000;

        gzip_proxied expired no-cache no-store private auth;

        gzip_types text/plain application/x-javascript text/xml text/css application/xml;

        set $path_info "";

        location ~ /include {

        deny all;

        return 403;

        }

        if ($request_uri ~ "^/api(+)") {

        set $path_info $1;

        }

        location ~ ^/api/(?|tasks).*$ {

        try_files $uri $uri/ /api/http.php?$query_string;

        }

        if ($request_uri ~ "^/scp/.*\.php(+)") {

        set $path_info $1;

        }

        location ~ ^/scp/ajax.php/.*$ {

        try_files $uri $uri/ /scp/ajax.php?$query_string;

        }

        location / {

        try_files $uri $uri/ index.php;

        }

        location ~ \.php$ {

        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

        include fastcgi_params;

        include snippets/fastcgi-php.conf;

        fastcgi_pass unix:/run/php/php7.0-fpm.sock;

        fastcgi_param PATH_INFO $path_info;

        }

        }

      • In [resolved] osticket 1.10 pop up blank

        New install of 1.10 Everytime I hover over "?" the help / tip pop up block comes up blank and when i trying to delete tickets same blank block appears. osTicket Versionv1.10Web Server Softwarenginx\1.10.3MySQL Version14.4\distrib 5.7.20PHP Version7.0