htaccess – problem with compressing and caching WordPress files and evaluating the page views

How are you

I'm having a problem improving my Google Page Insights score. The current score is + -40 and the Google report points to the following questions:

Google report

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

The problem is that I have already enabled gzip compression on the server. They also use a plugin (Autoptimize) to run the browser cache. I have no idea why Google is reporting these issues.

How can I improve it? If you need further information, I am available at any time.

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

# BEGIN DEFLATE COMPRESSION

# Compress HTML, CSS, JavaScript, Text, XML and fonts
 AddOutputFilterByType DEFLATE application/javascript
 AddOutputFilterByType DEFLATE application/rss+xml
 AddOutputFilterByType DEFLATE application/vnd.ms-fontobject
 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

# END DEFLATE COMPRESSION

# BEGIN GZIP COMPRESSION

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.*

# END GZIP COMPRESSION

#BEGIN EXPIRES HEADERS

# 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/vnd.microsoft.icon "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/vnd.ms-fontobject "access plus 1 month"

#END EXPIRES HEADERS

Super-fast, safe, high-retention, non-drop action for $ 2

Super-fast, highly retention-proof advertising without drops

Offer high quality video advertising in safe quality

SERVICE of functions:

✔ Very fast delivery time

✔ 100% safe and without a ban

✔ Super fast

✔ Non drop service

✔ Immediate support

✔ Split available

✔ No password access required

✔ The fastest on the market

✔ Delivery guaranteed

✔ High quality and SAFE

✔ 100% satisfaction guaranteed

✔ 24/7 customer service

After the order, the cancellation of this order is not accepted. Do not make your page private after ordering, or remove or change the link. The order is marked as completed immediately. No cancellation or refund will be given to them.

Views – problem with content when editing

When I try to enter content in my Drupla 8 structure, I get this error

