Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package phpPgAdmin for openSUSE:Factory checked in at 2026-01-26 11:00:56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/phpPgAdmin (Old) and /work/SRC/openSUSE:Factory/.phpPgAdmin.new.1928 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "phpPgAdmin" Mon Jan 26 11:00:56 2026 rev:33 rq:1328913 version:7.14.7 Changes: -------- --- /work/SRC/openSUSE:Factory/phpPgAdmin/phpPgAdmin.changes 2024-03-07 22:03:08.488367637 +0100 +++ /work/SRC/openSUSE:Factory/.phpPgAdmin.new.1928/phpPgAdmin.changes 2026-01-26 11:01:23.423625425 +0100 @@ -1,0 +2,8 @@ +Fri Jan 23 16:01:03 UTC 2026 - [email protected] + +- Update to 7.14.7 + - gh#16 'Deprecated htmlspecialchars(): Passing null' and other problems + - gh#19 No value shown for "last value" for sequences + - gh#23 Ajax browsing of foreign keys only works in one level (fixed) + +------------------------------------------------------------------- Old: ---- phpPgAdmin-7.14.6-mod.tar.gz New: ---- phpPgAdmin-7.14.7-mod.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ phpPgAdmin.spec ++++++ --- /var/tmp/diff_new_pack.Altn5M/_old 2026-01-26 11:01:24.323662862 +0100 +++ /var/tmp/diff_new_pack.Altn5M/_new 2026-01-26 11:01:24.327663029 +0100 @@ -1,7 +1,7 @@ # # spec file for package phpPgAdmin # -# Copyright (c) 2023 SUSE LLC +# Copyright (c) 2026 SUSE LLC and contributors # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -27,7 +27,7 @@ Summary: Administration of PostgreSQL over the web License: GPL-2.0-or-later Group: Productivity/Databases/Tools -Version: 7.14.6 +Version: 7.14.7 Release: 0 %define rel_version REL_7-14-6 #URL: https://github.com/phppgadmin/phppgadmin @@ -55,15 +55,15 @@ * Administer multiple servers * Support for PostgreSQL 9.x.x, 10.x, 11.x, 12.x, 14.x * Manage all aspects of: - o Users & groups + o Users & groups o Databases o Schemas - o Tables, indexes, constraints, triggers, rules & privileges - o Views, sequences & functions + o Tables, indexes, constraints, triggers, rules & privileges + o Views, sequences & functions o Advanced objects o Reports * Easy data manipulation: - o Browse tables, views & reports + o Browse tables, views & reports o Execute arbitrary SQL o Select, insert, update and delete * Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump ++++++ phpPgAdmin-7.14.6-mod.tar.gz -> phpPgAdmin-7.14.7-mod.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/phpPgAdmin-7.14.6-mod/classes/database/Postgres.php new/phpPgAdmin-7.14.7-mod/classes/database/Postgres.php --- old/phpPgAdmin-7.14.6-mod/classes/database/Postgres.php 2023-10-13 08:07:30.000000000 +0200 +++ new/phpPgAdmin-7.14.7-mod/classes/database/Postgres.php 2023-12-16 18:59:01.000000000 +0100 @@ -287,6 +287,7 @@ case 'jsonb': case 'xml': case 'xml[]': + if ($value === null) $value = ''; $n = substr_count($value, "\n"); $n = $n < 5 ? 5 : $n; $n = $n > 20 ? 20 : $n; @@ -296,6 +297,7 @@ break; case 'character': case 'character[]': + if ($value === null) $value = ''; $n = substr_count($value, "\n"); $n = $n < 5 ? 5 : $n; $n = $n > 20 ? 20 : $n; @@ -304,6 +306,7 @@ echo "</textarea>\n"; break; default: + if ($value === null) $value = ''; echo "<input name=\"", htmlspecialchars($name ?? ''), "\" value=\"", htmlspecialchars($value ?? ''), "\" size=\"35\"{$extra_str} />\n"; break; } @@ -2639,7 +2642,7 @@ $this->fieldClean($sequence); $this->clean($sequence); - $sql = "SELECT pg_catalog.has_sequence_privilege('{$f_schema}.{$sequence}','SELECT,USAGE') AS priv"; + $sql = "SELECT pg_catalog.has_sequence_privilege((SELECT pg_class.oid FROM pg_class INNER JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid WHERE pg_class.relname ILIKE '{$sequence}' AND pg_namespace.nspname ILIKE '{$f_schema}'),'SELECT,USAGE') AS priv"; return $this->selectField($sql, 'priv'); } diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/phpPgAdmin-7.14.6-mod/composer.json new/phpPgAdmin-7.14.7-mod/composer.json --- old/phpPgAdmin-7.14.6-mod/composer.json 2023-10-13 08:07:30.000000000 +0200 +++ new/phpPgAdmin-7.14.7-mod/composer.json 2023-12-16 18:59:01.000000000 +0100 @@ -1,7 +1,7 @@ { "name": "phppgadmin/phppgadmin", "description": "phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies, and hosting services.", - "type": "Application", + "type": "project", "license": "GPL-2.0+", "require": { "php": ">=7.1", diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/phpPgAdmin-7.14.6-mod/js/display.js new/phpPgAdmin-7.14.7-mod/js/display.js --- old/phpPgAdmin-7.14.6-mod/js/display.js 2023-10-13 08:07:30.000000000 +0200 +++ new/phpPgAdmin-7.14.7-mod/js/display.js 2023-12-16 18:59:01.000000000 +0100 @@ -1,15 +1,15 @@ $(function() { - + /* init some needed tags and values */ - + $('table#data').wrap('<div id="fkcontainer" class="fk" />'); $('#fkcontainer').append('<div id="root" />'); - - jQuery.ppa = { + + jQuery.ppa = { root: $('#root') }; - - $("a.fk").on('click', function (event) { + + $(document).on('click', "a.fk", null, function (event) { /* make the cursor being a waiting cursor */ $('body').css('cursor','wait'); @@ -54,7 +54,7 @@ /* creating the data div */ newdiv = $('<div class="fk '+divclass+'">').html(answer); - + /* highlight referencing fields */ newdiv.data('ref', this).data('refclass', $(this).attr('class').split(' ')[1]) .mouseenter(function (event) { @@ -76,7 +76,7 @@ $('body').css('cursor','auto'); } }); - + return false; // do not refresh the page }); diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/phpPgAdmin-7.14.6-mod/libraries/lib.inc.php new/phpPgAdmin-7.14.7-mod/libraries/lib.inc.php --- old/phpPgAdmin-7.14.6-mod/libraries/lib.inc.php 2023-10-13 08:07:30.000000000 +0200 +++ new/phpPgAdmin-7.14.7-mod/libraries/lib.inc.php 2023-12-16 18:59:01.000000000 +0100 @@ -9,14 +9,14 @@ include_once('./libraries/decorator.inc.php'); include_once('./lang/translations.php'); - // Set error reporting level to max - error_reporting(E_ALL); + // Do not show depreciation warnings. + error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED); // Application name $appName = 'phpPgAdmin'; // Application version - $appVersion = '7.14.6-mod'; + $appVersion = '7.14.7-mod'; // PostgreSQL and PHP minimum version global $postgresqlMinVer; diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/phpPgAdmin-7.14.6-mod/sequences.php new/phpPgAdmin-7.14.7-mod/sequences.php --- old/phpPgAdmin-7.14.6-mod/sequences.php 2023-10-13 08:07:30.000000000 +0200 +++ new/phpPgAdmin-7.14.7-mod/sequences.php 2023-12-16 18:59:01.000000000 +0100 @@ -627,33 +627,33 @@ echo "<tr><th class=\"data left\">{$lang['strcomment']}</th>\n"; echo "<td class=\"data1\">"; echo "<textarea rows=\"3\" cols=\"32\" name=\"comment\">", - htmlspecialchars($_POST['comment']), "</textarea></td></tr>\n"; + htmlspecialchars($_POST['comment'] ?? ''), "</textarea></td></tr>\n"; if ($data->hasAlterSequenceStart()) { echo "<tr><th class=\"data left\">{$lang['strstartvalue']}</th>\n"; echo "<td class=\"data1\"><input name=\"formStartValue\" size=\"5\" value=\"", - htmlspecialchars($sequence->fields['start_value']), "\" /></td></tr>\n"; + htmlspecialchars($sequence->fields['start_value'] ?? ''), "\" /></td></tr>\n"; } echo "<tr><th class=\"data left\">{$lang['strrestartvalue']}</th>\n"; echo "<td class=\"data1\"><input name=\"formRestartValue\" size=\"5\" value=\"", - htmlspecialchars($sequence->fields['last_value']), "\" /></td></tr>\n"; + htmlspecialchars($sequence->fields['last_value'] ?? ''), "\" /></td></tr>\n"; echo "<tr><th class=\"data left\">{$lang['strincrementby']}</th>\n"; echo "<td class=\"data1\"><input name=\"formIncrement\" size=\"5\" value=\"", - htmlspecialchars($sequence->fields['increment_by']), "\" /> </td></tr>\n"; + htmlspecialchars($sequence->fields['increment_by'] ?? ''), "\" /> </td></tr>\n"; echo "<tr><th class=\"data left\">{$lang['strmaxvalue']}</th>\n"; echo "<td class=\"data1\"><input name=\"formMaxValue\" size=\"5\" value=\"", - htmlspecialchars($sequence->fields['max_value']), "\" /></td></tr>\n"; + htmlspecialchars($sequence->fields['max_value'] ?? ''), "\" /></td></tr>\n"; echo "<tr><th class=\"data left\">{$lang['strminvalue']}</th>\n"; echo "<td class=\"data1\"><input name=\"formMinValue\" size=\"5\" value=\"", - htmlspecialchars($sequence->fields['min_value']), "\" /></td></tr>\n"; + htmlspecialchars($sequence->fields['min_value'] ?? ''), "\" /></td></tr>\n"; echo "<tr><th class=\"data left\">{$lang['strcachevalue']}</th>\n"; echo "<td class=\"data1\"><input name=\"formCacheValue\" size=\"5\" value=\"", - htmlspecialchars($sequence->fields['cache_value']), "\" /></td></tr>\n"; + htmlspecialchars($sequence->fields['cache_value'] ?? ''), "\" /></td></tr>\n"; echo "<tr><th class=\"data left\"><label for=\"formCycledValue\">{$lang['strcancycle']}</label></th>\n"; echo "<td class=\"data1\"><input type=\"checkbox\" id=\"formCycledValue\" name=\"formCycledValue\" ", @@ -662,7 +662,7 @@ echo "</table>\n"; echo "<p><input type=\"hidden\" name=\"action\" value=\"alter\" />\n"; echo $misc->form; - echo "<input type=\"hidden\" name=\"sequence\" value=\"", htmlspecialchars($_REQUEST['sequence']), "\" />\n"; + echo "<input type=\"hidden\" name=\"sequence\" value=\"", htmlspecialchars($_REQUEST['sequence'] ?? ''), "\" />\n"; echo "<input type=\"submit\" name=\"alter\" value=\"{$lang['stralter']}\" />\n"; echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n"; echo "</form>\n"; ++++++ phpPgAdmin_appVersion.patch ++++++ --- /var/tmp/diff_new_pack.Altn5M/_old 2026-01-26 11:01:24.859685158 +0100 +++ /var/tmp/diff_new_pack.Altn5M/_new 2026-01-26 11:01:24.871685658 +0100 @@ -6,8 +6,8 @@ $appName = 'phpPgAdmin'; // Application version -- $appVersion = '7.14.6-mod'; -+ $appVersion = '7.14.6'; +- $appVersion = '7.14.7-mod'; ++ $appVersion = '7.14.7'; // PostgreSQL and PHP minimum version global $postgresqlMinVer;
