Developers March 2017

developers@phpmyadmin.net

32 participants
57 discussions

Fwd: RV: Problems with PHP to MySQL remote connection...
by Juan Jose Perez Colorado 02 Mar '17

02 Mar '17

Good, the written for the references of the remote connections to MySQL. I have this code for the connection: **** < ?php $ip = gethostbyname('server.no-ip.org'); $conexion = mysqli_connect($ip, 'web', 'server123+', 'test') or die('Error al intentar conectarse a la base de datos.'); echo 'Conectado correctemente'; mysqli_close($conexion); ?> *** I explain my essence I have my MySQL server in my office and my page with the Apache server on my Tablet (Android). Which I want to do a query from my web hosted on my tablet through a public network to my MySQL server in my office, for later the result of the query store it in MySQL of my tablet to consult this data on my tablet OFF-LINE mode. It's kind of like data sychronization. Already enable the MySQL server in the office to allow remote access also opened port 3306 on the router. But I still have this error: ***** Warning: mysqli_connect (): (HY000 / 2002): An error occurred while attempting to connect because the connected part did not respond properly after a period of time, or there was an error in the connection established Since the connected host was unable to respond. In C: \ xampp \ htdocs \ Demo \ index.php on line 10 Error while trying to connect to database. *** How can I fix it or am I doing wrong?

1 0

GSOC 2017 (Theme generator)
by shishir bondre 02 Mar '17

02 Mar '17

What will be necessary features required for the *Theme Generator* and Expectations so that i can propose a good proposal and focus on these features and generate a good idea

2 1

Build failed in Jenkins: phpMyAdmin-continuous #12777
by Jenkins Daemon 01 Mar '17

01 Mar '17

See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/12777/changes> Changes: [Michal Čihař] Fixed related field selection for native relations [Michal Čihař] Display first char field for foreign key if nothing is configured ------------------------------------------ [...truncated 23.33 KB...] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 37) 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…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 38) 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…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 39) PMA_SeleniumExportTest::testDbExport with data set #1 ('SQL', array('CREATE TABLE IF NOT EXISTS `t...table`', 'INSERT INTO `test_table` (`id...VALUES', '(1, 2);')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 40) 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…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 41) 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…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 42) PMA_SeleniumExportTest::testTableExport with data set #1 ('SQL', array('CREATE TABLE IF NOT EXISTS `t...table`', 'INSERT INTO `test_table` (`id...VALUES', '(1, 2);')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 43) 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…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 44) PMA_SeleniumImportTest::testServerImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 45) PMA_SeleniumImportTest::testDbImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 46) PMA_SeleniumImportTest::testTableImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 47) PMA_SeleniumLoginTest::testSuccessfulLogin [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 48) PMA_SeleniumLoginTest::testLoginWithWrongPassword [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 49) PMA_SeleniumNormalizationTest::testNormalizationTo1NF [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 50) PMA_SeleniumPrivilegesTest::testChangePassword [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 51) PMA_SeleniumSettingsTest::testHideDatabase [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 52) PMA_SeleniumSettingsTest::testSettingsTabsAreDisplayed [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 53) PMA_SeleniumSettingsTest::testHideLogo [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 54) PMA_SeleniumTableBrowseTest::testSortRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 55) PMA_SeleniumTableBrowseTest::testChangeRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 56) PMA_SeleniumTableBrowseTest::testChangeRecordsByDoubleClick [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 57) PMA_SeleniumTableBrowseTest::testCopyRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 58) PMA_SeleniumTableBrowseTest::testSearchRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 59) PMA_SeleniumTableBrowseTest::testDeleteRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 60) PMA_SeleniumTableCreateTest::testCreateTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 61) PMA_SeleniumTableInsertTest::testAddData [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:29 [exec] [exec] 62) PMA_SeleniumTableOperationsTest::testChangeTableOrder [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 63) PMA_SeleniumTableOperationsTest::testMoveTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 64) PMA_SeleniumTableOperationsTest::testRenameTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 65) PMA_SeleniumTableOperationsTest::testCopyTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 66) PMA_SeleniumTableOperationsTest::testTruncateTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 67) PMA_SeleniumTableOperationsTest::testDropTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 68) PMA_SeleniumTableStructureTest::testAddColumn [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 69) PMA_SeleniumTableStructureTest::testChangeColumn [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 70) PMA_SeleniumTableStructureTest::testDropColumns [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 71) PMA_SeleniumTrackingTest::testTrackingData [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 72) PMA_SeleniumTrackingTest::testDeactivateTracking [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 73) PMA_SeleniumTrackingTest::testDropTracking [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 74) PMA_SeleniumTrackingTest::testStructureSnapshot [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 75) PMA_SeleniumXSSTest::testQueryTabWithNullValue [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] FAILURES! [exec] Tests: 2274, Assertions: 6205, Errors: 6, Skipped: 75, Incomplete: 5, Risky: 1. BUILD FAILED <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:33: exec returned: 2 Total time: 15 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 [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 #12776 [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #12776 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] - Check 'Failed Tests' threshold. [xUnit] [INFO] - Check 'Skipped Tests' threshold. [xUnit] [INFO] - Setting the build status to FAILURE [xUnit] [INFO] - Stopping recording.

