[ZBX-15372] SQL query error on slides.php page Created: 2018 Dec 27  Updated: 2024 Apr 10  Resolved: 2019 Jan 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 3.0.24, 4.0.3, 4.2.0alpha2
Fix Version/s: 4.0.4rc1, 4.2.0alpha3, 4.2 (plan)

Type: Problem report Priority: Minor
Reporter: Alexander Vladishev Assignee: Alexander Vladishev
Resolution: Fixed Votes: 0
Labels: codequality, slideshows
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Sub-task
Team: Team B
Sprint: Sprint 47, Dec 2018, Sprint 48, Jan 2019
Story Points: 0.125

 Description   

Steps to reproduce:

  1. 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.

 Comments   
Comment by Alexander Vladishev [ 2018 Dec 27 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-15372.

Comment by Alexander Vladishev [ 2019 Jan 09 ]

Fixed in:

  • 4.0.4rc1 r88434
  • 4.2.0alpha3 (trunk) r88435
Generated at Tue Jan 07 13:14:28 EET 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.