importrange – ERROR IN QUERY FORMULA GOOGLE SHEETS

I need to join two worksheets from different files in another one that already exist in Google sheets

I tried to do this

=QUERY({IMPORTRANGE(“1GoKFiJjBKcGQGGi6JMvk9xD5TIypsNSmpLCTeadWQnU”,”‘BDD PROYECTOS’!A2:AP”);IMPORTRANGE(“1jiE-8ciu-BzfIxts5Y6d-Yi8gjhgx4dvS4EQMK0Conc”,”‘BDD PROYECTOS’!A3:AP”)},”Where Col7 is not null”,1)

The error that brings is

Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col7

What should i do to solve this.

oracle – Why am i getting “missing right parenthesis” error when i try to LOG ERRORS when loading from an external table?

I’ve successfully created an error logging table

BEGIN
    DBMS_ERRLOG.create_error_log(
    dml_table_name  => 'enzyme',
    skip_unsupported => TRUE);
END;
/

desc ERR$_ENZYME;
Name            Null? Type           
--------------- ----- -------------- 
ORA_ERR_NUMBER$       NUMBER         
ORA_ERR_MESG$         VARCHAR2(2000) 
ORA_ERR_ROWID$        UROWID         
ORA_ERR_OPTYP$        VARCHAR2(2)    
ORA_ERR_TAG$          VARCHAR2(2000) 
ENZ_NAME              VARCHAR2(4000) 

But i get an error when I try to run this query:

insert /*+ ignore_row_on_dupkey_index ( enzyme ( enz_name ) ) */
into enzyme
SELECT enz_name FROM EXTERNAL ((
  construct_id NUMBER(10),
  n_term VARCHAR2 (50),
  enz_name VARCHAR2 (3),
  c_term VARCHAR2 (50),
  cpp VARCHAR2 (50),
  mutations VARCHAR2 (50),
  mw_kda NUMBER (7, 3))

    TYPE ORACLE_LOADER
    DEFAULT DIRECTORY data_to_input
    ACCESS PARAMETERS (
        RECORDS DELIMITED BY NEWLINE
        skip 1
        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
        MISSING FIELD VALUES ARE NULL 
        ) 
    LOCATION ('CONSTRUCT.CSV')
    LOG ERRORS INTO ERR$_ENZYME ('INSERT') REJECT LIMIT UNLIMITED) ext
    where not exists (
        select * from enzyme e
        where e.enz_name = ext.enz_name
    );
Error at Command Line : 79 Column : 5
Error report -
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 -  "missing right parenthesis"
*Cause:    
*Action:

Line 79 is the LOG ERRORS INTO line.

If i delete the LOG ERRORS INTO ERR$_ENZYME ('INSERT') part, this command functions perfectly.

integration – Verification of an Cauchy’s contour Integral of Complementary Error function?

I tried to find an integral of the following,$DeclareMathOperator{erfc}{erfc}$

$intlimits_0^{2pi} erfc(a + bcos(theta))erfc(c + dsin(theta)),dtheta $

Where, $a,b,c,d in Bbb R$

Now, $cos(theta) = frac{e^{jtheta} + e^{-jtheta}}{2};quadsin(theta) = frac{e^{jtheta } – e^{-jtheta }}{2j}$

Let $z = {e^{jtheta }}$

Therefore, I can rewrite the integral as,
$ointlimits_{|z| = 1} {erfcleft( {a + bleft( {frac{{z + {z^*}}}{2}} right)} right)erfcleft( {c + dleft( {frac{{z – {z^*}}}{{2j}}} right)} right)frac{{dz}}{{iz}}} $

Again, let $f(z) = erfcleft(a + bleft(frac{z + z^*}{2}right)right)erfcleft(c + dleft(frac{z – z^*}{2j}right) right)$

Hence , the final integral can be written as,

$ointlimits_{|z| = 1}f(z)frac{dz}{iz} = 2pi f(0) = 2pierfc(a)erfc(c)$

As $0$ falls inside $|z| = 1$.

Can you tell me if I am correct or wrong or it needs more reasoning? Thank you.

php – Error al actualizar datos de usuario

Tengo el siguiente código para actualizar los datos del usuario. No se el motivo por el cual no me actualiza la información del usuario.

Este es el código:

$email=$_SESSION('email');
$sql = "SELECT * FROM usuario WHERE Correo = '$email'";
$result = $conexion->query($sql);
$row = $result->fetch_array(MYSQLI_ASSOC);

if (!empty($_POST('first_name'))) { // <= false
    $query = "UPDATE usuario SET Nombre='$_POST(first_name)' where Correo_user='$email'";
    // No está vacía (true)
}
if (!empty($_POST('last_name'))) { // <= false
    $query1 = "UPDATE usuario SET Apellido='$_POST(last_name)' where Correo_user='$email'";
    // No está vacía (true)
}
if (!empty($_POST('provincia'))) { // <= false
    $query2 = "UPDATE usuario SET Provicncia='$_POST(provincia)' where Correo_user='$email'";
    // No está vacía (true)
}
if (!empty($_POST('cp'))) { // <= false
    $query3 = "UPDATE usuario SET CP='$_POST(cp)' where Correo_user='$email'";
    // No está vacía (true)
}
$extensiones = array(0=>'image/jpg',1=>'image/jpeg',2=>'image/png');
$max_tamanyo = 1024 * 1024 * 8;

$ruta_fichero_origen = $_FILES('imagen1')('tmp_name');
$ruta_nuevo_destino = '../img/Img_profile/' . $_FILES('imagen1')('name');
if ( in_array($_FILES('imagen1')('type'), $extensiones) ) {
     if ( $_FILES('imagen1')('size')< $max_tamanyo ) {
         if($row('Img_user')!=NULL){
            unlink("../img/Img_profile/".$row('Img_user'));
         }
          if( move_uploaded_file ( $ruta_fichero_origen, $ruta_nuevo_destino ) ) {
               header('Location: panel-control.php');//redirecciona a la pagina del usuario
          }
     }
}

forms – Drupal 8: Ajax error when trying to add another paragraph

Drupal 8.9 and paragraph 8.x-1.11

I have a paragraph type:

contact_information

  • field_phone_number (telephone from core)
  • field_type_of_phone (text_plain)

I have a custom module. In this custom module I am creating a form_alter on /user/register

I have:

function telephone_alter_form_user_register_form_alter(&$form, $form_state, $form_id ){
  $form('#validate')() = 'telephone_alter_test_validate';
  //$form('field_phone')('widget')('#element_validate')() = 'telephone_alter_test_validate';
}

function telephone_alter_test_validate($form, &$form_state) {
 kint::dump(form_state);
}

The validation works, prints out debugging. However, when I try to add another element, it does nothing.

the error displayed is:

({"command":"insert","method":"prepend","selector":null,"data":"u003Cdiv data-drupal-messagesu003En  u003Cdiv class=u0022messages__wrapperu0022u003En u003Cdiv class=u0022alert alert-danger alert-dismissibleu0022 role=u0022alertu0022 aria-label=u0022Error messageu0022u003En u003Cbutton type=u0022buttonu0022 role=u0022buttonu0022 class=u0022closeu0022 data-dismiss=u0022alertu0022 aria-label=u0022Closeu0022u003Eu003Cspan aria-hidden=u0022trueu0022u003Eu0026times;u003C/spanu003Eu003C/buttonu003En u003Ch2 class=u0022sr-onlyu0022u003EError messageu003C/h2u003En u003Cpu003EAn unrecoverable error occurred. The uploaded file likely exceeded the maximum file size (40 MB) that this server supports.u003C/pu003En u003C/divu003En    u003C/divu003Enu003C/divu003En","settings":null})

Any help is great! Thank you! I can provide more info if needed

protocol buffers – Error : google/protobuf/timestamp.proto: File not found. in WINDOWS system

I need to use “Timestamp” and “Duration” Datatypes of protobuf message. I am using intellij in windows.

proto definition :

syntax = "proto3";
import "google//protobuf//timestamp.proto";
message MapAndTimestamp {
map<string, string> map = 1;
google.protobuf.Timestamp time_n = 2;
}

My Poms.xml’s build tag :

<build>
    <plugins>
        <plugin>
            <groupId>com.github.os72</groupId>
            <artifactId>protoc-jar-maven-plugin</artifactId>
            <version>3.1.0.1</version>
            <executions>
                <execution>
                    <phase>generate-sources</phase>
                    <goals>
                        <goal>run</goal>
                    </goals>
                    <configuration>
                        <protocVersion>3.1.0</protocVersion>
                        <inputDirectories>
                            <include>src/main/proto</include>
                        </inputDirectories>
                        <outputDirectory>src/main/generated</outputDirectory>
                    </configuration>
                </execution>
            </executions>
        </plugin>
    </plugins>
</build>

Dependency :

    <dependency>
        <groupId>com.google.protobuf</groupId>
        <artifactId>protobuf-java</artifactId>
        <version>3.1.0</version>
    </dependency>

Error :

[ERROR] D:workspaceprotopracsrcmainprotoadvancedMapAndTimeStamp.proto [0:0]: google/protobuf/timestamp.proto: File not found.

I could not find a solution, searching throughout.

D:workspaceprotoprac>protoc --version
libprotoc 3.5.1

Let me know what more info to provide to debug for soltion.

Thanks in advance!!

sql server – Error convert data type varchar to numeric when using a case statement order by

I am using SQL Server. I have a table called ReviewWebsite with a column Answer VARCHAR(1000) NULLABLE.

This query runs perfectly:

SELECT * FROM (SELECT CONVERT(DECIMAL(4,2),Answer) AS Rating FROM ReviewWebsite WHERE ReviewQuestionId = 2) AS tbl ORDER BY Rating DESC;

But this query causes an error:

DECLARE @SortDir VARCHAR(1000) = 'ASC';
DECLARE @SortCol VARCHAR(1000) = 'Rating';

SELECT * FROM (SELECT CONVERT(DECIMAL(4,2),Answer) AS Rating FROM ReviewWebsite WHERE ReviewQuestionId = 2) AS tbl
ORDER BY
    CASE
    WHEN @SortDir <> 'ASC' THEN ''
    WHEN @SortCol = 'Rating' THEN tbl.Rating
    END ASC,
    CASE
    WHEN @SortDir <> 'DESC' THEN ''
    WHEN @SortCol = 'Rating' THEN tbl.Rating
    END DESC;

With the error being:

Msg 8114, Level 16, State 5, Line 4
Error converting data type varchar to numeric.

What did I do wrong and how do I correct this?

Extra notes incase it matters – the query above is actually part of a bigger set of queries that are UNION together.

Solve::nsmet error message while trying to find symbolic solution for equation

I would like to solve several equations for x and I’m looking for symbolic solutions.
The later ones might have some rather difficult or no result at all, but I think I am not handling the Solve() command in the right way.

Solve((x (V/(R x))^(-b))/(1 + b) == y && b > 0, x, Reals)
Solve((2 E^(b (-Sqrt(F) + Sqrt(R x))) (-1 + b Sqrt(R x)))/(b^2 R) == y && b > 0, x, Reals)
Solve((E^(b/F)*((R*x)/E^(b/(R*x)) + b*ExpIntegralEi(-(b/(R*x)))))/R == y && b > 0, x, Reals)

Mathematica returns the message During evaluation of In(1):= Solve::nsmet: This system cannot be solved with the methods available to Solve.

What is the correct input for these types of problems?