Year: 2024
-
Post Views: 18 1. In spatie\QueryBuilder, an error is reported: call to undefined method spatie\QueryBuilder\\AllowedFilter::endsWithStrict(). as shown in Figure 1 2. Search in vendor/spatie/laravel-query-builder/src/allowedFilter.php: EndsWithStrict, confirm that the EndsWithStrict method does not exist. 3. Check composer.json , “spatie/laravel-query-builder”: “^5.2”, . Use composer to automatically update to the latest compatible version of the package, 5.2.0 => 5.7.0. as shown in Figure…
-
Post Views: 17 1. In Spatie\QueryBuilder , the request parameter contains “,” error: sqlstate[HY093]: Invalid parameter number: number of bound variables not match number of tokens (SQL: select count(*) as aggregate from `table` where `table`.`Shipping_type` = 2 and `Shipping_at_gmt` >= 2024-05-21 08:54:14 and `Shipping_at_gmt` <= 2024-08-21 08:54:14 and `table`.`Shipping_error_message in (AAA)). as shown in Figure 1 2. When the request…
-
Post Views: 17 1. Copy a large number of files in Windows 10, resulting in CPU usage 100% of which makes it impossible to perform other operations (other operations are too slow, basically it will take a few seconds to react.), during this period may also be because I did the operation to delete the folder (size 10GB). as shown…
-
Post Views: 18 1. pnpm : The file cannot be loaded c:\users\thinkpad\appdata\roaming\npm\pnpm.ps1, because running scripts are prohibited on this system. as shown in Figure 1 2. Reference: about_execution_policies . Instead of executing in the terminal, it is executed in the command prompt, and it is found that the execution is successful. as shown in Figure 2
-
Post Views: 59 1. Failed to activate Navicat. The reason may be due to the upper limit of the number of activations has been reached. Please check if you have deactivated the license key before uninstalling or reinstalling Navicat. As shown in Figure 1 2. Since the system that previously installed Navicat has been reinstalled, it is impossible to deactivate…
-
Post Views: 72 1. Redis officially does not have native installation packages under Windows. as shown in Figure 1 2. Reference:The project is no longer actively maintained. If you are looking for a Windows version of Redis, you may need to check Memurai. Please note that Microsoft does not officially recognize the product in any way. Decided to use memurai.…
-
Post Views: 51 1. The configuration for mysol server 8.0.39 has failed.. as shown in Figure 1 2. Check the logs, as shown below 3. Edit C:\ProgramData\MySQL\MySQL Server 8.0\My.ini. 4. Right-click mysql-installer-community-8.0.36.0.msi to install, mysol server, and click Reconfigure. as shown in Figure 2 5. Still reporting an error, but already reporting another error. Successfully started service MySQL80. Configured configuration…
-
Post Views: 14 1. In Laravel 9, an error is reported when querying a chunkById block: sqlstate[23000]: Integrity Constraint Violation: 1052 ColumnIDin where Clause is ambigous. as shown in Figure 1 2. The code is implemented as follows 3. After adding the column parameter of chunkbyid, an error is reported: The chunkbyid operation was borne the[orders.id]Column is not present in…