Author:   Lars Michelsen <[email protected]>
Date:     Fri Aug  5 09:58:41 2011 +0200
Committer:   Lars Michelsen <[email protected]>
Commit-Date: Fri Aug  5 09:58:41 2011 +0200

Bugfix: Fixed SQL syntax error in MySQL auth backend

---

 share/server/core/classes/CoreMySQLHandler.php |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/share/server/core/classes/CoreMySQLHandler.php 
b/share/server/core/classes/CoreMySQLHandler.php
index 987f185..62537ff 100644
--- a/share/server/core/classes/CoreMySQLHandler.php
+++ b/share/server/core/classes/CoreMySQLHandler.php
@@ -183,7 +183,7 @@ class CoreMySQLHandler {
 
     private function updateDb1060022() {
        // Create permissions for User/setOption
-        $this->query('INSERT INTO perms (mod, act, obj) VALUES (\'User\', 
\'setOption\', \'*\')');
+        $this->query('INSERT INTO perms (`mod`, `act`, `obj`) VALUES 
(\'User\', \'setOption\', \'*\')');
 
         // Assign the new permission to the managers, users, guests
         $RES = $this->query('SELECT roleId FROM roles WHERE name=\'Managers\' 
or \'Users (read-only)\' or name=\'Guests\'');


------------------------------------------------------------------------------
BlackBerry&reg; DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts. 
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
_______________________________________________
Nagvis-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nagvis-checkins

Reply via email to