- Developers - lists.phpmyadmin.net

[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

Re: [Phpmyadmin-devel] relation view behavior
by Marc Delisle 30 Jun '05

30 Jun '05

Michael Keck a écrit : > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi, > > in our image tree is a button called b_save.png, > perhabs we can use this? Strange :) I don't remember that we use it now... but yes it could be used. Anyway, this will go into HEAD for 2.6.4. Marc > > Michael > > - --- Original Message --- > Mail from: Marc Delisle > Date: 30.06.2005 12:39 > >>Michal Čihař a écrit : >> >> >>>Hi >>> >>>On Wednesday 29 June 2005 13:27, Marc Delisle wrote: >>> >>> >>>>regarding >>>>https://sourceforge.net/tracker/index.php?func=detail&aid=1227710&group_id= >>>> >>>>23067&atid=377408 >>>> >>>>should we submit the left form (links) whenever a link is added, instead >>>>of hoping that the user will click Go? >>> >>> >>> >>>1. Maybe automatic saving would be better. >>> >>>2. I always wondered why we always use "Go" and not "Save" in such >>>situations. >>> >> >>Thanks Garvin and Michal for your input. Your comments made me think >>further: >>why don't we just put one submit button (probably named "Save") and merge >>the three forms: internal relations, InnoDB relations, display field? >> >>Marc >> >> >> >>------------------------------------------------------- >>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies >>from IBM. Find simple to follow Roadmaps, straightforward articles, >>informative Webcasts and more! Get everything you need to get up to >>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click >>_______________________________________________ >>Phpmyadmin-devel mailing list >>Phpmyadmin-devel(a)lists.sourceforge.net >>https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel >> >> >> > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (MingW32) > Comment: GnuPT 2.6.2.1 by EQUIPMENTE.DE > > iD8DBQFCw87GAeceoyXDUmIRAn/FAJ48jqcVeytfxQkzgKVKEQDAVwQDTACeNYqw > v/t5Qxba5teNKYe1H/WR64o= > =1tjz > -----END PGP SIGNATURE----- >

1 0

[Phpmyadmin-devel] relation view behavior
by Marc Delisle 30 Jun '05

30 Jun '05

Hi, regarding https://sourceforge.net/tracker/index.php?func=detail&aid=1227710&group_id=… should we submit the left form (links) whenever a link is added, instead of hoping that the user will click Go? Marc

3 3

[Phpmyadmin-devel] About 2.6.3 and 2.6.4
by Marc Delisle 29 Jun '05

29 Jun '05

Hi devs, Looking at the recent ChangeLog, IMO most of those changes belong to 2.6.4. We are at 2.6.3-rc1 and only bugfix should go for 2.6.3. Here is my proposition: I would open the QA_2_6_3 branch, based on RELEASE_2_6_3RC1, then backport to this branch the bug fixes than went into HEAD. Aiming for a final 2.6.3 on July 3rd. Opinions? Marc

2 4

[Phpmyadmin-devel] base64_decode
by Michal Čihař 28 Jun '05

28 Jun '05

Hi all Has somebody idea why we check for existence of base64_decode function in http auth? According to documentation this function is there for ages. Initial commit of this was done by loic while adding support for IIS. -- Michal Čihař | http://cihar.com

2 1

[Phpmyadmin-devel] Re: [Phpmyadmin-cvs] CVS: phpMyAdmin config.inc.php,2.53,2.54
by Garvin Hicking 23 Jun '05

23 Jun '05

Hi Robin! > $cfg['InsertDropdownOrder'] = FALSE; // Ordering for elements in > dropdown. I'm afraid this description "InsertDropdownOrder" seems a bit odd; if I didn't read the sourcecode I wouldn't know what the option is for. I'd rename it to "ForeignKeyDropdownOrder" = array('content-id', 'id-content'); Then people can either change the order in the array, or even strip "id-content" or "content-id" completely to only have one-way order (some people seem to get confused by it). Opinions? > + $cfg['SetOperators'] = array( > + 'IN', > + 'NOT IN' > + ); > + What's that for? 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 -- Garvin Hicking | Web-Entwickler | Make me happy: www.supergarv.de | #ICQ 21392242 | http://wishes.garv.info/

2 1