Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-15372

SQL query error on slides.php page

    XMLWordPrintable

    Details

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

        Attachments

          Activity

            People

            Assignee:
            sasha Alexander Vladishev
            Reporter:
            sasha Alexander Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: