Hello,

we are using osticket and currently the Database is something around 4,5GB. If I will install the Storage :: Attachments on the Filesystem - what happens with the existing Attachments which are saved in the Database?

Unfortenately there is no documentation for the Plugin?

    vollkommenIrrelevant If I will install the Storage :: Attachments on the Filesystem - what happens with the existing Attachments which are saved in the Database?

    Nothing. They are still where they are (in the database).
    Once you configure and and enable the plugin, and then tell osTicket to use it new attachments will be saved on the Filesystem. (note: go to Admin panel -> Settings -> System and see Store Attachments.)

    IF you actually want to make the database smaller you would migrate the attachments from the DB to the Filesystem.
    To do this open a command prompt and run the following command:
    php setup/cli/manage.php file migrate --backend D --to F --limit=20

    You can change the --limit=## to whatever you want or remove the directive, but I recommend that you make it something sane. You will have to run the command multiple times.

    There is a blog post about this on osTicket.com.

      3 months later

      Well - i put storage-fs.phar into the plugin folder and press und "install" in osticket. The Window loading is popup, but after closing the plugin is not visible. The PHP log is showing no errors, but there is a DB-error:

      [INSERT INTO ost_plugin SET installed=NOW() , install_path='plugins/storage-fs.phar', name='Attachments on the filesystem', isphar=1, version=0.3]

      Unknown column 'version' in 'field list'<br /> <br />
      ---- Ablaufverfolgung ----<br />
      #0 D:\Websites\xxx\osticket\include\mysqli.php(200): osTicket->logDBError('DB Error #1054', '[INSERT INTO os...')<br />
      #1 D:\Websites\xxx\osticket\include\class.plugin.php(353): db_query('INSERT INTO ost...')<br />
      #2 D:\Websites\xxx\osticket\scp\plugins.php(51): PluginManager->install('plugins/storage...')<br />
      #3 {main}

      After adding a column in DB (version/varchar(30)) everything seems fine.

      @ntozier
      Of course search is my friend. I'm very happy with my friend :-)
      But it makes much more sense if you improve the installer that he will add the column if it is not existing...

      It was just discovered 6 days ago. It has already been taken care of and will be in the next release.

      Write a Reply...