dongzaocheng3214 2019-01-22 08:35
浏览 650

SQLSTATE [HY000]:一般错误:21个错误参数或其他API滥用 - 在pyrocms中

I'm developing a web site on pyrocms and it worked fine in my laptop (WAMP environment). But it gives me error SQLSTATE[HY000]: General error: 21 bad parameter or other API misuse when I try this in my ubuntu server.

Server's PHP version - 7.2.13

I found this issue in github but I'm not clear what they suggesting.

My form's code

{% set company_types = {} %}

    {% set form = form({
        'ajax': true,
        'options': {
            'redirect': '/merchants/mobile/pin/get',
        },
        'handler': 'Ksn\\CompanyModule\\Company\\Form\\CompanyFormHandler@handle',
        'fields': {
            'name':{
                'type':'text',
                'required':true,
                'label': 'Comapany Name'
                }
.
.
.
.

and my form handlers code is this.

<?php namespace Ksn\CompanyModule\Company\Form;


use Anomaly\UsersModule\User\UserRepository;
use Illuminate\Contracts\Auth\Guard;
use Illuminate\Foundation\Bus\DispatchesJobs;
use Anomaly\Streams\Platform\Ui\Form\FormBuilder;
use Ksn\CompanyModule\Company\Contract\CompanyRepositoryInterface;

class CompanyFormHandler
{
    use DispatchesJobs;

    public function handle(
        Guard $auth,
        UserRepository $users,
        FormBuilder $builder,
        CompanyRepositoryInterface $companyRepository
    )
    {
        if(!$user = $auth->user()) {
            abort(404);
        }


        $values = $builder->getFormValues();

        $company_arr = [];
        foreach ($values as $key => $value)
        {
            if($key == 'mobile')
            {
                $user->telephone = $value;
                continue;
            }
            $company_arr[$key] = $value;
        }

        $company = $companyRepository->newInstance($company_arr);
        $company->save();

        $user->company_id = $company->getAttribute('id');

        // generate random pin
        $digits = 4;
        $user->mobileverificationpin = rand(pow(10, $digits-1), pow(10, $digits)-1);
        $user->status = 4;
        $user->save();


        //dd($company->getAttribute('id'));

        return $builder->getFormResponse();

    }

}

As my observations, error occurred only on data insertions.

enter image description here

as I highlighted above in red, it gives my desired response after series of error messages btw. Is anyone know how to fix this? Thanks

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥50 易语言把MYSQL数据库中的数据添加至组合框
    • ¥20 求数据集和代码#有偿答复
    • ¥15 关于下拉菜单选项关联的问题
    • ¥20 java-OJ-健康体检
    • ¥15 rs485的上拉下拉,不会对a-b<-200mv有影响吗,就是接受时,对判断逻辑0有影响吗
    • ¥15 使用phpstudy在云服务器上搭建个人网站
    • ¥15 应该如何判断含间隙的曲柄摇杆机构,轴与轴承是否发生了碰撞?
    • ¥15 vue3+express部署到nginx
    • ¥20 搭建pt1000三线制高精度测温电路
    • ¥15 使用Jdk8自带的算法,和Jdk11自带的加密结果会一样吗,不一样的话有什么解决方案,Jdk不能升级的情况