database error on fresh install when invoking "css/admin" view

[vazco]

On one of test servers with Elgg 1.8 I've got repeatable fatal error when displaying CSS:
​http://scitech.elggdev.com/scitech/cache/css/default/admin.1307362730.css

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 '= -2 AND .owner_guid IN ( SELECT guid_one FROM elgg_entity_relationships ' at line 1

QUERY: SELECT DISTINCT n_table.*, n.string as name, v.string as value FROM elgg_metadata n_table JOIN elgg_entities e ON n_table.entity_guid = e.guid JOIN elgg_metastrings n on n_table.name_id = n.id JOIN elgg_metastrings v on n_table.value_id = v.id JOIN elgg_metastrings msn on n_table.name_id = msn.id WHERE (e.guid IN (22)) AND (((msn.string IN ()) AND ( (.access_id = -2 AND .owner_guid IN ( SELECT guid_one FROM elgg_entity_relationships WHERE relationship='friend' AND guid_two=22 )) OR (.access_id IN (2,1,0) OR (.owner_guid = 22) OR ( .access_id = 0 AND .owner_guid = 22 ) ) and .enabled='yes'))) AND ( (.access_id = -2 AND .owner_guid IN ( SELECT guid_one FROM elgg_entity_relationships WHERE relationship='friend' AND guid_two=22 )) OR (.access_id IN (2,1,0) OR (.owner_guid = 22) OR ( .access_id = 0 AND .owner_guid = 22 ) ) and .enabled='yes') ORDER BY , n_table.id

in cache_handler.php, after I put die(); in line 94, I get "zend corrupt" output. Error appears on invoking css/admin view but it seems to be generated earlier.

When I comment out line 89, css is loaded correctly:
mysql_close($mysql_dblink);

This bug appears only when URL is pointing to subdirectory. After I changed URL to the one below, error stopped appearing:

​http://scitech.elggdev.com/cache/css/default/admin.1307362730.css

[brettp]

Just installed the latest master it in a subdir and it worked for me. Please reopen if more problems.