SQLSTATE[42000]: Syntax error or access violation

Created on 18 April 2023, over 1 year ago

Error occurred on report page /admin/reports/website-speed :

Drupal\Core\Database\DatabaseExceptionWrapper: 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 '' at line 6: SELECT route_name, AVG(ws.response_start) AS avg_response_start, MAX(ws.response_start) AS max_response_start, MIN(ws.response_start) AS min_response_start, SUM(ws.response_start) AS total_time, COUNT(*) AS num_requests FROM website_speed_timings ws GROUP BY route_name ORDER BY avg_response_start DESC LIMIT; Array ( ) in Drupal\website_speed\Controller\WebsiteSpeedReport->showSpeedByRoute() (line 316 of /var/www/html/modules/contrib/website_speed/src/Controller/WebsiteSpeedReport.php).

After re-installation all works fine.

🐛 Bug report
Status

Active

Version

1.0

Component

Code

Created by

🇵🇱Poland pawel_r

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024