ChangeLog update for 2.14 + some minor upgrade fixes

3 files changed, 6 insertions, 4 deletions

diff --git a/ChangeLog b/ChangeLog
index 84aafaec..0fce0942 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,4 +1,4 @@
-2.14 - ?
+2.14 - 2010-11-28
 	- Improved filter selection interface for the release and VN browser
 	- New release filters: voiced, animation and original language
 	- New VN filters: length, "has anime" and original language
@@ -16,7 +16,6 @@
 	- Use word-level (instead of character-level) diff for large fields
 	- Extended IE6 warning message to show up for IE7 as well
 
-
 2.13 - 2010-11-11
 	- Added 'formcode' parameter to all modification requests to fix all
 	  cross-site request forgery vulnerabilities
diff --git a/Makefile b/Makefile
index 8496bd9f..333d5add 100644
--- a/Makefile
+++ b/Makefile
@@ -149,7 +149,7 @@ update-2.13: all
 	$(multi-start)
 
 update-2.14: all
-	rm static/s/script.js
+	rm -f static/f/script.js
 	$(multi-stop)
 	${runpsql} < util/updates/update_2.14.sql
 	$(multi-start)
diff --git a/util/updates/update_2.14.sql b/util/updates/update_2.14.sql
index 2233e0a8..ea06e689 100644
--- a/util/updates/update_2.14.sql
+++ b/util/updates/update_2.14.sql
@@ -1,6 +1,5 @@
 
 -- add vn.c_olang
-
 ALTER TABLE vn ADD COLUMN c_olang language[] NOT NULL DEFAULT '{}';
 
 
@@ -8,6 +7,10 @@ ALTER TABLE vn ADD COLUMN c_olang language[] NOT NULL DEFAULT '{}';
 \i util/sql/func.sql
 
 
+-- regenerate vn.c_* columns
+SELECT COUNT(*) FROM (SELECT update_vncache(id) FROM vn WHERE NOT hidden) s;
+
+
 -- redefine the triggers to use the new conditional triggers in PostgreSQL 9.0
 
 DROP TRIGGER hidlock_update ON vn;