September 2014 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Automated testing for PMA
by Joe Yin 16 Mar '15

16 Mar '15

Hi, I am Joe from Beihang University, Beijing, China. I am major in Computer Sciences. Durning my university, PMA is very popular and a lot of my classmates are using PMA for database management. I am quite interested in the project Automated testing for PMA. I have some php unit test project experience and selenium project experience. when I try to add some unit test case, I found that the Jenkins build is failed, not very stable and without code coverage report. so I can't take a look at the code coverage report. http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ http://ci.phpmyadmin.net/job/phpMyAdmin/cloverphp/ Is there other place that I can see the code coverage report? thanks, Joe Yin

3 3

[Phpmyadmin-devel] #4536 - master: import problem (PMA_String)
by Hugues Peccatte 30 Oct '14

30 Oct '14

Hi everyone, It seems that since that commit [1], the master is quite slow to import data. This seems to be linked to multi-bytes functions that are really slower compared to standard string functions. I tried several variants of this, but without a good result: instead of always using PMA_StringMB, try to detect encoding and so use PMA_StringNative when possible. To improve this, I cached the encoding, to avoid to detect it each time. See [2] (this is not totally safe, here, for the tests, I removed the mb_* detection). But the result is not as good as before… I also tried something more experimental: convert all the strings used in PMA_String to UTF-8 string and so, mb_* functions won't convert anymore. But it is not effective either. Do you have any idea about the way to improve it please? I thought about generalising the strpos to a strallpos/strposall (for redundant strpos) with an explicit encoding, not to let PHP convert each time. Thanks for your help, [1] https://github.com/phpmyadmin/phpmyadmin/commit/9b77d746aba [2] https://github.com/Tithugues/phpmyadmin/commit/ab6f493449d90e58bd4caa15740d… Hugues.

4 52

[Phpmyadmin-devel] a better sprintf js library?
by Marc Delisle 01 Oct '14

01 Oct '14

Hi, After seeing this commit [0] I expect we can improve our codebase. Can someone have a look to find (and test) a better sprintf js library (GPL-compatible)? Maybe [1] which is licensed under the so-called MIT license, which is GPL-compatible. [0] https://github.com/phpmyadmin/phpmyadmin/commit/8ad314d1f011ddbcec0718ddd48… [1] http://phpjs.org/functions/sprintf/ -- Marc Delisle (phpMyAdmin)

2 1

Re: [Phpmyadmin-devel] [Phpmyadmin-team] create ticket link from error reporting server doesn't work
by Atul Pratap Singh 30 Sep '14

30 Sep '14

On Tue, Sep 30, 2014 at 6:51 PM, Smita <kumarismita62(a)gmail.com> wrote: > Hi > > On the error reporting server, I tried to create ticket for the issue[0], > but it goes to a blank page. Most probably server is coming across some > fetal error or something. > > I confirm that ticket submission shows blank page. > Also, when I try to send js error report from within phpMyAdmin.. its not > sending . See the attached screenshot[1.png]. > > Happens on both current phpMyAdmin git master and QA_4_2. > > When I tried submitting a js error, it said report was successfully submitted, but I could not find my report on error reporting server. So it didn't work. But we have been continuously getting reports from users, the newest I could find was https://reports.phpmyadmin.net/reports/view/3576 submitted yesterday. -- Atul Pratap Singh http://blog.atulsisodia.in/

1 0

[Phpmyadmin-devel] Help You don't have permission to access /phpmyadmin
by noiredeb＠gmail.com 30 Sep '14

30 Sep '14

Hi, phpmyadmin worked to me with Authentication (with popup where it asked user and pass to access to real login of phpmyadmin). But then I added .htaccess file to /www/ folder to redirect from http://ip-my-vps/ to http://my-real-domain.com. I have also installed Cloudflare and mod_cloudflare to restore original visitor IP in my Apache logs. And now I haven't popup but only 403 error: *Forbidden* You don't have permission to access /phpmyadmin on this server. :( I have removed Cloudflare and disabled (comment out) mod_cloudflare but doesn't work..maybe it's a problem with permissions in www folder? And is better to install VirtualMin and manage MySql databases with it? Thank you vey much in advance

2 1

[Phpmyadmin-devel] PMA-Team-Question--31-Aug-2014--14-04h--MESZ
by ZweiSteinSoft 29 Sep '14

29 Sep '14

neues-Logo-2-Freunde.2014-07-13.312.png ZweiSteinSoft ZweiSteinSoft(a)ZweiSteinSoft.de ******************************************** Hello team, we just found something strange: When exporting a database with many (104) tables, in PMA 4.3.0-dev, a JS notice appers, that warns about "more than 1000 form fields", related to max_input_fields setting. The SQL dump export then fails with red warnings about missing parameters. We assume this is due to "rename tables on export" hidden inputs. Do you know this already? **************** Please because we get otherwise in trouble..! **************** Until soon! Ann + J.M. ************************************************************ --- Diese E-Mail ist frei von Viren und Malware, denn der avast! Antivirus Schutz ist aktiv. http://www.avast.com

2 2

[Phpmyadmin-devel] Build failed in Jenkins: phpMyAdmin-continuous #7711
by Jenkins Daemon 27 Sep '14

27 Sep '14

