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,%’
Backtrace:
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.