Details
-
Type:
Problem report
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 3.0.24, 4.0.3, 4.2.0alpha2
-
Fix Version/s: 4.0.4rc1, 4.2.0alpha3, 4.2 (plan)
-
Component/s: Frontend (F)
-
Labels:
-
Team:Team B
-
Sprint:Sprint 47, Dec 2018, Sprint 48, Jan 2019
-
Story Points:0.125
Description
Steps to reproduce:
- open slides.php without any GET parameters
Result:
SQL error will occur and the page will be redirected to slideconf.php
pg_query(): Query failed: ERROR: invalid input syntax for integer: ""
LINE 1: SELECT s.* FROM slideshows s WHERE s.slideshowid=''
^ [slides.php:166 → get_slideshow_by_slideshowid() → DBselect() → pg_query() in include/db.inc.php:369]
Error in query [SELECT s.* FROM slideshows s WHERE s.slideshowid=''] [ERROR: invalid input syntax for integer: ""
LINE 1: SELECT s.* FROM slideshows s WHERE s.slideshowid=''
^]
Expected:
Page should be redirected without SQL errors.