Merge remote-tracking branch 'origin/master'

[phpmyadmin.git] / ChangeLog

phpMyAdmin - ChangeLog
======================

4.5.0.0 (not yet released)
+ rfe       Pagination for GIS visualization
+ rfe #1570 Usability improvements for console
+ rfe #1614 Access to Add columns text-box and Go button when creating table
+ rfe #1306 Add lock tables, disable keys options
+ rfe #1609 Additional page locking
+ rfe #1620 Support MySQL 5.7 syntax for password change
+ rfe #1626 Display/edit index name
+ rfe #1625 Toggle autocomplete of table and column names
+ rfe #933  Manage multiple variable in bookmarked query
+ rfe #947  Show edit/delete also when there is calculated column
+ rfe #1619 Show databases as list instead of as dropdown when no database is selected
+ rfe       Optional dark theme for the console
+ rfe #354  PDF schema sort options
+ rfe #844  Structure in PDF export
+ rfe #1635 Have ZeroConf create phpmyadmin DB if possible
+ rfe #763  Warning before silent data conversion/truncation
+ rfe #1650 Support a default page in designer
+ rfe #1651 Allow copying mutiple rows
+ rfe #1643 No SQL query for loading data
+ rfe #1653 New data validation feature and datetime type
+ rfe #1632 Importing and exporting pMA meta-data
+ rfe #1639 Add grouping to stored procedures in the navigation tree
+ rfe #1655 Support IPv6 browser transformation
+ rfe       Option groups for 'With selected' dropdown in database structure page
+ rfe #1661 Support checksum table
+ rfe #1380 Support for Paramaters with raw SQL
+ rfe #1146 Show original size of truncated columns
+ rfe #1413 Explain analyzer
+ rfe #1485 Add "Drop partition" option to partition tools
+ rfe #1668 Procedures window shift-click should select multiple rows
+ rfe #1669 Designer: "Sticky" menu option
+ rfe #1671 Directly show table comments in structure view
+ rfe #1559 Page-related settings
+ rfe #657  Alter privileges when renaming or copying a database
- bug #4910 Slowness due to large number of routines
- bug #4913 GROUP_CONCAT shown as GROUPBY_CONCAT in CodeMirror autocomplete
+ rfe #1242 Work with --skip-grant-tables
- bug #4922 "Sort by key" drop-down value is lost
+ rfe #1673 Browse: improve display of right-aligned data
- bug #4921 Textarea rows settings ignored Features > Text fields
+ rfe #1672 MIME types should be lower case
- bug #4872 Drop table doesn't remove the table name from navigation bar
+ rfe #1675 MySQL and MariaDB functions INET6_ATON and INET6_NTOA
- bug       Link to get real row counts of all the views in a db, at once
- bug #4932 Drizzle version numbers
+ rfe #701  Rewrite print view using CSS; fixes print view failures on multi-query statements
+ rfe #1677 Support spatial indexes in table create form
+ rfe #1359 Use CTRL or ALT plus arrow keys for navigation in grid editor
+ rfe       Remove support for Shift + Click on function name to apply to all rows in insert/edit page
+ rfe #1634 Don't group tables in tree if the result has only one group
- bug #4946 When hide table structure actions is false, action should be in a row
+ rfe #726  Batch changing the collation of each column in a table
- bug #4510 QBE generates wrong query
+ rfe #1594 Use plain English descriptors instead of script names for icon link destinations
+ rfe #1541 Disable foreign key checks for some operations
- bug #4957 "With selected" links doesn't work in table browse
- bug #4795 Query builder: missing joint for the intermediary table
+ rfe #1551 Integrate SQL debugging into console
- bug #4963 Improve/restore non-unique index row editing
- bug #4966 MySQL errors are not shown when DebugSQL is enabled
+ rfe #342  One file per table and one file per database export option
+ rfe #1060 Designer settings should be part of saved state
+ rfe #1557 Option to remove functions, procedures, etc., from navigation tree
+ rfe #689  Column privileges and update
+ rfe #1531 Cant use external config file
+ rfe #1552 CSV import: Allow "Columns escaped with" to be optional
+ rfe #1561 Being able to use multiple servers at the same time when using cookie auth
+ rfe #1603 select structure or data for each table when exporting
- bug #4916 Autocomplete completes the original table name when joining multiple aliased tables
+ rfe       Remove configuration storage data related to a user upon deleting the user
+ rfe #1685 Improved processlist for mariadb
+ rfe #1686 Warn about "Any user" potential problem
+ rfe #1683 Hide/diable edit links for read-only variables
+ rfe #1680 Human readable/writable URLs (html5 api)
+ rfe       Support virtual columns in MySQL 5.7.5+
+ rfe #1517 Support for virtual/persistent columns in MariaDB
- bug #4984 Undefined <feature>work upon upgrade to new version

