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>
next in thread | previous in thread | raw e-mail | index | archive | help
This is a multi-part message in MIME format. ------=_NextPart_000_0003_01C231AC.06037120 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0003_01C231AC.06037120 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" = xmlns=3D"http://www.w3.org/TR/REC-html40">; <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 10"> <meta name=3DOriginator content=3D"Microsoft Word 10"> <link rel=3DFile-List href=3D"cid:filelist.xml@01C231AC.05D11680"> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"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 */=20 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=3DEN-US link=3Dblue vlink=3Dpurple = style=3D'tab-interval:.5in'> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida = Console"><span style=3D'font-size:10.0pt;font-family:"Lucida Console";color:black'>Did = you <span class=3DSpellE>google</span> this error? I searched for it and got over = 3500 results. What version of <span class=3DSpellE>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=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida = Console"><span style=3D'font-size:10.0pt;font-family:"Lucida = Console";color:black'><o:p> </o:p></span></font></p> <div> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida = Console"><span style=3D'font-size:10.0pt;font-family:"Lucida = Console";color:black;mso-no-proof: yes'>sagacious (Mike)</span></font><font color=3Dblack><span = style=3D'color:black; mso-no-proof:yes'><o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida = Console"><span style=3D'font-size:10.0pt;font-family:"Lucida = Console";color:black;mso-no-proof: yes'>Network administrator</span></font><font color=3Dblack><span style=3D'color:black;mso-no-proof:yes'><o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida = Console"><span style=3D'font-size:10.0pt;font-family:"Lucida = Console";color:black;mso-no-proof: yes'>The unixhideout network</span></font><font color=3Dblack><span style=3D'color:black;mso-no-proof:yes'><o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida = Console"><span style=3D'font-size:10.0pt;font-family:"Lucida = Console";color:black;mso-no-proof: yes'><a = href=3D"http://www.unixhideout.com">http://www.unixhideout.com</a></span>= </font><o:p></o:p></p> </div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original = Message-----<br> <b><span style=3D'font-weight:bold'>From:</span></b> owner-freebsd-questions@FreeBSD.ORG [mailto:owner-freebsd-questions@FreeBSD.ORG] <b><span = style=3D'font-weight:bold'>On Behalf Of </span></b>Warner Joseph<br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, July 22, = 2002 6:08 PM<br> <b><span style=3D'font-weight:bold'>To:</span></b> = '</span></font><st1:PersonName><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt;font-family:Tahoma'>freebsd-questions@freebsd.o= rg</span></font></st1:PersonName><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt;font-family:Tahoma'>'<br> <b><span style=3D'font-weight:bold'>Subject:</span></b> MySQL problems = after upgrade to 4.6-STABLE (Please Help)</span></font></p> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>Hi,</span></font><o:p></o:p>= </p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DArial><span style=3D'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=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DArial><span style=3D'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=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DArial><span style=3D'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=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>pages, I get errors like = this:</span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>phpBB : <b><span = style=3D'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=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>..and = this:</span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><strong><b><font = size=3D3 face=3D"Times New Roman"><span = style=3D'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=3D'font-weight:bold'>/usr/local/www/nuke/html/includes/sql_layer.ph= p</span></b> on line <b><span = style=3D'font-weight:bold'>491</span></b><o:p></o:p></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3D"Times New Roman"><span style=3D'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=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DArial><span style=3D'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=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>Thanks</span></font><o:p></o= :p></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <p style=3D'margin-left:.5in'><font size=3D3 face=3D"Times New = Roman"><span style=3D'font-size:12.0pt'><br> </span></font><font face=3DArial><span = style=3D'font-family:Arial'> </span></font> <br> <font face=3DArial><span = style=3D'font-family:Arial'> </span></font> <br> <font face=3DArial><span = style=3D'font-family:Arial'> </span></font> <br> <b><u><font size=3D1 color=3Dblue face=3DArial><span = style=3D'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=3D'margin-left:.5in'><font size=3D1 face=3DArial><span = style=3D'font-size: 7.5pt;font-family:Arial'>Joe Warner</span></font><font size=3D1><span style=3D'font-size:7.5pt'> <br> </span></font><font size=3D1 face=3DArial><span = style=3D'font-size:7.5pt;font-family: Arial'>Operations Technical Analyst II</span></font><font size=3D1><span style=3D'font-size:7.5pt'> <br> </span></font><font size=3D1 face=3DArial><span = style=3D'font-size:7.5pt;font-family: Arial'>215 North Admiral Byrd Rd., Salt Lake City, UT = 84116</span></font><font size=3D1><span style=3D'font-size:7.5pt'> <br> </span></font><font size=3D1 face=3DArial><span = style=3D'font-size:7.5pt;font-family: Arial'>Ph: 801-539-4978</span></font><font size=3D1><span = style=3D'font-size: 7.5pt'> <br> </span></font><font size=3D1 face=3DArial><span = style=3D'font-size:7.5pt;font-family: Arial'>Fax: 801-533-8004</span></font> <o:p></o:p></p> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> </div> </body> </html> ------=_NextPart_000_0003_01C231AC.06037120-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000201c231cd$8d151120$0a01a8c0>