Support » Fixing WordPress » use stored procedure in WordPress

  • Hi there,
    I really would like to perform a stored procedure in MySQL which updates the wp_bp_xprofile_data table with information from a view in MySQL. The procedure should be started when somebody updates his profile. This is the code I use in bp-custom.php.

    function something_updated_profile() {
      $wpdb->query("CALL dekking_ophalen( )");
    add_action('xprofile_updated_profile', 'something_updated_profile');

    However, when I update my profile I only see a white page ( I have debugger enabled). After doing some research on the buddypress forums I am pretty sure that the error I make is in the $wpdb->query(“CALL dekking_ophalen( )”); line. I use wordpress 3.9.1 & bp 2.0.1. The stored procedure is stated as:

    INSERT INTO wp_bp_xprofile_data
    ( field_id,  user_id, value )
    SELECT 15, User,  dekking_absoluut
    FROM  dekking
    On duplicate KEY UPDATE
    wp_bp_xprofile_data.value=(SELECT dekking.dekking_absoluut
      FROM dekking
      WHERE dekking.user=wp_bp_xprofile_data.user_id )

    This stored procedure doesn’t need to give any results, it just have to perform an update on a table. What point am I missing here?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Have you checked your servers error logs?

    Hi craig,
    Thanks for your question…i’m not really sure what you mean, but i looked at the c-panel of my hosting provider en there where no logs to be found (all where empty). i also added

    // Enable WP_DEBUG mode
    define('WP_DEBUG', true);
    // Enable Debug logging to the /wp-content/debug.log file
    define('WP_DEBUG_LOG', true);
    // Disable display of errors and warnings
    define('WP_DEBUG_DISPLAY', false);

    to my config file and tried the code a couple of times, but i didn’t find the debug.log file. any idea of what i am doing wrong? Thanks!

    Please take a look at the Codex to see how you should prepare your statement.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘use stored procedure in WordPress’ is closed to new replies.