- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Timezone settings
by Sebastian Mendel 07 Aug '07

07 Aug '07

Hi --- Strict Standards: str*time() [function.str*time]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. --- how should we handle this? by default the date.timezone should be setup in the php.ini so we should check this and set it if not set - but what value? adding one more main.php option to display and setup timezone? -- Sebastian Mendel

2 5

[Phpmyadmin-devel] phpMyAdmin 2.11.0-rc1 is released
by Marc Delisle 02 Aug '07

02 Aug '07

Welcome to the first release candidate of phpMyAdmin 2.11, which will probably be the last series supporting PHP 4. This version supports creating VIEWs from query results and can manage triggers, procedures and functions. It also supports MySQL 5.0.37 query profiling and has an improved interface for servers hosting thousands of databases and tables. This release candidate contains just a few fixes, compared to -beta1. Details and downloads: http://www.phpmyadmin.net Marc Delisle, for the team

1 0

[Phpmyadmin-devel] phpMyAdmin 2.11.0-beta1 is released
by Marc Delisle 25 Jul '07

25 Jul '07

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.11.0-beta1 http://www.phpmyadmin.net phpMyAdmin 2.11.0-beta1 - July 25, 2007 =======================------========== A PHP application to administrate MySQL over the Web ---------------------------------------------------- Announcement ------------ The phpMyAdmin Project announces the immediate availability of the first beta release of phpMyAdmin 2.11.0, which will probably be the last series supporting PHP 4. This version supports creating VIEWs from query results and can manage triggers, procedures and functions. It also supports MySQL 5.0.37 query profiling and has an improved interface for servers hosting thousands of databases and tables. 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. Improvements: + [import] support handling of DELIMITER to mimic mysql CLI, thanks to fb1 + improved PHP 6 compatibility + [core] added PMA_fatalError() and made use of it + [doc] changed all documentation in config.inc.php to phpDocumentor style + [data] support for CREATE VIEW from query results + [gui] dropped css/ folder and moved into root of PMA + [l10n] new: Sinhala, Macedonian + [export] YAML export (see yaml.org) thanks to Bryce Thornton + [upload] moved file upload functionality into own class + [upload] make use of $cfg['TempDir'] for file uploads + [server] improved display of binary logs + [data] better error handling in tbl_create.php + [routines] from Patch #1649881, thanks to Mike Beck + [querywindow] store sql history in session + [querywindow] sql history now without db too + [querywindow] tweaks in sql history view + [export] Native Excel (Spreadsheet_Excel_Writer) improvements, thanks to Christian Schmidt + [doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch + RFE #1435922 [gui] navigation frame shows listing of databases when none selected + [data] support BIT datatype (under mysqli), thanks to Christian Schmidt + [display] automatic confirmation for sort by key, thanks to Juergen Wind + [data] can now choose the number of insert rows + RFE #1704779 [gui] link documentation from login page + RFE #1513345 [setup] check control user connection during setup + [structure] TRIGGERS: display/edit/drop/SQL export + [browse] store browse state in session per query + [gui] Insert/Edit: no longer display the Go button each 15 lines but just at the end of a row + [gui] Query window: use verbose server name if any + [auth] patch #1712514 specify host for single signon, thanks to Thierry + [gui] Navigator for the db list in the navigation panel + [gui] Navigator for the table list in the content panel + [display] Support for MySQL 5.0.37 profiling + RFE #1743983 [gui] Replace $max_characters by a configurable param: $cfg['MaxCharactersInDisplayedSQL'] + [display] patch #1749705, Allow multibyte characters in number formatting, thanks to garas + [privileges] Support password hashing on the Edit Privileges interface + [gui] Export: Select All/Unselect All over the choices, thanks to Florian Schmitz Fixes: - bug #1674914 [structure] changing definition of a TIMESTAMP field - bug #1615530 [upload] added more specific error message if field upload fails - bug #1627210, #1083301, #1482401 [data] warning on duplicate indexes - bug #1668724 JavaScript focus login Opera - bug #1666657 [auth] Cookie password delete on timeout / inactivity - bug #1648802 different mysql library and server version - bug #1662976 [auth] Authentication fails when controluser/pass is set - bug #1643758 [import] Error #1264 importing NULL values in MySQL 5.0 - bug #1523747 [innodb] make warning about row count more visible - bug #1676012 [auth] strip non-US-ASCII characters (RFC2616) - bug #1679440 Added FAQ entry about header errors under IIS caused by an end-of-line character - [gui] avoid displaying a wide selector in server selection - bug #1614004 [relation] foreign key spanning multiple columns are incorrectly displayed - bug #1681598 [interface] Edit next row - bug #1688053 [export] Wrong export of binary character fields - bug #1498281 [parser] Wrong primary key used for displaying results with subquery - bug #1699772 Visual space bug in table name (in browser) - bug #1699532 Cause of data manipulation issues: implemented changes as suggested by crisp_; still have to work on updating an ENUM value - bug #1747215 Export emits blanks at line ends - bug #1751172 Do not export data when exporting a single VIEW - bug #1755339 Warn about rename dataase actually being copy/delete - bug #1746921 Left frame shrinks on db change, thanks to Juergen Wind - bug #1727138 HTML not encoded (more than 1000 characters) - bug #1746186 LeftLogoLink fails if set to some external site 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 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 54 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-07-25

