pokeminer icon indicating copy to clipboard operation
pokeminer copied to clipboard

Using mssql as database will cause exceptions in the reports pages.

Open Primalpat- opened this issue 8 years ago • 2 comments

I haven't had a chance to look at the code myself, but here is the exception/traceback: image image

Primalpat- avatar Aug 02 '16 19:08 Primalpat-

It looks like since I am using tsql, LIMIT is not supported. I think it is the same as if I used TOP instead.

When I have a chance I'll see if I can pull down the code, make some sort of detection, and rewrite the queries. I will submit a PR when finished.

Primalpat- avatar Aug 02 '16 19:08 Primalpat-

There are already some ifs for SQLite in place (like this), you can extend it in the same way I think.

modrzew avatar Aug 09 '16 20:08 modrzew