问:
main.ts depends on 'core-js/es7/reflect' and Error: Module not found: Error: Can't resolve 'core-js/es/reflect'
I'm using Angular 15.0.4 and when I run ng serve -o to launch my app, the app doesn't compile and run, and I get this message:

```<code>√ Browser application bundle generation complete.

Initial Chunk Files   | Names         |  Raw Size
vendor.js             | vendor        |   3.55 MB |
styles.css, styles.js | styles        | 351.25 kB |
polyfills.js          | polyfills     | 314.27 kB |
main.js               | main          |  72.00 kB |
runtime.js            | runtime       |   6.51 kB |

                      | Initial Total |   4.28 MB

Build at: 2023-01-11T15:32:28.997Z - Hash: 7b4d3ef0affc1690 - Time: 7179ms

Warning: C:\work-temp\angular-example\QuickCBT\src\main.ts depends on 'core-js/es7/reflect'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

./src/main.ts:4:0-29 - Error: Module not found: Error: Can't resolve 'core-js/es/reflect' in 'C:\work-temp\angular-example\QuickCBT\src'

** Angular Live Development Server is listening on localhost:4200, open your browser on http://localhost:4200/ **

× Failed to compile.
</code>```

How can I fix this?

I should note that I already installed core-js@2.5.x by running npm install --save core-js@^2.5.0, following the answers of this question: Error: Can't resolve 'core-js/es7/reflect' in '\node_modules\@angular-devkit\build-angular\src\angular-cli-files\models

Update: I installed core-js@3 and the second error disappeared, but the first error persists.

Here is the output now:

```<code>ng serve -o √ Browser application bundle generation complete.

Initial Chunk Files   | Names         |  Raw Size vendor.js            | vendor        |   3.58 MB | styles.css, styles.js | styles        |
351.25 kB | polyfills.js          | polyfills     | 314.27 kB | main.js               | main          |  72.00 kB | runtime.js         | runtime       |   6.51 kB |

                      | Initial Total |   4.30 MB

Build at: 2023-01-11T16:43:11.909Z - Hash: 77cd44828399b547 - Time: 8190ms

Warning: C:\work-temp\angular-example\QuickCBT\src\main.ts depends on 'core-js/es/reflect'. CommonJS or AMD dependencies can cause optimization bailouts. For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

./src/main.ts:6:0-30 - Error: Module not found: Error: Can't resolve 'core-js/es7/reflect' in 'C:\work-temp\angular-example\QuickCBT\src'

** Angular Live Development Server is listening on localhost:4200, open your browser on http://localhost:4200/ **

× Failed to compile.
</code>```

Note: I have cypress installed in my Angular project.

Here is the code with the problem:

```<code>// cypress/support/index.ts
// core-js 3.*

require('core-js/es/reflect'); //  I'm keeping only this import statement
// core-js 2.*

//require('cypress-angular-unit-test/support');

import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';

import { AppModule } from './app/app.module';

platformBrowserDynamic().bootstrapModule(AppModule)
  .catch(err => console.error(err));
</code>```

This code was likely added by cypress:

```<code>require('core-js/es/reflect');

require('core-js/es7/reflect');
</code>```

Update: I commented out the above lines the app now works. Cypress also works.

Body:
I'm using Angular 15.0.4 and when I run ng serve -o to launch my app, the app doesn't compile and run, and I get this message:

√ Browser application bundle generation complete.

Initial Chunk Files   | Names         |  Raw Size
vendor.js             | vendor        |   3.55 MB |
styles.css, styles.js | styles        | 351.25 kB |
polyfills.js          | polyfills     | 314.27 kB |
main.js               | main          |  72.00 kB |
runtime.js            | runtime       |   6.51 kB |

                      | Initial Total |   4.28 MB

Build at: 2023-01-11T15:32:28.997Z - Hash: 7b4d3ef0affc1690 - Time: 7179ms

Warning: C:\work-temp\angular-example\QuickCBT\src\main.ts depends on 'core-js/es7/reflect'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

./src/main.ts:4:0-29 - Error: Module not found: Error: Can't resolve 'core-js/es/reflect' in 'C:\work-temp\angular-example\QuickCBT\src'

** Angular Live Development Server is listening on localhost:4200, open your browser on http://localhost:4200/ **

× Failed to compile.

How can I fix this?

I should note that I already installed core-js@2.5.x by running npm install --save core-js@^2.5.0, following the answers of this question: Error: Can't resolve 'core-js/es7/reflect' in '\node_modules\@angular-devkit\build-angular\src\angular-cli-files\models

Update: I installed core-js@3 and the second error disappeared, but the first error persists.

Here is the output now:

ng serve -o √ Browser application bundle generation complete.

Initial Chunk Files   | Names         |  Raw Size vendor.js            | vendor        |   3.58 MB | styles.css, styles.js | styles        |
351.25 kB | polyfills.js          | polyfills     | 314.27 kB | main.js               | main          |  72.00 kB | runtime.js         | runtime       |   6.51 kB |

                      | Initial Total |   4.30 MB

Build at: 2023-01-11T16:43:11.909Z - Hash: 77cd44828399b547 - Time: 8190ms

Warning: C:\work-temp\angular-example\QuickCBT\src\main.ts depends on 'core-js/es/reflect'. CommonJS or AMD dependencies can cause optimization bailouts. For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

./src/main.ts:6:0-30 - Error: Module not found: Error: Can't resolve 'core-js/es7/reflect' in 'C:\work-temp\angular-example\QuickCBT\src'

** Angular Live Development Server is listening on localhost:4200, open your browser on http://localhost:4200/ **

× Failed to compile.

Note: I have cypress installed in my Angular project.

Here is the code with the problem:

// cypress/support/index.ts
// core-js 3.*

require('core-js/es/reflect'); //  I'm keeping only this import statement
// core-js 2.*

//require('cypress-angular-unit-test/support');

import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';

import { AppModule } from './app/app.module';

platformBrowserDynamic().bootstrapModule(AppModule)
  .catch(err => console.error(err));

This code was likely added by cypress:

require('core-js/es/reflect');

require('core-js/es7/reflect');

Update: I commented out the above lines the app now works. Cypress also works.


来源: stackexchange

问:
XCode - ITMS-90426: Invalid Swift Support
I receive the following mail after the upload of my app form xCode to the Apple Connect platform.

```<code>Dear Developer,

We identified one or more issues with a recent delivery for your app, <APPNAME> 0.23.0 (10). Please correct the following issues, then upload again.

ITMS-90426: Invalid Swift Support - The SwiftSupport folder is missing. Rebuild your app using the current public (GM) version of Xcode and resubmit it.

Best regards,

The App Store Team
</code>```

Before uploading, I correctly validate the version, and xcode gives me the validation.

Do someone know how resolve this issue?

I have tried to follow some other Stakoverflow answers:

Go to Targets > YourApp > Build Settings

Defines Module: No

Always Embed Swift Standard Libraries: Yes

With no results

I'm running MacOS Ventura 13.1 and Xcode 14.2

ContentLicense: CC BY-SA 4.0

Body:
I receive the following mail after the upload of my app form xCode to the Apple Connect platform.

Dear Developer,

We identified one or more issues with a recent delivery for your app, <APPNAME> 0.23.0 (10). Please correct the following issues, then upload again.

ITMS-90426: Invalid Swift Support - The SwiftSupport folder is missing. Rebuild your app using the current public (GM) version of Xcode and resubmit it.

Best regards,

The App Store Team

Before uploading, I correctly validate the version, and xcode gives me the validation.

Do someone know how resolve this issue?

I have tried to follow some other Stakoverflow answers:

Go to Targets > YourApp > Build Settings

Defines Module: No

Always Embed Swift Standard Libraries: Yes

With no results

I'm running MacOS Ventura 13.1 and Xcode 14.2


问:
Dataframe containing np.arrays in each cell into Machine learning method
I have a pandas dataframe containing np.arrays in each cell (see the photo to understand better). Each array is 1000 samples long. However, when trying to use this as a training data in LSTM, it won't go through. enter image description here

model.fit(x_train, y_train, epochs = 15)

ValueError: Failed to convert a NumPy array to a Tensor (Unsupported object type numpy.ndarray).

How do I tackle this? Can't find an answer elsewhere, tried this:
 x_train=np.asarray(x_train).astype(np.float32)

but it failed due ValueError: setting an array element with a sequence.

Is there another way to use this sort of numpy arrays as input?

I was trying to train LSTM with my pandas dataframe data containing 1000 sample long np.arrays


问:
CAST jsonb column into INT[]
I'm in a situation where I get a jsonb value (from the scrape field which is jsonb) that looks like this:

```<code>SELECT COALESCE(scrape->'amenity_ids', '[]'::jsonb) AS ids
FROM my_table

ids                                                                                |
-------------------------------------------------------------------------------------------------------------+
[]                                                                                |
[33, 34, 35, 4, 5, 37, 8, 40, 9, 41, 42, 11, 44, 45, 46, 47, 16, 21, 56]                                     |
[129, 35, 4, 36, 37, 103, 40, 41, 45, 77, 17, 23, 30]                                                        |
[1, 33, 34, 35, 4, 36, 8, 40, 41, 44, 45, 77, 46, 47, 85, 56, 90, 91, 92, 93, 30, 95]                        |
[1, 129, 2, 4, 8, 9, 77, 85, 89, 90, 91, 92, 93, 30, 94, 95, 96, 33, 34, 100, 37, 38, 40, 41, 44, 45, 46, 57]|
</code>```

Note that there are NULL values in the jsonb object. So at this point ids is going to be of type jsonb and what I need is to have an array of integers as I'm trying to query for:

```<code>SELECT int_array_ids @> '{33,34,35}' FROM my_table;
</code>```

Once I'm able to have a converted ids to INT[] I can create indexes to speed my array contains queries.

I tried a subquery using array_agg but it's terrible slow:

```<code>SELECT array_agg(arrayed.am_id) FROM (
    SELECT
        id,
        jsonb_array_elements_text(scrape->'amenity_ids') AS am_id
    FROM my_table
) AS arrayed
GROUP BY arrayed.id
</code>```

Title: CAST jsonb column into INT[]

Body:
I'm in a situation where I get a jsonb value (from the scrape field which is jsonb) that looks like this:

SELECT COALESCE(scrape->'amenity_ids', '[]'::jsonb) AS ids
FROM my_table

ids                                                                                |
-------------------------------------------------------------------------------------------------------------+
[]                                                                                |
[33, 34, 35, 4, 5, 37, 8, 40, 9, 41, 42, 11, 44, 45, 46, 47, 16, 21, 56]                                     |
[129, 35, 4, 36, 37, 103, 40, 41, 45, 77, 17, 23, 30]                                                        |
[1, 33, 34, 35, 4, 36, 8, 40, 41, 44, 45, 77, 46, 47, 85, 56, 90, 91, 92, 93, 30, 95]                        |
[1, 129, 2, 4, 8, 9, 77, 85, 89, 90, 91, 92, 93, 30, 94, 95, 96, 33, 34, 100, 37, 38, 40, 41, 44, 45, 46, 57]|

Note that there are NULL values in the jsonb object. So at this point ids is going to be of type jsonb and what I need is to have an array of integers as I'm trying to query for:

SELECT int_array_ids @> '{33,34,35}' FROM my_table;

Once I'm able to have a converted ids to INT[] I can create indexes to speed my array contains queries.

I tried a subquery using array_agg but it's terrible slow:

SELECT array_agg(arrayed.am_id) FROM (
    SELECT
        id,
        jsonb_array_elements_text(scrape->'amenity_ids') AS am_id
    FROM my_table
) AS arrayed
GROUP BY arrayed.id


