May 4th, 2012· bug #3510784 [edit] Limit clause ignored when sort order is remembered
· bug #3511471 [interface] View name not seen in navi panel (MySQL 5.1)
· bug #3512916 [display] Right frame reloads after displaying SQL result(zero ro
· ws)
· bug [interface] Fixed missing Codemirror for inline query edit when exporting
· a result set
· bug #3514490 [auth] Multiple Navigation panels bug still present
· bug #3515181 [users] Error in create user + underscore + create database
· bug #3515666 [display] Profiling chart shows wrong data
· bug #3516037 [auth] JS includes missing in auth config error page
· bug #3516183 [display] Missing image extension
· bug [display] Added missing icons in original theme
· bug #3516761 [edit] Query error after search
· bug #3516405 [display] Chart title is getting wrong within chart export
· bug #3517021 [interface] Header links except 'More' hide after closing dialog
· bug #3516817 [interface] "More" actions in table structure
· bug #3518484 [privileges] PMA_sqlAddSlashes() does not quote the table names c
· orrectly
· bug #3518983 [designer] Error messages do not appear in the Designer
· bug #3519747 [interface] Suhosin patch warning incorrectly displayed
· bug #3520107 [interface] Server status page: Incorrect dialog box titles
· bug #3516089 [structure] DROP does not work on defective VIEWs
April 9th, 2012· browse-mode improvements
· grid editing
· remember recent tables
· remember last sort order by table
· flexible column width
· reorder columns
· more compact navigation bar
· AJAXification of many operations
· reorganised server status page, with server monitoring
· improved support for stored routines, events and triggers
· openGIS support
· zoom-search in table search
· Drizzle support
· improved ENUM/SET editor
March 30th, 2012· [security] Fixed local path disclosure vulnerability, see PMASA-2012-2
February 20th, 2012· [security] XSS in replication setup, see PMASA-2012-1
February 15th, 2012· bug #3460090 [interface] TextareaAutoSelect feature broken
· patch #3375984 [export] PHP Array export might generate invalid php code
· bug #3049209 [import] Import from ODS ignores cell that is the same as cell before
· bug #3463933 [display] SELECT DISTINCT displays wrong total records found
· patch #3458944 [operations] copy table data missing SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
· bug #3469254 [edit] Setting data to NULL and drop-downs
· bug #3477063 [edit] Missing set fields and values in generated INSERT query
· bug #3460867 [libraries] license issue with TCPDF (updated to 5.9.145)
January 27th, 2012· rfe #2021981 [interface] Add support for mass prefix change.
· "up to date" message on main page when current version is up to date
· Update to jQuery 1.6.2
· Patch #3256122 [search] Show/hide db search results
· Patch #3302354 Add gettext wrappers around a message
· Remove deprecated function PMA_DBI_get_fields
· rfe #2098927 Remember recent tables
· rfe #3078542 Remember the last sort order for each table
· AJAX for Create table in navigation panel
· rfe #3310562 Wording about Column
· AJAX for Add a user in Database privileges
· Patch #3271804 for rfe #3177495, new DisableMultiTableMaintenance directive
· interface] Reorganised server status page.
· interface] Changed way of generating charts.
· rfe #939233 [interface] Flexible column width
· interface] Mouse-based column reordering in query results
· AJAX for Insert to a table from database Structure page
· Patch #3316969 PMA_ajaxShowMessage() does not respect timeout
· AJAX for Change on multiple rows in table Browse
· interface] Improved support for stored routines
· display] More options for browsing GIS data
· interface] Support for spatial indexes
· display] GIS data visualization
· AJAX for table structure multiple-column change
· AJAX for table structure index edit
· Show/hide indexes in table Structure
· More compact navigation bar
· Display direction (horizontal/vertical) no longer displayed by default
· Shift/click support in database Structure
· Show/hide column in table Browse
· bug #3353856 [AJAX] AJAX dialogs use wrong font-size
· bug #3354356 [interface] Timepicker does not work in AJAX dialogs
· AJAX for table Structure Indexes Edit
· AJAX for table Structure column Change
· interface] Improved support for events
· interface] Improved support for triggers
· interface] Improved server monitoring
· AJAX for table Structure column Add
· AJAX for table Operations copy table
· bug #3380946 [export] no uid Query result export (Suhosin limit)
· Grid editing in browse mode (replaces row inline edit)
· Zoom-search in table Search
· interface] Editor for GIS data
· import] Import GIS data from ESRI Shapefiles
· interface] 'Function based search' for GIS data
· Support Drizzle database
· bug #3356456 [interface] Interface problems for queries having LIMIT clauses
· interface] Remove DefaultPropDisplay feature
· bug #3299486 [prettyprint] Order By in a query containing comment character
· interface] Improved ENUM/SET editor
· patch #3428376 [pmadb] pmadb on a different MySQL server
· patch #3410688 [interface] Improving field size for character columns
· usability] Removed an unnecessary AJAX request from database search
· bug #3302419 [navi] Tabs break when squeezing page
· rfe #3406797 [navi] Stick table tools to top of page on scroll
· rfe #1632106 [interface] Improved error handling
· patch #3432835 [interface] Add useful intermediate pages to pageselector
· interface] Improved index editor
· View editing via a generated ALTER VIEW
· bug #3408377 [interface] Deleting table from the DB does not change the table counter
· rfe #3438266 [designer] Toggle for relation lines
· bug #3442069 [AJAX] database list not updated after adding/deleting a user + database
· bug #3461750 [edit] Sort by key generates wrong sql with limit clause
· bug #3340842 [structure] Error dropping index of non-existing column
· bug #3093145 [display] Page through rows returned from a view
· patch #3303195 [interface] Checkbox to have SQL input remain
· patch #3472899 [export] Fixed CSV escape for the export
· patch #3475424 [import] Fixed CSV escape for the import
January 7th, 2012· browse-mode improvements
· grid editing
· remember recent tables
· remember last sort order by table
· flexible column width
· reorder columns
· more compact navigation bar
· AJAXification of many operations
· reorganised server status page, with server monitoring
· improved support for stored routines, events and triggers
· openGIS support
· zoom-search in table search
· Drizzle support
· improved ENUM/SET editor
December 22nd, 2011· bug #3442028 [edit] Inline editing enum fields with null shows no dropdown
· bug #3442004 [interface] DB suggestion not correct for user with underscore
· bug #3438420 [core] Magic quotes removed in PHP 5.4
· bug #3398788 [session] No feedback when result is empty (signon auth_type)
· bug #3384035 [display] Problems regarding ShowTooltipAliasTB
· bug #3306875 [edit] Can't rename a database that contains views
· bug #3452506 [edit] Unable to move tables with triggers
· bug #3449659 [navi] Fast filter broken with table tree
· bug #3448485 [GUI] Firefox favicon frameset regression
· [core] Better compatibility with mysql extension
· [security] Self-XSS on export options (export server/database/table)
· [security] Self-XSS in setup (host parameter),
December 15th, 2011· bug #3442028 [edit] Inline editing enum fields with null shows no dropdown
· bug #3442004 [interface] DB suggestion not correct for user with underscore
· bug #3438420 [core] Magic quotes removed in PHP 5.4
· bug #3398788 [session] No feedback when result is empty (signon auth_type)
· bug #3384035 [display] Problems regarding ShowTooltipAliasTB
· bug #3306875 [edit] Can't rename a database that contains views
· bug #3452506 [edit] Unable to move tables with triggers
· bug #3449659 [navi] Fast filter broken with table tree
· bug #3448485 [GUI] Firefox favicon frameset regression
· core] Better compatibility with mysql extension
· security] Self-XSS on export options (export server/database/table), see PMASA-2011-20
· security] Self-XSS in setup (host parameter), see PMASA-2011-19
December 2nd, 2011· bug #3425230 [interface] enum data split at space char (more space to edit)
· bug #3426840 [interface] ENUM/SET editor can't handle commas in values
· bug #3427256 [interface] no links to browse/empty views and tables
· bug #3430377 [interface] Deleted search results remain visible
· bug #3428627 [import] ODS import ignores memory limits
· bug #3426836 [interface] Visual column separation
· bug #3428065 [parser] TRUE not recognized by parser
· patch #3433770 [config] Make location of php-gettext configurable
· patch #3430291 [import] Handle conflicts in some open_basedir situations
· bug #3431427 [display] Dropdown results - setting NULL does not work
· patch #3428764 [edit] Inline edit on multi-server configuration
· patch #3437354 [core] Notice: Array to string conversion in PHP 5.4
· [interface] When ShowTooltipAliasTB is true, VIEW is wrongly shown as the view name in main panel db Structure page
· bug #3439292 [core] Fail to synchronize column with name of keyword
· bug #3425156 [interface] Add column after drop
· [interface] Avoid showing the password in phpinfo()'s output
· bug #3441572 [GUI] 'newer version of phpMyAdmin' message not shown in IE8
· bug #3407235 [interface] Entering the key through a lookup window does not reset NULL
· [security] Self-XSS on database names (Synchronize), see PMASA-2011-18
· [security] Self-XSS on database names (Operations/rename), see PMASA-2011-18
· [security] Self-XSS on column type (Create index), see PMASA-2011-18
· [security] Self-XSS on column type (table Search), see PMASA-2011-18
· [security] Self-XSS on invalid query (table overview), see PMASA-2011-18
November 11th, 2011· [security] Fixed possible local file inclusion in XML import
October 24th, 2011· bug #3418610 [interface] Links in navigation when $cfg['MainPageIconic'] = false
· bug #3418849 [interface] Inline edit shows dropdowns even after closing
· bug [view] View renaming did not work
· bug [navi] Wrong icon for view (MySQL 5.5)
· bug #3420229 [doc] Missing documentation section
· bug #3423725 [pdf] Broken PDF file when exporting database to PDF
· core] Allow to set language in URL
· bug #3425184 [doc] Fix links to PHP documentation
· bug #3426031 [export] Export to bzip2 is not working
October 17th, 2011· patch #3404173 InnoDB comment display with tooltips/aliases
· bug #3404886 [navi] Edit SQL statement after error
· bug #3403165 [interface] Collation not displayed for long enum fields
· bug #3399951 [export] Config for export compression not used
· bug #3400690 [privileges] DB-specific privileges won't submit
· bug #3410604 [config] Configuration storage incorrect suggested table name
· bug #3383572 [interface] Cannot execute saved query
· bug #3411535 [display] Full text button unchecks results display options
· bug #3411224 [display] Broken binary column when 'Show binary contents' is not set
· bug #3411633 [core] Call to undefined function PMA_isSuperuser()
· bug #3413743 [interface] Display options link missing after search
· bug #3324161 [core] CSP policy causing designer JS buttons to fail
· bug #3412862 [relation] Relations/constraints are dropped/created on every change
· bug #3390832 [display] Delete records from last page breaks search
· bug #3392150 [schema] PMA_User_Schema::processUserChoice() is broken
· bug #3414744 [core] External link fails in 3.4.5
· patch #3314626 [display] CharTextareaRows is not respected
· bug #3417089 [synchronize] Extraneous db choices
· [security] Fixed local path disclosure vulnerability, see PMASA-2011-15
· [security] Fixed XSS in setup (host/verbose parameter), see PMASA-2011-16
September 9th, 2011· bug #3375325 [interface] Page list in navigation frame looks odd
· bug #3313235 [interface] Error div misplaced
· bug #3374802 [interface] Comment on a column breaks inline editing
· patch #3383711 [display] Order by a column in a view doesn't work in some cases
· bug #3386434 [interface] Add missing space to server status
· core] Remove library PHPExcel, due to license issues
· export] Remove native Excel export modules (xls and xlsx formats)
· import] Remove native Excel import modules (xls and xlsx formats)
· bug #3392920 [edit] BLOB emptied after editing another column
· security] Fixed XSS in Inline Edit on save action
· security] Fixed XSS with db/table/column names
August 25th, 2011· bug #3323060 [parser] SQL parser breaks AJAX requests if query has unclosed quotes
· bug #3323101 [parser] Invalid escape sequence in SQL parser
· bug #3348995 [config] $cfg['Export']['asfile'] set to false does not select asText option
· bug #3340151 [export] Working SQL query exports error page
· bug #3353649 [interface] "Create an index on X columns" form not validated
· bug #3350790 [interface] JS error in Table->Structure->Index->Edit
· bug #3353811 [interface] Info message has "error" class
· bug #3357837 [interface] TABbing through a NULL field in the inline mode resets NULL
· remove version number in /setup
· bug #3367993 [usability] Missing "Generate Password" button
· bug #3363221 [display] Missing Server Parameter on inline sql query
· bug #3367986 [navi] Drop field -> lost active table
· remove misleading comment on the "Rename database" interface
· bug #3374374 [interface] Fix footnote for inexact count while browsing
· bug #3372807 [interface] Fix security warning link in setup
· bug #3374347 [display] Backquotes in normal text on import page
· bug #3358750 [core] With Suhosin, urls are too long in edit links
· security] Missing sanitization on the table, column and index names leads to XSS vulnerabilities, see PMASA-2011-13
July 25th, 2011· [security] Fixed XSS vulnerability, see PMASA-2011-9
· [security] Fixed local file inclusion vulnerability, see PMASA-2011-10
· [security] Fixed local file inclusion vulnerability and code execution, see PMASA-2011-11
· [security] Fixed possible session manipulation in swekey authentication, see PMASA-2011-12
July 4th, 2011· [security] Fixed possible session manipulation in swekey authentication, see PMASA-2011-5
· [security] Fixed possible code injection incase session variables are compromised, see PMASA-2011-6
· [security] Fixed regexp quoting issue in Synchronize code, see PMASA-2011-7
· [security] Fixed filtering of a file path, which allowed for directory traversal, see PMASA-2011-8
June 27th, 2011· bug #3311170 [sync] Missing helper icons in Synchronize
· patch #3304473 [setup] Redefine a lable that was wrong
· bug #3304544 [parser] master is not a reserved word
· bug #3307616 [edit] Inline edit updates multiple duplicate rows
· patch #3311539 [edit] Inline edit does not escape backslashes
· bug #3313210 [interface] Columns class sometimes changed for nothing
· patch #3313326 [interface] Some tooltips do not disappear
· bug #3315720 [search] Fix search in non unicode tables
· bug #3315741 [display] Inline query edit broken
· patch #3317206 [privileges] Generate password option missing on new accounts
· bug #3317293 [edit] Inline edit places HTML line breaks in edit area
· bug #3319466 [interface] Inline query edit does not escape special characters
· minor XSS (require a valid token)
June 7th, 2011· bug #3301249 [interface] Iconic table operations does not remove inline edit label
· bug #3303869 [interface] Unnecessary scrolling on Databases page
· patch #3303813 [setup] Define a label that was missing
· bug #3305606 [interface] Show all button wraps on privileges page
· bug #3305517 [config] Config for export compression not used
· bug #3305883 [interface] Table is dropped regardless of confirmation
· [auth] Fixed error handling for signon auth method.
· bug #3276001 [core] Avoid caching of index.php.
· bug #3306958 [interface] Unnecessary Details slider
· bug #3308476 [interface] "Show all" not persistent after a sort
· bug #3308072 [auth] Version disclosure to anonymous visitors
· bug #3306981 [interface] pmahomme and table statistics
May 21st, 2011· bug #3301108 [interface] Synchronize and already configured host
· bug #3302457 Inline edit and $cfg['PropertiesIconic']
· Patch #3302313 Show a translated label
· bug #3300981 [navi] Table filter is case sensitive
· bug #3285929 [privileges] Revert temporary fix
· bug #3302872 [synchronize] Synchronize and user name
· bug #3302733 [core] Some browsers report an insecure https connection
· security] Make redirector require valid token
May 12th, 2011· RFE #2890226 [view] Enable VIEW rename
· RFE #838637 [privileges] Export a user's privileges
· core] Updated mootools to fix some glitches with Safari.
· RFE #2816943 [interface] Add REGEXP ^...$ to select dialog.
· RFE #2924956 [interface] Add insert ignore option to editing row.
· RFE #2838080 [interface] Show warning when javascript is disabled.
· RFE #2823707 [edit] Call UUID function separately to show it in insert.
· RFE #2420684 [export] Allow export of timestamps in UTC.
· core] Remove config data from session as it brings chicken-egg problem.
· core] Cookie path now honors PmaAbsoluteUri.
· RFE #2393597 [core] phpMyAdmin honors https in PmaAbsoluteUri.
· RFE #1778337 [core] Try moving tables by RENAME and fail to CREATE/INSERT if that fails.
· RFE #1721189 [core] Force reload js on code change.
· RFE #1954161 [interface] Do not display long numbers in server status.
· RFE #2033616 [edit] Add option to just display insert query.
· RFE #1435032 [interface] Move SSL status to the end, it is usually empty.
· RFE #1340812 [interface] Show numbers of columns in table structure.
· RFE #1186511 [inrerface] Add link to reload navigation frame.
· RFE #2936156 [auth] Signon authentication forwards error message through session data.
· RFE #2835109 [interface] Move ^1 to the end of message.
· RFE #854911 [interface] Grey out non applicable actions in structure
· interface] Allow to create new table from navigation frame (in light mode).
· RFE #1025696 [browse] Add direct download of binary fields.
· browse] Properly display NULL value for BLOB.
· RFE #1516803 [edit] Allow to set BLOB to/from NULL with ProtectBinary.
· edit] Do not default to UNHEX when using file upload.
· RFE #1379201 [core] Add option to configure session_save_path.
· interface] Provide links to documentation in highlighted SQL.
· interface] It is now possible to bookmark most pages in JS capable browser.
· bug #2936482 [core] Fix SSL detection.
· RFE #2937850 [doc] Add some hints to chk_rel.php for quick setup.
· RFE #2938579 [interface] Add class to some elements for easier theming.
· RFE #2937840 [doc] Add some interesting configs to config.sample.inc.php.
· RFE #2792992 [doc] Added advice to re-login after changing pmadb settings
· patch #2952353 [interface] Prefill "Copy table to" in tbl_operations.php, thanks to iinl
· lang] Add English (United Kingdom) translation, thanks to Robert Readman.
· patch #2948421 [auth] HTTP Basic auth realm name,
· thanks to Harald Jenny
· bug #2954916 [interface] Do not insert doc links to not formatted SQL.
· lang] Chinese Simplified update, thanks to Shanyan Baishui
· lang] Turkish update, thanks to Burak Yavuz
· RFE #2963310 [interface] Focus TEXTAREA "sql_query" on click on "SQL" link
· lang] Uzbek update, thanks to Orzu Samarqandiy
· RFE #2958013 [import] After import, also list uploaded filename, thanks
· to Pavel Konnikov and Herman van Rink
· patch #2974341 [structure] Clicking on table name in db Structure should
· Browse the table if possible, thanks to bhdouglass
· patch #2975533 [search] New search operators, thanks to
· Martynas Mickevicius
· patch #2967320 [designer] Colored relations based on the primary key,
· thanks to GreenRover
· core] Provide way for vendors to easily change paths to config files.
· patch #2979922, RFE #2804874 [interface] Add inline query editing, thanks to Muhammd Adnan.
· bug #2966752 [setup] Allow to configure changes tracking in setup script.
· patch #2981165 [edit] Optionally disable the Type column,
· thanks to Brian Douglass
· patch #2984058 [edit] Buttons for quicky creating common SQL queries, thanks
· to sutharshan.
· patch #2984337 [interface] Convert loading of export/import to jQuery ready
· event, thanks to sutharshan.
· edit] CURRENT_TIMESTAMP is also valid for datetime fields.
· patch #2985068 [engines] Fix parsing of PBXT status, thanks to Madhura Jayaratne.
· patch #2986073 [interface] Convert upload progress bar to jQuery, thanks to
· Philip Frank.
· patch #2983960 [interface] Add javascript validation of datetime input,
· thanks to Sutharshan Balachandren.
· RFE #2981999 [interface] Default sort order is now SMART.
· RFE #2972969 [interface] Fix flipping of headers in non-IE browsers.
· RFE #2964518 [interface] Allow to choose servers from configuration for
· synchronisation.
· RFE #2988633 [relation] Improve ON DELETE/ON UPDATE drop-downs
· RFE #2988629 [relation] Improve labels in relation view
· RFE #2983207, patch #2988715 [interface] Use jQuery calendar dialog, thanks
· to Muhammad Adnan.
· doc] Incorporate synchronisation docs into main document.
· core] Include Content Security Policy HTTP headers.
· bug #3004216 [CSS] Field attributes use inline CSS
· patch #2999595, RFE #2998130 [interface] Cleanup navigation frame.
· patch #3025161 [core] Prevent sending of unnecessary cookies,
· thanks to Piotr Przybylski
· bug [password] Generate password only available if JS is enabled
· fixed for Privileges and Change password)
· core] RecodingEngine now accepts none as valid option.
· core] Dropped AllowAnywhereRecoding configuration variable.
· RFE #3016457 [interface] Define tab order in SQL form to allow easier tab
· navigation.
· core] Centralized format string expansion, @VARIABLES@ are recommended way
· now, used by file name templates, default queries, export and title
· generating.
· validator] SQL validator works also with SOAP PHP extension.
· interface] Better formatting for SQL validator results.
· doc] The linked-tables infrastructure is now called phpMyAdmin
· configuration storage.
· interface] Move drop/empty links from being tabs to Operations tab.
· interface] Fixed rendering of error/notice/info titles background.
· patch #3038293 [doc] Language and grammar fixes,
· thanks to Isaac Bennetch
· patch #3038312 [export] JSON export,
· thanks to Hauke Henningsen
· RFE #1494550 [interface] Editor for SET/ENUM fields.
· RFE #2649375 [interface] Simplified interface to backup/restore.
· RFE #2973909 Users preferences
· relations] Dropped WYSIWYG-PDF configuration variable.
· RFE #806035, bug #686260 [relations] Export relations to Dia, SVG and others
· interface] Added charts to status tab, profiling page and query results
· interface] AJAXification on various pages
· core] Remove last remaining parts of profiling code which was removed in 2006.
· bug #3042665 [parser] Add workaround for MySQL way of handling backtick.
· bug #3056610 [interface] Removed modification options for information_schema
· patch #3055886 [config] Add Left frame table filter visibility config option, thanks to eesau
· core] Force generating of new session on login
· RFE #1105678 [interface] Drop page-break-before as it is useless for smaller
· tables.
· RFE #2956556 [interface] Allow to wrap enum values.
· bug #1669459 [interface] Do not automatically mark PDF schema rows to delete
· bug #3087682 [interface] Do not apply LeftFrameDBSeparator on first character.
· RFE #3111455 [interface] Column highlighting and marking in table view
· Visual query builder
· bug #3115519 [interface] Prevent long queries from being shown in confirmation
· popup
· patch #3112792 [navi] Left panel table grouping incorrect,
· thanks to garas - garas
· bug #3123433 [interface] Avoid double escaping of MySQL errors.
· interface] Use less noisy message and remove disable link on server charts an
· d database statistics.
· rfe #3141330 [relation] When displaying results, show a link to the foreign
· table even when phpMyAdmin configuration storage is not active
· bug #3141327 [relation] Foreign key input options
· export] Better handling of export to PHP array.
· rfe #3158867 [privileges] No DROP DATABASE warning if you delete a user
· interface] Add link to documentation for status variables.
· security] Redirect external links to avoid Referer leakage.
· interface] Default to not count tables in database.
· patch #3172172 [interface] Shortcut for copying table row.
· bug #3175227 [auth] Reset user cache on login.
· rfe #3148361 [interface] Replace hard coded limit with $cfg['LimitChars'].
· bug #3177136 [interface] Indicate that bookmark is being used on browse.
· interface] Indicate shared bookmarks in interface.
· patch #3176420 [Search] Ajaxify browse and delete criteria in DB Search,
· thanks to Thilanka Kaushalya
· interface] New default theme pmahomme, dropped darkblue_orange theme.
· rfe #2936155 [auth] Allow to pass additional parameters using signon method.
· rfe #1640812 [auth] Add example for OpenID authentication using signon method.
· rfe #1312657 [dbi] Default to mysqli extension.
· rfe #1168350 [interface] Add clear button to SQL edit box.
· core] Update library PHPExcel to version 1.7.6
· bug #3206876 [core] Work without mbstring installed.
· rfe #3196075, patch #3212068 [interface] Add links to variables documentation.
· bug #3208723 [import] Fix import of utf-8 XML files.
· bug #3039384 [auth] Force signon auth on signon URL change.
· bug #3168733 [core] Synchronization does not honor AllowArbitraryServer
· bug #3134495 [synchronization] Data containing single quotes prevents sync,
· thanks to jviewer
· Remove the custom color picker feature
· bug #3285929 [privileges] Don't fail silently on missing priviledge to execute
· REVOKE ALL PRIVILEGES
April 27th, 2011This release contains new features, especially:
· User preferences
· Relation schema export to multiple formats
· ENUM/SET editor
· Simplified interface for export/import
· AJAXification of some parts
· Charts
· Visual query builder
March 19th, 2011· patch #3147400 [structure] Aria table size printed as unknown,
· patch #3150164 [structure] Ordering by size gives incorrect results,
· bug #3153409 [core] 0 row(s) affected
· bug #3155842 [core] Edit relational page and page number
· [security] Minor security fixes, see PMASA-2010-9 and PMASA-2010-10
· [lang] German update, thanks to jannicars@users.sourceforge.net.
February 12th, 2011· A security release
February 9th, 2011· This is a security release
· Version compatible with PHP 5 and MySQL 5
January 8th, 2011· User preferences
· Relation schema export to multiple formats
· ENUM/SET editor
· Simplified interface for export/import
· AJAXification of some parts
· Charts
· Visual query builder
January 3rd, 2011· RFE 2890226 [view] Enable VIEW rename
· RFE 838637 [privileges] Export a user's privileges
· [core] Updated mootools to fix some glitches with Safari.
· RFE 2816943 [interface] Add REGEXP ^...$ to select dialog.
· RFE 2924956 [interface] Add insert ignore option to editing row.
· RFE 2838080 [interface] Show warning when javascript is disabled.
· RFE 2823707 [edit] Call UUID function separately to show it in insert.
· RFE 2420684 [export] Allow export of timestamps in UTC.
· [core] Remove config data from session as it brings chicken-egg problem.
· [core] Cookie path now honors PmaAbsoluteUri.
· RFE 2393597 [core] phpMyAdmin honors https in PmaAbsoluteUri.
· RFE 1778337 [core] Try moving tables by RENAME and fail to CREATE/INSERT if that fails.
· RFE 1721189 [core] Force reload js on code change.
· RFE 1954161 [interface] Do not display long numbers in server status.
· RFE 2033616 [edit] Add option to just display insert query.
· RFE 1435032 [interface] Move SSL status to the end, it is usually empty.
· RFE 1340812 [interface] Show numbers of columns in table structure.
· RFE 1186511 [inrerface] Add link to reload navigation frame.
· RFE 2936156 [auth] Signon authentication forwards error message through session data.
· RFE 2835109 [interface] Move ^1 to the end of message.
· RFE 854911 [interface] Grey out non applicable actions in structure
· [interface] Allow to create new table from navigation frame (in light mode).
· RFE 1025696 [browse] Add direct download of binary fields.
· [browse] Properly display NULL value for BLOB.
· RFE 1516803 [edit] Allow to set BLOB to/from NULL with ProtectBinary.
· [edit] Do not default to UNHEX when using file upload.
· RFE 1379201 [core] Add option to configure session_save_path.
· [interface] Provide links to documentation in highlighted SQL.
· [interface] It is now possible to bookmark most pages in JS capable browser.
· bug 2936482 [core] Fix SSL detection.
· RFE 2937850 [doc] Add some hints to chk_rel.php for quick setup.
· RFE 2938579 [interface] Add class to some elements for easier theming.
· RFE 2937840 [doc] Add some interesting configs to config.sample.inc.php.
· RFE 2792992 [doc] Added advice to re-login after changing pmadb settings
· patch 2952353 [interface] Prefill "Copy table to" in tbl_operations.php
· [lang] Add English (United Kingdom) translation.
· patch 2948421 [auth] HTTP Basic auth realm name
· bug 2954916 [interface] Do not insert doc links to not formatted SQL.
· [lang] Chinese Simplified update
· [lang] Turkish update
· RFE 2963310 [interface] Focus TEXTAREA "sql_query" on click on "SQL" link
· [lang] Uzbek update
· RFE 2958013 [import] After import, also list uploaded filename
· patch 2974341 [structure] Clicking on table name in db Structure should
· Browse the table if possible
· patch 2975533 [search] New search operators
· patch 2967320 [designer] Colored relations based on the primary key
· [core] Provide way for vendors to easily change paths to config files.
· patch 2979922, RFE 2804874 [interface] Add inline query editing
· bug 2966752 [setup] Allow to configure changes tracking in setup script.
· patch 2981165 [edit] Optionally disable the Type column
· patch 2984058 [edit] Buttons for quicky creating common SQL queries
· patch 2984337 [interface] Convert loading of export/import to jQuery ready
· event
· [edit] CURRENT_TIMESTAMP is also valid for datetime fields.
· patch 2985068 [engines] Fix parsing of PBXT status
· patch 2986073 [interface] Convert upload progress bar to jQuery
· patch 2983960 [interface] Add javascript validation of datetime input,
· thanks to Sutharshan Balachandren.
· RFE 2981999 [interface] Default sort order is now SMART.
· RFE 2972969 [interface] Fix flipping of headers in non-IE browsers.
· RFE 2964518 [interface] Allow to choose servers from configuration for
· synchronisation.
· RFE 2988633 [relation] Improve ON DELETE/ON UPDATE drop-downs
· RFE 2988629 [relation] Improve labels in relation view
· RFE 2983207, patch 2988715 [interface] Use jQuery calendar dialog
· [doc] Incorporate synchronisation docs into main document.
· [core] Include Content Security Policy HTTP headers.
· bug 3004216 [CSS] Field attributes use inline CSS
· patch 2999595, RFE 2998130 [interface] Cleanup navigation frame.
· patch 3025161 [core] Prevent sending of unnecessary cookies,
· bug [password] Generate password only available if JS is enabled
· (fixed for Privileges and Change password)
· [core] RecodingEngine now accepts none as valid option.
· [core] Dropped AllowAnywhereRecoding configuration variable.
· RFE 3016457 [interface] Define tab order in SQL form to allow easier tab
· navigation.
· [core] Centralized format string expansion, @VARIABLES@ are recommended way now, used by file name templates, default queries, export and title
· generating.
· [validator] SQL validator works also with SOAP PHP extension.
· [interface] Better formatting for SQL validator results.
· [doc] The linked-tables infrastructure is now called phpMyAdmin
· configuration storage.
· [interface] Move drop/empty links from being tabs to Operations tab.
· [interface] Fixed rendering of error/notice/info titles background.
· patch 3038293 [doc] Language and grammar fixes
· patch 3038312 [export] JSON export
· RFE 1494550 [interface] Editor for SET/ENUM fields.
· RFE 2649375 [interface] Simplified interface to backup/restore.
· RFE 2973909 Users preferences
· [relations] Dropped WYSIWYG-PDF configuration variable.
· RFE 806035, bug 686260 [relations] Export relations to Dia, SVG and others
· [interface] Added charts to status tab, profiling page and query results
· [interface] AJAXification on various pages
· [core] Remove last remaining parts of profiling code which was removed in 2006.
· bug 3042665 [parser] Add workaround for MySQL way of handling backtick.
· bug 3056610 [interface] Removed modification options for information_schema
· patch 3055886 [config] Add Left frame table filter visibility config option
· [core] Force generating of new session on login
· RFE 1105678 [interface] Drop page-break-before as it is useless for smaller
· tables.
· RFE 2956556 [interface] Allow to wrap enum values.
· bug 1669459 [interface] Do not automatically mark PDF schema rows to delete
· bug 3087682 [interface] Do not apply LeftFrameDBSeparator on first character.
· RFE 3111455 [interface] Column highlighting and marking in table view
· Visual query builder
· bug 3115519 [interface] Prevent long queries from being shown in confirmation popup
· patch 3112792 [navi] Left panel table grouping incorrect,
· thanks to garas - garas
· bug 3123433 [interface] Avoid double escaping of MySQL errors.
January 3rd, 2011· bug [doc] Fix references to MySQL doc
· patch #3101490 Default function for TIMESTAMP, thanks to jirand - jirand
· bug #3103853 [js] Double quotes were not escaped in generated js
· bug #3077463 [core] Events were not copied when copying/renaming database
· bug #1762306 [core] Copy database with view of a view
· patch #3117535 [replication] Add quotes to database in initial statement,
· bug #3112614 [pdf schema] Scratchboard for PDF pages not working
· bug #3125606 [parser] Query for table "level" causes strange display
· bug #3127904 [parser] Close all opened round brackets indents
November 30th, 2010· A security release
October 25th, 2010· bug #3059311 [import] BIGINT field type added to table analysis
· [core] Update library PHPExcel to version 1.7.4
· bug #3062455 [core] copy procedures and routines before tables
· bug #3062455 [export] with SQL, export procedures and routines before tables
· bug #3056023 [import] USE query not working
· bug #3038193 [display] Error when editing row with GEOMETRY column
· bug #3062454 [interface] Display routines/events also when no tables are defin
· ed
· support ARIA storage engine as well as its previous name MARIA
October 18th, 2010· bug #3059311 [import] BIGINT field type added to table analysis
· [core] Update library PHPExcel to version 1.7.4
· bug #3062455 [core] copy procedures and routines before tables
· bug #3062455 [export] with SQL, export procedures and routines before tables
· bug #3056023 [import] USE query not working
· bug #3038193 [display] Error when editing row with GEOMETRY column
· bug #3062454 [interface] Display routines/events also when no tables are defin
· ed
· support ARIA storage engine as well as its previous name MARIA
September 7th, 2010· patch #3050492 [PDF scratchboard] Cannot drag table box to the edge after
· a page size increase, thanks to Martin Schönberger - mad05
· bug #3054458 [core] Fixed displaying number of rows.
· bug #3035300 [parser] Fixed wrong definition of keywords.
· [setup] Fixed escaping of server name.
September 1st, 2010· patch #3050492 [PDF scratchboard] Cannot drag table box to the edge after
· a page size increase, thanks to Martin Schönberger - mad05
· bug #3054458 [core] Fixed displaying number of rows.
· bug #3035300 [parser] Fixed wrong definition of keywords.
· [setup] Fixed escaping of server name.
August 29th, 2010· bug #3033063 [core] Navi gets wrong db name
· bug #3031705 [core] Fix generating condition for real numbers by comparing
· them to string.
· bug #3034026 [confirmation] TRUNCATE queries get no confirmation request
· bug #3036132 [core] Triggers not fetched if dbname has an hyphen
· patch #3039269 [dbi] Wrong variable checked for nopassword option,
· thanks to Will Palmer - wpalmer
· bug #3040226 [XHTML] LockFromUpdate checkbox not checked by default
· bug [doc] Withdraw or edit FAQ entries related to older MySQL or PHP
· bug #3042706 [pmadb] Relations, bookmarks, etc deleted after table drop
· bug #3044189 [doc] Cleared documentation for hide_db.
· bug #3042495 [core] Move PMA_sendHeaderLocation to core.lib.php.
August 21st, 2010· bug #3033063 [core] Navi gets wrong db name
· bug #3031705 [core] Fix generating condition for real numbers by comparing them to string.
· bug #3034026 [confirmation] TRUNCATE queries get no confirmation request
· bug #3036132 [core] Triggers not fetched if dbname has an hyphen
· patch #3039269 [dbi] Wrong variable checked for nopassword option, thanks to Will Palmer - wpalmer
· bug #3040226 [XHTML] LockFromUpdate checkbox not checked by default
· bug [doc] Withdraw or edit FAQ entries related to older MySQL or PHP
· bug #3042706 [pmadb] Relations, bookmarks, etc deleted after table drop
· bug #3044189 [doc] Cleared documentation for hide_db.
· bug #3042495 [core] Move PMA_sendHeaderLocation to core.lib.php.
August 20th, 2010· [core] Fixed various XSS issues, see PMASA-2010-5 for more details.
July 27th, 2010· patch #2932113 [information_schema] Slow export when having lots of databases, thanks to Stéphane Pontier - shadow_walker
· bug #3022705 [import] Import button does not work in Catalan when there is no progress bar possible
· bug [replication] Do not offer information_schema in the list of databases
· bug [js] Avoid loading twice a js file
· bug #3024344 [setup] Setup forces numeric MemoryLimit
· bug #3025975 [auth] Odd LoginCookieValidity default value
· bug #3026400 [PHP] ereg functions are deprecated
· bug #3027557 [PHP] split() deprecated in PHP 5.3 (backport fixes from master)
· bug #3023507 [core] No result set display from stored procedure SELECT
· bug [export] CSV for MS Excel (Windows) should have semi-colon as separator
· [core] Update library PHPExcel to version 1.7.3c
· bug #2994885, bug #3029168 [import] Convert Excel column name correctly
· bug [scripts] MySQL 5.5.5 does not accept TIMESTAMP(14) in create_tables.sql
June 28th, 2010· bug #2996161 [import] properly escape import value
· bug #2998889 [import] Import button does not work in Catalan
· browse] Fix handling of sort order if only column is specified.
· lang] Greek update, thanks to Panagiotis Papazoglou - panos78
· lang] Updated lot of translation based on work done in master branch.
· bug #3008411 [databases] Last dropped database remains active in navi
· bug #2986383 [parser] Not all data being shown / counted
· bug [synchronize] Rows were deleted in target table regardless of the
· "Would you like to delete..." option
· bug [privileges] List of tables not shown when the db name has a wildcard
· bug #3011126 [display] Edit link missing after long query
· patch #3013264 [doc] FAQ 1.40 uses a comma instead of a period,
· thanks to Isaac Bennetch - ibennetch
· engines] Fix getting InnoDB status.
· bug #2986422 [import] Results for query are not displayed
May 11th, 2010· patch #2982480 [navi] Do not group if there would be one table in group
· patch #2983492 [sync] When asking to synchronize Structure and Data,
· only Structure is done
· patch #2984893 [engines] InnoDB storage page emits a warning
· bug #2974687, bug #2974692 [compatibility] PHPExcel : IBM AIX iconv() does not work
· bug #2983066 [interface] Flush table on table operations shows the query twice
· bug #2983060, patch #2987900 [interface] Fix initial state of tables in
· designer
· bug #2983062, patch #2989408 [engines] Fix warnings when changing table
· engine to Maria
· bug #2974067 [display] non-binary fields shown as hex
· bug #2983065 [operations] Error when changing from Maria to MyISAM engine
· bug #2975408 [tracking] Data too long for column data_sql
· bug [tracking] Tracking report should obey MaxCharactersInDisplayedSQL
· bug [edit] Avoid selecting UNHEX function by default for a BLOB column for
· which editing is protected
· bug #2994168 [structure] Show auto_increment in uppercase
· bug #2993970 [pdf schema] Page numbering in Table of Contents
April 14th, 2010· patch #2969449 [core] Name for MERGE engine varies depending on the MySQL version, thanks to Dieter Adriaenssens - ruleant
· bug #2966078 [browse] Incorrect LIMIT is saved and sticks while browsing
· bug #2967366 [Structure] Some results of Propose table structure are shown in hex
· bug #2967565 [insert] UNHEX not selected by default when inserting BINARY
· [navi] Changed link to git repository on main page
· bug #2972232 [menu] Import menu tab not present on main page
· patch #2976790 [menu] Go to the upper level after table DROP, thanks to Kaarel Nummert - kaarelnu
· patch #2978815 [pdf] Fix generating PDF with table dimensions, thanks to BlinK_
· patch #2977725 [export] XML wrongly encoded, thanks to Victor Volkov - hanut
· patch #2979234 [import] Create tables with current charset and collation.
· patch #2979234, bug #2960105 [import] Properly import unicode text from ODS.
· bug #2973280 [export] Proper handling of temporary directory in XLS export.
· bug #2980582 [interface] Properly format server status parameter.
· bug #2973949 [session] SQL History broken (revert patch #2899969),
· thanks to Dieter Adriaenssens - ruleant
· [doc] Be more specific about problems with Suhosin.
April 7th, 2010· patch #2969449 [core] Name for MERGE engine varies depending on the MySQL version, thanks to Dieter Adriaenssens - ruleant
· bug #2966078 [browse] Incorrect LIMIT is saved and sticks while browsing
· bug #2967366 [Structure] Some results of Propose table structure are shown in hex
· bug #2967565 [insert] UNHEX not selected by default when inserting BINARY
· [navi] Changed link to git repository on main page
· bug #2972232 [menu] Import menu tab not present on main page
· patch #2976790 [menu] Go to the upper level after table DROP, thanks to Kaarel Nummert - kaarelnu
· patch #2978815 [pdf] Fix generating PDF with table dimensions, thanks to BlinK_
· patch #2977725 [export] XML wrongly encoded, thanks to Victor Volkov - hanut
· patch #2979234 [import] Create tables with current charset and collation.
· patch #2979234, bug #2960105 [import] Properly import unicode text from ODS.
· bug #2973280 [export] Proper handling of temporary directory in XLS export.
· bug #2980582 [interface] Properly format server status parameter.
· bug #2973949 [session] SQL History broken (revert patch #2899969), thanks to Dieter Adriaenssens - ruleant
March 16th, 2010· bug #2941037 [core] Database structure not sorted by table correctly
· bug #2948492 [interface] Slide effect masks some fields on search page
· bug #2959746 [interface] Unknown table status: TABLE_TYPE
· bug #2953050 [export] export VIEW as SQL includes INSERT statement
· bug #2942032 [core] Cannot detect PmaAbsoluteUri correctly on Windows
· bug #2961609 [auth] Potential information disclosure at login page
· patch #2961540 [export] Do not export data of MERGE table,
· thanks to Dieter Adriaenssens - ruleant
· bug #2961198 [parser] Querying a table named "data"
· bug #2931429 [structure] Editing long triggers
· bug #2970769 [structure] Incorrect reference to mootools-more.js
March 11th, 2010· bug #2941037 [core] Database structure not sorted by table correctly
· bug #2948492 [interface] Slide effect masks some fields on search page
· bug #2959746 [interface] Unknown table status: TABLE_TYPE
· bug #2953050 [export] export VIEW as SQL includes INSERT statement
· bug #2942032 [core] Cannot detect PmaAbsoluteUri correctly on Windows
· bug #2961609 [auth] Potential information disclosure at login page
· patch #2961540 [export] Do not export data of MERGE table
· bug #2961198 [parser] Querying a table named "data"
· bug #2931429 [structure] Editing long triggers
March 8th, 2010· rfe #2308632 [edit] Use hex for (var)binary fields
· patch #2794819 [navi] Filter for displayed table names
· bug #2794840 [core] Cannot redeclare pma_tableheader()
· rfe #2726479 [core] configurable maximal length of URL
· patch #2724755 [display] Full/partial text links (big T) are back
· bug [display] handle NavigationBarIconic as documented for navi buttons
· rfe #2726479 [export] Export tables preselect
· patch #2805828 [export] PHP array export plugin
· patch #2798592 [import] Progress bar
· bug [gui] Generate Password not working for 'Change Login Information', only for 'Change password'
· [lang] Arabic update
· rfe #2822190 [structure] BOOLEAN is standard SQL
· [lang] German update
· rfe #2813867 [structure] Default sorting order in list of tables
· [import] Added MySQL type-detection functionality to import library
· [import] Added ODS, Excel XLS, Excel XLSX, and XML import modules
· [export] Added Excel XLSX export module
· [core] Added ability for tracking changes made through phpMyAdmin
· rfe #2839504 [engines] Support InnoDB plugin's new row formats
· [core] Added ability for synchronizing databases among servers.
· [lang] #2843101 Dutch update
· [lang] Galician update
· [export] Added MediaWiki export module
· [lang] Turkish update
· [auth] Add custom port configuration in signon
· [core] Removed context from the error handler
· bug #2883633 [export] Export of InnoDB table is incomplete
· rfe #2862575 [status] Order query statistics by % desc, skip rows with 0
· rfe #2823686 [interface] Increase default height of query window
· rfe #2129902 [structure] Don't hide indexes
· patch #2812070 [interface] Allow selecting a range of rows by holding shift
· [lang] Russian update, thanks to Victor Volkov
· [lang] Greek update, thanks to Panagiotis Papazoglou
· [lang] Norwegian update, thanks to Sven-Erik Andersen
· bug #2929958 [import] Cannot import (French interface)
· [security] Use X-Frame-Options header to protect against ClickJacking.
· [lang] Finnish update, thanks to Jouni Kahkonen
· [lang] Lithuanian update, thanks to Rytis Slatkevicius - rytis_s
· bug #2931939 [status] Seeing "m" as unit is confusing
· bug #2926613 [edit] Copy database shows errors when DB has foreign key
· [lang] Catalan update, thanks to Xavier Navarro
March 4th, 2010· rfe #2308632 [edit] Use hex for (var)binary fields
· patch #2794819 [navi] Filter for displayed table names
· bug #2794840 [core] Cannot redeclare pma_tableheader()
· rfe #2726479 [core] configurable maximal length of URL
· patch #2724755 [display] Full/partial text links (big T) are back
· bug [display] handle NavigationBarIconic as documented for navi buttons
· rfe #2726479 [export] Export tables preselect
· patch #2805828 [export] PHP array export plugin
· patch #2798592 [import] Progress bar
· bug [gui] Generate Password not working for 'Change Login Information', only for 'Change password'
· [lang] Arabic update
· rfe #2822190 [structure] BOOLEAN is standard SQL
· [lang] German update
· rfe #2813867 [structure] Default sorting order in list of tables
· [import] Added MySQL type-detection functionality to import library
· [import] Added ODS, Excel XLS, Excel XLSX, and XML import modules
· [export] Added Excel XLSX export module
· [core] Added ability for tracking changes made through phpMyAdmin
· rfe #2839504 [engines] Support InnoDB plugin's new row formats
· [core] Added ability for synchronizing databases among servers.
· [lang] #2843101 Dutch update
· [lang] Galician update
· [export] Added MediaWiki export module
· [lang] Turkish update
· [auth] Add custom port configuration in signon
· [core] Removed context from the error handler
· bug #2883633 [export] Export of InnoDB table is incomplete
· rfe #2862575 [status] Order query statistics by % desc, skip rows with 0
· rfe #2823686 [interface] Increase default height of query window
· rfe #2129902 [structure] Don't hide indexes
· patch #2812070 [interface] Allow selecting a range of rows by holding shift
· [lang] Russian update, thanks to Victor Volkov
· [lang] Greek update, thanks to Panagiotis Papazoglou
· [lang] Norwegian update, thanks to Sven-Erik Andersen
· bug #2929958 [import] Cannot import (French interface)
· [security] Use X-Frame-Options header to protect against ClickJacking.
· [lang] Finnish update, thanks to Jouni Kahkonen
· [lang] Lithuanian update, thanks to Rytis Slatkevicius - rytis_s
· bug #2931939 [status] Seeing "m" as unit is confusing
· bug #2926613 [edit] Copy database shows errors when DB has foreign key
· [lang] Catalan update, thanks to Xavier Navarro
February 12th, 2010· new import and export modules
· changes tracking
· synchronizing structure and data between servers
· replication support
December 3rd, 2009· bug [engines] Innodb_buffer_pool_pages_latched no longer returned in status
· bug #2890451 [setup] Inconsistent generated "designer_coords"
· bug #2890443 [mysqli] "No index used in query" exception is reported
· bug #2891250 [ob] Garbled data in navi frame (PHP 5.2.11 bug)
· bug #2887357 [core] Slow loading times with large databases (partial fix)
· bug #2893931 [lang] Typo and empty message
· lang] Russian update
· bug #2823599 [edit] UUID Primary Key wrongly updated
· bug #2895894 [structure] Empty default value not set properly
· bug #2897536 [parser] Copying table with bit field with default
· bug #2893221 [core] Statement may not be safe to log in statement format
November 24th, 2009· a bugfix version.
October 31st, 2009· patch #2856664 [export] Date, time, and datetime column types now export correctly to OpenOffice Spreadsheet
· patch #2859788 [parser] Double-character delimiters (bug #2846239)
· bug #2832600 [export] Slow export when having lots of databases
· bug #2537766 [import] Comments are stripped when editing store procedures
· bug #2852370 [operations] Renaming database deletes triggers
· bug #2872247 [interface] Failed opening required 'mysql_charsets.lib.php'
· bug [structure] "In use" table incorrectly reported as "view"
· bug #2879909 [interface] Removed double htmlspecialchars when editing enum column
· bug #2868328 [relations] Adding foreign key when table name contains a dot
· bug #2883381 [doc] Side effects of MemoryLimit setting
· bug #2826128 [display] Inverting sort order when expression contains a function name
October 13th, 2009· [security] XSS and SQL injection, thanks to Herman van Rink
September 14th, 2009· bug #2825293 [structure] Default value for a BIT column
· bug [display] Red arrows were reversed in the list of tables
· bug #2813879 [export] Duplicate empty lines when exporting without comments
· bug #2825919 [export] Trigger export with database name
· bug #2823996 [data] Cannot edit row with no PK and a BIT field
· bug [export] Exporting results of a query which contains a LIMIT clause
· inside a subquery
· bug #2837722 [export] Run complex SQL then export does not work
· bug #2839548 [export] Triggers order on export
· bug #2826986 [display] Order by BLOB and range display
· bug [display] After clicking on Show Function or Function, the UPDATE query
· is not shown after execution
· bug [structure] Missing validation for BINARY and VARBINARY
September 6th, 2009· bug #2825293 [structure] Default value for a BIT column
· bug [display] Red arrows were reversed in the list of tables
· bug #2813879 [export] Duplicate empty lines when exporting without comments
· bug #2825919 [export] Trigger export with database name
· bug #2823996 [data] Cannot edit row with no PK and a BIT field
· bug [export] Exporting results of a query which contains a LIMIT clause
· inside a subquery
· bug #2837722 [export] Run complex SQL then export does not work
· bug #2839548 [export] Triggers order on export
· bug #2826986 [display] Order by BLOB and range display
· bug [display] After clicking on Show Function or Function, the UPDATE query
· is not shown after execution
· bug [structure] Missing validation for BINARY and VARBINARY
September 6th, 2009· a bugfix-only version
July 21st, 2009· A bugfix-only version
June 30th, 2009· [security] XSS: Insufficient output sanitizing in bookmarks
June 15th, 2009· [core] better support for vendor customisation (based on what Debian needs)
· rfe #2127987 warn when session.gc_maxlifetime is less than cookie validity
· rfe #2100910 configurable default charset for import
· rfe #1913541 link to InnoDB status when error 1005 occurs
· rfe #1927189 strip ` from column names on import
· rfe #1821619 LeftFrameDBSeparator can be an array
· patch #1821619 [privileges] Extra back reference when editing table-specific privileges
· patch #2356575 [display] Sortable database columns
· patch #2486825 [lang] Wrong string in setup script hints
· patch #2498350 [cleanup] XHTML cleanup,
· patch #2494192 [display] Possibility of disabling the sliders
· patch #2506831 [privileges] Create user for existing database
· patch #2505255 [privileges] Cleanup
· bug #2414056 [auth] AllowNoPasswordRoot error message is too vague
· patch #2596230 [XHTML] View table headers/footers completely
· patch #2602633 [core] support column name having square brackets
· [lang] Lithuanian update
· [auth] New setting AllowNoPassword (supercedes AllowNoPasswordRoot) that applies to all accounts (even the anonymous user)
· patch #2652972 [relation] Missing code with hashing for relationship editing
· rfe #2123386 Added option to disable mcrypt warning.
· bug #2648502 Request-URI Too Large error from Location header
· rfe #1731967 Check for relations support on main page.
· rfe #2186820 Explanation for using Host table.
· rfe #1369509 Link to download more themes.
· rfe #1666487 Add option to generate password on change password page.
· rfe #1694104 Allow logging of user status with Apache.
· patch #2649087 None default is different than other None in some languages.
· [lang] Chinese Simplified update
· patch #2550286 [display] Sort arrows problem
· [security] warn about existence of config directory on main page
· patch #2706761 [lang] Polish update
· patch #2715142 [export] (rfe 2416960, escape new line in CSV export)
· patch #2727250 Optimizations for PHP loops
· bug #2650776 [import] SQL_MODE not saved during Partial Import
· patch #1863739 [auth] cache control missing (PHP-CGI)
· patch #2750541 [parser] Incorrect parsing of constraints in ALTER TABLE
· patch #2735162 [status] Server status - replication
· patch #2745215 [edit] Multi-row change with "]" improved
· rfe #2657696 Automatically copy generated password
· bug #2787162 [interface] Table with name 'log_views' is incorrectly displayed as a view
· patch #2665440 Detect mcrypt initialization failure
· [lang] Galician update
· [lang] Swedish update
· [lang] Norwegian update
· [lang] Catalan update
· [lang] Finnish update
· [lang] Hungarian update
May 31st, 2009· This version contains a number of small new features and some bug fixes.
May 20th, 2009· [core] better support for vendor customisation (based on what Debian needs)
· rfe #2127987 warn when session.gc_maxlifetime is less than cookie validity
· rfe #2100910 configurable default charset for import
· rfe #1913541 link to InnoDB status when error 1005 occurs
· rfe #1927189 strip ` from column names on import
· rfe #1821619 LeftFrameDBSeparator can be an array
· patch #1821619 [privileges] Extra back reference when editing table-specific privileges
· patch #2356575 [display] Sortable database columns
· patch #2486825 [lang] Wrong string in setup script hints
· patch #2498350 [cleanup] XHTML cleanup,
· patch #2494192 [display] Possibility of disabling the sliders
· patch #2506831 [privileges] Create user for existing database
· patch #2505255 [privileges] Cleanup
· bug #2414056 [auth] AllowNoPasswordRoot error message is too vague
· patch #2596230 [XHTML] View table headers/footers completely
· patch #2602633 [core] support column name having square brackets
· [lang] Lithuanian update
· [auth] New setting AllowNoPassword (supercedes AllowNoPasswordRoot) that applies to all accounts (even the anonymous user)
· patch #2652972 [relation] Missing code with hashing for relationship editing
· rfe #2123386 Added option to disable mcrypt warning.
· bug #2648502 Request-URI Too Large error from Location header
· rfe #1731967 Check for relations support on main page.
· rfe #2186820 Explanation for using Host table.
· rfe #1369509 Link to download more themes.
· rfe #1666487 Add option to generate password on change password page.
· rfe #1694104 Allow logging of user status with Apache.
· patch #2649087 None default is different than other None in some languages.
· [lang] Chinese Simplified update
· patch #2550286 [display] Sort arrows problem
· [security] warn about existence of config directory on main page
· patch #2706761 [lang] Polish update
· patch #2715142 [export] (rfe 2416960, escape new line in CSV export)
· patch #2727250 Optimizations for PHP loops
· bug #2650776 [import] SQL_MODE not saved during Partial Import
· patch #1863739 [auth] cache control missing (PHP-CGI)
· patch #2750541 [parser] Incorrect parsing of constraints in ALTER TABLE
· patch #2735162 [status] Server status - replication
· patch #2745215 [edit] Multi-row change with "]" improved
· rfe #2657696 Automatically copy generated password
· bug #2787162 [interface] Table with name 'log_views' is incorrectly displayed as a view
· patch #2665440 Detect mcrypt initialization failure
· [lang] Galician update
· [lang] Swedish update
May 16th, 2009· patch #2739001 [export] XML does not allow spaces in element names
· bug #2780722 [import] Incorrect maximum file size
· bug #2780356 [calendar] Null checkbox not unchecked when date is chosen
· bug [calendar] js error "window.parent.addEvent is not a function"
· patch #2773818 [export] Invalid "Content-Encoding" header
· bug #2787162 [interface] Table with name 'log_views' is incorrectly displayed as a view
· bug #2784400 [parser] INVOKER not understood by parser
· [core] Compatibility with PHP 5.3.0RC2
May 8th, 2009· patch #2739001 [export] XML does not allow spaces in element names
· bug #2780722 [import] Incorrect maximum file size
· bug #2780356 [calendar] Null checkbox not unchecked when date is chosen
· bug [calendar] js error "window.parent.addEvent is not a function"
· patch #2773818 [export] Invalid "Content-Encoding" header
· bug #2787162 [interface] Table with name 'log_views' is incorrectly displayed as a view
· bug #2784400 [parser] INVOKER not understood by parser
· [core] Compatibility with PHP 5.3.0RC2
April 25th, 2009· patch #1808339 [doc] Apache SSLOptions and StdEnvVars FAQ
· bug #2491017 [operations] ANSI mode not supported (db rename and table move)
· bug #2609346 [operations] Fix copying views.
· rfe #2127983 Readd documentation link, it does not protect against anything.
· bug #1675249 [doc] Apache reverse proxy and cookies FAQ
· bug #2682140 UUID() and CURRENT_USER() should not accept arguments
· patch #2682833 [core] Fatal error: Call to a member function isDisplayed()
· patch #2702772 [lang] Duplicate sentence in Polish
· patch #2709040 [doc] Wrong link in ChangeLog formatter
· patch #2715417 [interface] Fixed truncation of enum/set values containing parenthesis
· [lang] Spanish update
· bug #2724844 Add Fields: Add index is missing quotes
· bug #2740550 [interface] Using textarea CharEditing drops default values
· bug #2729191 [config] CheckConfigurationPermissions = false is worthless
· bug #2687046 [export] Structure export: Null always YES
· [doc] typos
March 24th, 2009· [security] HTTP Response Splitting and file inclusion vulnerabilities - [security] XSS vulnerability on export page
· [security] Insufficient output sanitizing when generating configuration file
March 1st, 2009· [lang] Turkish update
· patch #2496403 [display] Multi-row change with "]"
· bug #2027720 [parser] Missing space after BINARY used as cast
· patch #2520747 [core] E_DEPRECATED compatibility for PHP 5.3
· bug [display] Message "Bookmark created" is not displaying
· [display] Show AUTO_INCREMENT instead of A_I when in vertical mode
· patch #2538358 [display] Conditions for relational display field
· [lang] Mongolian update
· patch #2553372 [display] DB comment tooltips not shown on navi
· patch #2561433 [structure] Display true number of rows in a view if it contains less than MaxExactCountViews
· [lang] Polish update
· bug #2568722 [designer] Compound key not shown
· patch #2550323 [XHTML] in server_databases.php
· patch #2358861 [navi] Row count tooltip wrong for information_schema
· bug #2565948 [core] Changing the connection collation changed the client charset.
· [lang] Romanian update
· patch #1760205 [data] Insert as new row: BLOB is lost
· [lang] Georgian update
January 19th, 2009· bug #1253252 [display] Can't NULL a column with relation defined
· bug #2009500 [SQL] Small improvements in generated SQL (partial fix)
· bug #1963184 [export] YAML export improvement
· [lang] Dutch update
· patch #2407785 [cleanup] ereg*() deprecated in PHP 5.3
· bug #2417058 [properties] Edit fields: losing auto-increment setting
· patch #2444082 [changelog] changelog.php linkifies one link wrong
· bug #2363653 [properties] Various problems with table structure
· bug [display] BIT field contents disappear when edited
· [lang] Czech update
· bug #2461735 [operations] Table operations adds "row_format"
· bug #2445213 [export] Commas for CSV Excel 2008 for Mac
· bug #2397877 [core] ForceSSL and http auth_type
· bug #2473127 [display] Deleting rows displays tbl structure, not contents
· patch #2478940 [core] PHP 5.2+ warning does not work
· bug #2416418 [privileges] Escaping special characters
December 10th, 2008· patch #2242765 [core] Navi panel server links wrong
· bug #2186823 [core] bad session.save_path not detected
· bug #2202709 [core] Re-login causes PMA to forget current table name
· bug #2280904 [export] do not include view name in export
· rfe #1688975 [display] enable copying of auto increment by default
· bug #2355753 [core] do not bail out creating session on any PHP warning
· bug #2355925 [display] properly update tooltips in navigation frame
· bug #2355923 [core] do not use ctype if it is not available
· bug #2356433 [display] HeaderFlipType "fake" problems
· bug #2363919 [display] Incorrect size for view
· bug #2121287 [display] Drop-down menu blinking in FF
· [lang] Catalan update
· [lang] Finnish update
· [core] Avoid error with BLOBstreaming support requiring SUPER privilege
· [security] possible XSRF on several pages
December 7th, 2008· a bugfix-only version
November 28th, 2008· [auth] Support for Swekey hardware authentication,
· see http://phpmyadmin.net/auth_key
· bug #2046883 [core] Notices about deprecated dl() (so stop using it)
· BLOBstreaming support
· patch #2067462 [lang] link FAQ references in messages
· new setup script
· rfe #1892243 [export] more links to documentation
· [auth] cookie auth now autogenerates blowfish_secret, but it has some
· limitations and you still should set it in config file
· [auth] cookie authentication is now the default
· [auth] do not allow root user without password unless explicitly enabled by
· AllowNoPasswordRoot
· rfe #1778908 [auth] arbitrary server auth can now also accept port
· patch #2089240 [export] handle correctly switching SQL modes
· rfe #1612724 [export] add option to export without comments
· bug #2090002 [display] Cannot edit row in VIEW
· patch #2099962 [js] fix js error without frameset
· patch #2099972 [structure] Display None when there is no default value
· patch #2122883 [PDF schema] Option to display just the keys
· rfe #1276463 [search] Search empty/not empty values
· rfe #823652 [structure] ENUM values: field size too small
· [lang] Persian update
· [lang] Czech update
· patch #2255890 [lang] English-language cleanup
· [lang] Norwegian update
· [lang] Hungarian update
· [lang] French update
· bug #2222344 [display] Query involving a function shown as binary
· [lang] Italian update
· [lang] Swedish update
· bug #2315549 [import] fclose() error with "Create PHP code"
· [lang] Polish update
November 9th, 2008Improvements for 3.1.0:
· [auth] Support for Swekey hardware authentication
· BLOBstreaming support
· new setup script
· patch #2067462 [lang] link FAQ references in messages
· [auth] cookie auth now autogenerates blowfish_secret, but it has
· some limitations and you still should set it in config file
· [auth] cookie authentication is now the default
· [auth] do not allow root user without password unless explicitly
· enabled by AllowNoPasswordRoot
· rfe #1892243 [export] more links to documentation
· rfe #1778908 [auth] arbitrary server auth can now also accept port
· rfe #1612724 [export] add option to export without comments
· rfe #1276463 [search] Search empty/not empty values
· rfe #823652 [structure] ENUM values: field size too small
Fixes for 3.1.0:
· bug #2046883 [core] Notices about deprecated dl() (so stop using it)
· patch #2089240 [export] handle correctly switching SQL modes
· bug #2090002 [display] Cannot edit row in VIEW
· patch #2099962 [js] fix js error without frameset
· patch #2099972 [structure] Display None when there is no
· default value
· patch #2122883 [PDF schema] Option to display just the keys
· [lang] Persian update
· [lang] Czech update
October 31st, 2008· bug #2134126 [GUI] SQL error after sorting a subset
· [lang] Catalan update
· [lang] Russian update
· patch #2143882 [import] Temporary uploaded file not deleted
· bug #2136986 [auth] Cannot create database after session timeout
· bug #1914066 [core] ForceSSL generates incorrectly escaped redirections (this time with the correct fix)
· [lang] Hungarian update
· bug #2153970 [core] Properly truncate SQL to avoid half
· of html tags
· [lang] Romanian update
· bug #2161443 [structure] Incorrect index choice shown when
· modifying an index
· bug #2127094 [interface] Misleading message after cancelling
· an action
· [lang] Croatian update
· [lang] Finnish update
· [lang] Polish update
· [lang] Japanese update
· patch #2176438 [privileges] Wrong message when changing password
· bug #2163437 [core] Cannot disable PMA tables
· bug #2184240 [lang] Problems with Italian language file
· bug #2187193 [interface] ShowChgPassword setting not respected
· (3.0.1.1) [security] XSS in a Designer component
October 23rd, 2008· bug #2134126 [GUI] SQL error after sorting a subset
· [lang] Catalan update
· [lang] Russian update
· patch #2143882 [import] Temporary uploaded file not deleted
· bug #2136986 [auth] Cannot create database after session timeout
· bug #1914066 [core] ForceSSL generates incorrectly escaped
· redirections (this time with the correct fix)
· [lang] Hungarian update
· bug #2153970 [core] Properly truncate SQL to avoid half
· of html tags
· [lang] Romanian update
· bug #2161443 [structure] Incorrect index choice shown when
· modifying an index
· bug #2127094 [interface] Misleading message after cancelling
· an action
· [lang] Croatian update
· [lang] Finnish update
· [lang] Polish update
· [lang] Japanese update
· patch #2176438 [privileges] Wrong message when changing password
· bug #2163437 [core] Cannot disable PMA tables
· bug #2184240 [lang] Problems with Italian language file
· bug #2187193 [interface] ShowChgPassword setting not respected
September 30th, 2008Improvements for 3.0.0:
· [table] support MySQL 5.1 PARTITION: CREATE TABLE / Table structure,
· partition maintenance
· [privileges] support for EVENT and TRIGGER
· [gui] Events
· minimal support on db structure page
· export
· [engines] Maria support
· [engines] MyISAM and InnoDB: support ROW_FORMAT table option
· [engines] PBXT: table options, foreign key (relation view, designer)
· [error handler] NEW handle errors to prevent path disclosure
· and display/collect errors
· [mysqlnd] do not display strMysqlLibDiffersServerVersion
· if the client is mysqlnd
· [webapp] experimental Mozilla Prism support
· [export] new plugin "codegen" for NHibernate
· [export] new export to Texy! markup
· [config] new parameter CheckConfigurationPermissions
· [config] new parameter ShowDatabasesCommand
· [config] new parameter CountTables
· rfe #1775288 [transformation] proper display if IP-address
· stored as INT
· rfe #1758177 [core] Add the Geometry DataTypes
· rfe #1741101, patch #1798184 UUID default for CHAR(36) PRIMARY KEY
· rfe #1840165 [interface] Enlarge column name field in vertical mode
· patch #1847534 [interface] New "Inside field" in db search
· [GUI] Mootools js library (http://mootools.net) and new parameter
· InitialSlidersState
· [core] cache some MySQL stats (do not query them with every
· page request)
· [view] clearer dialog WITH (CASCADED | LOCAL) CHECK OPTION
· [pdf] Merged tcpdf 2.2.002 (PHP5 version)
· prevent search indexes from indexing phpMyAdmin installations
· [lang] New Bangla
· [interface] Display options
· rfe #1962383 [designer] Option to create a PDF page
· [GUI] Color picker
· [navi] new parameter LeftDefaultTabTable
· [display] headwords for sorted column
· rfe #1692928 [transformation] Option to disable browser
· transformations
· [import] Speed optimization to be able to import the sakila database
· [doc] Documentation for distributing phpMyAdmin in README.VENDOR.
Fixes for 3.0.0.x:
· bug #1910621 [display] part 2: do not display a BINARY content
· as text
· [export] properly handle line breaks for YAML
· bug #1664240 [GUI] css height makes cfg TextareaRows useless
· bug #1724217 [Create PHP Code] doesn't include newlines for
· text fields
· bug #1845605 [i18n] translators.html still uses iso-8859-1
· bug #1823018 [charset] Edit(Delete) img-links pointing to wrong row
· bug #1826205 [export] Problems with yaml text export
· bug #1344768 [database] create/alter table new field can not have
· empty string as default
· patch #2007196, Typos in comments
· bug #1982315 [GUI] Comma and quote in ENUM
· bug #1970836 [parser] SQL parser is slow
· bug #2033962 [import] Cannot import zip file
· [core] Safer handling of temporary files with open_basedir
· bug #2066923 [display] Navi browse icon does not go to page 1
· patch #2075263 [auth] Single sign-on and cookie clearing
· bug #2080963 [charset] Clarify doc and improved code
· bug [charset] Cannot sort twice on a column when the table name
· contains accents
· bug #2113848 [navi] Page number after database switching
· patch #2115966 [GUI] Checkboxes and IE 7
· bug #114066 [core] ForceSSL generates incorrectly escaped
· redirections
September 22nd, 2008· bug #2031221 [auth] Links to version number on login screen
· bug #2032707 [core] PMA does not start if ini_set() is disabled
· bug #2004915 [bookmarks] Saved queries greater than 1000 chars
· not displayed
· bug #2037381 [export] Export type "replace" does not work
· bug #2037375 [export] DROP PROCEDURE needs IF EXISTS
· bug #2045512 [export] Numbers in Excel export
· [lang] Norwegian UTF-8 original file remerged
· bug #2074250 [parser] Undefined variable seen_from
· (2.11.9.1) [security] Code execution vulnerability
· (2.11.9.2) [security] XSS in MSIE using NUL byte
September 8th, 2008· [table] support MySQL 5.1 PARTITION: CREATE TABLE / Table structure,
· partition maintenance
· [privileges] support for EVENT and TRIGGER
· [gui] Events
· minimal support on db structure page
· export
· [engines] Maria support
· [engines] MyISAM and InnoDB: support ROW_FORMAT table option
· [engines] PBXT: table options, foreign key (relation view, designer)
· [error handler] NEW handle errors to prevent path disclosure
· and display/collect errors
· [mysqlnd] do not display strMysqlLibDiffersServerVersion
· if the client is mysqlnd
· [webapp] experimental Mozilla Prism support
· [export] new plugin "codegen" for NHibernate
· [export] new export to Texy! markup
· [config] new parameter CheckConfigurationPermissions
· [config] new parameter ShowDatabasesCommand
· [config] new parameter CountTables
· rfe #1775288 [transformation] proper display if IP-address
· stored as INT
· rfe #1758177 [core] Add the Geometry DataTypes
· rfe #1741101, patch #1798184 UUID default for CHAR(36) PRIMARY KEY
· rfe #1840165 [interface] Enlarge column name field in vertical mode
· patch #1847534 [interface] New "Inside field" in db search
· [GUI] Mootools js library (http://mootools.net) and new parameter
· InitialSlidersState
· [core] cache some MySQL stats (do not query them with every
· page request)
· [view] clearer dialog WITH (CASCADED | LOCAL) CHECK OPTION
· [pdf] Merged tcpdf 2.2.002 (PHP5 version)
· prevent search indexes from indexing phpMyAdmin installations
· [lang] New Bangla
· [interface] Display options
· rfe #1962383 [designer] Option to create a PDF page
· [GUI] Color picker
· [navi] new parameter LeftDefaultTabTable
· [display] headwords for sorted column
· rfe #1692928 [transformation] Option to disable browser
· transformations
· [import] Speed optimization to be able to import the sakila database
· [doc] Documentation for distributing phpMyAdmin in README.VENDOR.
August 11th, 2008· support MySQL 5.1 PARTITION: CREATE TABLE / Table structure, partition maintenance
· support for EVENT and TRIGGER
· Events
· minimal support on db structure page
· export
· Maria support
· MyISAM and InnoDB: support ROW_FORMAT table option
· PBXT: table options, foreign key (relation view, designer)
· support SweKey hardware authentication
· NEW handle errors to prevent path disclosure and display/collect errors
· do not display strMysqlLibDiffersServerVersion if the client is mysqlnd
· experimental Mozilla Prism support
· new plugin "codegen" for NHibernate
· new export to Texy! markup
· new parameter CheckConfigurationPermissions
· new parameter ShowDatabasesCommand
· new parameter CountTables
· proper display if IP-address stored as INT
· Add the Geometry DataTypes
· patch #1798184 UUID default for CHAR(36) PRIMARY KEY
· Enlarge column name field in vertical mode
· New "Inside field" in db search
· Mootools js library and new parameter InitialSlidersState
· cache some MySQL stats (do not query them with every page request)
· clearer dialog WITH (CASCADED | LOCAL) CHECK OPTION
· Merged tcpdf 2.2.002 (PHP5 version)
· prevent search indexes from indexing phpMyAdmin installations
· New Bangla
· Display options
· Option to create a PDF page
· Color picker
· new parameter LeftDefaultTabTable
· headwords for sorted column
· Option to disable browser transformations
· Speed optimization to be able to import the sakila database
· Documentation for distributing phpMyAdmin in README.VENDOR.
July 28th, 2008· patch #1987593 [interface] Table list pagination in navi
· bug #1989081 [profiling] Profiling causes query to be executed again (really causes a problem in case of INSERT/UPDATE)
· bug #1990342 [import] SQL file import very slow on Windows
· bug [XHTML] problem with tabindex and radio fields
· bug #1971221 [interface] tabindex not set correctly
· bug [views] VIEW name created via the GUI was not protected with backquotes
· bug #1989813 [interface] Deleting multiple views (space in name)
· bug #1992628 [parser] SQL parser removes essential space
· bug #1989281 [export] CSV for MS Excel incorrect escaping of double quotes
· bug #1959855 [interface] Font size option problem when no config file
· bug #1982489 [relation] Relationship view should check for changes
· bug [history] Do not save too big queries in history
· [security] Do not show version info on login screen
· bug #2018595 [import] Potential data loss on import resubmit
· patch #2020630 [export] Safari and timedate
· bug #2022182 [import, export] Import/Export fails because of Mac files
· [security] protection against cross-frame scripting and new directive AllowThirdPartyFraming
· [security] possible XSS during setup
· [interface] revert language changing problem introduced with 2.11.7.1
July 15th, 2008· bug #1908719 [interface] New field cannot be auto-increment and primary key
· [dbi] Incorrect interpretation for some mysqli field flags
· bug #1910621 [display] part 1: do not display a TEXT utf8_bin as BLOB (fixed for mysqli extension only)
· [interface] sanitize the after_field parameter, thanks to Norman Hippert
· [structure] do not remove the BINARY attribute in drop-down
· bug #1955386 [session] Overriding session.hash_bits_per_character
· [interface] sanitize the table comments in table print view, thanks to Norman Hippert
· bug #1939031 Auto_Increment selected for TimeStamp by Default
· patch #1957998 [display] No tilde for InnoDB row counter when we know it for sure, thanks to Vladyslav Bakayev - dandy76
· bug #1955572 [display] alt text causes duplicated strings
· bug #1762029 [interface] Cannot upload BLOB into existing row
· bug #1981043 [export] HTML in exports getting corrupted, thanks to Jason Judge - jasonjudge
· bug #1936761 [interface] BINARY not treated as BLOB: update/delete issues
· protection against XSS when register_globals is on and .htaccess has no effect, thanks to Tim Starling
· bug #1996943 [export] Firefox 3 and .sql.gz (corrupted); detect Gecko 1.9, thanks to Juergen Wind
· (2.11.7.1) [security] XSRF/CSRF by manipulating the db, convcharset and collation_connection parameters, thanks to YGN Ethical Hacker Group
June 23rd, 2008· bug #1908719 [interface] New field cannot be auto-increment and
· primary key
· [dbi] Incorrect interpretation for some mysqli field flags
· bug #1910621 [display] part 1: do not display a TEXT utf8_bin
· as BLOB (fixed for mysqli extension only)
· [interface] sanitize the after_field parameter,
· thanks to Norman Hippert
· [structure] do not remove the BINARY attribute in drop-down
· bug #1955386 [session] Overriding session.hash_bits_per_character
· [interface] sanitize the table comments in table print view,
· thanks to Norman Hippert
· bug #1939031 Auto_Increment selected for TimeStamp by Default
· patch #1957998 [display] No tilde for InnoDB row counter when
· we know it for sure, thanks to Vladyslav Bakayev - dandy76
· bug #1955572 [display] alt text causes duplicated strings
· bug #1762029 [interface] Cannot upload BLOB into existing row
· bug #1981043 [export] HTML in exports getting corrupted,
· thanks to Jason Judge - jasonjudge
bug #1936761 [interface] BINARY not treated as BLOB:
· update/delete issues
· protection against XSS when register_globals is on and .htaccess
· has no effect, thanks to Tim Starling
· bug #1996943 [export] Firefox 3 and .sql.gz (corrupted);
· detect Gecko 1.9, thanks to Juergen Wind
March 4th, 2008· bug #1862661 [GUI] Warn about rename deleting database
· bug #1866041 [interface] Incorrect sorting with AS
· bug #1871038 [import] Notice: undefined variable first_sql_delimiter
· bug #1873110 [export] Problem exporting with a LIMIT clause
· bug #1871164 [GUI] Empty and navigation frame synch.
· patch #1873188 [GUI] Making db pager work when js is disabled, thanks to Jürgen Wind - windkiel
· bug #1875010 [auth] MySQL server and client version mismatch (mysql ext.)
· patch #1879031 [transform] dateformat transformation and UNIX timestamps, thanks to Tim Steiner - spam38
· bug [import] Do not verify a missing enclosing character for CSV, because files generated by Excel don't have any enclosing character
· bug #1799691 [export] "Propose table structure" and Export
· bug #1884911 [GUI] Space usage
· bug #1863326 [GUI] Wrong error message / no edit (Suhosin)
· bug #1887204 [GUI] Order columns in result list messing up query
· patch #1893538 [GUI] Display issues on Opera 9.50, thanks to Jürgen Wind - windkiel
· bug [GUI] Do not display the database name used by the previous user, thanks to Ronny Görner
· bug [security] Remove cookies from Array for better coexistence with other applications, thanks to Richard Cunningham. See PMASA-2008-1.
January 15th, 2008· bug #1843428 [GUI] Space issue with DROP/DELETE/ALTER TABLE
· bug #1807816 [search] regular expression search doesn't work with
· backslashes
· bug #1843463 [GUI] DROP PROCEDURE does not show alert
· bug #1835904 [GUI] Back link after a SQL error forgets the query
· bug #1835654 [core] wrong escaping when using double quotes
· bug #1817612 [cookies] Wrong cookie path on IIS with PHP-CGI,
· thanks to Carsten Wiedmann
· bug #1848889 [export] export trigger should use
· DROP TRIGGER IF EXISTS
· bug #1851833 [display] Sorting forgets an explicit LIMIT
· (fix for sorting on column headers)
· bug #1764182 [cookies] Suhosin cookie encryption breaks phpMyAdmin
· bug #1798786 [import] Wrong error when a string contains semicolon
· bug #1813508 [login] Missing parameter: field after re-login
· bug #1710144 [parser] Space after COUNT breaks Export but not Query
· bug #1783620 [parser] Subquery results without "as" are ignored
· bug #1821264 [display] MaxTableList and INFORMATION_SCHEMA
· bug #1859460 [display] Operations and many databases
· bug #1814679 [display] Database selection pagination when
· switching servers
· patch #1861717 [export] CSV Escape character not exported right,
· thanks to nicolasdigraf
· bug #1864468 [display] Theme does not switch to darkblue_orange
· bug #1847409 [security] Path disclosure on
· darkblue_orange/layout.inc.php,
· thanks to Jürgen Wind windkiel
January 7th, 2008· Bug #1843428 [GUI] Space issue with DROP/DELETE/ALTER TABLE
· Bug #1807816 [search] regular expression search doesn't work with backslashes
· Bug #1843463 [GUI] DROP PROCEDURE does not show alert
· Bug #1835904 [GUI] Back link after a SQL error forgets the query
· Bug #1835654 [core] wrong escaping when using double quotes
· Bug #1817612 [cookies] Wrong cookie path on IIS with PHP-CGI
· Bug #1848889 [export] export trigger should use DROP TRIGGER IF EXISTS
· Bug #1851833 [display] Sorting forgets an explicit LIMIT (fix for sorting on column headers)
· Bug #1764182 [cookies] Suhosin cookie encryption breaks phpMyAdmin
· Bug #1798786 [import] Wrong error when a string contains semicolon
· Bug #1813508 [login] Missing parameter: field after re-login
· Bug #1710144 [parser] Space after COUNT breaks Export but not Query
· Bug #1783620 [parser] Subquery results without "as" are ignored
· Bug #1821264 [display] MaxTableList and INFORMATION_SCHEMA
· Bug #1859460 [display] Operations and many databases
December 11th, 2007· Patch #1818389 to remove a notice (failed to flush buffer)
· Patch #1821154, HTTP authentication: fix auth working With php/mod_fastcgi
· Wrong default charset in case of broken session
· Bug #1824506 [profiling] Profile command repeated on Older MySQL servers
· Bug #1825172 [export] Exporting and functions
· Bug #1817224 [import] Incorrect detection of file_uploads In some cases
· Bug #1777249 [display] Do not underline links in left panel
· Bug #1826022 [privileges] unable to add user (MySQL 3.23) Since PMA 2.11.2
· Bug #1823045 [import] Error importing file with lowercase"delimiter"
· Bug #1828913 [structure] Can't set FULLTEXT index on CHAR column
· Bug #1804081 [export] export on server doesn't obey AllowAnyWhereRecoding
· Bug #1789988 [display] space before SHOW COLUMNS
· Bug #1831646 [table creation] Error in CREATE TABLE with multiple Primary keys and AUTO_INCREMENT
· [display] Division by zero when showing all records (page selector)
· Bug #1828265 [privileges] No weird characters in generated password
December 3rd, 2007· patch #1818389 to remove a notice (failed to flush buffer)
· patch #1821154, HTTP authentication: fix auth working with php/mod_fastcgi
· wrong default charset in case of broken session
· bug #1824506 [profiling] Profile command repeated on older MySQL servers
· bug #1825172 [export] Exporting and functions
· bug #1817224 [import] Incorrect detection of file_uploads in some cases
· bug #1777249 [display] Do not underline links in left panel
· bug #1826022 [privileges] unable to add user (MySQL 3.23) since PMA 2.11.2
· bug #1823045 [import] Error importing file with lowercase "delimiter"
· bug #1828913 [structure] Can't set FULLTEXT index on CHAR column
· bug #1804081 [export] export on server doesn't obey
· AllowAnyWhereRecoding
· bug #1789988 [display] space before SHOW COLUMNS
· bug #1831646 [table creation] Error in CREATE TABLE with multiple
· primary keys and AUTO_INCREMENT
· [display] Division by zero when showing all records (page selector)
· bug #1828265 [privileges] No weird characters in generated password
· bug #1759194 [import] open_basedir warning
· bug #1793948 [parser] ROW_FORMAT incorrectly parsed
· undefined PMA_MYSQL_INT_VERSION when no default server is set
· bug #1763343 [session] Behavior with session.auto_start enabled
· [lang] Hungarian update
· patch #1837691 [query window] js errors
· patch #1839052 [lang] catalan not in UTF-8
· patch #1838626 [GUI] Login interface broken on Konqueror
November 13th, 2007· patch #1791576 HTTP auth: support REDIRECT_REMOTE_USER,
· thanks to Allard
· [lang] Serbian update, thanks to Mihailo Stefanovic
· bug #1798841 [relations] Copying db does not copy internal relations
· bug #1798646 [display] Character ' ' in query wrongly interpreted
· bug #1801919 [themes] Do not use NaviDatabaseNameColor for fieldset
· legend
· bug #1764735 [core] Designer: PDF error when deleting a table
· bug #1764195 [views] DROP button does not work on defective views
· bug #1805773 [relations] browse foreign values: return values not
· escaped, thanks to Alex Rambau
· bug #1807923 [login] Login with html entities in password fails
· [core] Undefined variable when creating a table that exists
· patch #1808578 Changes in font size were no longer detected
· after patch #1787915
· [lang] Croatian update, thanks to Renato Pavicic
· patch #1807615 [GUI] Display patch for column rights in Opera
· bug #1811519 Can't delete user with a german umlaut.
· bug #1811519 [privileges] fixed used collation for accessing
· mysql.user in server privileges
· it should not be possible to move or copy a table to
· information_schema
· bug #1814733 win: copy db to mixed name db fails
· bug #1777249 [display] Remove horizontal lines in navigation panel
· bug #1805102 [display] TextareaAutoSelect issues: set this parameter
· default value to false to help cut&paste from a terminal window;
· also set focus to the textarea
· bug #1814463 [display] Wrong database size
· bug #1811527 [display] Problem with links to the MySQL manual
· patch #1817529 [auth] Incorrect login via URL when
· AllowArbitraryServer is true, thanks to Juergen Wind
· (2.11.2.1) fixed possible SQL injection using database name
· (2.11.2.1) fixed possible XSS in database name,
· thanks to Omer Singer, The DigiTrust Group
October 24th, 2007· Patch #1791576 HTTP auth: support REDIRECT_REMOTE_USER
· [lang] Serbian update, thanks to Mihailo Stefanovic
· Bug #1798841 [relations] Copying db does not copy internal relations
· Bug #1798646 [display] Character ' ' in query wrongly interpreted
· Bug #1801919 [themes] Do not use NaviDatabaseNameColor for fieldset legend
· Bug #1764735 [core] Designer: PDF error when deleting a table
· Bug #1764195 [views] DROP button does not work on defective views
· Bug #1805773 [relations] browse foreign values: return values not escaped, thanks to Alex Rambau
· Bug #1807923 [login] Login with html entities in password fails
· [core] Undefined variable when creating a table that exists
· Patch #1808578 Changes in font size were no longer detected after patch #1787915
· [lang] Croatian update, thanks to Renato Pavicic
· Patch #1807615 [GUI] Display patch for column rights in Opera
· Bug #1811519 Can't delete user with a german umlaut
· Bug #1811519 [privileges] fixed used collation for accessing mysql.user in server privileges
October 18th, 2007· bug #1783667 [export] NO_AUTO_VALUE_ON_ZERO and MySQL version
· bug #1780098 [GUI] Logout causes CSS loss, thanks to Juergen Wind
· . incorrect field ids, thanks to Michael Keck
· bug #1787522 [view] wrong choice in algorithm drop-down
· bug #1777620 [GUI] Table Print preview: missing column header, thanks to Mario Rohkrämer
· Do not display "Your MySQL library..." if only the Z part of X.Y.Z version is different
bugs #1767759, 1216521 [data] Duplicate entry error Browse feature:
· this minor feature removed due to its complexity
· bug #1774825 [operations] Rename database loses charset info
· bug #1791568 [core] Undefined cfg, thanks to Christian Schmidt
· bug #1782332 [structure] New table form does not overtake data
· bug #1793763 [requirements] minimum PHP should be 4.2.0
· patch #1787915 Avoid CSS reloading on every click, thanks to Juergen Wind
· bug #1798627 [GUI] Wrong storage engine displayed
· - (2.11.1.1) security fix on setup.php
· (2.11.1.2) security fix on server_status.php and other possible XSS issues with PHP_SELF, PATH_INFO, REQUEST_URI
September 21st, 2007· bug #1783667 [export] NO_AUTO_VALUE_ON_ZERO and MySQL version
· bug #1780098 [GUI] Logout causes CSS loss, thanks to Juergen Wind
· . incorrect field ids, thanks to Michael Keck
· bug #1787522 [view] wrong choice in algorithm drop-down
· bug #1777620 [GUI] Table Print preview: missing column header, thanks to Mario Rohkrämer
· Do not display "Your MySQL library..." if only the Z part of X.Y.Z version is different
bugs #1767759, 1216521 [data] Duplicate entry error Browse feature:
· this minor feature removed due to its complexity
· bug #1774825 [operations] Rename database loses charset info
· bug #1791568 [core] Undefined cfg, thanks to Christian Schmidt
· bug #1782332 [structure] New table form does not overtake data
· bug #1793763 [requirements] minimum PHP should be 4.2.0
· patch #1787915 Avoid CSS reloading on every click, thanks to Juergen Wind
· bug #1798627 [GUI] Wrong storage engine displayed
August 22nd, 2007· [import] support handling of DELIMITER to mimic mysql CLI,
· thanks to fb1
· improved PHP 6 compatibility
· [core] added PMA_fatalError() and made use of it
· [doc] changed all documentation in config.inc.php
· to phpDocumentor style
· [data] support for CREATE VIEW from query results
· [gui] dropped css/ folder and moved into root of PMA
· [l10n] new: Sinhala, Macedonian
· [export] YAML export (see yaml.org), thanks to Bryce Thornton
· [upload] moved file upload functionality into own class
· [upload] make use of cfg['TempDir'] for file uploads
· [server] improved display of binary logs
· [data] better error handling in tbl_create.php
· [routines] from Patch #1649881, thanks to Mike Beck
· [querywindow] store sql history in session
· [querywindow] sql history now without db too
· [querywindow] tweaks in sql history view
· [export] Native Excel (Spreadsheet_Excel_Writer) improvements,
· thanks to Christian Schmidt
· [doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch
· RFE #1435922 [gui] navigation frame shows listing of databases
· when none selected
· [data] support BIT datatype (under mysqli),
· thanks to Christian Schmidt
· [display] automatic confirmation for sort by key,
· thanks to Juergen Wind
· [data] can now choose the number of insert rows
· RFE #1704779 [gui] link documentation from login page
· RFE #1513345 [setup] check control user connection during setup
· [structure] TRIGGERS: display/edit/drop/SQL export
· [browse] store browse state in session per query
· [gui] Insert/Edit: no longer display the Go button each 15 lines
· but just at the end of a row
· [gui] Query window: use verbose server name if any
· [auth] patch #1712514 specify host for single signon,
· thanks to Thierry
· [gui] Navigator for the db list in the navigation panel
· [gui] Navigator for the table list in the content panel
· [display] Support for MySQL 5.0.37 profiling
RFE #1743983 [gui] Replace max_characters by a configurable param:
· cfg['MaxCharactersInDisplayedSQL']
· [display] patch #1749705, Allow multibyte characters in number
· formatting, thanks to garas
· [privileges] Support password hashing on the Edit Privileges
· interface
· [gui] Export: Select All/Unselect All over the choices,
· thanks to Florian Schmitz
Fixes:
· bug #1674914 [structure] changing definition of a TIMESTAMP field
· bug #1615530 [upload] added more specific error message
· if field upload fails
· bug #1627210, #1083301, #1482401 [data] warning on duplicate indexes
· bug #1668724 JavaScript focus login Opera
· bug #1666657 [auth] Cookie password delete on timeout / inactivity
· bug #1648802 different mysql library and server version
· bug #1662976 [auth] Authentication fails when controluser/pass
· is set
· bug #1643758 [import] Error #1264 importing NULL values in MySQL 5.0
· bug #1523747 [innodb] make warning about row count more visible
· bug #1676012 [auth] strip non-US-ASCII characters (RFC2616)
· bug #1679440 Added FAQ entry about header errors under IIS caused by
· an end-of-line character
· [gui] avoid displaying a wide selector in server selection
· bug #1614004 [relation] foreign key spanning multiple columns are
· incorrectly displayed
· bug #1681598 [interface] Edit next row
· bug #1688053 [export] Wrong export of binary character fields
· bug #1498281 [parser] Wrong primary key used for displaying results
· with subquery
· bug #1699772 Visual space bug in table name (in browser)
· bug #1699532 Cause of data manipulation issues: implemented changes
· as suggested by crisp_; still have to work on updating an ENUM value
· bug #1747215 Export emits blanks at line ends
· bug #1751172 Do not export data when exporting a single VIEW
· bug #1755339 Warn about rename database actually being copy/delete
· bug #1746921 Left frame shrinks on db change, thanks to Juergen Wind
· bug #1727138 HTML not encoded (more than 1000 characters)
· bug #1746186 LeftLogoLink fails if set to some external site
· bug #1759528 browse_foreigners fails due to newlines,
· thanks to Hanno Boeck
· bug #1751553 Drop-down instead of input when editing
August 21st, 2007· [import] support handling of DELIMITER to mimic mysql CLI,
· thanks to fb1
· improved PHP 6 compatibility
· [core] added PMA_fatalError() and made use of it
· [doc] changed all documentation in config.inc.php
· to phpDocumentor style
· [data] support for CREATE VIEW from query results
· [gui] dropped css/ folder and moved into root of PMA
· [l10n] new: Sinhala, Macedonian
· [export] YAML export (see yaml.org), thanks to Bryce Thornton
· [upload] moved file upload functionality into own class
· [upload] make use of cfg['TempDir'] for file uploads
· [server] improved display of binary logs
· [data] better error handling in tbl_create.php
· [routines] from Patch #1649881, thanks to Mike Beck
· [querywindow] store sql history in session
· [querywindow] sql history now without db too
· [querywindow] tweaks in sql history view
· [export] Native Excel (Spreadsheet_Excel_Writer) improvements,
· thanks to Christian Schmidt
· [doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch
· RFE #1435922 [gui] navigation frame shows listing of databases
· when none selected
· [data] support BIT datatype (under mysqli),
· thanks to Christian Schmidt
· [display] automatic confirmation for sort by key,
· thanks to Juergen Wind
· [data] can now choose the number of insert rows
· RFE #1704779 [gui] link documentation from login page
· RFE #1513345 [setup] check control user connection during setup
· [structure] TRIGGERS: display/edit/drop/SQL export
· [browse] store browse state in session per query
· [gui] Insert/Edit: no longer display the Go button each 15 lines
· but just at the end of a row
· [gui] Query window: use verbose server name if any
· [auth] patch #1712514 specify host for single signon,
· thanks to Thierry
· [gui] Navigator for the db list in the navigation panel
· [gui] Navigator for the table list in the content panel
· [display] Support for MySQL 5.0.37 profiling
RFE #1743983 [gui] Replace max_characters by a configurable param:
· cfg['MaxCharactersInDisplayedSQL']
· [display] patch #1749705, Allow multibyte characters in number
· formatting, thanks to garas
· [privileges] Support password hashing on the Edit Privileges
· interface
· [gui] Export: Select All/Unselect All over the choices,
· thanks to Florian Schmitz
Fixes:
· bug #1674914 [structure] changing definition of a TIMESTAMP field
· bug #1615530 [upload] added more specific error message
· if field upload fails
· bug #1627210, #1083301, #1482401 [data] warning on duplicate indexes
· bug #1668724 JavaScript focus login Opera
· bug #1666657 [auth] Cookie password delete on timeout / inactivity
· bug #1648802 different mysql library and server version
· bug #1662976 [auth] Authentication fails when controluser/pass
· is set
· bug #1643758 [import] Error #1264 importing NULL values in MySQL 5.0
· bug #1523747 [innodb] make warning about row count more visible
· bug #1676012 [auth] strip non-US-ASCII characters (RFC2616)
· bug #1679440 Added FAQ entry about header errors under IIS caused by
· an end-of-line character
· [gui] avoid displaying a wide selector in server selection
· bug #1614004 [relation] foreign key spanning multiple columns are
· incorrectly displayed
· bug #1681598 [interface] Edit next row
· bug #1688053 [export] Wrong export of binary character fields
· bug #1498281 [parser] Wrong primary key used for displaying results
· with subquery
· bug #1699772 Visual space bug in table name (in browser)
· bug #1699532 Cause of data manipulation issues: implemented changes as suggested by crisp_; still have to work on updating an ENUM value
· bug #1747215 Export emits blanks at line ends
· bug #1751172 Do not export data when exporting a single VIEW
· bug #1755339 Warn about rename database actually being copy/delete
· bug #1746921 Left frame shrinks on db change, thanks to Juergen Wind
· bug #1727138 HTML not encoded (more than 1000 characters)
· bug #1746186 LeftLogoLink fails if set to some external site
· bug #1759528 browse_foreigners fails due to newlines,thanks to Hanno Boeck
August 3rd, 2007· [import] support handling of DELIMITER to mimic mysql CLI, thanks to fb1 improved PHP 6 compatibility
· [core] added PMA_fatalError() and made use of it
· [doc] changed all documentation in config.inc.php to phpDocumentor style
· [data] support for CREATE VIEW from query results
· [gui] dropped css/ folder and moved into root of PMA
· [l10n] new: Sinhala, Macedonian
· [export] YAML export (see yaml.org), thanks to Bryce Thornton
· [upload] moved file upload functionality into own class
· [upload] make use of cfg['TempDir'] for file uploads
· [server] improved display of binary logs
· [data] better error handling in tbl_create.php
· [routines] from Patch #1649881, thanks to Mike Beck
· [querywindow] store sql history in session
· [querywindow] sql history now without db too
· [querywindow] tweaks in sql history view
· [export] Native Excel (Spreadsheet_Excel_Writer) improvements, thanks to Christian Schmidt
· [doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch
· RFE #1435922 [gui] navigation frame shows listing of databases when none selected
· [data] support BIT datatype (under mysqli), thanks to Christian Schmidt
· [display] automatic confirmation for sort by key, thanks to Juergen Wind
· [data] can now choose the number of insert rows
· RFE #1704779 [gui] link documentation from login page
· RFE #1513345 [setup] check control user connection during setup
· [structure] TRIGGERS: display/edit/drop/SQL export
· [browse] store browse state in session per query
· [gui] Insert/Edit: no longer display the Go button each 15 lines but just at the end of a row
· [gui] Query window: use verbose server name if any
· [auth] patch #1712514 specify host for single signon, hanks to Thierry
· [gui] Navigator for the db list in the navigation panel
· [gui] Navigator for the table list in the content panel
· [display] Support for MySQL 5.0.37 profiling
· RFE #1743983 [gui] Replace max_characters by a configurable param: cfg['MaxCharactersInDisplayedSQL']
· [display] patch #1749705, Allow multibyte characters in number formatting, thanks to garas
· [privileges] Support password hashing on the Edit Privileges interface
· [gui] Export: Select All/Unselect All over the choices, thanks to Florian Schmitz
Fixes:
· bug #1674914 [structure] changing definition of a TIMESTAMP field
· bug #1615530 [upload] added more specific error message if field upload fails
· bug #1627210, #1083301, #1482401 [data] warning on duplicate indexes
· bug #1668724 JavaScript focus login Opera
· bug #1666657 [auth] Cookie password delete on timeout / inactivity
· bug #1648802 different mysql library and server version
· bug #1662976 [auth] Authentication fails when controluser/pass is set
· bug #1643758 [import] Error #1264 importing NULL values in MySQL 5.0
· bug #1523747 [innodb] make warning about row count more visible
· bug #1676012 [auth] strip non-US-ASCII characters (RFC2616)
· bug #1679440 Added FAQ entry about header errors under IIS caused by an end-of-line character
· [gui] avoid displaying a wide selector in server selection
· bug #1614004 [relation] foreign key spanning multiple columns are incorrectly displayed
· bug #1681598 [interface] Edit next row
· bug #1688053 [export] Wrong export of binary character fields
· bug #1498281 [parser] Wrong primary key used for displaying results with subquery
· bug #1699772 Visual space bug in table name (in browser)
· bug #1699532 Cause of data manipulation issues: implemented changes as suggested by crisp_; still have to work on updating an ENUM value
· bug #1747215 Export emits blanks at line ends
· bug #1751172 Do not export data when exporting a single VIEW
· bug #1755339 Warn about rename database actually being copy/delete
· bug #1746921 Left frame shrinks on db change, thanks to Juergen Wind
· bug #1727138 HTML not encoded (more than 1000 characters)
· bug #1746186 LeftLogoLink fails if set to some external site
· bug #1759528 browse_foreigners fails due to newlines, thanks to Hanno Boeck
July 26th, 2007Improvements:
· [Import] support handling of DELIMITER to mimic mysql CLI, thanks to fb1
· improved PHP 6 compatibility
· [Core] added PMA_fatalError() and made use of it
· [doc] changed all documentation in config.inc.php
· to phpDocumentor style
· [Data] support for CREATE VIEW from query results
· [Gui] dropped css/ folder and moved into root of PMA
· [L10n] new: Sinhala, Macedonian
· [Export] YAML export (see yaml.org), thanks to Bryce Thornton
· [Upload] moved file upload functionality into own class
· [Upload] make use of cfg['TempDir'] for file uploads
· [Server] improved display of binary logs
· [Data] better error handling in tbl_create.php
· [Routines] from Patch #1649881, thanks to Mike Beck
· [Querywindow] store sql history in session
· [Querywindow] sql history now without db too
· [Querywindow] tweaks in sql history view
· [Export] Native Excel (Spreadsheet_Excel_Writer) improvements, thanks to Christian Schmidt
· [Doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch
· RFE #1435922 [gui] navigation frame shows listing of databases when none selected
· [Data] support BIT datatype (under mysqli), thanks to Christian Schmidt
· [Display] automatic confirmation for sort by key, thanks to Juergen Wind
· [Data] can now choose the number of insert rows
· RFE #1704779 [gui] link documentation from login page
· RFE #1513345 [setup] check control user connection during setup
· [Structure] TRIGGERS: display/edit/drop/SQL export
· [Browse] store browse state in session per query
· [Gui] Insert/Edit: no longer display the Go button each 15 lines but just at the end of a row
· [Gui] Query window: use verbose server name if any
· [Auth] patch #1712514 specify host for single signon, thanks to Thierry
· [Gui] Navigator for the db list in the navigation panel
· [Gui] Navigator for the table list in the content panel
· [Display] Support for MySQL 5.0.37 profiling
· RFE #1743983 [gui] Replace max_characters by a configurable param: cfg['MaxCharactersInDisplayedSQL']
· [Display] patch #1749705, Allow multibyte characters in number formatting, thanks to garas
· [Privileges] Support password hashing on the Edit Privileges interface
· [Gui] Export: Select All/Unselect All over the choices, thanks to Florian Schmitz
Fixes:
· Bug #1674914 [structure] changing definition of a TIMESTAMP field
· Bug #1615530 [upload] added more specific error message if field upload fails
· Bug #1627210, #1083301, #1482401 [data] warning on duplicate indexes
· Bug #1668724 JavaScript focus login Opera
· Bug #1666657 [auth] Cookie password delete on timeout / inactivity
· Bug #1648802 different mysql library and server version
· Bug #1662976 [auth] Authentication fails when controluser/pass is set
· Bug #1643758 [Import] Error #1264 importing NULL values in MySQL 5.0
· Bug #1523747 [innodb] make warning about row count more visible
· Bug #1676012 [auth] strip non-US-ASCII characters (RFC2616)
· Bug #1679440 Added FAQ entry about header errors under IIS caused by an end-of-line character
· [gui] avoid displaying a wide selector in server selection
· Bug #1614004 [relation] foreign key spanning multiple columns are incorrectly displayed
· Bug #1681598 [interface] Edit next row
· Bug #1688053 [export] Wrong export of binary character fields
· Bug #1498281 [parser] Wrong primary key used for displaying results with subquery
· Bug #1699772 Visual space Bug in table name (in browser)
· Bug #1699532 Cause of data manipulation issues: implemented changes as suggested by crisp_; still have to work on updating an ENUM value
· Bug #1747215 Export emits blanks at line ends
· Bug #1751172 Do not export data when exporting a single VIEW
· Bug #1755339 Warn about rename dataase actually being copy/delete
· Bug #1746921 Left frame shrinks on db change, thanks to Juergen Wind
· Bug #1727138 HTML not encoded (more than 1000 characters)
· Bug #1746186 LeftLogoLink fails if set to some external site
July 17th, 2007· Fixed bug #1734285 Copy database with VIEWs
· Fixed bug #1722502 DROP TABLE in export VIEW
· Fixed bug #1729027 Sorting results of VIEW browsing
· Fixed bug #1733012 Unwanted table alias in delete button
· Fixed bug #1736405 Pretty printer and HTML line breaks
· Fixed bug #1745257 Invalid DB name is still displayed
· Fixed bug #1730367 Calendar "Go" has no effect
· Patch #1750500 Smaller file for favicon.ico, thanks to Thijs Kinkhorst
· Fixed bug #1748633 Incorrect parameter validation for VIEWs
· [lang] Russian revision, thanks to Victor Volkov and the users of php-myadmin.ru
· Do not try to delete an internal relation if we just deleted an InnoDB one
April 25th, 2007· bug #1541147 [js] '#' in database names not correctly handled by queywindow.js
· bug #1671403 [parser] using "client" as table name
· bug #1672379 [core] Call to undefined function PMA_removeCookie()
· bug [core] undefined variable in libraries/tbl_replace_fields.inc.php
· bug [gui] query window icon did not work, thanks to Juergen Wind - windkiel
· [general] use PMA_getenv('PHP_SELF')
· bug #1676033 [core] pow(int,int) causes overflow
· bug #1680952 [core] undefined function PMA_getUvaCondition()
· bug #1596328 [export] drop support for POSTGRESQL compatibility mode
· bug #1609443 [privileges] Grant all priv. on wildcard name (fix message)
· bug #1567317 [sqp] Syntax highlighter: extra spaces
· bug #1239401 [sqp] table dot numeric field name
· bug #1672789 [sqp] Undefined offset: 4 in sqlparser.lib.php #1674
· bug #1682044 [export] Export file even if file not selected
· bug #1664212 querywindow loses url encoded characters
· replaced ctype_digit() with is_numeric()
· [config] clean cookies on phpMyAdmin upgrade
· bug #1674972 [export] no export with ¯m%
· bug #1667887 HTML maxlength
· bug #1679055 #1050 - Table 'table name' already exists
· patch #1681620 [interface] support reordering of cfg['ColumnTypes'], thanks to Leonard den Ottolander
· bug #1690718 Can't edit if BLOB and no PK
· bug #1672636 [export] PDF export too wide
· [lang] brazilian-portuguese update, thanks to Airon Luis Pereira
· patch #1698964 javascript typo, thanks to Corey Hollaway
· bug #1703897 [css] undefined index 'js_frame'
· bug #1690561 Blobs being cleared on Edit of row
· bug #1679801 [core] XSS vulnerability in PMA_sanitize(), thanks to sp3x SecurityReason
· bug #1704467 XSS vulnerability in browse_foreigners.php, thanks to sp3x SecurityReason
January 10th, 2007· improved support for web clusters
· deleting a user under MySQL 4.1.x
· DELIMITER in export no longer commented out
· export of query results and procedure definitions
· detection of a binary column
· problem on 64-bit systems
· granting all privileges on a wildcard name
· verification on encrypted zip files
· security fixes
November 21st, 2006· Security fixes
Find us on Google+
