4 5.2.2 (not yet released)
5 - issue #17028 Fix total count of rows in not accurate
6 - issue #17683 Fix total count of rows in not accurate
7 - issue #17766 Allow to open in a new tab copy and edit row actions
8 - issue #17599 Fix error when handling an user that is not in privileges table
9 - issue #17364 Fix error when trying to import a status monitor chart arrangement
10 - issue #18106 Fix renaming database with a view
11 - issue #18120 Fix bug with numerical tables during renaming database
12 - issue #16851 Fix ($cfg['Order']) default column order doesn't have have any effect since phpMyAdmin 4.2.0
13 - issue #18112 Fix open base dir warning on git version class
14 - issue Do not show "Original length undefined" on binary hex columns
15 - issue Fix wrong time zone when handling Git information
16 - issue Do not show "Original length undefined" on binary hex columns
17 - issue Fix warning on non-existent table for XML export
18 - issue #18196 Fix errors of import notification
19 - issue #18093 Fix JS errors around "new user account" in some edge cases
20 - issue #16451 Increase password characters limit to 2000 during login
21 - issue Fix "IS NULL" is shown for non-nullable columns on search page
22 - issue #16199 Fix dragging of tables in designer
23 - issue #17702 Fix performance issue when handling large number of tables in a single database
24 - issue Fix UI defect on tracking versions table first column
25 - issue #18266 Fix disabling features (like `$cfg['Servers'][$i]['tracking'] = false;`) did not work
26 - issue Fixed query time measurement - measure time only for user queries
27 - issue #18235 Fix columns are misaligned for the "sys" database
28 - issue #18249 Speed improvements when browsing a database with multiple tables
29 - issue #18060 Fix Console height "Not a non-negative number" error
30 - issue Fix width/height of create routines modal and width of routines/triggers/events modals
31 - issue Stop pmadb database detection when all features are disabled
32 - issue Upgrade slim/psr7 to 1.4.1 for CVE-2023-30536 - GHSA-q2qj-628g-vhfw
33 - issue #17654 Fix unprivileged user cannot change password on MySQL >= 5.7.37
34 - issue Add CVE MITRE link to allowed domains and use cve.org
35 - issue #18330 Fix TypeError when no-datetime field is modified
36 - issue #18212 Fix Query Builder doesn't replace a table name with it's alias in the `WHERE` block
37 - issue Keep the criteria box collapsed by the user when un-checking the criteria checkbox
38 - issue Fix colspan for actions column on database table list
39 - issue Fix double encoding on User Groups pages
40 - issue Fix list of users of an user group not showing up
41 - issue Fix duplicate query params in the SQL message card
42 - issue #18314 Fix dragged row in index form
43 - issue #17392 Fix the actions not being hidden in the Triggers, Routines, Events pages
44 - issue #18441 Fix execute routine page not working when not in a modal
47 - issue #17522 Fix case where the routes cache file is invalid
48 - issue #17506 Fix error when configuring 2FA without XMLWriter or Imagick
49 - issue Fix blank page when some error occurs
50 - issue #17519 Fix Export pages not working in certain conditions
51 - issue #17496 Fix error in table operation page when partitions are broken
52 - issue #17386 Fix system memory and system swap values on Windows
53 - issue #17517 Fix Database Server panel not getting hidden by ShowServerInfo configuration directive
54 - issue #17271 Fix database names not showing on Processes tab
55 - issue #17424 Fix export limit size calculation
56 - issue #17366 Fix refresh rate popup on Monitor page
57 - issue #17577 Fix monitor charts size on RTL languages
58 - issue #17121 Fix password_hash function incorrectly adding single quotes to password before hashing
59 - issue #17586 Fix statistics not showing for empty databases
60 - issue #17592 Clicking on the New index link on the sidebar does not throw an error anymore
61 - issue #17584 It's now possible to browse a database that includes two % in its name
62 - issue Fix PHP 8.2 deprecated string interpolation syntax
63 - issue Some languages are now correctly detected from the HTTP header
64 - issue #17617 Sorting is correctly remembered when $cfg['RememberSorting'] is true
65 - issue #17593 Table filtering now works when action buttons are on the right side of the row
66 - issue #17388 Find and Replace using regex now makes a valid query if no matching result set found
67 - issue #17551 Enum/Set editor will not fail to open when creating a new column
68 - issue #17659 Fix error when a database group is named tables, views, functions, procedures or events
69 - issue #17673 Allow empty values to be inserted into columns
70 - issue #17620 Fix error handling at phpMyAdmin startup for the JS SQL console
71 - issue Fixed debug queries console broken UI for query time and group count
72 - issue Fixed escaping of SQL query and errors for the debug console
73 - issue Fix console toolbar UI when the bookmark feature is disabled and sql debug is enabled
74 - issue #17543 Fix JS error on saving a new designer page
75 - issue #17546 Fix JS error after using save as and open page operation on the designer
76 - issue Fix PHP warning on GIS visualization when there is only one GIS column
77 - issue #17728 Some select HTML tags will now have the correct UI style
78 - issue #17734 PHP deprecations will only be shown when in a development environment
79 - issue #17369 Fix server error when blowfish_secret is not exactly 32 bytes long
80 - issue #17736 Add utf8mb3 as an alias of utf8 on the charset description page
81 - issue #16418 Fix FAQ 1.44 about manually removing vendor folders
82 - issue #12359 Setup page now sends the Content-Security-Policy headers
83 - issue #17747 The Column Visibility Toggle will not be hidden by other elements
84 - issue #17756 Edit/Copy/Delete row now works when using GROUP BY
85 - issue #17248 Support the UUID data type for MariaDB >= 10.7
86 - issue #17656 Fix replace/change/set table prefix is not working
87 - issue Fix monitor page filter queries only filtering the first row
88 - issue Fix "Link not found!" on foreign columns for tables having no char column to show
89 - issue #17390 Fix "Create view" modal doesn't show on results and empty results
90 - issue #17772 Fix wrong styles for add button from central columns
91 - issue #17389 Fix HTML disappears when exporting settings to browser's storage
92 - issue #17166 Fix "Warning: #1287 'X' is deprecated [...] Please use ST_X instead." on search page
93 - issue Use jquery-migrate.min.js (14KB) instead of jquery-migrate.min.js (31KB)
94 - issue #17842 Use jquery.validate.min.js (24 KB) instead of jquery.validate.js (50 KB)
95 - issue #17281 Fix links to databases for information_schema.SCHEMATA
96 - issue #17553 Fix Metro theme unreadable links above navigation tree
97 - issue #17553 Metro theme UI fixes and improvements
98 - issue #17553 Fix Metro theme login form with
99 - issue #16042 Exported gzip file of database has first ~73 kB uncompressed and rest is gzip compressed in Firefox
100 - issue #17705 Fix inline SQL query edit FK checkbox preventing submit buttons from working
101 - issue #17777 Fix Uncaught TypeError: Cannot read properties of null (reading 'inline') on datepickers when re-opened
102 - issue Fix Original theme buttons style and login form width
103 - issue #17892 Fix closing index edit modal and reopening causes it to fire twice
104 - issue #17606 Fix preview SQL modal not working inside "Add Index" modal
105 - issue Fix PHP error on adding new column on create table form
106 - issue #17482 Default to "Full texts" when running explain statements
107 - issue Fixed Chrome scrolling performance issue on a textarea of an "export as text" page
108 - issue #17703 Fix datepicker appears on all fields, not just date
109 - issue Fix space in the tree line when a DB is expanded
110 - issue #17340 Fix "New Table" page -> "VIRTUAL" attribute is lost when adding a new column
111 - issue #17446 Fix missing option for STORED virtual column on MySQL and PERSISTENT is not supported on MySQL
112 - issue #17446 Lower the check for virtual columns to MySQL>=5.7.6 nothing is supported on 5.7.5
113 - issue Fix column names option for CSV Export
114 - issue #17177 Fix preview SQL when reordering columns doesn't work on move columns
115 - issue #15887 Fixed DROP TABLE errors ignored on multi table select for DROP
116 - issue #17944 Fix unable to create a view from tree view button
117 - issue #17927 Fix key navigation between select inputs (drop an old Firefox workaround)
118 - issue #17967 Fix missing icon for collapse all button
119 - issue #18006 Fixed UUID columns can't be moved
120 - issue Add `spellcheck="false"` to all password fields and some text fields to avoid spell-jacking data leaks
121 - issue Remove non working "Analyze Explain at MariaDB.org" button (MariaDB stopped this service)
122 - issue #17229 Add support for Web Authentication API because Chrome removed support for the U2F API
123 - issue #18019 Fix "Call to a member function fetchAssoc() on bool" with SQL mode ONLY_FULL_GROUP_BY on monitor search logs
124 - issue Add back UUID and UUID_SHORT to functions on MySQL and all MariaDB versions
125 - issue #17398 Fix clicking on JSON columns triggers update query
126 - issue Fix silent JSON parse error on upload progress
127 - issue #17833 Fix "Add Parameter" button not working for Add Routine Screen
128 - issue #17365 Fixed "Uncaught Error: regexp too big" on server status variables page
129 - issue [security] Fix an XSS attack through the drag-and-drop upload feature (PMASA-2023-01)
132 - issue #16521 Upgrade Bootstrap to version 5
133 - issue #16521 Drop support for Internet Explorer and others
134 - issue Upgrade to shapefile 3
135 - issue #16555 Bump minimum PHP version to 7.2
136 - issue Remove the phpseclib dependency
137 - issue Upgrade Symfony components to version 5.2
138 - issue Upgrade to Motranslator 4
139 - issue #16005 Improve the performance of the Export logic
140 - issue #16829 Add "NOT LIKE %...%" operator to Table search
141 - issue #16845 Fixed some links not passing through url.php
142 - issue #16382 Remove apc upload progress method (all upload progress code was removed from the PHP extension)
143 - issue #16974 Replace zxcvbn by zxcvbn-ts
144 - issue #15691 Disable the last column checkbox in the column list dropdown instead of not allowing un-check
145 - issue #16138 Ignore the length of integer types and show a warning on MySQL >= 8.0.18
146 - issue Add support for the Mroonga engine
147 - issue Double click column name to directly copy to clipboard
148 - issue #16425 Add "DELETE FROM" table on table operations page
149 - issue #16482 Add a select all link for table-specific privileges
150 - issue #14276 Add support for account locking
151 - issue #17143 Use composer/ca-bundle to manage the CA cert file
152 - issue #17143 Require the openssl PHP extension
153 - issue #17171 Remove the printview.css file from themes
154 - issue #17203 Redesign the export and the import pages
155 - issue #16197 Replace the master/slave terminology
156 - issue #17257 Replace libraries/vendor_config.php constants with an array
157 - issue Add the Bootstrap theme
158 - issue #17499 Remove stickyfilljs JavaScript dependency
161 - issue #17287 Fixed sorting the database list with "statistics" enabled on "Data" column creates a PHP type error
162 - issue #17368 Fix for invalid cache when losing access to config storage after it being cached
163 - issue #17387 Fix session cookie not respecting the CookieSameSite configuration directive in PHP 7.2
164 - issue #16769 Fix create index form accepting too many columns
165 - issue #16816 Disable editing to system schemas
166 - issue #16853 Add better error handling when IndexedDB is not working
167 - issue Fixed incorrect escaping of special MySQL characters on some pages
168 - issue #17188 Fix GIS visualization with an edited query
169 - issue #17418 Remove the use of the deprecated `strftime` function in OpenDocument exports
170 - issue #17111 Enable tabindex recompute on preview button while insert new rows
171 - issue #17474 Fix invalid SQL generated when PRIMARY/UNIQUE key contains a POINT column
172 - issue #17484 Fix setup's CSS not loading when the URL doesn't have a trailing slash
173 - issue #17494 Remove jQuery SVG JavaScript dependency
174 - issue #17335 Fix column visibility dropdown when the column name is too long
175 - issue #17445 Fix issue when exporting using Firefox or Safari on PHP 8.1.4
176 - issue Update JavaScript dependencies
177 - issue #17428 Fix case where errors were thrown when browsing a table
178 - issue #17508 Fix UI issue when user accounts page has the initials navigation bar
181 - issue #17308 Fix broken pagination links in the navigation sidebar
182 - issue #17331 Fix MariaDB has no support for system variable "disabled_storage_engines"
183 - issue #17315 Fix unsupported operand types in Results.php when running "SHOW PROCESSLIST" SQL query
184 - issue #17288 Fixed importing browser settings question box after login when having no pmadb
185 - issue #17288 Fix "First day of calendar" user override has no effect
186 - issue #17239 Fixed repeating headers are not working
187 - issue #17298 Fixed import of email-adresses or links from ODS results in empty contents
188 - issue #17344 Fixed a type error on ODS import with non string values
189 - issue #17239 Fixed header row show/hide columns buttons on each line after hover are shown on each row
190 - issue [security] Fix for path disclosure under certain server configurations (if display_errors is on, for instance)
193 - issue Replaced MySQL documentation redirected links
194 - issue #16960 Fix JS error on Designer visual builder on some modal buttons
195 - issue Re-build openlayers JS dependency from the source files and provide a smaller JS bundle
196 - issue Fixed imports and theme detection depending on the current working dir
197 - issue Update JavaScript dependencies
198 - issue #16935 Remove hardcoded row length for "$cfg['CharTextareaRows']" to allow back values < 7
199 - issue #16977 Fix encoding of enum and set values on edit value
200 - issue Fix set value as selected when it has special chars on edit value enum
201 - issue #16896 Fix distinct URLs broken on nullable text fields
202 - issue Fixed two possible PHP errors using INT data
203 - issue Fixed possible warning "Undefined index: output_format" on export
204 - issue Fixed warning "Undefined index: ods_recognize_percentages" on Import ODS
205 - issue Fixed warning "Undefined array key "ods_recognize_currency" on Import ODS
206 - issue #16982 Fixed "Notice: Undefined index: foreign_keys_data" on Designer remove relation
207 - issue Backquote phpMyAdmin table name on internal relation delete query for Designer
208 - issue #16982 Do not try to delete internal relations if they are not configured
209 - issue #16982 Show success messages on Designer for add and remove relation operations
210 - issue Fixed possible "Undefined index: clause_is_unique" on replace value in cell
211 - issue #16991 Fixed case where $_SERVER['REQUEST_METHOD'] is undefined
212 - issue Fixed configuration error handler registration
213 - issue #16997 Fixed server variables get/set value not working on multi server server > 1
214 - issue #16998 Fixed Multi table query submit on server > 1 logged out user
215 - issue #17000 Fixed Multi edit on central columns on server > 1 logged out user
216 - issue #17001 Fix PHP error on query submit without a table name on multi table query box
217 - issue #16999 Fixed multi table query results shows for 1 sec and then page refreshes
218 - issue Fixed a non translated button text on central columns add
219 - issue Fixed table width on Query by example page for large screens
220 - issue #16975 Fixed NULL default had a value on insert with datatime fields
221 - issue #16994 Fixed missing privilege escaping when assigning multiple databases with '_' to an user
222 - issue #16864 Fixed the margin on the last database of the tree on all themes when scrollbars are displayed
223 - issue #17011 Fixed the database tree line that was not continuous on database groups
224 - issue Build more syntax correct URLs on JS internal redirects
225 - issue #16976 Fix wrong link when a table is moved from a database to another
226 - issue #16985 Fix case-sensitive issue of innodb_file_format=barracuda vs innodb_file_format=Barracuda
227 - issue Fixed duplicate quote in navigation nodes
228 - issue #17006 Disable the URL limit for the MariaDB analyser feature
229 - issue Fix calls to fetchRow using two parameters but the function has only one parameter
230 - issue #17020 Fixed "Notice Undefined index: sql_query" on Insert page
231 - issue Fix reported "Undefined index: FirstDayOfCalendar"
232 - issue Fix reported "Undefined index: environment"
233 - issue Fix "TypeError: strlen() expects parameter 1 to be string, null given" on databases listing
234 - issue #16973 Fix "Undefined array key "n0_pos2_name"" on databases listing
235 - issue Use the correct min MySQL version for axis-order (8.0.1) instead of (8.0.11)
236 - issue Use the queries we asked the user confirmation for on DELETE and TRUNCATE table actions
237 - issue #16994 Fixed editing specific privileges for a database covered by a wildcard privilege
238 - issue #16994 Fixed escaping of the database name for databases containing '_' on users edit
239 - issue #16994 Only escape once on grant/revoke privileges for databases containing '_' or '%'
240 - issue #16994 Only show databases without a privilege on multi select for user grant databases
241 - issue Removed un-expected query success message from the Table export page
242 - issue #17026 Handle possible invalid boolean values injected in SaveDir or UploadDir causing "TypeError: mb_substr()"
243 - issue #16981 Enable cookie parameter "SameSite" on "phpMyAdmin" cookie for PHP >= 7.3
244 - issue #16966 Encode "#" to have the anchor part of the destination URL on SQL highlight terms URLs
245 - issue #17004 Fix PHP errors due to removed variable "innodb_file_format" on MariaDB >= 10.6.0 and MySQL >= 8.0.0
246 - issue #16842 Fixed missing password modes on PerconaDB
247 - issue #16947 Fix "Change login information" form not working
248 - issue #17004 Fix Advisor for MariaDB >= 10.5 because of removed "innodb_log_files_in_group" variable
249 - issue #17037 Fix change structure does not surface errors
250 - issue #17016 Fixed online Transaction, errors not reported on structure edit
251 - issue #17042 Fix SQL escaping bug on DB name with special chars on submit query with rollback option
252 - issue #17027 Better handle the display of sorted binary columns in results summary
253 - issue #16398 Quote non numeric values on parameterized queries
254 - issue Fixed duplicate HTML escaping on foreign keys select value modal
255 - issue #15370 Fixed edit routine UI incorrectly removes too many escape slashes
256 - issue #14631 Fix enum with comma produces incorrect search dropdown on search pages
257 - issue Fix gis visualization position and limit parameters have no effect
258 - issue #16995 Fix edit binary foreign key adds a 1 to the value on the selected value
259 - issue #13614 Fixed escaping the database names when granting privileges on tables
260 - issue #11834 Fixed adding a new user on "privileges" tab of a table with a database name using a "_" character
261 - issue #17033 Fixed scaling of line width and point size in GIS visualization
262 - issue #17054 Removed "DEL" character from generated random strings for Blowfish secret auto-generated by setup
263 - issue #17019 Fixed "Browse" button visible when creating a table from the database structure view
264 - issue #16804 Fixed numbers where left-aligned rather than right-aligned
265 - issue Fixed Metro theme text color for buttons in the browse table navigation bar
266 - issue #14796 Fix export Database page, UI prevents from exporting procedures only
267 - issue #15225 Fix Command+click on macOS opens links in same tab
268 - issue #17014 Fix column names in first row when importing from CSV where the first line contains column names
269 - issue Fix prevent scrolling the page when scrolling in GIS visualization
270 - issue Fix GIS visualization save file with a different label or column
271 - issue Fixed GIS saving image as png with a label
272 - issue Fixed if label is just the number zero, it was treated as no label in the OpenLayers map
273 - issue #17039 Fix unable to have 2FA working with a "pmadb" config value != phpmyadmin
274 - issue #17079 Fixed missing spatial functions in Insert/Edit page
275 - issue Fixed broken docs link after a FK data type mismatch error
276 - issue Fix don't add multiple OpenLayers maps, remove listeners on dispose on GIS visualization
277 - issue #14502 Uncheck the "ignore" checkbox when the user chooses a value in the foreign key list on Insert page
278 - issue #14502 Uncheck the "ignore" checkbox when the user saves the GIS value on Insert page
279 - issue #17018 Fixed cannot save data from GIS editor for spatial column on Insert page
280 - issue #17084 Fixed ErrorHandler not showing errors when phpMyAdmin session does not work at all
281 - issue #17062 Fixed pagination issues when working with identically named tables in separate databases
282 - issue #17046 Fix "Uncaught TypeError: htmlspecialchars() expects parameter 1 to be string, null given"
283 - issue #16942 Fix table Import with CSV using LOAD DATA LOCAL causes error "LOAD DATA LOCAL INFILE is forbidden"
284 - issue #16942 Fix auto-detection for "LOAD DATA LOCAL INFILE" LOCAL option
285 - issue #16067 Make select elements with multiple items resizable
286 - issue Fix the display of Indexes that use Expressions and not column names
287 - issue Allow to create the phpMyAdmin storage database using a different name than "phpmyadmin" using the interface
288 - issue #17092 Document that "$cfg['Servers'][$i]['designer_coords']" was removed in version 4.3.0
289 - issue #16906 Support special table names for pmadb storage table names
290 - issue #16906 Fix a caching effect on the feature list after creating the tables
291 - issue #16906 Better report errors when creating the pmadb or it's tables
292 - issue #16906 Create the pmadb tables using the names configured and not the default names
293 - issue #16906 Create the phpMyAdmin storage database using the configured "['pmadb']" name and not always "phpmyadmin"
294 - issue #16906 Prevent incorrect overriding of configured values after a pmadb fix
295 - issue #16906 Use the control connection to create the storage database and tables and not the user connection
296 - issue #16693 Fix can't see SQL after adding a new column
297 - issue #12753 Show table structure after adding a new column
298 - issue Fix a PHP notice when logging out
299 - issue #17090 Fix bbcode not rendered for error messages on setup
300 - issue #17198 Fix the database selection when the navigation tree is disabled
301 - issue #17228 Fixed copy to clipboard with NULL values gives non usable text
302 - issue #16746 Replace samyoul/u2f-php-server by code-lts/u2f-php-server
303 - issue #16005 Performance improvement on the Import and Export pages
304 - issue #17247 Fix triple HTML encoding
305 - issue #17259 Fix broken link in the Simulate DML query modal
306 - issue #16746 Update tcpdf dependency to ^6.4.4 for PHP 8.1 compatibility
307 - issue #16746 Update twig dependency to "^2.14.9 || ^3.3.5" for PHP 8.1 compatibility
308 - issue [security] Add configuration directive $cfg['Servers'][$i]['hide_connection_errors'] to allow hiding host names and other error details when login fails
309 - issue [security] Add configuration directive $cfg['URLQueryEncryption'] to allow encrypting senstive information in the URL
310 - issue [security] Fix a scenario where an authenticated user can disable two factor authentication (PMASA-2022-1)
311 - issue [security] Fix XSS and HTML injection attacks in the graphical setup page (PMASA-2022-2)
314 - issue #13325 Fixed created procedure shows up in triggers and events and vice-versa
315 - issue Fixed adding an event shows an empty row
316 - issue #16706 Fixed a PHP error when visualizing a nullable geometry column
317 - issue Fixed a PHP type error when exporting triggers to ODF
318 - issue #16659 Fixed the Column Drop arrow to make it responsive
319 - issue #16677 Improved the Font size of an executed SQL query
320 - issue #16677 Fixed Metro theme DB tree background
321 - issue #16713 Fixed "PhpMyAdmin\Url::getFromRoute" PHP error for old config values
322 - issue #16713 Add a legacy fallback for the old config value of "$cfg['DefaultTabDatabase']" and others
323 - issue #16698 Fix relative fallback URL to './' instead of '/'
324 - issue Fixed Yaml export to quote strings even when they are numeric
325 - issue #16704 Fixed PHP type errors on the substring transformation
326 - issue #14026 Fixed error messages and conditions for MD5 and AES_* functions
327 - issue #16708 Fixed PHP "Uncaught TypeError: hash_hmac()" on double quick edit
328 - issue #16709 Fix TCPDF open_basedir issue due to internal guessing code from TCPDF
329 - issue #16729 Fixed the silencing error management for PHP >= 8.0
330 - issue #16604 Set back tables width like in 5.0 versions
331 - issue #16716 Fixed rename button disappears after a column drop on table structure page
332 - issue #15628 Fixed "JSON encoding failed: Malformed UTF-8 characters" when browsing data that uses binary to IP transformation
333 - issue #14395 Fixed display chart with timeline & series name column trigger JS error
334 - issue #16738 Fixed quick search submit is not working on multi server server > 1
335 - issue #16717 Fixed main drawer js call slowing down the page and remove the reflow effect
336 - issue Fixed a PHP notice "Undefined index: pred_username"
337 - issue #16744 Fixed "Uncaught TypeError: XMLWriter::writeAttribute()" on Designer SVG export
338 - issue Fixed an PHP undefined index notice on export
339 - issue #14555 Fixed JavaScript error when auto completion is open (upgraded CodeMirror to 5.60.0)
340 - issue #16647 Fixed preferences form not showing texts and not respecting TabsMode config
341 - issue Fixed escape_mysql_wildcards Twig filter
342 - issue Change text from "Null" to "NULL" on grid edit popup
343 - issue Translate a non translated string on a change password page
344 - issue Fix designer modal buttons sizes for pmahomme and bootstrap themes
345 - issue #16694 Fixed "Triggers" page not visible for user table specific privileges
346 - issue #14430 Fixed execute button is disabled for routines
347 - issue #16703 Fixed SQL option to Export specific rows from a table
348 - issue #16656 Fixed error messages are not always translated
349 - issue #16728 Fixed wrong SQL query built on table structure index for new column
350 - issue #16647 Fixed table search forms not showing texts and not respecting TabsMode config
351 - issue #16758 Fixed copy to clipboard feature not working on ja or zh_TW languages because of the non ascii colon
352 - issue #16601 Update tcpdf dependency to ^6.4.1
353 - issue #16770 Fixed a notice or warning, when clicking on Structure tab
354 - issue #16756 Fixed refresh UI on server status
355 - issue Fixed a PHP notice when searching for .git/commondir on the login page for users using ShowGitRevision
356 - issue Fixed reported PHP notice on export save template
357 - issue Fixed reported PHP warnings on server status page
358 - issue #15629 Fixed datetime decimals displayed (.00000) after edit
359 - issue #16780 Fixed new event shows an empty row
360 - issue #16765 Fixed new lines in text fields are doubled
361 - issue Fix "Connection" label always shown on table create, should be hidden like it's input
362 - issue #16773 Fix do not use cast as binary for an empty text value on edit button condition
363 - issue Fixed a JS error on a missing script on zoom search
364 - issue Added button style on the reset charts of zoom search
365 - issue Fixed number of rows not kept when changing sort by index value
366 - issue #16784 Fixed spacing between icons when using NavigationTreeDefaultTabTable2 configuration
367 - issue #16786 Fixed browser error when clicking the logo with NavigationLogoLink configuration
368 - issue Fixed a type error when getting the special schema links
369 - issue #16789 Fix create PHP code removes ; from SQL query on Structure snapshot
370 - issue #16791 Fixed "Undefined index table_schema" on special schema table
371 - issue Fixed "DESCRIBE FILES;" broken links in query results
372 - issue #16790 Fixed "Undefined index field_name" PHP error
373 - issue #16605 Fixed vertical alignment issue on tables for pmahomme theme
374 - issue #16798 Fix ServerConfigChecks: Link 'trusted proxies list' not terminated properly (translation)
375 - issue #16805 Fixed shortcut keys not working
376 - issue #16821 Fix "Show all rows" un-check checkbox creates a JS error if the page was reloaded
377 - issue Remove redundant jQuery Event Drag plugin
378 - issue Fix PHP type error on GIS nullable data
379 - issue Fix not working export to PNG, SVG, PDF on GIS visualization
380 - issue Fix float values type errors on GIS export to PNG, SVG, PDF
381 - issue #16792 Fixed URL generation by removing un-needed & escaping for & char
382 - issue #16777 Fixed Non-UTF8 Primary Key text value edit row
383 - issue #16836 Fixed extra whitespaces in binary edit values causes a JS validation error message
384 - issue #15566 Support RTL mode on the Designer
385 - issue #16810 Fixed SQL query shown twice on drop column success
386 - issue #16404 Fixed JS password generation fails after a new user creation failure
387 - issue #16837 Fixed PHP error on execute query "create table event(...)"
388 - issue Fixed a PHP warning that was occuring on wrong chmod on config files
389 - issue Fixed a JS error on dismiss notification modal
390 - issue #16793 Upgrade CodeMirror to 5.61.0 to fix a JS error on scroll in SQL query box
391 - issue Fix password management for Percona Server lacking PASSWORD function
392 - issue Fixed "data is undefined" JS error
393 - issue Fixed 2 un-translated buttons on central columns edit
394 - issue #16810 Fixed SQL query shown twice on central columns actions
395 - issue #16771 Fixed PHP array export to work on very large datasets
396 - issue #16847 Fixed JSON export nullable binary PHP error
397 - issue #16847 Fixed JSON export text fields and binary data
398 - issue #14773 Fix exporting a raw query is not working
399 - issue #16734 Fixed memory limit reached, use SQL COUNT(*) instead of fetch and count results
400 - issue #16723 Fixed option to perform ALTER ONLINE is not available on edit of an existing column
401 - issue Add missing CSS style on "Filter" button on monitor results table header
402 - issue Fixed non working "Filter" button on monitor results table header
403 - issue #16420 Fixed single clicking on row starts editing even if GridEditing is set to double-click
404 - issue #16854 Fixed "Undefined index: SERVER_SOFTWARE" on very minimal PHP FPM setups
405 - issue #16863 Fixed replication setting up a replica is not working
406 - issue #16843 Fixed vertical alignment in Metro and pmahomme themes on user accounts overview
407 - issue Fixed "phpMyAdmin configuration storage" link on settings page warning
408 - issue #16871 Fixed PHP and JS errors on normalization steps
409 - issue Fixed CSS missing classes on normalization buttons
410 - issue #16437 Fixed sticky top position when using smaller screen sizes
411 - issue #16895 Fixed wrong table count on space separated numbers
412 - issue #16882 Fixed table delete resets count to 0
413 - issue #16892 Fixed current_timestamp() stringified on INSERT for date field
414 - issue #16911 Fixed PHP 8.1 "Method mysqli::get_client_info() is deprecated"
415 - issue Fix "array_fill(): Argument #2 ($count) must be of type int, string" for "$cfg['InsertRows']"
416 - issue #14130 Created new messages for U2F errors
417 - issue #16920 Fixed "Uncaught TypeError: PhpMyAdmin\Import::detectType()" on ODS import
418 - issue #16926 Fixed ODS import warning: Undefined array key "ods_empty_rows"
419 - issue #16888 Fixed JS error on renaming tables in saved Designer page
420 - issue #16504 Fixed create view dialog is too big and won't scroll (on small screens)
421 - issue #16931 Fixed php notice "Undefined index: utf8mb3" on MySQL 8.0.11+ servers with default utf8 server charset
424 - issue #15350 Change Media (MIME) type references to Media type
425 - issue #15377 Add a request router
426 - issue Automatically focus input in the two-factor authentication window
427 - issue #15509 Replace gender-specific pronouns with gender-neutral pronouns
428 - issue #15491 Improve complexity of generated passwords
429 - issue #14909 Add a configuration option to define the 1st day of week
430 - issue #12726 Made user names clickable in user accounts overview
431 - issue #15729 Improve virtuality dropdown for MariaDB > 10.1
432 - issue #15312 Added an option to perform ALTER ONLINE (ALGORITHM=INPLACE) when editing a table structure
433 - issue Added missing 'IF EXISTS' to 'DROP EVENT' when exporting databases
434 - issue #15232 Improve the padding in query result tool links
435 - issue #15064 Support exporting raw SQL queries
436 - issue #15555 Added ip2long transformation
437 - issue #15194 Fixed horizontal scroll on structure edit page
438 - issue #14820 Move table hide buttons in navigation to avoid hiding a table by mistake
439 - issue #14947 Use correct MySQL version if the version is 8.0 or above for documentation links
440 - issue #15790 Use "MariaDB Documentation" instead of "MySQL Documentation" on a MariaDB server
441 - issue #15880 Change "Show Query" link to a button
442 - issue #13371 Automatically toggle the radio button to "Create a page and save it" on Designer
443 - issue #12969 Tap and hold will not dismiss the error box anymore, you can now copy the error
444 - issue #15582 Don't disable "Empty" table button after clicking it
445 - issue #15662 Stay on the structure page after editing/adding/dropping indexes
446 - issue #15663 show structure after adding a column
447 - issue #16005 Remove symfony/yaml dependency
448 - issue #16005 Improve performance of dependency injection system by removing yaml parsing
449 - issue #15447 Disable phpMyAdmin storage database checkbox on databases list
450 - issue #16001 Add autocomplete attributes on login form
451 - issue #13519 Add "Preview SQL" option on Index dialog box when creating a new table
452 - issue #15954 Fixed export maximal length of created query input is too small
453 - issue Redesign the server status advisor page
454 - issue #13124 Use same height for SQL query textarea and Columns select in SQL page
455 - issue #16005 Add a new vendor constant "CACHE_DIR" that defaults to "libraries/cache/" and store routing cache into this folder
456 - issue #16005 Warm-up the routing cache before building the release
457 - issue #16005 Use --optimize-autoloader when installing composer vendors before building the release
458 - issue #15992 Add back the table name to the printable version on "Structure" page
459 - issue #14815 Allow simplifying exported view syntax to only "CREATE VIEW"
460 - issue #15496 Add $cfg['CaptchaSiteVerifyURL'] for Google ReCaptcha siteVerifyUrl
461 - issue #14772 Add the password_hash PHP function as an option when inserting data
462 - issue #15136 Add a notice for Hex converter giving invalid results
463 - issue #16139 Use a textarea for JSON columns
464 - issue #16223 Make JSON input transformation editor less narrow
465 - issue #14340 Add a button on Export Page to show the SQL Query
466 - issue #16304 Add support for INET6 column type
467 - issue #16337 Fix example insert/update query default values
468 - issue #12961 Remove indexes from table relation
469 - issue #13557 Use a full list of functions instead of a separated one on insert/edit page "Function" selector
470 - issue #14795 Include routines in the export in a predictable order
471 - issue #16227 Fixed autocomplete is not working in case the table name is quoted by "`" symbols
472 - issue #15463 Force BINARY comparison when looking at privileges to avoid an SQL error on privileges tab
473 - issue #16430 Fixed Windows error message uses trailing / instead of \
474 - issue #16316 Added support for "SameSite=Strict" on cookies using configuration "$cfg['CookieSameSite']"
475 - issue #16451 Fixed AWS RDS IAM authentication doesn't work because pma_password is truncated
476 - issue #16451 Show an error message when the security limit is reached instead of silently trimming the password to avoid confusion
477 - issue #15001 Add back Login Cookie Validity setting to the features form
478 - issue #16457 Add config parameters to support third-party ReCaptcha v2 compatible APIs like hCaptcha
479 - issue #13077 Moved tools section to left on large devices (Bootstrap xl)
480 - issue #15711 Moved some buttons to left on large devices (Bootstrap xl)
481 - issue #15584 Add $cfg['MysqlSslWarningSafeHosts'] to set the red text black when ssl is not used on a private network
482 - issue #15652 Replace deprecated FOUND_ROWS() function call on "distinct values" feature
483 - issue Export blobs as hex on JSON export
484 - issue #16095 Fix leading space not shown in a CHAR column when browsing a table
485 - issue Make procedures/functions SQL editor both side scrollable
486 - issue #16407 Bump pragmarx/google2fa conflict to >8.0
487 - issue #14953 Added a rename Button to use RENAME INDEX syntax of MySQL 5.7 (and MariaDB >= 10.5.2)
488 - issue #16477 Fixed no Option to enter TABLE specific permissions when the database name contains an "_" (underscore)
489 - issue #16498 Fixed empty text not appearing after deleting all Routines
490 - issue #16467 Fixed a PHP notice "Trying to access array offset on value of type null" on Designer PDF export
491 - issue #15658 Fixed saving UI displayed columns on a non database request fails
492 - issue #16495 Fix drop tables checkbox is above the checkbox for foreign keys
493 - issue #16485 Fix visual query builder missing "Build Query" button
494 - issue #16565 Added 'IF EXISTS' to 'DROP EVENT' when updating events to avoid replication issues
495 - issue Removed metro fonts that where Apache-2.0 files that are incompatible with GPL-2.0
496 - issue #16464 Made the relation view default to the current database when creating relations
497 - issue #16463 Fixed 'REFERENCES' privilege checkbox's title on new MySQL versions and on MariaDB
498 - issue #16405 Added jest as a Unit Testing tool for our javascript code
499 - issue #16252 Fixed the too small font size when editing rows (textareas)
500 - issue #16585 Fixed BLOB to JPG transformation PHP errors
501 - issue Made the console setup async to avoid blocking the page render
502 - issue #16429 Use PHP 8.0 fixed version (commit) for TCPDF
503 - issue #16005 Major performance improvements on browsing a lot of rows
504 - issue #16595 Fixed editing columns having a `_` in their name in specific conditions
505 - issue #16608 Fix "Sort by key" restore auto saved value
506 - issue #16611 Fixed unable to add tables to rename aliases twice on Export
507 - issue #16621 Fixed link HTML messed up in Advisor
508 - issue #16622 Fixed Advisor formatting incorrect for long_query_time notice
509 - issue #15389 Fixed reset current page indicator after deleting all rows to current page and not page 1
510 - issue #15997 Fixed auto save query
511 - issue #15997 Made auto saved query database or database+table independent
512 - issue #16641 Fixed query generation that was allowing JSON to have a length
513 - issue #15994 Fixed the selected value detection for "on update current_timestamp"
514 - issue #16614 Fixed PHP 8.0 dataseek offset call to the MySQLI extension
515 - issue #16662 Fixed Uncaught TypeError on "delete" button click of a database search results page
516 - issue Fixed Undefined index: selected_usr when the user tried to delete no selected user
517 - issue #16657 Fixed the QBE interface when the configuration storage is not enabled
518 - issue #16479 Fix our Selenium test-suite
519 - issue #16669 Fixed table search modal for BETWEEN
520 - issue #16667 Fixed LIKE and TINYINT in search not working properly
521 - issue #16424 Fixed numerical search in table and zoom
522 - issue Improve the version handling (new Version class) and add a VERSION_SUFFIX for vendors
523 - issue #14494 Fix uncaught TypeError when editing partitioning
524 - issue #16525 Fix PHP 8.0 failing tests when comparing 0 to ''
525 - issue #16429 Fixed PHP 8.0 errors on preg_replace and operand types
526 - issue #16490 Fixed PHP 8.0 function libxml_disable_entity_loader() is deprecated
527 - issue #16429 Fixed failing unit tests on PHP 8.0
528 - issue #16609 Fixed Sql.rearrangeStickyColumns is not a function
531 - issue [security] Fix an XSS attack through the drag-and-drop upload feature
534 - issue #17308 Fix broken pagination links in the navigation sidebar
537 - issue #17305 Fix syntax error for PHP 5
538 - issue #17307 Fix hide_connection_errors being undefined when a controluser is set
541 - issue #14321 Display a correct error page when "$cfg['Servers'][$i]['SignonURL']" is empty for auth_type=signon
542 - issue #14321 [security] Remove leaked HTML on signon page redirect before login for auth_type=signon
543 - issue [security] Add configuration directive $cfg['Servers'][$i]['hide_connection_errors'] to allow hiding host names and other error details when login fails
544 - issue [security] Add configuration directive $cfg['URLQueryEncryption'] to allow encrypting senstive information in the URL
545 - issue [security] Fix a scenario where an authenticated user can disable two factor authentication
547 --- Older ChangeLogs can be found on our project website ---
548 https://www.phpmyadmin.net/old-stuff/ChangeLogs/
550 # vim: et ts=4 sw=4 sts=4
551 # vim: ft=changelog fenc=utf-8
552 # vim: fde=getline(v\:lnum-1)=~'^\\s*$'&&getline(v\:lnum)=~'\\S'?'>1'\:1&&v\:lnum>4&&getline(v\:lnum)!~'^#'
553 # vim: fdn=1 fdm=expr