问:
Scraping Interactive Line Charts with Python
I would like to know how to extract the data that popped up when the mouse hovers over a certain time frame inside a graph panel.

The website is
https://app.truflation.com/

Data Graph Image

I tried Use Selenium to webscrape the data that popped up. There was a solution from https://towardsdatascience.com/scraping-interactive-charts-with-python-2bc20a9c7f5c and https://youtu.be/lTypMlVBFM4 but the difference here is I cannot capture the XPATH of the popup message.

from selenium import webdriver

DRIVER_PATH = '/Users/hudso/OneDrive/Documents/UST course/chromedriver.exe'
driver = webdriver.Chrome(executable_path=DRIVER_PATH)
driver.get("https://app.truflation.com/")
datas = driver.find_element_by_class_name('overlay')
for data in datas:
    Date = data.find_element_by_xpath('.//*[@id="trufrate-timeframe"]/g[2]/text[1]').text
    Inflation = data.find_element_by_xpath('.//*[@id="trufrate-timeframe"]/g[2]').text
    print(Date,Inflation)
```

I tried many different versions and this one seems to be closer. I am yet to print Date and Inflation, so not yet applied it to dataframe.

Body:
I would like to know how to extract the data that popped up when the mouse hovers over a certain time frame inside a graph panel.

The website is
https://app.truflation.com/

Data Graph Image

I tried Use Selenium to webscrape the data that popped up. There was a solution from https://towardsdatascience.com/scraping-interactive-charts-with-python-2bc20a9c7f5c and https://youtu.be/lTypMlVBFM4 but the difference here is I cannot capture the XPATH of the popup message.

from selenium import webdriver

DRIVER_PATH = '/Users/hudso/OneDrive/Documents/UST course/chromedriver.exe'
driver = webdriver.Chrome(executable_path=DRIVER_PATH)
driver.get("https://app.truflation.com/")
datas = driver.find_element_by_class_name('overlay')
for data in datas:
    Date = data.find_element_by_xpath('.//*[@id="trufrate-timeframe"]/g[2]/text[1]').text
    Inflation = data.find_element_by_xpath('.//*[@id="trufrate-timeframe"]/g[2]').text
    print(Date,Inflation)

I tried many different versions and this one seems to be closer. I am yet to print Date and Inflation, so not yet applied it to dataframe.


问:
Why some tasks in Gradle Signing Report use different paths to keystore file?
I use React Native on Windows, and when i want to know SHA fingerprints with command ./gradlew signingReport in folder android, in some tasks i see SHA from different files.

Why it happens? Shouldn't a project use a keystore file in the project itself? What is the keystore file in the user's folder for then?

Screenshot


问:
Why doesn't my formula calculate after I enter it?
I get an application defined error when my program enters this data into the cell.

```<code>Range("$H$7").Formula = "=S:/Finance/Budget & Forecast/2023/2023 Budget/Chapters/030 - New England/[030 - New England.xlsm]Consolidated'!" & Budget
</code>```

It enters it fine if I don't include the "=" sign, but does not calculate. I thought making this a .formula instead of a .value would automatically do this formula's calculation. No?

I've tried researching this, and I've tried putting double quotes around the string portion, it gives me "compile error: expected line number or label or statement or end of statement".

Ultimately, I just want this to give me the results of this formula when VBA enters it, just as if I typed it in, but with the dynamic term Budget at the end giving me the cell address (which is populating fine, via vlookup).

Body:
I get an application defined error when my program enters this data into the cell.

Range("$H$7").Formula = "=S:/Finance/Budget & Forecast/2023/2023 Budget/Chapters/030 - New England/[030 - New England.xlsm]Consolidated'!" & Budget

It enters it fine if I don't include the "=" sign, but does not calculate. I thought making this a .formula instead of a .value would automatically do this formula's calculation. No?

I've tried researching this, and I've tried putting double quotes around the string portion, it gives me "compile error: expected line number or label or statement or end of statement".

Ultimately, I just want this to give me the results of this formula when VBA enters it, just as if I typed it in, but with the dynamic term Budget at the end giving me the cell address (which is populating fine, via vlookup).


问:
Flutter: Make a list item expand to a pop-up on press?
I have a list in my flutter app that displays some facts, I would like to make it so when I click any of the facts in the list, it animates, expands to a larger pop-up kind of screen that shows a the fact text and some buttons below like "save" inside the pop-up. Upon pressing "back" it should animate back to the list.

I have created an animation in a video editor to show the behavior I'm trying to achieve: https://drive.google.com/file/d/16GsJ1J89jn2CCVnuUecoy7VsF7BRdKF_/view?usp=sharing

Here's my build function currently:

```<code>// Main UI Build function
  @override
  Widget build(BuildContext context) {
    return Scaffold(
        appBar: const PreferredSize(
            preferredSize: Size.fromHeight(50), child: FactsAppBar()),
        drawer: const FactsAppDrawer(),
        body: GlowingOverscrollIndicator(
          axisDirection: AxisDirection.down,
          color: Theme.of(context).primaryColor,
          child: ListView.separated(
            // Render List View
            itemCount: widgetsList
                .length, // Set item count from the previously generated list
            physics:
                const AlwaysScrollableScrollPhysics(),
            itemBuilder: (_, int index) =>
                widgetsList[index], // Build items from the generated list
            separatorBuilder: (_, div) => const Divider(
              // Build separator between the items
              thickness: 1.5,
            ),
          ),
        ));
  }
</code>```

Note: The widgetsList is a list of the facts generated during the screen load.

Body:
I have a list in my flutter app that displays some facts, I would like to make it so when I click any of the facts in the list, it animates, expands to a larger pop-up kind of screen that shows a the fact text and some buttons below like "save" inside the pop-up. Upon pressing "back" it should animate back to the list.

I have created an animation in a video editor to show the behavior I'm trying to achieve: https://drive.google.com/file/d/16GsJ1J89jn2CCVnuUecoy7VsF7BRdKF_/view?usp=sharing

Here's my build function currently:

// Main UI Build function
  @override
  Widget build(BuildContext context) {
    return Scaffold(
        appBar: const PreferredSize(
            preferredSize: Size.fromHeight(50), child: FactsAppBar()),
        drawer: const FactsAppDrawer(),
        body: GlowingOverscrollIndicator(
          axisDirection: AxisDirection.down,
          color: Theme.of(context).primaryColor,
          child: ListView.separated(
            // Render List View
            itemCount: widgetsList
                .length, // Set item count from the previously generated list
            physics:
                const AlwaysScrollableScrollPhysics(),
            itemBuilder: (_, int index) =>
                widgetsList[index], // Build items from the generated list
            separatorBuilder: (_, div) => const Divider(
              // Build separator between the items
              thickness: 1.5,
            ),
          ),
        ));
  }

Note: The widgetsList is a list of the facts generated during the screen load.


问:
How to use one component in another component vuejs
```<code><my-comp
title="title"
craps="one->two->three"
/>

<bread :record="record">

data(){
return {
 record = [{title: 'name', item: 'one'}, {title: 'name', item:'two'}];
}
}
</code>```

I wanted to use <bread component in  component under craps like this

```<code><my-comp
title="title"
craps=<bread :record="record">
/>
</code>```

what is the process to use of it please guide

Thank you

Body:
<my-comp
title="title"
craps="one->two->three"
/>

<bread :record="record">

data(){
return {
 record = [{title: 'name', item: 'one'}, {title: 'name', item:'two'}];
}
}

I wanted to use <bread component in  component under craps like this

<my-comp
title="title"
craps=<bread :record="record">
/>

what is the process to use of it please guide

Thank you


问:
SSLError error : HTTPSConnectionPool Python
I am trying to hit two LinkedIn URLs using the python requests module. But getting the attached error for both the urls.

```<code>proxies_list = [
    'https://xxx.xxx.xx.19:8080',
    'http://109.xxx.xx.40:9090',
    'https://xxx.60.xxx.69:53281']

ua = UserAgent()
    headers = {'User-Agent': ua.random}

    proxy = random.choice(proxies_list)

    proxies = {
        'http': proxy,
        'https': proxy,
    }
    try:
        response = requests.get(URL, headers=headers, proxies=proxies)
        print(response.text)
    except Exception as e:
        print(e)
</code>```

I am getting below error for both the urls:

Error 1:
HTTPSConnectionPool(host='www.linkedin.com', port=443): Max retries exceeded with url: /xxxx/xxxx/ (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)')))

Error 2:
HTTPConnectionPool(host='xxx.48.68.xxx', port=8x): Max retries exceeded with url: http://www.linkedin.com/xxx/xxx/ (Caused by ProxyError('Cannot connect to proxy.', ConnectionResetError(54, 'Connection reset by peer')))

Can someone help me resolve this?

Also, I do get below error as well intermittently.
HTTPSConnectionPool(host='www.linkedin.com', port=443): Max retries exceeded with url: /xxx/xxx/ (Caused by ProxyError('Cannot connect to proxy.', OSError('Tunnel connection failed: 400 Bad Request')))

What does this signify?

Body:
I am trying to hit two LinkedIn URLs using the python requests module. But getting the attached error for both the urls.

proxies_list = [
    'https://xxx.xxx.xx.19:8080',
    'http://109.xxx.xx.40:9090',
    'https://xxx.60.xxx.69:53281']

ua = UserAgent()
    headers = {'User-Agent': ua.random}

    proxy = random.choice(proxies_list)

    proxies = {
        'http': proxy,
        'https': proxy,
    }
    try:
        response = requests.get(URL, headers=headers, proxies=proxies)
        print(response.text)
    except Exception as e:
        print(e)

I am getting below error for both the urls:

Error 1:
HTTPSConnectionPool(host='www.linkedin.com', port=443): Max retries exceeded with url: /xxxx/xxxx/ (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)')))

Error 2:
HTTPConnectionPool(host='xxx.48.68.xxx', port=8x): Max retries exceeded with url: http://www.linkedin.com/xxx/xxx/ (Caused by ProxyError('Cannot connect to proxy.', ConnectionResetError(54, 'Connection reset by peer')))

Can someone help me resolve this?

Also, I do get below error as well intermittently.
HTTPSConnectionPool(host='www.linkedin.com', port=443): Max retries exceeded with url: /xxx/xxx/ (Caused by ProxyError('Cannot connect to proxy.', OSError('Tunnel connection failed: 400 Bad Request')))

What does this signify?


问:
how to add a new row in my User Table stores in a sql server
I want to add a new user in user table from R here is my way of doing it:

```<code>con<-dbConnect(odbc::odbc(),
Driver = "SQL Server",
Server = "my server adresse",
Database = "name_DataBase",
UID = "ID",
PWD = "pwd"
)

formData <- data.frame(CLE =as.integer(198),LOG ="user",PASSWORD="pwd",PROFIL = as.integer(2),ETB =as.integer(3),CREA =as.POSIXct(Sys.time(),format="%Y-%m-%d %H:%M:%S"),ETAT = "A")
</code>```

Here are the different column types of my user table at the sql server level:

```<code>CLE = int identity,LOG= nvarchar,PASSWORD =  varbinary,PROFIL= int,ETB  = int  ,CREA= smalldatime,ETAT= nvarchar
</code>```

add a new line:

```<code>dbAppendTable(conn = con,
name = Id(schema = "x", table = "User"),
value = formData,
row.names = NULL)
</code>```

here is the error:

```<code>Error in result_insert_dataframe(rs@ptr, values, batch_rows) :
nanodbc/nanodbc.cpp:1655: 22018: \[Microsoft\]\[ODBC SQL Server Driver\]Valeur de caractère non valide pour la spécification de la casse
</code>```

I'm waiting for your help

Body:
I want to add a new user in user table from R here is my way of doing it:

con<-dbConnect(odbc::odbc(),
Driver = "SQL Server",
Server = "my server adresse",
Database = "name_DataBase",
UID = "ID",
PWD = "pwd"
)

formData <- data.frame(CLE =as.integer(198),LOG ="user",PASSWORD="pwd",PROFIL = as.integer(2),ETB =as.integer(3),CREA =as.POSIXct(Sys.time(),format="%Y-%m-%d %H:%M:%S"),ETAT = "A")

Here are the different column types of my user table at the sql server level:

CLE = int identity,LOG= nvarchar,PASSWORD =  varbinary,PROFIL= int,ETB  = int  ,CREA= smalldatime,ETAT= nvarchar

add a new line:

dbAppendTable(conn = con,
name = Id(schema = "x", table = "User"),
value = formData,
row.names = NULL)

here is the error:

Error in result_insert_dataframe(rs@ptr, values, batch_rows) :
nanodbc/nanodbc.cpp:1655: 22018: \[Microsoft\]\[ODBC SQL Server Driver\]Valeur de caractère non valide pour la spécification de la casse

I'm waiting for your help


问:
Why do people typically call classes "Foo"?
This is not a problem. I am interested in why people call their classes "Foo", of all words to choose. Does "Foo" have a specific meaning / stand for something?</p>


问:
how to handle file input from an HTML form using py-script?
I am using pyscript implement Python3 code into HTML files. I am currently trying to have a user submit a form and then I will run an algorithm on the data that is inside the form, ideally a .txt file.

Here is my table

  <form target="k">
    Number of Tables

    <input
      type="number"
      class="form-control"
      id="numberOfTables"
      aria-describedby="numberOfTables"
      placeholder="Number of Tables as an integer"
    />

      List of Students with name, sex, group number (example file here)

    <input
      type="file"
      class="form-control"
      id="studentList"
      aria-describedby="studentList"
      placeholder="Student list as a .txt file"
    />

    <input
      type="submit"
      id="button"
      class="btn btn-primary"
      py-click="test()"
      value="Display Tables"
    />
  </form>

```
<p>I am able to access "numberOfTables" once the form is submitted through the following code:</p>
<pre class="lang-html prettyprint-override"><code><py-script>
def test():
    number = Element("numberOfTables").value
</py-script>
</code>```

But how would I access the information in the file? If I try to just do Element(studentList).value, then i get the string C:\fakepath\filename.txt.

Body:
I am using pyscript implement Python3 code into HTML files. I am currently trying to have a user submit a form and then I will run an algorithm on the data that is inside the form, ideally a .txt file.

Here is my table

  <form target="k">
    Number of Tables

    <input
      type="number"
      class="form-control"
      id="numberOfTables"
      aria-describedby="numberOfTables"
      placeholder="Number of Tables as an integer"
    />

      List of Students with name, sex, group number (example file here)

    <input
      type="file"
      class="form-control"
      id="studentList"
      aria-describedby="studentList"
      placeholder="Student list as a .txt file"
    />

    <input
      type="submit"
      id="button"
      class="btn btn-primary"
      py-click="test()"
      value="Display Tables"
    />
  </form>

I am able to access "numberOfTables" once the form is submitted through the following code:

<py-script>
def test():
    number = Element("numberOfTables").value
</py-script>

But how would I access the information in the file? If I try to just do Element(studentList).value, then i get the string C:\fakepath\filename.txt.


问:
Xcode 14 - Storyboard localization and internationalization doesn't work
I enabled localization for Storyboard,

Added French and English Localizations

When device language is French, it doesn't work. Device language:

And SplashScreen not translated:

How to resolve the issue?


问:
Wireless Tools: how to cross compile?
I tried to cross compile Wireless Tools for MIPS architecture by modifying Makefile

## Compiler to use (modify this for cross compile).
#CC = gcc
CC=/home/mips-gcc472-glibc216-64bit-r2.3.3/mips-gcc472-glibc216-64bit/bin/mips-linux-gnu-gcc

## Other tools you need to modify for cross compile (static lib only).
AR = ar
RANLIB = ranlib
```

I can build it successfully with there modified Makefile, but the tool fail to install. So I think something wrong with my modified Makefile. Do I feed wrong CC parameter or It need more step to build Wireless Tools with cross compile?

Title: Wireless Tools: how to cross compile?

Body:
I tried to cross compile Wireless Tools for MIPS architecture by modifying Makefile

## Compiler to use (modify this for cross compile).
#CC = gcc
CC=/home/mips-gcc472-glibc216-64bit-r2.3.3/mips-gcc472-glibc216-64bit/bin/mips-linux-gnu-gcc

## Other tools you need to modify for cross compile (static lib only).
AR = ar
RANLIB = ranlib

I can build it successfully with there modified Makefile, but the tool fail to install. So I think something wrong with my modified Makefile. Do I feed wrong CC parameter or It need more step to build Wireless Tools with cross compile?


问:
R shiny sortable clone element in rank list not working
I have a shiny app where the user uploads a csv file. Then, using the column names from the csv file, I create sortable bucket list. I would like drag the column name from the first rank list and have it cloned (i.e. not depleted). I tried to use the options parameter in add_rank_list() setting pull='clone', but that did not work. Any idea on how to do this? Below is my code, and some fake data can be accessed here.

```<code>library(shiny)
library(shinyjs)
library(sortable)

ui <- fluidPage(

  titlePanel("App"),

  sidebarLayout(
    sidebarPanel(
      useShinyjs(),
      fileInput(inputId = "file1", label = "Select a .csv file",
                accept = c("text/csv", "text/comma-separated-values,text/plain",".csv")
      ),
      uiOutput("show_button")
    ),

    mainPanel(
      DT::dataTableOutput("table")
    )
  ),

  fluidRow(uiOutput("buckets"))

)

server <- function(input, output) {

  # input csv file
  input_file <- reactive({
    if (is.null(input$file1)) {
      return("")
    }

    # actually read the file
    read.csv(file = input$file1$datapath)
  })

  # button to hide/show table

  ## only show when table is loaded
  output$show_button = renderUI({
    req(input$file1)
    actionButton(inputId = "button", label = "show / hide table")
  })

  ## observe the button being pressed
  observeEvent(input$button, {
    shinyjs::toggle("table")
  })

  # output table
  output$table <- DT::renderDataTable({

    # render only if there is data available
    req(input_file())

    # reactives are only callable inside an reactive context like render
    data <- input_file()
    data

  })

  # Drag and Drop Col names
  output$buckets = renderUI(
    {
      # create list of colnames
      req(input$file1)
      data = input_file()
      cols = colnames(data)

      # create bucket list
      bucket_list(
        header = "Drag the items in any desired bucket",
        group_name = "bucket_list_group",
        orientation = "horizontal",

        add_rank_list(
          text = "Drag from here",
          labels = as.list(cols),
          input_id = "rank_list_1",
          css_id = "list1",
          options = sortable_options(
            group = list(
              pull = "clone",
              name = "list_group1",
              put = FALSE))
        ),

        add_rank_list(
          text = "to here",
          labels = NULL,
          input_id = "rank_list_2",
          css_id = "list2",
          options = sortable_options(group = list(name = "list_group1")))
      )

    })

}

# Run the application
shinyApp(ui = ui, server = server)
</code>```

Body:
I have a shiny app where the user uploads a csv file. Then, using the column names from the csv file, I create sortable bucket list. I would like drag the column name from the first rank list and have it cloned (i.e. not depleted). I tried to use the options parameter in add_rank_list() setting pull='clone', but that did not work. Any idea on how to do this? Below is my code, and some fake data can be accessed here.

library(shiny)
library(shinyjs)
library(sortable)

ui <- fluidPage(

  titlePanel("App"),

  sidebarLayout(
    sidebarPanel(
      useShinyjs(),
      fileInput(inputId = "file1", label = "Select a .csv file",
                accept = c("text/csv", "text/comma-separated-values,text/plain",".csv")
      ),
      uiOutput("show_button")
    ),

    mainPanel(
      DT::dataTableOutput("table")
    )
  ),

  fluidRow(uiOutput("buckets"))

)

server <- function(input, output) {

  # input csv file
  input_file <- reactive({
    if (is.null(input$file1)) {
      return("")
    }

    # actually read the file
    read.csv(file = input$file1$datapath)
  })

  # button to hide/show table

  ## only show when table is loaded
  output$show_button = renderUI({
    req(input$file1)
    actionButton(inputId = "button", label = "show / hide table")
  })

  ## observe the button being pressed
  observeEvent(input$button, {
    shinyjs::toggle("table")
  })

  # output table
  output$table <- DT::renderDataTable({

    # render only if there is data available
    req(input_file())

    # reactives are only callable inside an reactive context like render
    data <- input_file()
    data

  })

  # Drag and Drop Col names
  output$buckets = renderUI(
    {
      # create list of colnames
      req(input$file1)
      data = input_file()
      cols = colnames(data)

      # create bucket list
      bucket_list(
        header = "Drag the items in any desired bucket",
        group_name = "bucket_list_group",
        orientation = "horizontal",

        add_rank_list(
          text = "Drag from here",
          labels = as.list(cols),
          input_id = "rank_list_1",
          css_id = "list1",
          options = sortable_options(
            group = list(
              pull = "clone",
              name = "list_group1",
              put = FALSE))
        ),

        add_rank_list(
          text = "to here",
          labels = NULL,
          input_id = "rank_list_2",
          css_id = "list2",
          options = sortable_options(group = list(name = "list_group1")))
      )

    })

}

# Run the application
shinyApp(ui = ui, server = server)


问:
The Crystal Report in My Computer is running but in My Client computer's Not Running and Show ERRO 4060
I'm Create dataset and fill it's from datagridview and create crystal report the it's Data source
of ADO.NET(XML) And everything is good and it is running in my computer but after convert into exe and install it in client computer is not running and show
message failed to open the connection code 4060</p>


问:
How to hide particular Schemas/models that are shown in end of swagger documentation page in NestJS?
I want to hide some schemas from the Swagger documentation page in NestJS. I have already checked the issue but it is for hiding all the schemas.
I want to show only few schemas in the documentation page. I have tried renaming the DTO from file name and Class names but the schema is not hiding.


问:
How to fix "Failed to execute 'getImageData' on 'CanvasRenderingContext2D': The canvas has been tainted by cross-origin data."
I am trying to make a web page where you can put a link of a video and it will draw square over it, when I use chrome it gives this error:

face-api.min.js:1 Uncaught (in promise) DOMException: Failed to
execute 'getImageData' on 'CanvasRenderingContext2D': The canvas has
been tainted by cross-origin data.

when I try firefox it gives this error

Uncaught (in promise) DOMException: The operation is insecure.

my code

html:

```<code><!DOCTYPE html>
    <html lang="en">
      <head>
        <meta charset="UTF-8" />
        <meta name="viewport" content="width=device-width, initial-scale=1.0" />
        <meta http-equiv="X-UA-Compatible" content="ie=edge" />
        <title>Document</title>
        <script defer src="face-api.min.js"></script>
        <script defer src="script.js"></script>
        <style>
          * {
            padding: none;
            margin: none;
          }
          body {
            background-color: black;
          }
          #video {
            height: 100%;
            width: 100%;
            position: absolute;
            left: 0px;
            right: 0px;
            top: 0px;
            margin: auto;
          }

          canvas {
            position: absolute;
          }
        </style>
      </head>
      <body>
        <video id="video" width="100%" height="100%" autoplay controls></video>
      </body>
    </html>
</code>```

JS:

```<code>const video = document.getElementById("video");
const url = prompt("Enter The Url For Video");
video.src = url
Promise.all([
  faceapi.nets.tinyFaceDetector.loadFromUri("models"),
  faceapi.nets.faceLandmark68Net.loadFromUri("models"),
  faceapi.nets.faceRecognitionNet.loadFromUri("models"),
  faceapi.nets.faceExpressionNet.loadFromUri("models"),
]).then(startVideo);

function startVideo() {
  console.log("video started");
}

video.addEventListener("play", () => {
  const canvas = faceapi.createCanvasFromMedia(video);
  document.body.append(canvas);
  const displaySize = { width: video.width, height: video.height };
  faceapi.matchDimensions(canvas, displaySize);
  setInterval(async () => {
    const detections = await faceapi
      .detectAllFaces(video, new faceapi.TinyFaceDetectorOptions())
      .withFaceLandmarks()
      .withFaceExpressions();
    const resizedDetections = faceapi.resizeResults(detections, displaySize);
    canvas.getContext("2d").clearRect(0, 0, canvas.width, canvas.height);
    canvas.crossOrigin = "Anonymous";
    faceapi.draw.drawDetections(canvas, resizedDetections);
  }, 100);
});
</code>```

Body:
I am trying to make a web page where you can put a link of a video and it will draw square over it, when I use chrome it gives this error:

face-api.min.js:1 Uncaught (in promise) DOMException: Failed to
execute 'getImageData' on 'CanvasRenderingContext2D': The canvas has
been tainted by cross-origin data.

when I try firefox it gives this error

Uncaught (in promise) DOMException: The operation is insecure.

my code

html:

<!DOCTYPE html>

        <meta charset="UTF-8" />
        <meta name="viewport" content="width=device-width, initial-scale=1.0" />
        <meta http-equiv="X-UA-Compatible" content="ie=edge" />
        <title>Document</title>

        <video id="video" width="100%" height="100%" autoplay controls></video>

JS:

const video = document.getElementById("video");
const url = prompt("Enter The Url For Video");
video.src = url
Promise.all([
  faceapi.nets.tinyFaceDetector.loadFromUri("models"),
  faceapi.nets.faceLandmark68Net.loadFromUri("models"),
  faceapi.nets.faceRecognitionNet.loadFromUri("models"),
  faceapi.nets.faceExpressionNet.loadFromUri("models"),
]).then(startVideo);

function startVideo() {
  console.log("video started");
}

video.addEventListener("play", () => {
  const canvas = faceapi.createCanvasFromMedia(video);
  document.body.append(canvas);
  const displaySize = { width: video.width, height: video.height };
  faceapi.matchDimensions(canvas, displaySize);
  setInterval(async () => {
    const detections = await faceapi
      .detectAllFaces(video, new faceapi.TinyFaceDetectorOptions())
      .withFaceLandmarks()
      .withFaceExpressions();
    const resizedDetections = faceapi.resizeResults(detections, displaySize);
    canvas.getContext("2d").clearRect(0, 0, canvas.width, canvas.height);
    canvas.crossOrigin = "Anonymous";
    faceapi.draw.drawDetections(canvas, resizedDetections);
  }, 100);
});


问:
Nuget package manager: can not install/update packages in my visual studio solution
I try to install a nuget package in my software project in visual studio 2022 (Version 17.4.4) with PM-console with the command:

Install-Package Microsoft.Extensions.ObjectPool -ProjectName

I get the following error message:

Sorry the original error message is in german language
Install-Package : Ungültige Wiederherstellungseingabe. Die erforderliche Eigenschaft "ProjectName" fehlt.
Eingabedateien: Drive:<PathToProject><Another project in soulution>.csproj.
In Zeile:1 Zeichen:1

Install-Package Microsoft.Extensions.ObjectPool -ProjectName

```<code>  + CategoryInfo          : NotSpecified: (:) [Install-Package], Exception
  + FullyQualifiedErrorId : NuGetCmdletUnhandledException,NuGet.PackageManagement.PowerShellCmdlets.InstallPackageCommand

</code>```

The Error message means:
Install-Package : Invalid restore input. The required property "ProjectName" is missing.
Input files: Drive:<PathToProject><Another project in solution>.csproj.
In Line:1 Character:1

Nuget version please see here:

Name             : Package Manager Host
Version          : 6.4.0.111
InstanceId       : 5d8e7bdb-2471-415d-9ea7-1f9d2084aa3c
UI               : System.Management.Automation.Internal.Host.InternalHostUserInterface
CurrentCulture   : de-DE
CurrentUICulture : de-DE
PrivateData      : NuGetConsole.Host.PowerShell.Implementation.NuGetPSHost+Commander
DebuggerEnabled  : True
IsRunspacePushed : False
Runspace         : System.Management.Automation.Runspaces.LocalRunspace

This is not my first nuget package in my visual studio solution around 10 nuget packages.
The same issue appears wenn I try to install the package with VS NuGet Paket Manager.

Any idea how solve this problem, thanks for your efforts

Body:
I try to install a nuget package in my software project in visual studio 2022 (Version 17.4.4) with PM-console with the command:

Install-Package Microsoft.Extensions.ObjectPool -ProjectName

I get the following error message:

Sorry the original error message is in german language
Install-Package : Ungültige Wiederherstellungseingabe. Die erforderliche Eigenschaft "ProjectName" fehlt.
Eingabedateien: Drive:<PathToProject><Another project in soulution>.csproj.
In Zeile:1 Zeichen:1

Install-Package Microsoft.Extensions.ObjectPool -ProjectName

  + CategoryInfo          : NotSpecified: (:) [Install-Package], Exception
  + FullyQualifiedErrorId : NuGetCmdletUnhandledException,NuGet.PackageManagement.PowerShellCmdlets.InstallPackageCommand

The Error message means:
Install-Package : Invalid restore input. The required property "ProjectName" is missing.
Input files: Drive:<PathToProject><Another project in solution>.csproj.
In Line:1 Character:1

Nuget version please see here:

Name             : Package Manager Host
Version          : 6.4.0.111
InstanceId       : 5d8e7bdb-2471-415d-9ea7-1f9d2084aa3c
UI               : System.Management.Automation.Internal.Host.InternalHostUserInterface
CurrentCulture   : de-DE
CurrentUICulture : de-DE
PrivateData      : NuGetConsole.Host.PowerShell.Implementation.NuGetPSHost+Commander
DebuggerEnabled  : True
IsRunspacePushed : False
Runspace         : System.Management.Automation.Runspaces.LocalRunspace

This is not my first nuget package in my visual studio solution around 10 nuget packages.
The same issue appears wenn I try to install the package with VS NuGet Paket Manager.

Any idea how solve this problem, thanks for your efforts


问:
Why cant I see all the text in my kivy app even after using scrollview method which doesnt show up?
I am trying to make an app with a dictionary without using a .kv file, the list of words is too long and I cant view it all, trying to use scroll view in order to fix it but it doesnt work, it is supposed to include more labels also...

I tried using scroll view and also I tried changing the text size, both didnt work. Also cant see the scroll menu...

My code:

```<code>from kivy.app import App
from kivy.uix.label import Label
from kivy.uix.boxlayout import BoxLayout
from kivy.uix.scrollview import ScrollView

class MyApp(App):
    def build(self):
        scroll_view_E = ScrollView(size_hint=(1, None), size=(400, 400))
        label_English = Label(text="Food:\nFood - Comida\nBread - Pan\nTea - Té\nCoffee - Café\nIce coffee - Café con hielo\nWater - Agua\nSparkling water - Agua mineral con gas\nSugar - Azúcar\nSalt - Sal\nOlive oil - Aceite de oliva\nPepper - Pimienta\nWine - Vino\nMilk - Leche\nCheese - Queso\nFish - Pescado\nMeat - Carne\nSpicy - Picante\nChicken - Pollo\nSeafood - Mariscos\nSandwich - Sandwich\nGluten - Gluten\n\nColours:\nGreen - Verde\nYellow - Amarillo\nRed - Rojo\nOrange - Naranja\nBlack - Negro\nWhite - Blanco\nPurple - Morado\nBlue - Azul\nPink - Rosado\n\nPhrases:\nExcuse me - Disculpe/Perdón\nThank you - Gracias\nGood - Bien\nBad - Mal\nNice to meet you - Encantado/a de conocerte\nWhat time is it? - ¿Qué hora es?\nWhere is the bathroom? - ¿Dónde está el baño?\nYou are welcome - De nada\nGood morning - Buenos días\nGood afternoon - Buenas tardes\nGood evening - Buenas noches\nHow are you? - ¿Cómo estás?\nNice to meet you - Encantado/a de conocerte\nMy name is - Mi nombre es\nWhat is your name? - ¿Cuál es tu nombre?\nMy phone number is - Mi número de teléfono es\nWhat is your phone number? - ¿Cuál es tu número de teléfono?\nI need help - Necesito ayuda\nDo you need help? - ¿Necesitas ayuda?\nCan you help me please? - ¿Podrías ayudarme por favor?\nHow do I get to it? - ¿Cómo llegó hasta allí?\nWhere is it? - ¿Dónde está?\nHow do you spell your name? - ¿Cómo se escribe tu nombre?\nI want to drink - Quiero beber\nI want to - Quiero\nI want to eat - Quiero comer\nI am here for - Estoy aquí para\nMore - Más\nLess - Menos\nEnter - Entrar\nExit - Salir\nEntrance - Entrada\nUp - Arriba\nDown - Abajo\nRight - Derecha\nLeft - Izquierda\nBehind - Detrás\nHelp - Ayuda\nI need help - Necesito ayuda\nOr - O\nOther - Otro\nMissing - Faltante\nWith - Con\nWithout - Sin\nI am lost - Estoy perdido\nGive me the bill please - Por favor, déme la cuenta\nGood bye - Adiós\n\nDays:\nMonday - Lunes\nTuesday - Martes\nWednesday - Miércoles\nThursday - Jueves\nFriday - Viernes\nSaturday - Sábado\nSunday - Domingo\n\nTimes:\nWeek - Semana\nMonth - Mes\nYear - Año\nTomorrow - Mañana\nToday - Hoy\nYesterday - Ayer\nMorning - Mañana\nEvening - Noche\nNoon - Mediodía\nAfter noon - Tarde\n\nLanguages:\nEnglish - Inglés\nFrench - Francés\nHebrew - hebreo\nDutch - holandés\nGerman - alemán\nItalian - italiano\nRussian - Ruso\nJapanese - japonés\nMandarin Chinese - mandarín chino\nPortuguese - portugués\nDo you speak___? - Hablas___?\n\nMonths:\nJanuary - enero\nFebruary - febrero\nMarch - marzo\nApril - abril\nMay - mayo\nJune - junio\nJuly - julio\nAugust - agosto\nSeptember - septiembre\nOctober - octubre\nNovember - noviembre\nDecember - Diciembre\n\nDirections:\nNorth - norte\nSouth - sur\nEast - este\nWest - oeste\n")
        scroll_view_P = ScrollView(size_hint=(1, None), size=(400, 400))
        label_Portuguese = Label(text="Comida:\nComida - Comida\nPão - Pan\nChá - Té\nCafé - Café\nCafé gelado - Café con hielo\nÁgua - agua\nÁgua com gás - agua mineral con gas\nAçúcar - azúcar\nSal - Sal\nAzeite - Aceite de oliva\nPimenta - Pimenta\nVinho - Vino\nLeite - Leche\nQueijo - Queso\nPeixe - Pescado\nCarne - Carne\nPicante - Picante\nFrango - Pollo\nFrutos do Mar - Mariscos\nSanduíche - Sandwich\nGlúten - Gluten\n\nCores:\nVerde - Verde\nAmarelo - Amarillo\nVermelho - Rojo\nLaranja - Naranja\nPreto - Negro\nBranco - Blanco\nRoxo - Morado\nAzul - Azul\nRosa - Rosa\n\nFrases:\nCom licença - Disculpe/Perdón\nObrigado - gracias\nBom - bien\nRuim - mal\nPrazer em conhecê-lo - Encantado/a de conocerte\n¿Qué horas são? - ¿Qué hora es?\nOnde fica o banheiro? - ¿Dónde está el baño?\nDe nada - De nada\nBom dia - Buenos dias\nBoa tarde - Buenas tardes\nBoa noite - Buenas noches\nComo você está? - Cómo estás?\nPrazer em conhecê-lo - Encantado/a de conocerte\nMeu nome é - Mi nombre es\nQual o seu nome? - Cuál es tu nombre?\nMeu número de telefone é - Mi número de teléfono es\nQual É o Seu Número De Telefone? - ¿Cuál es tu número de teléfono?\nPreciso de ajuda - Necesito ayuda\nVocê precisa de ajuda? - ¿Necesitas ayuda?\nVocê pode me ajudar por favor? - ¿Podrías ayudarme por favor?\nComo faço para chegar a ele? - ¿Cómo llegó hasta allí?\nCadê? - ¿Dónde está?\nComo soletrar o teu nome? - ¿Cómo se escribe tu nombre?\nEu quero beber - Quiero beber\nEu quero - Quiero\nEu quero comer - Quiero comer\nEstou aqui para - Estoy aquí para\nMais - Más\nMenos - menos\nEntrar - Entrar\nSaída - Salir\nEntrada - Entrada\nCima - Arriba\nDown - Abajo\nDireita - Derecha\nEsquerda - Izquierda\nAtrás - Detrás\nAjuda - Ajuda\najuda - ayuda\nOu - O\nOutro - Otro\nFaltando - Faltante\nCom - Con\nSem - sin\nEstou perdido - Estoy perdido\nDê-me a conta, por favor - Por favor, déme la cuenta\nAdeus - Adiós")
        scroll_view_E.add_widget(label_English)
        scroll_view_P.add_widget(label_Portuguese)
        return scroll_view_E
        return scroll_view_P

if __name__ == "__main__":
    MyApp().run()
</code>```

Body:
I am trying to make an app with a dictionary without using a .kv file, the list of words is too long and I cant view it all, trying to use scroll view in order to fix it but it doesnt work, it is supposed to include more labels also...

I tried using scroll view and also I tried changing the text size, both didnt work. Also cant see the scroll menu...

My code:

from kivy.app import App
from kivy.uix.label import Label
from kivy.uix.boxlayout import BoxLayout
from kivy.uix.scrollview import ScrollView

class MyApp(App):
    def build(self):
        scroll_view_E = ScrollView(size_hint=(1, None), size=(400, 400))
        label_English = Label(text="Food:\nFood - Comida\nBread - Pan\nTea - Té\nCoffee - Café\nIce coffee - Café con hielo\nWater - Agua\nSparkling water - Agua mineral con gas\nSugar - Azúcar\nSalt - Sal\nOlive oil - Aceite de oliva\nPepper - Pimienta\nWine - Vino\nMilk - Leche\nCheese - Queso\nFish - Pescado\nMeat - Carne\nSpicy - Picante\nChicken - Pollo\nSeafood - Mariscos\nSandwich - Sandwich\nGluten - Gluten\n\nColours:\nGreen - Verde\nYellow - Amarillo\nRed - Rojo\nOrange - Naranja\nBlack - Negro\nWhite - Blanco\nPurple - Morado\nBlue - Azul\nPink - Rosado\n\nPhrases:\nExcuse me - Disculpe/Perdón\nThank you - Gracias\nGood - Bien\nBad - Mal\nNice to meet you - Encantado/a de conocerte\nWhat time is it? - ¿Qué hora es?\nWhere is the bathroom? - ¿Dónde está el baño?\nYou are welcome - De nada\nGood morning - Buenos días\nGood afternoon - Buenas tardes\nGood evening - Buenas noches\nHow are you? - ¿Cómo estás?\nNice to meet you - Encantado/a de conocerte\nMy name is - Mi nombre es\nWhat is your name? - ¿Cuál es tu nombre?\nMy phone number is - Mi número de teléfono es\nWhat is your phone number? - ¿Cuál es tu número de teléfono?\nI need help - Necesito ayuda\nDo you need help? - ¿Necesitas ayuda?\nCan you help me please? - ¿Podrías ayudarme por favor?\nHow do I get to it? - ¿Cómo llegó hasta allí?\nWhere is it? - ¿Dónde está?\nHow do you spell your name? - ¿Cómo se escribe tu nombre?\nI want to drink - Quiero beber\nI want to - Quiero\nI want to eat - Quiero comer\nI am here for - Estoy aquí para\nMore - Más\nLess - Menos\nEnter - Entrar\nExit - Salir\nEntrance - Entrada\nUp - Arriba\nDown - Abajo\nRight - Derecha\nLeft - Izquierda\nBehind - Detrás\nHelp - Ayuda\nI need help - Necesito ayuda\nOr - O\nOther - Otro\nMissing - Faltante\nWith - Con\nWithout - Sin\nI am lost - Estoy perdido\nGive me the bill please - Por favor, déme la cuenta\nGood bye - Adiós\n\nDays:\nMonday - Lunes\nTuesday - Martes\nWednesday - Miércoles\nThursday - Jueves\nFriday - Viernes\nSaturday - Sábado\nSunday - Domingo\n\nTimes:\nWeek - Semana\nMonth - Mes\nYear - Año\nTomorrow - Mañana\nToday - Hoy\nYesterday - Ayer\nMorning - Mañana\nEvening - Noche\nNoon - Mediodía\nAfter noon - Tarde\n\nLanguages:\nEnglish - Inglés\nFrench - Francés\nHebrew - hebreo\nDutch - holandés\nGerman - alemán\nItalian - italiano\nRussian - Ruso\nJapanese - japonés\nMandarin Chinese - mandarín chino\nPortuguese - portugués\nDo you speak___? - Hablas___?\n\nMonths:\nJanuary - enero\nFebruary - febrero\nMarch - marzo\nApril - abril\nMay - mayo\nJune - junio\nJuly - julio\nAugust - agosto\nSeptember - septiembre\nOctober - octubre\nNovember - noviembre\nDecember - Diciembre\n\nDirections:\nNorth - norte\nSouth - sur\nEast - este\nWest - oeste\n")
        scroll_view_P = ScrollView(size_hint=(1, None), size=(400, 400))
        label_Portuguese = Label(text="Comida:\nComida - Comida\nPão - Pan\nChá - Té\nCafé - Café\nCafé gelado - Café con hielo\nÁgua - agua\nÁgua com gás - agua mineral con gas\nAçúcar - azúcar\nSal - Sal\nAzeite - Aceite de oliva\nPimenta - Pimenta\nVinho - Vino\nLeite - Leche\nQueijo - Queso\nPeixe - Pescado\nCarne - Carne\nPicante - Picante\nFrango - Pollo\nFrutos do Mar - Mariscos\nSanduíche - Sandwich\nGlúten - Gluten\n\nCores:\nVerde - Verde\nAmarelo - Amarillo\nVermelho - Rojo\nLaranja - Naranja\nPreto - Negro\nBranco - Blanco\nRoxo - Morado\nAzul - Azul\nRosa - Rosa\n\nFrases:\nCom licença - Disculpe/Perdón\nObrigado - gracias\nBom - bien\nRuim - mal\nPrazer em conhecê-lo - Encantado/a de conocerte\n¿Qué horas são? - ¿Qué hora es?\nOnde fica o banheiro? - ¿Dónde está el baño?\nDe nada - De nada\nBom dia - Buenos dias\nBoa tarde - Buenas tardes\nBoa noite - Buenas noches\nComo você está? - Cómo estás?\nPrazer em conhecê-lo - Encantado/a de conocerte\nMeu nome é - Mi nombre es\nQual o seu nome? - Cuál es tu nombre?\nMeu número de telefone é - Mi número de teléfono es\nQual É o Seu Número De Telefone? - ¿Cuál es tu número de teléfono?\nPreciso de ajuda - Necesito ayuda\nVocê precisa de ajuda? - ¿Necesitas ayuda?\nVocê pode me ajudar por favor? - ¿Podrías ayudarme por favor?\nComo faço para chegar a ele? - ¿Cómo llegó hasta allí?\nCadê? - ¿Dónde está?\nComo soletrar o teu nome? - ¿Cómo se escribe tu nombre?\nEu quero beber - Quiero beber\nEu quero - Quiero\nEu quero comer - Quiero comer\nEstou aqui para - Estoy aquí para\nMais - Más\nMenos - menos\nEntrar - Entrar\nSaída - Salir\nEntrada - Entrada\nCima - Arriba\nDown - Abajo\nDireita - Derecha\nEsquerda - Izquierda\nAtrás - Detrás\nAjuda - Ajuda\najuda - ayuda\nOu - O\nOutro - Otro\nFaltando - Faltante\nCom - Con\nSem - sin\nEstou perdido - Estoy perdido\nDê-me a conta, por favor - Por favor, déme la cuenta\nAdeus - Adiós")
        scroll_view_E.add_widget(label_English)
        scroll_view_P.add_widget(label_Portuguese)
        return scroll_view_E
        return scroll_view_P

if __name__ == "__main__":
    MyApp().run()


问:
VSCode: How to run npm scripts from the command pallete?
I just recently discovered the npm scripts section in VSCode. Now I'm wondering, is there also a way to run npm scripts from the command pallete?

I wasn't able to find any documentation on this, besides defining and launching build and test tasks. In a few results from Google, people were able to run npm scripts by typing > npm: taskname, but for some reason this won't work for me. I suspect this changed when VSCode natively implemented the script runner.


问:
CRUD, When I created a post, result is null but when use postman. Its worked
When I created a post, result is null but when use postman. Its worked

STACK is VueJs, Nodejs, Express, MySQL

controllers file >>

```<code>export const createUser = (req, res) => {
    const data = req.body;
    insertUser(data, (err, results) => {
        if (err) {
            res.send(err);
        } else {
            res.json(results);
        }
    });
};
</code>```

Model file >>

```<code>export const insertUser = (data, result) => {
    // const id = req.params.id;
    const { name, photo, email, phone, company, title } = data;
    db.query(
        "INSERT INTO profile (name, photo, email, phone, company, title) VALUES(?, ?, ?, ?, ?, ?)",
        [name, photo, email, phone, company, title],
        (err, results) => {
            if (err) {
                console.log(err);
                result(err, null);
            } else {
                result(null, results);
            }
        }
    );
};
</code>```

routes file >>

```<code>router.post("/users", createUser);
</code>```

Body:
When I created a post, result is null but when use postman. Its worked

STACK is VueJs, Nodejs, Express, MySQL

controllers file >>

export const createUser = (req, res) => {
    const data = req.body;
    insertUser(data, (err, results) => {
        if (err) {
            res.send(err);
        } else {
            res.json(results);
        }
    });
};

Model file >>

export const insertUser = (data, result) => {
    // const id = req.params.id;
    const { name, photo, email, phone, company, title } = data;
    db.query(
        "INSERT INTO profile (name, photo, email, phone, company, title) VALUES(?, ?, ?, ?, ?, ?)",
        [name, photo, email, phone, company, title],
        (err, results) => {
            if (err) {
                console.log(err);
                result(err, null);
            } else {
                result(null, results);
            }
        }
    );
};

routes file >>

router.post("/users", createUser);


问:
Activate Maven Child profile with a parameter using BootDashboard
I have a spring.boot 2.6.13 multimodule project using apache maven 3.8.5 and, for easily start my project I use BootDashboard on his embedded tomcat.

Now I have a parent pom like this:

```<code><profiles>
    <profile>
        <id>dev</id>
        <activation>
            <activeByDefault>true</activeByDefault>
        </activation>
        <properties>
            ....
        </properties>
        <modules>
            ....
        </modules>
    </profile>
    <profile>
        <id>prod</id>
        <activation>
            <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
            ....
        </properties>
        <modules>
            ....
        </modules>
    </profile>
</profiles>
</code>```

Now, if manually change the <activationByDefault> value from true to false the bootdashboard correctly identify the respective properties and so on.

Now suppose I have another child pom, for example the web.pom like this:

```<code><profiles>
    <profile>
        <id>prod</id>
        <activation>
            [I want to activate this conditionally based by some parent value]
        </activation>
        <dependencies>
            <dependency>
                <groupId>some.other.dependencies</groupId>
                <artifactId>some.other.dependencies</artifactId>
                <version>${project.parent.version}</version>
            </dependency>
        </dependencies>
    </profile>
</profiles>
</code>```

I know that I could place the child dependency on parent pom but my situation is a little bit different and I would like to know if conceptually I can achieve this trick.

For example, and responding to @khmarbaise, Imagine to have a unique rest backend and several customer profile. Now for each customer I have developed external library (packaging as jar) where I implemented different authentication method (jwt, saml and so on). This could be a reason.

But the main answer is, could I activate a child pom profile - based on some properties setted on the parent pom active (ativatedByDefault or with other mode) profile?

Body:
I have a spring.boot 2.6.13 multimodule project using apache maven 3.8.5 and, for easily start my project I use BootDashboard on his embedded tomcat.

Now I have a parent pom like this:

<profiles>
    <profile>
        <id>dev</id>
        <activation>
            <activeByDefault>true</activeByDefault>
        </activation>
        <properties>
            ....
        </properties>
        <modules>
            ....
        </modules>
    </profile>
    <profile>
        <id>prod</id>
        <activation>
            <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
            ....
        </properties>
        <modules>
            ....
        </modules>
    </profile>
</profiles>

Now, if manually change the <activationByDefault> value from true to false the bootdashboard correctly identify the respective properties and so on.

Now suppose I have another child pom, for example the web.pom like this:

<profiles>
    <profile>
        <id>prod</id>
        <activation>
            [I want to activate this conditionally based by some parent value]
        </activation>
        <dependencies>
            <dependency>
                <groupId>some.other.dependencies</groupId>
                <artifactId>some.other.dependencies</artifactId>
                <version>${project.parent.version}</version>
            </dependency>
        </dependencies>
    </profile>
</profiles>

I know that I could place the child dependency on parent pom but my situation is a little bit different and I would like to know if conceptually I can achieve this trick.

For example, and responding to @khmarbaise, Imagine to have a unique rest backend and several customer profile. Now for each customer I have developed external library (packaging as jar) where I implemented different authentication method (jwt, saml and so on). This could be a reason.

But the main answer is, could I activate a child pom profile - based on some properties setted on the parent pom active (ativatedByDefault or with other mode) profile?


问:
How I can pick the GitLab Access Token using NextAuth?
I want make request to GitLab API to get the client repositories, but I can't get the Access Token after I am logged. I just received this data:


问:
Migration from MySQL to Oracle 19c on RHEL 8.7 Server
I have a PHP-MySQL (Symfony) application which is running on an RHEL 8.7 instance, The customer wants to migrate the database from MySQL to Oracle. I have tried to migrate it using SQL Developer installed on the local Windows machine. It is taking too much time and often failing due to network issues. I installed SQL Developer on RHEL server but unable to do the migration as there is no GUI. What is the ideal solution for this? Can I use SQLCL to migrate MySQL to Oracle? If yes, what is the command?</p>


问:
Count the frequency of event from many columns group by id and hour category in r
I have a database with observational data from different animals, times, and dates:

id
date.cat
hour.cat
jump
run
lie_down
get_up

76
1
15
1
0
0
0

76
1
15
0
1
0
0

76
1
15
1
0
0
0

76
1
15
0
0
1
0

77
1
16
0
0
0
1

77
1
16
1
0
0
0

77
1
16
0
0
1
0

77
1
16
0
0
0
0

I need to sum the rows by behavior, grouped by id, time and date, as:

id
date.cat
hour.cat
jump
run
lie_down
get_up

76
1
15
2
1
1
0

77
1
16
1
0
1
1

I couldn't find a resolution


问:
In Kotlin, how do I discover the available methods on an object?
I am used to PowerShell where I can use a Get-Method cmdlet to get all the available methods on an object, working in Intellij I can view a lot of methods from the intellisense but not all of them unless I type something specific so I would need to know what to type before I need it. Is there a way to discover methods on an object in the REPL terminal or a doc somewhere I can review to learn this?

Thanks

I tried looking through intellisense but couldn't find what I was looking for


问:
Postgres add column generated always stored ... but without locking the table
I would like to add a generated column to a very large table without locking it:

```<code>alter table customer alter column foo text generated always as ((infos_json->'customerinfos'->>'redirect')) stored;
</code>```

Is there a way to do this without locking? Maybe concurrently?

Body:
I would like to add a generated column to a very large table without locking it:

alter table customer alter column foo text generated always as ((infos_json->'customerinfos'->>'redirect')) stored;

Is there a way to do this without locking? Maybe concurrently?


问:
Save Image to android local folder fails in some device
I'm saving images from bitmap to android local folder using below code,

```<code>        val relativeLocation = Environment.DIRECTORY_PICTURES + "/" + "MyAppName"
        val contentValues = ContentValues().apply {
            put(MediaStore.MediaColumns.DISPLAY_NAME, "Filename")
            put(MediaStore.MediaColumns.MIME_TYPE, "image/jpeg")
            if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.Q) {
                put(MediaStore.MediaColumns.RELATIVE_PATH, relativeLocation)
            }
        }

val resolver = reqireActivity().contentResolver
val uri = resolver.insert(MediaStore.Images.Media.EXTERNAL_CONTENT_URI, contentValues)

uri?.let { uri ->
                    val stream = resolver.openOutputStream(uri)

                    stream?.let { stream ->
                        if (!bitmap.compress(Bitmap.CompressFormat.JPEG, 50, stream)) {
                            throw IOException("Failed to save bitmap.")
                        }
                    } ?: throw IOException("Failed to get output stream.")

                } ?: throw IOException("Failed to create new MediaStore record")
</code>```

It works well in all devices, but now in crashlytics, i'm getting following error message from MI-Note4(android-7.0) and Mi Redmi 5Plus(android-8.1.0) devices,

Fatal Exception: java.lang.IllegalArgumentException
Unknown URL content://media/external/images/media
at android.content.ContentResolver.insert

Not sure really how to solve this issue

Body:
I'm saving images from bitmap to android local folder using below code,

        val relativeLocation = Environment.DIRECTORY_PICTURES + "/" + "MyAppName"
        val contentValues = ContentValues().apply {
            put(MediaStore.MediaColumns.DISPLAY_NAME, "Filename")
            put(MediaStore.MediaColumns.MIME_TYPE, "image/jpeg")
            if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.Q) {
                put(MediaStore.MediaColumns.RELATIVE_PATH, relativeLocation)
            }
        }

val resolver = reqireActivity().contentResolver
val uri = resolver.insert(MediaStore.Images.Media.EXTERNAL_CONTENT_URI, contentValues)

uri?.let { uri ->
                    val stream = resolver.openOutputStream(uri)

                    stream?.let { stream ->
                        if (!bitmap.compress(Bitmap.CompressFormat.JPEG, 50, stream)) {
                            throw IOException("Failed to save bitmap.")
                        }
                    } ?: throw IOException("Failed to get output stream.")

                } ?: throw IOException("Failed to create new MediaStore record")

It works well in all devices, but now in crashlytics, i'm getting following error message from MI-Note4(android-7.0) and Mi Redmi 5Plus(android-8.1.0) devices,

Fatal Exception: java.lang.IllegalArgumentException
Unknown URL content://media/external/images/media
at android.content.ContentResolver.insert

Not sure really how to solve this issue


问:
How to enforce microseconds with datetime()?
I'd like date2 to output 2023-01-11 14:00:00.000000 to have a predictable format.

```<code>from datetime import datetime

date1 = datetime(2023, 1, 11, 14, 0, 0, 123456)
date2 = datetime(2023, 1, 11, 14, 0, 0)
print(date1)  # 2023-01-11 14:00:00.123456
print(date2)  # 2023-01-11 14:00:00
</code>```

Any ideas?

Body:
I'd like date2 to output 2023-01-11 14:00:00.000000 to have a predictable format.

from datetime import datetime

date1 = datetime(2023, 1, 11, 14, 0, 0, 123456)
date2 = datetime(2023, 1, 11, 14, 0, 0)
print(date1)  # 2023-01-11 14:00:00.123456
print(date2)  # 2023-01-11 14:00:00

Any ideas?


问:
How to further specify an exception when there are two different errors under the same exception class
I have two different errors under the same exception class that I want to handle differently.

1.

Exception: ProgrammingError: (pyodbc.ProgrammingError) ('42S22', "[42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'newCol'. (207) (SQLExecDirectW); [42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. (8180)")

Exception: ProgrammingError: (pyodbc.ProgrammingError) ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ','. (102) (SQLExecDirectW)")

How do I further specify these errors in my try-except block so I can handle them differently?

try:
    #code
except ProgrammingError:
    #code
```


问:
Why does SwiftUI Map modifies state if it has .ignoresSafeArea() modifier?
```<code>import SwiftUI
import MapKit
import LocalAuthentication

struct ContentView: View {
    @State private var mapRegion = MKCoordinateRegion(center: CLLocationCoordinate2D(latitude: 51.4, longitude: -0.1), span: MKCoordinateSpan(latitudeDelta: 1, longitudeDelta: 1))

    var body: some View {
        Map(coordinateRegion: $mapRegion)
            .ignoresSafeArea()
    }
}
</code>```

When I run this code Xcode gives this Issue:

Modifying state during view update, this will cause undefined behavior.

When I remove .ignoresSafeArea() modifier from Map() the problem disappears. Is this a bug?

Body:
import SwiftUI
import MapKit
import LocalAuthentication

struct ContentView: View {
    @State private var mapRegion = MKCoordinateRegion(center: CLLocationCoordinate2D(latitude: 51.4, longitude: -0.1), span: MKCoordinateSpan(latitudeDelta: 1, longitudeDelta: 1))

    var body: some View {
        Map(coordinateRegion: $mapRegion)
            .ignoresSafeArea()
    }
}

When I run this code Xcode gives this Issue:

Modifying state during view update, this will cause undefined behavior.

When I remove .ignoresSafeArea() modifier from Map() the problem disappears. Is this a bug?


问:
DatePicker FlatPickr is not displaying in KrayinCRM which is based on Laravel
I am trying to add some custom fields in KrayinCRM.
I can do that by adding attributes, but I need to display and change some field of other tables and pass it to another table.
So basically, I want to display three date pickers in KrayinCRM.
I have gone through the Document of krayinCRM but could not do that.
I have tried following the code, but it doesn't work.

```<code>import Flatpickr from "flatpickr";

export default {

    mounted() {
        flatpickr('#datepicker')

    }
};
</code>```

This is KrayinCRM which I am using.
https://github.com/krayin/laravel-crm

I have tried Jquery also like this:

```<code>window.onload = function() {
    if (window.jQuery) {
        // jQuery is loaded

    } else {
        // jQuery is not loaded

    }
}
$(document).ready(function() {
    $("#test_date").flatpickr();
});
</code>```

But that also doesn't work.

Trying to display three date pickers that the user can change, and the form will submit; in the post side backend, I will get that date and insert it into another table after some calculation.

Body:
I am trying to add some custom fields in KrayinCRM.
I can do that by adding attributes, but I need to display and change some field of other tables and pass it to another table.
So basically, I want to display three date pickers in KrayinCRM.
I have gone through the Document of krayinCRM but could not do that.
I have tried following the code, but it doesn't work.

import Flatpickr from "flatpickr";

export default {

    mounted() {
        flatpickr('#datepicker')

    }
};

This is KrayinCRM which I am using.
https://github.com/krayin/laravel-crm

I have tried Jquery also like this:

window.onload = function() {
    if (window.jQuery) {
        // jQuery is loaded

    } else {
        // jQuery is not loaded

    }
}
$(document).ready(function() {
    $("#test_date").flatpickr();
});

But that also doesn't work.

Trying to display three date pickers that the user can change, and the form will submit; in the post side backend, I will get that date and insert it into another table after some calculation.


问:
How to setup progam.cs and services in a xUnitProject
This should be a simple enough question but I'm not able to find a working answer to it.
I use automapper in my application and inject it from program.cs

```<code>builder.Services.AddAutoMapper(typeof(AutoMappingProfiles).Assembly);
</code>```

I want to be able to use it with Dependency injection in my xUnit tests as well. There are some examples on various methods to achieve this but I can't get any of them to work. I added the Xunit.DependencyInjection package to my test project but it looks like the example on that packes is for .NET <= 6. So... I seem to be stuck.

I Tried to set up a program.cs file in the test project but can't figure out how to get it to execute. No breakpoints are hit in the program.cs file when I debug, so Obviously I'm not doing this the right way.

An important note is that I use .NET 7.0 and therefor my impression is that I should not have a startup.cs file.

Body:
This should be a simple enough question but I'm not able to find a working answer to it.
I use automapper in my application and inject it from program.cs

builder.Services.AddAutoMapper(typeof(AutoMappingProfiles).Assembly);

I want to be able to use it with Dependency injection in my xUnit tests as well. There are some examples on various methods to achieve this but I can't get any of them to work. I added the Xunit.DependencyInjection package to my test project but it looks like the example on that packes is for .NET <= 6. So... I seem to be stuck.

I Tried to set up a program.cs file in the test project but can't figure out how to get it to execute. No breakpoints are hit in the program.cs file when I debug, so Obviously I'm not doing this the right way.

An important note is that I use .NET 7.0 and therefor my impression is that I should not have a startup.cs file.


问:
rcu_sched kthread timer wakeup didn't happen for x jiffies Allwinner sun8i
I'm working on my own distribution for OrangePI R1 with Allwinner sun8i SoC. I had stripped kernel_defconfig to fit my custom linux into 16M SPI NOR. After leaving the board up for few days I see such messages on my serial console.

```<code>admin@orange-pi-r1:~# [65779.614485] rcu: INFO: rcu_sched detected stalls on CPUs/tasks:
[65779.620458] rcu:     3-...!: (4 GPs behind) idle=200/0/0x0 softirq=17870/17870 fqs=0  (false positive?)
[65779.629630]  (detected by 2, t=2103 jiffies, g=68925, q=83)
[65779.635224] Sending NMI from CPU 2 to CPUs 3:
[65779.639605] NMI backtrace for cpu 3
[65779.639619] CPU: 3 PID: 0 Comm: swapper/3 Tainted: G           O      5.15.35 #1
[65779.639636] Hardware name: Allwinner sun8i Family
[65779.639644] PC is at 0xc0106330
[65779.639651] LR is at 0xc0106340
[65779.639657] pc : [<c0106330>]    lr : [<c0106340>]    psr: 60000013
[65779.639669] sp : c0cadfa8  ip : 00000000  fp : c0805f90
[65779.639679] r10: c0cadfb8  r9 : 410fc075  r8 : c0805f4c
[65779.639689] r7 : c0cac000  r6 : c0cac000  r5 : 00000000  r4 : 00000000
[65779.639701] r3 : c0113ca0  r2 : 12e10204  r1 : 00000000  r0 : 12e10204
[65779.639714] Flags: nZCv  IRQs on  FIQs on  Mode SVC_32  ISA ARM  Segment none
[65779.639729] Control: 10c5387d  Table: 42a7c06a  DAC: 00000051
[65779.639738] CPU: 3 PID: 0 Comm: swapper/3 Tainted: G           O      5.15.35 #1
[65779.639754] Hardware name: Allwinner sun8i Family
[65779.639767] Function entered at [<c010c0b8>] from [<c0108bf4>]
[65779.639779] Function entered at [<c0108bf4>] from [<c0540794>]
[65779.639791] Function entered at [<c0540794>] from [<c037e2e0>]
[65779.639803] Function entered at [<c037e2e0>] from [<c010ad00>]
[65779.639814] Function entered at [<c010ad00>] from [<c010ad50>]
[65779.639825] Function entered at [<c010ad50>] from [<c016d288>]
[65779.639837] Function entered at [<c016d288>] from [<c0167b94>]
[65779.639848] Function entered at [<c0167b94>] from [<c0168218>]
[65779.639860] Function entered at [<c0168218>] from [<c038dff0>]
[65779.639871] Function entered at [<c038dff0>] from [<c0100b7c>]
[65779.639881] Exception stack(0xc0cadf58 to 0xc0cadfa0)
[65779.639896] df40:                                                       12e10204 00000000
[65779.639915] df60: 12e10204 c0113ca0 00000000 00000000 c0cac000 c0cac000 c0805f4c 410fc075
[65779.639934] df80: c0cadfb8 c0805f90 00000000 c0cadfa8 c0106340 c0106330 60000013 ffffffff
[65779.639946] Function entered at [<c0100b7c>] from [<c0106330>]
[65779.639957] Function entered at [<c0106330>] from [<c0546b94>]
[65779.639969] Function entered at [<c0546b94>] from [<c0148244>]
[65779.639980] Function entered at [<c0148244>] from [<c0148680>]
[65779.639991] Function entered at [<c0148680>] from [<401014d0>]
[65779.640602] rcu: rcu_sched kthread timer wakeup didn't happen for 2103 jiffies! g68925 f0x0 RCU_GP_WAIT_FQS(5) ->state=0x402
[65779.845052] rcu:     Possible timer handling issue on cpu=1 timer-softirq=33908
[65779.852117] rcu: rcu_sched kthread starved for 2125 jiffies! g68925 f0x0 RCU_GP_WAIT_FQS(5) ->state=0x402 ->cpu=1
[65779.862406] rcu:     Unless rcu_sched kthread gets sufficient CPU time, OOM is now expected behavior.
[65779.871383] rcu: RCU grace-period kthread stack dump:
[65779.876447] task:rcu_sched       state:I stack:    0 pid:   12 ppid:     2 flags:0x00000000
[65779.884836] Function entered at [<c0543560>] from [<c0543780>]
[65779.890688] Function entered at [<c0543780>] from [<c05462f4>]
[65779.896539] Function entered at [<c05462f4>] from [<c0176720>]
[65779.902391] Function entered at [<c0176720>] from [<c01791e4>]
[65779.908241] Function entered at [<c01791e4>] from [<c013cc18>]
[65779.914093] Function entered at [<c013cc18>] from [<c0100130>]
[65779.919942] Exception stack(0xc0c71fb0 to 0xc0c71ff8)
[65779.925008] 1fa0:                                     00000000 00000000 00000000 00000000
[65779.933212] 1fc0: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
[65779.941415] 1fe0: 00000000 00000000 00000000 00000000 00000013 00000000
</code>```

What might be causing such output? How can I debug this?

Body:
I'm working on my own distribution for OrangePI R1 with Allwinner sun8i SoC. I had stripped kernel_defconfig to fit my custom linux into 16M SPI NOR. After leaving the board up for few days I see such messages on my serial console.

admin@orange-pi-r1:~# [65779.614485] rcu: INFO: rcu_sched detected stalls on CPUs/tasks:
[65779.620458] rcu:     3-...!: (4 GPs behind) idle=200/0/0x0 softirq=17870/17870 fqs=0  (false positive?)
[65779.629630]  (detected by 2, t=2103 jiffies, g=68925, q=83)
[65779.635224] Sending NMI from CPU 2 to CPUs 3:
[65779.639605] NMI backtrace for cpu 3
[65779.639619] CPU: 3 PID: 0 Comm: swapper/3 Tainted: G           O      5.15.35 #1
[65779.639636] Hardware name: Allwinner sun8i Family
[65779.639644] PC is at 0xc0106330
[65779.639651] LR is at 0xc0106340
[65779.639657] pc : [<c0106330>]    lr : [<c0106340>]    psr: 60000013
[65779.639669] sp : c0cadfa8  ip : 00000000  fp : c0805f90
[65779.639679] r10: c0cadfb8  r9 : 410fc075  r8 : c0805f4c
[65779.639689] r7 : c0cac000  r6 : c0cac000  r5 : 00000000  r4 : 00000000
[65779.639701] r3 : c0113ca0  r2 : 12e10204  r1 : 00000000  r0 : 12e10204
[65779.639714] Flags: nZCv  IRQs on  FIQs on  Mode SVC_32  ISA ARM  Segment none
[65779.639729] Control: 10c5387d  Table: 42a7c06a  DAC: 00000051
[65779.639738] CPU: 3 PID: 0 Comm: swapper/3 Tainted: G           O      5.15.35 #1
[65779.639754] Hardware name: Allwinner sun8i Family
[65779.639767] Function entered at [<c010c0b8>] from [<c0108bf4>]
[65779.639779] Function entered at [<c0108bf4>] from [<c0540794>]
[65779.639791] Function entered at [<c0540794>] from [<c037e2e0>]
[65779.639803] Function entered at [<c037e2e0>] from [<c010ad00>]
[65779.639814] Function entered at [<c010ad00>] from [<c010ad50>]
[65779.639825] Function entered at [<c010ad50>] from [<c016d288>]
[65779.639837] Function entered at [<c016d288>] from [<c0167b94>]
[65779.639848] Function entered at [<c0167b94>] from [<c0168218>]
[65779.639860] Function entered at [<c0168218>] from [<c038dff0>]
[65779.639871] Function entered at [<c038dff0>] from [<c0100b7c>]
[65779.639881] Exception stack(0xc0cadf58 to 0xc0cadfa0)
[65779.639896] df40:                                                       12e10204 00000000
[65779.639915] df60: 12e10204 c0113ca0 00000000 00000000 c0cac000 c0cac000 c0805f4c 410fc075
[65779.639934] df80: c0cadfb8 c0805f90 00000000 c0cadfa8 c0106340 c0106330 60000013 ffffffff
[65779.639946] Function entered at [<c0100b7c>] from [<c0106330>]
[65779.639957] Function entered at [<c0106330>] from [<c0546b94>]
[65779.639969] Function entered at [<c0546b94>] from [<c0148244>]
[65779.639980] Function entered at [<c0148244>] from [<c0148680>]
[65779.639991] Function entered at [<c0148680>] from [<401014d0>]
[65779.640602] rcu: rcu_sched kthread timer wakeup didn't happen for 2103 jiffies! g68925 f0x0 RCU_GP_WAIT_FQS(5) ->state=0x402
[65779.845052] rcu:     Possible timer handling issue on cpu=1 timer-softirq=33908
[65779.852117] rcu: rcu_sched kthread starved for 2125 jiffies! g68925 f0x0 RCU_GP_WAIT_FQS(5) ->state=0x402 ->cpu=1
[65779.862406] rcu:     Unless rcu_sched kthread gets sufficient CPU time, OOM is now expected behavior.
[65779.871383] rcu: RCU grace-period kthread stack dump:
[65779.876447] task:rcu_sched       state:I stack:    0 pid:   12 ppid:     2 flags:0x00000000
[65779.884836] Function entered at [<c0543560>] from [<c0543780>]
[65779.890688] Function entered at [<c0543780>] from [<c05462f4>]
[65779.896539] Function entered at [<c05462f4>] from [<c0176720>]
[65779.902391] Function entered at [<c0176720>] from [<c01791e4>]
[65779.908241] Function entered at [<c01791e4>] from [<c013cc18>]
[65779.914093] Function entered at [<c013cc18>] from [<c0100130>]
[65779.919942] Exception stack(0xc0c71fb0 to 0xc0c71ff8)
[65779.925008] 1fa0:                                     00000000 00000000 00000000 00000000
[65779.933212] 1fc0: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
[65779.941415] 1fe0: 00000000 00000000 00000000 00000000 00000013 00000000

What might be causing such output? How can I debug this?


问:
Excel VBA Error 1004 The name 'Source' wasn't recognized. Make sure it's spelled correctly (.Refresh BackgroundQuery:=False)
I have been having this issue for a while now, and keeps on popping up.
I have been struggling with the error <<The name 'Source' wasn't recognized.>> but I can't figure out its cause.
I am trying to create a macro code to standardize the import of a CSV file to excel and transform its data before loading it to the excel sheet.

Any suggestions would be extremely helpful. Thanks!

```<code>Sub Macro1()

    PathArxiu = Application.GetOpenFilename("CSV Files (*.csv), *.csv")
    Dim NomArxiu As String
    Set FSO = CreateObject("Scripting.FileSystemObject")
    NomArxiuAmbExtencio = FSO.GetFileName(PathArxiu)
    NomArxiu = Left(NomArxiuAmbExtencio, InStr(NomArxiuAmbExtencio, ".csv") - 1)
    NomArxiu2 = Replace(NomArxiu, ".", "_")
    NomArxiu3 = Replace(NomArxiu2, "-", "_")
    NomArxiu4 = Replace(NomArxiu3, " ", "_")

 ActiveWorkbook.Queries.Add Name:= _
        NomArxiu4, Formula:= _
        "let" & Chr(13) & "" & Chr(10) & "    Source = Csv.Document(File.Contents(" & PathArxiu & "),[Delimiter="","", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.N" & _
        "one])," & Chr(13) & "" & Chr(10) & "    #""Promoted Headers"" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])," & Chr(13) & "" & Chr(10) & "    #""Changed Type"" = Table.TransformColumnTypes(#""Promoted Headers"",{{"" "", type text}, {""Area"", type text}, {""Perim."", type text}, {""Major"", type text}, {""Minor"", type text}, {""Angle"", type text}, {""Circ."", type text}, {""Feret"", type text}, {""FeretX"", " & _
        "type text}, {""FeretY"", type text}, {""FeretAngle"", type text}, {""MinFeret"", type text}, {""AR"", type text}, {""Round"", type text}, {""Solidity"", type text}})" & Chr(13) & "" & Chr(10) & "in" & Chr(13) & "" & Chr(10) & "    #""Changed Type"""
    ActiveWorkbook.Worksheets.Add
    With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array( _
        "OLEDB;Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=" & NomArxiu4 & ";Extended P" _
        , "roperties="""""), Destination:=Range("$A$1")).QueryTable
        .CommandType = xlCmdSql
        .CommandText = Array( _
        "SELECT * FROM [" & NomArxiu4 & "]")
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .PreserveColumnInfo = True
        .ListObject.DisplayName = _
        NomArxiu4
        .Refresh BackgroundQuery:=False
    End With

    Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2
End Sub
</code>```

Body:
I have been having this issue for a while now, and keeps on popping up.
I have been struggling with the error <<The name 'Source' wasn't recognized.>> but I can't figure out its cause.
I am trying to create a macro code to standardize the import of a CSV file to excel and transform its data before loading it to the excel sheet.

Any suggestions would be extremely helpful. Thanks!

Sub Macro1()

    PathArxiu = Application.GetOpenFilename("CSV Files (*.csv), *.csv")
    Dim NomArxiu As String
    Set FSO = CreateObject("Scripting.FileSystemObject")
    NomArxiuAmbExtencio = FSO.GetFileName(PathArxiu)
    NomArxiu = Left(NomArxiuAmbExtencio, InStr(NomArxiuAmbExtencio, ".csv") - 1)
    NomArxiu2 = Replace(NomArxiu, ".", "_")
    NomArxiu3 = Replace(NomArxiu2, "-", "_")
    NomArxiu4 = Replace(NomArxiu3, " ", "_")

 ActiveWorkbook.Queries.Add Name:= _
        NomArxiu4, Formula:= _
        "let" & Chr(13) & "" & Chr(10) & "    Source = Csv.Document(File.Contents(" & PathArxiu & "),[Delimiter="","", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.N" & _
        "one])," & Chr(13) & "" & Chr(10) & "    #""Promoted Headers"" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])," & Chr(13) & "" & Chr(10) & "    #""Changed Type"" = Table.TransformColumnTypes(#""Promoted Headers"",{{"" "", type text}, {""Area"", type text}, {""Perim."", type text}, {""Major"", type text}, {""Minor"", type text}, {""Angle"", type text}, {""Circ."", type text}, {""Feret"", type text}, {""FeretX"", " & _
        "type text}, {""FeretY"", type text}, {""FeretAngle"", type text}, {""MinFeret"", type text}, {""AR"", type text}, {""Round"", type text}, {""Solidity"", type text}})" & Chr(13) & "" & Chr(10) & "in" & Chr(13) & "" & Chr(10) & "    #""Changed Type"""
    ActiveWorkbook.Worksheets.Add
    With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array( _
        "OLEDB;Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=" & NomArxiu4 & ";Extended P" _
        , "roperties="""""), Destination:=Range("$A$1")).QueryTable
        .CommandType = xlCmdSql
        .CommandText = Array( _
        "SELECT * FROM [" & NomArxiu4 & "]")
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .PreserveColumnInfo = True
        .ListObject.DisplayName = _
        NomArxiu4
        .Refresh BackgroundQuery:=False
    End With

    Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2
End Sub


问:
Rocky 8.7 proxy connection to websocket in Laravel 9
Upgrading php-7.3 from php 8.2 on rocky-8.7 but WebSocket connection is not working

Before Upgrade: when WebSocket connection working fine

```<code>Rocky: 8.7
PHP: 7.3.33
Laravel: 8.83
beyondcode/laravel-websockets: 1.13.1
pusher/pusher-php-server: 4.1.5
</code>```

After Upgrade:

```<code>Rocky: 8.7
PHP: 8.2.1
Laravel: 9.x
beyondcode/laravel-websockets: 1.13.1
pusher/pusher-php-server: 7.2.1 -> pre-supported version by Laravel 9 (this is installed by dependencies not added in composer.json )
</code>```

Package.json

```<code>pusher-js: 7.0.3
</code>```

Pusher Connection:

```<code>pusher = new Pusher(process.env.MIX_PUSHER_APP_KEY, {
    cluster: process.env.MIX_PUSHER_APP_CLUSTER,
    encrypted: false,
    wsHost: window.location.hostname,
    // comment for use port 443
    // wsPort: 6001,
    // wssPort:6001,
    enabledTransports: ["ws", "wss"],
    forceTLS: true,
});
</code>```

httpd: ssl.conf file

```<code><IfModule mod_proxy.c>
    ProxyRequests On
    SSLProxyEngine On
    # Ensure WebSocket protocol is forwarded correctly
    RewriteEngine on
    RewriteCond %{HTTP:UPGRADE} ^Websocket$ [NC]
    RewriteCond %{HTTP:CONNECTION} Upgrade$ [NC]
    RewriteRule /app/(.*) wss://%{HTTP:HOST}:6001/app/$1 [P]
</IfModule>
</code>```

WebSocket request:

```<code>URL: wss://test.com/app/ABCDEFGHIJL?protocol=7&client=js&version=7.0.3&flash=false
Message: WebSocket is closed before the connection is established.
</code>```

When WebSocket request is sent from the browser using port 443 requests is stuck.
Help me in what I'm missing with rocky os

Same settings in Cento OS working fine with php-8.2.1 & Laravel 9

Body:
Upgrading php-7.3 from php 8.2 on rocky-8.7 but WebSocket connection is not working

Before Upgrade: when WebSocket connection working fine

Rocky: 8.7
PHP: 7.3.33
Laravel: 8.83
beyondcode/laravel-websockets: 1.13.1
pusher/pusher-php-server: 4.1.5

After Upgrade:

Rocky: 8.7
PHP: 8.2.1
Laravel: 9.x
beyondcode/laravel-websockets: 1.13.1
pusher/pusher-php-server: 7.2.1 -> pre-supported version by Laravel 9 (this is installed by dependencies not added in composer.json )

Package.json

pusher-js: 7.0.3

Pusher Connection:

pusher = new Pusher(process.env.MIX_PUSHER_APP_KEY, {
    cluster: process.env.MIX_PUSHER_APP_CLUSTER,
    encrypted: false,
    wsHost: window.location.hostname,
    // comment for use port 443
    // wsPort: 6001,
    // wssPort:6001,
    enabledTransports: ["ws", "wss"],
    forceTLS: true,
});

httpd: ssl.conf file

<IfModule mod_proxy.c>
    ProxyRequests On
    SSLProxyEngine On
    # Ensure WebSocket protocol is forwarded correctly
    RewriteEngine on
    RewriteCond %{HTTP:UPGRADE} ^Websocket$ [NC]
    RewriteCond %{HTTP:CONNECTION} Upgrade$ [NC]
    RewriteRule /app/(.*) wss://%{HTTP:HOST}:6001/app/$1 [P]
</IfModule>

WebSocket request:

URL: wss://test.com/app/ABCDEFGHIJL?protocol=7&client=js&version=7.0.3&flash=false
Message: WebSocket is closed before the connection is established.

When WebSocket request is sent from the browser using port 443 requests is stuck.
Help me in what I'm missing with rocky os

Same settings in Cento OS working fine with php-8.2.1 & Laravel 9


问:
How to create multiple databases with Postgres in pgAdmin4
I am trying to run the following query in pgAdmin:

CREATE DATABASE abc;
CREATE DATABASE xyz;
```
<p>And I get the following error:</p>
<blockquote>
```ERROR:  current transaction is aborted, commands ignored until end of transaction block
SQL state: 25P02
```

I'm relatively new to postgres.

With  SQL Server it's possible to create multiple databases in a single query with the "GO" statement in between if necessary.

I've tried to google this error, and most answers are to simply run each line separately.

That would work, but I'm curious why this doesn't work.

It may also be a setting in pgAdmin.

The "autocommit" is currently on. I've tried it off, and same result.

I'm using postgres 14.5 (in aws)

Body:
I am trying to run the following query in pgAdmin:

CREATE DATABASE abc;
CREATE DATABASE xyz;

And I get the following error:

ERROR:  current transaction is aborted, commands ignored until end of transaction block
SQL state: 25P02

I'm relatively new to postgres.

With  SQL Server it's possible to create multiple databases in a single query with the "GO" statement in between if necessary.

I've tried to google this error, and most answers are to simply run each line separately.

That would work, but I'm curious why this doesn't work.

It may also be a setting in pgAdmin.

The "autocommit" is currently on. I've tried it off, and same result.

I'm using postgres 14.5 (in aws)