Author: 永夜
-
Post Views: 16 1. The current scenario is as follows. In one table, there is a field of payment method. Now if it is necessary, the payment method will be summarized into another table regularly. In order to prevent the records before the query is repeated every time the timing is executed, it is necessary to record a last execution…
-
Post Views: 18 1. Error:[2024-09-28 02:59:09]local.error: preg_replace(): unknown modifier�{“exception”:”[object](ErrorException(code: 0): preg_replace(): unknown modifier�at) [stacktrace]. as shown in Figure 1 2. Check the code implementation 3. View the printed log information 4. The cause is initially derived, the value of the variable $otherpattern is “province/state caused by “/” caused by “/”. Reference:Regular expression special characters are: . \ + * ?[…
-
Post Views: 14 1. The existing implementation is as follows, is a nested preload, sql is as follows 2. Now you need to add constraints for items, and the final implementation is as follows 3. The generated SQL is as follows, which is in line with expectations. as shown in Figure 1
-
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: 20 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…