phpMyAdmin

phpMyAdmin - ChangeLog ====================== 5.1.3 (2022-02-10) - issue #17308 Fix broken pagination links in the navigation sidebar - issue #17331 Fix MariaDB has no support for system variable "disabled_storage_engines" - issue #17315 Fix unsupported operand types in Results.php when running "SHOW PROCESSLIST" SQL query - issue #17288 Fixed importing browser settings question box after login when having no pmadb - issue #17288 Fix "First day of calendar" user override has no effect - issue #17239 Fixed repeating headers are not working - issue #17298 Fixed import of email-adresses or links from ODS results in empty contents - issue #17344 Fixed a type error on ODS import with non string values - issue #17239 Fixed header row show/hide columns buttons on each line after hover are shown on each row - issue [security] Fix for path disclosure under certain server configurations (if display_errors is on, for instance)

phpMyAdmin - ChangeLog ====================== 5.1.2 (2022-01-20) - issue Replaced MySQL documentation redirected links - issue #16960 Fix JS error on Designer visual builder on some modal buttons - issue Re-build openlayers JS dependency from the source files and provide a smaller JS bundle - issue Fixed imports and theme detection depending on the current working dir - issue Update JavaScript dependencies - issue #16935 Remove hardcoded row length for "$cfg['CharTextareaRows']" to allow back values < 7 - issue #16977 Fix encoding of enum and set values on edit value - issue Fix set value as selected when it has special chars on edit value enum - issue #16896 Fix distinct URLs broken on nullable text fields - issue Fixed two possible PHP errors using INT data - issue Fixed possible warning "Undefined index: output_format" on export - issue Fixed warning "Undefined index: ods_recognize_percentages" on Import ODS - issue Fixed warning "Undefined array key "ods_recognize_currency" on Import ODS - issue #16982 Fixed "Notice: Undefined index: foreign_keys_data" on Designer remove relation - issue Backquote phpMyAdmin table name on internal relation delete query for Designer - issue #16982 Do not try to delete internal relations if they are not configured - issue #16982 Show success messages on Designer for add and remove relation operations - issue Fixed possible "Undefined index: clause_is_unique" on replace value in cell - issue #16991 Fixed case where $_SERVER['REQUEST_METHOD'] is undefined - issue Fixed configuration error handler registration - issue #16997 Fixed server variables get/set value not working on multi server server > 1 - issue #16998 Fixed Multi table query submit on server > 1 logged out user - issue #17000 Fixed Multi edit on central columns on server > 1 logged out user - issue #17001 Fix PHP error on query submit without a table name on multi table query box - issue #16999 Fixed multi table query results shows for 1 sec and then page refreshes - issue Fixed a non translated button text on central columns add - issue Fixed table width on Query by example page for large screens - issue #16975 Fixed NULL default had a value on insert with datatime fields - issue #16994 Fixed missing privilege escaping when assigning multiple databases with '_' to an user - issue #16864 Fixed the margin on the last database of the tree on all themes when scrollbars are displayed - issue #17011 Fixed the database tree line that was not continuous on database groups - issue Build more syntax correct URLs on JS internal redirects - issue #16976 Fix wrong link when a table is moved from a database to another - issue #16985 Fix case-sensitive issue of innodb_file_format=barracuda vs innodb_file_format=Barracuda - issue Fixed duplicate quote in navigation nodes - issue #17006 Disable the URL limit for the MariaDB analyser feature - issue Fix calls to fetchRow using two parameters but the function has only one parameter - issue #17020 Fixed "Notice Undefined index: sql_query" on Insert page - issue Fix reported "Undefined index: FirstDayOfCalendar" - issue Fix reported "Undefined index: environment" - issue Fix "TypeError: strlen() expects parameter 1 to be string, null given" on databases listing - issue #16973 Fix "Undefined array key "n0_pos2_name"" on databases listing - issue Use the correct min MySQL version for axis-order (8.0.1) instead of (8.0.11) - issue Use the queries we asked the user confirmation for on DELETE and TRUNCATE table actions - issue #16994 Fixed editing specific privileges for a database covered by a wildcard privilege - issue #16994 Fixed escaping of the database name for databases containing '_' on users edit - issue #16994 Only escape once on grant/revoke privileges for databases containing '_' or '%' - issue #16994 Only show databases without a privilege on multi select for user grant databases - issue Removed un-expected query success message from the Table export page - issue #17026 Handle possible invalid boolean values injected in SaveDir or UploadDir causing "TypeError: mb_substr()" - issue #16981 Enable cookie parameter "SameSite" on "phpMyAdmin" cookie for PHP >= 7.3 - issue #16966 Encode "#" to have the anchor part of the destination URL on SQL highlight terms URLs - issue #17004 Fix PHP errors due to removed variable "innodb_file_format" on MariaDB >= 10.6.0 and MySQL >= 8.0.0 - issue #16842 Fixed missing password modes on PerconaDB - issue #16947 Fix "Change login information" form not working - issue #17004 Fix Advisor for MariaDB >= 10.5 because of removed "innodb_log_files_in_group" variable - issue #17037 Fix change structure does not surface errors - issue #17016 Fixed online Transaction, errors not reported on structure edit - issue #17042 Fix SQL escaping bug on DB name with special chars on submit query with rollback option - issue #17027 Better handle the display of sorted binary columns in results summary - issue #16398 Quote non numeric values on parameterized queries - issue Fixed duplicate HTML escaping on foreign keys select value modal - issue #15370 Fixed edit routine UI incorrectly removes too many escape slashes - issue #14631 Fix enum with comma produces incorrect search dropdown on search pages - issue Fix gis visualization position and limit parameters have no effect - issue #16995 Fix edit binary foreign key adds a 1 to the value on the selected value - issue #13614 Fixed escaping the database names when granting privileges on tables - issue #11834 Fixed adding a new user on "privileges" tab of a table with a database name using a "_" character - issue #17033 Fixed scaling of line width and point size in GIS visualization - issue #17054 Removed "DEL" character from generated random strings for Blowfish secret auto-generated by setup - issue #17019 Fixed "Browse" button visible when creating a table from the database structure view - issue #16804 Fixed numbers were left-aligned rather than right-aligned - issue Fixed Metro theme text color for buttons in the browse table navigation bar - issue #14796 Fix export Database page, UI prevents from exporting procedures only - issue #15225 Fix Command+click on macOS opens links in same tab - issue #17014 Fix column names in first row when importing from CSV where the first line contains column names - issue Fix prevent scrolling the page when scrolling in GIS visualization - issue Fix GIS visualization save file with a different label or column - issue Fixed GIS saving image as png with a label - issue Fixed if label is just the number zero, it was treated as no label in the OpenLayers map - issue #17039 Fix unable to have 2FA working with a "pmadb" config value != phpmyadmin - issue #17079 Fixed missing spatial functions in Insert/Edit page - issue Fixed broken docs link after a FK data type mismatch error - issue Fix don't add multiple OpenLayers maps, remove listeners on dispose on GIS visualization - issue #14502 Uncheck the "ignore" checkbox when the user chooses a value in the foreign key list on Insert page - issue #14502 Uncheck the "ignore" checkbox when the user saves the GIS value on Insert page - issue #17018 Fixed cannot save data from GIS editor for spatial column on Insert page - issue #17084 Fixed ErrorHandler not showing errors when phpMyAdmin session does not work at all - issue #17062 Fixed pagination issues when working with identically named tables in separate databases - issue #17046 Fix "Uncaught TypeError: htmlspecialchars() expects parameter 1 to be string, null given" - issue #16942 Fix table Import with CSV using LOAD DATA LOCAL causes error "LOAD DATA LOCAL INFILE is forbidden" - issue #16942 Fix auto-detection for "LOAD DATA LOCAL INFILE" LOCAL option - issue #16067 Make select elements with multiple items resizable - issue Fix the display of Indexes that use Expressions and not column names - issue Allow to create the phpMyAdmin storage database using a different name than "phpmyadmin" using the interface - issue #17092 Document that "$cfg['Servers'][$i]['designer_coords']" was removed in version 4.3.0 - issue #16906 Support special table names for pmadb storage table names - issue #16906 Fix a caching effect on the feature list after creating the tables - issue #16906 Better report errors when creating the pmadb or its tables - issue #16906 Create the pmadb tables using the names configured and not the default names - issue #16906 Create the phpMyAdmin storage database using the configured "['pmadb']" name and not always "phpmyadmin" - issue #16906 Prevent incorrect overriding of configured values after a pmadb fix - issue #16906 Use the control connection to create the storage database and tables and not the user connection - issue #16693 Fix can't see SQL after adding a new column - issue #12753 Show table structure after adding a new column - issue Fix a PHP notice when logging out - issue #17090 Fix bbcode not rendered for error messages on setup - issue #17198 Fix the database selection when the navigation tree is disabled - issue #17228 Fixed copy to clipboard with NULL values gives non usable text - issue #16746 Replace samyoul/u2f-php-server by code-lts/u2f-php-server - issue #16005 Performance improvement on the Import and Export pages - issue #17247 Fix triple HTML encoding - issue #17259 Fix broken link in the Simulate DML query modal - issue #16746 Update tcpdf dependency to ^6.4.4 for PHP 8.1 compatibility - issue #16746 Update twig dependency to "^2.14.9 || ^3.3.5" for PHP 8.1 compatibility - issue [security] Add configuration directive $cfg['Servers'][$i]['hide_connection_errors'] to allow hiding host names and other error details when login fails - issue [security] Add configuration directive $cfg['URLQueryEncryption'] to allow encrypting senstive information in the URL - issue [security] Fix a scenario where an authenticated user can disable two factor authentication (PMASA-2022-1) - issue [security] Fix XSS and HTML injection attacks in the graphical setup page (PMASA-2022-2)

