J
jmgallardo

  • Mar 6, 2022
  • Joined Jul 14, 2017
  • 0 best answers
  • Hello people.
    I am trying for a long, the design of a mysql query that show me all the thread entries that my Osticket has grouped for companies of customers.
    It is difficult for me, because I'm new in MYSQL issues, but I need it to create a simple dashboard with my customers work load.
    Can you help me, please?

    Thanks in advanced.

  • You are totally right.
    I don't know, but it was modified recently.

    Regards @ntozier.

  • Yes. That is it.
    If I attach a pdf file with 1.6MB size, I have the error.
    The file size is put to 10Mbps

  • Hola.
    Autocloser funciona bien en la 15.2.

  • Hi people.
    After 1.15.2 upgrade task, I have seen that we have problems to upload files in the answers section.

    Explain: if I open a new ticket from agent control panel, I can attach several files, I have tested up to two files of 1.6MB without problems.
    If I open the ticket, and I try to add the attachment in the answer, I receive the error:
    File Upload Error
    filename.pdf
    File is too large
    undefined

    I have:
    Información del servidor
    Versión osTicket v1.15.2 (cb6766e) — Hasta la fecha
    Servidor del Software Web Apache/2.4.29 (Ubuntu)
    Versión MySQL 5.7.34
    Versión PHP 7.4.18
    Extensiones PHP
    gdlib Utilizado para la manipulación de imagen e impresión en PDF
    imap Usado para la recuperación del Email
    xml API XML
    xml-dom Utilizado para el procesado de Email en HTML
    json Mejora el desempeño de creación y el procesamiento JSON
    mbstring Altamente recomendado para el contenido en idiomas europeos que no sean del oeste
    phar Altamente recomendao para los paquetes de idioma y complementos
    intl Altamente recomendado para el contenido en idiomas europeos que no sean del oeste
    fileinfo Usar para detectar tipos de ficheros subidos
    zip Used for ticket and task exporting
    APCu Mejora el rendimiento general
    Zend Opcache Mejora el rendimiento general
    Configuración de PHP
    cgi.fix_pathinfo se recomienda "1" Si el AJAX no funciona
    date.timezone Europe/Madrid
    Información y uso de base de datos
    Esquema osticket (localhost:/run/mysqld/mysqld.sock)
    Firma del esquema add628927ee030469f5d3272ebda1e16
    Espacio ocupado 390.33 MiB
    Espacio para adjuntos 265.52 MiB
    Zona horaria CEST (Se interpreta como Europe/Berlin)

    In the PHP 7.4 config:

    upload_max_filesize = 10M
    post_max_size = 8M
    memory_limit = -1

    • Hi people.
      We are trying to use the fabulous autocloser plugin, and it is good.
      Anyway, we have a little issue, which resolved, will make perfect the plugin.
      We receive (assignment) the tickets in a team, so we need to change the plugin's config to choose a user like a robot.
      When we choose the user and save the config, the robot come back to ONLY Send as Ticket's assigned...

      Do you know how to fix it and allow any user, please?

      Regards.