Skip to content

Instantly share code, notes, and snippets.

@hugeval
Created August 26, 2015 16:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hugeval/22ad23b76e295967e117 to your computer and use it in GitHub Desktop.
Save hugeval/22ad23b76e295967e117 to your computer and use it in GitHub Desktop.
sql error
An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT COUNT(*) FROM (SELECT o0_.id AS id0, o0_.name AS name1, o1_.email AS email2, o2_.phone AS phone3 FROM orocrm_account o0_ INNER JOIN oro_navigation_history o3_ ON (o0_.id = o3_.entity_id AND o3_.route = 'orocrm_account_view') LEFT JOIN orocrm_contact o4_ ON o0_.default_contact_id = o4_.id AND (o4_.organization_id = 1) LEFT JOIN orocrm_contact_email o1_ ON o4_.id = o1_.owner_id AND (o1_.is_primary = 1) LEFT JOIN orocrm_contact_phone o2_ ON o4_.id = o2_.owner_id AND (o2_.is_primary = 1) WHERE o3_.user_id = 54 AND (o0_.organization_id = 1 OR EXISTS (SELECT 1 AS sclr4 FROM acl_entries a5_ WHERE o0_.id = a5_.record_id AND o0_.id = AND o0_.id = )) GROUP BY id0, name1, email2, phone3) AS e':
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 'AND o0_.id = )) GROUP BY id0, name1, email2, phone3) AS e' at line 1") in OroCRMAccountBundle:Dashboard:myAccountsActivity.html.twig at line 9.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment