Re: ?==?utf-8?q? cannot use mariadb usin g Interchange
"CSS Support" <[email protected]> Tue, 18 Dec 2018 01:58:25 -0600
| Newsgroups | gmane.comp.web.interchange.users |
|---|---|
| Message-ID | <f3a-5c18a880-39-14dbb4e0@186043029> |
--===============6875029392571019801== Content-Type: multipart/alternative; boundary="----=_=-_OpenGroupware_org_NGMime-3898-1545119905.258945-21------" ------=_=-_OpenGroupware_org_NGMime-3898-1545119905.258945-21------ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-Length: 1544 Hi, Thanks for your response. where sholud this be placed. Thanks, M 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? 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-1545119905.258945-21------ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-Length: 1898 <html>Hi,<br /><br />Thanks for your response. where sholud this be pla= ced.<br /><br />Thanks,<br /><br />M<br />On Monday, December 17, 2018 = 08:56 CST, David Christensen <[email protected]> wrote:<br />&nb= sp;<blockquote type=3D"cite" cite=3D"BE4550E3-56CF-4061-A638-01856AFFDD= [email protected]">> I could really use some assistance with my interc= hange. I am using Nethserver 7 with perlbrew and perl 5.10.-1. I upgrad= ed to IC 5.10 from rpm installation from interchange-5.2.0-1.<br />>= <br />> I got an DBM database running with IC 5.2. However, After I = got DBD:Mysql installed I get error on creation of indexes of tables. N= ethserver uses mariadb-5.5.60.<br />><br />> [16/December/2018:20= :30:18 -0600] cssstore - DBI: Post creation query 'CREATE INDEX `tree`=5F= `parent=5Ffld` ON `tree` (`parent=5Ffld`)' failed: You have an error in= your SQL syntax; check the manual that corresponds to your MariaDB ser= ver version for the right syntax to use near '=5F`parent=5Ffld` ON `tre= e` (`parent=5Ffld`)' at line 1<br /><br /><br />Hi,<br /><br />It looks= like the DBI->quote=5Fidentifier() function is returning values tha= t MariaDB doesn=E2=80=99t know how to interpret. Which version of the D= BD::mysql driver are you use?<br /><br />You could try to work around i= t by turning off QUOTE=5FIDENTIFIERS; something like:<br /><br />Databa= seDefault QUOTE=5FIDENTIFIERS 0<br /><br />It is possible this will int= roduce its own set of issues if any of the column names in any of the t= ables clash with reserved words; if so, you could try to narrow the sco= pe to just the tables you=E2=80=99re having problems with.<br /><br />H= TH,<br /><br />David<br />--<br />David Christensen<br />End Point Corp= oration<br />[email protected]<br />785-727-1171<br /><br /><br />&nbs= p;</blockquote><br /><br /><br /> </html> ------=_=-_OpenGroupware_org_NGMime-3898-1545119905.258945-21-------- --===============6875029392571019801== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KaW50ZXJjaGFu Z2UtdXNlcnMgbWFpbGluZyBsaXN0CmludGVyY2hhbmdlLXVzZXJzQGludGVyY2hhbmdlY29tbWVy Y2Uub3JnCmh0dHBzOi8vd3d3LmludGVyY2hhbmdlY29tbWVyY2Uub3JnL21haWxtYW4vbGlzdGlu Zm8vaW50ZXJjaGFuZ2UtdXNlcnM= --===============6875029392571019801==--