Welcome Guest, Not a member yet? Register   Sign In
Community Auth - a database error when logging in
#1

(This post was last modified: 04-11-2017, 10:59 PM by icteroo.)

Hi,

I have installed Community Auth (current master) with CodeIgniter 3.1.4.

The configurations are:



Code:
$config['sess_driver'] = 'files';
$config['sess_cookie_name'] = 'ci_session';
$config['sess_expiration'] = 7200;
$config['sess_save_path'] = sys_get_temp_dir();
$config['sess_match_ip'] = FALSE;
$config['sess_time_to_update'] = 300;
$config['sess_regenerate_destroy'] = FALSE;

Added an encryption key using Key_creator.php

Edited Examples.php


Code:
public function create_user()
{
// Customize this array for your user
$user_data = [
'username'   => 'skunkbot',
'passwd'     => 'PepeLePew7',
'email'      => '[email protected]',
'auth_level' => '9', // 9 if you want to login @ examples/index.
];



An account is created using /examples/create_user

Checked the DB user table and the user exists





However when I try to login, I get a database error:

A Database Error Occurred
Error Number: 1048
Column 'id' cannot be null
INSERT INTO `auth_sessions` (`id`, `user_id`, `login_time`, `ip_address`, `user_agent`) VALUES (NULL, '309003055', '2017-04-10 14:11:54', '84.92.55.111', 'Chrome 57.0.2987.133 on Mac OS X')
Filename: third_party/community_auth/models/Auth_model.php
Line Number: 90



$session_id seems to be NULL..

Do you have any idea why it keeps getting this error?

Thanks.
Reply


Messages In This Thread
Community Auth - a database error when logging in - by icteroo - 04-10-2017, 06:38 AM



Theme © iAndrew 2016 - Forum software by © MyBB