phpMyAdmin - ChangeLog ====================== 5.1.0 (2021-02-24) - issue #15350 Change Media (MIME) type references to Media type - issue #15377 Add a request router - issue Automatically focus input in the two-factor authentication window - issue #15509 Replace gender-specific pronouns with gender-neutral pronouns - issue #15491 Improve complexity of generated passwords - issue #14909 Add a configuration option to define the 1st day of week - issue #12726 Made user names clickable in user accounts overview - issue #15729 Improve virtuality dropdown for MariaDB > 10.1 - issue #15312 Added an option to perform ALTER ONLINE (ALGORITHM=INPLACE) when editing a table structure - issue Added missing 'IF EXISTS' to 'DROP EVENT' when exporting databases - issue #15232 Improve the padding in query result tool links - issue #15064 Support exporting raw SQL queries - issue #15555 Added ip2long transformation - issue #15194 Fixed horizontal scroll on structure edit page - issue #14820 Move table hide buttons in navigation to avoid hiding a table by mistake - issue #14947 Use correct MySQL version if the version is 8.0 or above for documentation links - issue #15790 Use "MariaDB Documentation" instead of "MySQL Documentation" on a MariaDB server - issue #15880 Change "Show Query" link to a button - issue #13371 Automatically toggle the radio button to "Create a page and save it" on Designer - issue #12969 Tap and hold will not dismiss the error box anymore, you can now copy the error - issue #15582 Don't disable "Empty" table button after clicking it - issue #15662 Stay on the structure page after editing/adding/dropping indexes - issue #15663 show structure after adding a column - issue #16005 Remove symfony/yaml dependency - issue #16005 Improve performance of dependency injection system by removing yaml parsing - issue #15447 Disable phpMyAdmin storage database checkbox on databases list - issue #16001 Add autocomplete attributes on login form - issue #13519 Add "Preview SQL" option on Index dialog box when creating a new table - issue #15954 Fixed export maximal length of created query input is too small - issue Redesign the server status advisor page - issue #13124 Use same height for SQL query textarea and Columns select in SQL page - issue #16005 Add a new vendor constant "CACHE_DIR" that defaults to "libraries/cache/" and store routing cache into this folder - issue #16005 Warm-up the routing cache before building the release - issue #16005 Use --optimize-autoloader when installing composer vendors before building the release - issue #15992 Add back the table name to the printable version on "Structure" page - issue #14815 Allow simplifying exported view syntax to only "CREATE VIEW" - issue #15496 Add $cfg['CaptchaSiteVerifyURL'] for Google ReCaptcha siteVerifyUrl - issue #14772 Add the password_hash PHP function as an option when inserting data - issue #15136 Add a notice for Hex converter giving invalid results - issue #16139 Use a textarea for JSON columns - issue #16223 Make JSON input transformation editor less narrow - issue #14340 Add a button on Export Page to show the SQL Query - issue #16304 Add support for INET6 column type - issue #16337 Fix example insert/update query default values - issue #12961 Remove indexes from table relation - issue #13557 Use a full list of functions instead of a separated one on insert/edit page "Function" selector - issue #14795 Include routines in the export in a predictable order - issue #16227 Fixed autocomplete is not working in case the table name is quoted by "`" symbols - issue #15463 Force BINARY comparison when looking at privileges to avoid an SQL error on privileges tab - issue #16430 Fixed Windows error message uses trailing / instead of \ - issue #16316 Added support for "SameSite=Strict" on cookies using configuration "$cfg['CookieSameSite']" - issue #16451 Fixed AWS RDS IAM authentication doesn't work because pma_password is truncated - issue #16451 Show an error message when the security limit is reached instead of silently trimming the password to avoid confusion - issue #15001 Add back Login Cookie Validity setting to the features form - issue #16457 Add config parameters to support third-party ReCaptcha v2 compatible APIs like hCaptcha - issue #13077 Moved tools section to left on large devices (Bootstrap xl) - issue #15711 Moved some buttons to left on large devices (Bootstrap xl) - issue #15584 Add $cfg['MysqlSslWarningSafeHosts'] to set the red text black when ssl is not used on a private network - issue #15652 Replace deprecated FOUND_ROWS() function call on "distinct values" feature - issue Export blobs as hex on JSON export - issue #16095 Fix leading space not shown in a CHAR column when browsing a table - issue Make procedures/functions SQL editor both side scrollable - issue #16407 Bump pragmarx/google2fa conflict to >8.0 - issue #14953 Added a rename Button to use RENAME INDEX syntax of MySQL 5.7 (and MariaDB >= 10.5.2) - issue #16477 Fixed no Option to enter TABLE specific permissions when the database name contains an "_" (underscore) - issue #16498 Fixed empty text not appearing after deleting all Routines - issue #16467 Fixed a PHP notice "Trying to access array offset on value of type null" on Designer PDF export - issue #15658 Fixed saving UI displayed columns on a non database request fails - issue #16495 Fix drop tables checkbox is above the checkbox for foreign keys - issue #16485 Fix visual query builder missing "Build Query" button - issue #16565 Added 'IF EXISTS' to 'DROP EVENT' when updating events to avoid replication issues - issue Removed metro fonts that where Apache-2.0 files that are incompatible with GPL-2.0 - issue #16464 Made the relation view default to the current database when creating relations - issue #16463 Fixed 'REFERENCES' privilege checkbox's title on new MySQL versions and on MariaDB - issue #16405 Added jest as a Unit Testing tool for our javascript code - issue #16252 Fixed the too small font size when editing rows (textareas) - issue #16585 Fixed BLOB to JPG transformation PHP errors - issue Made the console setup async to avoid blocking the page render - issue #16429 Use PHP 8.0 fixed version (commit) for TCPDF - issue #16005 Major performance improvements on browsing a lot of rows - issue #16595 Fixed editing columns having a `_` in their name in specific conditions - issue #16608 Fix "Sort by key" restore auto saved value - issue #16611 Fixed unable to add tables to rename aliases twice on Export - issue #16621 Fixed link HTML messed up in Advisor - issue #16622 Fixed Advisor formatting incorrect for long_query_time notice - issue #15389 Fixed reset current page indicator after deleting all rows to current page and not page 1 - issue #15997 Fixed auto save query - issue #15997 Made auto saved query database or database+table independent - issue #16641 Fixed query generation that was allowing JSON to have a length - issue #15994 Fixed the selected value detection for "on update current_timestamp" - issue #16614 Fixed PHP 8.0 dataseek offset call to the MySQLI extension - issue #16662 Fixed Uncaught TypeError on "delete" button click of a database search results page - issue Fixed Undefined index: selected_usr when the user tried to delete no selected user - issue #16657 Fixed the QBE interface when the configuration storage is not enabled - issue #16479 Fix our Selenium test-suite - issue #16669 Fixed table search modal for BETWEEN - issue #16667 Fixed LIKE and TINYINT in search not working properly - issue #16424 Fixed numerical search in table and zoom - issue Improve the version handling (new Version class) and add a VERSION_SUFFIX for vendors - issue #14494 Fix uncaught TypeError when editing partitioning - issue #16525 Fix PHP 8.0 failing tests when comparing 0 to '' - issue #16429 Fixed PHP 8.0 errors on preg_replace and operand types - issue #16490 Fixed PHP 8.0 function libxml_disable_entity_loader() is deprecated - issue #16429 Fixed failing unit tests on PHP 8.0 - issue #16609 Fixed Sql.rearrangeStickyColumns is not a function

phpMyAdmin - ChangeLog ====================== 5.0.4 (2020-10-15) - issue #16245 Fix failed Zoom search clears existing values - issue Fixed a PHP error when reporting a particular JS error - issue #16326 Fixed latitude and longitude swap for geometries in edit mode - issue #16032 Fix CREATE TABLE not being tracked when auto tracking is enabled - issue #16397 Fix compatibility problems with older PHP versions (also issue #16399) - issue #16396 Fix broken two-factor authentication

phpMyAdmin - ChangeLog ====================== 5.0.3 (2020-10-09) - issue #15983 Require twig ^2.9 - issue Fix option to import files locally appearing as not available - issue #16048 Fix to allow NULL as a default bit value - issue #16062 Fix "htmlspecialchars() expects parameter 1 to be string, null given" on Export xml - issue #16078 Fix no charts in monitor when using a decimal separator "," - issue #16041 Fix IN(...) clause doesn't permit multiple values on "Search" page - issue #14411 Support double tap to edit on mobile - issue #16043 Fix php error "Use of undefined constant MYSQLI_TYPE_JSON" when using the mysqlnd extension - issue #14611 Fix fatal JS error on index creation after using Enter key to submit the form - issue #16012 Set "axis-order" to swap lon and lat on MySQL >= 8.1 - issue #16104 Fixed overwriting a bookmarked query causes a PHP fatal error - issue Fix typo in a condition in the Sql class - issue #15996 Fix local setup doc links pointing to a wrong location - issue #16093 Fix error importing utf-8 with bom sql file - issue #16089 2FA UX enhancement: autofocus 2FA input - issue #16127 Fix table column description PHP error when ['DisableIS'] = true; - issue #16130 Fix local documentation links display when a PHP extension is missing - issue Fix some twig code deprecations for php 8 - issue Fix ENUM and SET display when editing procedures and functions - issue Keep full query state on "auto refresh" process list - issue Keep columns order on "auto refresh" process list - issue Fixed editing a failed query from the error message - issue #16166 Fix the alter user privileges query to make it MySQL 8.0.11+ compatible - issue Fix copy table to another database when the nbr of DBs is > $cfg['MaxDbList'] - issue #16157 Fix relations of tables having spaces or special chars not showing in the Designer - issue #16052 Fix a very rare JS error occuring on mousemove event - issue #16162 Make a foreign key link clickable in a new tab after the value was saved and replaced - issue #16163 Fixed a PHP notice "Undefined index: column_info" on views - issue #14478 Fix the data stream when exporting data in file mode - issue #16184 Fix templates/ directory not found error - issue #16184 Remove chdir logic to fix PHP fatal error "Uncaught TypeError: chdir()" - issue Support for Twig 3 - issue Allow phpmyadmin/twig-i18n-extension ^3.0 - issue #16201 Trim spaces for integer values in table search - issue #16076 Fixed cannot edit or export TIMESTAMP column with default CURRENT_TIMESTAMP in MySQL >= 8.0.13 - issue #16226 Fix error 500 after copying a table - issue #16222 Fixed can't use the search page when the table name has special characters - issue #16248 Fix zoom search is not performing input validation on INT columns - issue #16248 Fix javascript error when typing in INT fields on zoom search page - issue Fix type errors when using saved searches - issue #16261 Fix missing headings on modals of "User Accounts -> Export" - issue #16146 Fixed sorting did not keep the selector of number of rows - issue #16194 Fixed SQL query does not appear in case of editing view where definer is not you on MySQL 8 - issue #16255 Fix tinyint(1) shown as INT on Search page - issue #16256 Fix "Warning: error_reporting() has been disabled for security reasons" on php 7.x - issue #15367 Fix "Change or reconfigure primary server" link - issue #15367 Fix first replica links, start, stop, ignore links - issue #16058 Add "PMA_single_signon_HMAC_secret" for signon auths to make special links work and udate examples - issue #16269 Support ReCaptcha v2 checkbox width "$cfg['CaptchaMethod'] = 'checkbox';" - issue #14644 Use Doctum instead of Sami - issue #16086 Fix "Browse" headings shift when scrolling - issue #15328 Fix no message after import of zipped shapefile without php-zip - issue #14326 Fix PHP error when exporting without php-zip - issue #16318 Fix Profiling doesn't sum the number of calls - issue #16319 Fixed a Russian translation mistake on search results total text - issue #15634 Only use session_set_cookie_params once on PHP >= 7.3.0 versions for single signon auth - issue #14698 Fixed database named as 'New' (language variable) causes PHP fatal error - issue #16355 Make textareas both sides resizable - issue #16366 Fix column definition form not showing default value - issue #16342 Fixed multi-table query (db_multi_table_query.php) alias show the same alias for all columns - issue #15109 Fixed using ST_GeomFromText + GUI on insert throws an error - issue #16325 Fixed editing Geometry data throws error on using the GUI - issue [security] Fix XSS vulnerability with the transformation feature (PMASA-2020-5) - issue [security] Fix SQL injection vulnerability with search feature (PMASA-2020-6)

