WillyXJ / facileManager

A modular suite of web apps built with the sysadmin in mind.
www.facilemanager.com
GNU General Public License v2.0
88 stars 37 forks source link

[BUG] FMDns sql error #509

Closed VarnyDK closed 3 years ago

VarnyDK commented 3 years ago

fM Version : 4.02 fmDNS Version : 4.02

In raising this issue, I confirm the following (please check boxes, eg [X]):


(BUG | ISSUE) Expected Behavior: Sorting vievs with chosen group

(BUG | ISSUE) Actual Behavior: Sorting views resulting in Database error

(BUG | ISSUE) Steps to reproduce: Select group and change the order of views

The query is missing '' around g_1 in the query: "UPDATE fm_dns_views SET view_order_id=1 WHERE view_id=9 AND server_serial_no=g_1 AND account_id='1']" FMDnsSQLBug

WillyXJ commented 3 years ago

This is now fixed in fmDNS 4.1.0 and later.