Anonymous avatar Anonymous committed b685a11

Fixed an error in comment upgrade SQL.

Comments (0)

Files changed (1)

docs/ref/contrib/comments/upgrade.txt

     FROM comments_freecomment;
 
     INSERT INTO django_comments 
-        (content_type_id, object_pk, site_id, user_id, comment, submit_date,
-        ip_address, is_public, is_removed) 
+        (content_type_id, object_pk, site_id, user_id, user_name, user_email,
+        user_url, comment, submit_date, ip_address, is_public, is_removed)
     SELECT 
-        content_type_id, object_id, site_id, user_id, comment, submit_date,
-        ip_address, is_public, is_removed
+        content_type_id, object_id, site_id, user_id, '', '', '', comment,
+        submit_date, ip_address, is_public, is_removed
     FROM comments_comment;
 
     UPDATE django_comments SET user_name = (
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.