Changes between Initial Version and Version 1 of Ticket #817


Ignore:
Timestamp:
11/16/2005 09:44:54 AM (9 years ago)
Author:
hugo
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #817 – Description

    initial v1  
    11When using the registered comments, an SQL is build that produces the following error:
    22
    3 {{{
    43ProgrammingError at /forum/technik/waschmaschinen/miele-superfix/discussion/
    54ERROR: column "SELECT COUNT(*) FROM comments_karma WHERE comments_karma.commen" does not exist SELECT "comments"."id","comments"."user_id","comments"."content_type_id","comments"."object_id","comments"."headline","comments"."comment","comments"."rating1","comments"."rating2","comments"."rating3","comments"."rating4","comments"."rating5","comments"."rating6","comments"."rating7","comments"."rating8","comments"."valid_rating","comments"."submit_date","comments"."is_public","comments"."ip_address","comments"."is_removed","comments"."site_id","auth_users"."id","auth_users"."username","auth_users"."first_name","auth_users"."last_name","auth_users"."email","auth_users"."password_md5","auth_users"."is_staff","auth_users"."is_active","auth_users"."is_superuser","auth_users"."last_login","auth_users"."date_joined","content_types"."id","content_types"."name","content_types"."package","content_types"."python_module_name","packages"."label","packages"."name","sites"."id","sites"."domain","sites"."name",("SELECT COUNT(*) FROM comments_karma WHERE comments_karma.comment_id=comments.id AND score=1") AS "_karma_total_good",("SELECT COUNT(*) FROM comments_karma WHERE comments_karma.comment_id=comments.id AND score=-1") AS "_karma_total_bad" FROM "comments","content_types" "t1","content_types" "t5","auth_users","content_types","packages","sites" WHERE "comments"."content_type_id" = "t1"."id" AND "comments"."content_type_id" = "t5"."id" AND "t1"."package" = 'forum' AND "comments"."site_id" = 1 AND "comments"."object_id" = 3 AND "t5"."python_module_name" = 'groups' AND "comments"."user_id" = "auth_users"."id" AND "comments"."content_type_id" = "content_types"."id" AND "content_types"."package" = "packages"."label" AND "comments"."site_id" = "sites"."id" ORDER BY "comments"."submit_date" ASC
    6 }}}
    75
    86This looks like there is column-quoting even done on computed columns like inner selects.
Back to Top