Le site Web a rencontré aneurur inattendue. Veuillez essayer de
nouveau plus tard.Drupal Core Database DatabaseExceptionWrapper:
Exception in content (content): SQLSTATE (42S02): Base table or view not
found: 1146 table & # 39; database_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; Array (
(: 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) => fr
(: db_condition_placeholder_28) => en
(: db_condition_placeholder_29) => and
(: db_condition_placeholder_30) => zxx) in Drupal views Plugin views query Sql-> execute ()
(Line 1543 from 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 {Closure} ()
(Line: 582)
Drupal Core Render Renderer-> executeInRenderContext (object, object)
(Line: 227)
Drupal Core Render MainContent HtmlRenderer-> prepare (Array, Object,
Object) (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 ;,
Object) (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 tried to clear the field. I am getting this error

Le site Web a rencontré une erreur inattendue. Veuillez essayer de nouveau plus tard.

DrupalCoreDatabaseDatabaseExceptionWrapper: SQLSTATE(42S02): Base table or view not found: 1146 Table 'database_v2.node_revision__field_order' doesn't exist: SELECT 1 AS expression FROM {node_revision__field_order} t WHERE field_order_value IS NOT NULL LIMIT 1 OFFSET 0; Array ( ) in DrupalCoreEntitySqlSqlContentEntityStorage->countFieldData() (line 1800 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
DrupalCoreDatabaseStatement->execute(Array, Array) (Line: 631)
DrupalCoreDatabaseConnection->query('SELECT 1 AS expression
FROM
{node_revision__field_order} t
WHERE field_order_value IS NOT NULL
LIMIT 1 OFFSET 0', Array, Array) (Line: 358)
DrupalCoreDatabaseDrivermysqlConnection->query('SELECT 1 AS expression
FROM
{node_revision__field_order} t
WHERE field_order_value IS NOT NULL
LIMIT 1 OFFSET 0', Array, Array) (Line: 510)
DrupalCoreDatabaseQuerySelect->execute() (Line: 1800)
DrupalCoreEntitySqlSqlContentEntityStorage->countFieldData(Object, 1) (Line: 212)
DrupalfieldEntityFieldConfig::preDelete(Object, Array) (Line: 422)
DrupalCoreEntityEntityStorageBase->delete(Array) (Line: 402)
DrupalCoreEntityEntityBase->delete() (Line: 100)
Drupalfield_uiFormFieldConfigDeleteForm->submitForm(Array, Object)
call_user_func_array(Array, Array) (Line: 111)
DrupalCoreFormFormSubmitter->executeSubmitHandlers(Array, Object) (Line: 51)
DrupalCoreFormFormSubmitter->doSubmitForm(Array, Object) (Line: 590)
DrupalCoreFormFormBuilder->processForm('field_config_delete_form', Array, Object) (Line: 319)
DrupalCoreFormFormBuilder->buildForm(Object, Object) (Line: 93)
DrupalCoreControllerFormController->getContentResult(Object, Object)
call_user_func_array(Array, Array) (Line: 123)
DrupalCoreEventSubscriberEarlyRenderingControllerWrapperSubscriber->DrupalCoreEventSubscriber{closure}() (Line: 582)
DrupalCoreRenderRenderer->executeInRenderContext(Object, Object) (Line: 124)
DrupalCoreEventSubscriberEarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext(Array, Array) (Line: 97)
DrupalCoreEventSubscriberEarlyRenderingControllerWrapperSubscriber->DrupalCoreEventSubscriber{closure}() (Line: 151)
SymfonyComponentHttpKernelHttpKernel->handleRaw(Object, 1) (Line: 68)
SymfonyComponentHttpKernelHttpKernel->handle(Object, 1, 1) (Line: 57)
DrupalCoreStackMiddlewareSession->handle(Object, 1, 1) (Line: 47)
DrupalCoreStackMiddlewareKernelPreHandle->handle(Object, 1, 1) (Line: 106)
Drupalpage_cacheStackMiddlewarePageCache->pass(Object, 1, 1) (Line: 85)
Drupalpage_cacheStackMiddlewarePageCache->handle(Object, 1, 1) (Line: 47)
DrupalCoreStackMiddlewareReverseProxyMiddleware->handle(Object, 1, 1) (Line: 52)
DrupalCoreStackMiddlewareNegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
StackStackedHttpKernel->handle(Object, 1, 1) (Line: 693)
DrupalCoreDrupalKernel->handle(Object) (Line: 19)

How to increase YouTube views

So you want to get more people to visit your blog or website. To do this, you need to know how to increase YouTube views. But how is that achieved? Well it's easy; First of all, you need to write excellent and relevant content that gets a lot of traffic, and also get people to like your videos.

Now some people think that increasing YouTube views means placing your video on YouTube in the top ten. Yes, it is true that if you have a great video with a lot of traffic and a lot of likes, you will be shown on the YouTube homepage. You can increase your views by buying Youtube views. You can also go to the search engine and type "YouTube Videos" to see what's coming. It may surprise you that many other people have also uploaded their videos to YouTube. Your video may have appeared on the first page of YouTube, which you will appreciate. After all, it's your video, and you just want people to see and like it.

You should also make sure that you have the best possible video quality. Many people will watch the video and will not bother to watch your video. However, if you upload an excellent video, your video will be checked. You can also use Flash to add the Flash videos to your video and give it a professional look. Finally, you can create your own YouTube channel at any time and upload it to the YouTube website so users can come to you if they like your videos.

What are the approaches to updating materialized views in Oracle when underlying tables are updated frequently?

I am a web developer and maintain a web app that tracks orders, customers, products, etc. that my customer uses internally. I'm using Oracle 12c, which is hosted on AWS RDS. My client has just switched some other systems so we're at a point where the data structures have changed and I'm using a new schema in Oracle to store new data in the new structures.

So that the web app does not have to be revised to work with new data structures, it was decided to implement materialized views in Oracle that combine the new data from the new schema (manipulated into the "legacy structure"). along with the legacy data.

Now I have to take care of updating these materialized views so that the web app can always access the latest data. Ideally, the relevant materialized views will be updated when I get a new record in the new schema. However, I may get new data every few seconds during working hours. A compromise is fine – if the materialized views are out of date by a few minutes (maybe 5 or (less ideally) 10 minutes), this can be an acceptable situation.

My question is, what approach should I take to refresh these materialized views? I don't want to overload Oracle with constant updates, and the web app should give users a good user experience reading / writing data from / to Oracle. I am far from being an Oracle / DB expert, so I'm not sure what options are available. I think I could just have a cron job that runs every 5 minutes or something to refresh outdated materialized views one by one, but I wonder if this approach is a bit naive.

In reality, I'm dealing with 14 materialized views (for now), and my tests take up to 2.5 minutes for some of them to complete a full update.

Views – How is the drop-down list of child terms related to the parent term displayed?

I can use views to complete this problem. In this case, however, I can only display an unformatted list of "subordinate terms".

I need to display the DROPDOWN list of relevant child terms on each term page (which contains some child terms).

I think the taxonomy menu might work for that, but there are some bugs and conflicts in my installation.

Is there a clean way to do this?

What is the best way to theming Views fields? Custom templates or overwrite output from the user interface?

I have some confusion when issuing topic views in Drupal, The Drupal version doesn't matter here, as the confusion is the best course of action to follow.

While addressing a view with fields, you can either create template files for each view like views-view-unformatted--view-name--block-name.html.twig or you can use that Rewrite Results option in the fields configuration as shown below in the screenshot.

Drupal8 views-field configuration

I want to know which is the best course of action and why.

Some of my points below (please correct me if I'm wrong):

  • Rewrite views The output is saved in the database. Accidental deletion of the database is therefore destructive.
  • Creating a template file ensures that people who are unfamiliar with views have no effect even if they accidentally change the code.
  • If you leave the code in Rewrite Results, you can easily access changes through the Views user interface.

Can anyone suggest the advantages and disadvantages of both methods and what should you watch out for?

Views – Drupal 8 taxonomy term in page.html.twig

I have a list of taxonomic terms to create some categories on my website. When I click on one of them, the content appears, but I can't see the name of the term! In my view, I cannot find the right configuration.
Enter image description here

(it's in french, sorry …)

To see the result, I have to change the page.html.twig template and the views template. I want to display the name of the term on the page – my_name.html.twig template.
Thank you for your help and sorry for my bad english 🙂