- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] 4.0.x and export problems
by Marc Delisle 30 Aug '13

30 Aug '13

Hi, I just tested a big export and we have a problem in 4.0.5, compared to 3.5.8. In 3.5.8, a normal SQL export starts almost immediately, but in 4.0.5 it stalls and does not complete. I am testing with the employees.salaries sample table. I suggest to delay the final 4.0.6 (possibly releasing a 4.0.6-rc2 with a fix for this). -- Marc Delisle http://infomarc.info

3 6

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

28 Aug '13

See <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/4245/changes> Changes: [marc] Extraneous question mark was generated in the link ------------------------------------------ Started by GitHub push by lem9 Building in workspace <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/> Checkout:workspace / <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/> - hudson.remoting.LocalChannel@213c35f2 Using strategy: Default Last Built Revision: Revision 39fdb7d3a1db48dcd1f442c534bb9db17b3fd67b (origin/master) Fetching changes from 1 remote Git repository Fetching upstream changes from origin Commencing build of Revision 0690740b0dd0d185457532237de7f7c1b399de89 (origin/master) Checking out Revision 0690740b0dd0d185457532237de7f7c1b399de89 (origin/master) [workspace] $ /bin/sh -xe /tmp/hudson4634436059560626423.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 / 2084 ( 2%) [exec] ............................................................. 122 / 2084 ( 5%) [exec] ............................................................. 183 / 2084 ( 8%) [exec] ............................................................. 244 / 2084 ( 11%) [exec] ............................................................. 305 / 2084 ( 14%) [exec] ............................................................. 366 / 2084 ( 17%) [exec] ............................................................. 427 / 2084 ( 20%) [exec] ............................................................. 488 / 2084 ( 23%) [exec] ............................................................. 549 / 2084 ( 26%) [exec] ............................................................. 610 / 2084 ( 29%) [exec] .....................................[33;1mI[0m....................... 671 / 2084 ( 32%) [exec] ............................................................. 732 / 2084 ( 35%) [exec] ............................................................. 793 / 2084 ( 38%) [exec] ............................................................. 854 / 2084 ( 40%) [exec] ............................................................. 915 / 2084 ( 43%) [exec] ............................................................. 976 / 2084 ( 46%) [exec] ............................................................. 1037 / 2084 ( 49%) [exec] ............................................................. 1098 / 2084 ( 52%) [exec] ............................................................. 1159 / 2084 ( 55%) [exec] ............................................................. 1220 / 2084 ( 58%) [exec] ............................................................. 1281 / 2084 ( 61%) [exec] ............................................................. 1342 / 2084 ( 64%) [exec] ............................................................. 1403 / 2084 ( 67%) [exec] ............................................................. 1464 / 2084 ( 70%) [exec] ............................................................. 1525 / 2084 ( 73%) [exec] ............................................................. 1586 / 2084 ( 76%) [exec] ............................................................. 1647 / 2084 ( 79%) [exec] ............................................................. 1708 / 2084 ( 81%) [exec] ............................................................. 1769 / 2084 ( 84%) [exec] ............................................................. 1830 / 2084 ( 87%) [exec] ............................[41;37mF[0m................................ 1891 / 2084 ( 90%) [exec] .......................[33;1mI[0m..................................... 1952 / 2084 ( 93%) [exec] ............................................................. 2013 / 2084 ( 96%) [exec] ............................................................. 2074 / 2084 ( 99%) [exec] .........[33;1mI[0m [exec] [exec] Time: 21 seconds, Memory: 106.75Mb [exec] [exec] There was 1 failure: [exec] [exec] 1) PMA_ServerUserGroupsTest::testGetHtmlForUserGroupsTableWithUserGroups [exec] Failed asserting that '<h2>User groups</h2><form name="userGroupsForm" id="userGroupsForm" action="server_privileges.php" method="post"><input type="hidden" name="token" value="token" /><table id="userGroupsTable"><thead><tr><th style="white-space: nowrap">User group</th><th>Server level tabs</th><th>Database level tabs</th><th>Table level tabs</th><th>Action</th></tr></thead><tbody><tr class="odd"><td>usergroup</td><td>SQL, Status, Users, Export, Import, Settings, Binary log, Replication, Variables, Charsets, Plugins, Engines</td><td>SQL, Search, Query, Export, Import, Operations, Privileges, Routines, Events, Triggers, Tracking, Designer</td><td>Structure, SQL, Search, Insert, Export, Import, Operations, Tracking, Triggers</td><td><a class="" href="server_user_groups.php?viewUsers=1&userGroup=usergroup&token=token"><span class="nowrap"><img src="themes/dot.gif" title="View users" alt="View users" class="icon ic_b_usrlist" /> View users</span></a>  <a class="" href="server_user_groups.php?editUserGroup=1&userGroup=usergroup&token=token"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a>  <a class="deleteUserGroup ajax" href="server_user_groups.php?deleteUserGroup=1&userGroup=usergroup&token=token"><span class="nowrap"><img src="themes/dot.gif" title="Delete" alt="Delete" class="icon ic_b_drop" /> Delete</span></a></td></tr></tbody></table></form><fieldset id="fieldset_add_user_group"><a href="server_user_groups.php?addUserGroup=1&token=token"><span class="nowrap"><img src="themes/dot.gif" title="" alt="" class="icon ic_b_usradd" /> </span>Add user group</a></fieldset>' contains "<a class="" href="server_user_groups.php??viewUsers=1&userGroup=usergroup&token=token". [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/libraries/PMA_se…>:133 [exec] [exec] -- [exec] [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…>:948 [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: 2084, Assertions: 4807, Failures: 1, Incomplete: 4. [exec] [0m[2K BUILD FAILED <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:30: exec returned: 1 Total time: 22 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 #4244 [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #4244 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 0

[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