July 2005 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] server_privileges and special characters in table name
by Marc Delisle 27 Jul '05

27 Jul '05

Hi, First under MySQL 4.1.13 I create a table with a special character in its name (for example école). Then I have problems assigning privileges on a table level, with PMA. This is because SELECT Table_name from tables_priv returns a weird character instead of "é". Note however that SHOW GRANTS displays this character correctly. I was thinking of doing some conversion in server_privileges.php, but before, I tried the same test under MySQL 5.0.9 and there is no problem! Could someone confirm/comment my tests? Marc

1 0

[Phpmyadmin-devel] templates documentation and troubles
by Alessandro De Zorzi 26 Jul '05

26 Jul '05

Hi all, I'm working to create my first template with pla, I create with successfully a creation/new_my_template.php file now I try to create the related xml file but the "Proceed >>" button don't appears clickable, could be a my js problem? I try to create template for VirtualAdmin objectClass this is the schema http://www.phamm.org/docs/phamm.schema I'm looking for documentation about "howto create template for pla" is this available? Another one, is xml template the good way to use templates? Can consider the php template obsoleted? I need to create an multiple-entry with a template (my VirtualDomain need a postmaster account inside), is this possible? Is possible to use hidden values with xml templates? Thanks in advance. Alessandro De Zorzi

1 0

[Phpmyadmin-devel] Edit/insert mode
by Marc Delisle 21 Jul '05

21 Jul '05

Hi, I like the new dropdowns on this page, but I suggest replacing "and" by "then", which would give, for example: Insert as a new row then Go back to previous page Opinions? Marc

2 2

[Phpmyadmin-devel] Error reporting in config file
by Michal Čihař 12 Jul '05

12 Jul '05

Hi all since PHP 4.3.5 interpreter stops on parse error. With our current code this leads to empty page when user makes such error in configuration. This is pretty confusing, see bugreport [1]. Possible solutions, that come to my mind: - do not reset error reporting - user will get directly error message - eval config file content, parse errors inside eval are not thet fatal, so we can hide errors in that time and handle error simmilar way how we did it before 1. https://sourceforge.net/tracker/?func=detail&atid=377408&aid=1223319&group_… -- Michal Čihař | http://cihar.com

2 5

[Phpmyadmin-devel] IE JavaScript tooltip issue
by Garvin Hicking 12 Jul '05

12 Jul '05

Hi all! I have just looked at the bug report https://sourceforge.net/tracker/index.php?func=detail&aid=1224152&group_id=… I can confirm the error, even though it does not prevent me from successfully exporting anything. The problem is that this tooltip-JavaScript code is a bit suboptimal. The libraries for this function are called at the bottom of the file, even though JS libraries should be put inside the HEAD-section. That, however, cannot be done as the included javascript file references some div-Containers that only "exist" after the DOM creation. On the other hand, before the script is loaded you can already move your mouse above the tooltip bubble, and then you get an error in the IE because the JS library is not yet loaded. It would require a major rewrite of that piece of code so that the library is included in the head section, and the tooltip-init code is called upon <body onload="...">. Added to that, the tooltip bubble itself may not yet execute before the library and DOM is loaded. Sadly, this is only an issue in the IE, and I could not find ANY way whatsoever to debug it's JavaScripting and what exactly is causing this ominous reported error on line "142". In any case this should not ever prevent users from actual functionality like exporting... Regards, Garvin -- ++ Garvin Hicking | Web-Entwickler [PHP] | www.garv.in | ICQ 21392242 ++ Developer of | www.phpMyAdmin.net | www.s9y.org ++ Make me happy | http://wishes.garv.in

2 1

[Phpmyadmin-devel] Reminder: ChangeLog is UTF-8
by Michal Čihař 11 Jul '05

11 Jul '05

Hi Robin :-) the ChangeLog is in UTF-8, please don't break it with every commit, thanks -- Michal Čihař | http://cihar.com

3 7

[Phpmyadmin-devel] cookie mode broken? - blank screen again
by Robin H. Johnson 11 Jul '05

11 Jul '05

