March 2014 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] problem in PMA_ConfigTest
by Minhaz A V 05 Mar '14

05 Mar '14

In the setUp() of the test class *PMA_ConfigTest *( ./test/classes/PMA_ConfigTest.php ) two objects are created one for testing purpose ($object variable of class) and other as a global variable the test object is initialized with no parameter, while the global one is initialized with "*config.inc.php*" as a parameter, Although it should be initialized with *"config.sample.inc.php" *as this file exist in codebase while former does not. I have pulled a request for the same at https://github.com/phpmyadmin/phpmyadmin/pull/994 But there is a problem I'm facing here, for the global version the assertion for permissions is failing, while it should not .... I can't understand this. Can anyone help? Minhaz cistoner.org

2 5

[Phpmyadmin-devel] CSS class that is common to all themes
by Sastry aditya 05 Mar '14

05 Mar '14

Hey, I am working on the fix for this bug https://sourceforge.net/p/phpmyadmin/bugs/4228/ and I came up with a adhoc fix for this till the bug is fixed from the chrome end. Anyways I need to put a .css class declaration somewhere common to all themes. Could someone tell me where such a css file would be. Regards, Aditya

2 1

[Phpmyadmin-devel] Bug #4301: need suggestion
by Smita 05 Mar '14

05 Mar '14

Hi, I was looking at the bug http://sourceforge.net/p/phpmyadmin/bugs/4301/ . I think, If the query execution is not redirecting page, ie it's happening on the same page via an ajax request then there are two ways we can approach it. 1. Append an another Query box below previous Query box for all the following requests. So in this case, we'll have separate query boxes for each operation performed on the page. 2. Append the query itself with separator semicolon in the same existing query box. In this case we'll have same just one Query box having all the Queries appended with separator semicolon. Please let me know if any concern, and what approach we can take to solve the same ? Fixing the bug will also make sure that user will have list of all the queries performed on relation in order that resulted into the results displayed on the page. Thanks and Regards - Smita Kumari

5 12

[Phpmyadmin-devel] GIS visualization support request
by Isaac Bennetch 05 Mar '14

05 Mar '14

Hi, I don't know enough about the GIS visualization to help this person[1], would anyone else have a moment to take a look? 1 - https://stackoverflow.com/questions/22152862/phpmyadmin-gis-visualization-d…

3 3

Re: [Phpmyadmin-devel] Regarding Bug #4310
by Umair Khan 05 Mar '14

05 Mar '14

Actually it was something else derped in my PMA which was causing this bug. Now the content in the navigation panel while creating the procedure from is same as the main content. But the thing is that after the procedure is created, the new database is not selected but the old one. So, I want to ask should I make it to select the database in which the procedure was created ? Or the current behaviour is OK ?

1 0

