Search code examples
mysqlauthenticationexpressionengine

Expression Engine Login problems

I have been able to do this for a while now but it seems to have stop all of a sudden. Here goes:

When I login to expression engine at the backend - I cannot login to the front end with the same credentials - I get the following message:

MySQL ERROR:

Error Number: 1054

Description: Unknown column 'username' in 'where clause'

Query: 

SELECT count(*) AS count 
FROM exp_password_lockout 
WHERE 
  login_date > 1384272605 AND 
  ip_address = 'xx.xx.xx.xx' AND (
    user_agent = 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/53' OR 
    username = 'admin' 
  )

The same thing happens visa versa (When I can login to the the front end but not the back end).

Please help

Solution

  • The error below is known as Bad Field Error:

    Unknown column '%s' in '%s'

    So that means that some column refenced in the query was not found on any table of the same query. In order to reference a field in a SQL query, that field must be in a referenced table or the engine will throw that exception.

    So double check if your table has that field, probably you'll realize that it does not.

    I hope this helps.