Re: cannot use mariadb using Interchange

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--===============1733468812741873867==
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="IRMETCyBC6W3lGVfc2TlWKME7J9NBTwTs"

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--IRMETCyBC6W3lGVfc2TlWKME7J9NBTwTs
Content-Type: multipart/mixed; boundary="wgR5pzJDE64BIVvIlcTtncVeR6cPnxTxr";
 protected-headers="v1"
From: Peter <[email protected]>
To: [email protected]
Message-ID: <[email protected]>
Subject: Re: [ic] cannot use mariadb using Interchange
References: <f3a-5c173200-31-14dbb4e0@186041610>
 <[email protected]>
In-Reply-To: <[email protected]>

--wgR5pzJDE64BIVvIlcTtncVeR6cPnxTxr
Content-Type: text/plain; charset=utf-8
Content-Language: en-MW
Content-Transfer-Encoding: quoted-printable

On 18/12/18 03:56, David Christensen wrote:
>> I could really use some assistance with my interchange.  I am using Ne=
thserver 7 with perlbrew and perl 5.10.-1.  I upgraded to IC 5.10 from rp=
m installation from interchange-5.2.0-1.
>>
>> 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.  Nethserve=
r uses mariadb-5.5.60.
>>
>> [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 yo=
ur MariaDB server version for the right syntax to use near '_`parent_fld`=
 ON `tree` (`parent_fld`)' at line 1

You should upgrade to the latest version of IC from git, but you can fix
the issue by applying this patch:

https://github.com/interchange/interchange/commit/c15c57cf4b973ad0978daf6=
34c373b066588dd00.patch


Peter


--wgR5pzJDE64BIVvIlcTtncVeR6cPnxTxr--

--IRMETCyBC6W3lGVfc2TlWKME7J9NBTwTs
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iQEcBAEBAgAGBQJcGDjfAAoJEAUijw0EjkDvA/wIAIv+yPg4dUuRg8rJpAJRRuEQ
2yeK37cgProXhMfCu00GagF0uyqisnDvLnZEpWcu+CoKeF9jH6Wu50PDGkii8X4l
KIUuwk/J0dJ0Ee5Qm1l5sLUwudD6QjLeIaJnu7qKZpEoImAjABvPMCgU4X7J5CZ4
J7X8AjkoUaun/7ocKtHaLcLjn0K3FaeanRh2Vm8GyFk7w2JTtDKsjWUOfYZxWBzq
2l8i9Ir8tgM3RvmsgEH+iUMi6DWUzLVHG9hk3czuIXX4JdH/jEFFZxY2gD8/Vb4k
wmFG3khVRiSrclbFbfbTP4KaiK0PAEeJmMl3tyqfBtH5IlM6MmwGQbrsamr/lgA=
=Xv4d
-----END PGP SIGNATURE-----

--IRMETCyBC6W3lGVfc2TlWKME7J9NBTwTs--

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

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KaW50ZXJjaGFu
Z2UtdXNlcnMgbWFpbGluZyBsaXN0CmludGVyY2hhbmdlLXVzZXJzQGludGVyY2hhbmdlY29tbWVy
Y2Uub3JnCmh0dHBzOi8vd3d3LmludGVyY2hhbmdlY29tbWVyY2Uub3JnL21haWxtYW4vbGlzdGlu
Zm8vaW50ZXJjaGFuZ2UtdXNlcnM=

--===============1733468812741873867==--