wiki – mediawiki: Includes template with multiple heading levels on a mismatched header level

Suppose I have a template with multiple heading levels, such as:

= Template level 1 =
lorem ipsum

== Template level 2 ==
lorem ipsum

Now I want to put it on a certain level in a page that does not correspond to the level that is accepted by this template. Like this:

= Document level 1 =
lorem ipsum

== Document level 2 ==
lorem ipsum

=== Document level 3 ===
{{Template:Template}}

== Another document level 2 ==
lorem ipsum


As it is, the following page structure is created:

    1 Document level 1
        1.1 Document level 2
            1.1.1 Document level 3
    2 Template level 1
        2.1 Template level 2
        2.2 Another document level 2

Instead, I want to embed to take into account the structure of the enclosing document.


    1 Document level 1
        1.1 Document level 2
            1.1.1 Document level 3
                1.1.1.1 Template level 1
                    1.1.1.1.1 Template level 2
        1.2 Another document level 2

Is there a way to accomplish this with standard MediaWiki templates? An extension?

google sheets – Help with a Vlookup function to return multiple mismatched results

I am trying to execute the following code to return all the matches of column A from column C in a series of rows. In this situation, cell A1 is included in some iterations of column C, but these are not exact matches. I want a match for this cell https://i.postimg.cc/FzHBMnVc/KENKD00319-03-KDLP0808-WHITE-3235.jpg because KDLP0808 is included in the URL.

I use the code below to do this

= IFERROR (INDEX (C: C, SMALL (IF ("*" & A1 & "*" = C: C, ROW (C: C) - MIN (ROW (C: C)) + 1, ""), COLUMN () -4)), "") 

Enter image description here

postgresql – plpgsql: mismatched brackets at or near ";" in nested loop structure

I wrote a do-block to store only the tables in a Postgres database, but when I ran the script I got this error message. I can not see where parentheses do not match. I added the captions after seeing this error for the first time, but the error could not be fixed.

psql $ DBNAME << EOF
DO  $$
TO EXPLAIN
Myschema RECORD;
myview RECORD;
myfunc RECORD;
myseq RECORD;
BEGIN

FOR myschema IN (SELECT schema_name FROM information_schema.schemata;)
<>
LOOP

- Delete all views
FOR myview IN (SELECT viewname FROM pg_catalog.pg_views WHERE schema_name = myschema.schema_name;)
<>
LOOP
& # 39; DROP VIEW & # 39; EXECUTE || quote_ident (mychema.myview.viewname) || & # 39 & # 39 ;; ;;
END LOOP foreachview;

- Drop all functions
FOR myfunc IN (SELECT routine-name FROM information-schema.routines WHERE routine_type = & # 39; FUNCTION & # 39; AND specific_schema = & # 39; public & # 39 ;;)
<>
LOOP
& # 39; DROP FUNCTION & # 39; EXECUTE || quote_ident (mychema.myfunc.routine_name) || & # 39 & # 39 ;; ;;
END LOOP foreachfunc;

- Delete all sequences
FOR myseq IN (SELECT sequencename FROM informationschema.sequences;)
<>
LOOP
& # 39; DROP SEQUENCE & # 39; EXECUTE || quote_ident (mychema.myseq.sequence_name) || & # 39 & # 39 ;; ;;
END LOOP foreachseq;

END LOOP foreachschema;

THE END;
 $$ LANGUAGE plpgsql;
EOF
ERROR: Mismatching brackets at or near ";"
LINE 9: ... ma IN (SELECT schema_name FROM information_schema.schemata;)

Final work code:

psql $ DBNAME << EOF
DO  $$
TO EXPLAIN
Myschema RECORD;
myview RECORD;
myfunc RECORD;
myseq RECORD;
BEGIN

FOR myschema IN (SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE & # 39; pg_% & # 39; AND schema_name <> & # 39; information_schema & # 39;
LOOP

- Delete all views
FOR myview IN (SELECT viewname FROM pg_catalog.pg_views WHERE schema_name = myschema.schema_name)
LOOP
& # 39; DROP VIEW & # 39; EXECUTE || quote_ident (myschema.schema_name) || . & # 39; & # 39; || quote_ident (myview.viewname) || & # 39 & # 39 ;; ;;
END LOOP;

- Drop all functions
FOR myfunc IN (SELECT routine-name FROM information-schema.routines WHERE routine_type = & # 39; FUNCTION & # 39; AND specific_schema = & # 39; public & # 39;
LOOP
& # 39; DROP VIEW & # 39; EXECUTE || quote_ident (myschema.schema_name) || . & # 39; & # 39; || quote_ident (myfunc.routine_name) || & # 39 & # 39 ;; ;;
END LOOP;

- Delete all sequences
FOR myseq IN (SELECT sequencename FROM informationsschema.sequences)
LOOP
& # 39; DROP VIEW & # 39; EXECUTE || quote_ident (myschema.schema_name) || . & # 39; & # 39; || quote_ident (myseq.sequence_name) || & # 39 & # 39 ;; ;;
END LOOP;

END LOOP;

THE END;
 $$ LANGUAGE plpgsql;
EOF

Magento2 – mismatched Magento version when using the composer

I was running Magento on Ubuntu Xampp at the time and was trying to run Composer on a design file that made me install PHP extensions. I have done this (7.2 for all, just like system version) that fixed these bugs, but then suddenly came the message "Magento / Framework 100.0.9 requires PHP ~ 5.5.0 | ~ 5.6.0 | ~ 7.0.0 – > Your PHP version (7.2.15) does not meet this requirement. "This is a response to" Composer installation "in the corresponding Design folder.

The Magento admin panel, however, clearly states that I am on version 2.3.1, which supports PHP 7.2.11 (which is older than 7.2.15, but this should not be a crucial change). I've installed Magento through the Bitnami Addon installer for Xampp. What could be the cause, because somehow an older version was installed? (Even if the admin panel is running again with 2.3.1). Could this have something to do with the version that the topic is specifically looking for?

Any advice would be very grateful.
Many Thanks!

SQL Server – Finds the first mismatched character between two strings

In another forum, there is a very similar question in which someone wants to compare 1-character varchar arrays.

There are several answers that include looping through strings and longer scripts that insert new number tables into your database. And then there's a little gem of an answer that uses a bitwise comparison to detect the first difference between the strings.

To do this, this solution converts each character of each string into a binary representation. Due to the limitation of the allowed number of digits within the bigint data type, there is a brief indication that this is "a nice feature that works for up to 8 characters!"

If you extend this to support longer strings, you must split the supplied strings into eight character blocks. This is the solution I provide here.

create FUNCTION dbo.fnFirstDifference (@FirstString VARCHAR (256), @ SecondString VARCHAR (256))
RETURNS int
AS
BEGIN
DECLARE @var VARBINARY (8),
@firstChunk varchar (8),
@secondChunk varchar (8),
@chunkStart int,
@loopCount int,
@pos TINYINT

set @chunkStart = 1
set @loopCount = -1;
set @pos = 0;

set @firstChunk = substring (@firstString, @chunkStart, 8);
set @secondChunk = substring (@secondString, @chunkStart, 8);

during @pos = 0 and (data length (@firstChunk)> 0 or data length (@secondChunk)> 0)
begin

SELECT @var = CAST (CAST (@FirstChunk AS BINARY (8)) AS BIGINT) ^ CAST (CAST (@SecondChunk AS BINARY (8)) AS BIGINT),
@pos = PATINDEX (& # 39;%[^0]% & # 39 ;, SUBSTRING (master.dbo.fn_sqlvarbasetostr (@var), 3, 32)),
@pos = (1 + @pos) / 2

set @chunkStart = @chunkStart + 8;
set @firstChunk = substring (@firstString, @chunkStart, 8);
set @secondChunk = substring (@secondString, @chunkStart, 8);
set @loopCount = @loopCount + 1;
The End

if @pos <> 0 set @pos = (@loopCount * 8) + @pos;

BACK @pos
THE END

The original function returned a varchar that contained all matching characters and the first unmatched string 1 character, a hyphen, and then string 2 as well. Example: & # 39; interesti-intereste & # 39;, I converted this to indicate the position of the first mismatched character – 9 for the following example:

    choose dbo.fnFIrstDifference (& # 39; Interesting & # 39 ;, & # 39; Interested & # 39;)

The adaptation to the other use cases is trivial.

SSL Issue – Mismatched content between front-end and back-end on the same server

I have a server (an EC2 instance of AWS) with a frontend (html + css + javascript) and an IIS hosted backend (C #). Both communicate via HTTP requests with the frontend on port 3000 and the backend on port 5000.

I have purchased an SSL certificate from GoDaddy for this server. After some problems I could assign the certificate in my frontend (change its port to 443). However, when I communicated with the backend, I had the following problem:

> Mixed Content: The page at & # 39; https: //test.com/&#39; was loaded via HTTPS.
> However, requested an insecure XMLHttpRequest endpoint
> "http://test.com:5000/token". This request has been blocked. The content must be delivered via HTTPS.

As the bug itself explains, I need the other side of the request (the backend) to communicate through https. And here come my doubt.

  1. Because the backend is on the same server as the frontend (and both are hosted)
    I can use the same certificate that I have attached to my certificate
    Frontend for my backend?
  2. Because port 443 is already being used for the frontend, which port can
    Will I attach to the backend for it to work with https?
  3. I know that in my frontend I should change all my http requests in https.
    And in C # backend, I have to make some changes as well
    Link SSL?

plugins – WPALLIMPORT- Mismatched data stored in images meta (description)?

I use wpallimport plugin from a very long time ago. This is the first time I have faced this problem.

All this for 1 post.
Enter the image description here

Well as I use wpallimport meta-fields
Enter the image description here

everything seems to work fine, only problems in the description of the image description, it will be wrong data as given below
These are the data of the 1st plant, which are always correct. Title, caption, alt, description are all the same.

Enter the image description here

Start of problem from 2. Appendix-ID small data in the sheet, if 100 entries for 1 post-start problem originate from Appendix 3. how to roar. See the description that the data does not match. For all other fields, the correct data will be displayed, only the submitted descriptions will be incorrect (mismatch). I spend all my day solving this problem, but I was not lucky. finally i am here to get help.

Enter the image description here

Enter the image description here

Please help me with this. I change many things but have no luck.
So I have created a completely new line for the description in my sheet and assigned this only to the description in wpallimport. do not forget to share all the data in a cell, that does not work and much more, now I hang and nothing has to be done, so please help me. (Sorry for my bad english) (ignore # – in screenshots I use others for this time, I take screenshots and give ex: sheet to know the format)