folder coma issue? - Githubissues

What steps will reproduce the problem?
As an admin :
1. Create a folder with a coma (ie : tes't)
2. Delete it
3. confirm

What is the expected output? What do you see instead?
Expected : The folder should be deleted
Problem : I have a "Application configuration is invalid" windows.  The folder 
is indeed deleted in the hard drive but still shown in mollify.

What version of the product are you using? On what operating system?
Molify 1.8.5.3 on OS  (distant server.  I'll ask).

Please provide any additional information below.
I tried to do the same with non admin privileged.  After creating the folder, I 
was unable to open it (unlike the admin account) and when trying, I got this 
error (backend debug enabled but not client) :

-----
Invalid configuration

Error executing query (SELECT item_id, permission, (IF(user_id = '4', 1, 
IF(user_id = '0', 3, 2))) as ind from files_molify_item_permission where 
(user_id in (4,5,0)) and item_id in (SELECT distinct item_id from 
files_molify_item_permission p, files_molify_item_id i where p.item_id = i.id 
and (user_id in (4,5,0)) and i.path REGEXP '^2:/te't/[^/]+[/]?$') order by 
item_id asc, ind asc, permission desc): 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 't/[^/]+[/]?$') order by item_id asc, ind asc, permission 
desc' at line 1

MySQL DB: mdejdrnosmil@mysql5-12.pro:mdejdrnosmil(files_molify_) port= socket=
EVENT HANDLER: registering '*': NotificatorHandler
EVENT HANDLER: registering '*': EventLogger
VERSION: 1.8.5.3 SERVER: {UNIQUE_ID:TvxtUAoAVCYAACa@N78AAABC, 
GEOIP_COUNTRY_CODE:BE, GEOIP_COUNTRY_NAME:Belgium, GEOIP_REGION:11, 
GEOIP_CITY:Brussels, GEOIP_DMA_CODE:0, GEOIP_AREA_CODE:0, 
GEOIP_LATITUDE:50.833302, GEOIP_LONGITUDE:4.333300, 
SCRIPT_URL:/files/backend/r.php/filesystem/4efc6d4e86691/info/, 
SCRIPT_URI:http://www.srlive.be/files/backend/r.php/filesystem/4efc6d4e86691/inf
o/, PHP_VER:5, HTTP_REMOTE_IP:217.136.86.189, HTTP_ORIGIN:http://www.srlive.be, 
HTTP_DNT:1, HTTP_REFERER:http://www.srlive.be/files/, CONTENT_TYPE:text/plain; 
charset=UTF-8, HTTP_COOKIE:240plan=R3498010332; 
MOLLIFY-SESSION=154be703a93d8b8912f8819a552a642a; 
fsb2_sid=fa79ad71459a8e7328000a65c58d6630; 
fsb2_cookie_view=a%3A5%3A%7Bi%3A0%3Bs%3A2%3A%2295%22%3Bi%3A1%3Bs%3A3%3A%22153%22
%3Bi%3A2%3Bs%3A3%3A%22160%22%3Bi%3A3%3Bs%3A2%3A%2254%22%3Bi%3A4%3Bs%3A1%3A%223%2
2%3B%7D; fsb2_last_visit=1325163964; fsb2_unread_module=list; 
fsb2_auto=6e4a96af26bf6000daf7ed3f1b099ad4b57346bc, CONTENT_LENGTH:11, 
SCRIPT_FILENAME:/homez.50/mdejdr/nos/www/files/backend/r.php, 
SERVER_PROTOCOL:HTTP/1.1, REQUEST_METHOD:POST, QUERY_STRING:, 
REQUEST_URI:/files/backend/r.php/filesystem/4efc6d4e86691/info/, 
SCRIPT_NAME:/files/backend/r.php, PATH_INFO:/filesystem/4efc6d4e86691/info/, 
PATH_TRANSLATED:/homez.50/mdejdr/nos/www/filesystem/4efc6d4e86691/info/, 
UID:2753, PHP_SELF:/filesystem/4efc6d4e86691/info/, REQUEST_TIME:1325165904, 
argv:{0:r.php}, argc:1}
SETTINGS: {host_public_address:http://www.srlive.be, timezone:Europe/Brussels, 
enable_file_upload_progress:1, enable_zip_download:1, enable_public_links:, 
enable_mail_notification:1, enable_retrieve_url:, 
new_folder_permission_mask:511, support_output_buffer:1, debug:1}
CONFIGURATION PROVIDER (MySQLConfiguration): supported 
features={0:change_password, 1:descriptions, 2:administration, 3:user_groups, 
4:permission_inheritance} auth=1
FEATURES: {limited_http_methods:, file_upload:1, folder_actions:1, 
file_upload_progress:1, zip_download:1, change_password:1, descriptions:1, 
administration:1, user_groups:1, public_links:, mail_notification:1, 
retrieve_url:, folder_protection:, file_view:1, file_preview:1, file_edit:1, 
event_logging:1}
FILESYSTEM: allowed_file_upload_types={}
SESSION: {user_id:4, groups:{0:{id:5, name:folk, description:fichier folkeux 
(partage...)}}, username:folk, default_permission:RW, auth:PW}
AUTH: is_authentication_required=1, is_authenticated=1
REQUEST: method=post, path={0:filesystem, 1:4efc6d4e86691, 2:info}, 
ip=217.136.86.189, params={240plan:R3498010332, 
MOLLIFY-SESSION:154be703a93d8b8912f8819a552a642a, 
fsb2_sid:fa79ad71459a8e7328000a65c58d6630, 
fsb2_cookie_view:a:5:{i:0;s:2:\"95\";i:1;s:3:\"153\";i:2;s:3:\"160\";i:3;s:2:\"5
4\";i:4;s:1:\"3\";}, fsb2_last_visit:1325163964, fsb2_unread_module:list, 
fsb2_auto:6e4a96af26bf6000daf7ed3f1b099ad4b57346bc}, data={data:{}}
SERVICE (FilesystemServices): is_auth_required=1
DB: select path from files_molify_item_id where id='4efc6d4e86691'
DB: SELECT id, name, path FROM files_molify_folder where id='2'
DB: select id from files_molify_item_id where path='2:/'
DB: SELECT permission FROM (SELECT permission, user_id, 1 AS 'category', 
(IF(user_id = '4', 1, IF(user_id = '0', 3, 2))) AS 'subcategory' FROM 
files_molify_item_permission WHERE item_id = '4ef0d640907f9' AND (user_id in 
(0,4,5))) as u ORDER BY u.category ASC, u.subcategory ASC, u.permission DESC
Permission cache put [4ef0d640907f9]=rw
DB: SELECT item_id, permission, (IF(user_id = '4', 1, IF(user_id = '0', 3, 2))) 
as ind from files_molify_item_permission where (user_id in (4,5,0)) and item_id 
in (SELECT distinct item_id from files_molify_item_permission p, 
files_molify_item_id i where p.item_id = i.id and (user_id in (4,5,0)) and 
i.path REGEXP '^2:/te't/[^/]+[/]?$') order by item_id asc, ind asc, permission 
desc
ServiceException: INVALID_CONFIGURATION=Error executing query (SELECT item_id, 
permission, (IF(user_id = '4', 1, IF(user_id = '0', 3, 2))) as ind from 
files_molify_item_permission where (user_id in (4,5,0)) and item_id in (SELECT 
distinct item_id from files_molify_item_permission p, files_molify_item_id i 
where p.item_id = i.id and (user_id in (4,5,0)) and i.path REGEXP 
'^2:/te't/[^/]+[/]?$') order by item_id asc, ind asc, permission desc): 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 't/[^/]+[/]?$') order by 
item_id asc, ind asc, permission desc' at line 1
{0:{file:/homez.50/mdejdr/nos/www/files/backend/include/configuration/DbConfigur
ation.class.php, line:428, function:query, class:MySQLDatabase, type:->, 
args:{0:SELECT item_id, permission, (IF(user_id = '4', 1, IF(user_id = '0', 3, 
2))) as ind from files_molify_item_permission where (user_id in (4,5,0)) and 
item_id in (SELECT distinct item_id from files_molify_item_permission p, 
files_molify_item_id i where p.item_id = i.id and (user_id in (4,5,0)) and 
i.path REGEXP '^2:/te't/[^/]+[/]?$') order by item_id asc, ind asc, permission 
desc}}, 
1:{file:/homez.50/mdejdr/nos/www/files/backend/include/filesystem/FilesystemCont
roller.class.php, line:300, function:getAllItemPermissions, 
class:DbConfiguration, type:->, args:{0:FILESYSTEMITEM Folder 
(LocalFilesystem): [4efc6d4e86691] = 'te't' (te't/), 1:4}}, 
2:{file:/homez.50/mdejdr/nos/www/files/backend/include/filesystem/FilesystemCont
roller.class.php, line:228, function:fetchPermissions, 
class:FilesystemController, type:->, args:{0:FILESYSTEMITEM Folder 
(LocalFilesystem): [4efc6d4e86691] = 'te't' (te't/)}}, 
3:{file:/homez.50/mdejdr/nos/www/files/backend/include/services/FilesystemServic
es.class.php, line:277, function:items, class:FilesystemController, type:->, 
args:{0:FILESYSTEMITEM Folder (LocalFilesystem): [4efc6d4e86691] = 'te't' 
(te't/)}}, 
4:{file:/homez.50/mdejdr/nos/www/files/backend/include/services/FilesystemServic
es.class.php, line:338, function:getFolderInfo, class:FilesystemServices, 
type:->, args:{0:FILESYSTEMITEM Folder (LocalFilesystem): [4efc6d4e86691] = 
'te't' (te't/), 1:, 2:{}}}, 
5:{file:/homez.50/mdejdr/nos/www/files/backend/include/services/FilesystemServic
es.class.php, line:78, function:processPostFolder, class:FilesystemServices, 
type:->, args:{0:FILESYSTEMITEM Folder (LocalFilesystem): [4efc6d4e86691] = 
'te't' (te't/)}}, 
6:{file:/homez.50/mdejdr/nos/www/files/backend/include/services/ServicesBase.cla
ss.php, line:60, function:processPost, class:FilesystemServices, type:->, 
args:{}}, 
7:{file:/homez.50/mdejdr/nos/www/files/backend/include/MollifyBackend.class.php,
 line:79, function:processRequest, class:ServicesBase, type:->, args:{}}, 
8:{file:/homez.50/mdejdr/nos/www/files/backend/r.php, line:57, 
function:processRequest, class:MollifyBackend, type:->, args:{0:Request}}}
RESPONSE error {0:105, 1:Invalid configuration, 2:403} Error executing query 
(SELECT item_id, permission, (IF(user_id = '4', 1, IF(user_id = '0', 3, 2))) as 
ind from files_molify_item_permission where (user_id in (4,5,0)) and item_id in 
(SELECT distinct item_id from files_molify_item_permission p, 
files_molify_item_id i where p.item_id = i.id and (user_id in (4,5,0)) and 
i.path REGEXP '^2:/te't/[^/]+[/]?$') order by item_id asc, ind asc, permission 
desc): 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 't/[^/]+[/]?$') 
order by item_id asc, ind asc, permission desc' at line 1
------------
Original issue reported on code.google.com by djnosm...@gmail.com on 29 Dec 2011 at 1:41
wifang / mollify

folder coma issue? #340
