[patch] SQL Error in "Top Downloads" page when using SQL Server

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Install JForum against a SQL Server database
2. Try to load the "Top Downloads" page

What is the expected output? What do you see instead?
Should display list of top downloads; instead shows a SQL error.

Please provide any additional information below.

The problem is that SQL Server doesn't support the "LMIT m,n" operator. In this 
case, it can be fixed by using SQL Server's "TOP (n)" syntax instead.

Attached is a patch which adds the necessary statement to 
src/main/config/database/sqlserver/sqlserver.sql.

Original issue reported on code.google.com by max.b...@gmail.com on 3 Feb 2012 at 4:00

Attachments:

• sqlserver.sql.patch

[GoogleCodeExporter]

Fixed in revision r192

Original comment by andow...@gmail.com on 1 Jun 2012 at 11:02

• Changed state: Fixed

[GoogleCodeExporter]

Cool!

Original comment by max.b...@gmail.com on 1 Jun 2012 at 1:36