Ion Auth - Lightweight Auth System based on Redux Auth 2

Code:

A Database Error Occurred

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 'group, `groups`.`description` AS group_description, `meta`.`first_name`, `meta`.' at line 1



SELECT `users`.*, `groups`.`name` AS group, `groups`.`description` AS group_description, `meta`.`first_name`, `meta`.`last_name`, `meta`.`company`, `meta`.`phone` FROM (`users`) LEFT JOIN `meta` ON `users`.`id` = `meta`.`user_id` LEFT JOIN `groups` ON `users`.`group_id` = `groups`.`id`



Filename: .../models/ion_auth_model.php



Line Number: 650

Code:

function create_user() 

    {  

        $this->data['title'] = "Create User";

        

        $yearmin = date("Y", strtotime('-18 years'));

        $this->load->model('country_model');        

        $this->load->library('formdate');

        //set date params

        $formdate = new FormDate(); 

        $formdate->setLocale('nl_BE');

        $formdate->year['start'] = 1930;

        $formdate->year['end'] = $yearmin;

        $formdate->year['descend'] = true;

        $formdate->month['values'] = 'string';

        $formdate->month['selected'] = 'January';

        $formdate->day['selected'] = '1';

        

        $data['formdate'] = $formdate;

        

        $data['country'] = $this->country_model->country_select();    

              

        if ($this->ion_auth->logged_in() || $this->ion_auth->is_admin()) {

            redirect('auth', 'refresh');

        }

        

        //validate form input

        $this->form_validation->set_rules('name', 'Name', 'required|xss_clean');

        $this->form_validation->set_rules('username', 'Username', 'required|xss_clean');

        $this->form_validation->set_rules('email', 'Email Address', 'required|valid_email');

        $this->form_validation->set_rules('password', 'Password', 'required|min_length['.$this->config->item('min_password_length', 'ion_auth').']|max_length['.$this->config->item('max_password_length', 'ion_auth').']|matches[password_confirm]');

        $this->form_validation->set_rules('password_confirm', 'Password Confirmation', 'required');

        $this->form_validation->set_rules('gender', 'Gender', 'required|xss_clean');

        $this->form_validation->set_rules('country', 'Country', 'trim|required');

        $this->form_validation->set_rules('day', 'Day', 'trim|required|callback_valid_country');

        $this->form_validation->set_rules('month','Month', 'trim|required');

        $this->form_validation->set_rules('year','Year', 'trim|required|callback_valid_date');



        if ($this->form_validation->run() == true) {

            $username  = $this->input->post('username');

            $email     = $this->input->post('email');

            $password  = $this->input->post('password');

            

            $additional_data = array('name' => $this->input->post('name'),

                                     'gender'  => $this->input->post('gender'),

                            'country'    => $this->input->post('country'),

                            'dateofbirth'      => $this->input->post('year') .'-'. $this->input->post('month') .'-'. $this->input->post('day'),

                               );

        }

        if ($this->form_validation->run() == true && $this->ion_auth->register($username,$password,$email,$additional_data)) { //check to see if we are creating the user

                //redirect them back to the admin page

            $this->session->set_flashdata('message', "User Created");

               redirect("auth", 'refresh');

        } 

        

        else { //display the create user form

            //set the flash data error message if there is one

            $data['message'] = (validation_errors() ? validation_errors() : ($this->ion_auth->errors() ? $this->ion_auth->errors() : $this->session->flashdata('message')));

            

            $this->load->view('auth/create_user', $data);

        }

        

    }