Thread

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_accounts`.`uacc_id`' at line 7

Filename: models/flexi_auth_lite_model.php

Line Number: 213

error_reporting(0);

Error Number:

ERROR: Column does not exist «user_accounts» in the relation «user_accounts» LINE 1: INSERT INTO "user_accounts" ("user_accounts"."uacc_group_fk"... ^

INSERT INTO "user_accounts" ("user_accounts"."uacc_group_fk", "user_accounts"."uacc_email", "user_accounts"."uacc_username", "user_accounts"."uacc_password", "user_accounts"."uacc_ip_address", "user_accounts"."uacc_date_last_login", "user_accounts"."uacc_date_added", "user_accounts"."uacc_activation_token", "user_accounts"."uacc_active", "user_accounts"."uacc_suspend", "user_accounts"."uacc_salt")
 VALUES (1, 'sasa2@hotmail.com', 'sasa10', '$2a$08$tbxuO0z02mk5TwF445M8yeLSH67P995Q5p7l.R1zQfmhaUb2bHb7y', '127.0.0.1', '2014-11-03 04:26:15', '2014-11-03 04:26:15', '5ae984c9433f146561a79c54a2d6160fa37d2af8', 0, 0, 'F4kFtBvt6b')

Filename: C:\wamp\www\auth\system\database\DB_driver.php

Line Number: 330

function register_account()
 {
  $this->load->library('form_validation');
  // Set validation rules.
  // The custom rules 'identity_available' and 'validate_password' can be found in '../libaries/MY_Form_validation.php'.
  $validation_rules = array(   
   array('field' => 'register_email_address', 'label' => 'Email Address', 'rules' => 'required|valid_email|identity_available'),
   array('field' => 'register_username', 'label' => 'Username', 'rules' => 'required|min_length[4]|identity_available'),   
   array('field' => 'register_password', 'label' => 'Password', 'rules' => 'required|validate_password'),
   array('field' => 'register_confirm_password', 'label' => 'Confirm Password', 'rules' => 'required|matches[register_password]')
  );

  $this->form_validation->set_rules($validation_rules);
  
  // Run the validation. ->>> it always gets stuck here
  if ($this->form_validation->run())
  { 
   // Get user login details from input.
   $email = $this->input->post('register_email_address');
   $username = $this->input->post('register_username');
   $password = $this->input->post('register_password');
   
   // Get user profile data from input.
   // You can add whatever columns you need to customise user tables.
   $profile_data = array(
   );
   
   // Set whether to instantly activate account.
   // This var will be used twice, once for registration, then to check if to log the user in after registration.
   $instant_activate = FALSE;
 
   // The last 2 variables on the register function are optional, these variables allow you to:
   // #1. Specify the group ID for the user to be added to (i.e. 'Moderator' / 'Public'), the default is set via the config file.
   // #2. Set whether to automatically activate the account upon registration, default is FALSE. 
   // Note: An account activation email will be automatically sent if auto activate is FALSE, or if an activation time limit is set by the config file.
   $response = $this->flexi_auth->insert_user($email, $username, $password, $profile_data, 2, $instant_activate);

   if ($response)
   {
    // This is an example 'Welcome' email that could be sent to a new user upon registration.
    // Bear in mind, if registration has been set to require the user activates their account, they will already be receiving an activation email.
    // Therefore sending an additional email welcoming the user may be deemed unnecessary.
    $email_data = array('identity' => $email);
    $this->flexi_auth->send_email($email, 'Welcome', 'registration_welcome.tpl.php', $email_data);
    // Note: The 'registration_welcome.tpl.php' template file is located in the '../views/includes/email/' directory defined by the config file.
    
    ###+++++++++++++++++###
    
    // Save any public status or error messages (Whilst suppressing any admin messages) to CI's flash session data.
    $this->session->set_flashdata('message', $this->flexi_auth->get_messages());
    
    // This is an example of how to log the user into their account immeadiately after registering.
    // This example would only be used if users do not have to authenticate their account via email upon registration.
    if ($instant_activate && $this->flexi_auth->login($email, $password))
    {
     // Redirect user to public dashboard.
     redirect('racun');
    }
    
    // Redirect user to login page
    redirect('racun');
   }
  }

  // Set validation errors. -> these are NEVER set
  $this->data['message'] = validation_errors('', '');

  return FALSE;
 }