- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Field Value Separators in Translation Strings
by Dhananjay Nakrani 27 Jun '14

27 Jun '14

Hi Everyone, I was looking into the translations of PMA. On the translation server, I found strings with colon (:) in them. For example see code at [0]. Shouldn't colon be outside '__()'function? That would keep all the field-value separators like colon away from the translation strings. [0]: https://github.com/phpmyadmin/phpmyadmin/blob/master/index.php#L266 Regards, Dhananjay Nakrani.

3 3

[Phpmyadmin-devel] phpMyAdmin 4.2.5 is released
by Marc Delisle 26 Jun '14

26 Jun '14

Welcome to phpMyAdmin 4.2.5, a bugfix release. Details will appear on http://phpmyadmin.net. You can also visit https://sourceforge.net/projects/phpmyadmin/files to download. The phpMyAdmin team

1 0

[Phpmyadmin-devel] Possible bug in Add index
by Smita 26 Jun '14

26 Jun '14

Hi, When we open up "add index" dialog from tbl_structure page with number of columns more than 8 or something then the dialog's height comes up is too big to be able to see the footer for submitting the form and for adding any more columns. checkout the attached screen shot. I think the dialog content should be scrollable after certain height. need to set max-height. Thanks and Regards - Smita .

2 2

[Phpmyadmin-devel] about the mcrypt requirement
by Marc Delisle 26 Jun '14

26 Jun '14

Hi, in the doc, we mention that mcrypt is required on 64-bit servers. I believe it's no longer true since we replaced the blowfish PHP-based library with phpseclib. Therefore I would like, for the upcoming 4.2.5 release, to remove this requirement in the doc, and even the mcrypt warning; on my 64-bit laptop, I see no difference in page loading without mcrypt. Comments? -- Marc Delisle | phpMyAdmin

3 4

[Phpmyadmin-devel] About the change in initialization vector (IV)
by Marc Delisle 25 Jun '14

25 Jun '14

Hi, it seems that [0] which was done on QA_4_2 and released in 4.2.4, is causing problems to some users [1]. Maybe this kind of change should be postponed to 4.3 and reverted for 4.2.5? [0] https://github.com/phpmyadmin/phpmyadmin/commit/7cba81de271d62bdf93ded75987… [1] https://sourceforge.net/p/phpmyadmin/bugs/4469 -- Marc Delisle | phpMyAdmin

2 3

[Phpmyadmin-devel] Create database with export multiple databases
by Isaac Bennetch 24 Jun '14

24 Jun '14

It seems that current behavior is that, by default, when exporting multiple databases at once the CREATE DATABASE statement is omitted. I suppose it's possible that someone would want to export multiple tables for import in to only one database, but that's certainly not what I would think is normally expected behavior. I'd like to discuss how we can make this better. I propose that we make the default $cfg['Export']['sql_create_database'] = true; (it's currently false) in all cases, but I don't recall from the initial commit 77e67c3f whether there was a reason this was false by default. Any comments on this idea?

2 1

[Phpmyadmin-devel] Build failed in Jenkins: phpMyAdmin-continuous #6810
by Jenkins Daemon 24 Jun '14

24 Jun '14

See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/6810/changes> Changes: [phpMyAdmin] Fix coding style [weblate] Translated using Weblate (Azerbaijani) [weblate] Translated using Weblate (Korean) [weblate] Translated using Weblate (Norwegian Bokmål) [phpMyAdmin] Fix failing tests [hugues.peccatte] Update ChangeLog. [phpMyAdmin] Fix coding style [weblate] Translated using Weblate (Azerbaijani) [hugues.peccatte] Add missing include. (bug #4463) [weblate] Translated using Weblate (Azerbaijani) [weblate] Translated using Weblate (Estonian) [weblate] Translated using Weblate (Portuguese (Brazil)) ------------------------------------------ [...truncated 229 lines...] [exec] 18) PMA_SeleniumExportTest::testServerImport 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] 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_SeleniumPrivilegesTest::testChangePassword [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 32) PMA_SeleniumSettingsTest::testHideDatabase [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 33) PMA_SeleniumSettingsTest::testSettingsTabsAreDisplayed [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 34) PMA_SeleniumSettingsTest::testHideLogo [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 35) 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] 36) 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] 37) 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] 38) 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] 39) 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] 40) PMA_SeleniumTableBrowseTest::testDeleteRecords [exec] Selenium testing not configured. [exec] [exec] /var/lib/jenkins/jobs/php [exec] MyAdmin-continuous/workspace/test/selenium/TestBase.php:163 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 41) PMA_SeleniumTableCreateTest::testCreateTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:163 [exec] [exec] 42) 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] 43) 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] 44) 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] 45) 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] 46) 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] 47) 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] 48) 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] 49) 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] 50) 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] 51) 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] 52) 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] 53) 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] 54) 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] 55) 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] 56) 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: 2297, Assertions: 5326, Failures: 1, Incomplete: 5, Skipped: 56.[0m BUILD FAILED <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:33: exec returned: 1 Total time: 28 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 #6809 [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #6809 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 5

[Phpmyadmin-devel] Need suggestions: starting automated Normalization to 1NF
by Smita 23 Jun '14

23 Jun '14

Hi I have started working on automated normalization. I have written the detailed work flow for normalizing the relation to 1NF in my blog[1], I need your feedback/suggestions on the same. Just needed to know if the approach looks good. Also for user interface, I'm thinking to keep options on db_operations and tbl_operations page will be appropriate. The options will have 1. Normalize to 1NF, 2. Normalize to 2NF (1NF + 2NF), 3. Normalize to 3NF (1NF+2NF+3NF). On select of an option, user shall be presented a dialogue which will assist in normalizing the relation. Is it fine ? or should we keep these options somewhere else ? [1] http://smita786.blogspot.in/2014/06/gsoc14-coding-week-5-automated.html Thanks and Regards - Smita

2 4

[Phpmyadmin-devel] exporting files - Designer/schema integration
by Bimal Yashodha 22 Jun '14

22 Jun '14

Hi, I'm currently integrating "exporting relational schema" functionalities into the designer. And in "Operations > Edit or export relational schema", I have moved the "exporting files" functionality in to a popup dialog box in the designer. So the process is working through ajax calls. But my problem is, although the header parameters are set correctly, downloading is not working. 'Content-Description: File Transfer' 'Content-Disposition: attachment; filename='myfile.pdf' 'Content-Type: application/pdf' Should I get the file as JSON encoded and the process it at the browser or, have I missed something? -- I'm using the function calls initialized from the schema_export.php with minor changes. cheers, Bimal.

2 3

[Phpmyadmin-devel] RFE #654: Range Search Capability.
by Ashutosh Dhundhara 22 Jun '14

22 Jun '14

Hi, I was working on RFE #654 (Range Search Capability on search page). I was thinking to bind a 'click' event on 'BETWEEN' keyword in 'Operator' select list when column datatype is 'Numeric' and 'Date'. This will further open a dialog box to select a range of values for that particular column (Minimum and Maximum value). Will this be a good approach for this feature request? -- Ashutosh Dhundhara

2 2