[imp] VFS(mysql backend) problem,CVS

[David Chang]

I think that is back-slash cause such problem,and back-slash was generated by
IMP.


引用 David Chang <david at tmv.gov.tw>:

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