UBB.Developers Forums Community Development Programming MySQL and Server Configuration SQL Error

Greetings,

I am getting several of the following errors visable in the error logs.

/ubbthreads/pals/shoutdisplaypal.php

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)

"Can't connect to local MySQL server" generally means that the MySQL server itself is down. Speak to your host...

Are you still seeing these.

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.

Now that things are settling in on the new box you are on - restarts on our end should be very infrequent.

[]JoshPet said:
Are you still seeing these.

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.

Now that things are settling in on the new box you are on - restarts on our end should be very infrequent. [/]
All looks good now. The reason I asked is becuase I just updated the IIP and thought I did something wrong

Was just checking the Error Logs again and am now getting the following error listed several times:

/ubbthreads/dosearch.php

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'


I am assuming that the 'Bo_Cat' colum was not created? Am I warm?

TIA,

BWilliams

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.

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.

You might want to have a look at the official support forum of Infopop for .threads. This might be a but
(admitting that he is lazy and didn't look himself...)