Named Queries using single quotes (as used in default Templates query) are not accepted on Macintosh and not stored in database. On Windows there is no such problem. Easy work around is using double quotes. You can copy & paste the following updated query to the current Templates named query:

select o.id, o.type as "Type", o.name as "Name", p.publication as "Publication", s.section as "section", o.comment as "Comment", p.id as "PublicationId", i.id as "IssueId", s.id as "SectionId", st.id as "StateId"
from smart_objects as o
left join smart_publications as p on (o.publication = p.id)
left join smart_publissues as i on (o.issue = i.id)
left join smart_publsections as s on (o.section = s.id)
left join smart_states as st on (o.state = st.id)
where o.type = "LayoutTemplate" or o.type = "ArticleTemplate"