fluiditystudio

It turns out it is a combination of a plugin or plugins. I tried this on a bare install of WordPress with no other plugins and it worked just fine. So, it must be a plugin or combination of plugins causing the error on the site it is happening to.

I had all the YouTube videos in each video gallery playing just fine until I moved the site from our development server to a live server where an Secure Certificate was installed. Once the site went to “https”, the videos stopped playing. If I debug in the browser I notice the thumbnails from YouTube are https, but the iframed video is showing “http” this throws and error “Blocked loading mixed active content”. Even if I create a new gallery and add the videos again, it is the same result. I thought be created a new gallery on the new https version of the site, then it would fix it, but no luck. HELP!!!

I went into the file where the error is and changed the following line of code at line 200 from

This:
add_filter( ‘upgrader_pre_download’, array( Tribe__PUE__Package_Handler::instance(), ‘filter_upgrader_pre_download’ ), 5, 3 );

To this:
//add_filter( ‘upgrader_pre_download’, array( Tribe__PUE__Package_Handler::instance(), ‘filter_upgrader_pre_download’ ), 5, 3 );

Just add to forward slashes to comment out the line of code causing this issue and it will start working again. At least until they get their crap figured out and fix it.

• This reply was modified 8 years, 1 month ago by fluiditystudio.

The problem seems to be with this line of code in the Checker.php file:

add_filter( ‘upgrader_pre_download’, array( Tribe__PUE__Package_Handler::instance(), ‘filter_upgrader_pre_download’ ), 5, 3 );

When I look for “Tribe__PUE__Package_Handler” or “filter_upgrader_pre_download”, through the plugin folder, I do not see reference to it anywhere but just on line 200 in the checker.php file. It appears that someone didn’t complete the code for this.

• This reply was modified 8 years, 1 month ago by fluiditystudio.

I just reverted back to the previous version for now, but this update is going to crash a TON of sites.

Never mind, I got it myself. I just used the following code from your slm-third-party-integration.php file in your plugins includes folder. It worked perfectly and is storing the extra field data to the “wp_lic_key_tbl” table, since my plugin added the two new fields to the table on activation.

$items = $order->get_items();

foreach ( $items as $item ) {
	$product = $order->get_product_from_item( $item );
	$product_name = $item['name'];
	$product_id = $item['product_id'];
	$variation_id = $item['variation_id'];
	$firstname = $order->billing_first_name;
	$lastname = $order->billing_last_name;
	$email = $order->billing_email;
	$company = $order->billing_company;
	$date = date('Y-m-d');
	$dateExpiry = date('Y-m-d', strtotime('+1 year'));
	
	// retrieve slm key from options
	global $slm_debug_logger;
	global $wpdb;

	$options = get_option('slm_plugin_options');

	$lic_key_prefix = $options['lic_prefix'];

	$fields = array();
	$fields['license_key'] = uniqid($lic_key_prefix);
	$fields['lic_status'] = 'pending';
	$fields['first_name'] = $firstname;
	$fields['last_name'] = $lastname;
	$fields['email'] = $email;
	$fields['company_name'] = $company;
	$fields['txn_id'] = $order_id;
	$fields['product_id'] = $product_id;
	$fields['product_name'] = $product_name;
	$fields['date_created'] = $date;//Today's date
	$fields['max_allowed_domains'] = $license_count; //TODO - later take from estore's product configuration

	$slm_debug_logger->log_debug('Inserting license data into the license manager DB table.');

	$fields = array_filter($fields);//Remove any null values.

	$tbl_name = SLM_TBL_LICENSE_KEYS;

	$result = $wpdb->insert($tbl_name, $fields);

	if(!$result){

		$slm_debug_logger->log_debug('Notice! initial database table insert failed on license key table (User Email: '.$fields['email'].'). Trying again by converting charset', true);
	}
	
}//end foreach item

• This reply was modified 8 years, 1 month ago by fluiditystudio.

Actually I set my plugin on install to create those two columns in your license key table, so those fields are there. I have also added the input fields to the add/edit licenses section per your recently created hook. I can add the product id and name manually through the add/edit section and the data saves and updates. But, getting it to go through on my order completion does not work when using the code I stated above.

The code base is what you supply on your site here, under “Creating license keys on your license manager server”. So, I’m thinking it may have something to do with that code and maybe it having preset fields, so adding mine won’t work. I’m not sure though.

So, I have added my extra field to the “add/edit interface” and upon my plugin activation the filed is added to the database. When I manually create a new key from the “add/edit interface” it works great and my new field data is saved. However, when I try to insert this data upon completion of an order, it does not add the data. I’ve also discovered a while back that when I try to add the company name after a product purchase, that data doesn’t get inserted as well.

Here is the foreach loop that I’m using:

$items = $order->get_items();

foreach($items as $item)
	{
	$product = $order->get_product_from_item($item);

	// echo $item['name'];
	$product_name = $item['name'];
	$product_id = $item['product_id'];
	$variation_id = $item['variation_id'];
	$firstname = $order->billing_first_name;
	$lastname = $order->billing_last_name;
	$email = $order->billing_email;
	$company = $order->billing_company;
	$date = date('Y-m-d');
	$dateExpiry = date('Y-m-d', strtotime('+1 year'));

	// retrieve slm key from options
	$slm_options = get_option('slm_plugin_options');
	$secret_key = $slm_options['lic_creation_secret'];

	// prepare the data
	$api_params = array(
		'slm_action' => 'slm_create_new',
		'secret_key' => $secret_key,
		'first_name' => $firstname,
		'last_name' => $lastname,
		'email' => $email,
		'company_name' => '$company',
		'txn_id' => $order_id,
		'product_id' => $product_id,
		'product_name' => $product_name,
		'max_allowed_domains' => $license_count,
		'date_created' => $date,
		'date_expiry' => $dateExpiry,
	);

	// Send query to the license manager server
	$query = esc_url_raw(add_query_arg($api_params, YOUR_LICENSE_SERVER_URL));
	$response = wp_remote_get($query, array(
		'timeout' => 20,
		'sslverify' => false
	));

	// Check for error in the response
	if (is_wp_error($response))
		{
		echo "Unexpected Error! The query returned with an error.";
		}

	// License data.
	$license_data = json_decode(wp_remote_retrieve_body($response));

} //end foreach item

Out of the info attempted to insert into fields on license creation, the only data that doesn’t get added is “Company Name” as well as my two new fields added “product_id” & “product_name”. I have tested that the data is getting stored in the variables by printing the variables out on order completion. I just can’t figure out why those fields won’t get inserted into the db like the others.

This worked like a charm by the way!

Thank you, this is great!!

That would be perfect! I will need a column to save the data in, but I can always have my plugin add that additional column in the database upon activation.

Thank you!!

Thank you, I set redrawing to “NO” and it worked!!

Ok, so I dove in deeper and found that the exact problem occurs if I move the sidebar from the default right side to the left side in the archive-product.php file. I’m not sure why that would cause a problem.

I tried switching themes and it works. So, it appears there is something in our theme I will need to look at.