Member Approval

[martyn4000]

I have installed the member approval but when i goto the customers part of my admin i get the error

 

 

1054 - Unknown column 'member_level' in 'where clause'

 

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where member_level = '0'

 

[TEP STOP]

 

can anyone help

[martyn4000]

I have installed the member approval but when i goto the customers part of my admin i get the error

1054 - Unknown column 'member_level' in 'where clause'

 

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where member_level = '0'

 

[TEP STOP]

 

can anyone help

 

 

please help

[Guest]

I have installed the member approval but when i goto the customers part of my admin i get the error

re-read the installation instructions make sure you do the database part.

[martyn4000]

hi now i get the activate button then confirm button but then i goes back to activate and when i try to login i get the error

 

1054 - Unknown column 'member_level' in 'field list'

 

select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, member_level from customers where customers_email_address = '********@aol.com'

 

[TEP STOP]

[Guest]

it's still the same problem, the contribution you're using should include instructions to update/add some tables/columns to the database. Have you done that part?

 

Otherwise it won't work.