[jira] [Closed] (CLOUDSTACK-3353) The templates button is error, when i click the templates button the system is not right.

["terryye (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

terryye closed CLOUDSTACK-3353.
-------------------------------

       Resolution: Fixed
    Fix Version/s: 4.2.0
    
> The templates button is error, when i click the templates button the system is not right.
> -----------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-3353
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3353
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Management Server
>    Affects Versions: 4.2.0
>         Environment: ubuntu 12.04 kvm
>            Reporter: terryye
>             Fix For: 4.2.0
>
>
> when i click the templates button.
> It type a window. 
> DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@5dda7d56: SELECT template_view.id, template_view.uuid, template_view.unique_name, template_view.name, template_view.format, template_view.public, template_view.featured, template_view.type, template_view.url, template_view.hvm, template_view.bits, template_view.created, template_view.created_on_store, template_view.removed, template_view.checksum, template_view.display_text, template_view.enable_password, template_view.guest_os_id, template_view.guest_os_uuid, template_view.guest_os_name, template_view.bootable, template_view.prepopulate, template_view.cross_zones, template_view.hypervisor_type, template_view.extractable, template_view.source_template_id, template_view.source_template_uuid, template_view.template_tag, template_view.sort_key, template_view.enable_sshkey, template_view.account_id, template_view.account_uuid, template_view.account_name, template_view.account_type, template_view.domain_id, template_view.domain_uuid, template_view.domain_name, template_view.domain_path, template_view.project_id, template_view.project_uuid, template_view.project_name, template_view.data_center_id, template_view.data_center_uuid, template_view.data_center_name, template_view.store_scope, template_view.store_id, template_view.download_state, template_view.download_pct, template_view.error_str, template_view.size, template_view.destroyed, template_view.lp_account_id, template_view.detail_name, template_view.detail_value, template_view.tag_id, template_view.tag_uuid, template_view.tag_key, template_view.tag_value, template_view.tag_domain_id, template_view.tag_account_id, template_view.tag_resource_id, template_view.tag_resource_uuid, template_view.tag_resource_type, template_view.tag_customer, template_view.state, template_view.temp_zone_pair FROM template_view WHERE template_view.account_type != 5 AND template_view.hypervisor_type IN ('KVM','KVM') AND template_view.format != 'ISO' AND template_view.removed IS NULL ORDER BY template_view.sort_key DESC LIMIT 0, 20

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira