I am getting these two errors when I visit the Results page:
user warning: 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 n.status <> 0' at line 7 query: SELECT COUNT(DISTINCT(n.nid)) FROM node n INNER JOIN betting_node bn ON n.nid = bn.nid INNER JOIN term_node t ON n.vid = t.vid LEFT JOIN betting_results r ON n.nid = r.nid LEFT JOIN bettingflexi_results fr ON n.nid = fr.nid LEFT JOIN bettingflexi_results_clear frc ON n.nid = frc.nid LEFT JOIN bettingrelation rl ON n.nid = rl.nid WHERE (n.type IN ('game','gameflexi')) AND (r.nid <> 0 OR fr.nid <> 0 OR frc.nid <> 0) AND ISNULL(rl.nid)) AND n.status <> 0 in /home/haciend5/public_html/insightrading.com/sites/all/modules/betting/betting.module on line 1877.
user warning: 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 n.status <> 0 ORDER BY bn.start DESC LIMIT 0, 10' at line 7 query: SELECT DISTINCT n.nid FROM node n INNER JOIN betting_node bn ON n.nid = bn.nid INNER JOIN term_node t ON n.vid = t.vid LEFT JOIN betting_results r ON n.nid = r.nid LEFT JOIN bettingflexi_results fr ON n.nid = fr.nid LEFT JOIN bettingflexi_results_clear frc ON n.nid = frc.nid LEFT JOIN bettingrelation rl ON n.nid = rl.nid WHERE (n.type IN ('game','gameflexi')) AND (r.nid <> 0 OR fr.nid <> 0 OR frc.nid <> 0) AND ISNULL(rl.nid)) AND n.status <> 0 ORDER BY bn.start DESC LIMIT 0, 10 in /home/haciend5/public_html/insightrading.com/sites/all/modules/betting/betting.module on line 1877.
These error messages are total gibberish to me. Can anybody decipher these?
Comments
Comment #1
solomonkitumba commentedis there anybody to help fix this issue