July 2017 - Developers - lists.phpmyadmin.net

Build failed in Jenkins: error-reporting-server #160
by Jenkins Daemon 28 Sep '17

28 Sep '17

See <https://ci.phpmyadmin.net/job/error-reporting-server/160/changes> Changes: [Michal Čihař] Remove timezone from test data ------------------------------------------ Started by GitHub push by nijel [EnvInject] - Loading node environment variables. Building in workspace <https://ci.phpmyadmin.net/job/error-reporting-server/ws/> > git rev-parse --is-inside-work-tree # timeout=10 Fetching changes from the remote Git repository > git config remote.origin.url https://github.com/phpmyadmin/error-reporting-server.git # timeout=10 Fetching upstream changes from https://github.com/phpmyadmin/error-reporting-server.git > git --version # timeout=10 > git -c core.askpass=true fetch --tags --progress https://github.com/phpmyadmin/error-reporting-server.git +refs/heads/*:refs/remotes/origin/* > git rev-parse origin/master^{commit} # timeout=10 Checking out Revision f7984447f8480f815262987d75fdcebd9197110d (origin/master) > git config core.sparsecheckout # timeout=10 > git checkout -f f7984447f8480f815262987d75fdcebd9197110d > git rev-list f5c1ca48ddfc5149fb619c845ea74925c6f70ff2 # timeout=10 [workspace] $ /bin/sh -xe /tmp/hudson9192936017644220446.sh + mysql -utravis -e DROP DATABASE IF EXISTS pmaerr + mysql -utravis -e CREATE DATABASE pmaerr + composer update Loading composer repositories with package information Updating dependencies (including require-dev) Nothing to install or update Package guzzle/guzzle is abandoned, you should avoid using it. Use guzzlehttp/guzzle instead. Generating autoload files > Cake\Composer\Installer\PluginInstaller::postAutoloadDump [workspace] $ ant build Unable to locate tools.jar. Expected to find it in /usr/lib/jvm/java-7-openjdk-amd64/lib/tools.jar Buildfile: <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build.xml> clean: [delete] Deleting directory <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/api> [delete] Deleting directory <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/code-browser> [delete] Deleting directory <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/coverage> [delete] Deleting directory <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/logs> [delete] Deleting directory <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/pdepend> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/api> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/code-browser> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/coverage> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/logs> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build/pdepend> migrate: [exec] [exec] Welcome to CakePHP v3.3.4 Console [exec] --------------------------------------------------------------- [exec] App : src [exec] Path: <https://ci.phpmyadmin.net/job/error-reporting-server/ws/src/> [exec] PHP : 5.6.24-0+deb8u1 [exec] --------------------------------------------------------------- [exec] using migration path <https://ci.phpmyadmin.net/job/error-reporting-server/ws/config/Migrations> [exec] using seed path <https://ci.phpmyadmin.net/job/error-reporting-server/ws/config/Seeds> [exec] using environment default [exec] using adapter mysql [exec] using database pmaerr [exec] [exec] == 20150607191654 Initial: migrating [exec] == 20150607191654 Initial: migrated 0.3988s [exec] [exec] == 20150607192040 AddReportIdIndexToIncidents: migrating [exec] == 20150607192040 AddReportIdIndexToIncidents: migrated 0.1422s [exec] [exec] == 20150607192459 AddDevReportIndexToNotifications: migrating [exec] == 20150607192459 AddDevReportIndexToNotifications: migrated 0.1338s [exec] [exec] == 20160111023543 AddLocaleToIncidents: migrating [exec] == 20160111023543 AddLocaleToIncidents: migrated 0.1922s [exec] [exec] All Done. Took 0.8720s [exec] using migration path <https://ci.phpmyadmin.net/job/error-reporting-server/ws/config/Migrations> [exec] using seed path <https://ci.phpmyadmin.net/job/error-reporting-server/ws/config/Seeds> [exec] Writing dump file `<https://ci.phpmyadmin.net/job/error-reporting-server/ws/config/Migrations/s…...> [exec] Dump file `<https://ci.phpmyadmin.net/job/error-reporting-server/ws/config/Migrations/s…> was successfully written phpunit: [exec] PHPUnit 5.5.5 by Sebastian Bergmann and contributors. [exec] [exec] Runtime: PHP 5.6.24-0+deb8u1 [exec] Configuration: <https://ci.phpmyadmin.net/job/error-reporting-server/ws/phpunit.xml.dist> [exec] Error: No code coverage driver is available [exec] [exec] ...............F..... 21 / 21 (100%) [exec] [exec] Time: 7.22 seconds, Memory: 19.75MB [exec] [exec] There was 1 failure: [exec] [exec] 1) App\Test\TestCase\Controller\IncidentsControllerTest::testJson [exec] Failed asserting that two arrays are equal. [exec] --- Expected [exec] +++ Actual [exec] @@ @@ [exec] 'report_id' => 1 [exec] - 'created' => '2013-08-29T18:10:01' [exec] - 'modified' => '2013-08-29T18:10:01' [exec] + 'created' => '2013-08-29T18:10:01+00:00' [exec] + 'modified' => '2013-08-29T18:10:01+00:00' [exec] 'exception_type' => null [exec] ) [exec] [exec] <https://ci.phpmyadmin.net/job/error-reporting-server/ws/tests/TestCase/Cont…>:69 [exec] [exec] FAILURES! [exec] Tests: 21, Assertions: 87, Failures: 1. BUILD FAILED <https://ci.phpmyadmin.net/job/error-reporting-server/ws/build.xml>:25: exec returned: 1 Total time: 8 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] Skipping publisher since build result is FAILURE [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Skipping publisher since build result is FAILURE Publishing Clover coverage report... Clover xml file does not exist in: <https://ci.phpmyadmin.net/job/error-reporting-server/ws/> called: build/logs/clover.xml and will not be copied to: /var/lib/jenkins/jobs/error-reporting-server/builds/160/cloverphp/clover.xml Could not find 'null/build/logs/clover.xml'. Did you generate the XML report for Clover? [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/error-reporting-server/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 15

