{"action":"created","issue":{"url":"https://api.github.com/repos/wpninjas/ninja-forms/issues/2366","repository_url":"https://api.github.com/repos/wpninjas/ninja-forms","labels_url":"https://api.github.com/repos/wpninjas/ninja-forms/issues/2366/labels{/name}","comments_url":"https://api.github.com/repos/wpninjas/ninja-forms/issues/2366/comments","events_url":"https://api.github.com/repos/wpninjas/ninja-forms/issues/2366/events","html_url":"https://github.com/wpninjas/ninja-forms/issues/2366","id":203750285,"number":2366,"title":"Field data not exporting","user":{"login":"Much2tall","id":18430110,"avatar_url":"https://avatars.githubusercontent.com/u/18430110?v=3","gravatar_id":"","url":"https://api.github.com/users/Much2tall","html_url":"https://github.com/Much2tall","followers_url":"https://api.github.com/users/Much2tall/followers","following_url":"https://api.github.com/users/Much2tall/following{/other_user}","gists_url":"https://api.github.com/users/Much2tall/gists{/gist_id}","starred_url":"https://api.github.com/users/Much2tall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Much2tall/subscriptions","organizations_url":"https://api.github.com/users/Much2tall/orgs","repos_url":"https://api.github.com/users/Much2tall/repos","events_url":"https://api.github.com/users/Much2tall/events{/privacy}","received_events_url":"https://api.github.com/users/Much2tall/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-01-27T21:56:42Z","updated_at":"2017-01-30T13:15:24Z","closed_at":null,"body":"assumption is that db tables with non-standard prefixes are causing the export to fail\r\n\r\nreproduce:\r\ncreate wp install, rename db tables to non-standard prefixes, create a form, submit data, export the record."},"comment":{"url":"https://api.github.com/repos/wpninjas/ninja-forms/issues/comments/276059636","html_url":"https://github.com/wpninjas/ninja-forms/issues/2366#issuecomment-276059636","issue_url":"https://api.github.com/repos/wpninjas/ninja-forms/issues/2366","id":276059636,"user":{"login":"raykimsey","id":25409297,"avatar_url":"https://avatars.githubusercontent.com/u/25409297?v=3","gravatar_id":"","url":"https://api.github.com/users/raykimsey","html_url":"https://github.com/raykimsey","followers_url":"https://api.github.com/users/raykimsey/followers","following_url":"https://api.github.com/users/raykimsey/following{/other_user}","gists_url":"https://api.github.com/users/raykimsey/gists{/gist_id}","starred_url":"https://api.github.com/users/raykimsey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raykimsey/subscriptions","organizations_url":"https://api.github.com/users/raykimsey/orgs","repos_url":"https://api.github.com/users/raykimsey/repos","events_url":"https://api.github.com/users/raykimsey/events{/privacy}","received_events_url":"https://api.github.com/users/raykimsey/received_events","type":"User","site_admin":false},"created_at":"2017-01-30T13:15:24Z","updated_at":"2017-01-30T13:15:24Z","body":"Same problem here. I updated Submission.php with the prefix to access non-standard named table #2368 but still did not solve the issue with the export to csv as referenced above.\r\n\r\nI tried updating my Submission.php with the change to the line:\r\n\r\nSELECT id FROM {$wpdb->prefix}_nf3_fields\r\n\r\nThis still does not solve the problem for me. Replacing the following code with previous code with the previous allows me to export properly.  Thanks for your help... also see other comments in #2368\r\n\r\n$field_values = $wpdb->get_col( \"\r\nSELECT IFNULL( meta_value, '' )\r\nFROM \". $wpdb->postmeta . \" as postmeta\r\nRIGHT JOIN (\r\nSELECT id FROM {$wpdb->prefix}_nf3_fields\r\nWHERE id IN ( \" . implode( ',', $fields_order_by ) . \" )\r\nORDER BY FIELD( id, \" . implode( ',', $fields_order_by ) . \" )\r\n) as fields\r\nON postmeta.meta_key LIKE CONCAT( '%', fields.id, '%' )\r\nAND postmeta.post_id = \" . $sub->get_id() );\r\n"}}
{"actor":{"display_login":"raykimsey"}}