我该如何解决这个Zend_Form_Element_Select数据库错误？

Question

当我使用Zend_Form_Element_Select元素与multioptions我得到这个错误，当我经过选择的价值Zend_DB_Table插入到数据库

Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accounts_status ' in 'field list' 

我已经提取了一些代码片段，我相信会走很长的路到说明我的problem.The accounts_status字段DOES在我的表

存在在我的形式构建体已添加的选择元件和选项（I已经离开了其它元件）

$optionsstatus = array(
        'active' => 'active', 
        'pending' => 'pending'    
        ); 
    $optionsrole = array(
       'guest' => 'guest', 
       'user' => 'user', 
       'writer' => 'writer', 
       'admin' => 'admin'    
       ); 

    $status = new Zend_Form_Element_Select('accounts_status'); 
        $status->setLabel('Status') 
        ->setRequired(true)    
        ->addMultiOptions($optionsstatus); 
    $role = new Zend_Form_Element_Select('accounts_role'); 
        $role->setLabel('Role') 
        ->setRequired(true) 
        ->addMultiOptions($optionsrole); 

我使用Zend_Db_Table类从我的控制器

public function addaccount($username, $fullname, $email, 
     $password,$status,$roles,$comments) 
    { 
     $data = array(
       'accounts_username' => $username, 
       'accounts_fullname' => $fullname, 
       'accounts_email' => $email, 
       'accounts_password' => $password,    
       'accounts_status ' => $status, 
       'accounts_roles' => $roles,    
       'accounts_comments ' => $comments, 
     ); 
     $this->insert($data); 
    } 

插入后值在我的控制，我得到的职位值，并将其发送到我的模型

$username = $form->getValue('accounts_username'); 
       $fullname = $form->getValue('accounts_fullname'); 
       $email = $form->getValue('accounts_email'); 
       $password = $form->getValue('accounts_password'); 
       $status = $form->getValue('accounts_status'); 
       $roles = $form->getValue('accounts_roles'); 
       $comments = $form->getValue('accounts_comments'); 
       $accounts = new Model_DbTable_Account(); 
       $accounts->addaccount($username, $fullname,$email, 
       $password,$status,$roles,$comments); 

这种方法适用除了我正在处理Zend_Form_Element_Select元素。我只是想知道在涉及到CRUD操作时是否有处理这个select元素的特定方法。

Answer 1

Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accounts_status ' in 'field list' 

也许我疯了，但在我看来像有对'accounts_status '字段名的那一端一个额外的空间。