"Monitoring Service", bag from "Open Archive", request history

Openfire Plugins Community Plugins
22

OK, I solved the problem with “MS SQL Server”, but this plugin will only work with the version of “MS SQL 2005” and above.

I corrected the 2 bugs:

  1. The bug related to ‘LIMIT-OFFSET’ (for “MS SQL Server” has replaced another expression, other databases will use ‘LIMIT-OFFSET’).

  2. The bug related to expression “DISTINCT” and field ‘ofMessageArchive.body’ (“DISTINCT” can not work with the type “ntext”, so I changed it to “nvarchar(max)”. http://technet.microsoft.com/en-us/library/ms187993(v=sql.90).aspx).

I hope it will work
Monitoring_1.4.0_patched_3.zip (1729919 Bytes)
Monitoring_1.3.2-rc1_patched_3.zip (1541499 Bytes)

1 Like