[imp] VFS(mysql backend) problem,CVS

[David Chang]

Got this error message at compose window while tring attache binary file(.jpg):
DB Error: syntax error

Screenshot see http://www.tmv.gov.tw/~txg16/img/tmp/vfs_error.jpg

Note: This problem was happen only for  binary attache file.Text file is OK.

Here is my situation:
1.IMP 4.0 cvs ,imp/config/conf.php
----------------------------------
$conf['compose']['use_vfs'] = true;

2.Horde 3.0 cvs,horde/config/conf.php
-------------------------------------
$conf['vfs']['type'] = 'sql';

3.Table schema of prefs_vfs:
----------------------------
CREATE TABLE horde_vfs (
    vfs_id        BIGINT NOT NULL,
    vfs_type      SMALLINT NOT NULL,
    vfs_path      VARCHAR(255) NOT NULL,
    vfs_name      VARCHAR(255) NOT NULL,
    vfs_modified  BIGINT NOT NULL,
    vfs_owner     VARCHAR(255) NOT NULL,
    vfs_data      LONGBLOB,
    PRIMARY KEY   (vfs_id)
);

CREATE INDEX vfs_path_idx ON horde_vfs (vfs_path);
CREATE INDEX vfs_name_idx ON horde_vfs (vfs_name);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_vfs TO horde;


4. Env http://210.241.49.68/horde.beta/test.php

David Chang