AGS Awards votes close at 13:59 BST on Wednesday 07 March 2018. You've already voted, so you've got 9 days and 11 hours left to wait before voting closes!

Author Topic: Bug reports  (Read 44247 times)

Gurok

  • Rottwheelers
  • When life hands you lemons, combine them with the mop
    • I can help with AGS tutoring
    •  
    • Best Innovation Award Winner 2016, for improving and extending the AGS scripting language
    •  
    • I can help with proof reading
    •  
    • I can help with scripting
    •  
    • Gurok worked on a game that was nominated for an AGS Award!
      Gurok worked on a game that won an AGS Award!
Re: Bug reports
« Reply #460 on: 01 Feb 2018, 03:08 »
Unticking all of the checkboxes under one of the first four headings on the game search page and performing a search gives you an SQL error:

Couldn't connect to database: 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 (committeeRating >= 2) AND (isCommercial = 0) AND (dl_url_broken = 0)' at line 1

Unticking all checkboxes under two headings will give you "AND AND (committeeRating...", three, "AND AND AND..." and four, "AND AND AND AND...".

AGA

  • Adventure Game Aficionado
  • Administrator
  • Mittens Deity
  • ¡Qué alí­vio!
    • Lifetime Achievement Award Winner
    •  
    • AGA worked on a game that was nominated for an AGS Award!
Re: Bug reports
« Reply #461 on: 01 Feb 2018, 17:51 »
Unticking all of the checkboxes under one of the first four headings on the game search page and performing a search gives you an SQL error:

Couldn't connect to database: 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 (committeeRating >= 2) AND (isCommercial = 0) AND (dl_url_broken = 0)' at line 1

Unticking all checkboxes under two headings will give you "AND AND (committeeRating...", three, "AND AND AND..." and four, "AND AND AND AND...".

Interesting!  I've already completely rewritten the search page, which will be released soonish.  Thanks for the report though.