Certain users keep appearing in my sqlerror log, but the error doesnt mean anything to me.<br />I just want to check really that it's nothing malicious!<br /><br /> [] Fri, Sep 03 2004 06:07:30 +0000<br />********<br />Script: /home/fordmond/public_html/ubbthreads/dosearch.php - Line: 399 <br />SELECT Bo_Keyword,Bo_Title,Bo_Read_Perm,Bo_Cat,Bo_Active<br />FROM w3t_Boards<br />WHERE ()<br />AND (1 )<br />AND Bo_Active='1'<br />- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')<br />AND (1 )<br />AND Bo_Active='1'' at line 3<br /> <br />Fri, Sep 03 2004 06:07:40 +0000<br />******** Script: /home/fordmond/public_html/ubbthreads/search.php - Line: 107 <br />SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter<br />FROM w3t_Boards<br />WHERE ()<br />AND Bo_Active = '1'<br /><br />ORDER BY Bo_Cat,Bo_Sorter<br />- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')<br />AND Bo_Active = '1'<br /><br />ORDER BY Bo_Cat,Bo_Sorter' at line 3<br /> <br />Fri, Sep 03 2004 06:07:43 +0000<br />******** Script: /home/fordmond/public_html/ubbthreads/search.php - Line: 107 <br />SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter<br />FROM w3t_Boards<br />WHERE ()<br />AND Bo_Active = '1'<br /><br />ORDER BY Bo_Cat,Bo_Sorter<br />- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')<br />AND Bo_Active = '1'<br /><br />ORDER BY Bo_Cat,Bo_Sorter' at line 3<br /> <br />Fri, Sep 03 2004 09:44:04 +0000<br />******** Script: - Line: <br />SELECT U_Number<br />FROM w3t_Users<br />WHERE ()<br />ORDER BY U_Number ASC<br />- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')<br />ORDER BY U_Number ASC' at line 3<br /> <br />Fri, Sep 03 2004 09:45:08 +0000<br />******** Script: - Line: <br />SELECT Bo_Keyword,Bo_Title,Bo_Write_Perm,Bo_Reply_Perm,Bo_Read_Perm<br />FROM w3t_Boards<br />WHERE Bo_Keyword != ''<br />AND ()<br /><br />- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4<br /> <br /> [/] <br /><br /><br />the ******** is his username, just a FYI

and whats even weirder, this thread has had over 3000 views in less than a week?<br />wtf? lol!!!

Try this - <br /><br />SELECT U_Groups <br />FROM w3t_Users<br />WHERE U_Username = 'xxxxxxx'<br /><br /><br />My guess is the user isn't assigned to any usergroup - which causes all the queries to produce errors. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />If it comes up empty - add the user to the "Users" group. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Yeah, that was it.<br />you know, I could have sworn I checked that already <img src="http://www.ubbdev.com/forum/images/graemlins/smashpc.gif" alt="" />