This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "FusionForge".
The branch, Branch_5_3 has been updated
via 86f03e2b69016e2e3c5b73fbc96a951a10d4bd0f (commit)
from 67b74e71802a7a57d9f0991c91259ab123108843 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit 86f03e2b69016e2e3c5b73fbc96a951a10d4bd0f
Author: Sylvain Beucler <[email protected]>
Date: Wed May 21 12:10:45 2014 +0200
Forum: fix FK errors when saving position
diff --git a/src/db/20140521-fix-forum_saved_place-fk.sql
b/src/db/20140521-fix-forum_saved_place-fk.sql
new file mode 100644
index 0000000..b619f61
--- /dev/null
+++ b/src/db/20140521-fix-forum_saved_place-fk.sql
@@ -0,0 +1,6 @@
+-- 'forum' confusingly stores forum messages, not forums.
+-- 'forum_saved_place' references forum, not forum messages.
+-- The following fixes errors such as:
+-- Forum::savePlace() : ERROR: insert or update on table "forum_saved_place"
violates foreign key constraint "forum_saved_place_forum_id_fkey" DÉTAIL : Key
(forum_id)=(10462) is not present in table "forum".
+ALTER TABLE forum_saved_place DROP CONSTRAINT forum_saved_place_forum_id_fkey;
+ALTER TABLE forum_saved_place ADD FOREIGN KEY (forum_id) REFERENCES
forum_group_list (group_forum_id) ON DELETE CASCADE ON UPDATE CASCADE;
-----------------------------------------------------------------------
Summary of changes:
src/db/20140521-fix-forum_saved_place-fk.sql | 6 ++++++
1 file changed, 6 insertions(+)
create mode 100644 src/db/20140521-fix-forum_saved_place-fk.sql
hooks/post-receive
--
FusionForge
_______________________________________________
Fusionforge-commits mailing list
[email protected]
http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-commits
