Who's Online?
757 Users
View Users
Combination View Flat View Tree View
Threads [ Previous | Next ]
Can't access puzzles - SQL error message
toggle
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.
RE: Can't access puzzles - SQL error message
Answer Answer (Unmark)
2/8/10 2:10 AM as a reply to rackle.
Just wanted to report that the problem seems to have rectified itself on my mac though I'm not sure how. I'll try on my PC at work tomorrow, and if all goes well then no further action may be required.
Forum Moderators: griddlers_team, hagitm, Ra100, chefmomster2, domi77, dreamtheater, elimaor, ElinaMaria, Jeltje, sslug.
Please read the Board-wide Policies before you start using this forum.
Feywa
Web's Best Brain Games