Jenkins
by Michal Čihař 22 Aug '17

22 Aug '17

Hi all [Resending as apparently it didn't reach most of you due to Gmail rejecting my mails.] For quite some time we're using Jenkins for CI. We've also added Travis during next the years. Do you think it's reasonable to still have both of them? Own Jenkins server requires some maintenance and currently doesn't integrate that well with GitHub as Travis. This could be probably addressed, but the questions is whether it's worth of it. My personal opinion is that Jenkins does not really have any benefits, so maybe it's time to drop it from our infrastructure. PS: I've disabled error-reporting-server tests there as they are apparently failing due to some timezone errors. -- Michal Čihař | https://cihar.com/ | https://weblate.org/

3 5

Fallback to default table names and database
by Manish Bisht 28 Jul '17

28 Jul '17

Hi, I am working on this feature https://github.com/phpmyadmin/phpmyadmin/issues/12887 Till now I have set default database and table names. Should I set the default control user also to `phpmyadmin` So that you only have to set the control pass in the `config.inc.php` file. I think people give the user name according to user preference so its better so set it from `config.inc.php` file but I am looking for the community feedback so that I can implement in that way. Pull Request: https://github.com/phpmyadmin/phpmyadmin/pull/13524 Thanks, Manish Bisht Email : hi(a)manishbisht.me Website : https://manishbisht.me

2 1

Re: [phpMyAdmin Developers] phpmyadmin database update
by Raghuram Vadapalli 20 Jul '17

20 Jul '17

Hi Manish, When you are dealing with configuration storage, you need to use controluser link for database interface. Otherwise, it will use current user to execute queries. Current user may not have permissions to even access phpmyadmin database. You can do this by passing $GLOBALS['controluser'] as parameter to any function operating with DBI. I am assuming that you have set up controluser and similar parameters in config.inc.php file. If it still doesn't work, please share the error you are getting. Regards, Raghuram On 17-Jul-2017 3:16 PM, "Manish Bisht" <manish.bisht490(a)gmail.com> wrote: How to use the phpmyadmin configuration database properly. I am using the following code. $GLOBALS['dbi']->selectDb('phpmyadmin'); $GLOBALS['dbi']->tryQuery('INSERT INTO `pma__progress` VALUES ("sas", "sas", 50, 100)'); Let me know if I am correct or wrong. I think I am missing something. Manish Bisht Email : hi(a)manishbisht.me Website : https://manishbisht.me On Sat, Jul 15, 2017 at 5:07 PM, Manish Bisht <manish.bisht490(a)gmail.com> wrote: > Thanks > > Just created the table by running import. > > How to save data in the tables by running queries from any file. > > Manish Bisht > Email : hi(a)manishbisht.me > Website : https://manishbisht.me > > > On Sat, Jul 15, 2017 at 5:02 PM, Raghuram Vadapalli < > raghuram.vadapalli(a)research.iiit.ac.in> wrote: > >> Hi, >> >> You have to run that sql file. Running it is part of installation process >> as far as I know. >> >> Regards, >> Raghuram >> >> >> On 15-Jul-2017 4:38 PM, "Manish Bisht" <manish.bisht490(a)gmail.com> wrote: >> >>> Hi, >>> >>> To store the import/export progress I have added one new table in >>> sql/create_tables.sql file but I can't see my new table in the phpmyadmin >>> database. How to update phpmyadmin database from that file. I guess there >>> is something that do it automatically instead of manually executing the >>> statement. >>> >>> Thanks, >>> >>> Manish Bisht >>> Email : hi(a)manishbisht.me >>> Website : https://manishbisht.me >>> >>> >>> _______________________________________________ >>> Developers mailing list >>> Developers(a)phpmyadmin.net >>> https://lists.phpmyadmin.net/mailman/listinfo/developers >>> >>> >> _______________________________________________ >> Developers mailing list >> Developers(a)phpmyadmin.net >> https://lists.phpmyadmin.net/mailman/listinfo/developers >> >> > _______________________________________________ Developers mailing list Developers(a)phpmyadmin.net https://lists.phpmyadmin.net/mailman/listinfo/developers

4 11

phpMyAdmin 4.7.3 is released
by Isaac Bennetch 20 Jul '17

20 Jul '17

Welcome to phpMyAdmin 4.7.3, a regular maintenance release containing bug fixes. A complete list of new features and bugs that have been fixed is available in the ChangeLog file or changelog.php included with this release. Notable changes since 4.7.2: * Fixed creating relations * Fixed export without back quotes * Improved handling of uploaded files with open_basedir * Fixed usage of some browser transformations * Automatically connect using SSL when server is configured for such There are many more improvements; please refer to the ChangeLog for full details. As always, downloads are available at https://www.phpmyadmin.net Thanks to our sponsors for helping to make this work possible! The phpMyAdmin Team

1 0

longtext datatype request error
by florent larose 20 Jul '17

20 Jul '17

I have a website project to develop for my company. I actually think about using PHP/ MySQL for that purpose. One of my difficulties concern phpmyadmin and is the following : I need to save a record with a datatype < LONGTEXT > or < MEDIUM TEXT > (in fact the textarea must content until 2.000.000 caracters). When I test to register I obtain a pinky messagebox from mysql server saying that it is gone away... And no record has been done. So how can I use those two datatypes for longtext records ? And is there a configuration to define for the mysql server for such requests ? Thanks for your help. [cid:image001.jpg@01D3016B.88D2A130]

1 0

Upcoming release
by Isaac Bennetch 18 Jul '17

18 Jul '17

Hi, It's nearly time for phpMyAdmin 4.7.3, especially considering that we planned a slightly earlier than usual release in [1]. As usual, let me know if you have any objections or issues that should block the release. I see nothing critical in the tracker, but will keep an eye on the milestone status. I'll probably do the release in a few days. Isaac 1 - https://github.com/phpmyadmin/phpmyadmin/issues/13465

1 0

phpmyadmin database update
by Manish Bisht 17 Jul '17

17 Jul '17

Hi, To store the import/export progress I have added one new table in sql/create_tables.sql file but I can't see my new table in the phpmyadmin database. How to update phpmyadmin database from that file. I guess there is something that do it automatically instead of manually executing the statement. Thanks, Manish Bisht Email : hi(a)manishbisht.me Website : https://manishbisht.me

3 4

IRC meeting for tomorrow
by Isaac Bennetch 12 Jul '17

12 Jul '17

Hello developers, The monthly IRC meeting is scheduled for tomorrow, but there isn't anything on the agenda. If no one has any topics to add, I suggest we skip this meeting. Isaac

4 3

phpMyAdmin organization on Codecov
by Michal Čihař 12 Jul '17

12 Jul '17

Hi all I've just moved all phpMyAdmin repos on Codecov from my personal account to phpMyAdmin organization and granted all you access to it: https://www.codacy.com/app/phpMyAdmin You should be able to tweak the "patterns" there to adjust checks to match what we need to get better automated review. -- Michal Čihař | https://cihar.com/ | https://weblate.org/

1 0