projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Handles canceled payment transactions.
[platal.git]
/
bin
/
cron
/
clean.php
diff --git
a/bin/cron/clean.php
b/bin/cron/clean.php
index
153da31
..
76af55d
100755
(executable)
--- a/
bin/cron/clean.php
+++ b/
bin/cron/clean.php
@@
-1,7
+1,7
@@
#!/usr/bin/php5 -q
<?php
/***************************************************************************
#!/usr/bin/php5 -q
<?php
/***************************************************************************
- * Copyright (C) 2003-201
0
Polytechnique.org *
+ * Copyright (C) 2003-201
4
Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* 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
query('ALTER TABLE profile_job_enum
ORDER BY name');
query('ALTER TABLE profile_langskill_enum
- ORDER BY langu
e_fr
');
+ ORDER BY langu
age
');
query('ALTER TABLE profile_medal_enum
ORDER BY text');
query('ALTER TABLE profile_networking_enum
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)');
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:
?>
?>