Ports lists not working

[rfc1036]

ISSUE TYPE

Bug Report

OS

Distributor ID: Ubuntu
Description:    Ubuntu 20.04.2 LTS
Release:        20.04
Codename:       focal

VERSION

define( 'APPLICATION_VERSION', '6.0.0' );
define( 'APPLICATION_VERDATE', '2021071400' );

ENVIRONMENT

root@manager:/srv/ixpmanager# php -v
PHP 8.0.8 (cli) (built: Jul  1 2021 15:26:46) ( NTS )
Copyright (c) The PHP Group
Zend Engine v4.0.8, Copyright (c) Zend Technologies
    with Zend OPcache v8.0.8, Copyright (c), by Zend Technologies
root@manager:/srv/ixpmanager# dpkg -l | grep php
ii  php-common                        2:84+ubuntu20.04.1+deb.sury.org+1                                   all          Common files for PHP packages
ii  php-ds                            1.3.0-6+ubuntu20.04.1+deb.sury.org+1                                amd64        PHP extension providing efficient data structures for PHP 7
ii  php-igbinary                      3.2.1+2.0.8-6+ubuntu20.04.1+deb.sury.org+1                          amd64        igbinary PHP serializer
ii  php-memcache                      8.0+4.0.5.2+3.0.9~20170802.e702b5f9+-1+ubuntu20.04.1+deb.sury.org+2 amd64        memcache extension module for PHP
ii  php-memcached                     3.1.5+2.2.0-9+ubuntu20.04.1+deb.sury.org+1                          amd64        memcached extension module for PHP, uses libmemcached
ii  php-msgpack                       2.1.2+0.5.7-6+ubuntu20.04.1+deb.sury.org+1                          amd64        PHP extension for interfacing with MessagePack
ii  php-pear                          1:1.10.12+submodules+notgz+20210212-1+ubuntu20.04.1+deb.sury.org+1  all          PEAR Base System
ii  php-rrd                           2.0.1+1.1.3-14+ubuntu20.04.1+deb.sury.org+1                         amd64        PHP bindings to rrd tool system
ii  php-yaml                          2.2.1+2.1.0+2.0.4+1.3.2-6+ubuntu20.04.1+deb.sury.org+1              amd64        YAML-1.1 parser and emitter for PHP
ii  php8.0                            8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                all          server-side, HTML-embedded scripting language (metapackage)
ii  php8.0-bcmath                     8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        Bcmath module for PHP
ii  php8.0-cli                        8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        command-line interpreter for the PHP scripting language
ii  php8.0-common                     8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        documentation, examples and common module for PHP
ii  php8.0-curl                       8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        CURL module for PHP
ii  php8.0-ds                         1.3.0-6+ubuntu20.04.1+deb.sury.org+1                                amd64        PHP extension providing efficient data structures for PHP 7
ii  php8.0-fpm                        8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        server-side, HTML-embedded scripting language (FPM-CGI binary)
ii  php8.0-gd                         8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        GD module for PHP
ii  php8.0-igbinary                   3.2.1+2.0.8-6+ubuntu20.04.1+deb.sury.org+1                          amd64        igbinary PHP serializer
ii  php8.0-intl                       8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        Internationalisation module for PHP
ii  php8.0-mbstring                   8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        MBSTRING module for PHP
ii  php8.0-memcache                   8.0+4.0.5.2+3.0.9~20170802.e702b5f9+-1+ubuntu20.04.1+deb.sury.org+2 amd64        memcache extension module for PHP
ii  php8.0-memcached                  3.1.5+2.2.0-9+ubuntu20.04.1+deb.sury.org+1                          amd64        memcached extension module for PHP, uses libmemcached
ii  php8.0-msgpack                    2.1.2+0.5.7-6+ubuntu20.04.1+deb.sury.org+1                          amd64        PHP extension for interfacing with MessagePack
ii  php8.0-mysql                      8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        MySQL module for PHP
ii  php8.0-opcache                    8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        Zend OpCache module for PHP
ii  php8.0-readline                   8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        readline module for PHP
ii  php8.0-rrd                        2.0.1+1.1.3-14+ubuntu20.04.1+deb.sury.org+1                         amd64        PHP bindings to rrd tool system
ii  php8.0-snmp                       8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        SNMP module for PHP
ii  php8.0-xml                        8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        DOM, SimpleXML, XML, and XSL module for PHP
ii  php8.0-yaml                       2.2.1+2.1.0+2.0.4+1.3.2-6+ubuntu20.04.1+deb.sury.org+1              amd64        YAML-1.1 parser and emitter for PHP
ii  php8.0-zip                        8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        Zip module for PHP
root@manager:/srv/ixpmanager#

STEPS TO REPRODUCE

• Opened https://manager.minap.it/patch-panel/edit/1
• Modified the "Name" field
• Clicked on "Save Changes"

ACTUAL RESULTS

Error 500 with:

Server Error :: 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 'ASC order by `ppp`.`number` asc' at line 8 (SQL: select ppp.*, count( pppf.id ) AS files, count( ppph.id ) AS histories, pp.name as ppname, pp.port_prefix AS prefix, sp.name AS spname, s.name AS sname, c.abbreviatedName AS cname, count( ppps.id ) AS nbslave, ppps.number AS slavenumber from `patch_panel_port` as `ppp` inner join `patch_panel` as `pp` on `pp`.`id` = `ppp`.`patch_panel_id` left join `switchport` as `sp` on `sp`.`id` = `ppp`.`switch_port_id` left join `switch` as `s` on `s`.`id` = `sp`.`switchid` left join `cust` as `c` on `c`.`id` = `ppp`.`customer_id` left join `patch_panel_port_file` as `pppf` on `pppf`.`patch_panel_port_id` = `ppp`.`id` left join `patch_panel_port_history` as `ppph` on `ppph`.`patch_panel_port_id` = `ppp`.`id` left join `patch_panel_port` as `ppps` on `ppps`.`duplex_master_id` = `ppp`.`id` where `ppp`.`duplex_master_id` is null and `ppp`.`patch_panel_id` = 1 group by ppp.id, ppp.number ASC order by `ppp`.`number` asc)

[rfc1036]

Actually renaming works just fine: what does not work (always) are the https://manager.minap.it/patch-panel-port/list/patch-panel/ URLs.

[rfc1036]

I would really appreciate some help with this because it breaks generating LOAs and with the ORM I have no idea of how to fix the SQL statement.

[barryo]

Hey @rfc1036 - @yannrobin 's fix in now in release-v6 branch.