error: Datenbankfehler: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'C114' in 'where clause': update z75134_fields set count_new = (select count(*) from z75134 where `C114`='C116' and status='new'), count_confirmed = (select count(*) from z75134 where `C114`='C116' and status='confirmed'), count_cancelled = (select count(*) from z75134 where `C114`='C116' and status='cancelled'), count_waiting = (select count(*) from z75134 where `C114`='C116' and status='waiting') where id=126