- News - lists.phpmyadmin.net

[Phpmyadmin-news] phpMyAdmin 2.5.2 released
by Marc Delisle 25 Jul '03

25 Jul '03

The Internet, 2003-07-22 Greetings, the phpMyAdmin development team is pleased to announce the availability of phpMyAdmin 2.5.2. Improvements: * Preserve edited contents of the query window * Uploading of SQL when no database selected * Optional server list drop-down in left frame * "Options" tab merged in "Operations" * PDF report: paper size selection * $cfg['LimitChars'] now limits all non-numeric fields * MySQL 4.1 support: table and field charsets * Better Export functionnality, including export for big tables * Partial support for InnoDB foreign keys: PDF report, Select tab, results display * Visual editor (scratchboard) for PDF schema * Export any query in CSV, LaTeX, XML * Warning for missing length on VARCHAR * Export: checkbox for AUTO_INCREMENT value * Gzip output buffer: auto-detection and set to FALSE for IE 6.x * Display CREATE DATABASE query Fixes: * MySQL 4.1 related fixes: o User was unable to edit column privileges o The table structure page sometimes displayed "Array" in the charset column o When altering the field type, the input box for the field length sometimes had a strange default value o Erroneous export of timstamp fields o Incorrect row count for subqueries o Errors when inserting ENUM / SET values (in CVS) * Now use TRUNCATE with MySQL 4 when emptying multiple tables * Various HTML pretty printer problems * Bad display of parser bug report * docSQL and filename disclosure * Row count and DISTINCT * GD2 autodetection * Cookie: encrypt password (blowfish) * Wrong field names when exporting query results * Support for PROCEDURE ANALYSE * Security fix against bad JS code * Proper escaping in inline images * Safari detection and proper fonts * PDF schema and hardcoded A4 scaling * Incorrect row count for UNION * Better behavior when phpMyAdmin is within a frameset * Backslashes in username or password * Query statistics: percentages were wrong * Checks to avoid path disclosures * Do not display "Check referential integrity" for InnoDB tables. Download/support information on http://www.phpmyadmin.net. Regards, Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.5.2-rc2 released
by Marc Delisle 18 Jul '03

18 Jul '03

The Internet, 2003-07-14 Greetings, the phpMyAdmin development team is pleased to announce the availability of phpMyAdmin 2.5.2-rc2 (the second and probably last release candidate for 2.5.2). Improvements: * Preserve edited contents of the query window * Uploading of SQL when no database selected * Optional server list drop-down in left frame * "Options" tab merged in "Operations" * PDF report: paper size selection * $cfg['LimitChars'] now limits all non-numeric fields * MySQL 4.1 support: table and field charsets * Better Export functionnality, including export for big tables * Partial support for InnoDB foreign keys: PDF report, Select tab, results display * Visual editor (scratchboard) for PDF schema * Export any query in CSV, LaTeX, XML * Warning for missing length on VARCHAR * Export: checkbox for AUTO_INCREMENT value * Gzip output buffer: auto-detection and set to FALSE for IE 6.x * Display CREATE DATABASE query Fixes: * MySQL 4.1 related fixes: o User was unable to edit column privileges o The table structure page sometimes displayed "Array" in the charset column o When altering the field type, the input box for the field length sometimes had a strange default value o Erroneous export of timstamp fields o Incorrect row count for subqueries * Now use TRUNCATE with MySQL 4 when emptying multiple tables * Various HTML pretty printer problems * Bad display of parser bug report * docSQL and filename disclosure * Row count and DISTINCT * GD2 autodetection * Cookie: encrypt password (blowfish) * Wrong field names when exporting query results * Support for PROCEDURE ANALYSE * Security fix against bad JS code * Proper escaping in inline images * Safari detection and proper fonts * PDF schema and hardcoded A4 scaling * Incorrect row count for UNION * Better behavior when phpMyAdmin is within a frameset * Backslashes in username or password Download/support information on http://www.phpmyadmin.net. Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.5.1 released
by Marc Delisle 02 Jun '03

02 Jun '03

