Antecedents
Recently, the company's back-end project has been transformed and upgraded, from the previous laravel5.6 version to laravel5.8 version. After the upgrade, the system generated a lot of SQL execution It was wrong, but it ran well in the old version of the system, so today's journey of digging holes was born.
Recommended: "laravel tutorial"
Project environment
Old system (linux laravel5.6 php7.2 mysql5. 7)
Upgraded new system (linux laravel5.8 php7.2 mysql5.7)
Only upgraded the laravel framework version, and did not upgrade other related service dependencies.
However, a large number of SQL execution errors occurred. The exception monitoring is as follows:

Analysis process
What caused this service error It is such a piece of business logic, which is simulated through a demo below.
$pivot = UserRole::firstOrCreate([
'user_id' => 3,
'role_id' => 3,
]);
$this->addRoleHistory($user,$pivot->id);
dd($pivot->id);In laravel5.6 version, this code runs without any problem, but upgrading to version 5.8 will cause a large number of SQL execution errors , like the following.
laravel5.6:
dd($pivot->id); //10002
laravel5.8:
dd($pivot->id); //nullIn 5.6, the saved data can still get the ID normally, but why can’t it work in 5.8, so I immediately checked the release notes of laravel5.8, and there was nothing I found a change to cancel the acquisition of auto-increment ID in the Pivot model, so I started to check the 5.8 source code. . .
First of all, we compared the firstOrCreate function of 5.6 and 5.8 and found that there were no changes and the code logic was executed correctly.



Repair plan
In each Pivot Just re-overwrite the incrementing attribute value in Class and set it to true.class UserRole extends Pivot
{
public $incrementing = true;
protected $fillable = [
'user_id',
'role_id',
];
}After repair:laravel5.8:
dd($pivot->id); //10003
Postscript
So I looked at it carefully again In the laravel5.7~laravel5.8 release notes, I found that the reason for this change was still not mentioned, so I went to Google again and still couldn’t find the reason for this joke.
The above is the detailed content of Disappeared Pivot model ID (Laravel pitfall diary). For more information, please follow other related articles on the PHP Chinese website!
Laravel in Action: Real-World Applications and ExamplesApr 16, 2025 am 12:02 AMLaravelcanbeeffectivelyusedinreal-worldapplicationsforbuildingscalablewebsolutions.1)ItsimplifiesCRUDoperationsinRESTfulAPIsusingEloquentORM.2)Laravel'secosystem,includingtoolslikeNova,enhancesdevelopment.3)Itaddressesperformancewithcachingsystems,en
Laravel's Primary Function: Backend DevelopmentApr 15, 2025 am 12:14 AMLaravel's core functions in back-end development include routing system, EloquentORM, migration function, cache system and queue system. 1. The routing system simplifies URL mapping and improves code organization and maintenance. 2.EloquentORM provides object-oriented data operations to improve development efficiency. 3. The migration function manages the database structure through version control to ensure consistency. 4. The cache system reduces database queries and improves response speed. 5. The queue system effectively processes large-scale data, avoid blocking user requests, and improve overall performance.
Laravel's Backend Capabilities: Databases, Logic, and MoreApr 14, 2025 am 12:04 AMLaravel performs strongly in back-end development, simplifying database operations through EloquentORM, controllers and service classes handle business logic, and providing queues, events and other functions. 1) EloquentORM maps database tables through the model to simplify query. 2) Business logic is processed in controllers and service classes to improve modularity and maintainability. 3) Other functions such as queue systems help to handle complex needs.
Laravel's Versatility: From Simple Sites to Complex SystemsApr 13, 2025 am 12:13 AMThe Laravel development project was chosen because of its flexibility and power to suit the needs of different sizes and complexities. Laravel provides routing system, EloquentORM, Artisan command line and other functions, supporting the development of from simple blogs to complex enterprise-level systems.
Laravel (PHP) vs. Python: Development Environments and EcosystemsApr 12, 2025 am 12:10 AMThe comparison between Laravel and Python in the development environment and ecosystem is as follows: 1. The development environment of Laravel is simple, only PHP and Composer are required. It provides a rich range of extension packages such as LaravelForge, but the extension package maintenance may not be timely. 2. The development environment of Python is also simple, only Python and pip are required. The ecosystem is huge and covers multiple fields, but version and dependency management may be complex.
Laravel and the Backend: Powering Web Application LogicApr 11, 2025 am 11:29 AMHow does Laravel play a role in backend logic? It simplifies and enhances backend development through routing systems, EloquentORM, authentication and authorization, event and listeners, and performance optimization. 1. The routing system allows the definition of URL structure and request processing logic. 2.EloquentORM simplifies database interaction. 3. The authentication and authorization system is convenient for user management. 4. The event and listener implement loosely coupled code structure. 5. Performance optimization improves application efficiency through caching and queueing.
Why is Laravel so popular?Apr 02, 2025 pm 02:16 PMLaravel's popularity includes its simplified development process, providing a pleasant development environment, and rich features. 1) It absorbs the design philosophy of RubyonRails, combining the flexibility of PHP. 2) Provide tools such as EloquentORM, Blade template engine, etc. to improve development efficiency. 3) Its MVC architecture and dependency injection mechanism make the code more modular and testable. 4) Provides powerful debugging tools and performance optimization methods such as caching systems and best practices.
Which is better, Django or Laravel?Mar 28, 2025 am 10:41 AMBoth Django and Laravel are full-stack frameworks. Django is suitable for Python developers and complex business logic, while Laravel is suitable for PHP developers and elegant syntax. 1.Django is based on Python and follows the "battery-complete" philosophy, suitable for rapid development and high concurrency. 2.Laravel is based on PHP, emphasizing the developer experience, and is suitable for small to medium-sized projects.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft






