Sort of a how do I...more of a fact-finding mission.
I have never used subscriptions, but the latest board I have set up for someone requires it, ok, no big deal. Go into my php cron directory, set the path, and add a cron job to my set (every six hours for kicks).
[]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 = 'officers' AND t1.B_Posterid = t2.U_Number AND t1.B_Status <> 'M' ORDER BY t1.B_Number ASC
Please use your back button to return to the previous page. [/]
That is what I get when running the cron job manually - but it DOES seem to work. Is something broken? I am just now opening this code...so will see what I can find.