Re: php-db Digest 9 Jun 2002 13:18:08 -0000 Issue 1246

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 --- php-db-digest-help@lists.php.net 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: > php-db-digest-subscribe@lists.php.net > > To unsubscribe from the digest, e-mail: > php-db-digest-unsubscribe@lists.php.net > > To post to the list, e-mail: > php-db@lists.php.net > > > ---------------------------------------------------------------------- > > ATTACHMENT part 2 message/rfc822 > From: Jason Wong <phplist@gremlins.com.hk> > To: php-db@lists.php.net > 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 <tonyswu@mac.com> > To: <php-db@lists.php.net> > 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 > tonyswu@mac.com > > > > 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 <phplist@gremlins.com.hk> > To: php-db@lists.php.net > 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 <tonyswu@mac.com> > To: <php-db@lists.php.net> > 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 > tonyswu@mac.com > > > > 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 <phplist@gremlins.com.hk> > To: php-db@lists.php.net > 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 <garrettnelson@mac.com> > To: <php-db@lists.php.net> > 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" <phplist@gremlins.com.hk> 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 <phplist@gremlins.com.hk> > To: php-db@lists.php.net > 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 <garrettnelson@mac.com> > To: <php-db@lists.php.net> > Subject: Re: [PHP-DB] MySQL problem on Yellow Dog Linux > > On 6/8/02 12:07 PM, "Jason Wong" <phplist@gremlins.com.hk> 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 <phplist@gremlins.com.hk> > To: php-db@lists.php.net > 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" <internetracer@yifan.net> > To: <php-db@lists.php.net> > 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" <internetracer@yifan.net> > To: "SP" <internetracer@yifan.net>, > <php-db@lists.php.net> > 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:internetracer@yifan.net] > Sent: June 8, 2002 8:09 PM > To: php-db@lists.php.net > 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: php-db@lists.php.net > From: Jean HAUSSER <jean@hausser.org> > 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