By Pierre McCarragher on Monday, 21 March 2016
Posted in Technical Issues
Replies 3
Likes 0
Views 336
Votes 0
After reinstalling my website, The login do not work. User cannot login.
Hey Pierre,

I have checked your site and it looks like you have set the site to "offline" and upon entering the login credentials, it seems to be working fine.

Is this only occurring if you set the site to online? Can I set it to online?
·
Tuesday, 22 March 2016 00:45
·
0 Likes
·
0 Votes
·
0 Comments
·
It now online.

I was tryig to login with a user (user login details updated on first post). It give an error

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 'OR `a`.`id` NOT IN (SELECT `category_id` FROM `mwta9_social_clusters_categories_' at line 1 SQL=SELECT DISTINCT `a`.* FROM `mwta9_social_clusters_categories` AS `a` LEFT JOIN `mwta9_social_clusters_categories_access` AS `b` ON `a`.`id` = `b`.`category_id` WHERE `a`.`type` = 'event' AND `a`.`state` = '1' AND (`b`.`profile_id` = OR `a`.`id` NOT IN (SELECT `category_id` FROM `mwta9_social_clusters_categories_access`)) ORDER BY `a`.`ordering`
·
Tuesday, 22 March 2016 01:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Pierre,

It seems like I also can't able to login in your site, and keep hitting this following error :
The most recent request was denied because it contained an invalid security token. Please refresh the page and try again.


Based on the error message, it actually stored the user session in your database and never logged out before, so I unable to login in your user account in frontend, then I found out the reason it keep stored that user session is because of your cache.

I temporary disable with your cache settings from backend > system > global configuration > system > cache setting to NO, and disabled with your cache plugin (system - page cache).

After cleared the cache, the login is work fine now.

--------------------------------------------------------------------------
I found out the reason why you hitting that that second error message after login is because this user "hl7news" do not assign under any Easysocial profile type then throw this error.

In my suggestion, it would be best if you can create a new user through your site frontend or backend so this error will not happen again.

Hope this help.
·
Tuesday, 22 March 2016 12:44
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post