[imp] VFS(mysql backend) problem,CVS

[David Chang]

Thanks for your reply,Daniel.

After chang logging mode to DEBUG,this message was recorded at /tmp/horde.log

Dec 04 17:09:05 HORDE [debug] [imp] DB Error: syntax error: INSERT INTO horde_vf
s (vfs_id, vfs_type, vfs_path, vfs_name, vfs_modified, vfs_owner, vfs_data) VALU
ES (43, 1, '.horde/imp/compose', 'b55dd19678a4fcebf264cba932af9b60', 1070528945,
 '',
'?赨0^PJFIF\0^A^A\0\0^A\0^A\0\0茻0C\0^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^
A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^
A^A^A^A^A^A^A茻0C^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A
^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A餐0^Q^H\0c\
0~V^C^A\"\0^B^Q^A^C^Q^A孀0^_\0\0^A^E^A^A^A^A^A^A\0\0\0\0\0\0\0\0^A^B^C^D^E^F^G^
H      
\n^K孀0琴P\0^B^A^C^C^B^D^C^E^E^D^D\0\0^A}^A^B^C\0^D^Q^E^R!1A^F^SQa^G\"q
^T2~A~Q）H#B掄^UR栮$3br~B      
\n^V^W^X^Y\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefgh
ijstuvwxyz~C~D~E~F~G~H~I~J~R~S~T~U~V~W~X~Y~Z╯丰戍貝玨陷絮溢劃藏霰弅衲欶趹欹
摵蜠樉賥濋嚦黀蘜蠲╭孀0^_^A\0^C^A^A^A^A^A^A^A^A^A\0\0\0\0\0\0^A^B^C^D^E^F^G^H
\n^K孀0琴Q\0^B^A^B^D^D^C^D^G^E^D^D\0^A^Bw\0^A^B^C^Q^D^E!1^F^RAQ^Gaq^S\"2~A^H^TB

Any thing else i lose ?

David Chang


引用 Daniel Eckl <daniel.eckl at gmx.de>:

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