4.4.13.0 (not yet released)
- issue #1808 "Improve table structure" generates invalid SQL

4.4.12.0 (2015-07-20)
- bug       Saved chart image does not have a proper name or an extension
- bug #4976 Timepicker CSS issues in Original theme
- bug #4975 Move/Copy/Rename operations on Table/Db fail on Drizzle server
- bug #4826 Two inline edit windows
- bug #4979 Problem when import *.ods file
- bug       Add missing head tag
- bug #4985 Column headers move when scrolling

4.4.11.0 (2015-07-06)
- bug       Missing selected/entered values when editing active options in visual query builder
- bug #4969 Autoload from prefs_storage not behaving properly
- bug #4972 Incorrect length computed for binary data
- bug       Remove character set from create_tables_drizzle.sql
- bug #4973 Users overview needs clarification
- bug #4974 Creating a database from console doesn't update navigation panel
- bug #4844 FAQ 1.17 needs an update

4.4.10.0 (2015-06-17)
- bug #4950 Issues in database selection for replication
- bug #4951 Trying to save chart as image crashes the browser
- bug #4953 cant drag sql.gz file onto import input
- bug #4960 Table creation results in GET request with missing server parameter that invalidates the session
- bug #4961 Javascript error when Designer is opened
- bug #4962 Insert by foreign key scrolls page to top
- bug #4955 Clicking on the navi logo does not always work
- bug       External URL for $cfg['NavigationLogoLink'] causes JavaScript error when clicked

4.4.9.0 (2015-06-04)
- bug #4920 relation view doesn't list fields of table in other database
- bug #4905 Sorting by an alias
- bug #4931 False error before entering reCAPTCHA
- bug #4909 central column with multiple server
- bug #4937 Custom export with backquotes off is not working
- bug #4908 Reverse proxy: infinite internal redirect (added warning in doc)
- bug #4942 Export to gzip saves plain text under Chrome

4.4.8.0 (2015-05-28)
- bug       Allow accessing visual query builder when pmadb is not configured
- bug #4893 Nav tree line alignment issue
- bug #4911 Lock page icon is not shown after fresh reload
- bug #4912 "Highlight pointer" and "Row marker" doesn't work properly
- bug       Browse foreigners window goes out of the window
- bug #4918 Date field popup dialog position bug
- bug       In /setup, PMA_messages is not defined
- bug #4924 Recaptcha failure
- bug #4930 Database copy doesn't work for tables with more than one FULLTEXT index
- bug #4929 Edit view structure doesn't load the algorithm
- bug #4923 Do not limit table comments to 60 characters

4.4.7.0 (2015-05-16)
- bug #4876 Settings issues (Favorite tables shown twice in Settings)
- bug #4896 Non-styled error page when following results link
- bug #4894 Deleting without confirmation
- bug #4858 Issues with SQL autocomplete
- bug #4897 Column hint in SQL autocomplete is sometimes not shown
- bug #4898 JS error after selecting a field and press Enter
- bug       Honor proxy settings when getting Git commit information
- bug       Missing title on link
- bug #4512 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
- bug #4367 Import status infinite loop
- bug #4902 Designer: Loading does not work
- bug #4904 Setup: Overview > Display does not work
- bug #4906 Designer: pages from all databases

4.4.6.1 (2015-05-13)
- bug #4899 [security] CSRF vulnerability in setup
- bug #4900 [security] Vulnerability allowing man-in-the-middle attack

4.4.6.0 (2015-05-07)
- bug #4890 webkitStorageInfo and webkitIndexedDB is deprecated
- bug #4892 Undefined variable: unique_conditions
- bug #4891 CSV Import ignores "Replace table data with file" checkbox

4.4.5.0 (2015-05-05)
- bug       Table overhead stats: missing space before the unit
- bug       Fix resize icon in Designer
- bug #4879 Exit fullscreen in Designer does not change the button text
- bug #4880 Designer icons missing when using original theme
- bug #4878 Column list of central columns is not cleared
- bug #4881 jQuery dialogs of the Designer are not displayed in fullscreen
- bug #4883 Search function breaks when searching for certain combinations of backslashes and slashes
- bug #4830 Maximum execution time exceeded in Util.class.php (better fix)
- bug #4885 Some icons are above the overlay of jQuery dialogs
- bug #4886 Clicking on external links in advisor rules give JS error
- bug #4888 Filter in central columns does not work in other languages

4.4.4.0 (2015-04-26)
- bug #4863 Edit vs Change
- bug #4859 Don't scroll (to bottom) when editing multiple rows
- bug #4862 Misaligned Inline edit field
- bug #4861 Use of undefined constant PMA_DRIZZLE
- bug #4865 sprintf(): Too few arguments
- bug #4866 Limit column ordering in index edit dialog
- bug #4867 Incorrect ALTER TABLE statement generated
- bug #4870 Inconsistency in 'Ignore' checkbox in insert page
- bug #4869 Drop column action not asking to confirm
- bug #4871 Error on creating table
- bug       Undefined index: Rows

