Mailing List Archive

Re: ?==?utf-8?q? cannot use mariadb using Interchange
Hi,

i don't reallyt understand what to do.  Sholud i download the the entire source again.  I really appreciate your assistance. Experienced but a unlearned. 

Thanks,

Marlon



On Monday, December 17, 2018 18:06 CST, Peter <peter@pajamian.dhs.org> wrote:
 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 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:Mysql 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`_`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
>
> 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/c15c57cf4b973ad0978daf634c373b066588dd00.patch

...oh, and possibly this as well:

https://github.com/interchange/interchange/commit/86fbcb14c402efda89b2329b73270ae513715ddf.patch


Peter