phpMyAdmin - ChangeLog ====================== 5.0.1 (2020-01-07) - issue #15719 Fixed error 500 when browsing a table when $cfg['LimitChars'] used a string and not an int value - issue #14936 Fixed display NULL on numeric fields has showing empty string since 5.0.0 - issue #15722 Fix get Database structure fails with PHP error on replicated server - issue #15723 Fix can't browse certain tables since 5.0.0 update - issue Prevent line wrap in DB structure size column - issue Remove extra line break from downloaded blob content - issue #15725 Fixed error 500 when exporting - set time limit when $cfg['ExecTimeLimit'] used a string and not an int value - issue #15726 Fixed double delete icons on enum editor - issue #15717 Fixed warning popup not dissapearing on table stucture when using actions without any column selection - issue #15693 Fixed focus of active tab is lost by clicking refresh option on browse tab - issue #15734 Fix Uncaught TypeError: http_build_query() in setup - issue Fix double slash in path when $cfg['TempDir'] has a trailing slash - issue #14875 Fix shp file import tests where failing when php dbase extension was enabled - issue #14299 Fix JS error "PMA_makegrid is not defined" when clicking on a table from the "Insert" tab opened in a new tab - issue #15351 Fixed 2FA setting removed each time the user edits another configuration setting - issue [security] Fix SQL injection vulnerability on the user accounts page (PMASA-2020-1)

