+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: Ion Auth - Lightweight Auth System based on Redux Auth 2 (/showthread.php?tid=27435)
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-19-2010
[eluser]Ben Edmunds[/eluser]
d3ptzz,
Your welcome
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-19-2010
[eluser]Kinsbane[/eluser]
Hey Ben,
I just upgraded my files to your latest gits and am receiving an error when trying to login with the default account - it appears to be in the function identity_check() within ion_auth_model.php, on or around line #332 here's what my error says:
Quote: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 'WHERE `0` = 'admin@admin.com'' at line 2
SELECT COUNT(*) AS `numrows` WHERE `0` = 'admin@admin.com'
Here's the function:
Code:
protected function identity_check($identity = '')
{
if (empty($identity))
{
return FALSE;
}
return $this->db
->where($this->identity_column, $identity)
->count_all_results($this->tables['users']) > 0;
}I've got my newest ion_auth config file setup how I need, but not sure why it's querying field `0` for the email.
Any ideas that could help out? Thanks.
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-20-2010
[eluser]owls[/eluser]
Other than form_validation, are there any major obstacles to using ion auth with codeigniter 1.6.2?
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-20-2010
[eluser]Ben Edmunds[/eluser]
Owls,
I have no idea, other than form_validation I don't remember any big changes...
Give it a go and I'll help you if you run into problems.
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-20-2010
[eluser]Ben Edmunds[/eluser]
Kisbane,
Try replacing $this->identity_column with $this->config->item('identity', 'ion_auth') and let me know what happens.
Thanks,
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-20-2010
[eluser]Rob B.[/eluser]
Hi -- Thanks for the great library. Just wanted to let you know that I ran into the same problem Bernd discussed in this reply (http://ellislab.com/forums/viewreply/733952/) about the $this->ion_auth->_extra_where problem in the Ion auth model. I ended up commenting out line 899 (in the login_remembered_user() function) in ion_auth_model.php as follows:
Code:
//get the user
$query = $this->db->select($this->identity_column.', id, group_id')
->where($this->identity_column, get_cookie('identity'))
->where('remember_code', get_cookie('remember_code'))
// ->where($this->ion_auth->_extra_where)
->limit(1)
->get($this->tables['users']);and that enabled CI to run properly. I'm not really sure I understand what this property is for (I did read through the definition in the library, but it's still not that clear to me). Perhaps this could be a config variable that could be turned off if not needed. Anyway, I just wanted to post this as another case of this issue in the case it is helpful to you. Thanks!
Rob
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-20-2010
[eluser]Ben Edmunds[/eluser]
Hey Rob,
Thanks. I just pushed a fix for this. There seems to be a problem with the extra_where only when ran in the constructor of the library. I haven't been able to re-produce this issue to give it a good once over but from Bernd's troubleshooting this is the fix he came up with and should work fine.
The extra_where is there for multiple domain systems and any other system where users might need to have the same identity but need separate accounts.
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-20-2010
[eluser]Kinsbane[/eluser]
[quote author="Ben Edmunds" date="1271792171"]Kisbane,
Try replacing $this->identity_column with $this->config->item('identity', 'ion_auth') and let me know what happens.
Thanks,[/quote]
Hey Ben,
Well my first thought was, "I hadn't upgraded CI since I did Ion Auth", so I upgraded CI to 1.7.2 - but that was no fix. Changing from $this->identity_column to $this->config->item('identity', 'ion_auth') also didn't seem to work.
So then I thought, "OK! I'll just use ->where('email', $identity) !!"
But, this doesn't work either:
Quote: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 'WHERE `email` = 'admin@admin.com'' at line 2
SELECT COUNT(*) AS `numrows` WHERE `email` = 'admin@admin.com'
Something fishy is going on here. :/
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-20-2010
[eluser]spmckee[/eluser]
Same exact error as Kinsbane.
Worked fine on localhost:
PHP Version 5.2.9
MySQL client version: 5.0.51a
1064 error on dev server:
PHP Version 5.2.6
MySQL client version: 5.0.45
Ion Auth - Lightweight Auth System based on Redux Auth 2 - El Forum - 04-20-2010
[eluser]Kinsbane[/eluser]
I just realized that the AR commands in here aren't selecting a table to select from whatsoever:
Code:
return $this->db->get_where('users', array('email' => $identity), 1, 0);Outputs this error:
Quote: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 'WHERE `0` = 'admin@admin.com' AND `active` = 1 LIMIT 1' at line 2
SELECT `id`, `password`, `group_id` WHERE `0` = 'admin@admin.com' AND `active` = 1 LIMIT 1