X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fclean.php;h=76af55dd748d601cf7ad33105e1749a3987b5450;hb=3424387cde6c635ff16c3b5459c4caa88bb76e2e;hp=153da31f98dbeafd5808ebf98de8a43456698d0c;hpb=245923e335d0da5bec9495991a7846be9f0563ab;p=platal.git

diff --git a/bin/cron/clean.php b/bin/cron/clean.php
index 153da31..76af55d 100755
--- a/bin/cron/clean.php
+++ b/bin/cron/clean.php
@@ -1,7 +1,7 @@
 #!/usr/bin/php5 -q
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2010 Polytechnique.org                              *
+ *  Copyright (C) 2003-2014 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -48,7 +48,7 @@ query('ALTER TABLE  profile_education_field_enum
 query('ALTER TABLE  profile_job_enum
           ORDER BY  name');
 query('ALTER TABLE  profile_langskill_enum
-          ORDER BY  langue_fr');
+          ORDER BY  language');
 query('ALTER TABLE  profile_medal_enum
           ORDER BY  text');
 query('ALTER TABLE  profile_networking_enum
@@ -62,5 +62,9 @@ query('ALTER TABLE  profile_skill_enum
 query('DELETE FROM  search_autocomplete
              WHERE  generated < DATE_SUB(NOW(), INTERVAL 1 DAY)');
 
-// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
+// XXX: cleans profile_merge_issues (to be removed once all merge related issues have been fixed)
+query('DELETE FROM  profile_merge_issues
+             WHERE  issues IS NULL OR issues = \'\'');
+
+// vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8:
 ?>