Welcome to phpMyAdmin 4.9.3, a routine bugfix release. This is planned as the final bugfix release of phpMyAdmin version 4. Version 4 works with PHP versions 5.5 through (at least) 7.4, and MySQL versions 5.5 and newer (and the corresponding MariaDB versions). Version 5 will require PHP 7.1 or newer, but we plan to maintain security fixes for version 4 as part of our LTS program. For end of life details and supported versions, please see the "Supported versions" grid at . This release includes fixes for many bugs, including: * Several PHP notices and warnings including "Undefined index table_create_time," a notice about error_reporting() being disabled for security reasons, and several Undefined Index errors. * Support CloudFront-Forwarded-Proto header for Amazon CloudFront proxy * Early compatibility with development versions of PHP 8 * Fix replication actions (start, stop, etc) There are many, many more bug fixes thanks to the efforts of our developers and other contributors. For full details, you can see the ChangeLog file included with this release. The phpMyAdmin team

4.9.0.1 (2019-06-04) - issue #14478 phpMyAdmin no longer streams the export data - issue #14514 Tables with SYSTEM VERSIONING show up as views instead of tables - issue #14515 Values cannot be edited in SYSTEM VERSIONING tables with INVISIBLE timestamps - issue Fix header icon on server plugins page - issue #14298 Fixed error 500 on MultiTableQuery page when a empty query is passed - issue #14402 Fixed fatal javascript error while adding index to a new column - issue #14896 Fixed issue with plus/minus icon when refreshing an expanded database - issue #14922 Fixed json encode error in export - issue #13975 Fixed missing query time in German (fix decimal number format issue) - issue #14503 Fixed JavaScript events not activating on input (sql bookmark issue) - issue #14898 Fixed Bottom table is blocked in database list (left panel) - issue #14425 Fixed Null Checkbox automatically unmarked - issue #14870 Display correct date and time in Zip files - issue #14763 Fixed the loading symbol not appearing when refreshing the navigation - issue #14607 Count rows only if needed - issue #14832 Show Designer combo boxes when adding a constraint - issue #14948 Fix change password is not showing password strength difference at the second attempt - issue #14868 Fix edit view - issue #14943 Fixed loading Forever when creating new view without filling any field - issue #14843 Fix Bookmark::get() id matching SQL - issue #14734 Fixed invalid default value for bit field - issue #14311 Fixed undefined index in setup script - issue #14991 Fixed TypeError in GIS editor - issue Fixed GIS data editor for multi server setup - issue #14312 Fixed type error in setup script when adding new server - issue #14053 Fix missed padding on query results - issue #14826 Fixed javascript error PMA_messages is not defined - issue Show error message if config-set fails and not "loading..." forever - issue #14359 Prevent multiple error modals, and error-report request spamming from script - issue Fixed error reporting javascript errors on multi server setup - issue Fixed wrong property name on TableStructureController - issue #14811 Fix SHOW FULL TABLES FROM when a table is locked - issue #14916 Fix bug when creating or editing views - issue #14931 Fixed php error when using a query like SELECT 1 INTO @a; SELECT @a; in inline query edit - issue #15074 Make the server logo visible on theme "original" - issue #15077 Fixed incorrect page numbers - issue #14205 Fixed "No tables found in database" when you delete all tables from last page - issue #14957 Virtuality is not selected when editing generated column (added virtuality(stored) option for mariadb) - issue #14853 Insert page should not allow entering things into virtual columns - issue #15110 Fixed TypeError e.preventDefaulut is not a function - issue #15115 Improved label in Settings export, clarifying that it's a JSON file - issue #14816 Fixed [designer] Cannot read property 'style' of null - issue Fixed [designer] Add new tables with database/table list modal - issue Fixed query format on multi server setup - issue Fixed remove partitioning on multi server setup - issue Fixed normalization - issue Fixed 'RESET SLAVE' button on replication slave - issue Fixed sending a php error report on multi server setup - issue Fixed downloading of monitor parameters for IE 11, Edge, Chrome and others - issue #15141 Fixed php notice Undefined index: designer_settings - issue #12729 Fixed sticky table header over dropdown menu - issue #15140 Fixed edit link does not work on failed insert - issue #14334 Fixed export table structure shows rows fields - issue #15010 Fixed empty SQL preview modal on tbl_relation - issue #14673 Fixed innodb & MySQL 8: DYNAMIC & COMPRESSED ROW_FORMAT missing - issue Fixed empty success message when adding a new INDEX from left panel - issue #15150 Fixed generate password hidden on second open of change password modal - issue Fixed import XML data with leading zeros - issue #15036 Fixed missing input fields checks for MaxSizeForInputField - issue #15119 Fixed uninterpreted HTML on Settings->Export page - issue #15159 Fixed missing query time and database in console - issue #13713 Fixed column comments in the floating table header - issue #15177 Fixed label alignment on login page - issue #15210 Fixed a typo in the english name of the Albanian language - issue Fixed issue when resetting charset in import.php - issue #14460 Fixed forms where submitted multiple times on CTRL + ENTER - issue #15038 Fixed console height was allowing a negative values - issue #15219 Fixed 'No Password' option does not switch automatically to 'Use Text Field' in add user account - issue Fixed importing the exported config on Server status monitor page - issue #15228 Fixed php notice 'Undefined index: foreign_keys_data' on designer when the user has column access - issue #12900 Fixed designer page saving gives error when configuration storage is not set up - issue #15229 Fixed php notice, added support for 'DELETE HISTORY' table privilege (MariaDB >= 10.3.4) - issue #14527 Fixed import settings function not working - issue #14908 Fixed uninterpreted HTML on Settings->Import (missing data error descriptions) - issue #14800 Fixed status->Processes doesn't show full query process list page - issue #14833 Fixed sort by Time not working in process list page - issue #14982 Fixed setting "null" keep an "enum" value - issue #14401 Fixed insert rows keypress Enter behavior - issue #15146 Fixed error reports can not be sent because they are too large - issue #15205 Fixed useless backquotes on sql preview modal when deleting an index - issue #13178 Fixed issues with uppercase table and database names (lower_case_table_names=1) - issue #14383 Fixed warning when browsing certain tables (GIS data) - issue #12865 Fixed MySQL 8.0.0 issues with GIS display - issue #15059 Fixed "Server charset" in "Database server" tab showing wrong information - issue #14614 Fixed mysql error "#2014 - Commands out of sync; you can't run this command now" on sql query - issue #15238 Fixed phpMyAdmin 4.8.5 doesn't show privileges of procedures (raw html displayed instead) - issue #13726 Fixed can not copy user on Percona Server 5.7 - issue #15239 Fixed javascript error while fetching latest version info and switching pages - issue #14301 Fixed javascript error when editing a JSON data type column - issue #15240 Fixed apply a Settings form with errors shows a JSON response after using return back - issue #15043 Fixed multiple errors printing on Settings page - issue #15037 Fixed unexpected behavior of reset button on Settings - issue #15157 Fixed 'Settings' tab not marked as active when browsing 2FA settings - issue #14934 Fixed all fields readonly on Edit/Insert screens - issue #14588 Fixed export of geometry objects, GIS objects are now exported as hex - issue #14412 Better handling of errors with Signon authentication type - issue Added support for AUTO_INCREMENT when using ROCKSDB, on Operations page - issue #15276 Fixed partitioning is missing in Structure page UI (MySQL 8.0) - issue #14252 Fixed DisableIS and database tree list (new database missing when refreshing the list) - issue #14621 Removed "Propose table structure" on MySQL 8.0 - issue Fixed editing of virtual columns on PerconaDB - issue #13854 Fixed column options are ignored for GENERATED/VIRTUAL/STORED columns - issue #15262 Fixed incorrect display of charset column (raw html) - issue Added explicit parentheses in nested ternary operators - issue #15287 Fix auto_increment field is too small - issue #15283 Fix tries to change collation on views when changing collation on all tables/fields - issue Fixed empty PMA_gotoWhitelist JavaScript array - issue #15079 Fixed responsive behaviour of instruction dialog box - issue #10846 Fixed javascript error when renaming a table - issue Updated sql-parser to version 4.3.2 - issue [security] SQL injection in Designer (PMASA-2019-3) - issue [security] CSRF attack on 'cookie' login form (PMASA-2019-4)

