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

   SQL Error to Del.icio.us Add to del.icio.us
  Digg SQL Error Digg it
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


Top Posters Last 30 Days
AllenAyres 13
Gizmo 10
willing 2
S7ARBVCK 2
MattUK 1
Kevin H 1
tackaberry 1
Who's Online
1 Registered (Gizmo), 31 Guests and 10 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Noob - need help, or a reality check!
by Gizmo
Yesterday at 03:21 AM
Here I am! Rock me like a Hurricane!
by AllenAyres
09/02/08 03:05 PM
[7.x] Generic Page Outside of forum directory
by Gizmo
08/30/08 05:43 PM
Team UBBDev Rides Again!
by Gizmo
08/28/08 11:45 PM
Multiple Identity Detector
by MattUK
08/28/08 04:10 PM
[7.3.x] ubb.links
by AllenAyres
08/26/08 09:57 AM
Installing FlashChat with 7.3
by Gizmo
08/23/08 05:36 AM
New Mods
Installing FlashChat with 7.3
by Paug
08/23/08 12:14 AM
[7.3.x] ubb.links
by AllenAyres
06/20/08 11:50 PM
[7.2.1] - Naked shoutbox
by sirdude
08/17/07 10:36 PM
[7.x] Generic Page Outside of forum directory
by
01/14/07 10:58 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
Newest Members
veedubb8, twentyseven, Claus1, welcomeback1, Paug
13327 Registered Users

 

 

 
fusionbb message board php hacks