August 2014 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Skipping Travis CI & Scrutinizer CI builds for weblate pushes
by Chirayu Chiripal 12 Aug '14

12 Aug '14

Hi, I was just wondering that do we really need Travis CI builds for the weblate translation changes as it does not affect test cases. So why not just ignore builds for those commits and avoid wastage of resources and keep them available for PR? As weblate changes are so often it is just an overhead on Travis and Scrutinizer causing delays for other PR's and commits unnecessarily. To skip a build on Travis CI & Scrutinizer CI we can add "[ci skip]" or "[skip ci]" in the commit message (see [1] & [2]). Is it possible to do so? [1]: http://docs.travis-ci.com/user/how-to-skip-a-build/ [2]: https://scrutinizer-ci.com/docs/guides/skipping_a_build_via_commit_message -- Regards, Chirayu Chiripal phpMyAdmin Intern - Google Summer of Code 2014 https://chirayuchiripal.wordpress.com/

2 8

[Phpmyadmin-devel] Connect with non-existing user
by Hugues Peccatte 10 Aug '14

10 Aug '14

Hi, Today, while connecting to my pMA (on master), I did a mistake in my user name and pressed enter (without a password). Then I was connected and could only see "information_schema", but not send queries in it. I tried other user names and as I have no password, I can connect. Is it the desired behaviour please? Mustn't I have a connection error? I'll create a ticket if this is not right. Thanks, Hugues.

2 2

[Phpmyadmin-devel] Build failed in Jenkins: phpMyAdmin-continuous #7431
by Jenkins Daemon 10 Aug '14

10 Aug '14

See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/7431/changes> Changes: [hugues.peccatte] Coding style modifications. ------------------------------------------ [...truncated 235 lines...] [exec] [exec] 19) PMA_SeleniumExportTest::testServerImport with data set #2 ('JSON', array('[{"id":"1","val":"2"}]')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 20) PMA_SeleniumExportTest::testDbExport with data set #0 ('CSV', array('"1","2"')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 21) PMA_SeleniumExportTest::testDbExport with data set #1 ('SQL', array('CREATE TABLE IF NOT EXISTS `test_table`', 'INSERT INTO `test_table` (`id`, `val`) VALUES', '(1, 2);')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 22) PMA_SeleniumExportTest::testDbExport with data set #2 ('JSON', array('[{"id":"1","val":"2"}]')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 23) PMA_SeleniumExportTest::testTableExport with data set #0 ('CSV', array('"1","2"')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 24) PMA_SeleniumExportTest::testTableExport with data set #1 ('SQL', array('CREATE TABLE IF NOT EXISTS `test_table`', 'INSERT INTO `test_table` (`id`, `val`) VALUES', '(1, 2);')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 25) PMA_SeleniumExportTest::testTableExport with data set #2 ('JSON', array('[{"id":"1","val":"2"}]')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 26) PMA_SeleniumImportTest::testServerImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 27) PMA_SeleniumImportTest::testDbImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 28) PMA_SeleniumImportTest::testTableImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 29) PMA_SeleniumLoginTest::testSuccessfulLogin [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 30) PMA_SeleniumLoginTest::testLoginWithWrongPassword [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 31) PMA_SeleniumNormalizationTest::testNormalizationTo1NF [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 32) PMA_SeleniumPrivilegesTest::testChangePassword [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 33) PMA_SeleniumSettingsTest::testHideDatabase [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 34) PMA_SeleniumSettingsTest::testSettingsTabsAreDisplayed [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 35) PMA_SeleniumSettingsTest::testHideLogo [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 36) PMA_SeleniumTableBrowseTest::testSortRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 37) PMA_SeleniumTableBrowseTest::testChangeRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 38) PMA_SeleniumTableBrowseTest::testChangeRecordsByDoubleClick [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 39) PMA_SeleniumTableBrowseTest::testCopyRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 40) PMA_SeleniumTableBrowseTest::testSearchRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 41) PMA_SeleniumTableBrowseTest::testDeleteRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 42) PMA_SeleniumTableCreateTest::testCreateTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 43) PMA_SeleniumTableInsertTest::testAddData [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:29 [exec] [exec] 44) PMA_SeleniumTableOperationsTest::testChangeTableOrder [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 45) PMA_SeleniumTableOperationsTest::testMoveTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 46) PMA_SeleniumTableOperationsTest::testRenameTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 47) PMA_SeleniumTableOperationsTest::testCopyTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 48) PMA_SeleniumTableOperationsTest::testTruncateTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 49) PMA_SeleniumTableOperationsTest::testDropTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 50) PMA_SeleniumTableStructureTest::testAddColumn [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 51) PMA_SeleniumTableStructureTest::testChangeColumn [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 52) PMA_SeleniumTableStructureTest::testDropColumns [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 53) PMA_SeleniumTrackingTest::testTrackingData [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 54) PMA_SeleniumTrackingTest::testDeactivateTracking [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 55) PMA_SeleniumTrackingTest::testDropTracking [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 56) PMA_SeleniumTrackingTest::testStructureSnapshot [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 57) PMA_SeleniumXSSTest::testQueryTabWithNullValue [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [37;41m [0m [exec] [37;41mFAILURES! [0m [exec] [37;41mTests: 2378, Assertions: 5591, Errors: 1, Incomplete: 5, Skipped: 57.[0m BUILD FAILED <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:33: exec returned: 2 Total time: 25 seconds 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 #7430 [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #7430 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 '<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/'> for the testing framework 'PHPUnit-3.x (default)'. [xUnit] [INFO] - Converting '<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/logs/junit.xml'> . [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 2

