Pages: [1]
Author Topic: Non Active Games cause nasty SQL error  (Read 704 times)
Newbie
*

Karma: 0
Posts: 4


Email
on: Oct 04, 08, 09:21 AM

Hi

If I take a game that is in the database, and deactivate it (normally because I don't view it as suitable for my kids for some reason) it doesn't remove it from the listings (say top rated games, or recently played)

This is a bit of a problem, but worse is that when you click on the game, you get a nasty SQL error

Code:
ProArcadeScript DB ERROR!
Query failed.
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 'LIMIT 1' at line 1 - 1064.
QUERY: SELECT id, title, latin_title FROM pas_categories WHERE id= LIMIT 1

Any easy fix for that?

On an connected issue, any chance of implementing something so that perhaps I can have different levels of user, kids and over18s for example so that the kids only see a filtered games list?

Or maybe this can already be done and I've missed how.
Logged
Newbie
*

Karma: 0
Posts: 4


Email
Reply #1 on: Oct 04, 08, 09:29 AM

ah now I have seen this topic

http://www.proarcadescript.com/forum/index.php/topic,1697.0.html

which is about this, it says 1.3.1 but I assume the same will work for 1.3.2?
Logged
Administrator
Sr. Member
*

Karma: 7
Posts: 486


Email
Reply #2 on: Oct 04, 08, 11:21 AM

yes, it will for sure.

Actually some of the code mentioned in that topic is already applyed in v1.3.2, but looks like not in the "Toprated" block. So, please look through all blocks mentioned in that topic and apply the changes where necessary.
Logged
Pages: [1]
 
Jump to: