v2.3.* has broken

[yellowmamba]

I have noticed that you have changed your standard installation to use 2.4 changes, so I tried a fresh install via v2.3.* release, it gives me the same error as follows (I tried both v2.3.3 and v2.3.4 as I am not sure what the difference it makes by setting branch-alias):

An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT n.id, n.parent_id AS parent, t.url,
IF(t.weight IS NULL, v.weight, t.weight) AS weight,
IF(t.title IS NULL, v.title, t.title) AS title,
IF(t.online IS NULL, 0, t.online) AS online,
n.hidden_from_nav AS hidden FROM kuma_nodes n LEFT JOIN kuma_node_translations t ON (t.node_id = n.id AND t.lang = ?) LEFT JOIN (SELECT lang, title, weight, node_id, url FROM kuma_node_translations GROUP BY node_id ORDER BY id ASC) v ON (v.node_id = n.id AND v.lang <> ?) INNER JOIN (SELECT DISTINCT o.object_identifier as id FROM kunst-2.3.acl_object_identities as o
INNER JOIN kunst-2.3.acl_classes c ON c.id = o.class_id
LEFT JOIN kunst-2.3.acl_entries e ON (
e.class_id = o.class_id AND (e.object_identity_id = o.id
OR e.object_identity_id IS NULL)
)
LEFT JOIN kunst-2.3.acl_security_identities s ON (
s.id = e.security_identity_id
)
WHERE c.class_type = "Kunstmaan\\NodeBundle\\Entity\\Node"
AND (s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY" OR s.identifier = "ROLE_SUPER_ADMIN" OR s.identifier = "ROLE_PERMISSIONMANAGER" OR s.identifier = "ROLE_ADMIN" OR s.identifier = "ROLE_ALLOWED_TO_SWITCH" OR s.identifier = "Kunstmaan\\AdminBundle\\Entity\\User-admin")
AND e.mask & 4 > 0) perms_ ON perms_.id = n.id WHERE n.deleted = 0 GROUP BY n.id ORDER BY t.weight ASC, t.title ASC' with params ["en", "en"]:

SQLSTATE[42000]: Syntax error or access violation: 1064 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.3.acl_object_identities as o
INNER JOIN kunst-2.3.acl_classes c ON c.id = o.c' at line 5") in /Users/{username}/kunst-2.3/vendor/kunstmaan/admin-bundle/Kunstmaan/AdminBundle/Resources/views/Default/layout.html.twig at line 80.

kunst-2.3 is my db name. I can't figure out why. I initiated my projects with standard installation awhile back, and it was 2.3. But now I don't know why, the pages and user management stuff in the cms are gone. I am thus trying to fix this while encountering this error.

[roderik]

the - in the db name is an issue it seems. Can you try it with a db name without any special characters kunst23 for example?

[NaxYo]

In my case removing '-' work just fine, thx!

[yellowmamba]

Indeed that was the issue. Thanks! Probably because there wasn't backquotes around db name in parsing?