The Internet, 2003-06-02 Greetings, the phpMyAdmin development team is pleased to announce availability of phpMyAdmin 2.5.1. Improvements: * LaTeX export * Show multi-statement query result * Support for iconv parameters * Nested display of tables * CSV import from upload dir. * Save export to server * Check for same db/table when moving * Detection of missing scheme * Initial SQL box when no db exists * Reset button on edit page * Optional bigger textarea for LONGTEXTs * Show last inserted auto-increment id * Multi-tables CSV export * Can now disable ctrl-arrows moving * Export interface: can now override the use of LOCAL * Experimental MySQL 4.1 support Fixes: * Safari browser frame problems * "insert as another row" state * Confirmation when dropping databases * Light tabs displayed wrong * No longer saves in the history a query that generates an error * Error when not using backquotes in export * Incorrect "Create PHP code" * Edit link error * Better PDF schema * Incorrect GD2 detection * Avoid long delays when counting millions of rows * Empty value in ENUM * Frameset and XHTML * Execution of query in PHP code view * Hexification of BLOB when empty * Tabs highlighing * Wrong clickable columns and tool-tips with column alias * Behavior when clicking "Databases" * Invalid back link on invalid queries * Interface to SQL Validator * Correct parser behavior for "CHARACTER SET" and "SHOW INNODB STATUS" Download/support information on http://www.phpmyadmin.net. Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.5.1-rc1 is released
by Marc Delisle 28 May '03

28 May '03

The Internet, 2003-05-26 To: phpMyAdmin community The development team is pleased to announce version 2.5.1-rc1 (first release candidate) of phpMyAdmin. MySQL 4.1 note: phpMyAdmin 2.5.1 is not ready for MySQL 4.1. Improvements: * LaTeX export * Show multi-statement query result * Support for iconv parameters * Nested display of tables * CSV import from upload dir. * Save export to server * Check for same db/table when moving * Detection of missing scheme * Initial SQL box when no db exists * Reset button on edit page * Optional bigger textarea for LONGTEXTs * Show last inserted auto-increment id * Multi-tables CSV export * Can now disable ctrl-arrows moving Fixes: * Safari browser frame problems * "insert as another row" state * Confirmation when dropping databases * Light tabs displayed wrong * No longer saves in the history a query that generates an error * Error when not using backquotes in export * Incorrect "Create PHP code" * Edit link error * Better PDF schema * Incorrect GD2 detection * Avoid long delays when counting millions of rows * Empty value in ENUM * Frameset and XHTML * Execution of query in PHP code view * Hexification of BLOB when empty * Tabs highlighing * Wrong clickable columns and tool-tips with column alias * Behavior when clicking "Databases" * Invalid back link on invalid queries Download links, as usual, on http://www.phpmyadmin.net Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.5.0 released
by Marc Delisle 11 May '03

11 May '03

The Internet, 2003-05-11 To: phpMyAdmin community The development team is pleased to announce version 2.5.0 of phpMyAdmin. MySQL 4.1 note: phpMyAdmin 2.5.0 is not ready for MySQL 4.1. About future versions: The versions after 2.5.x will have those requirements: PHP >=4.1.0 and MySQL >=3.23.32. Improvements: * distinct Query window * field contents transformations (inline resized images, links, external programs, etc) * display column comments in exports * automatic update of relations, display fields, comments, bookmarks, etc after table/column changes * new display mode with 90 degree rotated headers * display query time * js row marker now works in vertical mode * SQL history: db- or not-db-based * optional vertical display of the columns in edit mode * optional lightweight menu tabs * InnoDB status monitor * print button in db view * new Export page with dynamic options * better security for docSQL importer * in edit mode, display first the functions that match field type * parameters for bookmarks queries * support for changing auto-increment value * default initial query in browse mode, based on a bookmark with the same name as the table * execute bookmarks when browsing bookmarks table * if available, display Create/Update/Check_time * in browse mode, highlight the fields used in the WHERE condition for the query * automatic layout of the PDF schema * choose results page in browse mode * automatic detection of compression for uploaded data * CHECK TABLE/ANALYZE TABLE for multisubmit actions * support for SHOW FULL PROCESSLIST * can now insert multiple fields at cursor position in the query textarea * can now choose all segments of a key (relations) Fixes: * could not insert some words like "$enum$" * bad URL (extra /) for generated PDFs * double password query with http auth * check privileges only shows root user * display SQL query used for an index modification * pdf schema headers footers for long pages * export results and LIMIT * inserting values with quotes * $cfg['PmaAbsoluteUri'] autodetection and CGI mode * escaping of \n, \r and \t characters * handling of disabled ini_get() * go back to fields definition form after an error * support XOR in the parser * check for field type when doing charset conversion * support for HTML entities as db/table/column names * avoid long delays when browsing big tables (MySQL 4) * support for host-based privileges * bad arrow aligning on PDF schema in "same widths" mode * faster record count * "undefined index" error in the data dictionary when using MySQL 3.22 or below * the privileges administration script did not work well with host-based DB privileges * having added a new user, the corresponding SQL query was not displayed * better "superuser" checking mechanism * "wrong parameter count" error when connecting with some strangely compiled php versions * replaced the %e placeholder in the date format string of some translations because it did not have any effect on Windows machines. * unaligned column headers * MONTH() and YEAR() not displayed as functions * error on "Skip Explain SQL" * bad Edit link on tables without primary key but with BLOB * now we export BLOBs hex quoted * better check for superuser in MySQL 4 * 2.5.0-rc1 syntax error SHOW TABLE STATUS LIKE... * highlight fields crossing db borders * FULLTEXT index type not shown in drop-down * disable CSV export for multiple tables Download links, as usual, on http://www.phpmyadmin.net Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.5.0-rc2 released
by Marc Delisle 27 Apr '03

