August 2013 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] effect of "Choose column to display" in table relation view
by Supun Nakandala 28 Aug '13

28 Aug '13

Hi devs, I am refactoring tbl_relation.php. I want to test the code but I cannot find the effect of "Choose column to display" in table relation view. Regards Supun

2 1

[Phpmyadmin-devel] Navigation tree problems
by Michal Čihař 28 Aug '13

28 Aug '13

Hi all I've looked a bit about problems people see with navigation frame and here is a little summary. - Speed The navigation panel is quite slow. By quickly looking at SQL queries it does, the database/table comments are quite big culprit here. Simply setting $cfg['ShowTooltip'] = false reduces load time a lot. For not so big database (~25 tables), I get from 1.25s to 0.128s. Are tooltips really worth of this? I suggest to drop this feature completely. In case there will be demand for something like that, lets load it on demand when user is hovering the table. https://github.com/phpmyadmin/phpmyadmin/pull/646 - Pagination Pagination together with tree can be quite annoying. I think we should increase limit for pagination to something like 250. It is still not too much to load (with disabled table comments, see above) and you can scroll in the navigation bar, what is much more convenient that clicking browse arrows. https://github.com/phpmyadmin/phpmyadmin/pull/647 - Quick search and pagination "%s other result found" is another usability nightmare, but this can be hidden by increasing limits (see above). But IMHO quick search (as it is anyway server side) should directly return all results. - Database jumping Maybe we should consider some option for database jumping - providing select box with all databases which will bring user directly to this database. This seems to be quite frequent use case for people maintaining lot of databases and tree navigation makes this quite hard... - Preserving state on reload This has been already discussed before. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

5 8

[Phpmyadmin-devel] Build failed in Jenkins: phpMyAdmin-continuous #4225
by michal＠cihar.com 28 Aug '13

28 Aug '13

