[ic] cannot use mariadb using Interchange

[David Christensen]

> 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


Hi,

It looks like the DBI->quote_identifier() function is returning values that MariaDB doesn’t 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’re having problems with.

HTH,

David
--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171



-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://www.interchangecommerce.org/pipermail/interchange-users/attachments/20181217/9056732a/attachment-0001.sig>