- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] phpMyAdmin 2.9.2 is released
by Marc Delisle 16 Jan '07

16 Jan '07

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.9.2 http://www.phpmyadmin.net phpMyAdmin 2.9.2 - January 16, 2007 ====================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project announces the immediate availability of phpMyAdmin 2.9.2, a bugfix-only release containing security fixes. See the Security section of phpmyadmin.net for details. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular Web GUI for MySQL. Fixes ----- * 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 Detailed list of changes 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 ---------- Please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- (from http://www.phpmyadmin.net/documentation) phpMyAdmin handles the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: * easily browse through databases and tables * create, copy, rename, alter and drop databases * create, copy, rename, alter and drop tables * do table maintenance * add, edit and drop fields * execute any SQL-statement, even multiple queries * create, alter and drop indexes * load text files into tables * create (*) and read dumps of tables or databases * export (*) data to SQL, CSV, XML, Word, Excel, PDF and Latex formats * administer multiple servers * manage MySQL users and privileges * check server settings and runtime information with configuration hints * check referential integrity in MyISAM tables * 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 * transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link * support InnoDB tables and foreign keys (see FAQ 3.6) * support mysqli, the improved MySQL extension (see FAQ 1.17) * communicate in 50 different languages (*) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps and CSV exports if you use PHP4 >= 4.0.4 with Zlib support (--with-zlib) and/or Bzip2 support (--with-bz2). Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2006 Marc Delisle <Marc.Delisle_at_cegepsherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Sebastian Mendel <cybot_tm_at_users.sourceforge.net> + 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 Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Marc Delisle / 2007-01-16

1 0

[Phpmyadmin-devel] phpMyAdmin 2.9.2-rc1 is released
by Marc Delisle 10 Jan '07

10 Jan '07

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.9.2-rc1 http://www.phpmyadmin.net phpMyAdmin 2.9.2-rc1 - January 9, 2007 ====================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project announces the immediate availability of the first release candidate for phpMyAdmin 2.9.2, a bugfix-only release containing security fixes. A security advisory will be published on phpmyadmin.net when releasing the final 2.9.2. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular Web GUI for MySQL. Fixes ----- * 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 Detailed list of changes 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 ---------- Please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- (from http://www.phpmyadmin.net/documentation) phpMyAdmin handles the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: * easily browse through databases and tables * create, copy, rename, alter and drop databases * create, copy, rename, alter and drop tables * do table maintenance * add, edit and drop fields * execute any SQL-statement, even multiple queries * create, alter and drop indexes * load text files into tables * create (*) and read dumps of tables or databases * export (*) data to SQL, CSV, XML, Word, Excel, PDF and Latex formats * administer multiple servers * manage MySQL users and privileges * check server settings and runtime information with configuration hints * check referential integrity in MyISAM tables * 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 * transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link * support InnoDB tables and foreign keys (see FAQ 3.6) * support mysqli, the improved MySQL extension (see FAQ 1.17) * communicate in 50 different languages (*) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps and CSV exports if you use PHP4 >= 4.0.4 with Zlib support (--with-zlib) and/or Bzip2 support (--with-bz2). Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2006 Marc Delisle <Marc.Delisle_at_cegepsherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Sebastian Mendel <cybot_tm_at_users.sourceforge.net> + 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 Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Marc Delisle / 2007-01-09

1 0

[Phpmyadmin-devel] releases roadmap
by Marc Delisle 04 Jan '07

04 Jan '07

Hi, I suggest a 2.9.2-rc1 and a 2.10.0-beta1 soon. Marc

3 6

[Phpmyadmin-devel] GPL and Apache licenses
by Marc Delisle 18 Dec '06

18 Dec '06

Hi, I have received some code that would make sense merging, but it uses a library that is licensed under the Apache license (v2). Now, the fun part is that the position of the Apache Foundation: http://www.apache.org/foundation/licence-FAQ.html#GPL differs from the position of the FSF: http://www.gnu.org/licenses/license-list.html#GPLIncompatibleLicenses about the compatibility of the two licenses. Has someone ever dealt with a case like this? (You remember that we removed some non-GPL code in 2006 from our code base.) Marc

1 0

[Phpmyadmin-devel] insert/update row with file contents
by Sebastian Mendel 12 Dec '06

