May 2004 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Redesign and alpha2
by Alexander M. Turek 10 May '04

10 May '04

Hi list, The current 2.6 code looks good for an alpha2 to me. We already discussed if we wanted to release a second alpha before merging the layout patches, but I don't think that we have come to a decision yet. Michael submitted a first patch against alpha1 dealing with the main page and his modified PMA logo. I merged it with HEAD and revised it, so that we could put it into CVS and all work on and with it. The thing is that I don't want to exchange the layout patches via the tracker as we would always have to merge it with HEAD... So if we wanted to release alpha2, I'd like us to do so now. Regards, -- Alexander M. Turek <rabus(a)users.sourceforge.net> _ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ <http://www.phpmyadmin.net>

4 3

RE: [Phpmyadmin-devel] 2.6.0-rc1
by Garvin Hicking 08 May '04

08 May '04

(Repost as this didn't seem to get through the list?) Hi Alexander! >> Michal said, we need to apply our coding style to the patch >> and most of all try to maintain some backwards-compatibility >> for the 'old' look. > > What do you mean by "backwards-compatibility"? I have not yet looked at the code of the redesign, only the live-demo. There are lots and lots of icons, which I tend to like personally and for newebie users. But as we all know from the several angry users after adding icons in first place, I guess many users do not want to have those buttons, so they need to be optional. And any other improvements, if making a definite difference in the UI should be tweakable. I think PMA benefits from long-term users who gotten used to it and who we might annoy by forcing a new UI upon them. >> I was already thinking of splitting up the configuration file >> into a ".design" >> php file where one could apply the many optical directives. >> But doing so would mean huge work on the config_import utility... > > No, it won't. Trust me. :-) So you're doing this? :) Today I was thinking of how we could make preferences toggle-able for users based on a DB-config. There are two approaches: 1. The "DB"-way. You'd have a new panel inside PMA where you can see a list of all tweakable settings and toggle them as you like. Those preferences get stored inside a new PMA table. After PMA reads the config.inc.php it overrides any settings stored in the table. Each user will get a cookie to identify him with the personal ID stored in the table. So a user could have one or even more "profiles" available by extending the ID values (as an serialized array) inside his cookie. If he has more than one ID cookie he can choose the profile he wants to have applied. Once we have a GUI for adjusting options (maybe we could use dropdown/enum code from our tbl_change already and just take care of a global PHP file defining possible and default values plus short/long descriptions) this should be fairly easy to implement. There could also be a way to share profiles which can be marked as profile. 2. The "cookie way" Basically same as above, but the config data is stored as a serialized array in the cookie. Benefits for this option: No need for setting up PMA tables, works out of the box. Performance should be equal; what is saved on not querying the SQL-table is lost on unserializing and submitting cookie data. Drawback: If the cookie is lost, the profile is lost. No use accross different browsers. We could implement both ways and make the 2nd the default to give all users that feature; we may also offer a "export my profile" setting which stores a profile inside the file system of the webserver and reload it in a checkbox. Choosing a different CSS layout could also be part of this new functionality, but we'd than have to make the CSS file static and split up for left/right frame. This would also make it easier for CSS-designers to work on non-PHP code. Opinions? :-) Regards, Garvin. -- Garvin Hicking | Web-Entwickler | Make me happy: www.supergarv.de | #ICQ 21392242 | http://wishes.garv.info/ -- Garvin Hicking | Web-Entwickler | Make me happy: www.supergarv.de | #ICQ 21392242 | http://wishes.garv.info/

2 1

[Phpmyadmin-devel] phpMyAdmin 2.6.0-alpha2 is released!
by Marc Delisle 07 May '04

