Ion Auth - Lightweight Auth System based on Redux Auth 2

[eluser]Ben Edmunds[/eluser]
Bernd,

Thanks for all the troubleshooting.

I still can't seem to re-produce this. Are you getting an error message?


Thanks,

[eluser]joytopia[/eluser]
Happy Easter, Ben,

this morning - the session cookies expired over night – I got on two of three browsers these error messages:

Code:

A PHP Error was encountered

Severity: Notice

Message: Undefined property: Ion_auth_model::$ion_auth

Filename: models/ion_auth_model.php

Line Number: 844

Code:

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: models/ion_auth_model.php

Line Number: 844

Code:

Ein Datenbankfehler ist aufgetreten

Error Number: 1064

Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'id` = '8'' in Zeile 1

UPDATE `users` SET `last_login` = 1270340970 WHERE ` IS NULL AND `id` = '8'

I cannot figure out, why it's only in two of three browsers. This is a bit confusing.
In the two browsers (FireFox and Safari)I have all the three cookies. In the other one (Opera) I have only the session cookie.

Best regards
Bernd

[eluser]joytopia[/eluser]
Now I have decommented line 844

Code:

/**
     * update_last_login
     *
     * @return bool
     * @author Ben Edmunds
     **/
    public function update_last_login($id)
    {
        $this->load->helper('date');
        
        $this->db
            //->where($this->ion_auth->_extra_where)
            ->update($this->tables['users'], array('last_login' => now()), array('id' => $id));
        
        return $this->db->affected_rows() == 1;
    }

I get this errors:

Code:

A PHP Error was encountered

Severity: Notice

Message: Undefined property: Ion_auth_model::$ion_auth

Filename: models/ion_auth_model.php

Line Number: 650

Code:

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: models/ion_auth_model.php

Line Number: 650

Code:

Ein Datenbankfehler ist aufgetreten

Error Number: 1054

Unbekanntes Tabellenfeld ' IS NULL LIMIT 1' in where clause

SELECT `users`.`id`, `users`.`username`, `users`.`password`, `users`.`email`, `users`.`activation_code`, `users`.`forgotten_password_code`, `users`.`ip_address`, `users`.`active`, `users`.`group_id`, `groups`.`name` AS `group`, `groups`.`description` AS group_description, `meta`.`first_name`, `meta`.`last_name`, `meta`.`company`, `meta`.`phone`, `meta`.`t3_uid`, `meta`.`t3_password`, `meta`.`t3_usergroup`, `meta`.`tstamp`, `meta`.`disable`, `meta`.`deleted`, `meta`.`gender`, `meta`.`title`, `meta`.`address`, `meta`.`country_code`, `meta`.`zip`, `meta`.`city`, `meta`.`phone`, `meta`.`mobil`, `meta`.`fax`, `meta`.`www`, `meta`.`crdate`, `meta`.`cruser_id`, `meta`.`image`, `meta`.`lastlogin`, `meta`.`services`, `meta`.`language`, `meta`.`region`, `meta`.`nearby`, `meta`.`quarter`, `meta`.`date_of_birth`, `meta`.`admin_comments`, `meta`.`invited_by`, `meta`.`activity`, `meta`.`setup_publish`, `meta`.`setup_email`, `meta`.`setup_design`, `meta`.`setup_mytop1`, `meta`.`setup_mytop2`, `meta`.`setup_mytop3`, `meta`.`setup_mytop4`, `meta`.`setup_mytop5`, `meta`.`bg_image`, `meta`.`premium_until`, `meta`.`academy_until` FROM (`users`) LEFT JOIN `meta` ON `users`.`id` = `meta`.`user_id` LEFT JOIN `groups` ON `users`.`group_id` = `groups`.`id` WHERE `users`.`id` = '8' AND ` IS NULL LIMIT 1

This is line 650

Code:

return $this->db->where($this->ion_auth->_extra_where)
->get($this->tables['users']);

Now I removed extra_where:

Code:

return $this->db->get($this->tables['users']);

And now it works.

This is what I already wrote yesterday

Best regards
Bernd

[eluser]owls[/eluser]
Noob Assistance Requested!

I am new to CI and am trying to get Ion Auth working. I copied all the files to their respective directories and set up the three tables in the DB. When I try example.com/auth, I get an empty page. What basic concept am I missing?

Thanks.

[eluser]Ben Edmunds[/eluser]
Bernd,

Just FYI, I asked Phil to take a look at this as I still can't seem to reproduce it. Maybe he'll be able to...

[eluser]Ben Edmunds[/eluser]
owls,

Do your other pages work?

Like just example.com/

[eluser]owls[/eluser]
Yup. Everything else continues to work correctly.

[eluser]Ben Edmunds[/eluser]
owls,

Are you using >=PHP5?

[eluser]owls[/eluser]
WOW! And here I thought we WERE using 5, but we're actually running 4.3.9. Glad you asked!

[eluser]Ben Edmunds[/eluser]
Any chance you can upgrade?

If not start with changing the constructor functions to PHP4 style.