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

SQL query contains duplicate order statement when accessing (base url)/dashboard, 500 error #3439

Closed
Joe-K2018 opened this issue Jan 28, 2019 · 3 comments
Assignees
Labels

Comments

@Joe-K2018
Copy link

Possibly related to #3418.

Here is my complete log:

laravel.log

@jbrooksuk
Copy link
Member

Hi Joe,

As per the support ticket, I'm going to pick this up here.

@jbrooksuk jbrooksuk added the Bug Bugs with Cachet label Apr 12, 2019
@jbrooksuk
Copy link
Member

The exception is:

Next ErrorException: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique. (SQL: select * from [components] where [components].[group_id] = 1 and [components].[group_id] is not null and [enabled] = 1 and [components].[deleted_at] is null order by [order] asc, [order] asc) (View: C:\Users\jkoch\Cachet\resources\views\dashboard\partials\components.blade.php) (View: C:\Users\jkoch\Cachet\resources\views\dashboard\partials\components.blade.php) in C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664

@jbrooksuk jbrooksuk self-assigned this Apr 12, 2019
@jbrooksuk
Copy link
Member

This is now fixed.

jbrooksuk added a commit that referenced this issue Apr 12, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants