Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Configuration error of parameter "rows" in layout #4

Open
Arachnos opened this issue May 6, 2022 · 0 comments
Open

Configuration error of parameter "rows" in layout #4

Arachnos opened this issue May 6, 2022 · 0 comments

Comments

@Arachnos
Copy link

Arachnos commented May 6, 2022

When writing this in the configuration for layouts :

layouts:
  _default:
    name: Default layout
    template: fe_page
    rows: 3rw

we got the following error :

In ExceptionConverter.php line 88:

  An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the
  manual that corresponds to your MariaDB server version for the right syntax to use near 'rows = '3rw', alias = '_default', pid = '3', tstamp = '1651845
  701' WHERE id =...' at line 1

In Exception.php line 30:

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server
  version for the right syntax to use near 'rows = '3rw', alias = '_default', pid = '3', tstamp = '1651845701' WHERE id =...' at line 1

In Statement.php line 101:

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server
  version for the right syntax to use near 'rows = '3rw', alias = '_default', pid = '3', tstamp = '1651845701' WHERE id =...' at line 1

The parameter rows seems to be reserved in MariaDB, so we have to write the config this way, with backquotes, to make it work :

layouts:
  _default:
    name: Default layout
    template: fe_page
    '`rows`': 3rw
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant