Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
#2977
Take 2
Ubuntu 16.04, new server, this time I followed steps mentioned here - http://opencats-documentation.readthedo ... 16.04.html

No issues in installation and able to login without any issues. When I click Job orders, Candidates and Companies, I get the following error

MySQL Query Failed: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'opencats.attachment.attachment_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

I tried installing using single script and I got stuck with error mentioned here viewtopic.php?f=4&t=846, and second time I tried manual setup and got above error.

Let me know how I can fix it, appreciate your help.
#2982
Yes, I did and it installed all without any error. Here is console output.

sudo composer install
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
- Installing behat/gherkin (v4.4.4)
Downloading: 100%

- Installing symfony/filesystem (v3.0.9)
Downloading: 100%

- Installing symfony/config (v2.8.11)
Downloading: 100%

- Installing symfony/css-selector (v3.1.4)
Downloading: 100%

- Installing behat/mink (v1.7.1)
Downloading: 100%

- Installing symfony/yaml (v2.8.11)
Downloading: 100%

- Installing symfony/polyfill-mbstring (v1.2.0)
Downloading: 100%

- Installing symfony/translation (v2.8.11)
Downloading: 100%

- Installing symfony/event-dispatcher (v2.8.11)
Downloading: 100%

- Installing symfony/dependency-injection (v2.8.11)
Downloading: 100%

- Installing symfony/console (v2.8.11)
Downloading: 100%

- Installing symfony/polyfill-apcu (v1.2.0)
Downloading: 100%

- Installing symfony/class-loader (v2.8.11)
Downloading: 100%

- Installing behat/transliterator (v1.1.0)
Downloading: 100%

- Installing behat/behat (v3.0.15)
Downloading: 100%

- Installing behat/mink-extension (dev-master 694c9ee)
Cloning 694c9ee490aa8c29e6e9224ca7269e41ad31362b

- Installing symfony/dom-crawler (v3.1.4)
Downloading: 100%

- Installing symfony/browser-kit (v3.1.4)
Downloading: 100%

- Installing psr/http-message (1.0.1)
Downloading: 100%

- Installing guzzlehttp/psr7 (1.3.1)
Downloading: 100%

- Installing guzzlehttp/promises (1.2.0)
Downloading: 100%

- Installing guzzlehttp/guzzle (6.2.1)
Downloading: 100%

- Installing fabpot/goutte (v3.1.2)
Downloading: 100%

- Installing behat/mink-browserkit-driver (v1.3.2)
Downloading: 100%

- Installing behat/mink-goutte-driver (v1.2.1)
Downloading: 100%

- Installing instaclick/php-webdriver (1.4.3)
Downloading: 100%

- Installing behat/mink-selenium2-driver (v1.3.1)
Downloading: 100%

- Installing webmozart/assert (1.1.0)
Downloading: 100%

- Installing phpdocumentor/reflection-common (1.0)
Downloading: 100%

- Installing phpdocumentor/type-resolver (0.2)
Downloading: 100%

- Installing phpdocumentor/reflection-docblock (3.1.1)
Downloading: 100%

- Installing phpunit/php-token-stream (1.4.8)
Downloading: 100%

- Installing sebastian/version (2.0.0)
Downloading: 100%

- Installing sebastian/resource-operations (1.0.0)
Downloading: 100%

- Installing sebastian/recursion-context (1.0.2)
Downloading: 100%

- Installing sebastian/object-enumerator (1.0.0)
Downloading: 100%

- Installing sebastian/global-state (1.1.1)
Downloading: 100%

- Installing sebastian/exporter (1.2.2)
Downloading: 100%

- Installing sebastian/environment (1.3.8)
Downloading: 100%

- Installing sebastian/diff (1.4.1)
Downloading: 100%

- Installing sebastian/comparator (1.2.0)
Downloading: 100%

- Installing phpunit/php-text-template (1.2.1)
Downloading: 100%

- Installing doctrine/instantiator (1.0.5)
Downloading: 100%

- Installing phpunit/phpunit-mock-objects (3.2.7)
Downloading: 100%

- Installing phpunit/php-timer (1.0.8)
Downloading: 100%

- Installing phpunit/php-file-iterator (1.4.1)
Downloading: 100%

- Installing sebastian/code-unit-reverse-lookup (1.0.0)
Downloading: 100%

- Installing phpunit/php-code-coverage (4.0.1)
Downloading: 100%

- Installing phpspec/prophecy (v1.6.1)
Downloading: 100%

- Installing myclabs/deep-copy (1.5.4)
Downloading: 100%

- Installing phpunit/phpunit (5.4.8)
Downloading: 100%

behat/mink suggests installing behat/mink-zombie-driver (fast and JS-enabled headless driver for any app (requires node.js))
symfony/translation suggests installing psr/log (To use logging capability in translator)
symfony/event-dispatcher suggests installing symfony/http-kernel ()
symfony/dependency-injection suggests installing symfony/expression-language (For using expressions in service container configuration)
symfony/dependency-injection suggests installing symfony/proxy-manager-bridge (Generate service proxies to lazy load them)
symfony/console suggests installing psr/log (For using the console logger)
symfony/console suggests installing symfony/process ()
behat/behat suggests installing behat/symfony2-extension (for integration with Symfony2 web framework)
behat/behat suggests installing behat/yii-extension (for integration with Yii web framework)
symfony/browser-kit suggests installing symfony/process ()
sebastian/global-state suggests installing ext-uopz (*)
phpunit/php-code-coverage suggests installing ext-xdebug (>=2.4.0)
phpunit/phpunit suggests installing phpunit/php-invoker (~1.1)
Generating autoload files

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me