12 Dec '06

Hi, is there an option to select a file from a user directory to be filled into a field? if so, than tbl_replace_fields.inc.php handles this, but it uses move_uploaded_file() on this file, did anybody test this this? does this work? move_uploaded_file() should only work on files uploaded by form ... -- Sebastian Mendel www.sebastianmendel.de

5 20

[Phpmyadmin-devel] bug in MYSQL40 compatibility mode
by Marc Delisle 12 Dec '06

12 Dec '06

Hi, I wonder if we should stop to offer the MYSQL40 mode in export, or at the very least display a big warning about it. In this mode, MySQL creates a dump that removes the auto_increment clause for the primary key! Marc Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 358345 to server version: 5.0.21-standard mysql> show create table bug1607282; CREATE TABLE `bug1607282` ( `id` int(11) NOT NULL auto_increment, `description` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 mysql> set sql_mode=MYSQL40; mysql> show create table bug1607282; CREATE TABLE `bug1607282` ( `id` int(11) NOT NULL, `description` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM

4 12

[Phpmyadmin-devel] urlencode for POST data in tbl_change.php?
by Sebastian Mendel 12 Dec '06

12 Dec '06

Hi, is there any reason why the data is urlencoded when submitted with POST? tbl_change.php#222: <form method="post" action="tbl_replace.php" name="insertForm" <?php if ($is_upload) { echo ' enctype="multipart/form-data"'; } ?>> <?php echo PMA_generate_common_hidden_inputs($db, $table); ?> <input type="hidden" name="goto" value="<?php echo urlencode($goto); ?>" /> <input type="hidden" name="pos" value="<?php echo isset($pos) ? $pos : 0; ?>" /> <input type="hidden" name="session_max_rows" value="<?php echo isset($session_max_rows) ? $session_max_rows : ''; ?>" /> <input type="hidden" name="disp_direction" value="<?php echo isset($disp_direction) ? $disp_direction : ''; ?>" /> <input type="hidden" name="repeat_cells" value="<?php echo isset($repeat_cells) ? $repeat_cells : ''; ?>" /> <input type="hidden" name="dontlimitchars" value="<?php echo (isset($dontlimitchars) ? $dontlimitchars : 0); ?>" /> <input type="hidden" name="err_url" value="<?php echo urlencode($err_url); ?>" /> <input type="hidden" name="sql_query" value="<?php echo isset($sql_query) ? urlencode($sql_query) : ''; ?>" /> this is very confusing, as GET submitted data gets automatically decoded but not POST submitted data - and forcing an urldecode on not encoded data could affect the sql query content -- Sebastian Mendel www.sebastianmendel.de

3 7

[Phpmyadmin-devel] PMA AJAX UI Testing & Update
by Dougal Matthews 05 Dec '06

05 Dec '06

When I have my work in a state worth testing (I'm getting there) is there a specific way that you guys use to test updates? Also as an update, I'm looking to add AJAX to some, if not all of the following areas; Searching (similar to live search on on other sites) Inserting Records (allow inserting multiple easier etc.) AJAX backed Query builder Editing text in place for fields/tables I realise these don't really describe what i mean, but it should give most of you some idea. If i have missed out a section that you think would be really good with AJAX. Please let me know. Probably some changes will be made to that list. As many of these can be used or not be used as you all see fit in the end. I don't mind. Dougal

2 1

[Phpmyadmin-devel] October change in PMA_showMessage()
by Marc Delisle 28 Nov '06

28 Nov '06

Hi Michal, what kind of problems what this fix for? (More specifically the last part of the fix at line 1575) http://phpmyadmin.svn.sourceforge.net/viewvc/phpmyadmin/branches/QA_2_9/php… It introduced a bug https://sourceforge.net/tracker/index.php?func=detail&aid=1603660&group_id=… Marc

2 2

[Phpmyadmin-devel] AJAX UI Project
by Dougal Matthews 24 Nov '06

24 Nov '06

Hi, My name is Dougal. I am a 4th year programming student in Scotland. I am undertaking a honours project on AJAX. I have chosen phpMyAdmin to demonstrate my work as I have to take a previously existing PHP program and add a AJAX spin to the user interface. I'll keep you posted with my updates.Advice advice or comments would be greatly appreciated. Dougal

5 9