Hi,
i am using php4.1.2 apahce1.3.240
i am getting this warning
Warning: Unknown list entry type in request shutdown (0) in Unknown
on line 0
could anyone help in solving this
thanks in advance for your help
chidambaram
--- [EMAIL PROTECTED] wrote: >
> php-db Digest 9 Jun 2002 13:18:08 -0000 Issue 1246
>
> Topics (messages 19689 through 19700):
>
> Re: Auto-update database records
> 19689 by: Jason Wong
> 19690 by: Tony
> 19691 by: Jason Wong
> 19692 by: Tony
> 19693 by: Jason Wong
>
> Re: MySQL problem on Yellow Dog Linux
> 19694 by: Garrett Nelson
> 19695 by: Jason Wong
> 19696 by: Garrett Nelson
> 19697 by: Jason Wong
>
> arranging folders hiearchy
> 19698 by: SP
> 19699 by: SP
>
> Hyperwave Upload Error, hw_insert_document()
> 19700 by: Jean HAUSSER
>
> Administrivia:
>
> To subscribe to the digest, e-mail:
> [EMAIL PROTECTED]
>
> To unsubscribe from the digest, e-mail:
> [EMAIL PROTECTED]
>
> To post to the list, e-mail:
> [EMAIL PROTECTED]
>
>
>
----------------------------------------------------------------------
>
> ATTACHMENT part 2 message/rfc822
> From: Jason Wong <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Sat, 8 Jun 2002 20:45:04 +0800
> Subject: Re: [PHP-DB] Auto-update database records
>
> On Saturday 08 June 2002 20:35, Tony wrote:
> > Here is my code.
> > If you see some variables not defined, assume it is:
>
> Hmm, is there a problem with your code? If so could you state what
> the problem
> is?
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications
> Development *
>
>
> /*
> Any man who hates dogs and babies can't be all bad.
> -- Leo Rosten, on W.C. Fields
> */
>
>
> ATTACHMENT part 3 message/rfc822
> Date: Sat, 08 Jun 2002 05:52:54 -0700
> From: Tony <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Re: [PHP-DB] Auto-update database records
>
> You are being picky on me, huh?
> I stated my problem 3 emails ago, browser gives me error "attempt
> to load
> "MyPage's URL" failed".
> Could be because of execution timeout.
> I tried to set the time longer with no luck.
> If I put the flush() after each data, I get the first output only.
> But I need to update the database very often, and I don't want to
> do it by
> hands..
>
> Tony S. Wu
> [EMAIL PROTECTED]
>
>
> > On Saturday 08 June 2002 20:35, Tony wrote:
> >> Here is my code.
> >> If you see some variables not defined, assume it is:
> >
> > Hmm, is there a problem with your code? If so could you state
> what the problem
> > is?
>
>
>
>
> ATTACHMENT part 4 message/rfc822
> From: Jason Wong <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Sat, 8 Jun 2002 21:27:09 +0800
> Subject: Re: [PHP-DB] Auto-update database records
>
> On Saturday 08 June 2002 20:52, Tony wrote:
> > You are being picky on me, huh?
>
> I'm sorry if you feel offended ...
>
> > I stated my problem 3 emails ago,
>
> ... but I delete mail from this list as soon as I've finished with
> them. As
> you have started a new thread one would naturally assume this is a
> new
> problem. Please don't expect people to remember dead threads.
>
> > browser gives me error "attempt to load
> > "MyPage's URL" failed".
>
> > Could be because of execution timeout.
> > I tried to set the time longer with no luck.
> > If I put the flush() after each data, I get the first output
> only.
> > But I need to update the database very often, and I don't want to
> do it by
> > hands..
>
> Have you tried tracking down where it is that the script fails?
>
> Either use echo() or error_log() at various points in the script to
> monitor
> what the program is doing. For example before starting the
> while-loops
> echo("Entering while loop") and inside the while-loop
> echo($counter), and
> when the loop terminates echo someting to that effect. This should
> at least
> tell you whether you have any infinite loops.
>
> Another thing you can do is simplify the check for the prices. Your
> present
> method seems to be veru long-winded. I think a single preg_match()
> could
> replace the "while ($counter < $i)" loop.
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications
> Development *
>
>
> /*
> YOU PICKED KARL MALDEN'S NOSE!!
> */
>
>
> ATTACHMENT part 5 message/rfc822
> Date: Sat, 08 Jun 2002 06:34:56 -0700
> From: Tony <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Re: [PHP-DB] Auto-update database records
>
> I do appreciate your reply.
> Yes, I've tried to track down the problem.
> I comment-out the fopen() function and use echo to display the URL.
> And it displays fine, so I did get the record from MySQL.
> Then when I put the fopen() back, same problem appears.
> I think it's probably because I have too much data to update at
> once, over a
> hundred maybe?
> Then it causes the PHP to timeout this script hence the error.
> If I can't solve this on PHP, I'll have to find an alternative way
> to do
> this...
>
> Tony S. Wu
> [EMAIL PROTECTED]
>
>
> > On Saturday 08 June 2002 20:52, Tony wrote:
> >> You are being picky on me, huh?
> >
> > I'm sorry if you feel offended ...
> >
> >> I stated my problem 3 emails ago,
> >
> > ... but I delete mail from this list as soon as I've finished
> with them. As
> > you have started a new thread one would naturally assume this is
> a new
> > problem. Please don't expect people to remember dead threads.
> >
> >> browser gives me error "attempt to load
> >> "MyPage's URL" failed".
> >
> >> Could be because of execution timeout.
> >> I tried to set the time longer with no luck.
> >> If I put the flush() after each data, I get the first output
> only.
> >> But I need to update the database very often, and I don't want
> to do it by
> >> hands..
> >
> > Have you tried tracking down where it is that the script fails?
> >
> > Either use echo() or error_log() at various points in the script
> to monitor
> > what the program is doing. For example before starting the
> while-loops
> > echo("Entering while loop") and inside the while-loop
> echo($counter), and
> > when the loop terminates echo someting to that effect. This
> should at least
> > tell you whether you have any infinite loops.
> >
> > Another thing you can do is simplify the check for the prices.
> Your present
> > method seems to be veru long-winded. I think a single
> preg_match() could
> > replace the "while ($counter < $i)" loop.
>
>
>
>
>
> ATTACHMENT part 6 message/rfc822
> From: Jason Wong <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Sat, 8 Jun 2002 21:44:12 +0800
> Subject: Re: [PHP-DB] Auto-update database records
>
> On Saturday 08 June 2002 21:34, Tony wrote:
> > I do appreciate your reply.
> > Yes, I've tried to track down the problem.
> > I comment-out the fopen() function and use echo to display the
> URL.
> > And it displays fine, so I did get the record from MySQL.
> > Then when I put the fopen() back, same problem appears.
>
> You did check that $buffer contains what you expect for each
> iteration of
> $final_result?
>
> > I think it's probably because I have too much data to update at
> once, over
> > a hundred maybe?
> > Then it causes the PHP to timeout this script hence the error.
>
> You can use set_time_limit(3000) inside a loop (probably the
> foreach) as each
> time it is used it will reset the max execution time to 3000secs.
>
> As I said before, see what's happening to the value of $counter. Or
> simplify
> that loop with a regular expression.
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications
> Development *
>
>
> /*
> In Oz, never say "krizzle kroo" to a Woozy.
> */
>
>
> ATTACHMENT part 7 message/rfc822
> Date: Sat, 08 Jun 2002 11:20:31 -0400
> From: Garrett Nelson <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Re: [PHP-DB] MySQL problem on Yellow Dog Linux
>
> I have both the lines in httpd.conf. As I said, PHP is working
> fine, it's
> just an issue with MySQL support I believe.
>
>
> On 6/8/02 2:24 AM, "Jason Wong" <[EMAIL PROTECTED]> wrote:
>
> > On Saturday 08 June 2002 05:29, Garrett Nelson wrote:
> >> I now downloaded "php-mysql-4.1.2-1a.ppc.rpm" from rpmfinder,
> and again I
> >> get
> >>
> >> rpm -ivh php-mysql*
> >> Preparing...
> ###########################################
> >> [100%]
> >> package php-mysql-4.1.2-1a is already installed
> >>
> >> (Same error with -Uvh, too)
> >>
> >> So I suppose it's something else. Do I have to uninstall PHP
> first? Or,
> >> again, could it be something wrong with the PHP configs? Is
> php.ini the
> >> only config file that might need to be edited?
> >
> > Check in your httpd.conf file that you have these lines:
> >
> > LoadModule php4_module modules/libphp4.so
> > AddModule mod_php4.c
>
> --
>
>
>
> ATTACHMENT part 8 message/rfc822
> From: Jason Wong <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Sun, 9 Jun 2002 00:07:07 +0800
> Subject: Re: [PHP-DB] MySQL problem on Yellow Dog Linux
>
> On Saturday 08 June 2002 23:20, Garrett Nelson wrote:
> > I have both the lines in httpd.conf. As I said, PHP is working
> fine, it's
> > just an issue with MySQL support I believe.
>
> Sorry my mistake. Check in php.ini for this line:
>
> extension=mysql.so
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications
> Development *
>
>
> /*
> A tautology is a thing which is tautological.
> */
>
>
> ATTACHMENT part 9 message/rfc822
> Date: Sat, 08 Jun 2002 13:28:39 -0400
> From: Garrett Nelson <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Re: [PHP-DB] MySQL problem on Yellow Dog Linux
>
> On 6/8/02 12:07 PM, "Jason Wong" <[EMAIL PROTECTED]> wrote:
>
> > On Saturday 08 June 2002 23:20, Garrett Nelson wrote:
> >> I have both the lines in httpd.conf. As I said, PHP is working
> fine, it's
> >> just an issue with MySQL support I believe.
> >
> > Sorry my mistake. Check in php.ini for this line:
> >
> > extension=mysql.so
>
>
> Well, we're getting closer now, maybe. I added the line
> extension=mysql.so,
> and I still get the same error when trying to run the web-based PHP
> apps,
> but in the command line when I type "php" I get back,
>
> PHP Warning: Unable to load dynamic library './mysql.so' -
> ./mysql.so:
> cannot open shared object file: No such file or directory in
> Unknown on line
> 0
>
> Does that help at all in identifying what may be wrong?
>
> --
>
>
>
> ATTACHMENT part 10 message/rfc822
> From: Jason Wong <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Sun, 9 Jun 2002 01:46:46 +0800
> Subject: Re: [PHP-DB] MySQL problem on Yellow Dog Linux
>
> On Sunday 09 June 2002 01:28, Garrett Nelson wrote:
> >
> > Well, we're getting closer now, maybe. I added the line
> extension=mysql.so,
> > and I still get the same error when trying to run the web-based
> PHP apps,
> > but in the command line when I type "php" I get back,
> >
> > PHP Warning: Unable to load dynamic library './mysql.so' -
> ./mysql.so:
> > cannot open shared object file: No such file or directory in
> Unknown on
> > line 0
> >
> > Does that help at all in identifying what may be wrong?
>
> In php.ini check/add the line
>
> extension_dir = /path/to/directory/containing-mysql.so
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications
> Development *
>
> /*
> Euch ist becannt, was wir beduerfen;
> Wir wollen stark Getraenke schluerfen.
> -- Goethe, "Faust"
> */
>
>
> ATTACHMENT part 11 message/rfc822
> From: "SP" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Date: Sat, 8 Jun 2002 20:09:22 -0400
> Subject: arranging folders hiearchy
>
> I am trying to arrange the results by PATH but within each of the
> same PATH
> section I want it to be arranged by NAME alphabetically so it looks
> like the
> following below. I've tried a bunch of order by's but not getting
> it to work.
> Is this possible to do? Or do I have to change my PATH data some
> how.
>
> Home
> About Us
> Contact Us
> Products
> Cabinets
> Furnitures
> Services
> Repairs
> Waxing
>
> ID PID PATH SECTION
> == === ========================== =================
> 1 1 ' 1' 'Home'
> 2 1 ' 1 2' 'Products'
> 3 1 ' 1 3' 'Services'
> 5 2 ' 1 2 5' 'Furniture'
> 6 2 ' 1 2 6' 'Cabinets'
> 7 3 ' 1 3 7' 'Waxing'
> 10 7 ' 1 3 10' 'Repairs'
> 11 1 ' 1 b' 'Contact Us'
> 12 1 ' 1 c' 'About Us'
>
>
>
>
> ATTACHMENT part 12 message/rfc822
> From: "SP" <[EMAIL PROTECTED]>
> To: "SP" <[EMAIL PROTECTED]>,
> <[EMAIL PROTECTED]>
> Date: Sat, 8 Jun 2002 20:29:55 -0400
> Subject: RE: [PHP-DB] arranging folders hiearchy
>
> Wrong: 10 7 ' 1 3 10' 'Repairs'
> Correction: 10 3 ' 1 3 10' 'Repairs'
>
> -----Original Message-----
> From: SP [mailto:[EMAIL PROTECTED]]
> Sent: June 8, 2002 8:09 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] arranging folders hiearchy
>
>
> I am trying to arrange the results by PATH but within each of the
> same PATH
> section I want it to be arranged by NAME alphabetically so it looks
> like the
> following below. I've tried a bunch of order by's but not getting
> it to
> work.
> Is this possible to do? Or do I have to change my PATH data some
> how.
>
> Home
> About Us
> Contact Us
> Products
> Cabinets
> Furnitures
> Services
> Repairs
> Waxing
>
> ID PID PATH SECTION
> == === ========================== =================
> 1 1 ' 1' 'Home'
> 2 1 ' 1 2' 'Products'
> 3 1 ' 1 3' 'Services'
> 5 2 ' 1 2 5' 'Furniture'
> 6 2 ' 1 2 6' 'Cabinets'
> 7 3 ' 1 3 7' 'Waxing'
> 10 7 ' 1 3 10' 'Repairs'
> 11 1 ' 1 b' 'Contact Us'
> 12 1 ' 1 c' 'About Us'
>
>
>
>
>
>
> ATTACHMENT part 13 message/rfc822
> To: [EMAIL PROTECTED]
> From: Jean HAUSSER <[EMAIL PROTECTED]>
> Date: 09 Jun 2002 15:01:34 +0200
> Subject: Hyperwave Upload Error, hw_insert_document()
>
> Hello,
>
> I'm trying to upload an image into an HIS (Hyperwave Information
> Server)
> 5.5 server running under Debian GNU/Linux (i386) with this userland
> function :
>
> ,----
> | function his_upload($datei, $parent, $attribute) {
> | /* datei : filename on the local (server) filesystem
> | * parent : parent collection of the document to upload
> | * attribute : string containing all the attributes, separated
> by \n
> | *
> | * Returns the new ObjID on success, false on error
> | */
> | global $hwconnector;
> |
> | $document_size = filesize($datei);
> | echo "[his_upload] $datei is $document_size long<br>";
> | $fd = fopen($datei, "r");
> | $document_data = fread($fd, $document_size);
> | fclose($fd);
> | echo "[his_upload] $datei : ".strlen($document_data)."
> read.<br>";
> |
> | $object_record = hw_array2objrec($attribute);
> | echo "[his_upload] object record preview :<br>".
> | nl2br($object_record)."<br>";
> | $hw_doc = hw_new_document($object_record, $document_data,
> | $document_size);
> | echo "[his_upload] hw_new_document : $hw_doc (last hw error
> msg: ".
> | hw_ErrorMsg($hwconnector).")<br>";
> | $result = hw_InsertDocument($hwconnector,
> his_get_objectID($parent),
> | $hw_doc);
> | echo "[his_upload] hw_insert_document returned $result (last hw
> ".
> | "error msg: ".hw_ErrorMsg($hwconnector).".)<br>";
> | return $result;
> | }
> |
> | function his_get_objectID($name)
> | {
> | global $hwconnector ;
> | if (!$hwconnector) return "-1"; // no connection to HIS
> |
> | if (!$name) return "0" ;
> | $objids = hw_getobjectbyquery($hwconnector, "Name=$name" ,
> -1);
> | if (count($objids) == 0) {
> | return "-2" ; // error! file not found in HIS
> | } else return $objids[0] ;
> | }
> `----
>
> When I try to use this function in a script, I get the following
> message :
>
> ,----[ PHP Ouput ]
> | [his_upload] /tmp/php8JPPJW is 26264 long
> | [his_upload] /tmp/php8JPPJW : 26264 read.
> | [his_upload] object record preview :
> | Type=Document
> | DocumentType=Image
> | MimeType=image/jpeg
> | Name=~jhausser/pw/ebc/image
> |
> | [his_upload] hw_new_document : 3 (last hw error msg: No error)
> | Added str to header: Name=~jhausser/pw/ebc (21)
> | Sending msg: type = 9 -- id = 6
> | Recv msg: type = 9 -- id = 6
> | Added str to header: Type=Document DocumentType=Image
> | MimeType=image/jpeg Name=~jhausser/pw/ebc/image (81)
> | Added str to header: Parent=0x7b (11)
> | Sending msg: type = 32 -- id = 7
> | Recv msg: type = 32 -- id = 7
> | [his_upload] hw_insert_document returned (last hw error msg:
> Unknown
> | error: -5.)
> `----
>
> And nothing is uploaded in Hyperwave...
>
> Apache is compiled from source (tried versions 1.3.14 and 1.3.23)
> using
> this configure command line :
> ./configure --prefix=/usr/local/apache --enable-module=so
> --with-port=8080 --server-uid=www-data --server-gid=www-data
>
> PHP is also compiled from source (tried versions 4.0.3, 4.1.1 and
> 4.2.1, same result) with the following configure command-line :
> ./configure --prefix=/usr/local/apache
> --sysconfdir=/usr/local/apache/conf
> --with-apxs=/usr/local/apache/bin/apxs --enable-safe-mode
> --enable-magic-quotes --enable-ftp --with-hyperwave --with-mysql
> --enable-trans-sid --enable-sockets --with-regexp=system
>
> But what is astonishing is that the very same script runs under
> FreeBSD
> 4.2 (same Apache and PHP source archive, same configure options,
> with
> Hyperwave's linux binairies running thanks to FreeBSD's
> compatibility
> libraries), and I'm using the very same httpd.conf and php.ini on
> Linux
> and FreeBSD !
>
> I've been looking on PHP's changelog, google, phpbuilder's forums,
> PHP
> mail archives and so on without finding anything about that
> 'Unknown
> Error -5' and I'm running out of ideas... so any advice on the
> problem
> would be really welcomed.
>
> Thanking you in advance,
>
> --
> Jean HAUSSER
>
________________________________________________________________________
Everything you always wanted to know about cars and bikes,now
at: http://in.autos.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php