Re: cannot use mariadb using Interchange

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

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--rCZiuUexaFQ25E2ruGByM0gEuVzlhdDjr
Content-Type: multipart/mixed; boundary="fyhjGxdr160EhDVNfiR4BbKo3MNPXbhGg";
 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]>
 <[email protected]>
In-Reply-To: <[email protected]>

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

On 18/12/18 13:01, Peter wrote:
> On 18/12/18 03:56, David Christensen wrote:
>>> I could really use some assistance with my interchange.  I am using N=
ethserver 7 with perlbrew and perl 5.10.-1.  I upgraded to IC 5.10 from r=
pm installation from interchange-5.2.0-1.
>>>
>>> I got an  DBM database running with IC 5.2.  However,  After I got DB=
D:Mysql installed I get error on creation of indexes of tables.  Nethserv=
er 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 y=
our MariaDB server version for the right syntax to use near '_`parent_fld=
` ON `tree` (`parent_fld`)' at line 1
>=20
> You should upgrade to the latest version of IC from git, but you can fi=
x
> the issue by applying this patch:
>=20
> https://github.com/interchange/interchange/commit/c15c57cf4b973ad0978da=
f634c373b066588dd00.patch

=2E..oh, and possibly this as well:

https://github.com/interchange/interchange/commit/86fbcb14c402efda89b2329=
b73270ae513715ddf.patch


Peter


--fyhjGxdr160EhDVNfiR4BbKo3MNPXbhGg--

--rCZiuUexaFQ25E2ruGByM0gEuVzlhdDjr
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)

iQEcBAEBAgAGBQJcGDnwAAoJEAUijw0EjkDvNDEH/ibsJqiF3xuIvQWNSFnVhlsP
BIfHjJqwQCDev7qmpvveFK4gL0AqU1R+jOaivkxFKxR97S1Rw+6n60GrC8IulY4s
xuvzBvB9vBkDlRBx5zU8ZQBWiJFIS4WJGMDyRp2I912iLPV7oUQIU5MoFNkTzY5z
zF+dpx/N71hJH/kNiZ0GODvxYhnXs7yZIHF8rMFgnqALgNCV5sD7pww/I2c0b5dM
lMggKYom+xb38K05s2ghXzf9Dl0qxld9VVevKuF1S27Pp0mcs4sHJgCZFYStiXfT
UPlC271drTK5OFpQg9tYIr1QwF7xLAdSYwljnyrLfIm5sfnHNJ02wibUoe8+sCM=
=Uy1K
-----END PGP SIGNATURE-----

--rCZiuUexaFQ25E2ruGByM0gEuVzlhdDjr--

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

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KaW50ZXJjaGFu
Z2UtdXNlcnMgbWFpbGluZyBsaXN0CmludGVyY2hhbmdlLXVzZXJzQGludGVyY2hhbmdlY29tbWVy
Y2Uub3JnCmh0dHBzOi8vd3d3LmludGVyY2hhbmdlY29tbWVyY2Uub3JnL21haWxtYW4vbGlzdGlu
Zm8vaW50ZXJjaGFuZ2UtdXNlcnM=

--===============7356799973341096819==--