Joseph H Posted May 2, 2019 Report Share Posted May 2, 2019 This is the same client, and all names point to the same profile and client number. Quote Link to comment Share on other sites More sharing options...
Paul Posted May 2, 2019 Report Share Posted May 2, 2019 Does the client have any contacts? What version of Blesta? What version of the widget? Quote Link to comment Share on other sites More sharing options...
Joseph H Posted May 2, 2019 Author Report Share Posted May 2, 2019 installed Version 4.5.2 System Overview 1.7.0 The client has no contacts Quote Link to comment Share on other sites More sharing options...
Joseph H Posted May 4, 2019 Author Report Share Posted May 4, 2019 Second Occurance Quote Link to comment Share on other sites More sharing options...
Tyson Posted May 7, 2019 Report Share Posted May 7, 2019 If that happens again, can you run the following query and look for any duplicates under the `user_id` column? SELECT `l1`.* FROM `log_users` AS `l1` INNER JOIN ( SELECT `log_users`.*, MAX(`log_users`.`date_updated`) AS `date_logged` FROM `log_users` WHERE `log_users`.`result` = 'success' GROUP BY `log_users`.`user_id` ) AS `online` ON `l1`.`user_id` = `online`.`user_id` AND `l1`.`date_updated` = `online`.`date_logged` LEFT JOIN `staff` ON `staff`.`user_id` = `l1`.`user_id` LEFT JOIN `clients` ON `clients`.`user_id` = `l1`.`user_id` LEFT JOIN `contacts` ON `contacts`.`client_id` = `clients`.`id` AND `contacts`.`contact_type` = 'primary' LEFT JOIN `contacts` AS `contacts2` ON `contacts2`.`user_id` = `l1`.`user_id` WHERE `l1`.`company_id` = 1 ORDER BY `l1`.`date_updated` DESC LIMIT 15; Are there duplicates? Is the entire record duplicate (all fields identical) between those with the same `user_id`? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.