Date: Mon, 22 Jul 2002 18:17:22 -0400 From: "sagacious" <sagacious@unixhideout.com> To: <freebsd-questions@freebsd.org> Subject: RE: MySQL problems after upgrade to 4.6-STABLE (Please Help) Message-ID: <000201c231cd$8d151120$0a01a8c0@MIKESBOX> In-Reply-To: <F59D56D98019A24391D6396DD708C8210C5B12@MLVV9MBE.usmlvv1p0a.smshsc.net>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --] Did you google this error? I searched for it and got over 3500 results. What version of mySQL are you running? Did you check permissions? How about your php.ini? Log files? This isn't related but you should do away with nuke all together. It's horrible and insecure. Try these guys. http://drupal.org sagacious (Mike) Network administrator The unixhideout network http://www.unixhideout.com -----Original Message----- From: owner-freebsd-questions@FreeBSD.ORG [mailto:owner-freebsd-questions@FreeBSD.ORG] On Behalf Of Warner Joseph Sent: Monday, July 22, 2002 6:08 PM To: 'freebsd-questions@freebsd.org' Subject: MySQL problems after upgrade to 4.6-STABLE (Please Help) Hi, I just upgraded our production server from 4.5-STABLE to 4.6-STABLE. Everything seems fine, with the exception of my install of MySQL. Now, when trying to access our forum system or any database driven pages, I get errors like this: phpBB : Critical Error Could not connect to the database ..and this: Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/local/www/nuke/html/includes/sql_layer.php on line 491 I've done these upgrades many times and have never once experienced a problem like this. I'm in a real crunch and was wondering if someone could help? Thanks Siemens - Health Services Joe Warner Operations Technical Analyst II 215 North Admiral Byrd Rd., Salt Lake City, UT 84116 Ph: 801-539-4978 Fax: 801-533-8004 [-- Attachment #2 --] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">; <head> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <meta name=ProgId content=Word.Document> <meta name=Generator content="Microsoft Word 10"> <meta name=Originator content="Microsoft Word 10"> <link rel=File-List href="cid:filelist.xml@01C231AC.05D11680"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/> <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if !mso]> <style> st1\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:553679495 -2147483648 8 0 66047 0;} @font-face {font-family:"Lucida Console"; panose-1:2 11 6 9 4 5 4 2 2 4; mso-font-charset:0; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-2147482993 6144 0 0 31 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} p {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} span.EmailStyle19 {mso-style-type:personal-reply; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:"Lucida Console"; mso-ascii-font-family:"Lucida Console"; mso-hansi-font-family:"Lucida Console"; color:black; font-weight:normal; font-style:normal; text-decoration:none; text-underline:none; text-decoration:none; text-line-through:none;} span.SpellE {mso-style-name:""; mso-spl-e:yes;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> </head> <body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'> <div class=Section1> <p class=MsoNormal><font size=2 color=black face="Lucida Console"><span style='font-size:10.0pt;font-family:"Lucida Console";color:black'>Did you <span class=SpellE>google</span> this error? I searched for it and got over 3500 results. What version of <span class=SpellE>mySQL</span> are you running? Did you check permissions? How about your php.ini? Log files? This isn’t related but you should do away with nuke all together. It’s horrible and insecure. Try these guys. http://drupal.org<o:p></o:p></span></font></p>; <p class=MsoNormal><font size=2 color=black face="Lucida Console"><span style='font-size:10.0pt;font-family:"Lucida Console";color:black'><o:p> </o:p></span></font></p> <div> <p class=MsoNormal><font size=2 color=black face="Lucida Console"><span style='font-size:10.0pt;font-family:"Lucida Console";color:black;mso-no-proof: yes'>sagacious (Mike)</span></font><font color=black><span style='color:black; mso-no-proof:yes'><o:p></o:p></span></font></p> <p class=MsoNormal><font size=2 color=black face="Lucida Console"><span style='font-size:10.0pt;font-family:"Lucida Console";color:black;mso-no-proof: yes'>Network administrator</span></font><font color=black><span style='color:black;mso-no-proof:yes'><o:p></o:p></span></font></p> <p class=MsoNormal><font size=2 color=black face="Lucida Console"><span style='font-size:10.0pt;font-family:"Lucida Console";color:black;mso-no-proof: yes'>The unixhideout network</span></font><font color=black><span style='color:black;mso-no-proof:yes'><o:p></o:p></span></font></p> <p class=MsoNormal><font size=2 color=black face="Lucida Console"><span style='font-size:10.0pt;font-family:"Lucida Console";color:black;mso-no-proof: yes'><a href="http://www.unixhideout.com">http://www.unixhideout.com</a></span></font><o:p></o:p></p>; </div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br> <b><span style='font-weight:bold'>From:</span></b> owner-freebsd-questions@FreeBSD.ORG [mailto:owner-freebsd-questions@FreeBSD.ORG] <b><span style='font-weight:bold'>On Behalf Of </span></b>Warner Joseph<br> <b><span style='font-weight:bold'>Sent:</span></b> Monday, July 22, 2002 6:08 PM<br> <b><span style='font-weight:bold'>To:</span></b> '</span></font><st1:PersonName><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>freebsd-questions@freebsd.org</span></font></st1:PersonName><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>'<br> <b><span style='font-weight:bold'>Subject:</span></b> MySQL problems after upgrade to 4.6-STABLE (Please Help)</span></font></p> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p> <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Hi,</span></font><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I just upgraded our production server from 4.5-STABLE to 4.6-STABLE.</span></font><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Everything seems fine, with the exception of my install of MySQL.</span></font><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Now, when trying to access our forum system or any database driven</span></font><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>pages, I get errors like this:</span></font><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>phpBB : <b><span style='font-weight:bold'>Critical Error</span></b> <br> <br> Could not connect to the database <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>..and this:</span></font><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><strong><b><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Warning</span></font></b></strong>: mysql_free_result(): supplied argument is not a valid MySQL result resource in <b><span style='font-weight:bold'>/usr/local/www/nuke/html/includes/sql_layer.php</span></b> on line <b><span style='font-weight:bold'>491</span></b><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face="Times New Roman"><span style='font-size:10.0pt'>I've done these upgrades many times and have never once experienced a problem like this.</span></font><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I'm in a real crunch and was wondering if someone could help?</span></font><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thanks</span></font><o:p></o:p></p> </div> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <p style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><br> </span></font><font face=Arial><span style='font-family:Arial'> </span></font> <br> <font face=Arial><span style='font-family:Arial'> </span></font> <br> <font face=Arial><span style='font-family:Arial'> </span></font> <br> <b><u><font size=1 color=blue face=Arial><span style='font-size:7.5pt; font-family:Arial;color:blue;font-weight:bold'>Siemens - Health Services</span></font></u></b><o:p></o:p></p> <p style='margin-left:.5in'><font size=1 face=Arial><span style='font-size: 7.5pt;font-family:Arial'>Joe Warner</span></font><font size=1><span style='font-size:7.5pt'> <br> </span></font><font size=1 face=Arial><span style='font-size:7.5pt;font-family: Arial'>Operations Technical Analyst II</span></font><font size=1><span style='font-size:7.5pt'> <br> </span></font><font size=1 face=Arial><span style='font-size:7.5pt;font-family: Arial'>215 North Admiral Byrd Rd., Salt Lake City, UT 84116</span></font><font size=1><span style='font-size:7.5pt'> <br> </span></font><font size=1 face=Arial><span style='font-size:7.5pt;font-family: Arial'>Ph: 801-539-4978</span></font><font size=1><span style='font-size: 7.5pt'> <br> </span></font><font size=1 face=Arial><span style='font-size:7.5pt;font-family: Arial'>Fax: 801-533-8004</span></font> <o:p></o:p></p> <div> <p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div> </div> </body> </html>help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000201c231cd$8d151120$0a01a8c0>