[ic] checkout selection fails

[interchange-users@icdevgroup.org (James P. Kinney III)]

--=-m/Q0yEohxvULrMkumRyf
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

More infor:

Checkout only fails if there are any items in the cart. The checkout
screen appears if the cart is empty.

So there seems to be a problem with the item processing to get through
the cart list.

I get the same behavior whether logged in or not. So it is not tied to
the user.

Will ^M in the products database cause problems? A product manager did
some cut-n-paste on a windows box so the ^M got plonked in all over.

On Sun, 2002-12-22 at 18:24, James P. Kinney III wrote:
> This isn't a javascript issue. It fails of ALL browsers, IE (5, 5.5, 6)
> Netscape 4.x-6, Mozilla.....
>=20
>=20
> I backed up the data from the .txt files and removed the IC rpms. I then
> removed the directories they were in (except for the images dir in the
> www area, to much stuff). Reinstalled 4.8.6, ran makecat, restored the
> txt files, removed the products/*.sql and *.gdbm files. Restarted IC,
> waited for the DB to restore successfully (it did).=20
>=20
> Logged in as the test user. Added an item to the cart and watched it
> crash when I selected "checkout".=20
>=20
> I'm stumped.=20
>=20
> On Sun, 2002-12-22 at 17:32, Giles Hayes wrote:
> > I don't know which browser your customer was using but I had similar
> > problems accessing the checkout page whilst using Internet Explorer V 6=
.
> >=20
> >=20
> > It worked fine with Netscape. I think IE 6 had problems were related to
> > javascript. Microsoft now supply a service pack for IE6 which seemed to
> > cure the problem.=20
> >=20
> > I hope this helps
> >=20
> >=20
> >=20
> > -----Original Message-----
> > From: interchange-users-admin@icdevgroup.org
> > [mailto:interchange-users-admin@icdevgroup.org] On Behalf Of James P.
> > Kinney III
> > Sent: 21 December 2002 23:42
> > To: Interchange development group
> > Subject: [ic] checkout selection fails
> >=20
> > Interchange 4.8.6. Postgresql 7.2.1=20
> >=20
> > I have had no problems for a while. Today, an email came in that the
> > customer could not access the checkout page. They weren't kidding!
> >=20
> > The process seems to just hang. Eventually the timeouts happen and
> > apache returns an error to the user:=20
> >=20
> > Internal Server Error
> > The server encountered an internal error or misconfiguration and was
> > unable to complete your request.
> >=20
> > apache log says:  Premature end of script headers:
> > /var/www/cgi-bin/foundation
> >=20
> >=20
> > ps aux shows:
> > postgres  5705  0.0  0.3  8132 1800 pts/1    S    18:09   0:00
> > /usr/bin/postmaster
> > postgres  5707  0.0  0.3  9124 1780 pts/1    S    18:09   0:00 postgres=
:
> > stats buffer process
> > postgres  5709  0.0  0.3  8156 1816 pts/1    S    18:09   0:00 postgres=
:
> > stats collector process
> > root      6012  0.0  0.1  1652  548 pts/1    S    18:18   0:00 tail -f
> > /var/log/httpd/error_log
> > interch   6129  0.0  3.9 25292 20484 ?       S    18:21   0:00
> > interchange
> > interch   6214  0.0  0.0  1452  388 ?        S    18:26   0:00
> > foundation
> > interch   6216  0.0  4.1 26376 21548 ?       S    18:26   0:00
> > interchange
> > postgres  6217  0.0  0.6  8844 3348 pts/1    S    18:26   0:00 postgres=
:
> > interch foundation [local] idle
> > root      6238  0.0  0.1  2648  720 pts/0    R    18:30   0:00 ps aux
> >=20
> > It's the [local] idle part that seems to be the issue. Continued
> > interchange access spawns more interchange/foundation pair processes
> > with nothing getting sent back to the screen.=20
> >=20
> > As long as no user is logged in and a visitor is just looking through
> > the system, it works fine.=20
> >=20
> > I had been doing some firewall work adding a VPN to the system. But 80
> > and 443 are still open. I can access the admin pages which all use http=
s
> > and some other https pages on the same system.
> >=20
> > The /var/log/interchange/foundation/error.log shows:
> >=20
> > foundation /cgi-bin/foundation/process.html Attempted database operatio=
n
> > without table, fields, or key.
> > > Table: ''
> > > Fields:''
> > > Key:   ''
> >=20
> > So I check out the database foundation for blank tables. I have:
> >      Name      | Type  |  Owner
> > ---------------+-------+---------
> >  affiliate     | table | interch
> >  area          | table | interch
> >  cat           | table | interch
> >  country       | table | interch
> >  gift_certs    | table | interch
> >  inventory     | table | interch
> >  merchandising | table | interch
> >  options       | table | interch
> >  order_returns | table | interch
> >  orderline     | table | interch
> >  pricing       | table | interch
> >  products      | table | interch
> >  state         | table | interch
> >  transactions  | table | interch
> >  userdb        | table | interch
> >=20
> > Which matches my test setup. This is the real, online live system!
> > Yikes!
> >=20
> > Where do I go to look for more info?   ?????
--=20
James P. Kinney III   \Changing the mobile computing world/
President and CEO      \          one Linux user         /
Local Net Solutions,LLC \           at a time.          /
770-493-8244             \.___________________________./

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics) <jkinney@localnetsoluti=
ons.com>
Fingerprint =3D 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7=20



--=-m/Q0yEohxvULrMkumRyf
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQA+BlI6YZCtw4KcbKcRAq6kAKDiQhlGyN/SUpjgYWiZvAIsK3lbqQCfRc8a
jb7lWnCBM2n6oZF+3BbhpGw=
=fhVL
-----END PGP SIGNATURE-----

--=-m/Q0yEohxvULrMkumRyf--