nilsteampassnet/TeamPass — Issue #60: 2.1.4: Folder content unable to be viewed
Author: syphernl
Created: 2012-03-01 10:40:20+00:00
State: open

When clicking a folder, it keeps loading....
Firebug shows an error for the POST to items.queries.php

```document.getElementById("mysql_error_warning").innerHTML = "MySQL Query fail: SELECT DISTINCT i.id AS id, i.restricted_to AS restricted_to, i.perso AS perso, i.label AS label,\n	i.description AS description, i.pw AS pw, i.login AS login, i.anyone_can_modify AS anyone_can_modify,\n l.date AS date,\n n.renewal_period AS renewal_period,\n l.action AS log_action, l.id_user AS log_user,\n k.rand_key AS rand_key\n FROM teampass_items AS i\n INNER JOIN teampass_nested_tree AS n ON (i.id_tree = n.id)\n INNER JOIN teampass_log_items AS l ON (i.id = l.id_item)\n	INNER JOIN teampass_keys AS k ON (k.id = i.id)\n WHERE i.inactif = 0 AND i.id_tree=2\n AND l.action = 'at_creation'\n	ORDER BY i.label ASC, l.date DESC\n	LIMIT 0,auto
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 \'auto\' at line 14";$("#div_mysql_error").dialog("open");```