June 2007 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] DefaultTabTable
by Marc Delisle 30 Jun '07

30 Jun '07

Ok, another point to discuss about :) In RFE 1680546, we got a request to set $cfg['DefaultTabTable'] = 'sql.php'; I agree that the most popular action done on a table would be to browse it. The RFE says that "most hosting companies don't change the default settings" so I can understand his point. Now I know that we have a browse icon next to the table name but clicking the table name is easier than reaching for this icon. So I suggest we change the default in config.default.php, as requested. If we do this, should we - remove this browse icon when the parameter is set to sql.php? - let this browse icon there for all situations? - display a different icon leading to the Structure page (if clicking the table name leads to the browse page) ? Marc

2 1

[Phpmyadmin-devel] prepare for 2.11 ?
by Marc Delisle 28 Jun '07

28 Jun '07

Hi, I think we should go into message freeze, start the 2.11 branch and prepare for beta 1. Opinions? Marc

1 0

[Phpmyadmin-devel] session_cleanup.lib.php
by Marc Delisle 25 Jun '07

25 Jun '07

Hi, In trunk I added libraries/session_cleanup.lib.php. For the moment it only does unset($_SESSION['navi_limit_offset']); and is called at logout time for http and cookie auth_type. The idea is to get rid of choices made by the previous user. If you remember of other variables set in the session as a result of a choice from a user, please add them there. Or should we just destroy the session at logout time? I was not brave enough to test this... Marc

2 2

Re: [Phpmyadmin-devel] [Phpmyadmin-svn] SF.net SVN: phpmyadmin: [10448] trunk/phpMyAdmin/libraries/List_Database. class.php
by Sebastian Mendel 19 Jun '07

19 Jun '07

lem9(a)users.sourceforge.net schrieb: > Revision: 10448 > http://svn.sourceforge.net/phpmyadmin/?rev=10448&view=rev > Author: lem9 > Date: 2007-06-18 09:36:41 -0700 (Mon, 18 Jun 2007) > > Log Message: > ----------- > do not use getItems() in this case > > [...] > - foreach ($this->getItems() as $key => $db) { > + foreach ($this->items as $key => $db) { what is the favor doing this? i do not think that you will save any memory or time (PHP copies variable content only on change in one of the variable copies) also, possible we could use getItems($count, $offset = 0) -- Sebastian

2 1

[Phpmyadmin-devel] going to PHP 5-only
by Marc Delisle 17 Jun '07

17 Jun '07

Hi, phpMyAdmin has been invited by a group of well-known open source projects to participate in an initiative that is meant to promote PHP 5 and break the cycle where web hosts are not encouraged to upgrade to 5 because apps works on 4. Specifically, if we agree to this, effective 5 February 2008, any new-feature release will have a minimum required PHP version of 5.2.0. I like the idea of a group of projects doing this (so no one is penalized by being the first); I am in favor of this and would like your feedback. Marc

6 25

[Phpmyadmin-devel] Revision 10397 problems with accented characters
by Marc Delisle 16 Jun '07

16 Jun '07

Hi, this revision: http://phpmyadmin.svn.sourceforge.net/viewvc/phpmyadmin?view=rev&revision=1… breaks this query: select `nombre_posté` from personne when I want to go to Next page of results. Due to the use of hmtlentities() on the query, it becomes SELECT `nombre_postÃ©` FROM `personne` Marc

2 2

[Phpmyadmin-devel] phpMyAdmin 2.10.2 is released
by Marc Delisle 15 Jun '07

15 Jun '07

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.10.2 http://www.phpmyadmin.net phpMyAdmin 2.10.2 - June 15, 2007 ================================= A PHP application to administrate MySQL over the Web ---------------------------------------------------- Announcement ------------ The phpMyAdmin Project announces the immediate availability of phpMyAdmin 2.10.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: + [data] display all warnings, not only last one - typo in fix for bug #1671813 - bug #1714908 Inserted Row Count is wrong - bug #1712570 Deleting last record freezes - bug #1717339 Missing header when deleting a checked column, thanks to Michael Keck - bug #1717477 Warning on Query page when db is empty - bug #1721002 db rename -> undefined cfgRelation, thanks to Jürgen Wind - bug #1721571 CREATE database privilege not always detected, thanks to Gordon McNaughton - bug #1715709 export in SQL format always includes procedures and functions - bug #1722502 DROP TABLE in export view structure - bug #1718787 Multi-server setup breaks Designer - bug #1724401 Column truncation in repair table output - patch #1726500 Wrong position of , thanks to Jürgen Wind - bug #1728590 Detected failing session_start fails, thanks to Jürgen Wind - RFE #1714760 Obey ShowCreateDb on the Databases tab - patch #1733762 Typo in message "INSERT DELAY", thanks to Victor Volkov - patch #1730171 Dead message strLanguageFileNotFound, thanks to Victor Volkov - patch #1731280 Avoid negative exponent in gmp_pow(), thanks to anosek Detailed list of changes is usually available under http://www.phpmyadmin.net/ChangeLog.txt but at present time, please refer to the ChangeLog in the distribution kit for the most up to date information. 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 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-2007 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-06-15

