htaccess – WordPress file compression and caching issue and page preview score

How are you

I have a problem in the process of improving the score on the google insights page. The current score is + -40 and the Google report highlights the following questions:

Google Report

  • Enable text compression
  • Serves static assets with an effective cache policy

The problem is that I have already enabled gzip compression on the server, in addition, they also use a plugin (automatic optimization) to perform the browser cache. I don't know why google points to these problems.

How can I improve this? If you need more details, I am at your entire disposal.

This is my .htaccess

# BEGIN WordPress

RewriteEngine On
RewriteBase /
RewriteRule ^index.php$ - (L)
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php (L)

# END WordPress


# Compress HTML, CSS, JavaScript, Text, XML and fonts
 AddOutputFilterByType DEFLATE application/javascript
 AddOutputFilterByType DEFLATE application/rss+xml
 AddOutputFilterByType DEFLATE application/
 AddOutputFilterByType DEFLATE application/x-font
 AddOutputFilterByType DEFLATE application/x-font-opentype
 AddOutputFilterByType DEFLATE application/x-font-otf
 AddOutputFilterByType DEFLATE application/x-font-truetype
 AddOutputFilterByType DEFLATE application/x-font-ttf
 AddOutputFilterByType DEFLATE application/x-javascript
 AddOutputFilterByType DEFLATE application/xhtml+xml
 AddOutputFilterByType DEFLATE application/xml
 AddOutputFilterByType DEFLATE font/opentype
 AddOutputFilterByType DEFLATE font/otf
 AddOutputFilterByType DEFLATE font/ttf
 AddOutputFilterByType DEFLATE image/svg+xml
 AddOutputFilterByType DEFLATE image/x-icon
 AddOutputFilterByType DEFLATE text/css
 AddOutputFilterByType DEFLATE text/html
 AddOutputFilterByType DEFLATE text/javascript
 AddOutputFilterByType DEFLATE text/plain
 AddOutputFilterByType DEFLATE text/xml



mod_gzip_on Yes
mod_gzip_dechunk Yes
mod_gzip_item_include file .(html?|txt|css|js|php|pl)$
mod_gzip_item_include handler ^cgi-script$
mod_gzip_item_include mime ^text/.*
mod_gzip_item_include mime ^application/x-javascript.*
mod_gzip_item_exclude mime ^image/.*
mod_gzip_item_exclude rspheader ^Content-Encoding:.*gzip.*



# Enable expirations
ExpiresActive On
# Default expiration: 1 hour after request
ExpiresDefault "now plus 1 hour"
# CSS and JS expiration: 1 week after request
ExpiresByType text/css "now plus 1 week"
ExpiresByType application/javascript "now plus 1 week"
ExpiresByType application/x-javascript "now plus 1 week"
# Image files expiration: 1 month after request
ExpiresByType image/bmp "now plus 1 month"
ExpiresByType image/gif "now plus 1 month"
ExpiresByType image/jpeg "now plus 1 month"
ExpiresByType image/jp2 "now plus 1 month"
ExpiresByType image/pipeg "now plus 1 month"
ExpiresByType image/png "now plus 1 month"
ExpiresByType image/svg+xml "now plus 1 month"
ExpiresByType image/tiff "now plus 1 month"
ExpiresByType image/ "now plus 1 month"
ExpiresByType image/x-icon "now plus 1 month"
ExpiresByType image/ico "now plus 1 month"
ExpiresByType image/icon "now plus 1 month"
ExpiresByType text/ico "now plus 1 month"
ExpiresByType application/ico "now plus 1 month"
# Webfonts
ExpiresByType font/truetype "access plus 1 month"
ExpiresByType font/opentype "access plus 1 month"
ExpiresByType application/x-font-woff "access plus 1 month"
ExpiresByType image/svg+xml "access plus 1 month"
ExpiresByType application/ "access plus 1 month"


Python performance issue in XML parsing even when using LXML