phpMyAdmin - ChangeLog ====================== 4.8.4 (2018-12-11) - issue #14452 Remove hash param in edit query URL - issue #14295 Issue in Changing theme - issue #13267 Ensure that database names with '.' are handled properly when DisableIS is true - issue #14438 Invisible Icon "Show Full Queries" - issue #14133 CSS issue in Designer - issue #14447 Error while copying database (pma__column_info) - issue #14571 "No database selected" - DROP a view - issue #14636 Move operation causes SELECT * FROM `undefined` - issue #14630 Enum '0' produces incorrect search SQL - issue #14223 Fix TypeError in database designer - issue #13621 QBE selenium tests broken since merge of #13342 - issue #14672 When logging with $cfg['AuthLog'] to syslog, successful login messages were not logged even if $cfg['AuthLogSuccess'] was true. - issue #14339 Fix infinite loop when sorting table rows by key. - issue #14658 Regression on multi table query functionality (foreign keys) - issue #14617 Fix designer errors when database is empty - issue #13032 Fix designer errors when database contains special chars - issue #14352 Fix designer javascript errors - issue #14764 Fix left/right icons hidden - issue [security] Local file inclusion flaw in the Transformation feature (PMASA-2018-6) - issue [security] Multiple CSRF/XSRF vulnerabilities (PMASA-2018-7) - issue [security] XSS vulnerability in the navigation tree (PMASA-2018-8)

