[ic] ?==?utf-8?q? cannot use mariadb using Interchange

[CSS Support]

Hi,

I am using DBD::mysql 4.049.  I

Thanks for your help

[root at store ~]# cpan -l | grep DBD::mysql
Loading internal null logger. Install Log::Log4perl for logging messages
Bundle::DBD::mysql      4.049
DBD::mysql      4.049
DBD::mysql::GetInfo     undef
Bundle::DBD::mysql      4.049
DBD::mysql      4.049
DBD::mysql::GetInfo     undef
[root at store ~]#
On Monday, December 17, 2018 08:56 CST, David Christensen <david at endpoint.com> 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


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?


[root at store ~]# cpan -l | grep DBD::mysql
Loading internal null logger. Install Log::Log4perl for logging messages
Bundle::DBD::mysql      4.049
DBD::mysql      4.049
DBD::mysql::GetInfo     undef
Bundle::DBD::mysql      4.049
DBD::mysql      4.049
DBD::mysql::GetInfo     undef
[root at store ~]#

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 --------------
An HTML attachment was scrubbed...
URL: <https://www.interchangecommerce.org/pipermail/interchange-users/attachments/20181219/d2de9c1f/attachment.html>