4 5.2.0 (not yet released)
5 - issue #16521 Upgrade Bootstrap to version 5
6 - issue #16521 Drop support for Internet Explorer and others
7 - issue Upgrade to shapefile 3
8 - issue #16555 Bump minimum PHP version to 7.2
9 - issue Upgrade phpseclib to version 3
10 - issue Upgrade Symfony components to version 5.2
11 - issue Upgrade to Motranslator 4
12 - issue #16005 Improve the performance of the Export logic
14 5.1.1 (not yet released)
15 - issue #13325 Fixed created procedure shows up in triggers and events and vice-versa
16 - issue Fixed adding an event shows an empty row
17 - issue #16706 Fixed a PHP error when visualizing a nullable geometry column
18 - issue Fixed a PHP type error when exporting triggers to ODF
19 - issue #16659 Fixed the Column Drop arrow to make it responsive
20 - issue #16677 Improved the Font size of an executed SQL query
21 - issue #16677 Fixed Metro theme DB tree background
22 - issue #16713 Fixed "PhpMyAdmin\Url::getFromRoute" PHP error for old config values
23 - issue #16713 Add a legacy fallback for the old config value of "$cfg['DefaultTabDatabase']" and others
24 - issue #16698 Fix relative fallback URL to './' instead of '/'
25 - issue Fixed Yaml export to quote strings even when they are numeric
26 - issue #16704 Fixed PHP type errors on the substring transformation
27 - issue #14026 Fixed error messages and conditions for MD5 and AES_* functions
28 - issue #16708 Fixed PHP "Uncaught TypeError: hash_hmac()" on double quick edit
29 - issue #16709 Fix TCPDF open_basedir issue due to internal guessing code from TCPDF
30 - issue #16729 Fixed the silencing error management for PHP >= 8.0
31 - issue #16604 Set back tables width like in 5.0 versions
32 - issue #16716 Fixed rename button disappears after a column drop on table structure page
33 - issue #15628 Fixed "JSON encoding failed: Malformed UTF-8 characters" when browsing data that uses binary to IP transformation
34 - issue #14395 Fixed display chart with timeline & series name column trigger JS error
35 - issue #16738 Fixed quick search submit is not working on multi server server > 1
36 - issue #16717 Fixed main drawer js call slowing down the page and remove the reflow effect
37 - issue Fixed a PHP notice "Undefined index: pred_username"
38 - issue #16744 Fixed "Uncaught TypeError: XMLWriter::writeAttribute()" on Designer SVG export
39 - issue Fixed an PHP undefined index notice on export
40 - issue #14555 Fixed JavaScript error when auto completion is open (upgraded CodeMirror to 5.60.0)
41 - issue #16647 Fixed preferences form not showing texts and not respecting TabsMode config
42 - issue Fixed escape_mysql_wildcards Twig filter
43 - issue Change text from "Null" to "NULL" on grid edit popup
44 - issue Translate a non translated string on a change password page
45 - issue Fix designer modal buttons sizes for pmahomme and bootstrap themes
46 - issue #16694 Fixed "Triggers" page not visible for user table specific privileges
47 - issue #14430 Fixed execute button is disabled for routines
48 - issue #16703 Fixed SQL option to Export specific rows from a table
49 - issue #16656 Fixed error messages are not always translated
50 - issue #16728 Fixed wrong SQL query built on table structure index for new column
51 - issue #16647 Fixed table search forms not showing texts and not respecting TabsMode config
52 - issue #16758 Fixed copy to clipboard feature not working on ja or zh_TW languages because of the non ascii colon
53 - issue #16601 Update tcpdf dependency to ^6.4.1
54 - issue #16770 Fixed a notice or warning, when clicking on Structure tab
55 - issue #16756 Fixed refresh UI on server status
56 - issue Fixed a PHP notice when searching for .git/commondir on the login page for users using ShowGitRevision
57 - issue Fixed reported PHP notice on export save template
58 - issue Fixed reported PHP warnings on server status page
59 - issue #15629 Fixed datetime decimals displayed (.00000) after edit
60 - issue #16780 Fixed new event shows an empty row
61 - issue #16765 Fixed new lines in text fields are doubled
62 - issue Fix "Connection" label always shown on table create, should be hidden like it's input
63 - issue #16773 Fix do not use cast as binary for an empty text value on edit button condition
64 - issue Fixed a JS error on a missing script on zoom search
65 - issue Added button style on the reset charts of zoom search
66 - issue Fixed number of rows not kept when changing sort by index value
67 - issue #16784 Fixed spacing between icons when using NavigationTreeDefaultTabTable2 configuration
68 - issue #16786 Fixed browser error when clicking the logo with NavigationLogoLink configuration
69 - issue Fixed a type error when getting the special schema links
70 - issue #16789 Fix create PHP code removes ; from SQL query on Structure snapshot
71 - issue #16791 Fixed "Undefined index table_schema" on special schema table
72 - issue Fixed "DESCRIBE FILES;" broken links in query results
73 - issue #16790 Fixed "Undefined index field_name" PHP error
74 - issue #16605 Fixed vertical alignment issue on tables for pmahomme theme
75 - issue #16798 Fix ServerConfigChecks: Link 'trusted proxies list' not terminated properly (translation)
76 - issue #16805 Fixed shortcut keys not working
79 - issue #15350 Change Media (MIME) type references to Media type
80 - issue #15377 Add a request router
81 - issue Automatically focus input in the two-factor authentication window
82 - issue #15509 Replace gender-specific pronouns with gender-neutral pronouns
83 - issue #15491 Improve complexity of generated passwords
84 - issue #14909 Add a configuration option to define the 1st day of week
85 - issue #12726 Made user names clickable in user accounts overview
86 - issue #15729 Improve virtuality dropdown for MariaDB > 10.1
87 - issue #15312 Added an option to perform ALTER ONLINE (ALGORITHM=INPLACE) when editing a table structure
88 - issue Added missing 'IF EXISTS' to 'DROP EVENT' when exporting databases
89 - issue #15232 Improve the padding in query result tool links
90 - issue #15064 Support exporting raw SQL queries
91 - issue #15555 Added ip2long transformation
92 - issue #15194 Fixed horizontal scroll on structure edit page
93 - issue #14820 Move table hide buttons in navigation to avoid hiding a table by mistake
94 - issue #14947 Use correct MySQL version if the version is 8.0 or above for documentation links
95 - issue #15790 Use "MariaDB Documentation" instead of "MySQL Documentation" on a MariaDB server
96 - issue #15880 Change "Show Query" link to a button
97 - issue #13371 Automatically toggle the radio button to "Create a page and save it" on Designer
98 - issue #12969 Tap and hold will not dismiss the error box anymore, you can now copy the error
99 - issue #15582 Don't disable "Empty" table button after clicking it
100 - issue #15662 Stay on the structure page after editing/adding/dropping indexes
101 - issue #15663 show structure after adding a column
102 - issue #16005 Remove symfony/yaml dependency
103 - issue #16005 Improve performance of dependency injection system by removing yaml parsing
104 - issue #15447 Disable phpMyAdmin storage database checkbox on databases list
105 - issue #16001 Add autocomplete attributes on login form
106 - issue #13519 Add "Preview SQL" option on Index dialog box when creating a new table
107 - issue #15954 Fixed export maximal length of created query input is too small
108 - issue Redesign the server status advisor page
109 - issue #13124 Use same height for SQL query textarea and Columns select in SQL page
110 - issue #16005 Add a new vendor constant "CACHE_DIR" that defaults to "libraries/cache/" and store routing cache into this folder
111 - issue #16005 Warm-up the routing cache before building the release
112 - issue #16005 Use --optimize-autoloader when installing composer vendors before building the release
113 - issue #15992 Add back the table name to the printable version on "Structure" page
114 - issue #14815 Allow simplifying exported view syntax to only "CREATE VIEW"
115 - issue #15496 Add $cfg['CaptchaSiteVerifyURL'] for Google ReCaptcha siteVerifyUrl
116 - issue #14772 Add the password_hash PHP function as an option when inserting data
117 - issue #15136 Add a notice for Hex converter giving invalid results
118 - issue #16139 Use a textarea for JSON columns
119 - issue #16223 Make JSON input transformation editor less narrow
120 - issue #14340 Add a button on Export Page to show the SQL Query
121 - issue #16304 Add support for INET6 column type
122 - issue #16337 Fix example insert/update query default values
123 - issue #12961 Remove indexes from table relation
124 - issue #13557 Use a full list of functions instead of a separated one on insert/edit page "Function" selector
125 - issue #14795 Include routines in the export in a predictable order
126 - issue #16227 Fixed autocomplete is not working in case the table name is quoted by "`" symbols
127 - issue #15463 Force BINARY comparison when looking at privileges to avoid an SQL error on privileges tab
128 - issue #16430 Fixed Windows error message uses trailing / instead of \
129 - issue #16316 Added support for "SameSite=Strict" on cookies using configuration "$cfg['CookieSameSite']"
130 - issue #16451 Fixed AWS RDS IAM authentication doesn't work because pma_password is truncated
131 - issue #16451 Show an error message when the security limit is reached instead of silently trimming the password to avoid confusion
132 - issue #15001 Add back Login Cookie Validity setting to the features form
133 - issue #16457 Add config parameters to support third-party ReCaptcha v2 compatible APIs like hCaptcha
134 - issue #13077 Moved tools section to left on large devices (Bootstrap xl)
135 - issue #15711 Moved some buttons to left on large devices (Bootstrap xl)
136 - issue #15584 Add $cfg['MysqlSslWarningSafeHosts'] to set the red text black when ssl is not used on a private network
137 - issue #15652 Replace deprecated FOUND_ROWS() function call on "distinct values" feature
138 - issue Export blobs as hex on JSON export
139 - issue #16095 Fix leading space not shown in a CHAR column when browsing a table
140 - issue Make procedures/functions SQL editor both side scrollable
141 - issue #16407 Bump pragmarx/google2fa conflict to >8.0
142 - issue #14953 Added a rename Button to use RENAME INDEX syntax of MySQL 5.7 (and MariaDB >= 10.5.2)
143 - issue #16477 Fixed no Option to enter TABLE specific permissions when the database name contains an "_" (underscore)
144 - issue #16498 Fixed empty text not appearing after deleting all Routines
145 - issue #16467 Fixed a PHP notice "Trying to access array offset on value of type null" on Designer PDF export
146 - issue #15658 Fixed saving UI displayed columns on a non database request fails
147 - issue #16495 Fix drop tables checkbox is above the checkbox for foreign keys
148 - issue #16485 Fix visual query builder missing "Build Query" button
149 - issue #16565 Added 'IF EXISTS' to 'DROP EVENT' when updating events to avoid replication issues
150 - issue Removed metro fonts that where Apache-2.0 files that are incompatible with GPL-2.0
151 - issue #16464 Made the relation view default to the current database when creating relations
152 - issue #16463 Fixed 'REFERENCES' privilege checkbox's title on new MySQL versions and on MariaDB
153 - issue #16405 Added jest as a Unit Testing tool for our javascript code
154 - issue #16252 Fixed the too small font size when editing rows (textareas)
155 - issue #16585 Fixed BLOB to JPG transformation PHP errors
156 - issue Made the console setup async to avoid blocking the page render
157 - issue #16429 Use PHP 8.0 fixed version (commit) for TCPDF
158 - issue #16005 Major performance improvements on browsing a lot of rows
159 - issue #16595 Fixed editing columns having a `_` in their name in specific conditions
160 - issue #16608 Fix "Sort by key" restore auto saved value
161 - issue #16611 Fixed unable to add tables to rename aliases twice on Export
162 - issue #16621 Fixed link HTML messed up in Advisor
163 - issue #16622 Fixed Advisor formatting incorrect for long_query_time notice
164 - issue #15389 Fixed reset current page indicator after deleting all rows to current page and not page 1
165 - issue #15997 Fixed auto save query
166 - issue #15997 Made auto saved query database or database+table independent
167 - issue #16641 Fixed query generation that was allowing JSON to have a length
168 - issue #15994 Fixed the selected value detection for "on update current_timestamp"
169 - issue #16614 Fixed PHP 8.0 dataseek offset call to the MySQLI extension
170 - issue #16662 Fixed Uncaught TypeError on "delete" button click of a database search results page
171 - issue Fixed Undefined index: selected_usr when the user tried to delete no selected user
172 - issue #16657 Fixed the QBE interface when the configuration storage is not enabled
173 - issue #16479 Fix our Selenium test-suite
174 - issue #16669 Fixed table search modal for BETWEEN
175 - issue #16667 Fixed LIKE and TINYINT in search not working properly
176 - issue #16424 Fixed numerical search in table and zoom
177 - issue Improve the version handling (new Version class) and add a VERSION_SUFFIX for vendors
178 - issue #14494 Fix uncaught TypeError when editing partitioning
179 - issue #16525 Fix PHP 8.0 failing tests when comparing 0 to ''
180 - issue #16429 Fixed PHP 8.0 errors on preg_replace and operand types
181 - issue #16490 Fixed PHP 8.0 function libxml_disable_entity_loader() is deprecated
182 - issue #16429 Fixed failing unit tests on PHP 8.0
183 - issue #16609 Fixed Sql.rearrangeStickyColumns is not a function
186 - issue #16245 Fix failed Zoom search clears existing values
187 - issue Fixed a PHP error when reporting a particular JS error
188 - issue #16326 Fixed latitude and longitude swap for geometries in edit mode
189 - issue #16032 Fix CREATE TABLE not being tracked when auto tracking is enabled
190 - issue #16397 Fix compatibility problems with older PHP versions (also issue #16399)
191 - issue #16396 Fix broken two-factor authentication
194 - issue #15983 Require twig ^2.9
195 - issue Fix option to import files locally appearing as not available
196 - issue #16048 Fix to allow NULL as a default bit value
197 - issue #16062 Fix "htmlspecialchars() expects parameter 1 to be string, null given" on Export xml
198 - issue #16078 Fix no charts in monitor when using a decimal separator ","
199 - issue #16041 Fix IN(...) clause doesn't permit multiple values on "Search" page
200 - issue #14411 Support double tap to edit on mobile
201 - issue #16043 Fix php error "Use of undefined constant MYSQLI_TYPE_JSON" when using the mysqlnd extension
202 - issue #14611 Fix fatal JS error on index creation after using Enter key to submit the form
203 - issue #16012 Set "axis-order" to swap lon and lat on MySQL >= 8.1
204 - issue #16104 Fixed overwriting a bookmarked query causes a PHP fatal error
205 - issue Fix typo in a condition in the Sql class
206 - issue #15996 Fix local setup doc links pointing to a wrong location
207 - issue #16093 Fix error importing utf-8 with bom sql file
208 - issue #16089 2FA UX enhancement: autofocus 2FA input
209 - issue #16127 Fix table column description PHP error when ['DisableIS'] = true;
210 - issue #16130 Fix local documentation links display when a PHP extension is missing
211 - issue Fix some twig code deprecations for php 8
212 - issue Fix ENUM and SET display when editing procedures and functions
213 - issue Keep full query state on "auto refresh" process list
214 - issue Keep columns order on "auto refresh" process list
215 - issue Fixed editing a failed query from the error message
216 - issue #16166 Fix the alter user privileges query to make it MySQL 8.0.11+ compatible
217 - issue Fix copy table to another database when the nbr of DBs is > $cfg['MaxDbList']
218 - issue #16157 Fix relations of tables having spaces or special chars not showing in the Designer
219 - issue #16052 Fix a very rare JS error occuring on mousemove event
220 - issue #16162 Make a foreign key link clickable in a new tab after the value was saved and replaced
221 - issue #16163 Fixed a PHP notice "Undefined index: column_info" on views
222 - issue #14478 Fix the data stream when exporting data in file mode
223 - issue #16184 Fix templates/ directory not found error
224 - issue #16184 Remove chdir logic to fix PHP fatal error "Uncaught TypeError: chdir()"
225 - issue Support for Twig 3
226 - issue Allow phpmyadmin/twig-i18n-extension ^3.0
227 - issue #16201 Trim spaces for integer values in table search
228 - issue #16076 Fixed cannot edit or export TIMESTAMP column with default CURRENT_TIMESTAMP in MySQL >= 8.0.13
229 - issue #16226 Fix error 500 after copying a table
230 - issue #16222 Fixed can't use the search page when the table name has special characters
231 - issue #16248 Fix zoom search is not performing input validation on INT columns
232 - issue #16248 Fix javascript error when typing in INT fields on zoom search page
233 - issue Fix type errors when using saved searches
234 - issue #16261 Fix missing headings on modals of "User Accounts -> Export"
235 - issue #16146 Fixed sorting did not keep the selector of number of rows
236 - issue #16194 Fixed SQL query does not appear in case of editing view where definer is not you on MySQL 8
237 - issue #16255 Fix tinyint(1) shown as INT on Search page
238 - issue #16256 Fix "Warning: error_reporting() has been disabled for security reasons" on php 7.x
239 - issue #15367 Fix "Change or reconfigure primary server" link
240 - issue #15367 Fix first replica links, start, stop, ignore links
241 - issue #16058 Add "PMA_single_signon_HMAC_secret" for signon auths to make special links work and udate examples
242 - issue #16269 Support ReCaptcha v2 checkbox width "$cfg['CaptchaMethod'] = 'checkbox';"
243 - issue #14644 Use Doctum instead of Sami
244 - issue #16086 Fix "Browse" headings shift when scrolling
245 - issue #15328 Fix no message after import of zipped shapefile without php-zip
246 - issue #14326 Fix PHP error when exporting without php-zip
247 - issue #16318 Fix Profiling doesn't sum the number of calls
248 - issue #16319 Fixed a Russian translation mistake on search results total text
249 - issue #15634 Only use session_set_cookie_params once on PHP >= 7.3.0 versions for single signon auth
250 - issue #14698 Fixed database named as 'New' (language variable) causes PHP fatal error
251 - issue #16355 Make textareas both sides resizable
252 - issue #16366 Fix column definition form not showing default value
253 - issue #16342 Fixed multi-table query (db_multi_table_query.php) alias show the same alias for all columns
254 - issue #15109 Fixed using ST_GeomFromText + GUI on insert throws an error
255 - issue #16325 Fixed editing Geometry data throws error on using the GUI
256 - issue [security] Fix XSS vulnerability with the transformation feature (PMASA-2020-5)
257 - issue [security] Fix SQL injection vulnerability with search feature (PMASA-2020-6)
260 - issue Fixed deprecation warning "implode(): Passing glue string after array is deprecated." function on export page
261 - issue #15767 Fixed can not copy user account since 5.0 - "error #1133"
262 - issue #15772 Fixed error code 500 during pagination of the tables in a database
263 - issue #16009 Fix php error "Trying to access array offset on value of type null" on column distinct values feature
264 - issue #15741 Fix fatal javascript error on clicking "Pick from Central Columns"
265 - issue #15773 Fixed a view named "views" adds an expand button
266 - issue #15432 Fixed names of the pages in the designer should be unique
267 - issue #14310 Fixed column selector "See more" removes "Preview SQL" and "Save" area
268 - issue Fixed wrong jQuery function call in table search page
269 - issue #15761 Fix uncaught TypeError when using "$cfg['ServerDefault'] = 0;"
270 - issue #15780 Fixed unexpected UI of action links (text only mode)
271 - issue #15674 Replace twig/extensions with phpmyadmin/twig-i18n-extension
272 - issue #15799 Change location of profiling state documentation to fix column ordering
273 - issue #15720 Fix designer adding all available tables to a designer page after adding a new relationship
274 - issue #15791 Replace facebook/webdriver by php-webdriver/webdriver
275 - issue #15802 Removed SET AUTOCOMMIT=0 from SQL export
276 - issue #15818 Fix table borders missing on theme original since 5.0.0
277 - issue #13864 Fix ENUM's radiobuttons reset on "Continue insertion with" changes
278 - issue #15811 Fixed browse foreign values doesn't show a modal with grid edit
279 - issue #15817 Fix "new table" layout issue on original theme
280 - issue #15798 Fixed not needed prompt before abandoning changes on SQL tab after only changing a checkbox
281 - issue #15833 Fix php TypeError when submitting unchanged data
282 - issue Fix php notice "Trying to access array offset on value of type bool" on Designer
283 - issue #13326 Added integer validations on search page
284 - issue #15200 Fixed server-side HTTPS detection misses support for Forwarded HTTP Extension (RFC 7239)
285 - issue #15831 Fixed DB names starting with "b" being cut off in <option>, User account page
286 - issue #15850 Fixed display content from "information_schema.PROCESSLIST"
287 - issue #15836 Fixed "has no type" error on export and import pages for "Chinese traditional" users
288 - issue #15863 Fixed designer move menu icon not changing directions and tables menu list resize button
289 - issue #15854 Fixed black borders for full screen mode on Designer
290 - issue #15899 Fix "Uncaught TypeError: mb_strtoupper()" on the relational view of a view
291 - issue Fixed some php uncaught errors and notices on user missing extension
292 - issue #15926 Fixed PhpMyAdmin\Core::getRealSize('8000M') returns a float instead of an int
293 - issue #15410 Fixed auto increment reset issue where the last value of AI was saved an could destroy the "good" value
294 - issue #15187 Fixed editing a row and using 'insert as new row' uses primary key 0 instead of NULL
295 - issue #15877 Fixed php error "preg_match() expects parameter 2 to be string, null given" on some specific tables
296 - issue #15795 Fix broken link on "MySQL said" error message
297 - issue #15781 Fix illegal string offset error on structure page of 'information_schema' database
298 - issue #15745 Fix version 5.0.1 suggests 4.9.4 as latest stable version
299 - issue #15958 Fix uncaught TypeError when sorting database tables by size or by rows
300 - issue #15830 Fix strftime issue on windows for Japanese users on "Structure" tab
301 - issue Windows testsuite fixes
302 - issue #15879 Added missing CSS class on "simulate query" button
303 - issue #15401 Fixed php notice "Undefined index HMAC_secret" for users upgrading phpMyAdmin without a log-out
304 - issue #15810 Fixed unexpected heading on add a new procedure, trigger, function, routine modals
305 - issue #15970 Removed wrong html a tag on "Replication status" header
306 - issue Add missing css classes on some buttons
307 - issue #15937 Make modals draggability/expand (down) work after a screen zoom change
308 - issue Fix php notice "Undefined index: on_delete" while creating a foreign key
309 - issue #15876 Fixed select "IN (...)" is a simple select instead of a multiple select
310 - issue Fix maxlength for User and Host on replication add user form
311 - issue #15282 Fixed MySQL 8.0 password syntax error when creating a replication user
312 - issue #15986 Fixed php fatal error "Uncaught TypeError: array_flip() expects parameter 1 to be array, null given"
313 - issue Fixed php fatal error "Uncaught TypeError: htmlspecialchars() expects parameter 1 to be string, int given"
314 - issue Support phpunit 9.0
315 - issue Fix error in NavigationTree where $key might be sent as an int instead of a str to urlencode
316 - issue #16022 Fix uncaught TypeError on browse foreigners
317 - issue Fix failure if relational display field value is NULL - "Display column for relationships"
318 - issue #16033 Remove vendor bin files from non source version of phpMyAdmin
319 - issue #15898 [security] Fix escape tbl_storage_engine argument used on tbl_create.php
320 - issue #15224 Don't fire keyboard shortcuts while SQL query area is focused (on a mobile for example)
321 - issue [security] Fix SQL injection with certain usernames (PMASA-2020-2)
322 - issue [security] Fix SQL injection in particular search situations (PMASA-2020-3)
323 - issue [security] Fix SQL injection and XSS flaw (PMASA-2020-4)
324 - issue Deprecate "options" for the external transformation; options must now be hard-coded along with the program name directly in the file.
327 - issue #15719 Fixed error 500 when browsing a table when $cfg['LimitChars'] used a string and not an int value
328 - issue #14936 Fixed display NULL on numeric fields has showing empty string since 5.0.0
329 - issue #15722 Fix get Database structure fails with PHP error on replicated server
330 - issue #15723 Fix can't browse certain tables since 5.0.0 update
331 - issue Prevent line wrap in DB structure size column
332 - issue Remove extra line break from downloaded blob content
333 - issue #15725 Fixed error 500 when exporting - set time limit when $cfg['ExecTimeLimit'] used a string and not an int value
334 - issue #15726 Fixed double delete icons on enum editor
335 - issue #15717 Fixed warning popup not dissapearing on table stucture when using actions without any column selection
336 - issue #15693 Fixed focus of active tab is lost by clicking refresh option on browse tab
337 - issue #15734 Fix Uncaught TypeError: http_build_query() in setup
338 - issue Fix double slash in path when $cfg['TempDir'] has a trailing slash
339 - issue #14875 Fix shp file import tests where failing when php dbase extension was enabled
340 - issue #14299 Fix JS error "PMA_makegrid is not defined" when clicking on a table from the "Insert" tab opened in a new tab
341 - issue #15351 Fixed 2FA setting removed each time the user edits another configuration setting
342 - issue [security] Fix SQL injection vulnerability on the user accounts page (PMASA-2020-1)
345 - issue #13896 Drop support for PHP 5.5, PHP 5.6, PHP 7.0 and HHVM
346 - issue #14007 Enable columns names by default for CSV exports
347 - issue #13919 Remove font size feature
348 - issue #12373 Add Metro theme
349 - issue #14155 Add move columns preview SQL button
350 - issue #14296 Enable strict mode in PHP files
351 - issue #13627 Increase field width for editing varchar fields
352 - issue #12603 Show warning for users with the default values for controluser and controlpass
353 - issue #14589 Fix rendering of column comments in Safari, improve display in all browsers
354 - issue #14330 New features for csv import plugin
355 - issue #14417 Automatically add index while editing an existing row and setting auto increment
356 - issue #13057 Add export option to drop user security definers from views
357 - issue #14404 Drop view and or replace added to exporting view
358 - issue #14594 Database "Search" selects all tables by default
359 - issue #12158 Auto expand the single database
360 - issue #13067 Inconsistency with submit buttons
361 - issue #14683 Improper message in Show Hidden Navigation Tree Items
362 - issue #14695 Remove unlabeled default collation from the bottom of the database list; this information is available elsewhere
363 - issue #14677 Security confirm() before running UPDATE statement without WHERE condition
364 - issue #13023 Show errors at the bottom of the page and add copy query button for errors in processing sql queries
365 - issue #14633 Use Sass instead of PHP to compile CSS
366 - issue #14765 Add initial support for Bootstrap 4
367 - issue #14829 Change table column comment field from input to textarea
368 - issue #14725 Console: ctrl+l clear line and ctrl+u clear console
369 - issue #14837 Use charset 'windows-1252' when format is MS Excel
370 - issue #15030 Move 'More settings' link from 'Appearance settings' to 'General settings'
371 - issue #15029 Remove the redundant 'i' help/tool tip in page settings "Query History Length" area
372 - issue #13424 Importing CSV now uses file name as the table name instead of 'TABLE #'
373 - issue #14926 Add an Edit link for each view in tables list
374 - issue #14890 Display column details in navigation bar
375 - issue #14977 Add title for group in navigation bar
376 - issue #14927 Show InnoDB table overhead (free space)
377 - issue #15072 Add 'Close' button to the Monitor Instructions modal
378 - issue #15174 Improved filter method in server variables page
379 - issue #15266 Add an external dependency injection system
380 - issue #15350 Change MIME type references to Media (MIME) type
381 - issue Fixed url.php crashing because it's not loading the DatabaseInterface service
382 - issue #15540 Fixed uncaught TypeError: htmlspecialchars() in NavigationTree
383 - issue Fix twig deprecation notices for php 8.0
384 - issue #15435 Fix ReCAPTCHA couldn't find user-provided function: Functions.recaptchaCallback
385 - issue #15623 Fix width of picker modal and remove date picker for int fields
386 - issue #14732 Fixed can't rename primary key with auto increment
387 - issue #15677 Fix show process-list triggers a php exception
388 - issue #15697 Fix uncaught php error: "Call to a member function get() on null" in db_export.php when exporting a table from the list
391 - issue #16397 Fix compatibility problems with older PHP versions (also issue #16399)
392 - issue #16396 Fix broken two-factor authentication
395 - issue [security] Fix XSS vulnerability with the transformation feature (PMASA-2020-5)
396 - issue [security] Fix SQL injection vulnerability with search feature (PMASA-2020-6)
399 - issue [security] Fix SQL injection with certain usernames (PMASA-2020-2)
400 - issue [security] Fix SQL injection in particular search situations (PMASA-2020-3)
401 - issue [security] Fix SQL injection and XSS flaw (PMASA-2020-4)
402 - issue Deprecate "options" for the external transformation; options must now be hard-coded along with the program name directly in the file.
405 - issue #15724 Fix 2FA was disabled by a bug
406 - issue [security] Fix SQL injection vulnerability on the user accounts page (PMASA-2020-1)
409 - issue #15570 Fix page contents go underneath of floating menubar in some cases
410 - issue #15591 Fix php notice 'Undefined index: foreign_keys_data' on relations view when the user has column access
411 - issue #15592 Fix php warning "error_reporting() has been disabled for security reasons"
412 - issue #15434 Fix middle click on table sort column name shows a blank page
413 - issue Fix php notice "Undefined index table_create_time" when setting displayed columns on results of a view
414 - issue #15571 Fix fatal error when trying to edit row with row checked and button under the table
415 - issue #15633 Fix designer set display field broken for php 5.x versions
416 - issue #15621 Support CloudFront-Forwarded-Proto header for Amazon CloudFront proxy
417 - issue Fix php 8.0 php notices - Undefined index on login page
418 - issue #15640 Fix php 7.4 error when trying to access array offset on value of type null on table browse
419 - issue #15641 Fix replication actions where broken (start slave, stop slave, reset, ...)
420 - issue #15608 Fix DisableIS is broken when with controluser configured (database list broken)
421 - issue #15614 Fix undefined offset on index page for MySQL 5.7.8 (server charset)
422 - issue #15692 Fix JavaScript error when user has not enough privilege to view query statistics.
423 - issue #14248 Fixed date selection in search menu missing higher Z-index value
424 - issue Fix Uncaught php TypeError on php 8.0 when adding a column to table create form
425 - issue #15682 Fix calendar not taking current time as default value
426 - issue #15636 Fix php error trying to access array offset on value o type null on replication GUI
427 - issue #15695 Fix input field for the time in datetime picker is disabled
430 - issue #14184 Change the cookie name from phpMyAdmin to phpMyAdmin_https for HTTPS, fixes many "Failed to set session cookie" errors
431 - issue #15304 Fix ssl_use php error
432 - issue #14804 Fix undefined index: ssl_* variables
433 - issue #14245 Fix mysql 8.0.3 and above fails on advisor
434 - issue #15499 Fix unparenthesized php deprecation
435 - issue #15482 Fix URL encoding plus sign (+) in the table or DB name when configuring foreign keys
436 - issue #14898 Fixed bottom table in list in left panel blocked by horizontal scroll bar
437 - issue #15161 Fix text area overflows its parent element on "Query" page
438 - issue #15511 Fixed exporting users after a delete will delete all selected users on "Users" page
439 - issue #14598 Fixed checking referencial integrity on "Operations" page
440 - issue #14433 Fix "You do not have privileges to manipulate with the users!" on root superadmin
441 - issue #15391 Fix GIS polygon of a geometry field is not drawn on "GIS visualization"
442 - issue #15311 Fix adjust privileges on copy database fails with MariaDB
443 - issue #15477 Fix display referential integrity check for InnoDB
444 - issue #15236 Support phpunit 8 in our test suite to help packaging phpMyAdmin on Debian
445 - issue #15522 Fix missing image error fills logs, removed ic_b_info icon from icon list
446 - issue #15537 Fixed some issues with the sort by key selectors
447 - issue #15546 Fix operators precedence in DatabaseInterface class
448 - issue #14906 Test test suite on 32-bit systems
449 - issue Fix Long2IP transformation issue with PHP 7.1
450 - issue #14951 Fix moving columns with DEFAULT NULL doesn't work on MariaDB 10.2+
451 - issue #14951 Fix moving columns with INT AND DEFAULT CURRENT_TIMESTAMP doesn't work on MariaDB
452 - issue #12241 Fixed table alias is removed when exporting a query
453 - issue #15316 Fixed cross join clause is removed on export
454 - issue #14809 Fix error "is_uploaded_file() expects parameter 1 to be string" when inserting blobs from files
455 - issue #15127 Fix white square when refreshing designer or browsing other pages
456 - issue #13912 Detect when phpMyAdmin storage tables are not accessible, help users browse corrupt DBs
457 - issue #15465 Display profiling when query outputs no rows
458 - issue Fix setting and removing display field on Designer
459 - issue Added a warning when trying to set a display field on Designer and configuration storage is not setup
460 - issue #15327 Fix shift-click in Export misses a checkbox
461 - issue [security] Fix improperly sanitized data when showing the Git branch (thanks to Ali Hubail for this report)
462 - issue [security] Fix security weaknesses in Designer feature,including a flaw where an attacker could trigger an SQL injection attack (PMASA-2019-5)
465 - issue #15313 Added support for Twig 2
466 - issue #15315 Fix cannot edit or export column with default CURRENT_TIMESTAMP in MySQL >= 8.0.13
467 - issue Fix a TypeError in Import class with PHP 8
468 - issue #14270 Fix Middle-click on foreign key link broken
469 - issue #14363 Fix broken relational links in tables
470 - issue #14987 Fix weird error for empty collation
471 - issue #15334 Fix export of GIS visualisation not working (PNG, PDF, SVG)
472 - issue #14918 Use hex for the phpMyAdmin session token
473 - issue Added GB18030 Chinese collations description
474 - issue Added Russian, Swedish, Slovak and Chinese UCA 9.0.0 collations description
475 - issue Added description for the _ks (kana-sensitive) collation suffix
476 - issue Added description for the _nopad (NO PAD) collation suffix
477 - issue #15404 Remove array/string curly braces access
478 - issue #15427 Fixed "FilterLanguages" option does not work (configuration)
479 - issue #15202 Fixed creating user with single quote in password results in no password user
480 - issue #14950 Fixed left database overview "add column" triggers error
481 - issue #15363 Fix remove unexpected quotes on text fields (structure and insert)
482 - issue Fix NULL wrongly checked on field change
483 - issue #15388 Fix allow to rollback an empty statement
484 - issue #14291 Fixed incorrect linkage from one table's value to another table
485 - issue #15446 Fix tables added from other databases are not collapsing in the designer section
486 - issue #14945 Fix designer page save fails if dB name contains period
487 - issue Display an error when trying to import in designer a table that's already imported
488 - issue Fix many bugs when adding new tables to designer
489 - issue Update CodeMirror to v5.48.4
490 - issue Update jQuery Migrate to v3.1.0
491 - issue Update jQuery Validation to v1.19.1
492 - issue Update jQuery to v3.4.1
493 - issue Update js-cookie to v2.2.1
494 - issue Remove fieldset closing tag when setting global privileges
495 - issue #15425 Fix backslash in column name resulting an error in editing
496 - issue #15380 Fix Status - Advisor error
497 - issue #15439 Fix designer page status not updated when added a new table from another database
498 - issue #15440 Fix page number is not being updated in the URL after saving a designer's page
499 - issue Fix reloading a designer's page
500 - issue Fix designer full screen mode button and text stuck when exiting full-screen mode
501 - issue Reduced possibility of causing heavy server traffic between the database and web servers
502 - issue Fix a situation where a server could be deleted while an administator is using the setup script
505 - issue #14478 phpMyAdmin no longer streams the export data
506 - issue #14514 Tables with SYSTEM VERSIONING show up as views instead of tables
507 - issue #14515 Values cannot be edited in SYSTEM VERSIONING tables with INVISIBLE timestamps
508 - issue Fix header icon on server plugins page
509 - issue #14298 Fixed error 500 on MultiTableQuery page when a empty query is passed
510 - issue #14402 Fixed fatal javascript error while adding index to a new column
511 - issue #14896 Fixed issue with plus/minus icon when refreshing an expanded database
512 - issue #14922 Fixed json encode error in export
513 - issue #13975 Fixed missing query time in German (fix decimal number format issue)
514 - issue #14503 Fixed JavaScript events not activating on input (sql bookmark issue)
515 - issue #14898 Fixed Bottom table is blocked in database list (left panel)
516 - issue #14425 Fixed Null Checkbox automatically unmarked
517 - issue #14870 Display correct date and time in Zip files
518 - issue #14763 Fixed the loading symbol not appearing when refreshing the navigation
519 - issue #14607 Count rows only if needed
520 - issue #14832 Show Designer combo boxes when adding a constraint
521 - issue #14948 Fix change password is not showing password strength difference at the second attempt
522 - issue #14868 Fix edit view
523 - issue #14943 Fixed loading Forever when creating new view without filling any field
524 - issue #14843 Fix Bookmark::get() id matching SQL
525 - issue #14734 Fixed invalid default value for bit field
526 - issue #14311 Fixed undefined index in setup script
527 - issue #14991 Fixed TypeError in GIS editor
528 - issue Fixed GIS data editor for multi server setup
529 - issue #14312 Fixed type error in setup script when adding new server
530 - issue #14053 Fix missed padding on query results
531 - issue #14826 Fixed javascript error PMA_messages is not defined
532 - issue Show error message if config-set fails and not "loading..." forever
533 - issue #14359 Prevent multiple error modals, and error-report request spamming from script
534 - issue Fixed error reporting javascript errors on multi server setup
535 - issue Fixed wrong property name on TableStructureController
536 - issue #14811 Fix SHOW FULL TABLES FROM when a table is locked
537 - issue #14916 Fix bug when creating or editing views
538 - issue #14931 Fixed php error when using a query like SELECT 1 INTO @a; SELECT @a; in inline query edit
539 - issue #15074 Make the server logo visible on theme "original"
540 - issue #15077 Fixed incorrect page numbers
541 - issue #14205 Fixed "No tables found in database" when you delete all tables from last page
542 - issue #14957 Virtuality is not selected when editing generated column (added virtuality(stored) option for mariadb)
543 - issue #14853 Insert page should not allow entering things into virtual columns
544 - issue #15110 Fixed TypeError e.preventDefaulut is not a function
545 - issue #15115 Improved label in Settings export, clarifying that it's a JSON file
546 - issue #14816 Fixed [designer] Cannot read property 'style' of null
547 - issue Fixed [designer] Add new tables with database/table list modal
548 - issue Fixed query format on multi server setup
549 - issue Fixed remove partitioning on multi server setup
550 - issue Fixed normalization
551 - issue Fixed 'RESET SLAVE' button on replication slave
552 - issue Fixed sending a php error report on multi server setup
553 - issue Fixed downloading of monitor parameters for IE 11, Edge, Chrome and others
554 - issue #15141 Fixed php notice Undefined index: designer_settings
555 - issue #12729 Fixed sticky table header over dropdown menu
556 - issue #15140 Fixed edit link does not work on failed insert
557 - issue #14334 Fixed export table structure shows rows fields
558 - issue #15010 Fixed empty SQL preview modal on tbl_relation
559 - issue #14673 Fixed innodb & MySQL 8: DYNAMIC & COMPRESSED ROW_FORMAT missing
560 - issue Fixed empty success message when adding a new INDEX from left panel
561 - issue #15150 Fixed generate password hidden on second open of change password modal
562 - issue Fixed import XML data with leading zeros
563 - issue #15036 Fixed missing input fields checks for MaxSizeForInputField
564 - issue #15119 Fixed uninterpreted HTML on Settings->Export page
565 - issue #15159 Fixed missing query time and database in console
566 - issue #13713 Fixed column comments in the floating table header
567 - issue #15177 Fixed label alignment on login page
568 - issue #15210 Fixed a typo in the english name of the Albanian language
569 - issue Fixed issue when resetting charset in import.php
570 - issue #14460 Fixed forms where submitted multiple times on CTRL + ENTER
571 - issue #15038 Fixed console height was allowing a negative values
572 - issue #15219 Fixed 'No Password' option does not switch automatically to 'Use Text Field' in add user account
573 - issue Fixed importing the exported config on Server status monitor page
574 - issue #15228 Fixed php notice 'Undefined index: foreign_keys_data' on designer when the user has column access
575 - issue #12900 Fixed designer page saving gives error when configuration storage is not set up
576 - issue #15229 Fixed php notice, added support for 'DELETE HISTORY' table privilege (MariaDB >= 10.3.4)
577 - issue #14527 Fixed import settings function not working
578 - issue #14908 Fixed uninterpreted HTML on Settings->Import (missing data error descriptions)
579 - issue #14800 Fixed status->Processes doesn't show full query process list page
580 - issue #14833 Fixed sort by Time not working in process list page
581 - issue #14982 Fixed setting "null" keep an "enum" value
582 - issue #14401 Fixed insert rows keypress Enter behavior
583 - issue #15146 Fixed error reports can not be sent because they are too large
584 - issue #15205 Fixed useless backquotes on sql preview modal when deleting an index
585 - issue #13178 Fixed issues with uppercase table and database names (lower_case_table_names=1)
586 - issue #14383 Fixed warning when browsing certain tables (GIS data)
587 - issue #12865 Fixed MySQL 8.0.0 issues with GIS display
588 - issue #15059 Fixed "Server charset" in "Database server" tab showing wrong information
589 - issue #14614 Fixed mysql error "#2014 - Commands out of sync; you can't run this command now" on sql query
590 - issue #15238 Fixed phpMyAdmin 4.8.5 doesn't show privileges of procedures (raw html displayed instead)
591 - issue #13726 Fixed can not copy user on Percona Server 5.7
592 - issue #15239 Fixed javascript error while fetching latest version info and switching pages
593 - issue #14301 Fixed javascript error when editing a JSON data type column
594 - issue #15240 Fixed apply a Settings form with errors shows a JSON response after using return back
595 - issue #15043 Fixed multiple errors printing on Settings page
596 - issue #15037 Fixed unexpected behavior of reset button on Settings
597 - issue #15157 Fixed 'Settings' tab not marked as active when browsing 2FA settings
598 - issue #14934 Fixed all fields readonly on Edit/Insert screens
599 - issue #14588 Fixed export of geometry objects, GIS objects are now exported as hex
600 - issue #14412 Better handling of errors with Signon authentication type
601 - issue Added support for AUTO_INCREMENT when using ROCKSDB, on Operations page
602 - issue #15276 Fixed partitioning is missing in Structure page UI (MySQL 8.0)
603 - issue #14252 Fixed DisableIS and database tree list (new database missing when refreshing the list)
604 - issue #14621 Removed "Propose table structure" on MySQL 8.0
605 - issue Fixed editing of virtual columns on PerconaDB
606 - issue #13854 Fixed column options are ignored for GENERATED/VIRTUAL/STORED columns
607 - issue #15262 Fixed incorrect display of charset column (raw html)
608 - issue Added explicit parentheses in nested ternary operators
609 - issue #15287 Fix auto_increment field is too small
610 - issue #15283 Fix tries to change collation on views when changing collation on all tables/fields
611 - issue Fixed empty PMA_gotoWhitelist JavaScript array
612 - issue #15079 Fixed responsive behaviour of instruction dialog box
613 - issue #10846 Fixed javascript error when renaming a table
614 - issue Updated sql-parser to version 4.3.2
615 - issue [security] SQL injection in Designer (PMASA-2019-3)
616 - issue [security] CSRF attack on 'cookie' login form (PMASA-2019-4)
619 - issue Developer debug data was saved to the PHP error log
620 - issue #14217 Fix issue when adding user on MySQL 8.0.11
621 - issue #13788 Exporting a view structure based on another view with a sub-query throws no database selected error
622 - issue #14635 Fix PHP error in GitRevision, error in processing request, error code 200
623 - issue #14787 Cannot execute stored procedure
624 - issue Add Burmese language
625 - issue #14794 Not responding to click, frozen interface, plugin Text_Plain_Sql error
626 - issue #14786 Table level Operations functions missing
627 - issue #14791 PHP warning, db_export.php#L91 urldecode()
628 - issue #14775 Export to SQL format not available for tables
629 - issue #14782 Error message shown instead of two-factor QR code when adding 2fa to a user
630 - issue [security] Arbitrary file read/delete relating to MySQL LOAD DATA LOCAL INFILE and an evil server instance (PMASA-2019-1)
631 - issue [security] SQL injection in Designer (PMASA-2019-2)
633 --- Older ChangeLogs can be found on our project website ---
634 https://www.phpmyadmin.net/old-stuff/ChangeLogs/
636 # vim: et ts=4 sw=4 sts=4
637 # vim: ft=changelog fenc=utf-8
638 # vim: fde=getline(v\:lnum-1)=~'^\\s*$'&&getline(v\:lnum)=~'\\S'?'>1'\:1&&v\:lnum>4&&getline(v\:lnum)!~'^#'
639 # vim: fdn=1 fdm=expr