|Tags||database system-administration php mysql mariadb|
5.1.312 Feb 2022 03:25 minor bugfix: Broken pagination links in the navigation sidebar. MariaDB has no support for system variable "disabled_storage_engines". Unsupported operand types in Results.php when running "SHOW PROCESSLIST" SQL query. Importing browser settings question box after login when having no pmadb. "First day of calendar" user override has no effect. Repeating headers are not working. Import of email-adresses or links from ODS results in empty contents. a type error on ODS import with non string values. Header row show/hide columns buttons on each line after hover are shown on each row. security for path disclosure under certain server configurations (if display_errors is on, for instance).
5.1.025 Feb 2021 10:45 major bugfix: Change Media (MIME) type references to Media type. Add a request router. Automatically focus input in the two-factor authentication window. Replace gender-specific pronouns with gender-neutral pronouns. Improve complexity of generated passwords. Add a configuration option to define the 1st day of week. Made user names clickable in user accounts overview. Improve virtuality dropdown for MariaDB 10.1. Added an option to perform ALTER ONLINE (ALGORITHM=INPLACE) when editing a table structure. Added missing 'IF EXISTS' to 'DROP EVENT' when exporting databases. Improve the padding in query result tool links. Support exporting raw SQL queries. Added ip2long transformation. horizontal scroll on structure edit page. Move table hide buttons in navigation to avoid hiding a table by mistake. Use correct MySQL version if the version is 8.0 or above for documentation links. Use "MariaDB Documentation" instead of "MySQL Documentation" on a MariaDB server. Change "Show Query" link to a button. Automatically toggle the radio button to "Create a page and save it" on Designer. Tap and hold will not dismiss the error box anymore, you can now copy the error. Don't disable "Empty" table button after clicking it. Stay on the structure page after editing/adding/dropping indexes. show structure after adding a column. Remove symfony/yaml dependency. Improve performance of dependency injection system by removing yaml parsing. Disable phpMyAdmin storage database checkbox on databases list. Add autocomplete attributes on login form. Add "Preview SQL" option on Index dialog box when creating a new table. export maximal length of created query input is too small. Redesign the server status advisor page. Use same height for SQL query textarea and Columns select in SQL page. Add a new vendor constant "CACHE_DIR" that defaults to "libraries/cache/" and store routing cache into this folder. Warm-up the routing cache before building the release. Use --optimize-autol
5.0.416 Oct 2020 06:45 minor bugfix: Failed Zoom search clears existing values. a PHP error when reporting a particular JS error. Latitude and longitude swap for geometries in edit mode. CREATE TABLE not being tracked when auto tracking is enabled. Compatibility problems with older PHP versions. Broken two-factor authentication.
5.0.311 Oct 2020 16:25 minor bugfix: Require twig 2.9. Option to import files locally appearing as not available. to allow NULL as a default bit value. "htmlspecialchars() expects parameter 1 to be string, null given" on Export xml. no charts in monitor when using a decimal separator ",". IN(...) clause doesn't permit multiple values on "Search" page. Support double tap to edit on mobile. Php error "Use of undefined constant MYSQLI_TYPE_JSON" when using the mysqlnd extension. Fatal JS error on index creation after using Enter key to submit the form. Set "axis-order" to swap lon and lat on MySQL = 8.1. Overwriting a bookmarked query causes a PHP fatal error. Typo in a condition in the Sql class. Local setup doc links pointing to a wrong location. Error importing utf-8 with bom sql file. FA UX enhancement: autofocus 2FA input. Table column description PHP error when 'DisableIS' = true;. Local documentation links display when a PHP extension is missing. Some twig code deprecations for php 8. ENUM and SET display when editing procedures and functions. Keep full query state on "auto refresh" process list. Keep columns order on "auto refresh" process list. Editing a failed query from the error message. The alter user privileges query to make it MySQL 8.0.11+ compatible. Copy table to another database when the nbr of DBs is cfg 'MaxDbList' . Relations of tables having spaces or special chars not showing in the Designer. a very rare JS error occuring on mousemove event. Make a foreign key link clickable in a new tab after the value was saved and replaced. a PHP notice "Undefined index: column_info" on views. The data stream when exporting data in file mode. Templates/ directory not found error. Remove chdir logic to PHP fatal error "Uncaught TypeError: chdir()". Support for Twig 3. Allow phpmyadmin/twig-i18n-extension 3.0. Trim spaces for integer values in table search. Cannot edit or export TIMESTAMP column with default CURRENT_TIMESTAMP in MySQL = 8.0.13. Error 500
5.0.109 Jan 2020 09:25 minor bugfix: Error 500 when browsing a table when cfg 'LimitChars' used a string and not an int value. Display NULL on numeric fields has showing empty string since 5.0.0. Get Database structure fails with PHP error on replicated server. Can't browse certain tables since 5.0.0 update. Prevent line wrap in DB structure size column. Remove extra line break from downloaded blob content. Error 500 when exporting - set time limit when cfg 'ExecTimeLimit' used a string and not an int value. Double delete icons on enum editor. Warning popup not dissapearing on table stucture when using actions without any column selection. Focus of active tab is lost by clicking refresh option on browse tab. Uncaught TypeError: http_build_query() in setup. Double slash in path when cfg 'TempDir' has a trailing slash. Shp file import tests where failing when php dbase extension was enabled. JS error "PMA_makegrid is not defined" when clicking on a table from the "Insert" tab opened in a new tab. FA setting removed each time the user edits another configuration setting. security SQL injection vulnerability on the user accounts page (PMASA-2020-1).
5.0.028 Dec 2019 06:05 major feature: Drop support for PHP 5.5, PHP 5.6, PHP 7.0 and HHVM. Enable columns names by default for CSV exports. Remove font size feature. Add Metro theme. Add move columns preview SQL button. Enable strict mode in PHP files. Increase field width for editing varchar fields. Show warning for users with the default values for controluser and controlpass. rendering of column comments in Safari, improve display in all browsers. New features for csv import plugin. Automatically add index while editing an existing row and setting auto increment. Add export option to drop user security definers from views. Drop view and or replace added to exporting view. Database "Search" selects all tables by default. Auto expand the single database. Inconsistency with submit buttons. Improper message in Show Hidden Navigation Tree Items. Remove unlabeled default collation from the bottom of the database list; this information is available elsewhere. Security confirm() before running UPDATE statement without WHERE condition. Show errors at the bottom of the page and add copy query button for errors in processing sql queries. Use Sass instead of PHP to compile CSS. Add initial support for Bootstrap 4. Change table column comment field from input to textarea. Console: ctrl+l clear line and ctrl+u clear console. Use charset 'windows-1252' when format is MS Excel. Move 'More settings' link from 'Appearance settings' to 'General settings'. Remove the redundant 'i' help/tool tip in page settings "Query History Length" area. Importing CSV now uses file name as the table name instead of 'TABLE #'. Add an Edit link for each view in tables list. Display column details in navigation bar. Add title for group in navigation bar. Show InnoDB table overhead (free space). Add '' button to the Monitor Instructions modal. Improved filter method in server variables page. Add an external dependency injection system. Change MIME type references to Media (MIME) type. url.php crashing b
4.9.223 Nov 2019 03:15 minor bugfix: Change the cookie name from phpMyAdmin to phpMyAdmin_https for HTTPS, many "Failed to set session cookie" errors. Ssl_use php error. Undefined index: ssl_ variables. Mysql 8.0.3 and above fails on advisor. Unparenthesized php deprecation. URL encoding plus sign (+) in the table or DB name when configuring foreign keys. Bottom table in list in left panel blocked by horizontal scroll bar. Text area overflows its parent element on "Query" page. Exporting users after a delete will delete all selected users on "Users" page. Checking referencial integrity on "Operations" page. "You do not have privileges to manipulate with the users!" on root superadmin. GIS polygon of a geometry field is not drawn on "GIS visualization". Adjust privileges on copy database fails with MariaDB. Display referential integrity check for InnoDB. Support phpunit 8 in our test suite to help packaging phpMyAdmin on Debian. Missing image error fills logs, removed ic_b_info icon from icon list. Some with the sort by key selectors. Operators precedence in DatabaseInterface class. Test test suite on 32-bit systems. Long2IP transformation with PHP 7.1. Moving columns with DEFAULT NULL doesn't work on MariaDB 10.2+. Moving columns with INT AND DEFAULT CURRENT_TIMESTAMP doesn't work on MariaDB. Table alias is removed when exporting a query. Cross join clause is removed on export. Error "is_uploaded_file() expects parameter 1 to be string" when inserting blobs from files. White square when refreshing designer or browsing other pages. Detect when phpMyAdmin storage tables are not accessible, help users browse corrupt DBs. Display profiling when query outputs no rows. Setting and removing display field on Designer. Added a warning when trying to set a display field on Designer and configuration storage is not setup. Shift-click in Export misses a checkbox. security improperly sanitized data when showing the Git branch. security security
4.9.122 Sep 2019 03:15 minor bugfix: Added support for Twig 2. Cannot edit or export column with default CURRENT_TIMESTAMP in MySQL = 8.0.13. a TypeError in Import class with PHP 8. Middle-click on foreign key link broken. Broken relational links in tables. Weird error for empty collation. Export of GIS visualisation not working (PNG, PDF, SVG). Use hex for the phpMyAdmin session token. Added GB18030 Chinese collations description. Added Russian, Swedish, Slovak and Chinese UCA 9.0.0 collations description. Added description for the _ks (kana-sensitive) collation suf- Added description for the _nopad (NO PAD) collation suf- Remove array/string curly braces access. "FilterLanguages" option does not work (configuration). Creating user with single quote in password results in no password user. Left database overview "add column" triggers error. Remove unexpected quotes on text fields (structure and insert). NULL wrongly checked on field change. Allow to rollback an empty statement. Incorrect linkage from one table's value to another table. Tables added from other databases are not collapsing in the designer section. Designer page save fails if dB name contains period. Display an error when trying to import in designer a table that's already imported. Many when adding new tables to designer. Update CodeMirror to v5.48.4. Update jQuery Migrate to v3.1.0. Update jQuery Validation to v1.19.1. Update jQuery to v3.4.1. Update js-cookie to v2.2.1. Remove fieldset closing tag when setting global privileges. Backslash in column name resulting an error in editing. Status - Advisor error. Designer page status not updated when added a new table from another database. Page number is not being updated in the URL after saving a designer's page. Reloading a designer's page. Designer full screen mode button and text stuck when exiting full-screen mode. Reduced possibilit
4.8.323 Aug 2018 03:15 minor bugfix: Error when naming a database '0'. NULL as default not shown. with recent table list. slow performance on DB structure filtering. Editing server variable not showing save or cancel option. Populate options for view create and edit. FA configuration fails if PHP doesn't have GD support. Can't unhide tables. "Visualize GIS data" icon missing. Event scheduler status toggle doesn't work. View not working on multiple servers. Partition actions in table structure do not work. ERR_BLOCKED_BY_XSS_AUDITOR on export table. Blank message shown instead of MySQL error when adding trigger and other locations. PHP 7.3 warning: "continue" in "switch" is equal to "break". Icon missing when creating a new trigger, routine, and event. Table comment not showing since 4.8.1. Drop table doesn't work when you copy tables to another database. Escaped HTML in 'Add a new server' setup. security HTML injection in import warning messages, see PMASA-2018-5.
4.8.224 Jun 2018 03:45 minor security: WHERE 0 causes Fatal error. Missing index icon. security XSS vulnerability in Designer, see PMASA-2018-3. security File inclusion and remote code execution vulnerability, see PMASA-2018-4.
4.8.126 May 2018 08:25 minor bugfix: case where the central columns attributes don't get filled in. case where the query builder doesn't work when selected column is *. Revert "Browse" table CSS overflow. Dropping indexes and foreign keys fail. Relational linking broken. error in configuration storage zero config. Show 2FA Secret next to QR code. XML Export from single table throws fatal error. Line and some other charts ignore result set order of values chosen for the x-axis. configuration for DefaultLang and Lang. Linking for 'Distinct values' broken. MariaDB 10.2 current_timestamp(). for missing go button in view edit. for with spatial fields. Remember table's sorting broken. multi-column sorting. central columns in-line edit - AUTO_INCREMENT error when only exporting table structure in database-level exports. Simulating queries produces unexpected results. Setup script icons missing.
220.127.116.11 Apr 2018 06:45 minor security: security Multiple CSRF vulnerabilities, See PMASA-2018-02.
4.7.906 Mar 2018 03:15 minor bugfix: Browsing tables with more results. "Not an integer" when browsing a table. "Input variables exceeded 1000" error relating to PHP's max_input_vars directive.
4.7.823 Feb 2018 03:15 minor bugfix: Resetting default setting values. Fallback value for collation connection. Error handling in PHP 7.2. security XSS in Central Columns Feature, See PMASA-2018-01.
4.7.709 Jan 2018 08:45 minor bugfix: displaying of formatted numeric values for some locales. Ensure datetimepicker is always loaded for datetime fields. PHP error when browsing certain results. security XSRF/CSRF vulnerability, see PMASA-2017-09.
4.7.602 Dec 2017 03:15 minor bugfix: check all interaction with filtering. Add SJIS-win to default list of allowed charsets. Improve detection that MySQL server needs SSL connection. Support JSON datatype on MariaDB 10.2.7 and newer. constructing ALTER query with AFTER. Lock page when changes are done in the SQL editor. Prefer iconv for encoding conversions. changing password on MariaDB cluster.
4.7.425 Aug 2017 06:05 minor bugfix: Remove shadow from the logo. Per server theme feature. Missing newline in ALTER exports. Several compatibility with PHP 7.2. Copy results to clipboard. Add limitation for user group length. Edit variable link in advisor. Optimize table link should not be visible in print page. Improved error handling on corrupted tables. Rendering of add index dialog. Refreshing server variables.
4.7.322 Jul 2017 03:15 minor bugfix: Large multi-line query removes Export operation and blanks query box options. Rendering of query results. Version check when not connected to a database. Creating relation. Export without backquotes. Improved handling of uploaded files with open_basedir. Inline editing of hex values. Size of index edit dialog. Rendering SQL lint errors. Avoid breakage if set_time_limit is disabled. Fail if ini_set/ini_get are disabled. Automatically connect using SSL when server is configured so. Usage of some browser transformations.
4.7.102 Jun 2017 03:15 minor bugfix: Always execute tracking queries as controluser. Focus on SQL editor after inserting field name. Broken links in setup. Database list Tooltips: Show wrong value. Pagination while browsing resuls. Outbound links in changelog.php. Do not include devel dependencies in the release. Do not show New as a database in database dropdown. Handling of errors in AJAX requests. PHP error in case of invalid table preferences. PHP error on password change. Refresh of Process List. Refresh of long queries. Improved handling of logout with disabled LoginCookieDeleteAll. Add support for MySQL 8.0 collations. Rendering of phpMyAdmin logos. Properly report not working sessions. Password check on server replication. Grid editing time column. Detection of Amazon RDS. Redirect user to last page that has any tables to display. Link to User accounts overview page. Error in query builder. Grid editing repeats action after error.
18.104.22.168 Dec 2016 20:05 minor bugfix: SQL export with newlines.
22.214.171.124 Nov 2016 05:45 minor bugfix: Incorrect parameters to escapeString in Node.php. PHP error when mbstring is not installed. Don't force partition count to be specified when creating a new table.
4.6.526 Nov 2016 03:15 minor bugfix: Remove potentionally license problematic sRGB profile. Display read only fields as read only when editing. expanding of navigation pane when clicking on database. Impove partitioning support. Reintroduced simplified PmaAbsoluteUri configuration directive. Always use UTC time in HTTP headers. Simplified validation of external links. browsing tables with built in transformations. Do not show warning about short blowfish_secret if none is set. random logouts due to wrong cookie path. editing of ENUM/SET/DECIMAL fields structure. Missing escaping of configuration used in SQL (hide_db and only_db). Add error checking in reading advisory rules file. Add checking missing elements and confirming element types from json_decode. Automatically save SQL query in browser local storage rather than in cookie. Unable to edit transformations. Remove unused paramenter when connecting to MySQLi. number formatting with different settings of precision in PHP. Use single quotes in PHP code. Option for the dropped column is not removed from 'after_field' select, after the column is dropped. Properly detect DROP DATABASE queries. possible race condition in setting URL hash. Remove caching of server information. Proper parsing of INSERT... ON DUPLICATE KEY queries. Proper parsing of CREATE TABLE... PARTITION queries. Code can throw unhandled exception. Do not try to keep alive session even after expiry. rendering BBCode links in setup. copy of table with generated columns. export of table with generated columns. Copying a user does not copy usergroup. Adding a new row with default enum goes to no selection when you want to add more then 2 rows. Drag and drop import prevents file dropping to blob column file selector on the insert tab. Absence of scrolling makes it impossible to read longer text values in grid editing. "Edit routine" crashes when the current user is not the definer, even if privileges are adequate. Export selective tables by-d
4.6.418 Aug 2016 06:45 minor security: security Weaknesses with cookie encryption, see PMASA-2016-29. security Improve session cookie code for openid.php and signon.php example files. security Full path disclosure in openid.php and signon.php example files. security Multiple XSS vulnerabilities, see PMASA-2016-30. security Multiple XSS vulnerabilities, see PMASA-2016-31. security Unsafe generation of BlowfishSecret (when not supplied by the user). security Referrer leak when phpinfo is enabled. security PHP code injection, see PMASA-2016-32. security Full path disclosure, see PMASA-2016-33. security SQL injection attack, see PMASA-2016-34. security Local file exposure through LOAD DATA LOCAL INFILE, see PMASA-2016-35. security Local file exposure through symlinks with UploadDir, see PMASA-2016-36. security Path traversal with SaveDir and UploadDir, see PMASA-2016-37. security Multiple XSS vulnerabilities, see PMASA-2016-38. security SQL injection vulnerability as control user, see PMASA-2016-39. security SQL injection vulnerability, see PMASA-2016-40. security Denial-of-service attack through transformation feature, see PMASA-2016-41. security SQL injection vulnerability as control user, see PMASA-2016-42. security Verify data before unserializing, see PMASA-2016-43. security Use HTTPS for wiki links. Remove Swekey support. security SSRF in setup script, see PMASA-2016-44. security Denial-of-service attack with cfg 'AllowArbitraryServer' = true and persistent connections, see PMASA-2016-45. security Improve SSL certificate handling. security full path disclosure in deging code. security Possible circumvention of IP-based allow/deny rules with IPv6 and proxy server, see PMASA-2016-47. security Detect if user is logged in, see PMASA-2016-48. security Bypass URL redirection protection, see PMASA-2016-49. security Referrer leak, see PMASA-2016-50. security Reflected File Download, see PMASA-2016-51. security Arbitrary
4.6.0.024 Mar 2016 03:15 major bugfix: Disabled storage engines. Allow setting routine wise privileges. Hide Insert tab for non-updatable views. UI for defining partitioning in create table window. Support JSON data type. Editing partitions in table Structure. Tracking does not make sense for information_schema. Regression in Find and replace. TokuDB Tables Show Size as "unknown". Use a slider for Internal relations. Ability to disable the navigationhiding Feature. Restrict configuration NavigationTreeDbSeparator to strings. Disable the tooltip in the navigation panel's filter box. Copy results to clipboard. Reactivate cut paste possibility in print view. Extraneous message after edit + grid-edit. Table header is empty with browsing an empty table. Allow changing parameter order of routines. Remove no password warning. Clarify the meaning of "Stand-in structure for view" in SQL export. HTML line break shown after a MySQL connection error message. CSV import skip row count after. displaying of SQL query on table operations. Display binary strings as text if they are valid UTF-8. Display routine specific privileges. Copy multiple tables to database. Support Cloudflare Flexible SSL. Handle empty TABLE_COMMENT. Drop support for old Internet Explorer versions. Use modals for displaying forms in db structure page. Show MySQL error messages in user language. Add 'ssl_verify' configuration directive for self-signed certificates with mysqlnd and PHP = 5.6. Show more used PHP extensions. Report when version check and error reporting are disabled. PDF schema export. Remove ForceSSL configuration directive. Remove support for Mozilla Prism. Remove PmaAbsoluteUri configuration directive. autoloading of phpseclib. rendering of missing extension error. Errors on Structure tab when user only has select access on certain columns. Missing documentation for cfg 'Servers' i 'favorite' and cfg 'NumFavoriteTables
126.96.36.199 Mar 2016 00:45 minor security: CREATE UNIQUE INDEX index type is not recognized by parser. Row count wrong when grouping joined tables. Column definition with default value and comment in CREATE TABLE expoerted faulty. New statement but no delimiter and unexpected token with REPLACE. incorrect usage of SQL parser context in SQL export. security XSS vulnerability in SQL parser, see PMASA-2016-10. security Multiple XSS vulnerabilities, see PMASA-2016-11. security Multiple XSS vulnerabilities, see PMASA-2016-12. security Vulnerability allowing man-in-the-middle attack on API call to GitHub, see PMASA-2016-13. inclusion of gettext library from SQL parser.
188.8.131.52 Feb 2016 13:45 minor documentation: Error with PMA 184.108.40.206. Remove hard dependency on phpseclib.
220.127.116.11 Dec 2015 09:05 minor security: Undefined offset 2. Security Path disclosure, see PMASA-2015-6.
4.5.3.024 Dec 2015 06:25 major bugfix: Incomplete results of UNION ALL. MATCH AGAINST keywords not recognized. syntax verifier is not knowing "STRAIGHT_JOIN". REPLACE() function confused with REPLACE statement. FLUSH word not recognized by parser. Online syntax verifier - "IF" on SELECT statement. Format breaks query with COUNT(). Undefinex index: SendErrorReports. Incorrect script name in include. Warning: Invalid argument supplied for foreach(). Delimiter missing while exporting multiple db routines. mysql_native_password with MariaDB - Flush privileges overusage - related to #11597. Query was empty on creating User in 4.5.2. PMA_getDataForDeleteUsers() warning. Cannot create user on Percona Server. Properly report error on connecting. Database export template not saving compression option. single quote export for servers in ANSI_QUOTES mode. Avoid duplicite fetching of table information. Temporary for live data edit of big sets is not working. IE 8 compatibility in console. Exporting feature does not work with union table. Cannot export results of some queries. Message "An account already exists..." incorrectly displayed. Missing quoting of table in ALTER CONVERT query. PMA 4.5.2 breaks MySQL Master-Master Cluster. Export and preview show different SQL for character set. possible undefined variables in table operations.
4.5.2.024 Nov 2015 06:45 major feature: Incorrect parameter in mysqli_fetch_fields(). Missing headers in zipped export. Parser: Array to string conversion. Huge binary log growth on 4.5.x. 'only_db' config option when db names contain underscore and are grouped. Unable to change password from Login information tab. Undefined variable: res_rel. Warning while exporting schema to PDF. Undefined index: new_row_format. Changing hostname kills password. Undefined variable: db. CREATE TABLE/INSERT INTO executed twice (ctrl+enter). Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given. Exporting GIS visualization ignores start and row count. Errors instead of git info when PHP has no gzip support. CodeMirror tooltip shows below modal window. with the MainBackground Color. Profiling checkbox is missing. Properly handle session expiry after POST requests. Notice in./export.php#214 Undefined index: quick_or_custom. Unrecognized keywords. Sql not executed properly. Linter warnings when creating new user. wrong row count for query results. Analyzer doesn't recognize GRANT statements. Parser warnings (subqueries). Collation column is empty in table Structure. Error changing table's column encoding.
4.5.1.024 Oct 2015 07:05 major feature: Invalid argument supplied for foreach(). array_key_exists() expects parameter 2 to be array. Notice Undefined index: drop_database. Server variable edition in ANSI_QUOTES sql_mode: losing current value. Propose table structure broken. phpMyAdmin suggests upgrading to newer version not usable on that system. 'PMA_Microhistory' is undefined. Incorrect definition for getTablesWhenOpen(). Error when creating new user on MariaDB 10.0.21. Notice on htmlspecialchars(). Notice in Structure page of views. AUTO_INCREMENT always exported when IF NOT EXISTS is on. Some partitions are missing in copied table. Notice of undefined variable when performing SHOW CREATE. Error exporting sql query results with table alias. SQL editing window does not recognise 'OUTER' keyword in 'LEFT OUTER JOIN'. "NOT IN" clause not recognized (MySQL 5.6 and 5.7). Yellow star does not change in database Structure after add/remove from favorites. Invalid SQL in table definition when exporting table. Foreign key to other database's tables fails. while exporting results when a joined table field name is in SELECT query. Strange behavior on table rename. Rename table does not result in refresh in left panel. Missing arguments for PMA_Table::generateAlter(). Notices about undefined indexes on structure pages of information_schema tables. Change minimum PHP version for Composer. Import parser and backslash. "Visualize GIS data" seems to be broken. Confirm box on "Reset slave" option. cookies clearing on version change. Cannot execute SQL with subquery. Incorrect syntax creating a user using mysql_native_password with MariaDB. Cannot use third party auth plugins.
18.104.22.168 Sep 2015 16:45 minor documentation: Incorrect indexes when exporting.
22.214.171.124 Sep 2015 15:45 minor documentation: AUTO_INCREMENT statements are partly missing from exports.
4.4.15.021 Sep 2015 16:45 major bugfix: Undefined "replace" function on numeric scalar. Stored-proc / routine - broken parameter parsing. Missing name for configuration read_as_multibytes. Incorrect "No row selected" message. MySQL 5.5 and the language system variable. Semantics of export and import icons are mixed up. Designer-in move.js on multiple server configuration. Invalid UTF-8 sequence in argument. Request URI too large. Invalid argument supplied for foreach(). Foreign key constraints for InnoDB tables with upper-case letters disabled. Warning when entering Query page.
126.96.36.199 Sep 2015 14:45 minor security: security reCaptcha bypass.
4.4.14.021 Aug 2015 10:45 major documentation: Export after search, missing WHERE clause. Incomplete message after import. Incorrect scalar type declaration (reported under PHP 7). ReCaptcha produces deprecated messages under PHP 7. phpseclib 2.0 produces deprecated messages on PHP 7. "Switch to copied table" doesn't work. Missing quotes after calling "distinct values". Cannot import database with long data in one column. SPATIAL index option is not clickable.
188.8.131.52 Aug 2015 18:45 minor feature: SQL error when importing phpMyAdmin dump file.
4.4.13.008 Aug 2015 07:25 minor feature: "Improve table structure" generates invalid SQL. issue Once checked "Show only active" checkbox is always checked. Delete rows using "Check All" is broken. issue Fix PHP 7 possible binding ambiguity. Exported schema includes all the tables of the database. Results not displayed if query ends in delimiter and comment. Live edit of data fields is not working always. issue Table list in navigation collapses when entering into a table in another page. JS error while trying to auto navigate to db structure page when db creation has failed.
4.4.12.022 Jul 2015 08:25 minor feature: Saved chart image did not have a proper name or an extension. Timepicker CSS issues in Original theme. Move/Copy/Rename operations on Table/Db fail on Drizzle server. Two inline edit windows. Problem when import *.ods file. Add missing head tag. Column headers move when scrolling.
4.4.11.007 Jul 2015 22:05 minor feature: bug Missing selected/entered values when editing active options in visual query builder. Autoload from prefs_storage not behaving properly. Incorrect length computed for binary data. bug Remove character set from create_tables_drizzle.sql. Users overview needs clarification. Creating a database from console doesn't update navigation panel. FAQ 1.17 needs an update.
4.4.9.005 Jun 2015 13:25 minor feature: relation view doesn't list fields of table in other database. Sorting by an alias. False error before entering reCAPTCHA. central column with multiple server. Custom export with backquotes off is not working. Reverse proxy: infinite internal redirect (added warning in doc). Export to gzip saves plain text under Chrome.
4.4.8.029 May 2015 03:16 minor feature: bug Allow accessing visual query builder when pmadb is not configured. Nav tree line alignment issue. Lock page icon is not shown after fresh reload. "Highlight pointer" and "Row marker" doesn't work properly. bug Browse foreigners window goes out of the window. Date field popup dialog position bug. bug In /setup, PMA_messages is not defined. Recaptcha failure. Database copy doesn't work for tables with more than one FULLTEXT index. Edit view structure doesn't load the algorithm. Do not limit table comments to 60 characters.
4.4.7.018 May 2015 03:16 minor feature: Settings issues (Favorite tables shown twice in Settings). Non-styled error page when following results link. Deleting without confirmation. Issues with SQL autocomplete. Column hint in SQL autocomplete is sometimes not shown. JS error after selecting a field and press Enter. bug Honor proxy settings when getting Git commit information. bug Missing title on link. ForceSSL Redirect Check. bug Undefined index collation_connection. bug Error when the reporting server is down. bug Escape database and table names for partition maintenance. bug Invalid value for CURLOPT_SSL_VERIFYPEER. Import status infinite loop. Designer: Loading does not work. Setup: Overview Display does not work. Designer: pages from all databases.
184.108.40.206 May 2015 14:45 security: security CSRF vulnerability in setup.
4.4.6.010 May 2015 03:45 minor feature: webkitStorageInfo and webkitIndexedDB is deprecated. Undefined variable: unique_conditions. CSV Import ignores "Replace table data with file" checkbox.
4.4.5.006 May 2015 20:05 minor bugfix: Table overhead stats: missing space before the unit. Fix resize icon in Designer. Exit fullscreen in Designer does not change the button text. Designer icons missing when using original theme. Column list of central columns is not cleared. jQuery dialogs of the Designer are not displayed in fullscreen. Search function breaks when searching for certain combinations of backslashes and slashes. Maximum execution time exceeded in Util.class.php (better fix). Some icons are above the overlay of jQuery dialogs. Clicking on external links in advisor rules give JS error. Filter in central columns does not work in other languages.
4.4.4.028 Apr 2015 02:45 minor bugfix: Don't scroll (to bottom) when editing multiple rows. Misaligned Inline edit field. Use of undefined constant PMA_DRIZZLE. sprintf(): Too few arguments. Limit column ordering in index edit dialog. Incorrect ALTER TABLE statement generated. Inconsistency in 'Ignore' checkbox in insert page. Drop column action not asking to confirm. Error on creating table. Bugfux for Undefined index: Rows.
4.4.3.021 Apr 2015 14:05 minor feature: PHP errors in login dialogue. json_encode error due to strftime returning non utf8 chars in Windows 8.1 Chinese version. White screen (Cloudflare). Server error viewing table content. bug Fix issues related to number of decimal places in time. Relation view between 1600 and 1780 px. bug PHP 7 compatibility in php-gettext. bug PHP 7 compatibility in bfShapeFiles. bug PHP 7 session_regenerate_id() warning. Alter table after changing column name error. Maximum execution time exceeded in Util.class.php.
220.127.116.11 Apr 2015 22:00 minor bugfix: Web server's error log is flooded.
4.4.0.003 Apr 2015 03:16 major feature: rfe InnoDB presently supports one FULLTEXT index creation at a time. rfe Allow tracking multiple table at once from database level tracking page. rfe Improve action message on Tracking page. rfe Change value of "Number of rows:" when "Show all" is checked. rfe Focus console by clicking on white space. rfe Part 1: Cycle through console history with keyboard up/down arrows. rfe Default to primary key when adding relation. rfe User prefs: Diff-friendly JSON for config. rfe Sever Variables Table UI Improvements. phpMyAdmin should be able to work without 'examples' DIR - move SQL scripts to sql directory. rfe Warn about reserved word only when a column is created. rfe Recaptcha API v2. rfe Individual Zeroconf PMA tables support. rfe Generate keys one per line. rfe allow table with transformed column anywhere in FROM clause. rfe Shortcut link to search page. rfe Fold Add Column After / Before into dropdown. Table structure: adding primary key doesn't refresh page. rfe SQL formatter. rfe Fast filter improvement: remove "x other results found". No error message on Missing extension mbstring. rfe Builtin transformations and relations. rfe USING BTREE support for HEAP/MEMORY tables. rfe Make "Options Relational" configurable. rfe More details in PDF relation view. rfe Cannot enter connection for federated engine table. rfe Allow SALT in ENCRYPT function. rfe Setting LoginCookieValidity session.gc_maxlifetime. rfe Transformation for JSON. bug Fix isCanvasSupported for new window. rfe Clarify the "Inline" link. rfe Speed up slow triggers by using EVENT_OBJECT_SCHEMA. rfe ON DUPLICATE KEY UPDATE for loading CSV. bug Cannot execute command from console (multi-server installation). rfe linking from information_schema. rfe Relation view: move to main "Structure" page. rfe Designer menu with explicit text. rfe Relations with views like with tables. rfe Browse Field - Search. rfe Provide sanity check for table/column
4.3.13.030 Mar 2015 19:25 hidden: "Show hidden items" is sometimes hidden. Breaks when sorting by multiple columns while using UNION. Missing column when exporting in sql. Broken find and replace. Undefined Index after export schema. Changelog page is not working. Infinite calls to index.php. Invalid links to dev.mysql.com. simulate query fails, but actual query does not.
4.3.12.015 Mar 2015 06:25 minor feature: bug #4746 Right-aligned columns have left-aligned header bug #4779 PMA_Util::parseEnumSetValues fails on enums with UTF-8 values bug Undefined index savedsearcheswork bug #4788 Inline edit of DATE fields with NULL, NULL checkbox is under datepicker bug #4790 DROP TABLE/VIEW IF EXISTS are not tracked bug Compatibility with central columns of version 4.4 bug #4758 Firefox with auth_type to http with multiple server doesn't work anymore bug #4789 Views aren't dropped when copying a database bug #4784 Incomplete bookmark saving bug #4786 SELECT width on relations page
18.104.22.168 Mar 2015 19:25 security: Risk of BREACH attack, see PMASA-2015-1
4.3.11.003 Mar 2015 20:05 minor feature: SQL links are completely wrong. MariaDB: version mismatch. Some images are missing in Designer for original theme. Drizzle: undefined index in mysql_charsets.inc.php. Normal field and multi-line field have different margins. Cannot re-import settings from local storage. SQL error when database list is sorted by additional columns. Notice when timestamp column does not have default value.
4.3.10.021 Feb 2015 04:05 minor feature: bug Undefined index navwork bug #4744 Opening console scroll down the page bug Remove extra column heading in view structure page bug Add missing confirmation when deleting central columns bug Undefined index DisableIS bug #4763 Database export with more than 512 tables fails bug #4769 Previously set column aliases are destroyed if returned to the same table bug #4752 Incorrect page after creating table bug #4771 Central Columns not working, showing error
4.3.9.006 Feb 2015 03:17 minor feature: bug #4728 Incorrect headings in routine editor bug #4730 Notice while browsing tables when phpmyadmin pma database exists, but not all the tables bug #4729 Display original field when using "Relational display column" option and display column is empty bug #4734 Default values for binary fields do not support binary values bug #4736 Changing display options breaks query highlighting bug Undefined index submit_type bug #4738 Header lose align when scrolling in Firefox bug #4741 in ./libraries/Advisor.class.php#184 vsprintf: Too few arguments bug #4743 Unable to move cursor with keyboard in filter rows box bug Incorrect link in doc bug #4745 Tracking does not handle views properly bug #4706 Schema export doesn't handle dots in db/table name bug #3935 Table Header not displayed correct bug #4750 Disable renaming referenced columns bug #4748 Column name center-aligned instead of left-aligned in Relations
4.3.8.025 Jan 2015 07:05 minor feature: bug Undefined constant PMA_DRIZZLE bug #4712 Wrongly positioned date-picker while Grid-Editing bug #4714 Forced ORDER BY for own sql statements bug #4721 Undefined property: stdClass:: version bug #4719 'only_db' not working bug #4700 Error text: Internal Server Error bug #4722 Incorrect width table summary when favorite tables is disabled bug #4716 Collapse all in navigation panel is sometimes broken bug #4724 Cannot navigate in filtered table list bug #4717 Database navigation menu broken when resolution/screen is changing bug #4727 Collation column missing in database list when DisableIS is true bug Undefined index central_columnswork bug Undefined index favorite_tables
4.3.7.016 Jan 2015 04:25 minor feature: bug #4694 js error on marking table as favorite in Safari bug #4695 Changing cfg doesn't update link and title bug Undefined index menuswork bug Undefined index navwork bug Undefined index central_columnswork bug #4697 Server Status refresh not behaving as expected bug Null argument in array_multisort bug #4699 Navigation panel should not hide icons based on 'TableNavigationLinksMode' bug #4703 Unsaved schema page exported as pdf.pdf bug #4707 Call to undefined method PMA_Schema_PDF::dieSchema bug #4702 URL is non RFC-2396 compatible in get_scripts.js.php
4.3.4.030 Dec 2014 03:25 minor feature: bug #4653 Always connection error was shown, on /setup at tab "configuration storage" bug #4661 Drag and drop file import always fails bug #4651 don't open console with esc bug #4664 select min displays 1 row, but reports the table amount of rows returned bug #4666 Undefined indexes in table stucture print view of a view bug #4663 Export missing back ticks for order table name bug #4668 Remove from central columns error bug #4670 CSV import reads both commas and values into first column after first row bug #4642 phpmyadmin often fails to load due to specific load order bug #4671 Unable to move all columns bug #4645 Import of export created with mysqldump bug #4672 "Distinct values" does not page bug #4667 Consistency in borders bug #4658 Illegal string offset bug #4655 Undefined index: collation_connection bug #4673 Delimiter causing page lock
4.3.3.022 Dec 2014 03:15 minor feature: bug The "Recently used tables" setting should be with Nav panel bug #4647 Can't disable Favorites bug #4646 Version Check Broken bug #4630 AJAX request infinite loop bug #4649 Attributes field size smaller than others bug #4622 Cannot remove table ordering on a Mac bug Fix initial replication configuration bug Undefined index central_columnswork bug #4657 Don't have default blowfish_secret bug #4656 Some error popups fade away too quickly bug #4648 Consistency in borders bug cfg no longer necessary bug #4659 Leading and trailing whitespace in column name
4.3.2.012 Dec 2014 13:45 minor feature: bug #4628 PHP error while exporting schema as PDF bug #4631 Server selector submits two server parameter values bug #4629 Problem with custom SQL queries using cookie authentication bug Undefined index central_columnswork bug #4632 Notice in ./libraries/Util.class.php#1916 Undefined index: query bug #4633 Wrong parameter in fetchValue bug #4634 Error reporting creates an infinite loop bug #4635 Token mismatch while creating configuration storage bug #4640 Incorrect reference to PHP 6 bug #3794 failure to handle repeating empty columns when importing ODS bug #4638 Default Export Method setting broken bug #4639 Export SQL missing indentation first field bug #4637 Field Alignment bug #4644 Error when browsing tables
4.3.1.009 Dec 2014 03:15 minor feature: bug #4609 'Show all' checkbox label is not clickable bug #4610 JS error reporting: Hash fragment is reset bug Undefined index menuswork bug #4614 Separator between "Show All" and "Number of rows" disappears bug #4615 SQL highlighting in process list breaks on auto refresh bug #4616 Warning in db structure print view page bug Undefined index navwork, savedsearcheswork, fields bug #4620 Undefined index while adding to the central columns list bug #4618 Page scrolls while GIS visualization is zoomed in/out with mousewheel bug #4613 HHVM: method 'ob_gzhandler' not found bug #4593 Manual "SELECT" doesn't change active table bug #4623 Incomplete PHP OpenSSL support bug #4626 Ctrl + click on a column not in sort triggers a server call to erroneous url bug #4625 "Insufficient space to save the file" on export SQL to file on server bug #4627 "file_get_contents: failed to open stream" after update bug #4617 UI issues with sortable tables bug #4619 SELECT LENGTH FROM `table` does not sort
22.214.171.124 Dec 2014 06:05 security: bug #4612 XSS vulnerability in redirection mechanism bug #4611 DOS attack with long passwords
4.2.13.001 Dec 2014 07:45 minor feature: bug #4604 Query history not being deleted bug #4057 db/table query string parameters no longer work bug #4605 Unseen messages in tracking bug #4606 Tracking report export as SQL dump does not work bug #4607 Syntax error during db_copy operation bug #4608 SELECT permission issues with relations and restricted access
4.2.11.001 Nov 2014 03:15 minor feature: bug ReferenceError: Table_onover is not defined bug #4552 Incorrect routines display for database due to case insensitive checks bug #4259 reCaptcha sound session expired problem bug #4557 PHP fatal error, undefined function __ bug #4568 Date displayed incorrectly when charting a timeline bug #4571 Database Privileges link does not work bug makegrid.js: where_clause is undefined bug #4572 missing trailing slash
126.96.36.199 Oct 2014 03:15 security security: bug #4562 XSS in debug SQL output bug #4563 XSS in monitor query analyzer
4.2.10.012 Oct 2014 03:16 minor feature: bug #4361 Can't change font size bug #4542 Tab key in column name not shown bug PDF export: title not present in PDF bug #4543 Changing column name can break saved "order by" clause bug #4545 trying to favorite table while browser localStorage is disabled throws JS error bug #4259 reCaptcha sound session expired problem bug #4548 Inline editing a field converts tab to spaces bug #4252 Database-level permission bug for db names containing underscores bug #3120 Events are not exported when using xml bug #4554 Grid-editing timestamp column forces datepicker bug #4556 Fast filters for tables, views etc. should be governed by NavigationTreeDisplayItemFilterMinimum
188.8.131.52 Oct 2014 20:11 security: Security: XSS vulnerabilities in table search and table structure pages
4.2.9.021 Sep 2014 03:15 minor feature: bug ajax.js responseHandler: cannot read property of null bug sql.js: str is undefined bug #4524 Allow for direct selection of "0" on the "user overview" page bug #4529 Undefined index: pos bug #4523 tbl_change.js: insert as new row submit type on multiple selected records does not set all AUTO_INCREMENTs to 0 value bug ajax.js responseHandler: another "cannot read property" bug tbl_structure.js "cannot read property"
184.108.40.206 Sep 2014 23:49 security: DOM based XSS that results to a CSRF that creates a ROOT account in certain conditions
4.2.8.031 Aug 2014 23:09 minor bugfix: This bug fix corrects some odd export behavior, an uncaught TypeError, sql.js/server_privileges.js/functions.js property accesses, chart types did not match selected data, ignored AUTO_INCREMENT option and partitioned table in exports, duplicate column names while assigning index, import ODS files with trailing spaces in column names, navigation error in search results.
220.127.116.11 Aug 2014 22:36 security: XSS in table browse page. Self-XSS in enum value editor. Self-XSSes in monitor. Self-XSS in query charts. XSS in view operations page. XSS in relation view.
4.2.731 Jul 2014 18:14 minor bugfix: Broken links on home page. Overlap in navigation panel. Action icons not in horizontal order. s_attention.png is missing. Uncaught TypeError: Cannot call method 'substr' of undefined. PMA 4.2.x and HHVM. mysql_doc_template is not defined.
4.2.508 Jul 2014 05:34 minor bugfix: shell_exec() has been disabled for security reasons. Error while submitting empty query. Fatal error: Class 'PMA_DatabaseInterface' not found. Fixed cookie based login for installations without mcrypt. Incorrect result count when having clause is used. Mcrypt: remove the requirement (64-bit) and the related warning.
ManageYou can also help out here by:
← Update project
or flagging this entry for moderator attention.