No Clustering, getting "unknown column" errors
| Project: | Memetracker |
| Version: | 6.x-1.1-alpha6 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
My memes aren't clustering...I'm guessing it has to do with these errors.... Suggestions?
# user warning: Unknown column 'search_score' in 'field list' query: SELECT cid1, search_score FROM trac_machinelearningapi_distance_cache WHERE cid1 in ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131') AND cid2 = 1 in /home/windyc/sites/windycitizen.com/public/trackers/sites/all/modules/memetracker/machine_learning_api.inc on line 269.
# user warning: Unknown column 'search_score' in 'field list' query: SELECT cid2, search_score FROM trac_machinelearningapi_distance_cache WHERE cid2 in ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131') AND cid1 = 1 in /home/windyc/sites/windycitizen.com/public/trackers/sites/all/modules/memetracker/machine_learning_api.inc on line 272.
# user warning: Unknown column 'search_score' in 'field list' query: SELECT cid1, search_score FROM trac_machinelearningapi_distance_cache WHERE cid1 in ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131') AND cid2 = 2 in /home/windyc/sites/windycitizen.com/public/trackers/sites/all/modules/memetracker/machine_learning_api.inc on line 269.
# user warning: Unknown column 'search_score' in 'field list' query: SELECT cid2, search_score FROM trac_machinelearningapi_distance_cache WHERE cid2 in ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131') AND cid1 = 2 in /home/windyc/sites/windycitizen.com/public/trackers/sites/all/modules/memetracker/machine_learning_api.inc on line 272.
# user warning: Unknown column 'search_score' in 'field list' query: SELECT cid1, search_score FROM trac_machinelearningapi_distance_cache WHERE cid1 in ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131') AND cid2 = 3 in /home/windyc/sites/windycitizen.com/public/trackers/sites/all/modules/memetracker/machine_learning_api.inc on line 269.
#1
huh -- it looks like the search_score column was deleted. Can you browse your database and see if in the "machinelearningapi_distance_cache" table that the search_score column is still there?