phpMyAdmin - ChangeLog ====================== 4.8.2 (2018-06-21) - issue #14370 WHERE 0 causes Fatal error - issue #14225 Fix missing index icon - issue [security] XSS vulnerability in Designer, see PMASA-2018-3 - issue [security] File inclusion and remote code execution vulnerability, see PMASA-2018-4

phpMyAdmin - ChangeLog ====================== 4.8.0.1 (2018-04-19) - issue [security] Multiple CSRF vulnerabilities, See PMASA-2018-02

phpMyAdmin - ChangeLog ====================== 4.7.9 (2018-03-05) - issue #13931 Fixed browsing tables with more results - issue #13927 "Not an integer" when browsing a table - issue #13887 "Input variables exceeded 1000" error relating to PHP's max_input_vars directive

phpMyAdmin - ChangeLog ====================== 4.7.7 (2017-12-23) - issue #13865 Fixed displaying of formatted numeric values for some locales - issue #13856 Ensure datetimepicker is always loaded for datetime fields - issue #13848 Fixed PHP error when browsing certain results - issue [security] Fix XSRF/CSRF vulnerability, see PMASA-2017-09

phpMyAdmin - ChangeLog ====================== 4.7.5 (2017-10-23) - issue #13615 Avoid problems with browsing unknown query types - issue #13612 Integrate tooltip into datetime pickers - issue #13628 Fixed javascript error in server monitor - issue #13444 Fixed server monitor on non Linux and Windows systems - issue #13633 Reload javscript messages when changing language - issue #13604 Fixed crash on invalid ordering data - issue #13639 Fixed error when browsing non SELECT results - issue #13533 Fixed saving column to display - issue #13647 Fixed export of tables with VIRTUAL columns - issue #13669 Fixed selecting multiple rows accidentally selects the next row too - issue #13513 Fixed edit index Column alignment issue - issue #13515 Fixed rendering of add index dialog - issue #13710 Fixed possible error in server advisor - issue #13477 Fixed setting input transformations - issue #13552 Fixed IPv4/IPv6 To Binary input transformation - issue #13686 Clicking on column name to trigger sort with an active search leads to logout - issue #13725 Fixed copying tables with specific PARTITION definition - issue #13761 Fixed listing of bookmarks for a database

