Elementor + W3C Validator: “Attribute alt not allowed on element div at this point” for all photo gallery items [closed]

I am trying to validate my Elementor-built website using W3C Validator (https://validator.w3.org/nu) but when it comes for a page containing a photo gallery (Elementor Gallery Pro widget), I get the error:

Error: Attribute alt not allowed on element div at this point.

Obviously, Elementor applies the alt attribute to the div containing the image rather than the image itself, so this error is produced.

Any ideas how to fix it?

Thanks in advance!

Why is this IN-clause with subquery materialization slow?

Can someone help me explain why the performance of the two queries are so vastly different? (Setup-Code is at the end, DB-Fiddle is here: https://www.db-fiddle.com/f/eEuPWqR6gZcjbeSeWk4tu2/0)

1.

select id from texts WHERE id not in (select doc_id from details); 
select id from texts WHERE not exists (select 1 from details where details.doc_id=texts.id) 

When running the query select id from texts WHERE id not in (select doc_id from details); the query seems to run "forever". The query plan looks like this:

                                     QUERY PLAN                                      ------------------------------------------------------------------------------------  Gather  (cost=1000.00..3703524012.67 rows=400000 width=8)    Workers Planned: 2    ->  Parallel Seq Scan on texts  (cost=0.00..3703483012.67 rows=166667 width=8)          Filter: (NOT (SubPlan 1))          SubPlan 1            ->  Materialize  (cost=0.00..20220.86 rows=799991 width=8)                  ->  Seq Scan on details  (cost=0.00..13095.91 rows=799991 width=8)  JIT:    Functions: 8    Options: Inlining true, Optimization true, Expressions true, Deforming true (10 rows)  Time: 1.319 ms 

The costs already hint a much longer execution time, but I do not understand why the costs are that much bigger? Why does the Parallel Seq Scan on texts take so long? What is postgres doing here?

With fewer rows in the tables, I get the following query plan:

explain (analyse) select id from texts WHERE id not in (select doc_id from details);                                                                               QUERY PLAN                                                        -----------------------------------------------------------------------------------------------------------------------  Seq Scan on texts  (cost=11466.00..23744.18 rows=338247 width=8) (actual time=174.488..325.775 rows=10 loops=1)    Filter: (NOT (hashed SubPlan 1))    Rows Removed by Filter: 599990    SubPlan 1      ->  Seq Scan on details  (cost=0.00..9937.20 rows=611520 width=8) (actual time=0.014..56.549 rows=599990 loops=1)  Planning Time: 0.079 ms  Execution Time: 326.372 ms (7 rows) 

Why does it degrade that much with more rows? If I understand the output correctly the materialization itself is not the problem. Also how does the second query avoid this problem?

Schema/Data generation:

create table texts (   id bigint primary key,   url text);    create table details (   id bigserial primary key,   doc_id bigint,   content text);       insert into details (doc_id, content) select generate_series(1,800000), 'foobar'; insert into texts (id, url) select generate_series(1,800000), 'something';  # Delete some values delete from details where doc_id IN ( 307531, 630732, 86402, 584950, 835230, 334934, 673047, 772541, 239455, 763671); 

How can I speed up this mysql (mariadb) Query?

I’m averaging about 1000 queries per minute with the below query. Most of the query will stay the same with variations on the date,hour,minute and itemName (2021-06-02, 10, 30 and "football" in this example ). I’ve switched around various parts and this seems to be the best order for performance. I suspect a query utilizing different functions may be more appropriate for performance but I’ve yet to figure one out.

SELECT DatetimeRecorded, itemName, field1, field2, field3 FROM StoreData.data  WHERE DatetimeRecorded  BETWEEN '2021-06-02' - INTERVAL 30 DAY AND '2021-06-02' - INTERVAL 1 DAY   AND itemName = 'football' and  HOUR(DatetimeRecorded) = 10 and  MINUTE(DatetimeRecorded)  <= 30                                        

The frequency of "football" in the data base will only occur once per day with the example time constraints, meaning this and other similar queries would return a max of 30 rows being 1 per day.

In a more human readable format what I’m hoping to do more efficiently is "select 30 days before 2021-06-02 where the time is between 10:00 and 10:30 and the item is football"

additional info

  • queries are being run on mariadb Ver 15.1 Distrib 10.3.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
  • the database is about a half million entries
  • there are about 5000 unique itemNames

Here is the output show create table

 | Data | CREATE TABLE `data` (  `DatetimeRecorded` datetime DEFAULT NULL,   `field1` varchar(255) DEFAULT NULL,   `field2` varchar(255) DEFAULT NULL,   `field3` varchar(9) DEFAULT NULL,   `itemName` varchar(255) NOT NULL,   `field4` varchar(255) DEFAULT NULL,   `field5` double DEFAULT NULL,   `field6` int(11) DEFAULT NULL,   `field7` varchar(255) DEFAULT NULL,   `field8` double DEFAULT NULL,   `field9` int(11) DEFAULT NULL,   `field10` varchar(255) DEFAULT NULL,   `field11` double DEFAULT NULL,   `field12` int(11) DEFAULT NULL,   `field13` varchar(255) DEFAULT NULL,   `field14` double DEFAULT NULL,   `field15` double DEFAULT NULL,   `field16` double DEFAULT NULL,   `field17` double DEFAULT NULL,   `field18` double DEFAULT NULL,   `field19` int(11) NOT NULL,   `field20` mediumtext DEFAULT NULL,   `field21` mediumtext DEFAULT NULL,   `field22` double DEFAULT NULL,   `field23` varchar(255) DEFAULT NULL,   `field24` varchar(255) DEFAULT NULL,   `field25` varchar(255) DEFAULT NULL,   `field26` varchar(255) DEFAULT NULL,   `field27` double DEFAULT NULL,   `field28` int(11) DEFAULT NULL,   `field29` double DEFAULT NULL,   `field30` double DEFAULT NULL,   `field31` double DEFAULT NULL,   `field32` double DEFAULT NULL,   `field33` double DEFAULT NULL,   `field34` datetime DEFAULT NULL,   `field35` varchar(255) DEFAULT NULL,   `field36` double DEFAULT NULL,   `field37` int(11) DEFAULT NULL,   `field38` double DEFAULT NULL    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 | 

Apologies if I have left out any important details, I’m very new to sql and would appreciate any guidance/suggestions

Would a custom table make more sense than a CPT in this case?

I am building a "multi vendor" type plugin to extend Woocommerce. There will be two types of new user roles: Vendor, and Non-Profit Org.

Vendors can list their products on the site, and users can choose at the checkout page which "Non-Profit Organization" they would like to donate part of their purchase to.

Ultimately, I would like the site owner to be able to have a curated list of all transactions, meaning how much is going to the Non Profit, how much goes to the Vendor. Preferably in chosen increments (monthly, daily, by individual order).

What’s got me stuck is figuring out how to let the "Vendor" and "Non Profit Org" accounts VIEW their respective transactions as well.

I don’t know if I should make two custom post types (Vendor Orders, Non Profit Orders) and just list extra info as Post Meta, as well as finding out a way to make sure ONLY the user assigned to the role can view orders for that role (in other words, one non profit can’t see records of another non profit).

Or, I am wondering if it makes more sense to create a custom table, which lists all valuable information (amount going to vendor, amount going to non profit, etc…) and just write custom queries to list the information based on the current user ID.

How can I solve this PDE?

I got the following equation from physics.

$ $ C \sin \theta \frac{\partial T}{\partial \theta} = \frac{1}{r} \frac{\partial }{\partial r} \left( r \frac{\partial T}{\partial r} \right)$ $ where boundary conditions are

$ T=T_w$ for $ r<r_0$ ,

$ T=T_0$ where $ r \rightarrow\infty$ ,

and $ C, T_0, T_w, r_0$ are constant.

(Symmetrical for all $ \theta$ )

I would like to find $ \frac{\partial T}{\partial r}$ where $ r=r_0$ from the equation.

How can I solve using Mathematica? Thank you so much!

SEO | Cloaking | Is it safe to remove Third-party / Analytical scripts for crawlers/bots? Is this considered as cloaking?

Is it considered as cloaking if I remove third party scripts such as google tag manager, other analytics based scripts tags for crawlers/bots?

By removing these external javascripts I will surely have improved page performance(reduced page load time) for the Google Crawler and for effective SEO.

Though the question is related to Will disabling javascript be considered as cloaking by Google But, unlike there I am trying to remove only Third party Scripts which are not vital for the site from crawlers perspective.

Can I do so? Please suggest.

How to write this tensor?

How can I write this tensor in Mathematica?

$ $ \mathcal{P}_{ijkl}(N) = \Big( \delta_{ik} – N_iN_k \Big) \Big( \delta_{jl} – N_jN_l \Big) – \dfrac{1}{2} \Big( \delta_{ij} – N_iN_j \Big)\Big( \delta_{kl} – N_kN_l \Big)$ $

I have tried with TensorProduct, but I realized that it is not so simple because of the position of the indices.

I want to change this matlab code to Mathematica? can you help me

my code have one matrix entry and works as QR decompose method by using Givens rotation and its outputs contain 2 matrix as Q and R I want to run this code in mathematica without using Matlink package…..can you help me by rewriting this code in mathematica Language eye is the IdentityMatrix and norm(a,b) is $ \sqrt{(a^2+b^2)}$ Thank you for HELP

function [Q,R] = my_givens_QR(A) n = size(A,1);  Q=eye(n); R=A; for j=1:n for i=n:(-1):j+1 x=R(:,j); if norm([x(i-1),x(i)])>0 c=x(i-1)/norm([x(i-1),x(i)]); s=-x(i)/norm([x(i-1),x(i)]); G=eye(n); G([i-1,i],[i-1,i])=[c,s;-s,c]; R=G'*R; Q=Q*G; end end end 

why isnt this playing a sound?

This code is supposed to play a sound when I press ‘E’ but it’s not working. also keep in mind I’m new to unity and coding in general so don’t be to harsh if I made a really dumb mistake.

using System.Collections; using System.Collections.Generic; using UnityEngine;  public class flashlightonoffsound : MonoBehaviour {      public AudioSource flashlightsound;      // Use this for initialization     void Start()     {      }      // Update is called once per frame     void Update()     {         if (Input.GetKeyDown(KeyCode.E))         {             flashlightsound.Play();         }         else         {             flashlightsound.Stop();         }              } }