See <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/4225/changes> Changes: [chathuranga.jayaneththi] Modify isTime() function to accept times with fractional [chathuranga.jayaneththi] Update jquery-ui-timepicker-addon to version 1.3.1 [chathuranga.jayaneththi] Use fractional seconds in time [chathuranga.jayaneththi] Do not add trailing 0s for 'CURRENT_TIMESTAMP' string ------------------------------------------ Started by GitHub push by ibennetch Building in workspace <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/> Checkout:workspace / <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/> - hudson.remoting.LocalChannel@75cd93e9 Using strategy: Default Last Built Revision: Revision c036ae1d5c171c85224afa9543a98b658f976c90 (origin/master) Fetching changes from 1 remote Git repository Fetching upstream changes from origin Commencing build of Revision fa87bcec06c135d888e7ebe5a2d577f7e67181cb (origin/master) Checking out Revision fa87bcec06c135d888e7ebe5a2d577f7e67181cb (origin/master) [workspace] $ /bin/sh -xe /tmp/hudson7921368792080905364.sh + ./scripts/generate-mo --quiet [workspace] $ ant clean phpunit-nocoverage phpcpd phpcs phploc jshint Unable to locate tools.jar. Expected to find it in /usr/lib/jvm/java-7-openjdk-amd64/lib/tools.jar Buildfile: <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml> clean: [delete] Deleting directory <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/api> [delete] Deleting directory <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/code-browser> [delete] Deleting directory <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/coverage> [delete] Deleting directory <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/logs> [delete] Deleting directory <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/pdepend> [mkdir] Created dir: <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/api> [mkdir] Created dir: <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/code-browser> [mkdir] Created dir: <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/coverage> [mkdir] Created dir: <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/logs> [mkdir] Created dir: <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/pdepend> phpunit-nocoverage: [exec] Enabling headers testing... [exec] [exec] [exec] [exec] [exec] [exec] [exec] [exec] [exec] [exec] PHPUnit 3.7.22 by Sebastian Bergmann. [exec] [exec] Configuration read from <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/phpunit.xml.nocoverage> [exec] [exec] ............................................................[33;1mI[0m 61 / 2086 ( 2%) [exec] ............................................................. 122 / 2086 ( 5%) [exec] ............................................................. 183 / 2086 ( 8%) [exec] ............................................................. 244 / 2086 ( 11%) [exec] ............................................................. 305 / 2086 ( 14%) [exec] ............................................................. 366 / 2086 ( 17%) [exec] ............................................................. 427 / 2086 ( 20%) [exec] ............................................................. 488 / 2086 ( 23%) [exec] ............................................................. 549 / 2086 ( 26%) [exec] ............................................................. 610 / 2086 ( 29%) [exec] .......................................[33;1mI[0m..................... 671 / 2086 ( 32%) [exec] ............................................................. 732 / 2086 ( 35%) [exec] ............................................................. 793 / 2086 ( 38%) [exec] ............................................................. 854 / 2086 ( 40%) [exec] ............................................................. 915 / 2086 ( 43%) [exec] ............................................................. 976 / 2086 ( 46%) [exec] ............................................................. 1037 / 2086 ( 49%) [exec] ............................................................. 1098 / 2086 ( 52%) [exec] ............................................................. 1159 / 2086 ( 55%) [exec] ............................................................. 1220 / 2086 ( 58%) [exec] ............................................................. 1281 / 2086 ( 61%) [exec] ............................................................. 1342 / 2086 ( 64%) [exec] ............................................................. 1403 / 2086 ( 67%) [exec] ............................................................. 1464 / 2086 ( 70%) [exec] ............................................................. 1525 / 2086 ( 73%) [exec] ............................................................. 1586 / 2086 ( 76%) [exec] ............................................................. 1647 / 2086 ( 78%) [exec] ......................................[31;1mE[0m...................... 1708 / 2086 ( 81%) [exec] ............................................................. 1769 / 2086 ( 84%) [exec] ............................................................. 1830 / 2086 ( 87%) [exec] ............................................................. 1891 / 2086 ( 90%) [exec] .........................[33;1mI[0m................................... 1952 / 2086 ( 93%) [exec] ............................................................. 2013 / 2086 ( 96%) [exec] ............................................................. 2074 / 2086 ( 99%) [exec] ...........[33;1mI[0m [exec] [exec] Time: 23 seconds, Memory: 106.00Mb [exec] [exec] There was 1 error: [exec] [exec] 1) PMA_InsertEditTest::testVerifyWhetherValueCanBeTruncatedAndAppendExtraData [exec] Use of undefined constant PMA_DBI_QUERY_STORE - assumed 'PMA_DBI_QUERY_STORE' [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/libraries/insert_edit…>:2430 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/libraries/PMA_in…>:2568 [exec] [exec] There were 4 incomplete tests: [exec] [exec] 1) PMA_ConfigTest::testCheckPermissions [exec] This test has not been implemented yet. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/classes/PMA_Conf…>:943 [exec] [exec] 2) PMA_AuthenticationCookie_Test::testBlowfishDecrypt [exec] Not testing mcrypt support [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/classes/plugin/a…>:1097 [exec] [exec] 3) PMA_TblColumnsDefinitionFormTest::testGetFormParamsForOldColumn [exec] Not yet implemented! [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/libraries/PMA_tb…>:1114 [exec] [exec] 4) Environment_Test::testSession [exec] No session testing [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/Environment_test…>:83 [exec] [exec] [37;41m[2KFAILURES! [exec] [0m[37;41m[2KTests: 2086, Assertions: 4804, Errors: 1, Incomplete: 4. [exec] [0m[2K BUILD FAILED <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:30: exec returned: 2 Total time: 24 seconds Build step 'Invoke Ant' marked build as failure [CHECKSTYLE] Skipping publisher since build result is FAILURE [DRY] Collecting duplicate code analysis files... [DRY] Finding all files that match the pattern build/logs/pmd-cpd.xml [DRY] Computing warning deltas based on reference build #4224 [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #4224 Recording plot data [xUnit] [INFO] - Starting to record. [xUnit] [INFO] - Processing PHPUnit-3.x (default) [xUnit] [INFO] - [PHPUnit-3.x (default)] - 1 test report file(s) were found with the pattern 'build/logs/junit.xml' relative to '<http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/'> for the testing framework 'PHPUnit-3.x (default)'. [xUnit] [INFO] - Check 'Failed Tests' threshold. [xUnit] [INFO] - Check 'Skipped Tests' threshold. [xUnit] [INFO] - Setting the build status to FAILURE [xUnit] [INFO] - Stopping recording.

1 12

[Phpmyadmin-devel] trouble with StackOverflow???
by Isaac Bennetch 27 Aug '13

27 Aug '13

Here's the first question[1] I've see flagged as off topic. I'm closely monitoring the situation (not just that question, but the moderation overall) to see if StackOverflow is going to let us down. 1 - http://stackoverflow.com/questions/18429916/accessing-phpmyadmin-remotely

5 6

[Phpmyadmin-devel] phpMyAdmin 4.0.6-rc1 is released
by Marc Delisle 27 Aug '13

27 Aug '13

Welcome to the first release candidate for phpMyAdmin 4.0.6, a bugfix version with improvements in the navigation panel. Details will appear on http://phpmyadmin.net. In a hurry? you can visit https://sourceforge.net/projects/phpmyadmin/files to download. Marc Delisle, for the team

1 0

[Phpmyadmin-devel] Fwd: [Broken] phpmyadmin/phpmyadmin#4184 (master - fa87bce)
by Isaac Bennetch 27 Aug '13

27 Aug '13

It looks like this Travis CI report was sent to phpmyadmin-users, which doesn't seem right. Is that something we can reconfigure? ---------- Forwarded message ---------- From: Travis CI <notifications(a)travis-ci.org> Date: Tue, Aug 27, 2013 at 9:43 AM Subject: [Broken] phpmyadmin/phpmyadmin#4184 (master - fa87bce) To: bennetch(a)gmail.com, phpmyadmin-users(a)lists.sourceforge.net ** The build was broken. Repository phpmyadmin/phpmyadmin Build #4184 https://travis-ci.org/phpmyadmin/phpmyadmin/builds/10668076<http://mandrillapp.com/track/click.php?u=30007208&id=51a1adf921864fdf9206e9…> Changeset https://github.com/phpmyadmin/phpmyadmin/compare/c036ae1d5c17...fa87bcec06c1<http://mandrillapp.com/track/click.php?u=30007208&id=51a1adf921864fdf9206e9…> Commit fa87bce (master) Message Merge pull request #582 from kasunchathuranga/fractionalSecs Use fractional seconds in time, datetime and timestamp Author Isaac Bennetch Duration 4 minutes and 32 seconds You can configure recipients for build notifications in your configuration file<http://mandrillapp.com/track/click.php?u=30007208&id=51a1adf921864fdf9206e9…>. Further documentation about Travis CI can be found here<http://mandrillapp.com/track/click.php?u=30007208&id=51a1adf921864fdf9206e9…>. For help please join our IRC channel irc.freenode.net#travis. Want Travis CI for your private repositories?<http://mandrillapp.com/track/click.php?u=30007208&id=51a1adf921864fdf9206e9…> Powered by <http://mandrillapp.com/track/click.php?u=30007208&id=51a1adf921864fdf9206e9…>

3 3

[Phpmyadmin-devel] Appropriate feature request to implement?
by Kasun Chathuranga 27 Aug '13

27 Aug '13

Hi devs, Since "reCaptcha support for login panel" [1] feature I planned to implement has already been implemented, I thought "Show per table privileges" [2] feature would be a good candidate to implement in place of it. I would like to know whether [2] is good to be implemented. Further the current implementation uses server_privileges.php and server_privileges.lib.php for both Users tab in server level and Privileges tab in database level. Is it a good idea to refactor them to different files (db_privileges.php and db_privileges.lib.php may be)? [1] https://sourceforge.net/p/phpmyadmin/feature-requests/1382/ [2] https://sourceforge.net/p/phpmyadmin/feature-requests/1253/ -- Regards Kasun Chathuranga

2 1

[Phpmyadmin-devel] navi panel and 4.0.6-rc1
by Marc Delisle 27 Aug '13

27 Aug '13

Hi, please have a look at the current state of QA_4_0. I encouraged Atul to merge his implementation for RFE 1435 and he did some other improvements to the navi panel. I plan to release 4.0.6-rc1 tomorrow with these changes. -- Marc Delisle http://infomarc.info

5 7

[Phpmyadmin-devel] license for error reporting server
by Dieter Adriaenssens 26 Aug '13

26 Aug '13

Hi Mohamed, On the team meeting last week, we discussed the license under which the error reporting server will be published. Because it is based on cakePHP which is licensed under MIT 2.0, we decided to license our additions under MIT 2.0 as well. This way it will be easier to contribute any changes that might be useful for cakePHP upstream (if applicable). In order to keep track of who holds copyright on which files (cakePHP or phpMyAdmin), a copyright notice should be added to each file that was created for phpMyAdmin. For original cakePHP files that are modified, both copyright holders (cakePHP and phpMyAdmin) should be mentioned. Can you do the necessary changes? Thanks! -- Kind regards, Dieter Adriaenssens

2 6

[Phpmyadmin-devel] Tutorials
by Isaac Bennetch 25 Aug '13

25 Aug '13

After being inspired by the tutorial we did and also a nice chat with Rouslan while riding the train, I think it would be great to do a few tutorial videos. I've started a wiki page [1] with ideas, but right now I just duplicate what we did in the video. My goal is to make these short, perhaps five minutes each, and showcase one or two features. I'm open to suggestions and have no idea when I'll actually get around to creating them, but if you have an idea, please add it. Regards and happy weekend ~isaac 1 - http://wiki.phpmyadmin.net/pma/Proposed_tutorials

4 3