Subscriptions.php Error (Cron) - 06/10/2005 4:48 AM
When I run my subscriptions.php via Cron or Browser, I keep getting the following below error. Yet, it is sending email to my members who subscribed to a particular forum(s):
What is this error trying to tell me?
[]Script:
Line#:
SQL Error: 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 'AND t1.B_Approved = 'yes' AND t1.B_Board = '
SQL Error #: 1064
Query: SELECT t1.B_Number,t1.B_Posted,t2.U_Username,t1.B_IP,t1.B_Subject,t1.B_Body,t1.B_AnonName,t2.U_Number FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Number > AND t1.B_Approved = 'yes' AND t1.B_Board = 'hacking' AND t1.B_Posterid = t2.U_Number AND t1.B_Status <> 'M' ORDER BY t1.B_Number ASC[/]
What is this error trying to tell me?
[]Script:
Line#:
SQL Error: 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 'AND t1.B_Approved = 'yes' AND t1.B_Board = '
SQL Error #: 1064
Query: SELECT t1.B_Number,t1.B_Posted,t2.U_Username,t1.B_IP,t1.B_Subject,t1.B_Body,t1.B_AnonName,t2.U_Number FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Number > AND t1.B_Approved = 'yes' AND t1.B_Board = 'hacking' AND t1.B_Posterid = t2.U_Number AND t1.B_Status <> 'M' ORDER BY t1.B_Number ASC[/]