4.4.3.0 (2015-04-20)
- bug #4851 PHP errors in login dialogue
- bug #4207 json_encode error due to strftime returning non utf8 chars in Windows 8.1 Chinese version
- bug #4845 White screen (Cloudflare)
- bug #4794 Server error viewing table content
- bug       Fix issues related to number of decimal places in time
- bug #4853 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
- bug #4857 Alter table after changing column name error
- bug #4830 Maximum execution time exceeded in Util.class.php

4.4.2.0 (2015-04-13)
- bug #4835 PMA_hideShowConnection not called after submit_num_fields
- bug #4836 Server warning after moving from console to direct clicks
- bug #4837 Duplicate new version notification when using the "Back" button
- bug #4839 DOC link in setting is broken
- bug #4841 Status page: Mislukte pogingen per uur value is incorrect
- bug       MIME Transformation link fixed
- bug #4838 Prevents console window from moving out of the screen height
- bug #4829 Create procedure via SQL Editor not more possible
- bug #4833 CSS and Javascript are not compressed
- bug #4849 Functions accessed from navigation do not load on ajax dialog
- bug #4850 Relation view on 1920

4.4.1.1 (2015-04-08)
- bug #4846 Web server's error log is flooded

4.4.1.0 (2015-04-07)
- bug #4813 MySQL 5.7.6 and the Users menu tab
- bug #4818 MySQL 5.7.6 and changing the password for another user
- bug #4819 Request URI too large
- bug #4814 MySQL 5.7.6 and Databases
- bug       Use 'server' parameter in console to work in multi server environments
- bug       Missing tooltip in monitor
- bug       Missing sort icons in monitor
- bug #4805 Inline edit broken when using functions in query
- bug #4821 Timed-out import fails to restart when file represented
- bug #4754 pMA DB not detected properly
- bug #4825 Datepicker missing when changing number of rows on Insert page
- bug #4824 INNODB STATUS page is empty
- bug #4828 JavaScript is loaded in wrong order
- bug #4827 TEXT formatting doesn't work after inline editing
- bug #4822 Compress when php.ini output_buffering is active
- bug #4832 Sorting distinct values result loses links
- bug #4834 Do not attach token to css requests to improve caching

4.4.0.0 (2015-04-01)
+ rfe #1553 InnoDB presently supports one FULLTEXT index creation at a time
+ rfe #1562 Allow tracking multiple table at once from database level tracking page
+ rfe #1564 Improve action message on Tracking page
+ rfe #1566 Change value of "Number of rows:" when "Show all" is checked
+ rfe       Focus console by clicking on white space
+ rfe #1507 Part 1: Cycle through console history with keyboard up/down arrows
+ rfe #1579 Default to primary key when adding relation
+ rfe #1572 User prefs: Diff-friendly JSON for config
+ rfe #1567 Sever Variables Table UI Improvements
- bug #4675 phpMyAdmin should be able to work without 'examples' DIR - move SQL scripts to sql directory
+ rfe #1578 Warn about reserved word only when a column is created
+ rfe #1590 Recaptcha API v2
+ rfe #1580 Individual Zeroconf PMA tables support
+ rfe #1525 Generate keys one per line
+ rfe #347  allow table with transformed column anywhere in FROM clause
+ rfe #1591 Shortcut link to search page
+ rfe #1568 Fold Add Column After / Before into dropdown
- bug #4705 Table structure: adding primary key doesn't refresh page
+ rfe #1582 SQL formatter
+ rfe #1597 Fast filter improvement: remove "x other results found"
- bug #4720 No error message on Missing extension mbstring
+ rfe #801  Builtin transformations and relations
+ rfe #767  USING BTREE support for HEAP/MEMORY tables
+ rfe #1596 Make "Options > Relational" configurable
+ rfe #719  More details in PDF relation view
+ rfe #1096 Cannot enter connection for federated engine table
+ rfe #954  Allow SALT in ENCRYPT function
+ rfe #1260 Setting LoginCookieValidity > session.gc_maxlifetime
+ rfe       Transformation for JSON
- bug       Fix isCanvasSupported for new window
+ rfe #1600 Clarify the "Inline" link
+ rfe #1179 Speed up slow triggers by using EVENT_OBJECT_SCHEMA
+ rfe #1192 ON DUPLICATE KEY UPDATE for loading CSV
- bug       Cannot execute command from console (multi-server installation)
+ rfe #1208 linking from information_schema
+ rfe #1235 Relation view: move to main "Structure" page
+ rfe #1558 Designer menu with explicit text
+ rfe #937  Relations with views like with tables
+ rfe #1241 Browse Field -> Search
+ rfe #723  Provide sanity check for table/column names (table names)
+ rfe #1312 SessionTimeZone configuration directive
- bug       Add missing confirmation when deleting tracking report entries
+ rfe       Ability to disable foreign key check when emptying tables
+ rfe #1549 Reset auto-increment when exporting structure
+ rfe #1602 Recover query in redaction after session end
+ rfe #1605 After database creation, go to database structure page
+ rfe #1604 Show PHP version
- bug #4770 Multiple delete on table browse ignoring foreign key checkbox
+ rfe       CodeMirror based SQL editor as an input transformation
+ rfe #1275 CodeMirror based JSON editor as an input transformation
+ rfe #685  Editor for HTML content
+ rfe #1595 make professional code editor suggestion
+ rfe #1606 processlist filter
+ rfe       Change tracking activation status from db level tracking page
+ rfe #1207 Export users associated with a specific schema/database
+ rfe #1575 "Disable database expansion" : unclear directive name and
explanation
+ rfe #1607 Tool tip for lock icon when making changes to a page
+ rfe #1327 Hide 'Add user' link if user does not have privileges
+ rfe #501  Support for SSL GRANT option
+ rfe #1608 Central columns allowing setting SIGNED / UNSIGNED attribute for integer
+ rfe #1441 Add regexp match when using AllowArbitraryServer
- bug #4806 Unable to work with two different servers in two tabs

