09692: Crash when saving global permissions if AuditLog is active

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

09692	Bug reports	Plugins	public	2015-06-18 00:00	2015-08-24 12:35

Reporter	aesteban	Assigned To	sammousa
Priority	normal	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	2.06+

Summary	09692: Crash when saving global permissions if AuditLog is active
Description	If AuditLog is active saving global permissions is imposible because application crash
Steps To Reproduce	1.- Enable AuditLog plugin 2.- Create an user 3.- Click to set global permissions 4.- Modify a permission 5.- Click on "Save" Application crashes (see attached PHP notice)
Tags	No tags attached.
Attached Files	savepermissions.html (21,924 bytes) <!-- saved from url=(0070)http://localhost/lsurveymaster/index.php/admin/user/sa/savepermissions --> <html><head><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"></head><body><br> <font size="1"><table class="xdebug-error xe-fatal-error" dir="ltr" border="1" cellspacing="0" cellpadding="1"> <tbody><tr><th align="left" bgcolor="#f57900" colspan="5"><span style="background-color: #cc0000; color: #fce94f; font-size: x-large;">( ! )</span> Fatal error: Class 'ls\pluginmanager\Permission' not found in /usr/share/nginx/html/lsurveymaster/application/libraries/PluginManager/LimesurveyApi.php on line <i>315</i></th></tr> <tr><th align="left" bgcolor="#e9b96e" colspan="5">Call Stack</th></tr> <tr><th align="center" bgcolor="#eeeeec">#</th><th align="left" bgcolor="#eeeeec">Time</th><th align="left" bgcolor="#eeeeec">Memory</th><th align="left" bgcolor="#eeeeec">Function</th><th align="left" bgcolor="#eeeeec">Location</th></tr> <tr><td bgcolor="#eeeeec" align="center">1</td><td bgcolor="#eeeeec" align="center">0.0003</td><td bgcolor="#eeeeec" align="right">242248</td><td bgcolor="#eeeeec">{main}( )</td><td title="/usr/share/nginx/html/lsurveymaster/index.php" bgcolor="#eeeeec">../index.php<b>:</b>0</td></tr> <tr><td bgcolor="#eeeeec" align="center">2</td><td bgcolor="#eeeeec" align="center">0.0221</td><td bgcolor="#eeeeec" align="right">1050728</td><td bgcolor="#eeeeec">CApplication->run( )</td><td title="/usr/share/nginx/html/lsurveymaster/index.php" bgcolor="#eeeeec">../index.php<b>:</b>211</td></tr> <tr><td bgcolor="#eeeeec" align="center">3</td><td bgcolor="#eeeeec" align="center">0.0229</td><td bgcolor="#eeeeec" align="right">1073872</td><td bgcolor="#eeeeec">CWebApplication->processRequest( )</td><td title="/usr/share/nginx/html/lsurveymaster/framework/base/CApplication.php" bgcolor="#eeeeec">../CApplication.php<b>:</b>180</td></tr> <tr><td bgcolor="#eeeeec" align="center">4</td><td bgcolor="#eeeeec" align="center">0.0234</td><td bgcolor="#eeeeec" align="right">1074168</td><td bgcolor="#eeeeec">CWebApplication->runController( )</td><td title="/usr/share/nginx/html/lsurveymaster/framework/web/CWebApplication.php" bgcolor="#eeeeec">../CWebApplication.php<b>:</b>141</td></tr> <tr><td bgcolor="#eeeeec" align="center">5</td><td bgcolor="#eeeeec" align="center">0.1648</td><td bgcolor="#eeeeec" align="right">2838032</td><td bgcolor="#eeeeec">AdminController->run( )</td><td title="/usr/share/nginx/html/lsurveymaster/framework/web/CWebApplication.php" bgcolor="#eeeeec">../CWebApplication.php<b>:</b>282</td></tr> <tr><td bgcolor="#eeeeec" align="center">6</td><td bgcolor="#eeeeec" align="center">0.1895</td><td bgcolor="#eeeeec" align="right">2906416</td><td bgcolor="#eeeeec">CController->run( )</td><td title="/usr/share/nginx/html/lsurveymaster/application/controllers/AdminController.php" bgcolor="#eeeeec">../AdminController.php<b>:</b>164</td></tr> <tr><td bgcolor="#eeeeec" align="center">7</td><td bgcolor="#eeeeec" align="center">0.1907</td><td bgcolor="#eeeeec" align="right">2961304</td><td bgcolor="#eeeeec">CController->runActionWithFilters( )</td><td title="/usr/share/nginx/html/lsurveymaster/framework/web/CController.php" bgcolor="#eeeeec">../CController.php<b>:</b>265</td></tr> <tr><td bgcolor="#eeeeec" align="center">8</td><td bgcolor="#eeeeec" align="center">0.1907</td><td bgcolor="#eeeeec" align="right">2961448</td><td bgcolor="#eeeeec">CController->runAction( )</td><td title="/usr/share/nginx/html/lsurveymaster/framework/web/CController.php" bgcolor="#eeeeec">../CController.php<b>:</b>286</td></tr> <tr><td bgcolor="#eeeeec" align="center">9</td><td bgcolor="#eeeeec" align="center">0.1908</td><td bgcolor="#eeeeec" align="right">2961824</td><td bgcolor="#eeeeec">Survey_Common_Action->runWithParams( )</td><td title="/usr/share/nginx/html/lsurveymaster/framework/web/CController.php" bgcolor="#eeeeec">../CController.php<b>:</b>308</td></tr> <tr><td bgcolor="#eeeeec" align="center">10</td><td bgcolor="#eeeeec" align="center">0.1910</td><td bgcolor="#eeeeec" align="right">2967880</td><td bgcolor="#eeeeec">CAction->runWithParamsInternal( )</td><td title="/usr/share/nginx/html/lsurveymaster/application/core/Survey_Common_Action.php" bgcolor="#eeeeec">../Survey_Common_Action.php<b>:</b>99</td></tr> <tr><td bgcolor="#eeeeec" align="center">11</td><td bgcolor="#eeeeec" align="center">0.1911</td><td bgcolor="#eeeeec" align="right">2968064</td><td bgcolor="#eeeeec"><a href="http://www.php.net/ReflectionMethod.invokeArgs" target="_new">invokeArgs</a> ( )</td><td title="/usr/share/nginx/html/lsurveymaster/framework/web/actions/CAction.php" bgcolor="#eeeeec">../CAction.php<b>:</b>108</td></tr> <tr><td bgcolor="#eeeeec" align="center">12</td><td bgcolor="#eeeeec" align="center">0.1911</td><td bgcolor="#eeeeec" align="right">2968592</td><td bgcolor="#eeeeec">UserAction->savepermissions( )</td><td title="/usr/share/nginx/html/lsurveymaster/framework/web/actions/CAction.php" bgcolor="#eeeeec">../CAction.php<b>:</b>108</td></tr> <tr><td bgcolor="#eeeeec" align="center">13</td><td bgcolor="#eeeeec" align="center">0.2779</td><td bgcolor="#eeeeec" align="right">3298736</td><td bgcolor="#eeeeec">Permission::setPermissions( )</td><td title="/usr/share/nginx/html/lsurveymaster/application/controllers/admin/useraction.php" bgcolor="#eeeeec">../useraction.php<b>:</b>457</td></tr> <tr><td bgcolor="#eeeeec" align="center">14</td><td bgcolor="#eeeeec" align="center">0.3163</td><td bgcolor="#eeeeec" align="right">3630208</td><td bgcolor="#eeeeec">ls\pluginmanager\PluginManager->dispatchEvent( )</td><td title="/usr/share/nginx/html/lsurveymaster/application/models/Permission.php" bgcolor="#eeeeec">../Permission.php<b>:</b>384</td></tr> <tr><td bgcolor="#eeeeec" align="center">15</td><td bgcolor="#eeeeec" align="center">0.3163</td><td bgcolor="#eeeeec" align="right">3630456</td><td bgcolor="#eeeeec"><a href="http://www.php.net/function.call-user-func" target="_new">call_user_func</a> ( )</td><td title="/usr/share/nginx/html/lsurveymaster/application/libraries/PluginManager/PluginManager.php" bgcolor="#eeeeec">../PluginManager.php<b>:</b>193</td></tr> <tr><td bgcolor="#eeeeec" align="center">16</td><td bgcolor="#eeeeec" align="center">0.3163</td><td bgcolor="#eeeeec" align="right">3630848</td><td bgcolor="#eeeeec">AuditLog->beforePermissionSetSave( )</td><td title="/usr/share/nginx/html/lsurveymaster/application/libraries/PluginManager/PluginManager.php" bgcolor="#eeeeec">../PluginManager.php<b>:</b>193</td></tr> <tr><td bgcolor="#eeeeec" align="center">17</td><td bgcolor="#eeeeec" align="center">0.3213</td><td bgcolor="#eeeeec" align="right">3648024</td><td bgcolor="#eeeeec">ls\pluginmanager\LimesurveyApi->getPermissionSet( )</td><td title="/usr/share/nginx/html/lsurveymaster/plugins/AuditLog/AuditLog.php" bgcolor="#eeeeec">../AuditLog.php<b>:</b>83</td></tr> </tbody></table></font> <!-- start profiling summary --> <table class="yiiLog" width="100%" cellpadding="2" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;"> <tbody><tr> <th style="background:black;color:white;" colspan="6"> Profiling Summary Report (Time: 0.32923s, Memory: 3,617KB) </th> </tr> <tr style="background-color: #ccc;"> <th>Procedure</th> <th>Count</th> <th>Total (s)</th> <th>Avg. (s)</th> <th>Min. (s)</th> <th>Max. (s)</th> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' \|\| consrc \|\| ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='lime_settings_global', :schema='public')</td> <td align="center">1</td> <td align="center">0.00627</td> <td align="center">0.00627</td> <td align="center">0.00627</td> <td align="center">0.00627</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='lime_surveys', :schema='public')</td> <td align="center">1</td> <td align="center">0.00453</td> <td align="center">0.00453</td> <td align="center">0.00453</td> <td align="center">0.00453</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='lime_settings_global', :schema='public')</td> <td align="center">1</td> <td align="center">0.00415</td> <td align="center">0.00415</td> <td align="center">0.00415</td> <td align="center">0.00415</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' \|\| consrc \|\| ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='lime_plugins', :schema='public')</td> <td align="center">1</td> <td align="center">0.00350</td> <td align="center">0.00350</td> <td align="center">0.00350</td> <td align="center">0.00350</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' \|\| consrc \|\| ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='lime_users', :schema='public')</td> <td align="center">1</td> <td align="center">0.00338</td> <td align="center">0.00338</td> <td align="center">0.00338</td> <td align="center">0.00338</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' \|\| consrc \|\| ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='lime_surveys', :schema='public')</td> <td align="center">1</td> <td align="center">0.00322</td> <td align="center">0.00322</td> <td align="center">0.00322</td> <td align="center">0.00322</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='lime_users', :schema='public')</td> <td align="center">1</td> <td align="center">0.00264</td> <td align="center">0.00264</td> <td align="center">0.00264</td> <td align="center">0.00264</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='lime_plugins', :schema='public')</td> <td align="center">1</td> <td align="center">0.00259</td> <td align="center">0.00259</td> <td align="center">0.00259</td> <td align="center">0.00259</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' \|\| consrc \|\| ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='lime_permissions', :schema='public')</td> <td align="center">1</td> <td align="center">0.00242</td> <td align="center">0.00242</td> <td align="center">0.00242</td> <td align="center">0.00242</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='lime_permissions', :schema='public')</td> <td align="center">1</td> <td align="center">0.00191</td> <td align="center">0.00191</td> <td align="center">0.00191</td> <td align="center">0.00191</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_settings_global', :schema='public')</td> <td align="center">1</td> <td align="center">0.00186</td> <td align="center">0.00186</td> <td align="center">0.00186</td> <td align="center">0.00186</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT * FROM "lime_permissions" "t" WHERE "t"."entity_id"=:yp0 AND "t"."entity"=:yp1 AND "t"."uid"=:yp2 AND "t"."permission"=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1, :yp3='superadmin')</td> <td align="center">1</td> <td align="center">0.00184</td> <td align="center">0.00184</td> <td align="center">0.00184</td> <td align="center">0.00184</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT * FROM "lime_users" "t" WHERE "t"."parent_id"=:yp0 LIMIT 1. Bound with :yp0=0)</td> <td align="center">1</td> <td align="center">0.00169</td> <td align="center">0.00169</td> <td align="center">0.00169</td> <td align="center">0.00169</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t")</td> <td align="center">1</td> <td align="center">0.00140</td> <td align="center">0.00140</td> <td align="center">0.00140</td> <td align="center">0.00140</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_users', :schema='public')</td> <td align="center">1</td> <td align="center">0.00139</td> <td align="center">0.00139</td> <td align="center">0.00139</td> <td align="center">0.00139</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_plugins', :schema='public')</td> <td align="center">1</td> <td align="center">0.00128</td> <td align="center">0.00128</td> <td align="center">0.00128</td> <td align="center">0.00128</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_permissions', :schema='public')</td> <td align="center">1</td> <td align="center">0.00123</td> <td align="center">0.00123</td> <td align="center">0.00123</td> <td align="center">0.00123</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0. Bound with :yp0=1)</td> <td align="center">1</td> <td align="center">0.00111</td> <td align="center">0.00111</td> <td align="center">0.00111</td> <td align="center">0.00111</td> </tr> <tr style="background:#FFFFFF"> <td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_surveys', :schema='public')</td> <td align="center">1</td> <td align="center">0.00104</td> <td align="center">0.00104</td> <td align="center">0.00104</td> <td align="center">0.00104</td> </tr> <tr style="background:#F5F5F5"> <td>system.db.CDbCommand.query(SELECT * FROM "lime_users" "t" WHERE "t"."uid"=1 LIMIT 1)</td> <td align="center">1</td> <td align="center">0.00099</td> <td align="center">0.00099</td> <td align="center">0.00099</td> <td align="center">0.00099</td> </tr></tbody></table> <!-- end of profiling summary --></body></html> savepermissions.html (21,924 bytes)

