Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't go through installation process with PostgreSQL #194

Closed
fledge4tw opened this issue Mar 21, 2016 · 2 comments
Closed

Can't go through installation process with PostgreSQL #194

fledge4tw opened this issue Mar 21, 2016 · 2 comments

Comments

@fledge4tw
Copy link

Hi, I'm looking to get your piece of software working, but can't do righht now. So here's my bug report

Expected behaviour

Expected to go through installation process and be able to login with provided information during script.

Actual behaviour

2 Errors at the end of the artisan script.
Admin account isn't created, but default admin@example.com user is in the database after script fail.
Can't Log-in. Maybe i could try default user if i had default password.

Steps to reproduce

Just trying a clean install following instructions in README.md
Droping & Recreating database + git clean -x -f -d at each try.

Environment info

Operating System: Debian 8 + Testing Repo
PHP Version: v5.6.17-3 (same error on v7.0)
Node Version: v4.3.1
Database System: PostgreSQL
Database Version: v9.5

storage/logs/cli.log (same output at the end of php artisan)

production.ERROR: exception 'PDOException' with message 'SQLSTATE[42803]: Grouping error: 7 ERROR: column "projects.name" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...= $2 and "projects"."deleted_at" is null order by "name" asc
^' in /opt/deployer/vendor/laravel/framework/src/Illuminate/Database/Connection.php:335
[...]
Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42803]: Grouping error: 7 ERROR: column "projects.name" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...= $2 and "projects"."deleted_at" is null order by "name" asc
^ (SQL: select count(*) as aggregate from "projects" where "projects"."group_id" = 1 and "projects"."group_id" is not null and "is_template" = 0 and "projects"."deleted_at" is null order by "name" asc)' in /opt/deployer/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669
[...]

Steps I could do

  • Installation on MariaDB or MySQL Database ?
@REBELinBLUE
Copy link
Owner

Hmm, I shall take a look at this as soon as I am free in about an hour.

REBELinBLUE added a commit that referenced this issue Mar 21, 2016
…05_07_145127_change_output_column is not needed
@REBELinBLUE
Copy link
Owner

This is fixed in master I will release a new tagged version later today

REBELinBLUE added a commit that referenced this issue Mar 21, 2016
* master: (31 commits)
  Updated CHANGELOG
  Upgrade ruby so github_changelog_generator still works
  Fixes #194
  Work on fixing #194. Long text isn't supported on postgresql so 2015_05_07_145127_change_output_column is not needed
  Tweak group name
  Fixed group name
  Re-added missing array_merge
  Group VM
  Added gitignore global to config
  Revert "Refactoring deployment to move commands to separate command files"
  Revert "Add comments to bash scripts"
  Revert "Work on refactoring deployment script"
  Revert "Move cleanup to a shell script"
  Typo
  Not needed
  Move cleanup to a shell script
  Work on refactoring deployment script
  Add comments to bash scripts
  Tweak
  Updated all dependencies
  ...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants