Woocommerce Custom product fields need to be editable after purchase in View Orders Page

I am Using https://stackoverflow.com/questions/46612499/display-a-custom-field-value-in-woocommerce-orders-edit-view/#answer-46615303 answer code, which works fine.

I want to display that checkout custom fields on My Account > View Order Pages, to allow customer to edit its value after purchase, so Customers can change and save the custom field value.

Any help?

AnyDice: semantics of output headers in “export” view

I hope this is on-topic: In AnyDice, when choosing the "Export" view, output d6 is displayed as:

"output 1",3.5000000000069997,1.707825127661641,1,6 #,% 1,16.6666666667 2,16.6666666667 3,16.6666666667 4,16.6666666667 5,16.6666666667 6,16.6666666667 

I’m not quite sure what the numbers in the first line signify, the last two (1 and 6) are presumably the range of values that the rolls can take on but what about the other two (3.5 and 1.7…)? I have not been able to figure this out from the documentation.

MariaDB views: I want to replace repeated multi-table joins in my queries with a view – are there any issues to watch out for?

Rather than

SELECT a.pk, b.pk, c.pk, d.name  FROM a JOIN b on b.pk = a.fk JOIN c on c.pk = b.fk JOIN d on d.pk = c.fk 

I can do

SELECT a_pk, b_pk, c_pk, d_name  FROM view_a_b_c_d 

I have a lot of this sort of thing through my code.

I’ve done a performance test, and the differences seem to be negligible, and I feel it would greatly tidy my codebase up and remove a lot of repetition.

But before I commit to that (as it’d be a big change with a lot of work and testing), I want to check that this IS a good thing to do. I didn’t study computer science and have no formal DBA training. I’m also a sole dev working on my own closed-source product. So I don’t get much input from the outside world, unless I strike out and ask for it.

Thank you – any opinions/experience appreciated.

MSSQL – Incapacity to query underlying table of a schemabound view

I migrated a database from SQL Server 2008R2 to SQL Server 2019 (both enterprise edition) using backup-restore technique and a set of post-transfer actions like DBCC UPDATEUSAGE or UPDATE STATISTICS XXX

At statistics update, I get following error:

Msg 402, Level 16, State 1, Procedure ZZZZ, Line 5 [Batch Start Line 0] The data types datetime and time are incompatible in the add operator. Msg 4413, Level 16, State 1, Line 1 Could not use view or function 'ZZZZ' because of binding errors. 

I know that the message is quite explicit (the view, which was syntactically correct in MSSQL 2008R2 is not anymore in MSSQL 2019) but I don’t understand why would a view defined WITH SCHEMABINDING that is not valid would prevent the update of statistics on an underlying table.

Moreover, I get the same error message when querying the underlying table with a WHERE clause, except if I force a FULLSCAN with following hint:


I know SQL Server will fire an error in case of DDL change to underlying schema-bound objects, but I don’t understand why, if the view is invalid, the underlying objects cannot be used as usual. I’m sure there is an explanation (like the protection mechanisms for schema-bound views cannot be processed due to the invalidity of the view), but I can’t find it for sure in MS documentation…

Trouble diagnosing an AdSense Viewability / Active View issue

I’m having a viewability issue with a vertical Adsense placement (300×600 and under).

It’s a pretty standard above-the-fold, right column placement. The top of the placement starts around 200 px from the top of the browser window, so it’s a very visible placement. Easily the most visible on the site for desktop users.

The placement is hidden in mobile (by hiding the parent per current AdSense regulations) and doesn’t serve to mobile devices. (This is tested and confirmed, btw… so that’s not the issue).

The placement is currently scoring a meager 30% Active View in AdSense reports, which means it’s serving and not being seen — a lot.

Where else should I be looking to diagnose this problem? I’m pretty sure the viewability issue is negatively impacting RPM.

The site has excellent traction, with over 6 ppv and an average pageview time of nearly 1 minute. The bounce rate is a very healthy 33%. The CWV on the page are all healthy (Rather, as healthy as can be expected with a site running AdSense).

Anyone familiar with viewability / active view issues? Any thoughts on where else the issue could lie?


Google Analytics: View filter not picking up any traffic

I have created a new view (a copy of the main one) and set a filter as follows:

enter image description here

However, if I visit any URL with that inside of it, nothing gets picked up on the real-time view. However it does get picked up on the main view, where there are no filters.

I can’t click on the verify link as it’s saying the service isn’t available

Any ideas?

Where does elementor stores the data from the content that is created from the frontend view? [closed]

I am trying to change a value/text in an inner section created by elementor page builder plugin that exists on around 400 pages. I have edited the database (wp_posts) with the right values but it’s not changed on the front end. The values are still the old values on the pages. It almost seems like something is being cached somewhere, but I do not have any caching currently enabled.

If I completely disable elementor and elementor pro. The correct values are shown. If I re-enable elementor the old incorrect values are shown again.

Does anyone know where does elementor stores the data from the content that is created from the frontend view? In the database (where?) in files? (where?) Thanks so much!!

Password entry: are “paste from password manager” and “eyeball to view passwords” mutually-exclusive features?


NIST SP 800-63b gives the following guidance for password forms (aka login pages):

Verifiers SHOULD permit claimants to use “paste” functionality when entering a memorized secret. This facilitates the use of password managers, which are widely used and in many cases increase the likelihood that users will choose stronger memorized secrets.

In order to assist the claimant in successfully entering a memorized secret, the verifier SHOULD offer an option to display the secret — rather than a series of dots or asterisks — until it is entered. This allows the claimant to verify their entry if they are in a location where their screen is unlikely to be observed. The verifier MAY also permit the user’s device to display individual entered characters for a short time after each character is typed to verify correct entry. This is particularly applicable on mobile devices.

I had the argument made to me that these two features should not be implemented together because they would allow a user to circumvent a password manager’s protection and view the auto-populated password. I suspect this argument won’t hold water, but I’m curious about community opinions.

Why is my view selecting hundreds of duplicates?

This view selects 696 entries. The CSV file has 48 entries.

CREATE OR REPLACE VIEW insert_3_char_abts AS SELECT     ext.construct_id,     n_term,     enz_name,     c_term,     cpp,     mutations,     ext.g_batch,     ext.p_batch,     emptycol,          c_batch,     abts5_mean,     abts5_SD,     abts5_n,     abts5_method,     abts5_study_id,     abts7_mean,     abts7_SD,     abts7_n,     abts7_method,     abts7_study_id,     pur.pk_purified_enz_id FROM EXTERNAL ((        construct_id NUMBER(10),       n_term VARCHAR2 (50),       enz_name VARCHAR2 (50),       c_term VARCHAR2 (50),       cpp VARCHAR2 (50),       mutations VARCHAR2 (50),       g_batch VARCHAR2 (50),       p_batch VARCHAR2 (50),       emptycol VARCHAR2(50),        c_batch VARCHAR2 (50),       abts5_mean NUMBER (5, 2),       abts5_SD NUMBER (5, 2),       abts5_n NUMBER (3),       abts5_method VARCHAR2 (50),       abts5_study_id VARCHAR2 (8),       abts7_mean NUMBER (5, 2),       abts7_SD NUMBER (5, 2),       abts7_n NUMBER (3),       abts7_method VARCHAR2 (50),       abts7_study_id VARCHAR2 (8))            TYPE ORACLE_LOADER     DEFAULT DIRECTORY data_to_input     ACCESS PARAMETERS (         RECORDS DELIMITED BY NEWLINE          SKIP 1         BADFILE bad_files:'badflie_view_before_insert_char_abts.bad'         FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'         MISSING FIELD VALUES ARE NULL          )      LOCATION ('CHAR_ABTS.CSV')     REJECT LIMIT UNLIMITED) ext  INNER JOIN purified_enz pur ON ext.p_batch = pur.p_batch INNER JOIN produced pr  ON pr.pk_produced_id = pur.fk_produced_id; ; 

If I finish this statement with

AND pr.fk_construct_id = ext.construct_id; 

It selects 46 out of 48 records, which is better, but not great.