Ok, I have a little problem here while my code is working correctly XML parsing is way too slow takes about 1.5 hours to process 988 individual files with different sizes at first I was using Python's default element tree module to do the job, but was too slow, so I switched to lxml, it improved slightly, but not enough could be my code. Now what I want is to analyze xml in a pandas database and then in a sorry csv if the code is bad, any improvement or suggestion is welcome xml sample attached

from lxml import etree as et

def xml_to_dataframe():
"Converts All XML Files To A Dataframe And Returns That Dataframe"

for xml_file in xml_files_path_list:
    xml_file_root = et.parse(xml_file).getroot()

    for S_node in xml_file_root.findall('S'):

        S_node_attribs = S_node.attrib
        S_node_sid = S_node_attribs.get('sid')
        S_node_text = S_node.text

    for abstract_node in xml_file_root.findall('ABSTRACT'):
        for abs_S_node in abstract_node.findall('S'):
            abs_S_node_attribs = abs_S_node.attrib
            abs_S_node_sid = abs_S_node_attribs.get('sid')
            abs_S_node_ssid = abs_S_node_attribs.get('ssid')
            abs_S_node_text = abs_S_node.text
            xml_dataframe=xml_dataframe.append({'SID':abs_S_node_sid,'SSID' : abs_S_node_ssid,'Text':abs_S_node_text},ignore_index=True)

    for section_node in xml_file_root.findall('SECTION'):
        section_node_attribs = section_node.attrib
        section_node_title = section_node_attribs.get('title')
        section_node_number = section_node_attribs.get('number')
        xml_dataframe=xml_dataframe.append({'Title':section_node_title,'Number' : section_node_number},ignore_index=True)

        for sec_S_node in section_node.findall('S'):          
            sec_S_node_attribs = sec_S_node.attrib
            sec_S_node_sid = sec_S_node_attribs.get('sid')
            sec_S_node_ssid = sec_S_node_attribs.get('ssid')
            sec_S_node_text = sec_S_node.text
            xml_dataframe=xml_dataframe.append({'SID':sec_S_node_sid,'SSID' : sec_S_node_ssid,'Text':sec_S_node_text},ignore_index=True)

return xml_dataframe

Example of an XML file

Can different states of the world issue passports with the same "number"?

As a rule, passport numbers are not only indexes of passports issued, but they have certain rules regarding the relationship between numbers, the use of letters and / or suffixes and prefixes.

Is it true that you can determine which state in the world has issued a passport solely on the basis of the "number" (ie a combination of numbers and letters called passport number)? Or can different states issue passports with the same number?

SQL Server 2019 license issue not found

I am trying to install SQL Server 2019 Standard Edition on a new professional virtualized installation Windows 10 64 bit (version 1809) with 6 GB of RAM memory. The installer fails to start with the message (translated from Spanish): "License agreement not found for the selected SQL server, STANDARD. This may be due to damaged media or because publishing is not allowed ".

I removed the media corruption because I downloaded the ISO file from the Microsoft partner website twice and I still get the same message.

I have a product key for installation, but the installation process never requires it, but does not start.

enter description of image here

usability – List item label issue

I'm facing a problem where I have a list item that has multiple values ​​and one of them is an ambiguous number, so I want to label it. However, a problem (in my opinion) that it creates is when the list contains several elements, this label becomes repetitive (see wireframe below). Do you have any ideas on how to communicate what this number means without repeatedly displaying the value label? Thank you!

enter description of image here

views – content issue when editing

when i try to enter content on my drupla 8 on structure, i get this error