[Phpmyadmin-devel] RFE #1123
by Ashutosh Dhundhara 08 Aug '14

08 Aug '14

Hi, I was starting to work on RFE #1123 <https://sourceforge.net/p/phpmyadmin/feature-requests/1123/> (Zeroconf PMA tables support). Is it something like enabling/disabling the PMA configuration storage feature through UI with default table names? Also, automatically create these tables when user has enabled this feature through UI? -- Ashutosh Dhundhara

3 6

[Phpmyadmin-devel] question about the phpmyadmin
by xie 07 Aug '14

07 Aug '14

I login phpmyadmin when I want to see databases,but if I keep seeing the page over 10 seconds without operation,it will prompt the "token is overdue",Do anyone know how to configure the time more longer?

2 1

[Phpmyadmin-devel] Refactoring: designer/schema - Plugin like architecture
by Bimal Yashodha 05 Aug '14

05 Aug '14

Hi, As I'm doing my final task, which is to remove code duplications and OOping the code, I came across with a possible idea to re-factor schema exporting as plugins. That is, as done in "data exporting" with various formats(SQL, CSV, XML, PDF) the existing schema exporting funcationality would be implemented as plugins, while preserving OOP concepts. So this would help in future in such a way, as the modularity and portability is enhanced, new schema exporting method can be integrated easily.

2 2

[Phpmyadmin-devel] RFE #1491
by Ashutosh Dhundhara 04 Aug '14

04 Aug '14

Hi all, I was looking into RFE #1491 <http://sourceforge.net/p/phpmyadmin/feature-requests/1491/> (Support InnoDB for database Query by example). If I am not wrong, is the concept of displaying the 'LEFT JOIN' is something like as discussed in the case below: Lets say I have two tables: CREATE TABLE `product` ( `id` int(11) NOT NULL, `price` decimal(10,0) DEFAULT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `product_order` ( `product_id` int(11) NOT NULL, `customer_id` int(11) NOT NULL, KEY `product_category` (`product_id`), KEY `customer_id` (`customer_id`), CONSTRAINT `product_order_ibfk_4` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ) Now in QBE interface, when I will select `product_order`.`product_id` in first column drop-down and `product`.`id` in second column drop-down, I should get the following result: FROM `db_name`.`product_order` LEFT JOIN `db_name`.`product` ON `product_order`.`product_id` = `product`.`id` In general, 'LEFT JOIN' with foreign table and ON condition between master column and foreign column. Am I getting it right? -- Ashutosh Dhundhara

2 7

[Phpmyadmin-devel] Improved notification when attempting to insert invalid data.
by Chirayu Chiripal 01 Aug '14

01 Aug '14

Hi, My GSoC task for this week is "Improved notification when attempting to insert invalid data". I would like to know at which places validation is required to be done? -- Regards, Chirayu Chiripal phpMyAdmin Intern - Google Summer of Code 2014 https://chirayuchiripal.wordpress.com/

2 6