Trek15 Posted July 10, 2009 Share Posted July 10, 2009 Hi guys. I'm getting a new error in an SMF forum that i don't understand why. I sure didn't mess with this code after i installed this. I would be very grateful if someone could look at this: Database 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 b.contributionsEnable GROUP BY t.id_member_started' at line 5 Apparently somewhere in this: $request = $smcFunc['db_query']('',' SELECT t.id_member_started, COUNT(t.id_topic) AS contributions FROM {db_prefix}topics AS t INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board) WHERE t.id_member_started IN ({raw:members}) AND b.contributionsEnable GROUP BY t.id_member_started', array ( 'members' => implode(',', $posters) Quote Link to comment https://forums.phpfreaks.com/topic/165511-error-in-syntax/ Share on other sites More sharing options...
wildteen88 Posted July 10, 2009 Share Posted July 10, 2009 You will be better of getting support over at the offical SMF support forum over at http://simplemachines.org Quote Link to comment https://forums.phpfreaks.com/topic/165511-error-in-syntax/#findComment-872945 Share on other sites More sharing options...
Trek15 Posted July 10, 2009 Author Share Posted July 10, 2009 Well, i'll try, but you guys here are always faster and more competent. Quote Link to comment https://forums.phpfreaks.com/topic/165511-error-in-syntax/#findComment-872948 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.