[gollem] Gollem Error When Cut/Pasting File From one folder to another (sounds like #12106)

[Andy Dorman]

We are experimenting with Gollem 3.0.1 (Horde 5.1.1)

We use PostgreSQL.  The Gollem config was set from the web UI with 
$conf[backend][backend_list] = None and is about as simple as it gets...

/etc/horde/gollem/backends.d/10-webmail.php
<?php
$backends['ftp']['disabled'] = true;
$backends['sqlhome']['disabled'] = false;
$backends['sqlhome']['name'] = 'Home';

We have not made any other config changes.

Anyway, we ran across a problem when trying to cut & paste a file from 
one folder to another.  I researched and this may be #12106 that was 
reported last March but has been unconfirmed.

http://bugs.horde.org/ticket/12106

Here is what happened for us:

- After logging in I opened my Home folder and selected the file
- click on "Cut"
- click on the destination folder (IronicDesign in this case)
- once in the new folder, click on the Clipboard
- select the file in the clipboard and click Paste

The web site responded with the error page below.  A later check shows 
the file was moved to the new folder successfully.


A fatal error has occurred

Unable to load SQL data.

1. Gollem::moveFile() /usr/share/horde/gollem/manager.php:169
2. Gollem::_copyFile() /usr/share/horde/gollem/lib/Gollem.php:480
3. Gollem::moveFile() /usr/share/horde/gollem/manager.php:169
4. Gollem::_copyFile() /usr/share/horde/gollem/lib/Gollem.php:480
5. Horde_Vfs_Sql->read() /usr/share/horde/gollem/lib/Gollem.php:550
6. Horde_Vfs_Sql->_readBlob() /usr/share/php/Horde/Vfs/Sql.php:145
Details

The full error message is logged in Horde's log file, and is shown below 
only to administrators. Non-administrative users will not see error details.

Gollem_Exception Object
(
     [details] =>
     [logged] => 1
     [_logLevel:protected] => 0
     [message:protected] => Unable to load SQL data.
     [string:Exception:private] =>
     [code:protected] => 0
     [file:protected] => /usr/share/horde/gollem/lib/Gollem.php
     [line:protected] => 560
     [trace:Exception:private] => Array
         (
             [0] => Array
                 (
                     [file] => /usr/share/horde/gollem/lib/Gollem.php
                     [line] => 480
                     [function] => _copyFile
                     [class] => Gollem
                     [type] => ::
                     [args] => Array
                         (
                             [0] => move
                             [1] => sqlhome
                             [2] => /home/andydorman at comehome.net
                             [3] => Maintainable_JavaScript.pdf
                             [4] => sqlhome
                             [5] => 
/home/andydorman at comehome.net/IronicDesign
                         )

                 )

             [1] => Array
                 (
                     [file] => /usr/share/horde/gollem/manager.php
                     [line] => 169
                     [function] => moveFile
                     [class] => Gollem
                     [type] => ::
                     [args] => Array
                         (
                             [0] => sqlhome
                             [1] => /home/andydorman at comehome.net
                             [2] => Maintainable_JavaScript.pdf
                             [3] => sqlhome
                             [4] => 
/home/andydorman at comehome.net/IronicDesign
                         )

                 )

         )

     [previous:Exception:private] => Horde_Vfs_Exception Object
         (
             [details] =>
             [logged] =>
             [_logLevel:protected] => 0
             [message:protected] => Unable to load SQL data.
             [string:Exception:private] =>
             [code:protected] => 0
             [file:protected] => /usr/share/php/Horde/Vfs/Sql.php
             [line:protected] => 660
             [trace:Exception:private] => Array
                 (
                     [0] => Array
                         (
                             [file] => /usr/share/php/Horde/Vfs/Sql.php
                             [line] => 145
                             [function] => _readBlob
                             [class] => Horde_Vfs_Sql
                             [type] => ->
                             [args] => Array
                                 (
                                     [0] => horde_vfs
                                     [1] => vfs_data
                                     [2] => Array
                                         (
                                             [vfs_path] => 
home/andydorman at comehome.net
                                             [vfs_name] => 
Maintainable_JavaScript.pdf
                                         )

                                 )

                         )

                     [1] => Array
                         (
                             [file] => 
/usr/share/horde/gollem/lib/Gollem.php
                             [line] => 550
                             [function] => read
                             [class] => Horde_Vfs_Sql
                             [type] => ->
                             [args] => Array
                                 (
                                     [0] => /home/andydorman at comehome.net
                                     [1] => Maintainable_JavaScript.pdf
                                 )

                         )

                     [2] => Array
                         (
                             [file] => 
/usr/share/horde/gollem/lib/Gollem.php
                             [line] => 480
                             [function] => _copyFile
                             [class] => Gollem
                             [type] => ::
                             [args] => Array
                                 (
                                     [0] => move
                                     [1] => sqlhome
                                     [2] => /home/andydorman at comehome.net
                                     [3] => Maintainable_JavaScript.pdf
                                     [4] => sqlhome
                                     [5] => 
/home/andydorman at comehome.net/IronicDesign
                                 )

                         )

                     [3] => Array
                         (
                             [file] => /usr/share/horde/gollem/manager.php
                             [line] => 169
                             [function] => moveFile
                             [class] => Gollem
                             [type] => ::
                             [args] => Array
                                 (
                                     [0] => sqlhome
                                     [1] => /home/andydorman at comehome.net
                                     [2] => Maintainable_JavaScript.pdf
                                     [3] => sqlhome
                                     [4] => 
/home/andydorman at comehome.net/IronicDesign
                                 )

                         )

                 )

             [previous:Exception:private] =>
         )

)

Our Horde log showed this at the same time

2013-07-09T15:23:40.504516-05:00 yorick HORDE: [gollem] Unable to load 
SQL data. [pid 15115 on line 560 of 
"/usr/share/horde/gollem/lib/Gollem.php"]
2013-07-09T15:23:40.754746-05:00 yorick HORDE: User is not authorized 
for horde [pid 15115 on line 267 of "/usr/share/php/Horde/Registry.php"]

I will keep looking at this and see if I can figure something out.  But 
since I have just begun working with Gollem I hoped this information 
might help someone more knowledgeable figure out what is going wrong.

-- 
Andy Dorman