See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/7711/changes> Changes: [marc] Refactor duplicate code ------------------------------------------ Started by GitHub push by lem9 [EnvInject] - Loading node environment variables. Building in workspace <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/> > git rev-parse --is-inside-work-tree # timeout=10 Fetching changes from the remote Git repository > git config remote.origin.url git://github.com/phpmyadmin/phpmyadmin.git # timeout=10 Fetching upstream changes from git://github.com/phpmyadmin/phpmyadmin.git > git --version # timeout=10 > git fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/* > git rev-parse origin/master^{commit} # timeout=10 Checking out Revision 4314444675edb9e739fa65c2f7938be764933bca (origin/master) > git config core.sparsecheckout # timeout=10 > git checkout -f 4314444675edb9e739fa65c2f7938be764933bca > git rev-list 74709bb48e35faa012ea86ddd65b78e07171d90e # timeout=10 > git tag -a -f -m Jenkins Build #7711 jenkins-phpMyAdmin-continuous-7711 # timeout=10 [EnvInject] - Executing scripts and injecting environment variables after the SCM step. [EnvInject] - Injecting as environment variables the properties content TESTSUITE_SERVER=localhost TESTSUITE_USER=pmatest TESTSUITE_DATABASE=pmatest TESTSUITE_URL=http://ci-live.phpmyadmin.net/phpMyAdmin-continuous/workspace/ XTESTSUITE_BROWSERSTACK_USER=michaliha [EnvInject] - Variables injected successfully. [workspace] $ /bin/sh -xe /tmp/hudson2827077029343390729.sh + composer install --dev --no-interaction Warning: This development build of composer is over 30 days old. It is recommended to update it by running "/var/lib/jenkins/bin/composer self-update" to get the latest version. Loading composer repositories with package information Installing dependencies (including require-dev) from lock file Nothing to install or update Generating autoload files [workspace] $ ant -DTESTSUITE_BROWSERSTACK_KEY=**** -DTESTSUITE_PASSWORD=**** clean locales phpunit-nocoverage phpcpd phpcs phploc jshint Unable to locate tools.jar. Expected to find it in /usr/lib/jvm/java-6-openjdk-amd64/lib/tools.jar Buildfile: <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml> clean: [delete] Deleting directory <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/api> [delete] Deleting directory <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/code-browser> [delete] Deleting directory <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/coverage> [delete] Deleting directory <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/logs> [delete] Deleting directory <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/pdepend> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/api> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/code-browser> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/coverage> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/logs> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/pdepend> locales: phpunit-nocoverage: [exec] Enabling headers testing using runkit... [exec] Not supported query: SHOW ALL SLAVES STATUS [exec] PHP Warning: require_once(libraries/tbl_tracking.lib.php): failed to open stream: No such file or directory in <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/libraries/PMA_t…> on line 12 [exec] PHP Fatal error: require_once(): Failed opening required 'libraries/tbl_tracking.lib.php' (include_path='<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/vendor/phpunit/php-t…>:<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/vendor/phpunit/phpun…>:<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/vendor/phpunit/php-t…>:<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/vendor/phpunit/php-f…>:<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/vendor/phpunit/php-c…>:<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/vendor/phpunit/phpun…>:<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/vendor/symfony/yaml>:<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/vendor/phpunit/phpun…>:.:/usr/share/php:/usr/share/pear:') in <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/libraries/PMA_t…> on line 12 BUILD FAILED <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:33: exec returned: 255 Total time: 9 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 #7710 [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #7710 Recording plot data [xUnit] [INFO] - Starting to record. [xUnit] [INFO] - Processing PHPUnit-3.x (default) [xUnit] [INFO] - [PHPUnit-3.x (default)] - No 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)'. Did you enter a pattern relative to the correct directory? Did you generate the result report(s) for 'PHPUnit-3.x (default)'? [xUnit] [ERROR] - No test reports found for the metric 'PHPUnit' with the resolved pattern 'build/logs/junit.xml'. Configuration error?. [xUnit] [INFO] - Failing BUILD. [xUnit] [INFO] - There are errors when processing test results. [xUnit] [INFO] - Skipping tests recording. [xUnit] [INFO] - Stop build.

1 1

[Phpmyadmin-devel] bug #4540: table create issue
by Smita 22 Sep '14

22 Sep '14

Hi This is in reference of bug[0] in current master. While I was debugging the code to fix the issue, I found that we are trying to force the column to be primary key if auto_increment has been checked. there is this comment in Table.class.php: // Force an auto_increment field to be part of the primary key // even if user did not tick the PK box; anyone have an idea why are we doing so ? [0] https://sourceforge.net/p/phpmyadmin/bugs/4540/ Thanks and Regards - Smita

2 5

[Phpmyadmin-devel] phpMyAdmin 4.2.9 is released
by Marc Delisle 20 Sep '14

20 Sep '14

Welcome to phpMyAdmin 4.2.9, 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] problem with 4.2.8.1 ?
by Marc Delisle 19 Sep '14

19 Sep '14

Hi, it seems that my fix [0] is causing a problem [1] on some servers (including our demo server). However I am unable to reproduce the problem. There is a style element (cfs-style) that sets the whole page to display:none. Then, we are loading (conditionally) js/cross_framing_protection.js that is supposed to remove this element but on the problematic servers, this script (and other dynamic js scripts) are not loaded. I tried with $cfg['AllowThirdPartyFraming'] set to the default false and also to true. Does someone have a hint? [0] https://github.com/phpmyadmin/phpmyadmin/commit/33b39f9f1dd9a4d27856530e5ac… [1] https://sourceforge.net/p/phpmyadmin/bugs/4539/ -- Marc Delisle (phpMyAdmin)

1 1