4.3.14.0 (not yet released)


4.3.13.0 (2015-03-29)
- bug #4803 "Show hidden items" is sometimes hidden
- bug #4807 Breaks when sorting by multiple columns while using UNION
- bug #4798 Missing column when exporting in sql
- bug #4810 Broken find and replace
- bug #4804 Undefined Index after export schema
- bug #4802 Changelog page is not working
- bug #4815 Infinite calls to index.php
- bug #4820 Invalid links to dev.mysql.com
- bug #4718 simulate query fails, but actual query does not

4.3.12.0 (2015-03-14)
- 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

4.3.11.1 (2015-03-04)
- bug       [security] Risk of BREACH attack, see PMASA-2015-1

4.3.11.0 (2015-03-02)
- bug #4774 SQL links are completely wrong
- bug #4768 MariaDB: version mismatch
- bug #4777 Some images are missing in Designer for original theme
- bug #4767 Drizzle: undefined index in mysql_charsets.inc.php
- bug #4753 Normal field and multi-line field have different margins
- bug #4760 Cannot re-import settings from local storage
- bug #4778 SQL error when database list is sorted by additional columns
- bug #4780 Notice when timestamp column does not have default value

4.3.10.0 (2015-02-20)
- 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.0 (2015-02-05)
- 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 (Safari 5.0.5 Mac)
- bug #4750 Disable renaming referenced columns
- bug #4748 Column name center-aligned instead of left-aligned in Relations

4.3.8.0 (2015-01-24)
- 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.0 (2015-01-15)
- bug #4694 js error on marking table as favorite in Safari (in private mode)
- bug #4695 Changing $cfg['DefaultTabTable'] 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.6.0 (2015-01-07)
- bug       Undefined index notices while configuring recent and favorite tables
- bug #4687 Designer breaks without configuration storage
- bug #4686 Select elements flicker and selects something else
- bug #4689 Setup tool creates "pma__favorites" incorrectly
- bug #4685 Call to a member function isUserType() on a non-object
- bug #4691 Do not include console when no server is selected
- bug #4688 File permissions in archive
- bug #4692 Dynamic javascripts gives 500 when db selected

4.3.5.0 (2015-01-05)
- bug       Auto-configuration: tables were not created automatically
- bug #4677 Advanced feature checker does not check for favorite tables feature
- bug #4678 Some of the data stored in configuration storage are not deleted upon db or table delete
- bug #4679 Setup does not allow providing a name for favorites table
- bug #4680 Number of favorite table are not configurable in setup
- bug #4681 'Central columns table' field in setup does not have a description
- bug #4318 Default connection collation and sorting
- bug #4683 Relational data is not properly updated on table rename
- bug #4655 Undefined index: collation_connection (second patch)
- bug #4682 4.3.3 & 4.3.4 Import sql created by mysqldump fails on foreign keys
- bug #4676 Auto-configuration issues
- bug #4416 New lines are removed when grid editing (part two: TEXT)

         --- Older ChangeLogs can be found on our project website ---
                     http://www.phpmyadmin.net/old-stuff/ChangeLogs/

# vim: et ts=4 sw=4 sts=4
# vim: ft=changelog fenc=utf-8
# vim: fde=getline(v\:lnum-1)=~'^\\s*$'&&getline(v\:lnum)=~'\\S'?'>1'\:1&&v\:lnum>4&&getline(v\:lnum)!~'^#'
# vim: fdn=1 fdm=expr