Razuna 1.9.6 new install, but sql error with images


#1

I just installed 1.9.6 on Debian 9, with local h2 database. I get SQL errors when trying to edit images, while all other file types are good.

Query Error: Column “SELECTION” not found; SQL statement: SELECT /* 9BAB7BE8C5204AF68238708CC8D5D762detailimg / i.img_id, i.img_group, i.img_publisher, i.img_filename, i.folder_id_r, i.img_custom_id, i.img_online, i.img_owner, i.img_create_date, i.img_create_time, i.img_change_date, i.img_change_time, i.img_filename_org, i.img_filename_org filenameorg, i.thumb_extension, i.path_to_asset, i.cloud_url, i.cloud_url_org, i.img_width orgwidth, i.img_height orgheight, i.img_extension orgformat, i.thumb_width thumbwidth, i.thumb_height thumbheight, i.img_size ilength, i.thumb_size thumblength, i.hashtag, i.img_ranking rank, i.img_single_sale, i. img_is_new, i.img_selection, i.img_in_progress, i.img_alignment, i.img_license, i.img_dominant_color, i.img_color_mode, img_image_type, i.img_category_one, i.img_remarks, i.img_extension, i.shared,i.img_upc_number, i.expiry_date, s.set2_img_download_org, i.link_kind, i.link_path_url, i.img_meta, s.set2_intranet_gen_download, s.set2_url_website,s.set2_custom_file_ext, u.user_first_name, u.user_last_name, fo.folder_name, ‘’ as perm, selection FROM raz1_images i LEFT JOIN raz1_settings_2 s ON s.set2_id = ? AND s.host_id = i.host_id LEFT JOIN users u ON u.user_id = i.img_owner LEFT JOIN raz1_folders fo ON fo.folder_id = i.folder_id_r AND fo.host_id = i.host_id WHERE i.img_id = ? AND i.host_id = ? [42122-196] Datasource: H2 Native Error Code: 42122 SQL State: 42S22 Executing SQL: SELECT / 9BAB7BE8C5204AF68238708CC8D5D762detailimg */ i.img_id, i.img_group, i.img_publisher, i.img_filename, i.folder_id_r, i.img_custom_id, i.img_online, i.img_owner, i.img_create_date, i.img_create_time, i.img_change_date, i.img_change_time, i.img_filename_org, i.img_filename_org filenameorg, i.thumb_extension, i.path_to_asset, i.cloud_url, i.cloud_url_org, i.img_width orgwidth, i.img_height orgheight, i.img_extension orgformat, i.thumb_width thumbwidth, i.thumb_height thumbheight, i.img_size ilength, i.thumb_size thumblength, i.hashtag, i.img_ranking rank, i.img_single_sale, i. img_is_new, i.img_selection, i.img_in_progress, i.img_alignment, i.img_license, i.img_dominant_color, i.img_color_mode, img_image_type, i.img_category_one, i.img_remarks, i.img_extension, i.shared,i.img_upc_number, i.expiry_date, s.set2_img_download_org, i.link_kind, i.link_path_url, i.img_meta, s.set2_intranet_gen_download, s.set2_url_website,s.set2_custom_file_ext, u.user_first_name, u.user_last_name, fo.folder_name, ‘’ as perm, selection FROM raz1_images i LEFT JOIN raz1_settings_2 s ON s.set2_id = ? AND s.host_id = i.host_id LEFT JOIN users u ON u.user_id = i.img_owner LEFT JOIN raz1_folders fo ON fo.folder_id = i.folder_id_r AND fo.host_id = i.host_id WHERE i.img_id = ? AND i.host_id = ? Error occurred while processing element (CFINCLUDE) on line 33 column 1 in template file “/opt/razuna_tomcat_1_9_6/tomcat/webapps/razuna/raz1/dam/index.cfm”


#2

Installed again with a MySQL database, but get a similar error. Still, all other file formats work well.

Query Error: Unknown column ‘selection’ in ‘field list’ Datasource: MYSQL Native Error Code: 1054 SQL State: 42S22 Executing SQL: SELECT /* 94F7CC0D6ECB4022AAEF508F55AAB5F3detailimg */ i.img_id, i.img_group, i.img_publisher, i.img_filename, i.folder_id_r, i.img_custom_id, i.img_online, i.img_owner, i.img_create_date, i.img_create_time, i.img_change_date, i.img_change_time, i.img_filename_org, i.img_filename_org filenameorg, i.thumb_extension, i.path_to_asset, i.cloud_url, i.cloud_url_org, i.img_width orgwidth, i.img_height orgheight, i.img_extension orgformat, i.thumb_width thumbwidth, i.thumb_height thumbheight, i.img_size ilength, i.thumb_size thumblength, i.hashtag, i.img_ranking rank, i.img_single_sale, i. img_is_new, i.img_selection, i.img_in_progress, i.img_alignment, i.img_license, i.img_dominant_color, i.img_color_mode, img_image_type, i.img_category_one, i.img_remarks, i.img_extension, i.shared,i.img_upc_number, i.expiry_date, s.set2_img_download_org, i.link_kind, i.link_path_url, i.img_meta, s.set2_intranet_gen_download, s.set2_url_website,s.set2_custom_file_ext, u.user_first_name, u.user_last_name, fo.folder_name, ‘’ as perm, selection FROM raz1_images i LEFT JOIN raz1_settings_2 s ON s.set2_id = ? AND s.host_id = i.host_id LEFT JOIN users u ON u.user_id = i.img_owner LEFT JOIN raz1_folders fo ON fo.folder_id = i.folder_id_r AND fo.host_id = i.host_id WHERE i.img_id = ? AND i.host_id = ? Error occurred while processing element (CFINCLUDE) on line 33 column 1 in template file “/opt/razuna_tomcat_1_9_6/tomcat/webapps/razuna/raz1/dam/index.cfm”


#3

Hmmm… This is weird. Sorry about that.

Please add a new column with the name “selection” and type “boolean” with default value of 0 (zero) to the images, videos, audios, and files tables.


#4

I’ve also just updated the downloadable version from our website. It might take a while for all cached to get updated.


#5

that solves it. thank you!


#6

though i’m getting xml errors now when trying to download 1.9.6

<Error><Code>AccessDenied</Code><Message>Access Denied</Message><RequestId>1A89A264A5AA6B3A</RequestId><HostId>KKgAA7/m4difP7X1sV7j1kTb5WNWHUZuGTgJoywOCnlOTkH+imORhhS3emmihSR1anq9uKsrotQ=</HostId></Error>


#7

Ah sorry. Permission error. Fixed. You might have to clear the cache.