Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0

by

This was added to the upgrade documentation on Dec 29, 2015, so if you upgraded before then you probably missed it.

When fetching any attribute from the model it checks if that column should be cast as an integer, string, etc.

By default, for auto-incrementing tables, the ID is assumed to be an integer in this method:

https://github.com/laravel/framework/blob/5.2/src/Illuminate/Database/Eloquent/Model.php#L2790

So the solution is:

class UserVerification extends Model
{
    // if your key name is not 'id'
    // you can also set this to null if you don't have a primary key
    protected $primaryKey = 'your_key_name';

    public $incrementing = false;

    // In Laravel 6.0+ make sure to also set $keyType
    protected $keyType="string";
}

More Related Contents:

  1. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  2. Laravel one to many relation with a one to one relation
  3. How to do this in Laravel, subquery where in
  4. Laravel 5 PDOException Could Not Find Driver
  5. Laravel Check If Related Model Exists
  6. How can I convert many statement mysql to laravel eloquent?
  7. Laravel Model with Two Primary Keys update [duplicate]
  8. Laravel OrderBy relationship count
  9. Laravel Checking If a Record Exists
  10. Laravel 5 hasMany relationship on two columns
  11. Laravel $q->where() between dates
  12. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  13. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  14. Difference between Eloquent\Model::get() and all()
  15. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  16. Eloquent Parent-Child relationship on same model
  17. Eloquent many-to-many-to-many – how to load distant relation easily
  18. Merge ‘with’ and ‘whereHas’ in Laravel 5
  19. find in set in laravel ? example
  20. How to insert multiple rows from a single query using eloquent/fluent
  21. Creating and Update Laravel Eloquent
  22. Can’t install laravel installer via composer
  23. Laravel 5.2 Auth not Working
  24. Laravel 5.5 Error Base table or view already exists: 1050 Table ‘users’ already exists
  25. Fatal error: Class ‘Illuminate\Foundation\Application’ not found
  26. Laravel SQLSTATE[HY000] [2002] Connection refused
  27. Custom validator in Laravel 5
  28. Laravel Middleware return variable to controller
  29. CONCAT columns with Laravel 5 eloquent
  30. How to create a database-driven multi-level navigation menu using Laravel

Leave a Comment