1 0

Re: [Phpmyadmin-devel] they sell phpMyAdmin
by Sebastian Mendel 12 Jun '07

12 Jun '07

Marc Delisle schrieb: > Hi, > > About this site: > > http://php-my-admin.awardspace.com/download.php > > Here are my views: > > 1. we don't own any trademark so we can't do anything on the name > phpMyAdmin > > 2. GPL does not forbid them to charge a fee for transfering a copy and > for offering warranty. > > 3. but imitating our web site is questionnable (especially removing the > license link from their partial copy of our site). > > So I think I'll phone them! > > What do you think of this? possible gpl-violations.org can give some advice -- Sebastian Mendel www.sebastianmendel.de

1 0

[Phpmyadmin-devel] phpMyAdmin 2.10.2-rc1 is released
by Marc Delisle 09 Jun '07

09 Jun '07

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.10.2-rc1 http://www.phpmyadmin.net phpMyAdmin 2.10.2-rc1 - June 8, 2007 ==================================== A PHP application to administrate MySQL over the Web ---------------------------------------------------- Announcement ------------ The phpMyAdmin Project announces the immediate availability of the first release candidate for phpMyAdmin 2.10.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: + [data] display all warnings, not only last one - typo in fix for bug #1671813 - bug #1714908 Inserted Row Count is wrong - bug #1712570 Deleting last record freezes - bug #1717339 Missing header when deleting a checked column, thanks to Michael Keck - bug #1717477 Warning on Query page when db is empty - bug #1721002 db rename -> undefined cfgRelation, thanks to Jürgen Wind - bug #1721571 CREATE database privilege not always detected, thanks to Gordon McNaughton - bug #1715709 export in SQL format always includes procedures and functions - bug #1722502 DROP TABLE in export view structure - bug #1718787 Multi-server setup breaks Designer - bug #1724401 Column truncation in repair table output - patch #1726500 Wrong position of , thanks to Jürgen Wind - bug #1728590 Detected failing session_start fails, thanks to Jürgen Wind - RFE #1714760 Obey ShowCreateDb on the Databases tab Detailed list of changes is usually available under http://www.phpmyadmin.net/ChangeLog.txt but at present time, please refer to the ChangeLog in the distribution kit for the most up to date information. 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 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-2007 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-06-08

1 0

[Phpmyadmin-devel] {POLLURIEL?} phpMyAdmin 2.10.2-rc1 is released
by Marc Delisle 08 Jun '07

08 Jun '07

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.10.2-rc1 http://www.phpmyadmin.net phpMyAdmin 2.10.2-rc1 - June 8, 2007 ==================================== A PHP application to administrate MySQL over the Web ---------------------------------------------------- Announcement ------------ The phpMyAdmin Project announces the immediate availability of the first release candidate for phpMyAdmin 2.10.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: + [data] display all warnings, not only last one - typo in fix for bug #1671813 - bug #1714908 Inserted Row Count is wrong - bug #1712570 Deleting last record freezes - bug #1717339 Missing header when deleting a checked column, thanks to Michael Keck - bug #1717477 Warning on Query page when db is empty - bug #1721002 db rename -> undefined cfgRelation, thanks to Jürgen Wind - bug #1721571 CREATE database privilege not always detected, thanks to Gordon McNaughton - bug #1715709 export in SQL format always includes procedures and functions - bug #1722502 DROP TABLE in export view structure - bug #1718787 Multi-server setup breaks Designer - bug #1724401 Column truncation in repair table output - patch #1726500 Wrong position of , thanks to Jürgen Wind - bug #1728590 Detected failing session_start fails, thanks to Jürgen Wind - RFE #1714760 Obey ShowCreateDb on the Databases tab Detailed list of changes is usually available under http://www.phpmyadmin.net/ChangeLog.txt but at present time, please refer to the ChangeLog in the distribution kit for the most up to date information. 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 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-2007 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-06-08

1 0