phpMyAdmin - ChangeLog ====================== 4.7.3 (2017-07-20) - issue #13447 Large multi-line query removes Export operation and blanks query box options - issue #13445 Fixed rendering of query results - issue #13437 Fixed version check when not connected to a database - issue #13465 Fixed creating relation - issue #13475 Fixed export without backquotes - issue #13482 Improved handling of uploaded files with open_basedir - issue #13387 Fixed inline editing of hex values - issue #13382 Fixed size of index edit dialog - issue #13489 Fixed rendering SQL lint errors - issue #13468 Avoid breakage if set_time_limit is disabled - issue #13471 Fail if ini_set/ini_get are disabled - issue #13436 Automatically connect using SSL when server is configured so - issue #13478 Fixed usage of some browser transformations

phpMyAdmin - ChangeLog ====================== 4.7.1 (2017-05-25) - issue #13132 Always execute tracking queries as controluser - issue #13125 Focus on SQL editor after inserting field name - issue #13133 Fixed broken links in setup - issue #13135 Database list Tooltips: Show wrong value - issue #13150 Fixed pagination while browsing resuls - issue #13149 Fixed outbound links in changelog.php - issue #13146 Do not include devel dependencies in the release - issue #13144 Do not show New as a database in database dropdown - issue #13130 Fixed handling of errors in AJAX requests - issue #13152 Fixed PHP error in case of invalid table preferences - issue #13154 Fixed PHP error on password change - issue #13219 Fix Refresh of Process List - issue #13182 Fix refresh of long queries - issue #12301 Improved handling of logout with disabled LoginCookieDeleteAll - issue #13216 Add support for MySQL 8.0 collations - issue #13218 Fixed rendering of phpMyAdmin logos - issue #13234 Properly report not working sessions - issue #13256 Fixed password check on server replication - issue #13252 Fixed grid editing time column - issue #13258 Fixed detection of Amazon RDS - issue #13241 Redirect user to last page that has any tables to display - issue #13266 Fix link to User accounts overview page - issue #13274 Fix error in query builder - issue #13177 Grid editing repeats action after error

phpMyAdmin - ChangeLog ====================== 4.6.6 (2017-01-23) - issue #12759 Fix Notice regarding 'Undefined index: old_usergroup' - issue #12760 Fix Notice regarding 'Undefined index: users' - issue #12762 Fixed parsing of SQL with BINARY function - issue #12588 ReCaptcha now works without allow_url_fopen - issue #12699 Show no local storage warning only on settings tab - issue #12778 Syntax Error in Adding/Changing TIMESTAMP columns with default value as NULL - issue #12769 Edit/Export links are not clickable under Routines tab - issue #12757 Fixed creating new user with older MariaDB - issue #12784 Remove ctype installation suggestion - issue #12780 Format button replaces all text with blank spaces - issue #12786 Fixed database searching - issue #12792 Fixed javascript error on new version link - issue #12785 Add information about required and suggested extensions to composer.json - issue #12801 Custom header shown twice with cookie login form - issue #12802 Custom footer not shown with auth_type http login failure - issue #12434 Improve documentation for servers running with Suhosin - issue #12800 Updated embedded phpSecLib to 2.0.4 - issue #12800 Fixed various issues with PHP 7.1 - issue #11816 Fixed operation with lower_case_table_names=2 - issue #12813 Fixed stored procedure execution - issue #12826 Honor user configured connection collation - issue #12293 Correctly report OpenSSL errors from cookie encryption - issue #12814 DateTime won't allow to input length in Routine editor - issue #12840 Fix Notice regarding 'Undefined index: row_format' when altering table options - issue #12841 Fixed moving of columns with whitespace in name - issue #12847 Fixed editing of virtual columns - issue #12859 Changed WHERE condition to 0 instead of 1 for SQL query window to avoid accidents - issue #12872 Use same query for display and execution when dropping index - issue #12868 Fix check for user groups freatures being enabled - issue #12876 Fix notices and warning related to dbs_to_test global - issue #12831 Fix table formatting on Insert tab, which mostly affected row highlighting - issue #12495 Reintroduced phpinfo page with limited capabilities - issue #12861 Fix renaming tables with lower_case_table_names=2 - issue #12876 Fix possible PHP error in navigation - issue #12881 Fix database search with newer php-gettext - issue #12894 Fix linter error on unterminated variable name - issue #12732 Fixed filtering for active processes - issue [security] Multiple vulnerabilities in setup script, see PMASA-2016-44. - issue [security] Open redirect, see PMASA-2017-1. - issue [security] php-gettext code execution, see PMASA-2017-2. - issue [security] DOS vulnerabiltiy in table editing, see PMASA-2017-3. - issue [security] CSS injection in themes, see PMASA-2017-4. - issue [security] Cookie attribute injection attack, see PMASA-2017-5. - issue [security] SSRF in replication, see PMASA-2017-6. - issue [security] DOS in replication status, see PMASA-2017-7.