Hello,
When I check "Disable foreign key" option while importing, it doesn't seem
working correctly.
I tried `fk_test_import.sql` (attached) on DB created by `fk_test.sql`
(attached). And it always gives "a foreign key constraint fails" error.
I'm not sure if this is a bug or I am doing something wrong. Anyone?
Thanks.
--
Nisarg Jhaveri
નિસર્ગ ઝવેરી
On Sun, May 24, 2015 at 10:08 PM, 章浩 <jason.daurus(a)gmail.com> wrote:
> Hi Singh,
>
> Recently I am working on templates of `tbl_column_definitions.lib.php`,
> and I need some help from you.
>
> I met a problem on the unit test:
>
> [image: Inline image 1]
>
> And here is the test code raise the problem:
>
> [image: Inline image 2]
>
> The failure is caused by the format of HTML, which will not cause any side
> effects for user interface. So what should I do to handle this kind of
> error? Merging spaces in a HTML tag may help, but it seems difficult to
> distinguish a special case:
>
> *Before trimming:*
>
> <script>someScript(); //
>
> anotherScript();</script>
>
> *After trimming:*
>
> <script>someScript(); // anotherScript();</script>
>
> It's obvious that it will cause some Javascripts being commented. Then I
> figured out a second solution: modify the test scripts and let it pass.
> This is a "palliative" solution, we have to spend plenty of time to fix
> this kind of problems.
>
> Maybe we could use a more effective way to test front-end components
> (templates, pages, etc) in the future, though I haven’t figure out how to
> achieve this goal yet.
>
> Could you give me some suggestions about this?
>
Hi devs,
I share Jason's confusion above and doubt the usefulness of unit tests that
are just asserting for static HTML strings in a dynamic HTML output and one
that will keep evolving with course of development.
Also I wonder about its importance as we move to template system[0],
opinions are welcome for possible better ways of doing it. Maybe we can
just test for valid input data getting used by the template and some
important key words but not HTML tags[1]
[0] https://github.com/phpmyadmin/phpmyadmin/pull/1642#discussion_r28551465
[1] http://stackoverflow.com/questions/3429218/unit-tests-for-html-output
Best regards,
>
> Jason
>
>
>
--
Atul Pratap Singh
See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/9627/changes>
Changes:
[Madhura Jayaratne] Do not use configurations TextareaCols and TextareaRows of their
------------------------------------------
Started by GitHub push by madhuracj
[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 -c core.askpass=true 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 72b1826c25e0ed033d835d10f1aaf1ef55ec7df7 (origin/master)
> git config core.sparsecheckout # timeout=10
> git checkout -f 72b1826c25e0ed033d835d10f1aaf1ef55ec7df7
> git rev-list 5b47c080e2457e2f2cea664c8509c563ad4edcb0 # timeout=10
> git tag -a -f -m Jenkins Build #9627 jenkins-phpMyAdmin-continuous-9627 # 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/hudson207730508922653992.sh
+ composer install --dev --no-interaction
You are using the deprecated option "dev". Dev packages are installed by default now.
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Nothing to install or update
Generating autoload files
[workspace] $ ant ******** ******** clean locales phpunit-nocoverage phpcpd phpcs phploc jshint jshint-checkstyle
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/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:
[exec] po/ru.po:697: a format specification for argument 1 doesn't exist in 'msgstr'
[exec] msgfmt: found 1 fatal error
[exec] tput: No value for $TERM and no -T specified
[exec] Error when compiling po/ru.po
[exec] tput: No value for $TERM and no -T specified
BUILD FAILED
<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:148: 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
[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 #9625
[TASKS] Skipping publisher since build result is FAILURE
[ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #9625
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.
Hi,
can someone reproduce this under Windows 7?
With Chrome, Firefox and IE, I try to use the ctrl/click, shift/click
and alt/click actions on a column header to modify the sort, to no
avail. Instead, for example a new tab is opened when using ctrl/click.
All is fine with Chrome on Linux.
--
Marc Delisle | phpMyAdmin
Hi Nisarg,
In Settings > Features > Text fields, there are some settings that
should IMO be also available as a page-related setting.
As an example, "CHAR columns editing" controls how to edit (via the edit
link) a CHAR or VARCHAR (input field or textarea). So it should be
available on the Insert/Edit page.
--
Marc Delisle (phpMyAdmin)
Hi all
I've recently Rollbar <https://rollbar.com/> and started to use it for
Weblate <http://weblate.org/>. It does basically what our error
reporting server does, but it provides generic solution for any
platform.
They even have public demo, so you can try it:
https://rollbar.com/demo/demo/
I think it can be great source of inspiration how error reporting
server could work.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
See <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/217/changes>
Changes:
[Madhura Jayaratne] #4912 "Highlight pointer" and "Row marker" doesn't work properly
[Madhura Jayaratne] ChangeLog entry for bug #4912
------------------------------------------
Started by GitHub push by madhuracj
[EnvInject] - Loading node environment variables.
Building in workspace <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/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 -c core.askpass=true fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/*
> git rev-parse origin/QA_4_4^{commit} # timeout=10
Checking out Revision 0ac438a081de1edd9a6255a0d2148cde07e3770b (origin/QA_4_4)
> git config core.sparsecheckout # timeout=10
> git checkout -f 0ac438a081de1edd9a6255a0d2148cde07e3770b
> git rev-list ac2f9acaa351cb2776e2fb7f70e45ac8d52418db # timeout=10
[workspace] $ /bin/sh -xe /tmp/hudson3470184405124895290.sh
+ composer install --dev --no-interaction
You are using the deprecated option "dev". Dev packages are installed by default now.
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Nothing to install or update
Generating autoload files
+ ./scripts/generate-mo --quiet
po/pt.po:697: a format specification for argument 1 doesn't exist in 'msgstr'
msgfmt: found 1 fatal error
tput: No value for $TERM and no -T specified
Error when compiling po/pt.po
tput: No value for $TERM and no -T specified
Build step 'Execute shell' 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] Parsing 1 file in <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/>
[DRY] Successfully parsed file <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/logs/pmd-cpd.xml> with 14 unique warnings and 0 duplicates.
[DRY] Computing warning deltas based on reference build #214
[TASKS] Skipping publisher since build result is FAILURE
[ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #214
Recording plot data
Publishing Clover coverage report...
Clover xml file does not exist in: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/> called: build/logs/clover.xml and will not be copied to: /var/lib/jenkins/jobs/phpMyAdmin-4.4/builds/217/cloverphp/clover.xml
Could not find 'build/coverage/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/phpMyAdmin-4.4/ws/'> for the testing framework 'PHPUnit-3.x (default)'.
[xUnit] [ERROR] - Test reports were found but not all of them are new. Did all the tests run?
* <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/logs/junit.xml> is 1 day 9 hr old
[xUnit] [INFO] - Failing BUILD.
[xUnit] [INFO] - There are errors when processing test results.
[xUnit] [INFO] - Skipping tests recording.
[xUnit] [INFO] - Stop build.
[JDepend] JDepend plugin is ready
[JDepend] Found 2402 classes in 318 packages
See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/9587/changes>
Changes:
[Madhura Jayaratne] Simplify
------------------------------------------
Started by GitHub push by madhuracj
[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 -c core.askpass=true 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 76f1f58102b2414c4684c3954a7f129b4cd1f24e (origin/master)
> git config core.sparsecheckout # timeout=10
> git checkout -f 76f1f58102b2414c4684c3954a7f129b4cd1f24e
> git rev-list 71b3a7270a55f22fea7ecc6ed9c078a423da2453 # timeout=10
> git tag -a -f -m Jenkins Build #9587 jenkins-phpMyAdmin-continuous-9587 # 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/hudson6569974653612964854.sh
+ composer install --dev --no-interaction
You are using the deprecated option "dev". Dev packages are installed by default now.
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Nothing to install or update
Generating autoload files
[workspace] $ ant ******** ******** clean locales phpunit-nocoverage phpcpd phpcs phploc jshint jshint-checkstyle
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/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:
[exec] po/pt.po:704: a format specification for argument 1 doesn't exist in 'msgstr'
[exec] msgfmt: found 1 fatal error
[exec] tput: No value for $TERM and no -T specified
[exec] Error when compiling po/pt.po
[exec] tput: No value for $TERM and no -T specified
BUILD FAILED
<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:148: exec returned: 1
Total time: 7 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 #9585
[TASKS] Skipping publisher since build result is FAILURE
[ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #9585
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.