Mailing List Archive

ubuntu 16 Interchange 5.12.0 rc1
- ubuntu 16.04.6 kernel 4.4.0-177
- apache 2.4.18 (Ubuntu)
- perl 5.22.1 (Ubuntu)
- mysql 5.7.29-0 (Ubuntu)
- interchange-5.12.0-rc1.tar.gz

apt update
apt upgrade
adduser interch
apt install mc
apt install apache2
apt install mysql-server
sudo apt-get install build-essential
perl -MCPAN -e 'install Bundle::Interchange'

sudo apt-get install libdbd-mysql-perl
a2enmod cgi

cd interchange-5.12.0
perl Makefile.PL
make
make test
make install
cd /usr/local/lib/interchange/
bin/makecat

# su -c "/usr/local/lib/interchange/bin/interchange -r" interch

root@ubuntu16TestIc5:/home/interch/catalogs/strap/products# su -c
"/usr/local/lib/interchange/bin/interchange -r" interch

Killing Interchange server 2449 with TERM.
Low traffic settings.
Calling UI......UI is loaded...
Interchange V5.12.0
Running with old signals.
Configuring catalog strap...Using MySQL,
DSN=dbi:mysql:test_strap...table gateway_log created: create table
`gateway_log` (
`gateway_log_id` INT PRIMARY KEY AUTO_INCREMENT,
`trans_type` text not null default '',
`processor` text not null default '',
`catalog` text not null default '',
`cart_md5` text not null default '',
`result_code` text not null default '',
`result_subcode` text not null default '',
`reason_code` text not null default '',
`response_msg` text not null default '',
`request_id` varchar(255) not null default '',
`order_number` varchar(32) not null default '',
`email` varchar(191) not null default '',
`amount` text not null default '',
`session_id` text not null default '',
`host_ip` text not null default '',
`username` text not null default '',
`request_source` text not null default '',
`request_date` varchar(32) not null default '',
`request_duration` text not null default '',
`request` text not null default '',
`response` text not null default ''
)

table gateway_log index failed: Table 'test_strap.gateway_log' doesn't exist
DBI: Index creation query 'CREATE INDEX `gateway_log_request_date` ON
`gateway_log` (`request_date`)' failed: Table 'test_strap.gateway_log'
doesn't exist
DBI: Index creation query 'CREATE INDEX `gateway_log_request_id` ON
`gateway_log` (`request_id`)' failed: Table 'test_strap.gateway_log'
doesn't exist
DBI: Index creation query 'CREATE INDEX `gateway_log_order_number` ON
`gateway_log` (`order_number`)' failed: Table 'test_strap.gateway_log'
doesn't exist
DBI: Index creation query 'CREATE INDEX `gateway_log_email` ON
`gateway_log` (`email`)' failed: Table 'test_strap.gateway_log' doesn't
exist
table 'gateway_log' failed: list_fields execute on `gateway_log`: Table
'test_strap.gateway_log' doesn't exist at
/usr/local/lib/interchange/lib/Vend/Table/DBI.pm line 2072.

done.
Interchange server started in UNIX mode(s) (process id 1639)

http://ubuntu16/strap/

images admin url error in products/variable.txt
UI_IMAGE_DIR /var/www/html/interchange-5/
manually correct with but maybe my error
UI_IMAGE_DIR /interchange-5/

mysql error:
ERROR 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column 'trans_type'
can't have a default value

=== test done ========================
placed one order from customer pages anyway
run on all admin pages

--
"fino alla bara sinpara"
"up to demise we rize"
_______________________________________________
interchange-users mailing list
interchange-users@interchangecommerce.org
https://www.interchangecommerce.org/mailman/listinfo/interchange-users