Ok, now I hope this isn't just me (I can produce it elsewhere, but the config between the two is very similar). I use cookie mode, and sometime between the start of this year, and LinuxTag the cookie mode seems to have broken. I get the login page, but after that I just get a blank screen. Absolutely no errors from PHP, in any shape or form (or even logged to any file!), or any error from Apache even. Here is part of the communication between my server and a browser, I filled in the login page, enabled my tcpdump, and hit submit. POST /mysql/index.php HTTP/1.1 Referer: http://sql.orbis-terrarum.net/mysql/ Content-Type: application/x-www-form-urlencoded Accept-Encoding: gzip, deflate User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MathPlayer 2.0; (R1 1.5); .NET CLR 1.1.4322) Host: sql.orbis-terrarum.net Content-Length: 91 Connection: Keep-Alive Cache-Control: no-cache Cookie: pma_theme=original; pma_mcrypt_iv=Po4wIABjc8I%3D; pma_cookie_username-1=gyxyJ2f8Lo%2BBBlGcCZbY2Q%3D%3D pma_username=XXXX&pma_password=XXXXXXXXX&server=1&lang=en-iso-8859-1&convcharset=iso-8859-1 HTTP/1.1 302 Found Date: Mon, 11 Jul 2005 07:16:33 GMT Server: Apache/2.0.54 (Gentoo/Linux) PHP/4.4.0RC2 X-Powered-By: PHP/4.4.0RC2 Set-Cookie: pma_cookie_username-1=gyxyJ2f8Lo9RVCqezXed3g%3D%3D; expires=Wed, 10 Aug 2005 07:16:33 GMT; path=/mysql/ Set-Cookie: pma_cookie_password-1=kEKZPkXMOVOVLvg5LRAWSw%3D%3D; path=/mysql/ Location: http://sql.orbis-terrarum.net/mysql/index.php?lang=en-iso-8859-1&server=1 Content-Length: 0 Keep-Alive: timeout=15, max=96 Connection: Keep-Alive Content-Type: text/html; charset=ISO-8859-1 GET /mysql/index.php?lang=en-iso-8859-1&server=1 HTTP/1.1 Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, */* Referer: http://sql.orbis-terrarum.net/mysql/ Accept-Language: en-ca Accept-Encoding: gzip, deflate User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MathPlayer 2.0; (R1 1.5); .NET CLR 1.1.4322) Host: sql.orbis-terrarum.net Connection: Keep-Alive Cache-Control: no-cache Cookie: pma_theme=original; pma_mcrypt_iv=Po4wIABjc8I%3D; pma_cookie_username-1=gyxyJ2f8Lo9RVCqezXed3g%3D%3D; pma_cookie_password-1=kEKZPkXMOVOVLvg5LRAWSw%3D%3D HTTP/1.1 200 OK Date: Mon, 11 Jul 2005 07:16:33 GMT Server: Apache/2.0.54 (Gentoo/Linux) PHP/4.4.0RC2 X-Powered-By: PHP/4.4.0RC2 Set-Cookie: pma_cookie_username-1=gyxyJ2f8Lo9RVCqezXed3g%3D%3D; expires=Wed, 10 Aug 2005 07:16:33 GMT; path=/mysql/ Set-Cookie: pma_cookie_password-1=kEKZPkXMOVOVLvg5LRAWSw%3D%3D; path=/mysql/ Content-Length: 0 Keep-Alive: timeout=15, max=98 Connection: Keep-Alive Content-Type: text/html; charset=ISO-8859-1 I'm really stumped, so I've decided to post here, and hope that somebody else has some useful suggestions. For safety in posting here, I changed one character in the pma_mcrypt_iv so that you can't work out my username and password. -- Robin Hugh Johnson E-Mail : robbat2(a)orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639 GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85

2 2

[Phpmyadmin-devel] phpMyAdmin-2.6.3-pl1 is released
by Marc Delisle 04 Jul '05

04 Jul '05

Hi, For users of the mysqli extension, a problem exists in phpMyAdmin 2.6.3 and was fixed in 2.6.3-pl1. We regret this unfortunate bug. Marc Delisle

1 0

[Phpmyadmin-devel] phpMyAdmin 2.6.3 is released
by Marc Delisle 03 Jul '05

03 Jul '05

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.3 http://www.phpmyadmin.net phpMyAdmin 2.6.3 - July 3rd, 2005 ================================= A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of phpMyAdmin 2.6.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 GUI for MySQL and is downloaded between 6,000 and 14,000 times a day, according to SourceForge.net. Highlights ---------- Improvements: * Privileges: Always display the "Add a new user" link * New script to upgrade a phpMyAdmin installation * Database view: add a Privileges tab * Privileges: add a back link to the db on which we are checking privileges * "Hand" pointer on mouseover and mousedown * Password generator when creating/editing user account * Optional database creation before database copy * New languages: mongolian, tatarish Fixes: * Respect the db order given in only_db * Escaping of apostrophe in generated PHP code * Better handling of reserved words in queries * Detection of NULL fields under MySQL 5.0.x * Ordering by count(*) * Bookmark copying during table/db copy * Avoid double compression of exports when zlib.output_compression is On * Setting collation for a field * Js error when two queries submitted at once * Adding fields: table collation forgotten * Print view: missing header for multi tables * Comment at the end of query was applied as well to appended LIMIT * Searching on a VARBINARY field * Themes: spelling error on a font name * NULL detection on TIMESTAMPs * Diacritics wrongly converted * Changing table type under MySQL 5.0.4 * Left panel update after manual table rename * Queryframe update after database copy * Left panel number of rows not updated after emptying table * Invalid SQL when creating a table with zero fields * Missing backquotes on the Browse feature in case of duplicate entry * Exporting the results of a query containing "limit" clause * Copying a database did not preserve its default charset and collation * Copying a database containing a MERGE table * Javascript error when getting the value of a select field in some browsers * Problem renaming a database * Changing a table's collation under MySQL 5.0.x * Wrong type when creating a table under MySQL 5.0.x * When renaming a database, the old pmadb information would stay 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. 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, copy, rename 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 50 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller..com> Copyright (C) 2001-2005 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 Marc Delisle/ 2005-07-03

1 0