Re: ?==?utf-8?q? cannot use mariadb usin g Interchange
"CSS Support" <[email protected]> Wed, 19 Dec 2018 02:27:59 -0600
| Newsgroups | gmane.comp.web.interchange.users |
|---|---|
| Message-ID | <f3a-5c1a0100-43-14dbb4e0@186077316> |
--===============3980841169778240916== Content-Type: multipart/alternative; boundary="----=_=-_OpenGroupware_org_NGMime-3898-1545208079.471008-28------" ------=_=-_OpenGroupware_org_NGMime-3898-1545208079.471008-28------ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-Length: 2294 Hi, I am using DBD::mysql 4.049.=C2=A0 I Thanks for your help [root@store ~]# cpan -l | grep DBD::mysql Loading internal null logger. Install Log::Log4perl for logging message= s Bundle::DBD::mysql =C2=A0 =C2=A0 =C2=A04.049 DBD::mysql =C2=A0 =C2=A0 =C2=A04.049 DBD::mysql::GetInfo =C2=A0 =C2=A0 undef Bundle::DBD::mysql =C2=A0 =C2=A0 =C2=A04.049 DBD::mysql =C2=A0 =C2=A0 =C2=A04.049 DBD::mysql::GetInfo =C2=A0 =C2=A0 undef [root@store ~]# On Monday, December 17, 2018 08:56 CST, David Christensen <david@endpoi= nt.com> wrote: =C2=A0> I could really use some assistance with my interchange. I am us= ing Nethserver 7 with perlbrew and perl 5.10.-1. I upgraded to IC 5.10 = from rpm installation from interchange-5.2.0-1. > > I got an DBM database running with IC 5.2. However, After I got DBD:M= ysql installed I get error on creation of indexes of tables. Nethserver= uses mariadb-5.5.60. > > [16/December/2018:20:30:18 -0600] cssstore - DBI: Post creation query= 'CREATE INDEX `tree`=5F`parent=5Ffld` ON `tree` (`parent=5Ffld`)' fail= ed: You have an error in your SQL syntax; check the manual that corresp= onds to your MariaDB server version for the right syntax to use near '=5F= `parent=5Ffld` ON `tree` (`parent=5Ffld`)' at line 1 Hi, It looks like the DBI->quote=5Fidentifier() function is returning value= s that MariaDB doesn=E2=80=99t know how to interpret. Which version of = the DBD::mysql driver are you use? [root@store ~]# cpan -l | grep DBD::mysql Loading internal null logger. Install Log::Log4perl for logging message= s Bundle::DBD::mysql =C2=A0 =C2=A0 =C2=A04.049 DBD::mysql =C2=A0 =C2=A0 =C2=A04.049 DBD::mysql::GetInfo =C2=A0 =C2=A0 undef Bundle::DBD::mysql =C2=A0 =C2=A0 =C2=A04.049 DBD::mysql =C2=A0 =C2=A0 =C2=A04.049 DBD::mysql::GetInfo =C2=A0 =C2=A0 undef [root@store ~]# You could try to work around it by turning off QUOTE=5FIDENTIFIERS; som= ething like: DatabaseDefault QUOTE=5FIDENTIFIERS 0 It is possible this will introduce its own set of issues if any of the = column names in any of the tables clash with reserved words; if so, you= could try to narrow the scope to just the tables you=E2=80=99re having= problems with. HTH, David -- David Christensen End Point Corporation [email protected] 785-727-1171 =C2=A0 =C2=A0 ------=_=-_OpenGroupware_org_NGMime-3898-1545208079.471008-28------ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-Length: 2768 <html>Hi,<br /><br />I am using DBD::mysql 4.049. I<br /><br />Th= anks for your help<br /><br />[root@store ~]# cpan -l | grep DBD::mysql= <br />Loading internal null logger. Install Log::Log4perl for logging m= essages<br />Bundle::DBD::mysql 4.049<br />DBD::mys= ql 4.049<br />DBD::mysql::GetInfo und= ef<br />Bundle::DBD::mysql 4.049<br />DBD::mysql &n= bsp; 4.049<br />DBD::mysql::GetInfo undef<br= />[root@store ~]#<br />On Monday, December 17, 2018 08:56 CST, David C= hristensen <[email protected]> wrote:<br /> <blockquote typ= e=3D"cite" cite=3D"[email protected]">&= gt; I could really use some assistance with my interchange. I am using = Nethserver 7 with perlbrew and perl 5.10.-1. I upgraded to IC 5.10 from= rpm installation from interchange-5.2.0-1.<br />><br />> I got a= n DBM database running with IC 5.2. However, After I got DBD:Mysql inst= alled I get error on creation of indexes of tables. Nethserver uses mar= iadb-5.5.60.<br />><br />> [16/December/2018:20:30:18 -0600] csss= tore - DBI: Post creation query 'CREATE INDEX `tree`=5F`parent=5Ffld` O= N `tree` (`parent=5Ffld`)' failed: You have an error in your SQL syntax= ; check the manual that corresponds to your MariaDB server version for = the right syntax to use near '=5F`parent=5Ffld` ON `tree` (`parent=5Ffl= d`)' at line 1<br /><br /><br />Hi,<br /><br />It looks like the DBI-&g= t;quote=5Fidentifier() function is returning values that MariaDB doesn=E2= =80=99t know how to interpret. Which version of the DBD::mysql driver a= re you use?<br /><br /><br />[root@store ~]# cpan -l | grep DBD::mysql<= br />Loading internal null logger. Install Log::Log4perl for logging me= ssages<br />Bundle::DBD::mysql 4.049<br />DBD::mysq= l 4.049<br />DBD::mysql::GetInfo unde= f<br />Bundle::DBD::mysql 4.049<br />DBD::mysql &nb= sp; 4.049<br />DBD::mysql::GetInfo undef<br = />[root@store ~]#<br /><br />You could try to work around it by turning= off QUOTE=5FIDENTIFIERS; something like:<br /><br />DatabaseDefault QU= OTE=5FIDENTIFIERS 0<br /><br />It is possible this will introduce its o= wn set of issues if any of the column names in any of the tables clash = with reserved words; if so, you could try to narrow the scope to just t= he tables you=E2=80=99re having problems with.<br /><br />HTH,<br /><br= />David<br />--<br />David Christensen<br />End Point Corporation<br /= >[email protected]<br />785-727-1171<br /><br /> </blockquote><br= /><br /><br /> </html> ------=_=-_OpenGroupware_org_NGMime-3898-1545208079.471008-28-------- --===============3980841169778240916== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KaW50ZXJjaGFu Z2UtdXNlcnMgbWFpbGluZyBsaXN0CmludGVyY2hhbmdlLXVzZXJzQGludGVyY2hhbmdlY29tbWVy Y2Uub3JnCmh0dHBzOi8vd3d3LmludGVyY2hhbmdlY29tbWVyY2Uub3JnL21haWxtYW4vbGlzdGlu Zm8vaW50ZXJjaGFuZ2UtdXNlcnM= --===============3980841169778240916==--