[ic] cannot use mariadb using Interchange

CSS Support support at computersolutionsandservices.com
Mon Dec 17 05:21:02 UTC 2018


Greetings Ladies and Gentleman,
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
- - - [16/December/2018:20:30:18 -0600] cssstore - DBI: Post creation query 'CREATE  INDEX `tree`_`mgroup` ON `tree` (`mgroup`)' 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 '_`mgroup` ON `tree` (`mgroup`)' at line 1
Interchange version
   
5.10.0
Server hostname
   
store.computersolutionsandservices.com
Interchange PID
   
29412
Interchange SUID User
   
interch (uid 52)
Server mode
   
INET and UNIX
Last time server restarted
   
Sun Dec 16 20:44:06 2018
Last time changes applied
   
Sun Dec 16 20:44:05 2018 (apply now)
Environment variables passed
   
MOD_PERL
 
Perl Version
   
Perl 5.10.1 (called with: /opt/perl5/perls/perl-5.10.1/bin/perl)
Optional Module Information
   
Archive::Tar found (v2.32).
LWP::Simple found (v6.36).
Archive::Zip found (v1.64).
MIME::Base64 found (v3.15).
Bundle::LWP not found. Certain parts of these modules (URI::URL and MIME::Base64) are required for Interchange's internal HTTP server. Also, Business::UPS, for calculating shipping, requires this.
Safe::Hole found (v0.14).
Business::UPS found (v2.01).
Set::Crontab found (v1.03).
Compress::Zlib found (v2.081).
Spreadsheet::ParseExcel found (v0.65).
Crypt::SSLeay found (v0.72).
Spreadsheet::WriteExcel found (v2.40).
DBI found (v1.642).
Storable found (v3.11).
Digest::MD5 found (v2.55).
Tie::ShadowHash found (v1.00).
Digest::SHA found (v6.02).
Tie::Watch not found. Minor: cannot set watch points in catalog.cfg.
Image::Size found (v3.3).
URI::URL found (v5.04).
Safe operations untrapped
   
ftfile sort rand
 
Database Interfaces
   
GDBM available (v1.09)
No Berkeley DB_File.
DBI enabled (v1.642), available drivers:
DBM
ExampleP
File
Gofer
Mem
Proxy
Sponge
mysql
Database Tables
   
2ndDayAir
gift_certs
products
Ground
ichelp
route
NextDayAir
inventory
state
access
locale
survey
affiliate
merchandising
transactions
area
mv_metadata
tree
cat
options
userdb
component
order_returns
variable
country
orderline
variants
forum
pricing
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.interchangecommerce.org/pipermail/interchange-users/attachments/20181216/ca738241/attachment.html>


More information about the interchange-users mailing list