Closed (outdated)
Project:
Legal
Version:
6.x-2.4-rc2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
25 May 2007 at 15:52 UTC
Updated:
21 Oct 2017 at 23:36 UTC
Jump to comment: Most recent
Not sure why, but when securesite is active and i change the conditions for legal, normal user cannot login anymore.
There are some errors to be found in the log:
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 ')' at line 1 query: user_access SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /www/htdocs/drupaldir/includes/database.mysql.inc in Zeile 172.
implode() [<a href='function.implode'>function.implode</a>]: Bad arguments. in /www/htdocs/drupaldir/modules/user/user.module in Zeile 361.
array_keys() [<a href='function.array-keys'>function.array-keys</a>]: The first argument should be an array in /www/htdocs/drupaldir/modules/user/user.module in Zeile 361.
The whole seems to get triggered by calling module_invoke_all('user', 'logout', NULL, $user); in hook legal_user() (legal.module line 518).
Comments
Comment #1
robert castelo commentedI've run into that problem as well.
Don't have time to fix this problem, but will update the documentation to make it known that there's a conflict.
Comment #2
wotstheguts commentedHi,
Yes this can have quite an impact. I inadvertently locked out all my beta testers when I made a small change to the terms and conditions!
Just to help anyone else who comes across this, to re-allow users to login with Securesite enabled, you need to login as Admin and go back to the admin/settings/legal page and note down the Current Version.
Then, using a database editor such as DBTools, open the database table legal_accepted and change the tc_id field for all users to the Current Version. They should then be able to login with Securesite.
Then DON"T CHANGE your terms and conditions until there is a patch, or until you stop using Securesite!
Cheers,
Peter.
Comment #3
javi-er commentedHi, I installed your module in a site using securesite and didn't have any issue, the versions I installed are Legal 6.x-2.2-beta4 and Secure Site 6.x-2.4
I saw the notice in this project homepage so I did the following test:
1- downloaded and installed legal and checkbox_validate
2- in legal conf, choose "Page Link" as display style and wrote some t&c
3- created user account and logged in
4- as admin changed the t&c
5- log out with the previous user and logged in again
The result was that the second time I log in with the regular user I got prompted to accept the t&c again without problems.
Maybe this issue affects only to D5 or older releases?
Comment #4
robert castelo commentedJust tested with Legal 6.x-2.4-rc2 and encountered this problem.
Comment #5
Anonymous (not verified) commentedconfirmed
Comment #6
robert castelo commentedConfirmed working or that there's a problem?
Comment #7
Anonymous (not verified) commentedThat there is still the problem with RC2 :(
Comment #8
robert castelo commentedCould someone re-test with Legal 6.x.8.4.
Comment #9
kenorb commentedComment #10
robert castelo commented