Title: petervnv's Replies | WordPress.org

---

# petervnv

  [  ](https://wordpress.org/support/users/petervnv/)

 *   [Profile](https://wordpress.org/support/users/petervnv/)
 *   [Topics Started](https://wordpress.org/support/users/petervnv/topics/)
 *   [Replies Created](https://wordpress.org/support/users/petervnv/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/petervnv/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/petervnv/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/petervnv/engagements/)
 *   [Favorites](https://wordpress.org/support/users/petervnv/favorites/)

 Search replies:

## Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Register Plus Redux] where in wordpress database does RPR store custom fields?](https://wordpress.org/support/topic/where-in-wordpress-database-does-rpr-store-custom-fields/)
 *  Thread Starter [petervnv](https://wordpress.org/support/users/petervnv/)
 * (@petervnv)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/where-in-wordpress-database-does-rpr-store-custom-fields/#post-4456527)
 * OK, my question boils down to this.
 * I need 2 custom fields for registration that the user neither sees nor inputs
   anything. (alt_id and alt_pass)
    alt_id must be an integer between 1000 amd 9999,
   alt_pass is a random 8 character password. Now I have created a table in wp named
   alt_table where I created columns alt_id and alt_pass and have already populated
   them.
 * What I would like to figure out how to do, is have RPR update the (initially 
   blank I presume since they’re hidden from the registering user) user_meta fields
   alt_id and alt_pass with the values already existing in the alt_table.
 * Is this possible? I’ve been looking into RPR sourcecode but I’m getting overwhelmed.
 * Conceptually I think that somewhere in rpr_activate.php or rpr_signup.php, it
   should be possible to run a mysql query like $wpdb->get_var(“SELECT alt_pass 
   FROM alt_table WHERE user_id = ‘current user or whatever’ “) and do the same 
   to grab alt_id, then use those values to run update_user_meta once the account
   has been activated.
 * Is my thinking correct or am I way off base here?
 * Any help or pointers much appreciated.
 * Thanks and Happy New Year
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Connect Matomo - Analytics Dashboard for WordPress] Tracking doesn't work](https://wordpress.org/support/topic/tracking-doesnt-work/)
 *  [petervnv](https://wordpress.org/support/users/petervnv/)
 * (@petervnv)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/tracking-doesnt-work/#post-4441513)
 * Yeah, I know. Separate things.
 * Thanks for your help with the plugin.
 * Cheers
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Connect Matomo - Analytics Dashboard for WordPress] Tracking doesn't work](https://wordpress.org/support/topic/tracking-doesnt-work/)
 *  [petervnv](https://wordpress.org/support/users/petervnv/)
 * (@petervnv)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/tracking-doesnt-work/#post-4441511)
 * Hi,
 * Disabling caching indeed fixed the wp error message on the plugin.
 * Now I still have the remaining problem that piwik appears to not work for me 
   at all. I think it’s a compatibility issue between my (super) recent version 
   of MySQL and what piwik expects.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Connect Matomo - Analytics Dashboard for WordPress] Tracking doesn't work](https://wordpress.org/support/topic/tracking-doesnt-work/)
 *  [petervnv](https://wordpress.org/support/users/petervnv/)
 * (@petervnv)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/tracking-doesnt-work/#post-4441507)
 * I see the following error message when I run system check:
 * Error:
    Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification:
   1045 Access denied for user ‘piwik’@’localhost’ (using password: YES)[28000],
   Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation:
   1148 The used command is not allowed with this MySQL version[42000]
 * I’m using MySQL version 5.5.33 and PHP 5.5.7 on Debian Wheezy. Pretty sure the
   password is OK but I will recheck
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Connect Matomo - Analytics Dashboard for WordPress] Tracking doesn't work](https://wordpress.org/support/topic/tracking-doesnt-work/)
 *  [petervnv](https://wordpress.org/support/users/petervnv/)
 * (@petervnv)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/tracking-doesnt-work/#post-4441506)
 * I have the same problem. Using WP 3.8
 * When I add the API key and click save, I get the message:
    An error occured: 
   Please check URL and auth token. You need at least view access to one site.
 * Now I’m pretty sure my url and api key are correct. I enabled auto-config and
   I see there are two blogs (I only have one) with the exact same name in my Piwik
   dashboard, but both show 0 traffic.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Register Plus Redux] where in wordpress database does RPR store custom fields?](https://wordpress.org/support/topic/where-in-wordpress-database-does-rpr-store-custom-fields/)
 *  Thread Starter [petervnv](https://wordpress.org/support/users/petervnv/)
 * (@petervnv)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/where-in-wordpress-database-does-rpr-store-custom-fields/#post-4456404)
 * Answering (partially) my own question, I see that RPR stores custom fields in
   wp_usermeta table.
 * Is it possible for RPR to grab data from my own custom field, even if it’s in
   wp_users table, and insert that data into the new user welcome email?
 * Or, alternatively, I could use another plugin to fire off a custom welcome email
   after the RPR one has been sent.
 * Unfortunately this seems to cause a conflict in RPR because it is already hooked
   into wp_new_user_notification. Any help or ideas on how to get this done?

Viewing 6 replies - 1 through 6 (of 6 total)