Breaking News: Grepper is joining You.com. Read the official announcement!

Integrity constraint violation: 1052 Column in order clause is ambiguous

Add Answer

Adam, the developer answered on May 14, 2021 Popularity 9/10 Helpfulness 3/10

answer Integrity constraint violation: 1052 Column in order clause is ambiguous

related SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous

related SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'Name' in where clause is ambiguous

Integrity constraint violation: 1052 Column in order clause is ambiguous

Comment

specify your id, which table's id are you taking from to avoid ambiguity
example:
<?php
    public function getItemsBannedWord(Scenario $scenario)
    {
        return $scenario->Items()
        ->oldest('items.id') // here -> instead of (id), change to (yourtable.id)
        ->join('banned_words', function($qb){
            $qb->on('items.name_ja', 'banned_words.ng_word')
                ->orOn('items.name_en', 'banned_words.ng_word');
        })->first();
    }
?>

Popularity 9/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: ambiguous clause integrity php

Link to this answer
Share Copy Link

Contributed on Nov 28 2022

Adam, the developer

0 Answers Avg Quality 2/10

Closely Related Answers

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous

Comment

SQL supports qualifying a column by prefixing the reference with either the 
full table name:

SELECT tbl_names.id, tbl_section.id, name, section
  FROM tbl_names
  JOIN tbl_section ON tbl_section.id = tbl_names.id 
  
...or a table alias:

SELECT n.id, s.id, n.name, s.section
  FROM tbl_names n
  JOIN tbl_section s ON s.id = n.id

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: ambiguous ambi

Link to this answer
Share Copy Link

Contributed on May 14 2021

Lokesh003

0 Answers Avg Quality 2/10

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'Name' in where clause is ambiguous

Comment

Ambiguous, means that mysql doesn't know which column to order by, you have two columns with the name name, you probably need to prefix it with the table name as well.

answer given by Tray2 in https://laracasts.com/discuss/channels/laravel/sqlstate23000-integrity-constraint-violation-1052-column-name-in-order-clause-is-ambiguous

Popularity 8/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: ambiguous ambi

Link to this answer
Share Copy Link

Contributed on May 30 2023

Shy Snake

0 Answers Avg Quality 2/10

Integrity constraint violation: 1052 Column in order clause is ambiguous

Contents

More Related Answers

Integrity constraint violation: 1052 Column in order clause is ambiguous

Closely Related Answers

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'Name' in where clause is ambiguous

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.