27 Apr '03

The Internet, 2003-04-25 To: phpMyAdmin community The development team is pleased to announce version 2.5.0-rc2 (second release candidate) of phpMyAdmin. This one includes about 15 bug fixes from -rc1, along with updated translations. Final version is planned for mid-May. Download links and the detailed ChangeLog available on http://www.phpmyadmin.net. Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.5.0-rc1 is released
by Marc Delisle 16 Apr '03

16 Apr '03

The Internet, 2003-04-13 To: phpMyAdmin community The development team is pleased to announce version 2.5.0-rc1 (first release candidate) of phpMyAdmin. Improvements: * distinct Query window * field contents transformations (inline resized images, links, external programs, etc) * display column comments in exports * automatic update of relations, display fields, comments, bookmarks, etc after table/column changes * new display mode with 90 degree rotated headers * display query time * js row marker now works in vertical mode * SQL history: db- or not-db-based * optional vertical display of the columns in edit mode * optional lightweight menu tabs * InnoDB status monitor * print button in db view * new Export page with dynamic options * better security for docSQL importer * in edit mode, display first the functions that match field type * parameters for bookmarks queries * support for changing auto-increment value * default initial query in browse mode, based on a bookmark with the same name as the table * execute bookmarks when browsing bookmarks table * if available, display Create/Update/Check_time * in browse mode, highlight the fields used in the WHERE condition for the query * automatic layout of the PDF schema * choose results page in browse mode * automatic detection of compression for uploaded data * CHECK TABLE/ANALYSE TABLE for multisubmit actions * support for SHOW FULL PROCESSLIST * can now insert multiple fields at cursor position in the query textarea Fixes: * could not insert some words like "$enum$" * bad URL (extra /) for generated PDFs * double password query with http auth * check privileges only shows root user * display SQL query used for an index modification * pdf schema headers footers for long pages * export results and LIMIT * inserting values with quotes * $cfg['PmaAbsoluteUri'] autodetection and CGI mode * escaping of \n, \r and \t characters * handling of disabled ini_get() * go back to fields definition form after an error * support XOR in the parser * check for field type when doing charset conversion * support for HTML entities as db/table/column names * avoid long delays when browsing big tables (MySQL 4) * support for host-based privileges * bad arrow aligning on PDF schema in "same widths" mode * faster record count * "undefined index" error in the data dictionary when using MySQL 3.22 or below * the privileges administration script did not work well with host-based DB privileges * having added a new user, the corresponding SQL query was not displayed * better "superuser" checking mechanism * "wrong parameter count" error when connecting with some strangely compiled php versions * replaced the %e placeholder in the date format string of some translations because it did not have any effect on Windows machines. Download links, as usual, on http://www.phpmyadmin.net Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.4.0 released
by Marc Delisle 23 Feb '03

23 Feb '03

phpMyAdmin 2.4.0 - February 23rd, 2003 ====================================== A set of PHP-scripts to administrate MySQL over the WWW. ----------------------------------------- Announcement ------------ After 7 months of work and 2 release candidate versions, the phpMyAdmin developers are pleased to announce the availability of phpMyAdmin 2.4.0. phpMyAdmin is intended to handle the administration of MySQL over the Web, and is now one of the most popular PHP script used worldwide: more than 3.1 million download in the past year! SourceForge gave phpMyAdmin the "Project of the Month" award in December: look at the article http://sourceforge.net/pom_1202.php to learn more about the project's history. phpMyAdmin 2.4.0 includes the following highlights: Highlights ---------- Some improvements: * PDF pages - new data dictionary - support for deleting a PDF page definition - better browser support * cookie login: login error message * new server/user management interface with sub-pages - more intuitive interface - interface to most MySQL status variables - server traffic & query statistics - support new MySQL 4 privileges - support for user resource limits - privileges may now be edited without reloading the user tables - copy user profiles * Export - export to LaTeX format - better handling of charset conversion - better output order of inserts/creates - export results of any single-table SELECT * option to only copy data (append) to a table * better handling of confirmation requests (bookmarks) and LIMIT * support EXTRACT ... FROM * check/uncheck all for field selection * moving cursor with ctrl/arrows in table creation and row editing * images in PNG format where possible * display UPDATE SQL statement after a row edit * in Select sub-page, drop-down for ENUMs * support for compressed connections to the MySQL server * upload of binary file into a field * new documentation layout * (for phpMyAdmin developers) interface to DBG extension for debugging/profiling * show blob size Some fixes: * output handler warning for PHP >=4.3.0 * usernames with "@" character * links or submit buttons for db search results * warning for bzip problem of PHP 4.2.1 * wrong "Back" links * UNION processing generated undefined variables * handling of "LOCAL" in recent MySQL versions for LOAD DATA INFILE * wrong drop-down for foreign keys in Select sub-page * wrong charset information in XML exports * parsing error for the single quote case * problem with SQL validator interface * wrong parsing of INTERVAL and AUTO_INCREMENT * no longer allow invalid options like UNSIGNED in SET/ENUM * problem entering comments in Relation view * fix for kanji encoding problem * empty field names on add fields page caused problems * the quicklinks on top of each page are now pointing to the default tabs * problem with recieving the database list with MySQL >= 4.0.2-alpha * adjusted font sizes for Opera 7 for Windows and Konqueror * problems with editing the contents of the SQL query boxes with Opera 7 for Windows * query-by-example and only one table * do not display edit link for database-independent queries * fix some of the problems with record counting Detailed list of changes since version 2.2.0 is available under http://www.phpmyadmin.net/ChangeLog.txt Availability ------------ This software is available under the GNU General Public License V2.0. You can get the newest version at http://www.phpmyadmin.net/ Available file formats are: .zip, .tar.gz and .tar.bz2. If you install phpMyAdmin on your system, it's recommended to subscribe to the news mailing list by adding your address under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news This way, you will be informed of new updates and security fixes. It is a read only list, and traffic is not greater than a few mail every year. Support and Documentation ------------------------- The documentation is included in the software package as text and HTML file, but can also be downloaded from: http://www.phpmyadmin.net/documentation/ The software is provided as is without any express or implied warranty, but there is a bugs tracker page under: http://sourceforge.net/projects/phpmyadmin/ [click on "Bugs"] In addition, there are also a number of discussion lists related to phpMyAdmin. A list of mailing lists with archives is available at: http://sourceforge.net/mail/?group_id=23067 or http://sourceforge.net/projects/phpmyadmin/ [click on "Lists"] Finally, an users support forum is also available under: http://sourceforge.net/forum/forum.php?forum_id=72909 Known bugs ---------- * The total number of rows of UNION SELECT is not calculated correctly. * Some users reported problems on machines running Zend Accelerator (TM). * The MySQL 4.1.x and php 5.0.x branches are not yet supported by phpMyAdmin. * Displaying large exports may crash Microsoft Internet Explorer. * When renaming tables or fields the relations set in phpMyAdmin are lost. To be informed about new releases fixing these problems, please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Description ----------- phpMyAdmin is intended to handle the administration of MySQL over the WWW. It can manage a whole MySQL server as well as a single database. Currently it can: - create and drop databases - create, copy, drop, rename and alter tables - do table maintenance - delete, edit and add fields - execute any SQL-statement, even batch-queries - manage keys on fields - load text files into tables - create and read dumps of tables - export data to CSV, XML and Latex formats - administer multiple servers - manage MySQL users and privileges - check referential integrity - using Query-by-example (QBE), create complex queries automatically connecting required tables - create PDF graphics of your Database layout - search globally in a database or a subset of it - communicate in 42 different languages Author & Copyright ------------------ Copyright (C) 1998-2000 Tobias Ratschiller <tobias.ratschiller_at_maguma.com> Copyright (C) 2001- Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Loïc Chapeaux <lolo_at_phpHeaven.net> Robin Johnson <robbat2_at_users.sourceforge.net> Armel Fauveau <armel.fauveau_at_globalis-ms.com> Steve Alberty <alberty_at_neptunlabs.de> Alexander M. Turek <rabus_at_users.sourceforge.net> Mike Beck <mikebeck_at_users.sourceforge.net> Michal Cihar <nijel_at_users.sourceforge.net> Garvin Hicking <hicking_at_faktor-e.de> + many other people (check the CREDITS section of our documentation) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA EOF -- Alexander M. Turek / 2003-02-23