The website encountered an unexpected error. Please try to
again later. Drupal Core Database DatabaseExceptionWrapper:
Exception in content (content): SQLSTATE (42S02): base table or view not
found: 1146 Table & # 39; databse_v2.node__field_order & # 39;
does not exist: SELECT t. * FROM {node__field_order} t WHERE
(entity_id IN (: db_condition_placeholder_0,
: db_condition_placeholder_1 ,: db_condition_placeholder_2,
: db_condition_placeholder_3 ,: db_condition_placeholder_4,
: db_condition_placeholder_5 ,: db_condition_placeholder_6,
: db_condition_placeholder_7 ,: db_condition_placeholder_8,
: db_condition_placeholder_9 ,: db_condition_placeholder_10,
: db_condition_placeholder_11 ,: db_condition_placeholder_12,
: db_condition_placeholder_13 ,: db_condition_placeholder_14,
: db_condition_placeholder_15 ,: db_condition_placeholder_16,
: db_condition_placeholder_17 ,: db_condition_placeholder_18,
: db_condition_placeholder_19 ,: db_condition_placeholder_20,
: db_condition_placeholder_21 ,: db_condition_placeholder_22,
: db_condition_placeholder_23 ,: db_condition_placeholder_24,
: db_condition_placeholder_25)) AND (deleted =
: db_condition_placeholder_26) AND (langcode IN
(: db_condition_placeholder_27 ,: db_condition_placeholder_28,
: db_condition_placeholder_29 ,: db_condition_placeholder_30)) ORDER BY
delta ASC; Board (
(: db_condition_placeholder_0) => 175
(: db_condition_placeholder_1) => 176
(: db_condition_placeholder_2) => 269
(: db_condition_placeholder_3) => 270
(: db_condition_placeholder_4) => 271
(: db_condition_placeholder_5) => 272
(: db_condition_placeholder_6) => 273
(: db_condition_placeholder_7) => 274
(: db_condition_placeholder_8) => 275
(: db_condition_placeholder_9) => 276
(: db_condition_placeholder_10) => 442
(: db_condition_placeholder_11) => 457
(: db_condition_placeholder_12) => 461
(: db_condition_placeholder_13) => 463
(: db_condition_placeholder_14) => 464
(: db_condition_placeholder_15) => 465
(: db_condition_placeholder_16) => 466
(: db_condition_placeholder_17) => 468
(: db_condition_placeholder_18) => 469
(: db_condition_placeholder_19) => 470
(: db_condition_placeholder_20) => 472
(: db_condition_placeholder_21) => 473
(: db_condition_placeholder_22) => 474
(: db_condition_placeholder_23) => 487
(: db_condition_placeholder_24) => 489
(: db_condition_placeholder_25) => 490
(: db_condition_placeholder_26) => 0
(: db_condition_placeholder_27) => en
(: db_condition_placeholder_28) => en
(: db_condition_placeholder_29) => und
(: db_condition_placeholder_30) => zxx) in Drupal views Plugin views query Sql-> execute ()
(line 1543 of core / modules / views / src / Plugin / views / query / Sql.php).

Drupal views ViewExecutable-> execute (NULL)
(Line: 1454) Drupal views ViewExecutable-> render () (Line: 183)
Drupal views Plugin views display Page-> execute () (Line: 1630)
Drupal views ViewExecutable-> executeDisplay (& # 39; page_1 & # 39 ;,
Array) (Line: 77)
Drupal views Element View :: preRenderViewElement (array)
call_user_func (Array, Array) (Line: 378)
Drupal Core Render Renderer-> doRender (Array,) (Line: 195)
Drupal Core Render Renderer-> render (Array,) (Line: 226)
Drupal Core Render MainContent HtmlRenderer-> Drupal Core Render MainContent {close} ()
(Line: 582)
Drupal Core Render Renderer-> executeInRenderContext (Object, Object)
(Line: 227)
Drupal Core Render MainContent HtmlRenderer-> prepare (Array, Object,
Subject) (Line: 117)
Drupal Core Render MainContent HtmlRenderer-> renderResponse (Array,
Object, object) (Line: 90)
Drupal Core EventSubscriber MainContentViewSubscriber-> onViewRenderArray (Object,
& # 39; kernel.view & # 39;, Object) call_user_func (Array, Object,
& # 39; kernel.view & # 39 ;, Object) (Line: 111)
Drupal Component EventDispatcher ContainerAwareEventDispatcher-> dispatch (& # 39; kernel.view & # 39 ;,
Subject) (Line: 156)
Symfony Component HttpKernel HttpKernel-> handleRaw (Object, 1)
(Line: 68) Symfony Component HttpKernel HttpKernel-> handle (Object,
1, 1) (Line: 57)
Drupal Core StackMiddleware Session-> handle (Object, 1, 1) (Line:
47) Drupal Core StackMiddleware KernelPreHandle-> handle (Object, 1,
1) (Line: 106)
Drupal page_cache StackMiddleware PageCache-> pass (Object, 1, 1)
(Line: 85)
Drupal page_cache StackMiddleware PageCache-> handle (Object, 1, 1)
(Line: 47)
Drupal Core StackMiddleware ReverseProxyMiddleware-> handle (Object,
1, 1) (Line: 52)
Drupal Core StackMiddleware NegotiationMiddleware-> handle (Object,
1, 1) (Line: 23) Stack StackedHttpKernel-> handle (Object, 1, 1)
(Line: 693) Drupal Core DrupalKernel-> handle (Object) (Line: 19)

I have no idea how to fix it

tls – Do certification authorities issue an intermediate certificate for each new certificate request?

The issuing certificate of the certification authority is, simply, a confirmation that the public key that you sent to the certification authority in the Cerfiticate request really belongs to you (otherwise everyone could pretend that he is the owner of the domain or Since the certificate contains your public key, it cannot be prepared in advance. In addition, the response time depends on the type of certificate you requested. Simple certificates that confirm that the applicant (you) really own the domain take little time to generate. Usually CA sends you a link to an email from your domain, like You click on the link and confirm that you are the owner. Then CA generates a certificate and sends it to you.

But other types of certificates include much more verification, for example The certification authority should verify that your business really exists and is really properly registered, that your business resides at the particular address, etc. . This check can take many more days or even weeks. It takes a lot of effort, so the price is that much higher. But the certificate also confirms much more than other certificates.

In addition to domain certificates, there are other types of certificates, like S / MIME: to sign your emails, so the recipient can count that the email really came from you; it can also be used for email encryption. Verification and generation of these certificates takes even less time than for domain certificates. There are certificates for code signing, etc.

More details you can find on CA websites (I prefer not to promote any here).

To sign certificates:

The certification authority has a root certificate. It is the most important element of the certificate hierarchy. This is why it is stored with great security. For often practical use, this is not practical. This is why CA uses a root certificate (which is generally valid for 10 years or more) to issue certain signing certificates which have a shorter validity, such as 3 to 5 years. Shorter validity means less exposure and therefore less risk of compromise.

To the question: Yes, these signing certificates are created in advance.

Which non-state authorities can issue car license plates?

In Uzhhorod, Ukraine, I saw cars with unusual license plates, not assigned to Ukraine or another country, but probably to the OBSE organization.

What other organizations can issue their own license plates?

enter description of image here – Coinbase and wallet issue

Can I put / move my cryptography from Coinbase dot com to wallet dot Coinbase?
Also, I tried to move / link my paypal with Coinbase to withdraw in USD. It's been 4 days and I have not received any notification from paypal with a link to Coinbase.
My transaction is also complete since history shows it.
Received, 2 emails saying that I sent and one that I received. When I click on the link to see the transaction, I return to Coinbase and it seems to me that I have set up another account. I am so lost. Any advice would be appreciated.
Coinbase customer service seems unable to respond.

How do I store more than 5,000 items in List. How do I deal with the list limiting issue in JSOM Sharepoint Online?

I have a list in SharePoint online containing more than 5000 items. How to manage it with JSOM or the REST API.