opencats.org

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.

For the sake of being thorough. Did you use composer in the installation process?

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

I followed suggestion from this post - http://stackoverflow.com/questions/2392 ... l-group-by

Updated my.cnf
[mysqld]
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

After MySQL restart, everything looks good so far.

Thanks,