I set up this silly voting site last week for homecoming royalty and it was working great with over 10,000 votes... until today. I’m now getting a parse error but I can’t make heads or tails of it. Any help would be fantastic! Thank you.
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Incorrect information in file: './pubcrawl_crawl/ep_poll.frm' »
SQL: SELECT p.idPoll AS 'id', p.Title AS 'title', IF(p.StartDate > 0, DATE_FORMAT(p.StartDate, '%Y-%m-%d %H:%i'), '-') AS 'sdate', IF(p.EndDate > 0, DATE_FORMAT(p.EndDate, '%Y-%m-%d %H:%i'), '-') AS 'edate', p.isActive AS 'active', (SELECT COUNT( ln.idLang ) FROM ep_language ln) * (SELECT COUNT(ch.idChoice)+1 FROM ep_choice ch WHERE ch.idPoll = p.idPoll) - (SELECT COUNT(t.idPoll) FROM ep_translation t WHERE t.idPoll = p.idPoll) AS 'translate', (SELECT SUM(c.Votes) FROM ep_choice c WHERE c.idPoll = p.idPoll) AS 'votes', (SELECT COUNT(c.idChoice) FROM ep_choice c WHERE c.idPoll = p.idPoll) AS 'choices' FROM ep_poll p ORDER BY p.StartDate DESC 