[Phpmyadmin-devel] Invalid HTML code for query result (#result_query)
by Abhishek Kandoi 05 Mar '14

05 Mar '14

While examining the *bug 4301*, I found a fundamental problem with the query result messages (those with id result_query). The problem is that in some cases there are multiple result query messages that have to be displayed. For eg: when a row is edited (using the *Edit *link of a particular row on the browse table page) two result queries are displayed. The first is an *UPDATE* query and the other is a *SELECT* query. The corresponding HTML for this contains two *div*s with the same id (i.e. *result_query*). This is invalid html as an *id* is supposed to be unique to an element and must only identify a single element. Regarding the bug 4301, there is a pull request from *krtin *available here https://github.com/phpmyadmin/phpmyadmin/pull/1006. But according to the standards this is not the proper way to fix this bug. I would like to re-factor the code corresponding to the multiple-element-with-same-id problem and then fix this bug accordingly. This pull request does solve the problem but, in the long run it may be problematic due to its inconsistency with the overall UI/UX of phpMyAdmin (it uses animation to display the UPDATE query for a few seconds followed by the SELECT query). Any thoughts on this? -- Abhishek Kandoi Second Year, Computer Science and Engineering Indian Institute of Technology Roorkee About Me : about.me/kandoiabhi I blog at: abhikandoi.in

2 1

[Phpmyadmin-devel] GSoC 2014
by Abhishek Kandoi 05 Mar '14

05 Mar '14

Hello everyone, My name is Abhishek Kandoi and I am a 2nd Year Undergraduate pursuing Bachelors of Technology in Computer Science at IIT Roorkee, India. I have been following the development of phpMyAdmin and have contribute some bug fixes. This made me familiar with the code-base of phpMyAdmin. As a part GSoC 2014, I would love to continue contributing to PMA. Apart from this I have worked on a number of projects related to Web Development (using PHP as well as Python). This includes both individual projects as well as collaborative projects (using Git and GitHub). Apart from bug fixes what else can I do to strengthen my application for GSoC? Thanks and Regards -- Abhishek Kandoi Second Year, Computer Science and Engineering Indian Institute of Technology Roorkee About Me : about.me/kandoiabhi I blog at: abhikandoi.in

2 1

[Phpmyadmin-devel] Travis fails for the bug patch I have written
by Sastry aditya 05 Mar '14

05 Mar '14

Hey, I wrote a patch for this bug 4306<https://sourceforge.net/p/phpmyadmin/bugs/4306/>. The breadcrumb bar was pointing to the newly created table even when we are back from the table creation page and are exploring the structure of the DB. This was the patch I wrote. https://github.com/phpmyadmin/phpmyadmin/pull/1005 But the travis failed on this one with the error, "Starting test 'Advisor_Test::testAddRule with data set #5 (array('foo | fsafdsa', 'Failure', 'issue', 'Recommend'), array(), 'Failed formatting string for rule \'Failure\'. PHP threw following error: Use of undefined constant fsafdsa - assumed \'fsafdsa\'')'. No output has been received in the last 10 minutes, this potentially indicates a stalled build or something wrong with the build itself." I just checked the tests for tbl_create.php and I didn't see anything that would cause this to fail ! The error seems a bit vague and doesn't point out any particular test that failed so if someone could point out what failed, that would be great. Regards, Aditya

2 1

[Phpmyadmin-devel] Build failed in Jenkins: phpMyAdmin-continuous #5655
by michal＠cihar.com 04 Mar '14

04 Mar '14

See <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/5655/changes> Changes: [weblate] Translated using Weblate (Estonian) ------------------------------------------ [...truncated 268 lines...] [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:29 [exec] [exec] 28) PMA_SeleniumLoginTest::testLoginWithWrongPassword [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:43 [exec] [exec] 29) PMA_SeleniumPrivilegesTest::testChangePassword [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:29 [exec] [exec] 30) PMA_SeleniumSettingsTest::testHideDatabase [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:27 [exec] [exec] 31) PMA_SeleniumSettingsTest::testSettingsTabsAreDisplayed [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:27 [exec] [exec] 32) PMA_SeleniumSettingsTest::testHideLogo [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:27 [exec] [exec] 33) PMA_SeleniumTableBrowseTest::testSortRecords [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:51 [exec] [exec] 34) PMA_SeleniumTableBrowseTest::testChangeRecords [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:51 [exec] [exec] 35) PMA_SeleniumTableBrowseTest::testChangeRecordsByDoubleClick [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:51 [exec] [exec] 36) PMA_SeleniumTableBrowseTest::testCopyRecords [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:51 [exec] [exec] 37) PMA_SeleniumTableBrowseTest::testSearchRecords [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:51 [exec] [exec] 38) PMA_SeleniumTableBrowseTest::testDeleteRecords [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:51 [exec] [exec] 39) PMA_SeleniumTableCreateTest::testCreateTable [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:29 [exec] [exec] 40) PMA_SeleniumTableInsertTest::testAddData [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:47 [exec] [exec] 41) PMA_SeleniumTableOperationsTest::testChangeTableOrder [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:47 [exec] [exec] 42) PMA_SeleniumTableOperationsTest::testMoveTable [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:47 [exec] [exec] 43) PMA_SeleniumTableOperationsTest::testRenameTable [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:47 [exec] [exec] 44) PMA_SeleniumTableOperationsTest::testCopyTable [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:47 [exec] [exec] 45) PMA_SeleniumTableOperationsTest::testTruncateTable [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:47 [exec] [exec] 46) PMA_SeleniumTableOperationsTest::testDropTable [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:47 [exec] [exec] 47) PMA_SeleniumTableStructureTest::testAddColumn [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:45 [exec] [exec] 48) PMA_SeleniumTableStructureTest::testChangeColumn [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:45 [exec] [exec] 49) PMA_SeleniumTableStructureTest::testDropColumns [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:45 [exec] [exec] 50) PMA_SeleniumTrackingTest::testTrackingData [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:54 [exec] [exec] 51) PMA_SeleniumTrackingTest::testDeactivateTracking [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:54 [exec] [exec] 52) PMA_SeleniumTrackingTest::testDropTracking [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:54 [exec] [exec] 53) PMA_SeleniumTrackingTest::testStructureSnapshot [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:54 [exec] [exec] 54) PMA_SeleniumXSSTest::testQueryTabWithNullValue [exec] InvalidArgumentException: Element not found. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:340 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:242 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:29 [exec] [exec] There were 2 incomplete tests: [exec] [exec] 1) PMA_DisplayResults_Test::testGetTableNavigation with data set #0 (21, 41, '123', false, '310') [exec] Not yet implemented! [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/classes/PMA_Disp…>:438 [exec] [exec] 2) PMA_TblColumnsDefinitionFormTest::testGetFormParamsForOldColumn [exec] Not yet implemented! [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/libraries/PMA_tb…>:1101 [exec] [exec] -- [exec] [exec] [exec] There were 2 skipped tests: [exec] [exec] 1) PMA_SeleniumCreateDropDatabaseTest::testCreateDropDatabase [exec] Test user is not a superuser. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:192 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:29 [exec] [exec] 2) PMA_SeleniumCreateRemoveUserTest::testCreateRemoveUser [exec] Test user is not a superuser. [exec] [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBas…>:192 [exec] <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSele…>:44 [exec] [exec] [37;41m[2KFAILURES! [exec] [0m[37;41m[2KTests: 2257, Assertions: 5367, Errors: 54, Incomplete: 2, Skipped: 2. [exec] [0m[2K BUILD FAILED <http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:31: exec returned: 2 Total time: 8 minutes 1 second Build step 'Invoke Ant' marked build as failure [CHECKSTYLE] Skipping publisher since build result is FAILURE [JSLINT] Skipping publisher since build result is FAILURE [PMD] 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 #5654 [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #5654 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] #4295 bug
by Avinandan Bhattacharjee 03 Mar '14

03 Mar '14

Hi, if in bug #4295( https://sourceforge.net/p/phpmyadmin/bugs/4295/) we increase the time in usleep i think up to 60 secs then it will be fine or if we write a function that checks the size of import and if size is large then accordingly change the time. I am working in writing the function. Is the approach correct? -- Abhinandan Bhattacharjee

2 1