[imp] VFS(mysql backend) problem,CVS

[Daniel Eckl]

Hi David!

Perhaps you get a better error message when setting the horde logging to DEBUG
in horde/config/conf.php and triggering the error again.

Greets,
Daniel

Zitat von David Chang <david at tmv.gov.tw>:

> 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
>
> --
> IMP mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org
>
>
>