Re: cannot use mariadb using Interchange

--===============3951598450555836447==
Content-Type: multipart/signed;
	boundary="Apple-Mail=_4EF6F1FB-E3F3-4C5B-8491-C1427D6AE3F1";
	protocol="application/pgp-signature";
	micalg=pgp-sha256


--Apple-Mail=_4EF6F1FB-E3F3-4C5B-8491-C1427D6AE3F1
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

> 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.
>=20
> 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.  =
Nethserver uses mariadb-5.5.60.
>=20
> [16/December/2018:20:30:18 -0600] cssstore - DBI: Post creation query =
'CREATE  INDEX `tree`_`parent_fld` ON `tree` (`parent_fld`)' 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 =
'_`parent_fld` ON `tree` (`parent_fld`)' at line 1


Hi,

It looks like the DBI->quote_identifier() function is returning values =
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_IDENTIFIERS; =
something like:

DatabaseDefault QUOTE_IDENTIFIERS 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




--Apple-Mail=_4EF6F1FB-E3F3-4C5B-8491-C1427D6AE3F1
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename=signature.asc
Content-Type: application/pgp-signature;
	name=signature.asc
Content-Description: Message signed with OpenPGP

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEECKA1l4YEfF4eK4/eN0ojyd+bZbgFAlwXuRsACgkQN0ojyd+b
ZbjqgQ/+PabXREwF2XHxP3TssZIfpzm6JITtVUfvnsKgoSyoB3Ya7XYe2Np/0cTH
TV1U6IeTq/0nkiAPRhHEQ8QKtIZr4PYipN5cqu+f8VWHLZeHnXP000FA/VmZgcTG
HJs1uxnU/6wvFI9J7jpLZJxYKxGoIsyAOZXv7R42VRoLVXgNlctRPsLsm1/uIZbR
6rQ/s1gpR0/aRhRBosNlZ2x5ZKs1nBM7z8sl4rqOJDIX0eYg/GCUGZss8cWNMHNU
tkKtmkrn6ywl7Duca5p2ZwSfjYCqhzuvPDk+dzRMK6Ko67RPu/zTrwI8dWrfsAPY
TfFpyj+TZBAYOYJj9AtchlZN8Px+2UW3GrLfdq51ckPCxawTSR9rj8f4FSq2HoDs
jxj7frfglYF/LxX1Dlt7KNSjJPl5MKrLjYzrX54usObSHSEpGtYOmcx2RA1hUbDE
xoKQIZV5aa9vYvU9e2fPdVvaURtausQ6+7YaW/SBQRMmTwb0/PFXQks187f1eo85
RFB3stoZczchazBc8d9Y9QzG/OXBDq1oxCq+i5FEm/Q8qyoaU0fFR3xQRMSXECQd
Jf1evA3oXgW+mZzC7unXlipJZN9ays3ciqOAE7FEfHOtQePGIXmiRPxGgW7Hm9rj
eUduSB8fjGIEHBbzQ5EFkyl8lSIZ7yzXuRAVhIzt2AdqTB/c//E=
=LiBj
-----END PGP SIGNATURE-----

--Apple-Mail=_4EF6F1FB-E3F3-4C5B-8491-C1427D6AE3F1--

--===============3951598450555836447==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: inline

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KaW50ZXJjaGFu
Z2UtdXNlcnMgbWFpbGluZyBsaXN0CmludGVyY2hhbmdlLXVzZXJzQGludGVyY2hhbmdlY29tbWVy
Y2Uub3JnCmh0dHBzOi8vd3d3LmludGVyY2hhbmdlY29tbWVyY2Uub3JnL21haWxtYW4vbGlzdGlu
Zm8vaW50ZXJjaGFuZ2UtdXNlcnM=

--===============3951598450555836447==--