List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 15 2001 4:14am
Subject:Re: Warning: 1 is not a valid MySQL-Link resource
View as plain text  
At 10:20 AM +1100 11/15/01, John Mravunac wrote:
>Hi,
>
>Has anybody seen this error before?

Yes, lots of people.  That's why it's in the PHP FAQ. :-)

Typically, it's a symptom of failing to check MySQL calls for
errors.  Then your script continues blytely along, unaware that
there's a problem, until if fails catastophically.

Fix: Check all your mysql_xxx() calls for errors and take
appropriate action when a failure occurs.

>
>Everything was working great on my web server until one day I 
>upgraded MySQL from version 3.22.32 to 3.23.42.
>
>Initially I had Apache 1.3.12 working with PHP 4.0.1p12 and MySQL 
>3.22.32 along with a Mod_Auth_MySQL version 2.2 module. Then when I 
>upgraded the MySQL version, I started getting this error in the 
>apache logs:
>
>[notice] child pid 2713 exit signal Segmentation fault (11)
>
>every time a php page was used, and the php pages took quite some 
>time to populate sometimes timing out the web browsers.
>
>I upgraded the PHP to version 4.0.6 and this error disappeared with 
>the php pages working fine again, but now I receive this error on 
>the php page:
>
>Warning: 1 is not a valid MySQL-Link resource in 
>/usr/local/apache/webleads/sendlead.php on line 267
>
>Having performed the very same MySQL upgrade works fine on our 
>mirrored server which is setup exactly the same, no php problems.
>
>Perhaps somebody has some suggestions?? I've tried upgrading the 
>kernel version also, as I've read that MySQL has been reported to 
>produce strange errors on kernel version 2.2.14-5.0, but this did 
>not help.
>
>Thanks for any help you may be able to offer,
>John Mravunac :^)
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread91325@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
Warning: 1 is not a valid MySQL-Link resourceJohn Mravunac15 Nov
  • Re: Warning: 1 is not a valid MySQL-Link resourcePaul DuBois15 Nov
Re: Warning: 1 is not a valid MySQL-Link resourceJohn Mravunac15 Nov