Bug heat	4
Complete LimeSurvey version number (& build)	2b83227e2570460fe608659db7d5
I will donate to the project if issue is resolved	No
Browser	Firefox
Database type & version	Postgresql 9.3
Server OS (if known)	Debian Wheezy
Webserver software & version (if known)	Nginx 1.4.6
PHP Version	5.5.9

User List	There are no users monitoring this issue.

Date Modified	Username	Field	Change
2015-06-18 00:00	aesteban	New Issue
2015-06-18 00:00	aesteban	File Added: savepermissions.html
2015-06-18 00:01	aesteban	Summary	Crash when saving global permissions if AuditLog is enabled => Crash when saving global permissions if AuditLog is active
2015-06-18 00:01	aesteban	Description Updated
2015-06-18 10:55	c_schmitz	Assigned To	=> sammousa
2015-06-18 10:55	c_schmitz	Status	new => assigned
2015-06-18 11:23	sammousa	Changeset attached	=> LimeSurvey master f9b0d650
2015-06-18 11:23	sammousa	Note Added: 32422
2015-06-18 11:23	sammousa	Resolution	open => fixed
2015-06-18 11:23	sammousa	Status	assigned => resolved
2015-08-24 12:35	c_schmitz	Note Added: 32993
2015-08-24 12:35	c_schmitz	Status	resolved => closed

sammousa 2015-06-18 11:23 reporter ~32422	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15462

c_schmitz 2015-08-24 12:35 administrator ~32993	2.06+ Build 150824 released

LimeSurvey: master f9b0d650 2015-06-18 11:22 sammousa Details Diff	Fixed issue 09692: Crash when saving global permissions if AuditLog is active Dev Changed class names to be fully qualified.		Affected Issues 09692
	mod - application/libraries/PluginManager/LimesurveyApi.php		Diff File

View Issue Details

Users monitoring this issue

Activities

Related Changesets

Issue History