[ic] Please Help: Strange problem

[Guy Soudant]

This is the error.log file (table creation has been ommited, since no errors
were logged during this phase:

217.120.4.44 ZejavpCs:217.120.4.44 - [10/June/2001:06:25:12 -0400] store
/cgi-bin/store/process.html Saving userdb in mv_check.
217.120.4.44 ZejavpCs:217.120.4.44 - [10/June/2001:06:25:12 -0400] store
/cgi-bin/store/process.html commit attempted on non-transaction database,
returning success
217.120.4.44 ZejavpCs:217.120.4.44 - [10/June/2001:06:25:12 -0400] store
/cgi-bin/store/process.html commit attempted on non-transaction database,
returning success
217.120.4.44 ZejavpCs:217.120.4.44 - [10/June/2001:06:25:12 -0400] store
/cgi-bin/store/process.html commit attempted on non-transaction database,
returning success
217.120.4.44 ZejavpCs:217.120.4.44 - [10/June/2001:06:25:12 -0400] store
/cgi-bin/store/process.html commit attempted on non-transaction database,
returning success

This is the log file in the LOGS Directory:

#### begin TEST0001 #####
Place table transactions in transaction mode.
Place table orderline in transaction mode.
Place table userdb in transaction mode.
Add main order TEST0001 to transactions: 1
1
#### end TEST0001 #####

Sending email copy of order TEST0001 to soudant@home.nl: 1

The tracking.asc file and the tracking file in the LOGS Directory do not
show any errors at all.

Relevant part of the error.log in Interchange

- - - [10/June/2001:06:20:27 -0400] - - Added/changed catalog store:
>
>  Directory: /home/formula/catalogs/store
>  Script:    /cgi-bin/store
>
- - - [10/June/2001:06:20:27 -0400] - - Config 'store' from running server
(17634)
- - - [10/June/2001:06:20:27 -0400] - - Using MySQL,
DSN=dbi:mysql:formula_f1store...
- - - [10/June/2001:06:20:28 -0400] - - Reconfig of store successful.
- - - [10/June/2001:06:20:28 -0400] - - Config 'store' from running server
(17634)
- - - [10/June/2001:06:20:28 -0400] - - Using MySQL,
DSN=dbi:mysql:formula_f1store...
- - - [10/June/2001:06:20:29 -0400] - - Reconfig of store successful.
- - - [10/June/2001:06:20:39 -0400] - - STOP server (17634) on signal TERM
- - - [10/June/2001:06:20:43 -0400] - - Low traffic settings.
- - - [10/June/2001:06:20:43 -0400] - - ...UI is loaded....
- - - [10/June/2001:06:20:44 -0400] - - Interchange V4.7.2
- - - [10/June/2001:06:20:44 -0400] - - Config 'f1shop' at server startup
- - - [10/June/2001:06:20:44 -0400] - - Config 'store' at server startup
- - - [10/June/2001:06:20:44 -0400] - - START server (21701) (INET and UNIX)
- - - [10/June/2001:06:20:45 -0400] - - Accepting connections from
localhost|127\.0\.0\.1
- - - [10/June/2001:06:20:45 -0400] - - INET mode server failed to start on
port 7786: bind: Address already in use at
/home/formula/interchange/lib/Vend/Server.pm line 1353.
>
- - - [10/June/2001:06:20:45 -0400] - - Continuing in UNIX MODE ONLY
- - - [10/June/2001:06:20:45 -0400] - - START server (21753) (UNIX)
- - - [10/June/2001:06:38:59 -0400] - - Config 'store' from running server
(21753)
- - - [10/June/2001:06:38:59 -0400] - - Using MySQL,
DSN=dbi:mysql:formula_f1store...
- - - [10/June/2001:06:39:00 -0400] - - Reconfig of store successful.

I checked the orderline Table, and nothing was added to the Table after
performing a test order. If, however, I add an item, then the Database is
updated (perhaps this is helpfull)

Hopefully you can help me further

Kind regards

Guy Soudant



-----Original Message-----
From: interchange-users-admin@developer.akopia.com
[mailto:interchange-users-admin@developer.akopia.com]On Behalf Of Stefan
Hornburg (Racke)
Sent: zondag 10 juni 2001 13:26
To: interchange-users@developer.akopia.com
Subject: Re: [ic] Please Help: Strange problem


"Guy Soudant" <soudant@home.nl> writes:

> Hi,
>
> I am currently testing my Interchange 4.7.2 install, and I seem to run
into
> a strange problem. When I check the pre-installed orders (those that come
> with the demo) in the admin UI, I can see all the data (i.e. all items in
> the orders), but when I check my own test orders in both the customer
(order
> tracking) as well as the admin UI (order viewing), I do not see the items
> ordered by the customer (all other info is present, except for shipping
> costs, but that is not yet properly set up). IC does not add the orders to
> orderline (I have checked this with the MySQL admin client). It seems that
> IC does not write the data into the SQL table orderline, but I have no
clue
> why and what I can do about it. Can someone please help???? I reaaly need
> some help to get this up and running! Below you can find some details.

Look into the catalog error log for failure messages and check the
MySQL logs for inserts into orderline. Check if these inserts
are correct (e.g. by testing them manually with the mysql client).

Ciao
		Racke

--
Master of Swiss Web 2001: http://www.zweifel.ch/

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users