1 phpMyAdmin - ChangeLog
4 3.4.2.0 (not yet released)
5 - bug #3301249 [interface] Iconic table operations does not remove inline edit label
6 - bug #3303869 [interface] Unnecessary scrolling on Databases page
7 - patch #3303813 [setup] Define a label that was missing
8 - bug #3305606 [interface] Show all button wraps on privileges page
9 - bug #3305517 [config] Config for export compression not used
10 - bug #3305883 [interface] Table is dropped regardless of confirmation
11 - [auth] Fixed error handling for signon auth method.
12 - bug #3276001 [core] Avoid caching of index.php.
13 - bug #3306958 [interface] Unnecessary Details slider
16 - bug #3301108 [interface] Synchronize and already configured host
17 - bug #3302457 Inline edit and $cfg['PropertiesIconic']
18 - Patch #3302313 Show a translated label
19 - bug #3300981 [navi] Table filter is case sensitive
20 - bug #3285929 [privileges] Revert temporary fix
21 - bug #3302872 [synchronize] Synchronize and user name
22 - bug #3302733 [core] Some browsers report an insecure https connection
23 - [security] Make redirector require valid token
26 + rfe #2890226 [view] Enable VIEW rename
27 + rfe #838637 [privileges] Export a user's privileges
28 - [core] Updated mootools to fix some glitches with Safari.
29 + rfe #2816943 [interface] Add REGEXP ^...$ to select dialog.
30 + rfe #2924956 [interface] Add insert ignore option to editing row.
31 + rfe #2838080 [interface] Show warning when javascript is disabled.
32 + rfe #2823707 [edit] Call UUID function separately to show it in insert.
33 + rfe #2420684 [export] Allow export of timestamps in UTC.
34 + [core] Remove config data from session as it brings chicken-egg problem.
35 + [core] Cookie path now honors PmaAbsoluteUri.
36 + rfe #2393597 [core] phpMyAdmin honors https in PmaAbsoluteUri.
37 + rfe #1778337 [core] Try moving tables by RENAME and fail to CREATE/INSERT if that fails.
38 + rfe #1721189 [core] Force reload js on code change.
39 + rfe #1954161 [interface] Do not display long numbers in server status.
40 + rfe #2033616 [edit] Add option to just display insert query.
41 + rfe #1435032 [interface] Move SSL status to the end, it is usually empty.
42 + rfe #1340812 [interface] Show numbers of columns in table structure.
43 + rfe #1186511 [inrerface] Add link to reload navigation frame.
44 + rfe #2936156 [auth] Signon authentication forwards error message through session data.
45 + rfe #2835109 [interface] Move ^1 to the end of message.
46 + rfe #854911 [interface] Grey out non applicable actions in structure
47 + [interface] Allow to create new table from navigation frame (in light mode).
48 + rfe #1025696 [browse] Add direct download of binary fields.
49 - [browse] Properly display NULL value for BLOB.
50 - rfe #1516803 [edit] Allow to set BLOB to/from NULL with ProtectBinary.
51 - [edit] Do not default to UNHEX when using file upload.
52 - rfe #1379201 [core] Add option to configure session_save_path.
53 + [interface] Provide links to documentation in highlighted SQL.
54 + [interface] It is now possible to bookmark most pages in JS capable browser.
55 - bug #2936482 [core] Fix SSL detection.
56 + rfe #2937850 [doc] Add some hints to chk_rel.php for quick setup.
57 + rfe #2938579 [interface] Add class to some elements for easier theming.
58 + rfe #2937840 [doc] Add some interesting configs to config.sample.inc.php.
59 + rfe #2792992 [doc] Added advice to re-login after changing pmadb settings
60 + patch #2952353 [interface] Prefill "Copy table to" in tbl_operations.php, thanks to iinl
61 + [lang] Add English (United Kingdom) translation, thanks to Robert Readman.
62 + patch #2948421 [auth] HTTP Basic auth realm name,
63 thanks to Harald Jenny - haraldj
64 - bug #2954916 [interface] Do not insert doc links to not formatted SQL.
65 + [lang] Chinese Simplified update, thanks to Shanyan Baishui - rimyxp
66 + [lang] Turkish update, thanks to Burak Yavuz
67 + rfe #2963310 [interface] Focus TEXTAREA "sql_query" on click on "SQL" link
68 + [lang] Uzbek update, thanks to Orzu Samarqandiy
69 + rfe #2958013 [import] After import, also list uploaded filename, thanks
70 to Pavel Konnikov and Herman van Rink
71 + patch #2974341 [structure] Clicking on table name in db Structure should
72 Browse the table if possible, thanks to bhdouglass - dougboybhd
73 + patch #2975533 [search] New search operators, thanks to
75 + patch #2967320 [designer] Colored relations based on the primary key,
76 thanks to GreenRover - greenrover
77 - [core] Provide way for vendors to easily change paths to config files.
78 + patch #2979922, rfe #2804874 [interface] Add inline query editing, thanks to Muhammd Adnan.
79 - bug #2966752 [setup] Allow to configure changes tracking in setup script.
80 + patch #2981165 [edit] Optionally disable the Type column,
81 thanks to Brian Douglass - bhdouglass
82 + patch #2984058 [edit] Buttons for quicky creating common SQL queries, thanks
84 + patch #2984337 [interface] Convert loading of export/import to jQuery ready
85 event, thanks to sutharshan.
86 - [edit] CURRENT_TIMESTAMP is also valid for datetime fields.
87 - patch #2985068 [engines] Fix parsing of PBXT status, thanks to Madhura Jayaratne.
88 - patch #2986073 [interface] Convert upload progress bar to jQuery, thanks to
90 - patch #2983960 [interface] Add javascript validation of datetime input,
91 thanks to Sutharshan Balachandren.
92 - rfe #2981999 [interface] Default sort order is now SMART.
93 - rfe #2972969 [interface] Fix flipping of headers in non-IE browsers.
94 + rfe #2964518 [interface] Allow to choose servers from configuration for
96 + rfe #2988633 [relation] Improve ON DELETE/ON UPDATE drop-downs
97 + rfe #2988629 [relation] Improve labels in relation view
98 + rfe #2983207, patch #2988715 [interface] Use jQuery calendar dialog, thanks
100 + [doc] Incorporate synchronisation docs into main document.
101 + [core] Include Content Security Policy HTTP headers.
102 - bug #3004216 [CSS] Field attributes use inline CSS
103 - patch #2999595, rfe #2998130 [interface] Cleanup navigation frame.
104 - patch #3025161 [core] Prevent sending of unnecessary cookies,
105 thanks to Piotr Przybylski - crackpl
106 - bug [password] Generate password only available if JS is enabled
107 (fixed for Privileges and Change password)
108 - [core] RecodingEngine now accepts none as valid option.
109 + [core] Dropped AllowAnywhereRecoding configuration variable.
110 - rfe #3016457 [interface] Define tab order in SQL form to allow easier tab
112 + [core] Centralized format string expansion, @VARIABLES@ are recommended way
113 now, used by file name templates, default queries, export and title
115 + [validator] SQL validator works also with SOAP PHP extension.
116 - [interface] Better formatting for SQL validator results.
117 - [doc] The linked-tables infrastructure is now called phpMyAdmin
118 configuration storage.
119 - [interface] Move drop/empty links from being tabs to Operations tab.
120 - [interface] Fixed rendering of error/notice/info titles background.
121 - patch #3038293 [doc] Language and grammar fixes,
122 thanks to Isaac Bennetch - ibennetch
123 - patch #3038312 [export] JSON export,
124 thanks to Hauke Henningsen - blubberkeks152
125 - rfe #1494550 [interface] Editor for SET/ENUM fields.
126 - rfe #2649375 [interface] Simplified interface to backup/restore.
127 - rfe #2973909 Users preferences
128 - [relations] Dropped WYSIWYG-PDF configuration variable.
129 - rfe #806035, #686260 [relations] Export relations to Dia, SVG and others
130 + [interface] Added charts to status tab, profiling page and query results
131 + [interface] AJAXification on various pages
132 - [core] Remove last remaining parts of profiling code which was removed in 2006.
133 - bug #3042665 [parser] Add workaround for MySQL way of handling backtick.
134 - bug #3056610 [interface] Removed modification options for information_schema
135 + patch #3055886 [config] Add Left frame table filter visibility config option, thanks to eesau
136 - [core] Force generating of new session on login
137 + rfe #1105678 [interface] Drop page-break-before as it is useless for smaller
139 + rfe #2956556 [interface] Allow to wrap enum values.
140 - bug #1669459 [interface] Do not automatically mark PDF schema rows to delete
141 - bug #3087682 [interface] Do not apply LeftFrameDBSeparator on first character.
142 + rfe #3111455 [interface] Column highlighting and marking in table view
143 + Visual query builder
144 - bug #3115519 [interface] Prevent long queries from being shown in confirmation popup
145 - patch #3112792 [navi] Left panel table grouping incorrect,
146 thanks to garas - garas
147 - bug #3123433 [interface] Avoid double escaping of MySQL errors.
148 - [interface] Use less noisy message and remove disable link on server charts and database statistics.
149 + rfe #3141330 [relation] When displaying results, show a link to the foreign
150 table even when phpMyAdmin configuration storage is not active
151 - bug #3141327 [relation] Foreign key input options
152 - [export] Better handling of export to PHP array.
153 - rfe #3158867 [privileges] No DROP DATABASE warning if you delete a user
154 - [interface] Add link to documentation for status variables.
155 - [security] Redirect external links to avoid Referer leakage.
156 - [interface] Default to not count tables in database.
157 - patch #3172172 [interface] Shortcut for copying table row.
158 - bug #3175227 [auth] Reset user cache on login.
159 - rfe #3148361 [interface] Replace hard coded limit with $cfg['LimitChars'].
160 - bug #3177136 [interface] Indicate that bookmark is being used on browse.
161 - [interface] Indicate shared bookmarks in interface.
162 - patch #3176420 [Search] Ajaxify browse and delete criteria in DB Search,
163 thanks to Thilanka Kaushalya
164 - [interface] New default theme pmahomme, dropped darkblue_orange theme.
165 - rfe #2936155 [auth] Allow to pass additional parameters using signon method.
166 - rfe #1640812 [auth] Add example for OpenID authentication using signon method.
167 - rfe #1312657 [dbi] Default to mysqli extension.
168 - rfe #1168350 [interface] Add clear button to SQL edit box.
169 - [core] Update library PHPExcel to version 1.7.6
170 - bug #3206876 [core] Work without mbstring installed.
171 - rfe #3196075, patch #3212068 [interface] Add links to variables documentation.
172 - bug #3208723 [import] Fix import of utf-8 XML files.
173 - bug #3039384 [auth] Force signon auth on signon URL change.
174 - bug #3168733 [core] Synchronization does not honor AllowArbitraryServer
175 - bug #3134495 [synchronization] Data containing single quotes prevents sync,
177 - Remove the custom color picker feature
178 - bug #3285929 [privileges] Don't fail silently on missing priviledge to execute REVOKE ALL PRIVILEGES
180 3.3.11.0 (not yet released)
182 3.3.10.1 (2011-05-20)
183 - [security] XSS on Tracking page
185 3.3.10.0 (2011-03-19)
186 - patch #3147400 [structure] Aria table size printed as unknown,
187 thanks to erickoh75 - erickoh75
188 - patch #3150164 [structure] Ordering by size gives incorrect results,
189 thanks to Madhura Jayaratne - madhuracj
190 - bug #3153409 [core] 0 row(s) affected
191 - bug #3155842 [core] Edit relational page and page number
192 - [security] Minor security fixes, see PMASA-2010-9 and PMASA-2010-10
193 - [lang] German update, thanks to to jannicars@users.sourceforge.net.
196 - [security] SQL injection, see PMASA-2011-2
199 - [security] Path disclosure, see PMASA-2011-1
202 - bug [doc] Fix references to MySQL doc
203 - patch #3101490 Default function for TIMESTAMP, thanks to jirand - jirand
204 - bug #3103853 [js] Double quotes were not escaped in generated js
205 - bug #3077463 [core] Events were not copied when copying/renaming database
206 - bug #1762306 [core] Copy database with view of a view
207 - patch #3117535 [replication] Add quotes to database in initial statement,
208 thanks to Craig Duncan - duncan3dc
209 - bug #3112614 [pdf schema] Scratchboard for PDF pages not working
210 - bug #3125606 [parser] Query for table "level" causes strange display
211 - bug #3127904 [parser] Close all opened round brackets indents
214 - bug #3115519 (private) [security] XSS on db search, see PMASA-2010-8
217 - bug #3059311 [import] BIGINT field type added to table analysis
218 - [core] Update library PHPExcel to version 1.7.4
219 - bug #3062455 [core] copy procedures and routines before tables
220 - bug #3062455 [export] with SQL, export procedures and routines before tables
221 - bug #3056023 [import] USE query not working
222 - bug #3038193 [display] Error when editing row with GEOMETRY column
223 - bug #3062454 [interface] Display routines/events also when no tables are defined
224 - support ARIA storage engine as well as its previous name MARIA
227 - patch #3050492 [PDF scratchboard] Cannot drag table box to the edge after
228 a page size increase, thanks to Martin Schönberger - mad05
231 - bug #3033063 [core] Navi gets wrong db name
232 - bug #3031705 [core] Fix generating condition for real numbers by comparing
234 - bug #3034026 [confirmation] TRUNCATE queries get no confirmation request
235 - bug #3036132 [core] Triggers not fetched if dbname has an hyphen
236 - patch #3039269 [dbi] Wrong variable checked for nopassword option,
237 thanks to Will Palmer - wpalmer
238 - bug #3040226 [XHTML] LockFromUpdate checkbox not checked by default
239 - bug [doc] Withdraw or edit FAQ entries related to older MySQL or PHP
240 - bug #3042706 [pmadb] Relations, bookmarks, etc deleted after table drop
241 - bug #3044189 [doc] Cleared documentation for hide_db.
242 - bug #3042495 [core] Move PMA_sendHeaderLocation to core.lib.php.
245 - [core] Fixed various XSS issues, see PMASA-2010-5 for more details.
248 - patch #2932113 [information_schema] Slow export when having lots of
249 databases, thanks to Stéphane Pontier - shadow_walker
250 - bug #3022705 [import] Import button does not work in Catalan when there
251 is no progress bar possible
252 - bug [replication] Do not offer information_schema in the list of databases
253 - bug [js] Avoid loading twice a js file
254 - bug #3024344 [setup] Setup forces numeric MemoryLimit
255 - bug #3025975 [auth] Odd LoginCookieValidity default value
256 - bug #3026400 [PHP] ereg functions are deprecated
257 - bug #3027557 [PHP] split() deprecated in PHP 5.3 (backport fixes from master)
258 - bug #3023507 [core] No result set display from stored procedure SELECT
259 - bug [export] CSV for MS Excel (Windows) should have semi-colon as separator
260 - [core] Update library PHPExcel to version 1.7.3c
261 - bug #2994885, bug #3029168 [import] Convert Excel column name correctly
262 - bug [scripts] MySQL 5.5.5 does not accept TIMESTAMP(14) in create_tables.sql
265 - bug #2996161 [import] properly escape import value
266 - bug #2998889 [import] Import button does not work in Catalan
267 - [browse] Fix handling of sort order if only column is specified.
268 + [lang] Greek update, thanks to Panagiotis Papazoglou - panos78
269 + [lang] Updated lot of translation based on work done in master branch.
270 - bug #3008411 [databases] Last dropped database remains active in navi
271 - bug #2986383 [parser] Not all data being shown / counted
272 - bug [synchronize] Rows were deleted in target table regardless of the
273 "Would you like to delete..." option
274 - bug [privileges] List of tables not shown when the db name has a wildcard
275 - bug #3011126 [display] Edit link missing after long query
276 - patch #3013264 [doc] FAQ 1.40 uses a comma instead of a period,
277 thanks to Isaac Bennetch - ibennetch
278 - [engines] Fix getting InnoDB status.
279 - bug #2986422 [import] Results for query are not displayed
282 - patch #2982480 [navi] Do not group if there would be one table in group,
283 thanks to Lorikeet Lee.
284 - patch #2983492 [sync] When asking to synchronize Structure and Data,
285 only Structure is done, thanks to Ankit Gupta - ankitgupta3
286 - patch #2984893 [engines] InnoDB storage page emits a warning,
287 thanks to Madhura Jayaratne - madhuracj
288 - bug #2974687, bug #2974692 [compatibility] PHPExcel : IBM AIX iconv() does not work,
289 thanks to Björn Wiberg - bwiberg
290 - bug #2983066 [interface] Flush table on table operations shows the query twice,
291 thanks to Martynas Mickevičius - BlinK_
292 - bug #2983060, patch #2987900 [interface] Fix initial state of tables in
293 designer, thanks to Sutharshan Balachandren.
294 - bug #2983062, patch #2989408 [engines] Fix warnings when changing table
295 engine to Maria, thanks to Madhura Jayaratne.
296 - bug #2974067 [display] non-binary fields shown as hex
297 - bug #2983065 [operations] Error when changing from Maria to MyISAM engine
298 - bug #2975408 [tracking] Data too long for column data_sql
299 - bug [tracking] Tracking report should obey MaxCharactersInDisplayedSQL
300 - bug [edit] Avoid selecting UNHEX function by default for a BLOB column for
301 which editing is protected
302 - bug #2994168 [structure] Show auto_increment in uppercase
303 - bug #2993970 [pdf schema] Page numbering in Table of Contents
306 - patch #2969449 [core] Name for MERGE engine varies depending on the
307 MySQL version, thanks to Dieter Adriaenssens - ruleant
308 - bug #2966078 [browse] Incorrect LIMIT is saved and sticks while browsing
309 - bug #2967366 [Structure] Some results of Propose table structure are
311 - bug #2967565 [insert] UNHEX not selected by default when inserting BINARY
312 - [navi] Changed link to git repository on main page
313 - bug #2972232 [menu] Import menu tab not present on main page
314 - patch #2976790 [menu] Go to the upper level after table DROP,
315 thanks to Kaarel Nummert - kaarelnu
316 - patch #2978815 [pdf] Fix generating PDF with table dimensions, thanks to BlinK_
317 - patch #2977725 [export] XML wrongly encoded, thanks to Victor Volkov - hanut
318 - patch #2979234 [import] Create tables with current charset and collation.
319 - patch #2979234, bug #2960105 [import] Properly import unicode text from ODS.
320 - bug #2973280 [export] Proper handling of temporary directory in XLS export.
321 - bug #2980582 [interface] Properly format server status parameter.
322 - bug #2973949 [session] SQL History broken (revert patch #2899969),
323 thanks to Dieter Adriaenssens - ruleant
324 - [doc] Be more specific about problems with Suhosin.
327 - bug #2941037 [core] Database structure not sorted by table correctly
328 - bug #2948492 [interface] Slide effect masks some fields on search page
329 - bug #2959746 [interface] Unknown table status: TABLE_TYPE
330 - bug #2953050 [export] export VIEW as SQL includes INSERT statement
331 - bug #2942032 [core] Cannot detect PmaAbsoluteUri correctly on Windows
332 - bug #2961609 [auth] Potential information disclosure at login page
333 - patch #2961540 [export] Do not export data of MERGE table,
334 thanks to Dieter Adriaenssens - ruleant
335 - bug #2961198 [parser] Querying a table named "data"
336 - bug #2931429 [structure] Editing long triggers
337 - bug #2970769 [structure] Incorrect reference to mootools-more.js
340 + rfe #2308632 [edit] Use hex for (var)binary fields,
341 thanks to Maarten Dieleman - maartendieleman
342 + patch #2794819 [navi] Filter for displayed table names,
343 thanks to Michael Valushko - dylfin
344 - bug #2794840 [core] Cannot redeclare pma_tableheader()
345 - rfe #2726479 [core] configurable maximal length of URL
346 + patch #2724755 [display] Full/partial text links (big T) are back,
347 thanks to nullbarriere - nullbarriere
348 - bug [display] handle NavigationBarIconic as documented for navi buttons
349 + rfe #2726479 [export] Export tables preselect
350 + patch #2805828 [export] PHP array export plugin,
351 thanks to Geoffray Warnants - amnsk
352 + patch #2798592 [import] Progress bar,
353 thanks to Tomas Srnka - tomassrnka
354 - bug [gui] Generate Password not working for 'Change Login Information', only for 'Change password'
355 + [lang] Arabic update, thanks to Meno25 - meno25
356 + rfe #2822190 [structure] BOOLEAN is standard SQL
357 + [lang] German update, thanks to knittl
358 + [lang] German update, thanks to virsacer
359 + rfe #2813867 [structure] Default sorting order in list of tables
360 + [import] Added MySQL type-detection functionality to import library,
361 thanks to Derek Schaefer
362 + [import] Added ODS, Excel XLS, Excel XLSX, and XML import modules,
363 thanks to Derek Schaefer
364 + [export] Added Excel XLSX export module,
365 thanks to Derek Schaefer
366 + [core] Added ability for tracking changes made through phpMyAdmin
367 + rfe #2839504 [engines] Support InnoDB plugin's new row formats
368 + [core] Added ability for synchronizing databases among servers.
369 + [lang] #2843101 Dutch update, thanks to scavenger2008
370 + [lang] Galician update, thanks to Xosé Calvo - xosecalvo
371 + [export] Added MediaWiki export module,
372 thanks to Derek Schaefer - drummingds1
373 + [lang] Turkish update, thanks to Burak Yavuz
374 + [auth] Add custom port configuration in signon, thanks to Gary Smith
375 - [core] Removed context from the error handler
376 - bug #2883633 [export] Export of InnoDB table is incomplete
377 + rfe #2862575 [status] Order query statistics by % desc, skip rows with 0
378 + rfe #2823686 [interface] Increase default height of query window
379 + rfe #2129902 [structure] Don't hide indexes
380 + patch #2812070 [interface] Allow selecting a range of rows by holding shift, thanks to Joolee
381 + [lang] Russian update, thanks to Victor Volkov
382 + [lang] Greek update, thanks to Panagiotis Papazoglou
383 + [lang] Norwegian update, thanks to Sven-Erik Andersen
384 - bug #2929958 [import] Cannot import (French interface)
385 - [security] Use X-Frame-Options header to protect against ClickJacking.
386 + [lang] Finnish update, thanks to Jouni Kahkonen
387 + [lang] Lithuanian update, thanks to Rytis Slatkevicius - rytis_s
388 - bug #2931939 [status] Seeing "m" as unit is confusing
389 - bug #2926613 [edit] Copy database shows errors when DB has foreign key
390 + [lang] Catalan update, thanks to Xavier Navarro
392 3.2.6.0 (not released)
393 - bug #2938492 [display] information_schema sorting order
394 - bug #2941101 [import] import timeout when table already created and
396 - bug #2944069 [config] Extraneus dot from dirname() when installed in root, thanks to ayanamist
399 - patch #2903400 [bookmarks] Status of bookmark table,
400 thanks to Virsacer - virsacer
401 - bug [history] QueryHistoryDB is not respected
402 - bug #2905629 [auth] Blowfish secret is not hashed
403 - bug #2910000 [gui] ShowServerInfo should hide all server info from main page
404 - bug #2910568 [structure] Table size for ARCHIVE tables is not displayed
405 - patch #2899969 [core] Session lock blocks working from a second window,
406 thanks to Greg Roach - fisharebest
407 - patch #2915168 [import] Incorrect parsing of DELIMITER keyword,
408 thanks to Greg Roach - fisharebest
409 - patch #2918831 [export] Missing backquotes on reserved words,
410 thanks to Virsacer - virsacer
411 - [core] Fix broken cleanup of $_GET
412 - bug #2924357 [operations] Cannot rename a database that has foreign key
414 - bug #869006 [structure] Ignore number of records for MRG_MyISAM tables
415 - bug [browse] "Show BLOB contents" should display HTML code that is present
416 in a BLOB, thanks to Vincent van der Tuin
417 - [privileges] Improve escaping of hostname
419 --- Older ChangeLogs can be found on our project website ---
420 http://www.phpmyadmin.net/old-stuff/ChangeLogs/
422 # vim: et ts=4 sw=4 sts=4
423 # vim: ft=changelog fenc=utf-8
424 # vim: fde=getline(v\:lnum-1)=~'^\\s*$'&&getline(v\:lnum)=~'\\S'?'>1'\:1&&v\:lnum>4&&getline(v\:lnum)!~'^#'
425 # vim: fdn=1 fdm=expr