1 1

Intresting Candidate - Help needed.
by Jees K Denny 01 Mar '17

01 Mar '17

Hai, I am Jees K Denny, familiar with web designing and development. I am already contributed one simple theme named as Pmaterial in phpmyadmin repository. I am very interested to participate in GSOC. I don't know where to start. I read lot about this. is this too late to participate in GSOC? i checked several ideas already here. https://github.com/phpmyadmin/phpmyadmin/wiki/GSoC_2017_ideas_list

2 5

New feature
by ashish kakar 01 Mar '17

01 Mar '17

Hi all. I recently had an idea that I would like to implement in phpmyadmin. In the development docs it is mentioned that ideas about new features should be discussed on the list before implementing it. I was working on MySQL (with phpmyadmin) in my last job and I faced some problems. Basically when I entered an incorrect query it led to data loss and there was no way to recover it. I searched online and there were a few people like me who also experienced similar problems. Recovery is only possible when there is data backup and only to the extent of the frequency of the backups. Having read about binary logs in MySQL I came up with the idea to implement a solution that is able to recover the database by undoing only the offending queries. However, to implement this it would be necessary to have a web interface to view and select the statements that need to be undone. I felt that implementing it as a part of phpmyadmin would be better than implementing a standalone solution because it would gel very well with it. Also I want this project to be open source. I don't have a lot of experience so I don't know if this is a good idea or if there is a better approach to solve this. I would very much like your suggestions on this. Thanks, Ashish Get Outlook for Android<https://aka.ms/ghei36>

3 3

Re: [phpMyAdmin Developers] Developers Digest, Vol 20, Issue 16
by chintan zaveri 01 Mar '17

01 Mar '17

Hello everyone, I am Chintan Zaveri here. I am pursuing my bachelors in Computer Science. I am planning to work on Enhancement features collection B or Refactoring code towards MVC. Kindly let me know the mentor for the later project. Looking forward to amazing coding summer. On 28 Feb 2017 16:30, <developers-request(a)phpmyadmin.net> wrote: Send Developers mailing list submissions to developers(a)phpmyadmin.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.phpmyadmin.net/mailman/listinfo/developers or, via email, send a message with subject or body 'help' to developers-request(a)phpmyadmin.net You can reach the person managing the list at developers-owner(a)phpmyadmin.net When replying, please edit your Subject line so it is more specific than "Re: Contents of Developers digest..." Today's Topics: 1. Regarding GSoC '17 (Raghuram Vadapalli) 2. Re: Intresting Candidate - Help needed. (Jees K Denny) ---------------------------------------------------------------------- Message: 1 Date: Tue, 28 Feb 2017 09:26:13 +0000 From: Raghuram Vadapalli <raghuram.vadapalli(a)research.iiit.ac.in> To: Developer discussion for phpMyAdmin <developers(a)phpmyadmin.net> Subject: [phpMyAdmin Developers] Regarding GSoC '17 Message-ID: <CAHHB_vt3HUWtJcBS=rJvAPJWmNLXUumSod4tJ827wFohngtdWQ(a)mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hi all, Congratulations on getting selected! I went throught the project ideas page. I find the 'Enhancements collection A' project interesting. I have submitted a patch a long time ago for https://github.com/phpmyadmin/phpmyadmin/issues/6267 . Since it is advised not to work on actual project right now, I will leave it at that. [1] are my past contributions. I would like to discuss further regarding this project. [1] https://github.com/phpmyadmin/phpmyadmin/pulls?utf8=%E2%9C% 93&q=is%3Apr%20author%3AAchilles-96%20is%3Amerged Regards, Raghuram

2 1

GSoC 2017
by Anamika Das 01 Mar '17

01 Mar '17

Warm Greetings ! I am Anamika Abhoypada Das, doing my master's in Computer Science with Specialisation in Information Security at BITS-Pilani Hyderabad Campus, India. My proficiency revolves around the areas of C/C++, Javascript, C#, php. I have worked on application development with Microsoft. I have seen the project ideas on your organization page- phpMyAdmin. I would love to contribute to the GSoC 2017 by being a part of the project*- **New UI for Multi-table query generator *. It would be great if you could mentor me to further understand the intricacies of the project. I may not have the required skill sets but motivated to gain it. If there is any dedicated task then I would like to get the details. Looking forward for your reply, Regards, Anamika Das

2 1

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers March 2017