- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Inconsistency in announcement
by Michal Čihař 26 Apr '04

26 Apr '04

Hi all just noticed this in announcement: Availability ------------ This software is available under the GNU General Public License V2.0. Authors & Copyright ------------------- ...either version 2 of the License, or (at your option) any later version. This should be IMHO unified to just one of these... -- Regards Michal Čihař http://cihar.com

2 2

[Phpmyadmin-devel] Undefined offset in blowfish.php
by Alexander M. Turek 21 Apr '04

21 Apr '04

Hi list, I was just changing my MySQL password being logged on in cookie mode. Clicking the "back" link or any button inside the navi frame logs me out and gives me the following error message: Notice: Undefined offset: 1 in [pma]/libraries/blowfish.php on line 436. Regards, -- Alexander M. Turek <rabus(a)users.sourceforge.net> _ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ <http://www.phpmyadmin.net>

2 2

[Phpmyadmin-devel] release notes for 2.6.0-alpha
by Marc Delisle 21 Apr '04

21 Apr '04

Hi, Please have a look at http://www.phpmyadmin.net/home_page/marc.php?rel=0 and send me your additions/corrections. Marc

4 13

[Phpmyadmin-devel] phpMyAdmin 2.6.0-alpha1 is released
by Marc Delisle 21 Apr '04

