Skip to Content.
Sympa Menu

freetds - Re: PHP/tds issue

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Francis Smit <francis AT kbd.com.au>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: PHP/tds issue
  • Date: Wed, 13 Sep 2000 09:54:56 +1000




Michael Kimsal wrote:

> Hello all. :)
>
> I'm having a devil of a time tracking this one down - I hope someone has
> some knowledge here that can fix this.
>
> Situation:
> We've been developing a web app for a couple months. We're using PHP4
> with the latest freetds and MSSQL7 (sp1). Things were pretty fine up until
> about a
> week ago. *something's* changed, but I don't know what. We are
> now *often* having a page come back 'document contained no data' or the
> IE equivalent. By often I mean perhaps every 50 requests or so. This
> NEVER used to
> happen - we wouldn't have pressed forward with this if it did.
>

You haven't started to replicate the DB have you (or at least Publish
some tables), if so then make sure your not trying to grab the rowguid column

>
> Original development box:
> Caldera 2.4 (kernel 2.2.14)
> MSSQL7
> FreeTDS CVS - August 17 snapshot and one from June were both used
> at various times.
> PHP - either the snapshots after the 4.0.1pl2 release or the current
> 4.0.2
>
> Current box
> RedHat 6.2 (kernel 2.2.14 also I believe with SMP - 2 processors)
> MSSQL7 (again sp1)
> FreeTDS CVS - August 17 snapshot and one from June were both used
> at various times.
> PHP - either the snapshots after the 4.0.1pl2 release or the current
> 4.0.2
>
> Both boxes also running Apache 1.3.12
>
> Things worked fine on original box, and moved to final box (redhat) about 3
> weeks ago.
>
> Sometime last week, though, the RedHat box started flaking out -
> queries simply HANG and die. I've dumped FreeTDS to a log, but it doesn't
> seem
> to tell me anything. There is no rhyme nor reason for this - hitting
> reload will
> normally do the querys again and the page is fine.
>
> There is no error in the Apache error log - the access log shows the page as
> getting called, but returning 0 bytes (or, more precisely, '-' bytes).
>
> I've compiled freetds with
> --enable-msdblib --with-tdsver=4.2
> Also tried tdsver=7.0 with no better results.
>
> Any troubleshooting information anyone can pass on?
>
> I can send logfiles to anyone individually if you'd like - just didn't want
> to clog up
> the
> list with big big mails.
>
> Thanks in advance. :)
>
> ==========================
> Michael Kimsal
> http://www.tapinternet.com
> 734-480-9961
>
> ---
> You are currently subscribed to freetds as: francis AT oztel.com
> To unsubscribe, forward this message to $subst('Email.Unsub')

--

Grizzly . oo
`oO
Francis Smit


Knowledge By Design
Suite 201, 683 George st
Sydney 2000 NSW
http://www.kbd.com.au

mailto:francis AT kbd.com.au
Mob +61416 008 977

Tel: +61 2 9212 1399
Fax: +61 2 9212 5727
___________________________________
m$: How can we stuff you up today?
How about an annoying paper clip?






Archive powered by MHonArc 2.6.24.

Top of Page