1 0

Re: [Phpmyadmin-devel] [Phpmyadmin-users] phpMyAdmin's visuals derailing since 2.6.0?
by Marc Delisle 24 Jul '07

24 Jul '07

Sebastian Mendel a écrit : > Florian wrote: >> - all the black - somethimes even thick - lines which visually >> strongly seperate elements that actually belong together > > between fieldset's (input and submit footer)? > yes, seems a little bit to dark The thick line on top of fieldset tblFooters is gone.

1 0

Re: [Phpmyadmin-devel] [Phpmyadmin-users] phpMyAdmin's visuals derailing since 2.6.0?
by Marc Delisle 24 Jul '07

24 Jul '07

Florian Schmitz a écrit : >> For the "Showing rows" notice, I would prefer to not use the notice >> class in this case. Notice is in yellow to draw attention to something >> special, and we get this yellow message quite often. > > I'd actually suggest to do it like in 2.6.0, also see > http://i14.tinypic.com/62zvqjt and http://floele.flyspray.org/test.htm > again. It was rather unobstrusive back then and was visually connected > to the query it refers to. I suggest to move "Showing rows" just on top on the first Show dialog, with a <fieldset class="tblFooters">. The idea is that: 1. user sent query, we display it in the SQL query fieldset 2. we are showing rows x to x 3. we display the rows

1 0

Re: [Phpmyadmin-devel] [Phpmyadmin-users] phpMyAdmin's visuals derailing since 2.6.0?
by Marc Delisle 24 Jul '07

24 Jul '07

Florian Schmitz a écrit : >> one reason why this was not implemented before or to change the look of our >> tabs more like other tabs was the fact that these tabs often break into the >> next line, and this could look strange ... because the active tab should >> always be on the lower line > > Well, if you have a super low screen with, you cannot really expect > everything to look perfect. As long as the tabs wrap well, I don't see > a serious problem with that. > > With the bottom border removed, it's much better now already. But > there are still 3 minor issues. If you click "browse" despite the fact > that there are no rows, the browse tab is highlighted afterwards but > the structure is the current tab. Instead browse should look like all > the other tabs (execpt structure). Also, when hovering a tab next to > the active one, the borders still are too close together. > Last but not least I think there should be at least 1px space between > the tab icon and the black bottom border (which is not the case for > search and operations). So basically the images need to be somewhat > more vertically centered. > > Regards, > Florian First minor issue: fixed. Second one: it's not so bad IMO, unless you suggest to remove completely the effect. Third one: I don't know where to fix this :) I tried to play with values in themes/original/css/theme_right.css.php: .icon { vertical-align: middle; margin-right: 0.3em; margin-left: 0.3em; } but it does not seem to take effect.

1 0

[Phpmyadmin-devel] going to 82% by default ?
by Marc Delisle 23 Jul '07

23 Jul '07

Hi, after reading the arguments about this from Florian, Sebastian, Isaac and Juergen, I think it's better for the majority of our users (with the default browser font size of 16) to set our default font size to 82%. Why 82% ? I experimented and this gives a good compromise (the monospace fonts look better than in 80%, for example in the Rows stats). Comments? Marc

4 5

[Phpmyadmin-devel] phpMyAdmin 2.10.3 is released
by Marc Delisle 20 Jul '07

20 Jul '07

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.10.3 http://www.phpmyadmin.net phpMyAdmin 2.10.3 - July 20, 2007 ================================= A PHP application to administrate MySQL over the Web ---------------------------------------------------- Announcement ------------ The phpMyAdmin Project announces the immediate availability of phpMyAdmin 2.10.3. 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: - bug #1734285 Copy database with VIEWs - bug #1722502 DROP TABLE in export VIEW - bug #1729027 Sorting results of VIEW browsing - bug #1733012 Unwanted table alias in delete button - bug #1736405 Pretty printer and HTML line breaks - bug #1745257 Invalid DB name is still displayed - bug #1730367 Calendar "Go" has no effect - bug #1748633 Incorrect parameter validation for VIEWs + [lang] Russian revision, thanks to Victor Volkov and the users of php-myadmin.ru - Do not try to delete an internal relation if we just deleted an InnoDB one 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 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-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-07-20

1 0

[Phpmyadmin-devel] comparing phpmyadmin.net and PMA
by Marc Delisle 20 Jul '07

20 Jul '07

Hi, still about font sizes: many browsers have standardized on a default size of 16, this is why many find the text oversized in recent versions of PMA (and the majority of users don't bother changing their browser's settings because many sites adjust their fonts or font sizes accordingly). On phpmyadmin.net we specify the font size in CSS, and it's not dependent on the default browser's font size. Users can still do CTRL + or - if their browser supports it. So why not do it in PMA, with a config parameter containing 14 by default (if set to empty, PMA would not alter the font-size in CSS). Marc

3 2

[Phpmyadmin-devel] font size question
by Marc Delisle 19 Jul '07

19 Jul '07

Hi, I would like to educate myself about this subject :) I know that we have decided to use the default browser's font size, but I just made a test: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <body> <p>Rename table to</p> </body> </html> and when I display that in FF 2.0.0.5, the text looks larger than the same text as seen on the Operations panel from PMA 2.10.2. In fact, I have to choose a font size of 80% to obtain the same size as in my test. Why? Is my simple test flawed? Marc

2 5