Author: russellm
Date: 2008-08-28 06:43:54 -0500 (Thu, 28 Aug 2008)
New Revision: 8653

Modified:
   django/trunk/docs/ref/contrib/comments/upgrade.txt
Log:
Fixed #8583: Modified the migration SQL described in the comments upgrade docs 
to account for a problem found with freecomments using Postgres. Thanks to 
rajeshd for the report.

Modified: django/trunk/docs/ref/contrib/comments/upgrade.txt
===================================================================
--- django/trunk/docs/ref/contrib/comments/upgrade.txt  2008-08-28 11:39:27 UTC 
(rev 8652)
+++ django/trunk/docs/ref/contrib/comments/upgrade.txt  2008-08-28 11:43:54 UTC 
(rev 8653)
@@ -62,10 +62,10 @@
     UPDATE django_comments SET user_name = (
         SELECT username FROM auth_user 
         WHERE django_comments.user_id = auth_user.id
-    );
+    ) WHERE django_comments.user_id is not NULL;
     UPDATE django_comments SET user_email = (
         SELECT email FROM auth_user 
         WHERE django_comments.user_id = auth_user.id
-    );
+    ) WHERE django_comments.user_id is not NULL;
     
     COMMIT;


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to