07 May '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.0-alpha2 http://www.phpmyadmin.net phpMyAdmin 2.6.0-alpha2 - May 7th, 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 second 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-alpha2 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 * (alpha2) Optional display of server choice as links * (alpha2) Click on result row to mark the checkbox * (alpha2) Show if BLOB is NULL * (alpha2) Mouse cursor in db structure and table structure views * (alpha2) Multiple row insert * (alpha2) Search: new choice LIKE %...% * (alpha2) Can now change the number of columns when adding fields 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 o (alpha2)Handling of multi-column foreign keys * 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 * (alpha2) Invalid SQL on empty table export * (alpha2) Multi-byte functions and windows- charsets * (alpha2) Handling of USE in multiple queries * (alpha2) Light mode undefined indices * (alpha2) Consistent window layout for query window * (alpha2) Missing localization for multi-row edit/delete/export * (alpha2) Data dictionary: wrong formatting * (alpha2) Uploading with UploadDir and open_basedir restriction * (alpha2) Handling of complex sort queries * (alpha2) Nested mode: collapsing problem * (alpha2) Multi-edit: wrong tabindex ids * (alpha2) Calendar: maximum values * (alpha2) Privileges: wrong message when editing for non-existent db * (alpha2) Parser and multibyte strings * (alpha2) Browsing of foreign table: problem with encoding of the primary key reference * (alpha2) Cookie login: avoid double frames * (alpha2) Nested table now also works with aliases tablenames 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 ---------- To be informed about new releases fixing the problems, 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 ----------- 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 version 2, as published by the Free Software Foundation. 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-05-07

2 1

[Phpmyadmin-devel] 2.6.0-rc1
by Marc Delisle 06 May '04

06 May '04

Hi, just to ask confirmation of what was discussed previously: feature freeze and -rc1 on May 9th? Marc

4 10

[Phpmyadmin-devel] Closing bugs instead of priority 1?
by Michal Čihař 05 May '04

05 May '04

Hi all how about closing bugs just as they're fixed in cvs? It will make easier to overview what is still broken. Users anyway should use search and not just look at bugs list to reduce duplicates (they often don't do this anyway). Priority should mark how severe the bug is. Comments? -- Regards Michal Čihař http://cihar.com

3 4

[Phpmyadmin-devel] Scripts cleanup
by Michal Čihař 05 May '04

05 May '04

Hi all do we still need to ship these scripts: extchg.sh - used in past for changing php3 to php inno2pma.sh - convert InnoDB keys into pma database, we now have native support for InnoDB, don't we? -- Regards Michal Čihař http://cihar.com

2 1

[Phpmyadmin-devel] Mail Delivery (failure phpmyadmin-devel@lists.sourceforge.net)
by jeremy＠nirvani.net 04 May '04

04 May '04

----------- Trend GateLock 病毒防護通知 (主機：higp7.gatelock.com.tw) ** 中毒檔案 email-body 已刪除。 --------------------------------------------------------- ----------- Trend GateLock 病毒防護通知 (主機：higp7.gatelock.com.tw) ** 中毒檔案 message.scr 已刪除。 --------------------------------------------------------- ----------- Trend GateLock 病毒防護通知 (主機：higp7.gatelock.com.tw) ** 在檔案 email-body 中發現病毒 HTML_Netsky.P。無法清除病毒，中毒檔案已刪除。 ** 在檔案 message.scr 中發現病毒 WORM_NETSKY.P。無法清除病毒，中毒檔案已刪除。 ---------------------------------------------------------

1 0

[Phpmyadmin-devel] "Mastering phpMyAdmin for Effective MySQL Management"
by Marc Delisle 04 May '04

04 May '04

Finally a phpMyAdmin book! Dear phpMyAdmin users, It is my pleasure to announce the immediate availability of "Mastering phpMyAdmin for Effective MySQL Management". I have written this book with all phpMyAdmin users in mind -- newbies and power users, and I think it's great that the community can now have a tutorial and reference manual to rely upon. Mastering phpMyAdmin for Effective MySQL Management will help you to unlock the full potential of phpMyAdmin and will show you how to increase your productivity and control when working with your MySQL. This book begins with a comprehensive tutorial of phpMyAdmin that systematically explains and demonstrates the potential of this tool. It then goes on to show the less well known and generally under-used features and capabilities of phpMyAdmin in depth. For more information, please visit: http://www.packtpub.com/view_book/isbn/1904811035 Marc Delisle phpMyAdmin.net

1 0

[Phpmyadmin-devel] multi-row delete
by Alexander M. Turek 02 May '04

02 May '04

Hi list, When, browsing a table, I select multiple records by clicking the checkboxes. When clicking the red trashcan below the table, I get to the edit view for the selected records, but that's not what I expect when clicking a trashcan... ;-) Could someone have a look at this? Btw, welcome to the EU, Michal. :-) Regards, -- Alexander M. Turek <rabus(a)users.sourceforge.net> _ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ <http://www.phpmyadmin.net>

3 2