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) 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 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. Link to comment https://forums.phpfreaks.com/topic/165511-error-in-syntax/#findComment-872948 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.