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

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

Add Answer
Shadow answered on May 14, 2021 Popularity 9/10 Helpfulness 4/10

Contents

  • answer laravel SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where 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

    • More Related Answers

  • SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
  • Integrity constraint violation: 1052 Column in order clause is ambiguous
  • how to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
  • Column not found: 1054 Unknown column 'api_token' in 'where clause
  • Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
  • Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
  • SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
  • column 'user_id' in on clause is ambiguous
  • Uncaught PDOException: SQLSTATE[42S22]: Column not found:
  • ERROR: column reference "doctor_id" is ambiguous
  • System.Reflection.AmbiguousMatchException: Ambiguous match found
  • error: column reference "id" is ambiguous

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

    Comment
    3
    Popularity 9/10 Helpfulness 4/10 Language php
    Source: Grepper
    Tags: ambiguous integrity laravel php where-clause
    Link to this answer
    Share Copy Link
    Shadow
    Contributed on Dec 26 2022
    Shadow
    0 Answers  Avg Quality 2/10

    Closely Related Answers



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

    Comment
    0
    Popularity 10/10 Helpfulness 1/10 Language sql
    Source: Grepper
    Tags: ambiguous ambi
    Link to this answer
    Share Copy Link
    Lokesh003
    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
    0

    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
    Shy Snake
    Contributed on May 30 2023
    Shy Snake
    0 Answers  Avg Quality 2/10

    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

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