|
| Can't access puzzles - SQL error message 2/8/10 1:37 AM Hi I have not been able to play Griddlers for 3 days as when I try to access the list of puzzles I get the following error message:
Error! org.apache.jasper.JasperException: javax.servlet.jsp.JspException: select SQL_CALC_FOUND_ROWS p.id,p.theme,p.description,p.uid,p.width,p.height,p.shapes triangels, p.created,p.colors,p.difficulty,p.bundle_id,p.bundle_parts,p.censored,p.kids, p.solved_count, 25*(sum_vote/count_vote) popularity,count_vote vcnt,width*height totalsize,ave_time avetime ,null solved from gpuzzles_SMS p where 1=1 and (p.width between and ) and (p.height between and ) and (p.colors between and ) and shapes order by limit 0 , : 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 ) and (p.height between and ) and (p.colors between and ) and sha' at line 13
I'm not sure if it is something I've done but this problem follows me whether I use Internet Explorer (version 7 - can't change this as it's at work) or Safari version 4.0.4
I'd be grateful if someone could get back to me on how to rectify this.
Thanks. |