<html>Hi,<br /><br />I am using DBD::mysql 4.049. I<br /><br />Thanks for your help<br /><br />[root@store ~]# cpan -l | grep DBD::mysql<br />Loading internal null logger. Install Log::Log4perl for logging messages<br />Bundle::DBD::mysql 4.049<br />DBD::mysql 4.049<br />DBD::mysql::GetInfo undef<br />Bundle::DBD::mysql 4.049<br />DBD::mysql 4.049<br />DBD::mysql::GetInfo undef<br />[root@store ~]#<br />On Monday, December 17, 2018 08:56 CST, David Christensen <david@endpoint.com> wrote:<br /> <blockquote type="cite" cite="BE4550E3-56CF-4061-A638-01856AFFDDFB@endpoint.com">> 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.<br />><br />> 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.<br />><br />> [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<br /><br /><br />Hi,<br /><br />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?<br /><br /><br />[root@store ~]# cpan -l | grep DBD::mysql<br />Loading internal null logger. Install Log::Log4perl for logging messages<br />Bundle::DBD::mysql 4.049<br />DBD::mysql 4.049<br />DBD::mysql::GetInfo undef<br />Bundle::DBD::mysql 4.049<br />DBD::mysql 4.049<br />DBD::mysql::GetInfo undef<br />[root@store ~]#<br /><br />You could try to work around it by turning off QUOTE_IDENTIFIERS; something like:<br /><br />DatabaseDefault QUOTE_IDENTIFIERS 0<br /><br />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.<br /><br />HTH,<br /><br />David<br />--<br />David Christensen<br />End Point Corporation<br />david@endpoint.com<br />785-727-1171<br /><br /> </blockquote><br /><br /><br /> </html>