{"id":19021482,"date":"2026-09-16T11:02:12","date_gmt":"2026-09-16T11:02:12","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/reliance-on-sha1\/"},"modified":"2026-09-16T11:02:12","modified_gmt":"2026-09-16T11:02:12","slug":"reliance-on-sha1","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/reliance-on-sha1\/","title":{"rendered":"Reliance on SHA1"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">When trying to import venues from a CSV file I get error:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>WordPress database error:<\/strong> [FUNCTION wordpress.SHA1 does not exist]<br \/><code>SELECT IS_FREE_LOCK( SHA1( 'tribe_ea_csv_import_434' ) )<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I think this is because the plugin hardcodes the use of database function SHA1 but <a href=\"https:\/\/blogs.oracle.com\/mysql\/mysql-9-x-moving-away-from-sha1-and-md5\">from MYSQL 9.x onwards this function is no longer available<\/a>.<\/p>\n","protected":false},"template":"","class_list":["post-19021482","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/19021482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/19021482\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=19021482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}