An exception occurred in shop's script

  • Error type: MySQL Error
  • Source, line: Parser::tws_shop_index[59]
  • Error message: Table 'knigovo.ms_client_field_set' doesn't exist
 SELECT c.id, cfs_info_set.code AS info_code, IF(cfv_active_set.code = 'partner-active-1', 1, 0) AS active
                FROM ms_client c
                    LEFT JOIN ms_client_field cfv_info
                        ON cfv_info.client_id = c.id
                            AND cfv_info.field_id = ( SELECT id FROM ms_field WHERE skey = 'partner-info' )
                    LEFT JOIN ms_client_field_set cfs_info_set
                        ON cfs_info_set.name = cfv_info.value_txt
                            AND cfs_info_set.field_id = cfv_info.field_id
                    LEFT JOIN ms_client_field cfv_active
                        ON cfv_active.client_id = c.id
                            AND cfv_active.field_id = ( SELECT id FROM ms_field WHERE skey = 'partner-active' )
                    LEFT JOIN ms_client_field_set cfv_active_set
                        ON cfv_active_set.name = cfv_active.value_txt
                            AND cfv_active_set.field_id = cfv_active.field_id
                    WHERE c.id = '19757'