Anthony Booth
Forum Replies Created
-
Posts
-
Hello Stiofan,
Thank you for the reply. I’ve had to drop your plugin for WP-Members. I discussed this with my client and it was cheaper for them to buy into that for the MailChimp add-on than it was for me to script a bespoke import routine. WP-Members uses the core wp_usermeta table which integrates with existing import plugins.
Again thank you for your reply.
Regards
AnthonyHello Paolo,
Thank you for replying.
I thought that might be the case, that’s a shame. I will have to write my own script then.Regards
AnthonyI’m assuming from the no reply that you do not have a method to import users with custom meta.
Hello Stiofan,
Thank you for your quick response.
Anthony
Hello Stiofan,
I think your problem is with the placeholder I always use %f %d or %s I have now amended it to the following which works fine:
$fields = $wpdb->get_results($wpdb->prepare(“SELECT * FROM ” . $table_name . ” WHERE form_type = %s AND is_active = ‘1’ AND for_admin_use != ‘1’ AND is_register_only_field = ‘0’ %s ORDER BY sort_order ASC”, array(‘account’, $extra_where)));
Hello Stiofan,
I have found the issue for some reason your $wpdb-prepare statement didn’t like the array on line 79 and 81 in /includes/helpers/forms.php
I took out the array and replaced it with comma separated values “‘account’, $extra_where” and now it works:
$fields = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM ” . $table_name . ” WHERE form_type = ‘%s’ AND is_active = ‘1’ AND is_register_only_field = ‘0’ ” . $extra_where . ” ORDER BY sort_order ASC”, ‘account’, $extra_where ) );
