Skip to content

Only full_group_by issue in detailed receivings report #2967

@saurabh261187

Description

@saurabh261187

Background information

IMPORTANT: If you choose to ignore this issue report template, your issue will be closed as we cannot help without the requested information.

Please make sure you tick (add an x between the square brackets with no spaces) the following check boxes:

  • [] Reporting an issue of an unmodified OSPOS installation
  • [] Checked open and closed issues and no similar issue was already reported (please make sure you searched!)
  • [] Read README, WHATS_NEW, INSTALL.md and UPGRADE
  • [] Read the FAQ for any known install and/or upgrade gotchas (in specific PHP extensions installed)
  • [] Read the wiki
  • [] Executed any database upgrade scripts if an upgrade pre 3.0.0 (e.g. database/2.4_to_3.0.sql)
  • [] Aware the installation code is in bintray (see README), and GitHub master is for developers only and therefore not complete nor stable

Installation information

  • OSPOS version is: 3.3.2 , the last stable version released
  • OSPOS git commit hash is: opensourcepos.20200903075833.3.3.2.bb309c.zip
  • PHP version is: 7.2.24
  • MySQL or MariaDB version is: 5.7.31-0ubuntu0.18.04.1
  • OS and version is: Ubuntu Linux 18.04.4
  • WebServer is: Apache 2.4.29
  • Selected language is: English
  • (If applicable) Docker installation:
  • (If applicable) Installation package for the LAMP/LEMP stack is: Virtualmin

Issue / Bug / Question / New Feature

Whenever I am trying to generate Receiving report, a HTTP 500 error is coming up. I ran the installation in development mode and this came up :

image

I changed the MYSQL sql_mode to not use only_full_group_by , and removed it. Post that the receiving ran fine, but it may create dependencies on other softwares since I am using a shared server. Is there no way to run the installation out of the box without making any changesto sql_mode ?

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions