[ic] Install problems with MySQL

[Michael Lehmkuhl]

Dan,

> uname -a
BSD/OS electricpulp.com 4.0.1 BSDI BSD/OS 4.0.1 Virtual Kernel #12: Fri Feb
25 17:03:03 PST 2000

As for the SQL, I can execute the query you attached.  As a matter of fact,
Interchange is able to execute that query as well.  The problem seems to
happen on the query right after the CREATE TABLE orderline query.  The table
orderline is correctly set up in MySQL, but right after running that query,
Interchange gives me the following error:

table orderline index failed: Lost connection to MySQL server during query

Also, I installed another catalog (pulpstore_dbm) using DBM instead of
MySQL, and that did work correctly.

-- 
Michael Lehmkuhl <michael@electricpulp.com>
Partner, Electric Pulp

1.605.988.0177 : 1.888.722.PULP
electricpulp.com


> From: Dan B <db@cyclonehq.dnsalias.net>
> Reply-To: interchange-users@developer.akopia.com
> Date: Fri, 18 May 2001 16:05:17 -0700
> To: interchange-users@developer.akopia.com
> Subject: Re: [ic] Install problems with MySQL
> 
> At 02:55 PM 5/18/2001 -0500, you wrote:
>> I'm a newbie to Interchange, but I'm extremely excited about it.  The demo
>> installation really got me turned on to the speed and flexibility of this
>> tool.
>> 
>> However, I downloaded and am trying to install the software on my server,
>> and I'm having problems with MySQL.  The problem comes when trying to start
>> up the server for the first time after adding the first catalog.  I'm
>> running Interchange V4.6.5, bsdi, MySQL 3.22.14b, Perl 5.005_03.
> 
> [...]
> 
> What version of BSDi are you running?  Also, does the startup do the same
> thing every time (stop at orderline)?  Try manually running the command in
> mysql (attached), just to rule that out.
> 
> Also, would you try running just DBM (which is no SQL) to rule out other
> possibilities?
> 
> I hope you get it going,
> 
> Dan Browning, Cyclone Computer Systems, danb@cyclonecomputers.com
> 
> create table orderline (
> code char(14) NOT NULL PRIMARY KEY,
> store_id CHAR(9) DEFAULT '' NOT NULL, index(store_id),
> order_number CHAR(14) NOT NULL, index(order_number),
> session CHAR(32) NOT NULL,
> username CHAR(20) default '' NOT NULL,
> shipmode CHAR(32) default '' NOT NULL,
> sku CHAR(14) NOT NULL,
> quantity CHAR(9) NOT NULL,
> price CHAR(12) NOT NULL,
> subtotal CHAR(12) NOT NULL,
> shipping CHAR(12),
> taxable CHAR(3),
> size VARCHAR(30),
> color VARCHAR(30),
> options VARCHAR(255),
> order_date varchar(32) NOT NULL,
> update_date timestamp,
> status VARCHAR(32),
> parent CHAR(9),
> affiliate char(128),
> campaign char(128),
> description char(128)
> )
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>