April 2011 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Fwd: regex-replace UI suggestion
by Karol Danko 12 May '11

12 May '11

Hi everybody, (I used phpmyadmin-users mailing first but I did not receive any response so sorry for double-post) I'm new to phpmyadmin development, so far I have been just passive daily user. I think phpmyadmin is great and I would love to help making it even better. I'm working on regex-replace interface for phpmyadmin: http://sourceforge.net/tracker/index.php?func=detail&aid=1398891&group_id=2… I would love to hear your thoughts about this concept I have, I suggest following UI: http://karoldanko.com/img/regex-replace.png The 'Rows to replace' is simply a where statement The second fieldset contains user defined regular expression matches. Each regexp has sort of ID which is later used when addressing correct token The last fieldset contains fields to be replaced. Fields are replaced by addressing ID of the match and token, e.g. #1$2 means token 2 from match 1 thank you in advance Karol

3 5

[Phpmyadmin-devel] Color of error messages in pmahomme theme
by Marc Delisle 06 May '11

06 May '11

Hi, I find it difficult to read error messages (white text on "pink" background). Text color red would be fine, IMO. -- Marc Delisle http://infomarc.info

4 13

[Phpmyadmin-devel] Charts colors and git question
by Tyron Madlener 05 May '11

05 May '11

I thought its a good idea to make the charts adjust to the current theme colors, so I wrote a patch for it: http://www.tyron.at/tmp/chart_colors.patch I also wrote a short blog entry about it, showing screenshots of the new changed charts: http://tyronx.blogspot.com/2011/04/some-better-colors-for-charts.html I tried to pull it to my repos on repo.or.cz but it doesn't accept my user name and password. Set I set up a push account for me though, and typed in my public key. The (Windows)-git-commit-tool-gui shows me the same public key. After I checked out the code, I've added my repos with the command 'git remote add tyronm ssh://repo.or.cz/srv/git/phpmyadmin/tyronm.git' then trying to pull via 'git pull tyronm'. Anyone know what I'm doing wrong? Thanks in advance.

6 12

[Phpmyadmin-devel] Firefox 4.0
by Isaac Bennetch 01 May '11

01 May '11

Does anyone use Firefox 4.0? I've got 3.whatever, and prefer not to upgrade yet, but a user reported some trouble with the display under FF4. https://sourceforge.net/projects/phpmyadmin/forums/forum/72909/topic/4482670 Just wondering if anyone can confirm, at the least.

6 5

[Phpmyadmin-devel] AJAXify phpMyAdmin Interface - GSOC 2011
by Thilanka Kaushalya 01 May '11

01 May '11

Hi Marc, I created the git branch [1] for the project. Here is my blog [2] and I saw that it is already included to phpmyadmin planet. I'll start writing the posts on the project by tomorrow. I updated the schedule of my proposal as you mentioned [3]. Thank you. [1] - http://repo.or.cz/w/phpmyadmin/thilanka.git <http://repo.or.cz/w/phpmyadmin/thilanka.git>[2] - http://coders-view.blogspot.com/ [3] - http://www.google-melange.com/gsoc/proposal/review/google/gsoc2011/lgtkaush… Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

3 4

[Phpmyadmin-devel] OpenGIS support for phpMyAdmin
by Madhura Jayaratne 29 Apr '11

29 Apr '11

Hi Michal, First of all thank you so much for coming up as the mentor for this project idea, especially when it didn't have a mentor initially. And a big thank goes to phpMyAdmin team and Google for this great opportunity. I will use the following blog [1] to communicate the progress of the project. I have already included some posts about the project and will continue to post. Please be kind enough to merge it to Plant phpMyAdmin. Michal, I will get in touch with you to plan ahead for the development work. -- Thanks and Regards, Madhura Jayaratne [1] http://madhuracj.blogspot.com/

1 1

[Phpmyadmin-devel] outdated md5 bug -- versions 3.3.0 - 3.3.3
by Isaac Bennetch 28 Apr '11

28 Apr '11

Hi, An IRC user reported some strange behavior with the MD5 function under the version 3.3.2 shipped with Ubuntu[1]. For instance, select md5('blah') is returning 3666316564303032616235353935383539303134656266303935313532326439 instead of 6f1ed002ab5595859014ebf0951522d9. I also tested a few other strings, which aren't worth copying and pasting here other than to say they are also incorrect. I did some work with git and found it affects the officially distributed versions 3.3.0, 3.3.1, and 3.3.2 (and was then fixed for 3.3.3). Since it's been fixed for several releases, I don't think anything needs to be done about it, but I haven't seen any bug reports or commit messages about it and thought it should be mentioned. To reproduce under any of 3.3.0, 3.3.1, or 3.3.2 go to the SQL query window, run the query "select md5('blah')" and compare the result to the same query run from the command line (or a non-affected pma instance). ~isaac 1 - my Debian box would want to install 2.11.8.1 !

2 2

[Phpmyadmin-devel] GSoC 2011: Drizzle support
by Piotr Przybylski 27 Apr '11

27 Apr '11

Hi everyone, This year I will be implementing Drizzle support, so that phpMyAdmin will be able to work with this light MySQL fork. You will be able to track my work by reading weekly reports on my usually-dead blog [1] and checking my git repository [2]. [1] http://crackpl.eu/blog/ [2] http://repo.or.cz/w/phpmyadmin/crack.git -- Regards, Piotr Przybylski

1 0

[Phpmyadmin-devel] Links to documentation from displayed SQL query rfe:2937379
by Samiran Raj Boro 27 Apr '11

27 Apr '11

http://sourceforge.net/tracker/index.php?func=detail&aid=2937379&group_id=2… Is someone working in the above mentioned task. If none let me do it. Waiting for go signal, Samiran

2 3

[Phpmyadmin-devel] [Drizzle] Charset and Collation issue
by Azhari Harahap 27 Apr '11

27 Apr '11

Hi all I've been started to look at Drizzle compability with MySQL, and the first issue i got is the Charset and Collation I've been looking through Drizzle documentation and it said that currently Drizzle only support utf8 charset and collation. But as i seen the code on latest trunk, phpMyAdmin simply disable it rather than set it to utf8. As i tested on Drizzle7 2011.03.13, we can look at supported charset by query: SELECT * from DATA_DICTIONARY.CHARACTER_SETS; As replacement of SHOW CHARACTER SET; on MySQL And for the collation: SELECT * from DATA_DICTIONARY.COLLATIONS; As replacement of SHOW COLLATION; on MySQL But, the table structure is little bit confusing here, because in MySQL we can match the `Charset` field on both result, but in Drizzle i've to match `CHARACTER_SET_NAME` on charset result and `DESCRIPTION` on collation result. At least, now phpMyAdmin can show correct charset and collation on the Charsets menu. I already send patch for this issue [1] But, i got another issue, for example when submit Create table form, it thrown error "CHARACTER SET" because it's removed on Drizzle [1], but "COLLATE" seems to be supported [2] I'll give more investigation on this issue. [1] https://sourceforge.net/tracker/?func=detail&aid=3280876&group_id=23067&ati… [2] http://docs.drizzle.org/mysql_differences.html#objects-removed [3] http://docs.drizzle.org/create_table.html?highlight=create%20table#data-type Regards Azhari Harahap http://azhari.harahap.us

2 3