1 0

[Phpmyadmin-news] phpMyAdmin 2.4.0-rc2 is released
by Marc Delisle 17 Feb '03

17 Feb '03

The Internet, 2003-02-17 To: phpMyAdmin community The development team is pleased to announce version 2.4.0-rc2 (second release candidate) of phpMyAdmin. The test cycle is going well, testers of -rc1 found some bugs so -rc2 is better :) and contains a more polished new privileges/db management system. Improvements: * PDF pages o new data dictionary o support for deleting a PDF page definition o better browser support * cookie login: login error message * new server/user management interface with sub-pages o more intuitive interface o interface to most MySQL status variables o server traffic & query statistics o support new MySQL 4 privileges o support for user resource limits o privileges may now be edited without reloading the user tables o copy user profiles * Export o export to LaTeX format o better handling of charset conversion o better output order of inserts/creates o export results of any single-table SELECT * option to only copy data (append) to a table * better handling of confirmation requests (bookmarks) and LIMIT * support EXTRACT ... FROM * check/uncheck all for field selection * moving cursor with ctrl/arrows in table creation and row editing * images in PNG format where possible * display UPDATE SQL statement after a row edit * in Select sub-page, drop-down for ENUMs * (experimental) support for compressed connections to the MySQL server * upload of binary file into a field * new documentation layout * (for phpMyAdmin developers) interface to DBG extension for debugging/profiling * show blob size Fixes: * output handler warning for PHP >=4.3.0 * usernames with "@" character * links or submit buttons for db search results * warning for bzip problem of PHP 4.2.1 * wrong "Back" links * UNION processing generated undefined variables * handling of "LOCAL" in recent MySQL versions for LOAD DATA INFILE * wrong drop-down for foreign keys in Select sub-page * wrong charset information in XML exports * parsing error for the single quote case * problem with SQL validator interface * wrong parsing of INTERVAL and AUTO_INCREMENT * no longer allow invalid options like UNSIGNED in SET/ENUM * problem entering comments in Relation view * fix for kanji encoding problem * empty field names on add fields page caused problems * the quicklinks on top of each page are now pointing to the default tabs * problem with receiving the database list with MySQL >= 4.0.2-alpha (in CVS) * adjusted font sizes for Opera 7 for Windows and Konqueror (in CVS) * problems with editing the contents of the SQL query boxes with Opera 7 for Windows (in CVS) * query-by-example and only one table * do not display edit link for database-independent queries * fix some of the problems with record counting Download links, as usual, on http://www.phpmyadmin.net Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.4.0-rc1 is released
by Marc Delisle 03 Feb '03

03 Feb '03

The Internet, 2003-02-02 To: phpMyAdmin community The development team is pleased to announce version 2.4.0-rc1 (first release candidate) of phpMyAdmin. Improvements: * PDF pages o new data dictionary o support for deleting a PDF page definition o better browser support * cookie login: login error message * new server/user management interface with sub-pages o more intuitive interface o support new MySQL 4 privileges o support for user resource limits * Export o export to LaTeX format o better handling of charset conversion o better output order of inserts/creates o export results of any single-table SELECT * option to only copy data (append) to a table * better handling of confirmation requests (bookmarks) and LIMIT * support EXTRACT ... FROM * check/uncheck all for field selection * moving cursor with ctrl/arrows in table creation and row editing * images in PNG format where possible * display UPDATE SQL statement after a row edit * in Select sub-page, drop-down for ENUMs * (experimental) support for compressed connections to the MySQL server * upload of binary file into a field * new documentation layout * (for phpMyAdmin developers) interface to DBG extension for debugging/profiling Fixes: * output handler warning for PHP >=4.3.0 * usernames with "@" character * links or submit buttons for db search results * warning for bzip problem of PHP 4.2.1 * wrong "Back" links * UNION processing generated undefined variables * handling of "LOCAL" in recent MySQL versions for LOAD DATA INFILE * wrong drop-down for foreign keys in Select sub-page * wrong charset information in XML exports * parsing error for the single quote case * problem with SQL validator interface * wrong parsing of INTERVAL and AUTO_INCREMENT * no longer allow invalid options like UNSIGNED in SET/ENUM * problem entering comments in Relation view * fix for kanji encoding problem * empty field names on add fields page caused problems Download links, as usual, on http://www.phpmyadmin.net Marc Delisle, for the team.

1 0