customer login error

when customer logs in:

Database error: Unknown column ‘users_conditions_hash’ in ‘where clause’ (1054)

Invalid query: SELECT count(*) FROM cscart_promotions WHERE status = ‘A’ AND zone = ‘catalog’ AND users_conditions_hash LIKE ‘%,4,%’


File: /var/www/vhosts/mysite/httpdocs/core/fn.database.php

Line: 310

Function: db_error

File: /var/www/vhosts/mysite/httpdocs/core/fn.database.php

Line: 132

Function: db_query

File: /var/www/vhosts/mysite/httpdocs/controllers/customer/init.php

Line: 49

Function: db_get_field

File: /var/www/vhosts/mysite/httpdocs/core/fn.control.php

Line: 567

Function: include

File: /var/www/vhosts/mysite/httpdocs/core/fn.control.php

Line: 422

Function: fn_run_controller

File: /var/www/vhosts/mysite/httpdocs/index.php

Line: 28

Function: fn_dispatch

what does all of this mean?

I would guess you are using an addon that is not appropriate for your version (would help if yo told us your version). There is no column named users_conditions_hash, but there is a conditions_hash (version 2.0.15 and 2.1.1).

The error is being generated from a controller (probably an addon)…

version is 2.1.2

site works fine until first customer tries to register. then NOTHING at all works

it’s stock standard fresh install…no addons

It would seem that ‘users_conditions_hash’ was added in 2.1.2.

I have no idea why it would not be created properly. It is created in install/database/scheme.sql.

I’m going to guess that you have a partial 2.1.1 and 2.1.2 archive (or filesystem) that you are installing from.