php forum
php mysql forum
php mysql smarty
 
Topic Options
#270792 - 03/12/04 11:49 AM SQL Error
BWilliams_dup1 Offline
Member

Registered: 03/09/03
Posts: 171
Loc: Southern California
Greetings,<br /><br />I am getting several of the following errors visable in the error logs.<br /><br />/ubbthreads/pals/shoutdisplaypal.php<br /><br />Unable to do_query: SELECT U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned,U_Agree FROM w3t_Users WHERE U_Number = '102' - Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)

Top
#270793 - 03/12/04 12:10 PM Re: SQL Error [Re: vajraman]
Charles Capps Offline
Admin Emeritus
Resident Code Hacker

Registered: 01/09/00
Posts: 5438
Loc: Lynnwood, WA
"Can't connect to local MySQL server" generally means that the MySQL server itself is down. Speak to your host...
_________________________
UBB.classic: Love it or hate it, it was mine.

Top
#270794 - 03/12/04 04:34 PM Re: SQL Error [Re: vajraman]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Are you still seeing these.<br /><br />Cpanel did an emergency security update of their software which hosed up the CPanels ofmany of the servers on the net. In fixing that today - a reboot was needed. So these errors are common when the box is rebooted as there is a few moments when the webserver (Apache) comes back online but MySQL hasn't quite started up yet.<br /><br />Now that things are settling in on the new box you are on - restarts on our end should be very infrequent. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#270795 - 03/12/04 06:31 PM Re: SQL Error [Re: Daine]
BWilliams_dup1 Offline
Member

Registered: 03/09/03
Posts: 171
Loc: Southern California
[]JoshPet said:<br /> Are you still seeing these.<br /><br />Cpanel did an emergency security update of their software which hosed up the CPanels ofmany of the servers on the net. In fixing that today - a reboot was needed. So these errors are common when the box is rebooted as there is a few moments when the webserver (Apache) comes back online but MySQL hasn't quite started up yet.<br /><br />Now that things are settling in on the new box you are on - restarts on our end should be very infrequent. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> [/]<br />All looks good now. The reason I asked is becuase I just updated the IIP and thought I did something wrong <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />

Top
#270796 - 03/15/04 02:52 PM Re: SQL Error [Re: Rick8765]
BWilliams_dup1 Offline
Member

Registered: 03/09/03
Posts: 171
Loc: Southern California
Was just checking the Error Logs again and am now getting the following error listed several times:<br /><br /> /ubbthreads/dosearch.php<br /><br />Unable to do_query: SELECT t1.B_Number,t1.B_Main,t3.U_Username,t1.B_Subject,t1.B_Posted,t1.B_Board,t3.U_Color,t1.B_Reged,t1.B_Icon,t1.B_Posterid,t1.B_Status,t1.B_AnonName,t1.B_Body FROM w3t_Posts AS t1, w3t_Users AS t3 WHERE t1.B_Approved = 'yes' AND t1.B_Posterid = t3.U_Number AND t1.B_Status <> 'M' AND t1.B_Board IN ('WSS','UER','PER','psd','oldpsd','fd','69fd','order','racing','anything','4sale','chat','ua','990373psd','TH','polls','jokes','newbie') AND (Bo_Cat = 6 ) ORDER BY B_Posted DESC LIMIT 26 - Unknown column 'Bo_Cat' in 'where clause' <br /><br /><br />I am assuming that the 'Bo_Cat' colum was not created? Am I warm?<br /><br />TIA,<br /><br />BWilliams

Top
#270797 - 03/15/04 03:12 PM Re: SQL Error [Re: vajraman]
dimopoulos Offline
Kahuna

Registered: 08/18/02
Posts: 1271
Loc: Vienna, Austria
Bo_Cat exists only in the w3t_Boards table if I am not mistaken. The query here selects from the w3t_Posts and w3t_Users tables. <br /><br />I had a look at the script and there is something I didn't quite understand there since the selection of the Bo_Cat column in the Where criteria wouldn't do any good since the table itself is not included in the From clause.<br /><br />You might want to have a look at the official support forum of Infopop for .threads. This might be a but <br />(admitting that he is lazy and didn't look himself...)
_________________________
Nikos

Top


Who's Online
0 registered (), 25 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Forum 'Trader Ratings'.
by blaaskaak
11/20/08 08:27 AM
Problems reading a lot of old posts here
by Ruben Rocha
11/18/08 04:33 PM
PhotoPost BB Code Popup
by Iann128
11/15/08 01:24 PM
Customization needed
by Gizmo
11/12/08 12:28 PM
Team UBBDev Rides Again!
by AllenAyres
11/11/08 02:16 PM
Active Topics.
by AllenAyres
11/11/08 02:13 PM
Looking for a simple upload script
by AllenAyres
11/11/08 02:12 PM
New Mods
Forum 'Trader Ratings'.
by McLemore
11/19/08 02:14 PM
[7.4] Keep log of custom title changes
by blaaskaak
10/27/08 07:51 AM
User Authentication Class
by
01/19/07 02:59 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
PhotoPost BB Code Popup
by
11/06/06 05:43 PM
Newest Members
nick1, Begbie, cenk, MATTO, DougMMcts
13362 Registered Users
Top Posters
AllenAyres 25448
JoshPet 11330
Rick 8372
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438

 

 

 
fusionbb message board php hacks