HTML typo causing a MySQL error....

Support and queries relating to all previous versions of ZoneMinder
Locked
User avatar
tgutwin
Posts: 24
Joined: Thu Jan 12, 2006 4:02 am
Location: North Vancouver, Canada

HTML typo causing a MySQL error....

Post by tgutwin »

In the new user dialog there is a typo "'" character inside the
MonitorIds input field

Code: Select all

<input type="text" name="new_user['MonitorIds]"
see the ' char right before the word MonitorIds

It causes the following error when the form is submitted.
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 '\'MonitorIds = '1,2'' at line 1
You can recreate the error by doing the following:
open up the 'users' tab in options dialog then
click the 'add new user'
view the source and scroll right to the bottom....

That'll be an easy fix.
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post by zoneminder »

Thanks. I've updated it ready for the next release.
Phil
Locked