21 Apr '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.0-alpha1 http://www.phpmyadmin.net phpMyAdmin 2.6.0-alpha1 - April 21th, 2004 ========================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of the first alpha release of phpMyAdmin 2.6.0. Because of significant changes inside the database connection methods and major improvements to the MySQL 4.1 compatibility, the team decided to release this alpha version from phpMyAdmin's current development code. Supporting the new improved MySQL extension of php5 (MySQLi), phpMyAdmin has made a giant step towards the upcoming PHP and MySQL versions. As the new milestone should to be as stable as possible, any feedback about 2.6.0-alpha1 would be appreciated. Please note, that it is not recommended to run this testing release on production environments. 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 GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- Improvements: * PHP 5 mysqli extension support o better performance o improved security * Improved support for character sets * Support for UTF-8 databases under MySQL 4.1 * Site-configurable header and footer * Export: o can add custom text to SQL export headers o support for IF NOT EXISTS o support for INSERT IGNORE and UPDATE IGNORE o use unbuffered queries o enclosing SQL export in a transaction o selective row export o improved ANSI compatibility * Operations: now copy table defaults to "structure and data" * Operations: database renaming * Editing: option "Go back to this page" * Sort: natural order (configurable) * Search page: DISTINCT, IS NULL, IS NOT NULL, NOT LIKE, multiple choices for ENUM * Left panel Logout link * Popup calendar (date and time editing) for date, datetime and timestamp fields * Set and alter collations for databases, tables and fields * Security: Protection against cookie hijacking: encrypt also the user name, and set a time limit on the validity of encrypted password in the cookie * "(Un)check all" link for privileges page Fixes: * Error parsing floating point digit and GRANT...TO * Numeric field names * Keyword field names become capitalized * Substr transformation broken with utf-8 * CONSTRAINT error in MySQL 3.23.x * MySQL charsets not added to WHERE clauses * Export: o on-the-fly compression problem o CSV problem with double-byte characters o UPDATE option does not work * Editing: o Invalid escaping of + in ENUM o Undefined submit_mult o Cannot edit first row when no primary key o Cannot edit big table structure o Multi-edit: changes are lost o Editing of double and float numbers o Charset information was lost when changing fields * Invalid row count when emptying table * Error on Delete link after a db search * Interface: Icons not displayed for index management * Problem when the query contains quotes * Wrong detection of the CREATE privilege * Problem when the bookmark table does not exist * Password error when copying a user * Search page and empty VARCHAR column * IIS crash: header problem 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 ---------- - phpMyAdmin SQL parser chokes on fieldnames with certain non-ASCII characters (bugs #593598, #936161). 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 Web. 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 Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 Marc Delisle <DelislMa_at_CollegeSherbrooke.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> Marcel Tschopp <ne0x_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 the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA EOF -- Alexander M. Turek and Marc Delisle/ 2004-04-21

1 0

[Phpmyadmin-devel] popup calendar broken?
by Marc Delisle 20 Apr '04

20 Apr '04

Hi, since the addition of time editing, I have problems: I pick some date, and the year and month are send to my field, but for the day, it's always set to the current day. Can someone else reproduce this? Marc

1 1

[Phpmyadmin-devel] Use utf-8 for ChangeLog
by Michal Čihař 20 Apr '04

20 Apr '04

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all since I started to use utf-8 on some machines I noticed that we have some iso-8859-1 characters in ChangeLog. Wouldn't be better to make it utf-8 encoded? - -- Regards Michal Čihař http://cihar.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAgm5e3DVS6DbnVgQRApZtAJ96IN//OAS6HTbrOdju7kU5cADKLgCgt82M lGzfoGx4xL7hAEprqlrK6U8= =D8Se -----END PGP SIGNATURE-----

4 17

[Phpmyadmin-devel] ready for 2.6.0-alpha?
by Marc Delisle 19 Apr '04

19 Apr '04

Hi devs, I am writing the release notes, and plan to release today or tomorrow. Marc

4 3

[Phpmyadmin-devel] Pop-up calendar for date fields (RFE #880647)
by Marcel Tschopp 19 Apr '04

19 Apr '04

Hi Michal If I use an existing date value (eg: 2004-04-07), the calendar doesn't work correctly: The displayed month becomes "undefined" and the selected day is the 4th. Are you still working on it? Thanks Marcel

3 6

[Phpmyadmin-devel] [Fwd: Better logout]
by Olivier Mueller 18 Apr '04

18 Apr '04

got this on a private mail account: (no time to look at it now, will check during the week). regards, Olivier -------- Forwarded Message -------- From: Ing. Jozef Sakalos <jsakalos(a)aariadne.com> Subject: Better logout Date: Sun, 18 Apr 2004 19:37:05 +0200 Mailer: KMail/1.6.51 Hi Olivier, I just downloaded and installed CVS version of phpMyAdmin and I found that you've added the logout button to the left frame. The drawback is that if you click it you cannot login with the same name and password. You've probably used example from PHP documentation. I've been working on the logout feature too, and I found the better solution (see code snippet at the end of this e-mail). I use logout button that POSTs cmd=logout to the PHP code. When logout command is processed I set cookie (well, this is browser settings dependent) to prevent infinite loop of log-in dialogs. Once the user authenticates, I delete the cookie. This way I can log-in with the same name/password. Use this if you want and let me know your opinion. Best Regards, Ing. Jozef Sakalos jsakalos(a)aariadne.com <? if(!isset($_SERVER["PHP_AUTH_USER"]) || ("logout" == $cmd && ! $logging_out)) { if("logout" == $cmd) { setcookie("logging_out", "1"); } header('WWW-Authenticate: Basic realm="Theseus"'); header('HTTP/1.0 401 Unauthorized'); header("Status: 401 Unauthorized"); echo "You have to authenticate<br>"; exit; } setcookie("logging_out", "", time() - 3600); echo "Hello: $PHP_AUTH_USER<br>"; echo "Your password is: $PHP_AUTH_PW"; echo <<<eot <html><head></head><body> <br> <br> <form action="$PHP_SELF" method="post"> <input type="hidden" name="cmd" value="logout"> <input type="submit" value="Logout"> </form> cmd=$cmd eot; echo "</body></html>"; ?>

3 2

[Phpmyadmin-devel] Relogin in cookie mode
by Alexander M. Turek 18 Apr '04

18 Apr '04

Hi list, PMA forces me to relogin whenever I click a link or a button after being inactive for a couple of minutes... I am having this problem for some time now. Is it a bug or a feature? Regards, -- Alexander M. Turek <rabus(a)users.sourceforge.net> _ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ <http://www.phpmyadmin.net>

3 3