How did you find that the card does not support? Is there any methods to detect, thanks.

The performance gain is huge,because it dynamically binds listeners to every child elements through single parent.there are so many edge cases to consider before to use

1. Delegate too many events on parent can cause inefficency and complex logic
2. it only works with events like click and does not work with events like onblur,onfocus,mousenter etc.
3. you need to optimize the condition logic to avoid triggering unnecessary execution

Do as proposed above. You’re missing the "border" utility class — add "border" along with "border-solid" and "border-black", or the border won’t show up.

In case anyone needs, I found a similar post using Jolt transform here which helps: Split array inside JSON with JOLT

I wanted to add a related use-case here that I didn't see listed above, but this might help someone else. I often need to apply a custom function to many columns where that function itself takes multiple columns of a df, where the exact columns might be a pain to spell out or change subtly depending on the data-frame. So, same problem as OP, but where the function might be user-defined and require multiple columns.

I took the basic idea from Rajib's comment above. I wanted to post it here since, while it might be overkill for some cases, it is useful in others. In that case, you'll need apply, and you'll want to wrap the results in a pd.Series to return them as a normal-looking table.

# Toy data
import numpy as np
import pandas as pd
inc_data = {f"inc_{k}" : np.random.randint(1000, size=1000)
        for k in range(1,21)}
other_data = {f"o_{k}" : np.random.randint(1000, size=1000)
        for k in range(1,21)} # Adding unnecessary cols to simulate real-world dfs
group = {"group" :
     ["a"]*250 + ["b"]*250 + ["c"]*100 + ["d"]*400}
data = {**group, **inc_data, **other_data}
df = pd.DataFrame.from_dict(data)

# Identify needed columns
check = [c for c in df.columns if "inc" in c] # Cols we want to check
need = check + ["o_1"] # Cols we need
ref = "o_1" # Reference column
# Not an actual function I use, but just a sufficiently complicated one
def myfunc(data, x, y, n):
    return data.nlargest(n, x)[y].mean() 
df.groupby('group')[need].apply( # Use apply() to access entire groupby columns
    lambda g : pd.Series( # Use series to return as columns of a summary table
    {c : myfunc(g, c, ref, 5) # Dict comprehension to loop through many cols
    for c in check}
    ))

There might be much more performant ways to do this, but I had a hard time figuring this out. This method doesn't require more pre-defined functions than your custom function, and if the idea is just speeding up a lot of work, this is better than the manual methods of creating a Series detailed here, which has lots of good tips if the functions themselves are very different.

I'm having the same issue with the mermaid servers since a week ago (or so). I tried running the server locally on docker and it works as expected. For the issue with node names I'm assuming your Jupyter notebook is caching the image for a previously created graph and when you use that old name it just uses the cache hence you don't see an error. Try creating a new notebook (or even better a whole new python environment), and run both codes in there see if you can reproduce the error for both versions.

You can try and run mermaid server locally following these steps. Let me know after you try these, we need to report this to langchain and mermaid team.

1. Download and run the mermaid container folowing instrutions here.
2. From your python directory navigate to langchain_core/runnables/graph_mermaid.py/ > _render_mermaid_using_api() and replace https://mermaid.ink in image_url with `http://localhost:3000. Keep the rest of the url intact.

you need using this, Module Federation 2 has another approach https://module-federation.io/guide/basic/runtime.html#registerremotes

After some debugging, found that if I add a signal handler in the HAL, that solves the problem, no longer seeing a crash. Posting it here in case someone else has similar issues

I am facing the same issue. Were you able to solve it?

@Christophe To my understanding, the term "class" in a class diagram represents the principle of object-oriented programming. You cannot simply say that the model must be separated from the implementation. Rather, the model must be precisely transferable to the respective implementation and vice versa. The remaining question is: how do I represent the following implementation in a UML class diagram?

class LeaseAgreement{
    public Person tenant{
        get{
            return tenant;
        }
        set{
            tenant = value;
        }
    }

}

class Person{
    public string name{get{return name;}set{name=value;}}
    public string lastname{get{return lastname;}set{lastname=value;}}
}

In my case i used pm2 to start my server and it somehow change relative path or something like that...

Solution for such case:

provide explicitly cwd option to pm2 from config or directly in terminal, for example: pm2 start dist/main.js -- --name example --cwd /var/www/hope-it-will-help/app

Only issue with CTAS approach is Table/column constraints. Constraints are not copied and it can cause issues in the target system(s). For example, if you have auto increment column, CTAS will not copy the constraint. To keep the table definition as is, use CREATE TABLE LIKE <source table> and then copy the data using insert/insert overwrite.

Well as well and have the money for the people act like you have been working for the company that has been working on that has to have the

I managed to resolve the high CPU usage issue when using WebFlux by configuring the R2DBC connection pool more carefully. Here's what helped in my case:

#in my DB Config class
#The code comments are in Korean

@Bean(name = "arhConnectionFactory")
  public ConnectionFactory arhConnectionFactory() {
    ConnectionFactory conn = ConnectionFactories.get(ConnectionFactoryOptions.builder()
        .option(ConnectionFactoryOptions.DRIVER, "pool") // pool 사용 (proxy로 감싸기 전)
        .option(ConnectionFactoryOptions.PROTOCOL, properties.getDriver()) // mariadb, mssql 등
        .option(ConnectionFactoryOptions.HOST, properties.getHost())
        .option(ConnectionFactoryOptions.PORT, properties.getPort())
        .option(ConnectionFactoryOptions.USER, properties.getUsername())
        .option(ConnectionFactoryOptions.PASSWORD, properties.getPassword())
        .option(ConnectionFactoryOptions.DATABASE, properties.getDatabase())

        // 커넥션 풀 관련 옵션
        .option(Option.valueOf("initialSize"), 1) // 초기 커넥션 수
        .option(Option.valueOf("maxSize"), 2) // 최대 커넥션 수
        .option(Option.valueOf("maxIdleTime"), Duration.ofSeconds(60)) // 유휴 커넥션 유지 시간
        .option(Option.valueOf("maxCreateConnectionTime"), Duration.ofSeconds(5)) // 커넥션 생성 제한 시간
        .option(Option.valueOf("maxAcquireTime"), Duration.ofSeconds(3)) // 커넥션 획득 제한 시간
        .option(Option.valueOf("acquireRetry"), 1) // 커넥션 획득 재시도 횟수
        .option(Option.valueOf("validationQuery"), "SELECT 1") // 유효성 검사 쿼리
        .option(Option.valueOf("backgroundEvictionInterval"), Duration.ofSeconds(120)) // 유휴 커넥션 정리 주기
        .option(Option.valueOf("name"), "arh-r2dbc-pool") // 커넥션 풀 이름
        .build()
    );

    return ProxyConnectionFactory.builder(conn)
        .onAfterQuery(queryInfo -> {
          log.debug("{}", new QueryExecutionInfoFormatter().showQuery().format(queryInfo));
          log.debug("{}", new QueryExecutionInfoFormatter().showBindings().format(queryInfo));
        })
        .build();
  }

BUT,There were two main tasks in my WebFlux server that caused a noticeable increase in CPU usage:

1. Processing JSON parameters and storing them in the database

2. Saving multiple files from a Flux<FilePart> into server storage

I was able to solve the first issue (database write logic for JSON data), and CPU usage has improved since then. However, the second issue—saving multiple files to disk—is still causing high CPU load.

Has anyone faced similar problems with Flux and file I/O in WebFlux? I'd appreciate any tips or advice on optimizing file write operations (e.g., writing to disk efficiently in a reactive context).

Adding border-1 did the trick, thank you @Wongjn on the comments.

page.tsx

export default function Home() {
  return (
    <div>
      <input className="border-1 border-solid border-black rounded-md" type="text" disabled />
    </div>
  );
}

The only changed I need was in the method 'get_current_user' I added an if...else that return 'None' if the user is not logged in, than I added 'get_current_user' for all endpoints and works for all user authenticated or not.

the key is to `InstallArtifact`

    const install_tests_bin = b.addInstallArtifact(tests, .{});
    b.step("install-tests", "Install tests to zig-out/bin").dependOn(&install_tests_bin.step);

You could use the walrus operator in a dictionary value as follows:

count = 10

dictionary1 = {
                1: 'One', 2: 'Two', 3: (count := count + 1)
              }

print(dictionary1[3])

The walrus operator returns the value of the assignment.

The problem was I had competing manifests due to using yarn and npm and npx. Steps to fix:

1. Delete node_modules and package-lock.json (because I have a yarn.lock instead)
2. Run yarn install

The project is now building and running again locally.

pjjonesnz has published a github project to add styles to the Excel export:

https://github.com/pjjonesnz/datatables-buttons-excel-styles

The credit for this answer goes to @dimich. The problem is a copy of the NeoPixel object is being made and since there is none defined in the class, this results in a memory deallocation of the pixels member.

Specifically, the statement pixel = Adafruit_NeoPixel(1, 25, NEO_GRB + NEO_KHZ800); destroys that 1st instance in which pixels is NULL, which is not a problem. It then creates the new one and allocates the memory for the pixels member, and then makes an automatic copy since there is no copy constructor. Since the data member pixels is dynamically allocated, its pointer is copied. In all, three instances are created. The 2nd instance is then destroyed, which causes the problem.

Because the 3rd instance points to the same section of memory for pixels, when the 2nd instance is destroyed, so is the allocation for that memory. Thus, the memory is free for other uses, and the pointer that was copied is no longer valid.

In order to make it clearer:

Adafruit_NeoPixel pixel; // 1st instance; pixels == NULL
pixel = Adafruit_NeoPixel(1, 25, NEO_GRB + NEO_KHZ800); // pixel contains a copy of the pixels pointer, but not its memory.
// pixel.pixels == 0x555 and Adafruit_NeoPixel(1,...).pixels == 0x555
// after the copy is made 0x555 is freed and the pixel.pixels points to freed memory.

From Brave AI, it says it best:

If you do not define a copy constructor, the compiler-generated default copy constructor will copy the data members directly. However, if the class contains pointers or dynamically allocated resources, a custom copy constructor should be defined to handle deep copying, ensuring that the new object has its own copy of the dynamically allocated resources rather than sharing the same resources as the original object.

Thanks again to @dimich for catching this easy to miss problem.

I worked it out! It was rather simple.

launch.bat

@echo off

:: Assumes native_bridge.py and the 'venv' folder are in the same directory as this batch file.

:: Path to venv python relative to this batch file
set VENV_PYTHON="%~dp0venv\Scripts\python.exe"

:: Path to the python script relative to this batch file
set SCRIPT_PATH="%~dp0native_bridge.py"

:: Define log file paths relative to this batch file's location
set STDOUT_LOG="%~dp0native_bridge_stdout.log"
set STDERR_LOG="%~dp0native_bridge_stderr.log"

:: Execute the script using the venv's python, redirecting output
%VENV_PYTHON% %SCRIPT_PATH% > %STDOUT_LOG% 2> %STDERR_LOG%

com.nativebridge.test.json

{
  "name": "com.nativebridge.test",
  "description": "Persistent event bridge",
  "path": "C:\\NativeBridgeTest\\native_host\\launch.bat",
  "type": "stdio",
  "allowed_origins": [
    "chrome-extension://fedjpkbjlhmmnaipkljgbhfofpnmbamc/"
  ]
}

As you can see the manifest is launching launch.bat. Great. My AHK script sends messages down the pipe, they arrive in native_bridge.py but never reach the browser? Why? Because I'm redirecting stdout of native_bridge.py for logging... Well whatever I guess I worked it out. I'll leave this repo public in it's fixed state in case anyone wants to copy it in future.

I am facing the exact same issue

flutter: ClientException with SocketException: The semaphore timeout period has expired.

(OS Error: The semaphore timeout period has expired.

, errno = 121), address = xxxx, port = 59881, uri=http://xxxxxx:2020/bastate

I'm facing a similar issue. I am trying to play youtube videos in the background but I couldn't solve the problem. Have you found a solution or a workaround?

Why don't you just copy and past the old /home into the new OS?

I mean, really. Is there a reason of why you can't do something so simple?

This seems to have been a mistake and was fixed in the 2013 edition: The list now contains mbtowc and wctomb, but not wcstombs.

This does not solve the problem with visual studio 2022. Instead of getting error C28251, it causes an error of C2731 "wWinMain" function cannot be overloaded. How do I solve this error?

The approch when you use files.associations is the best way,Just a little observation,to know when configure css to tailwind, press ctrl + shift + p and search 'Open Workspace Settings (JSON)' and paste the code and the error disapper

For easier rotation and interaction, I’d recommend checking out Plotly. It’s a solid Python library that lets you create 3D scatter plots you can rotate in real-time, right in the browser. I’ve used similar setups when working with a product visualization platform, and the interactivity makes a big difference, especially when you’re trying to spot patterns or compare dimensions quickly.

Found! name vs id outputs on the pool. (It's easy to loose track of when to use which and seeing the error crosseyed, it's easy to miss the repitition of the full project path that was in the error)

The correct code is:

authority = gcp.certificateauthority.Authority(
    "internal-ca-authority",
    certificate_authority_id=f"internal-ca-authority-{stack}",
    pool=pool.name, # <<<---
...

 You didn't define or call it from the body section:

    {
      "type": "TextBlock",
      "text": "<at>john</at>"
    }

or skip the entities definition:

    {
      "type": "TextBlock",
      "text": "<at>[email protected]</at>"
    }

Apparently it is not possible.

You can simply do it with v.check:

const validValues = ['1', '2', '4'];

const Schema = v.object({
  // ...
  user: v.array(
    v.pipe(
      v.string(),
      v.regex(/^\d+$/, 'Invalid ID format'),
      v.check((item) => validValues.includes(item), 'ID is not allowed')
    )
  )
});

I face the same problem, and nothing on internet answers this question. Did you find a solution for this problem?

Not sure if these are the same three dots (as on line 11)

But I disabled them with

  "workbench.colorCustomizations": {
    // other customizations
    "editorHint.foreground": "#00000000",
  },

Just wanted to share that I submitted an Apple DTS ticket about iOS 18.4 breaking popoverTip/TipKit and they have acknowledged it and confirmed that "it is a known issue for which there is no known workaround at this time."

This is what I had sent them along with an MRE:

There are two issues that I am noticing with my tips in iOS 18.4. These issues were not present prior to updating to iOS 18.4. To be clear, if you run on a iOS 18.2 device, simulator, or in Swift Previews, you do not see these issues.

1. The message Text is truncated. It is not allowed to wrap around anymore.
2. Subsequent tips shown in my TipGroup are presented in a sheet. The tip has no arrow and, interestingly, the text is not truncated here.

Yes, this is a known limitation with the Amazon Prime Video app. It often restricts playback of downloaded content from external SD cards on some devices due to DRM (Digital Rights Management) issues. Netflix handles this differently, which is why it works fine.

Try setting the SD card as the default download location from within the Prime Video app settings, and make sure the card is formatted as internal storage (adoptable storage), if your device supports that. Otherwise, you'll likely have to stick with internal storage for Prime downloads.

I am having a similar problem with custom dimensions. Views change to zero, but I know there is activity based on date and user counts.

2nd issue was the action property of the form tag, didn't need an action property, think the ide slipped it in. It all works now.

The error 535, '5.7.8 Username and Password not accepted' means that Gmail isn't accepting your login info.

My suggestion:

1. Make sure you've turned on 2-Step Verification in your Google account.

2. Go to your Google account's Security settings and create an App Password — you’ll use this instead of your regular password.

3. Please double-check that your EMAIL_PASSWORD environment variable has that app password set.

Try updating your config to the following:

springdoc:
  default-produces-media-type: "application/json"
  swagger-ui:
    path: /index.html

server:
  port: 8088
  servlet:
    context-path: /api/v1

1- Clean up old NVIDIA drivers

sudo apt purge '^nvidia'

2- Install the recommended driver automatically

sudo ubuntu-drivers autoinstall

3- Restart the system

sudo reboot

Regretfully....I upgraded to SSMS 20

Found the solution in another Question: by using "npm config set script-shell powershell" fixed the problem

Update. The Clearbit free logo API will be shut down on 12/1/25. Reference this changelog for alternatives - developers.hubspot.com/changelog/…

As of 2025 you can:

1. Download the official Data Wrangler extension;
2. Run your code and have your data frame in memory;
3. Open Jupyter Variables;
4. Choose the data frame;
5. Boom! Voila!

Data frame with Data Wrangler

After trying all of the suggestions here, I also needed to delete browsing data, and now the site loads fine.

-- Criar o banco de dados
CREATE DATABASE LOJABD;
USE LOJABD;

-- Criar a tabela CLIENTE
CREATE TABLE CLIENTE (
    codigo INT AUTO_INCREMENT PRIMARY KEY,
    nome VARCHAR(100) NOT NULL,
    estado VARCHAR(2) NOT NULL,
    cidade VARCHAR(100) NOT NULL,
    telefone VARCHAR(15) NOT NULL
);

-- Criar a tabela PRODUTO
CREATE TABLE PRODUTO (
    id INT AUTO_INCREMENT PRIMARY KEY,
    nome VARCHAR(100) NOT NULL,
    valor DECIMAL(10,2) NOT NULL,
    quantidade_estoque INT NOT NULL
);

-- Criar a tabela COMPRA
CREATE TABLE COMPRA (
    numero INT PRIMARY KEY,
    data_compra DATE NOT NULL,
    codigo_cliente INT,
    id_produto INT,
    quantidade_comprada INT NOT NULL,
    valor_compra DECIMAL(10,2) NOT NULL,
    FOREIGN KEY (codigo_cliente) REFERENCES CLIENTE(codigo),
    FOREIGN KEY (id_produto) REFERENCES PRODUTO(id)
);

I also kept facing the cache miss issue where it would install and then towards the end just get stuck and i couldn't kill terminal.

But after i updated nodejs version i managed to run npm install again and it worked.

The answer to your question is that what marks it as a virus is the way it is compressed, meaning your initial guess was correct. Although I am not aware of any viable alternatives, there is actually a way to forget switching to a different compile tool, remove the error, and get your software whitelisted.

If you visit this link (https://www.microsoft.com/en-us/wdsi/filesubmission), you can get your software whitelisted by Microsoft. All you need to do is fill out a form and wait for a response. It's a pretty lengthy process overall, but it may be worth it.

Hope this helped.

1. RESTART MYSQL WORKBENCH

2. under the window title there is a house icon and a welcome screen, welcomeToMysqlWorkbench and at the bottom are your MysqlConnections

3. open some connection by double clicking

4. from the top you see, the house icon, menu, toolbar and usually there are two tabs [Admin] and the other is [Schema]

5. you only see items from [Admin] and not your schemas

6. on the left the panel continues, with two more tabs [object info] and [session]

7) above [object info] and [session] there is a dividing line, which you can grab with your mouse and move it down

8. you will see the top two tabs [Admin] and [schema]

TabView { ... }.indexViewStyle(.page(backgroundDisplayMode: .always))

Will get you:

According to https://developer.apple.com/documentation/swiftui/view/indexviewstyle(_:), this has been available since iOS 14.

Check in IIS authentications is correct for the site, OR check in the server if there are pages, maybe it was not well published

This is a VERY GOOD QUESTION.

I also wanna know why it didn't change the .editorconfig when i change the severity at the light bulb.

1)) First of all, i'll will explain the 4 options.

• "Configure IDE0090 code style" is to configure options (except severity) related to the IDE0090 (The "IDE*" are called code rule or code style, something like that).

It's like in Tools -> Options -> Text Editor -> Code Style - General

you'll see the 2 columns Preference and Severity,

the "Configure IDE0090 code style" should belong to the Preference column.

There're many code styles which i couldn't find in the GUI of VS 2022 (Tools -> Options -> Text Editor -> Code Style - General),

very inconvenient.

Luckily you can still configure them in the .editorconfig file.

• "Configure IDE0090 severity" is to change the severity of the IDE0090, obviously.

I'm NOT 100% sure but i guess "None" means it'll completely ignore the IDE0090 .

"Silent" means you won't see a sign of the IDE0090 in the code, the only way is to move your mouse or the cursor (I don't remember) to the place in your code which triggers the IDE0090, then maybe a light bulb or screwdriver will pop up at the start of the code line.

"Suggestion" means you'll see little 3 dots in the code where IDE0090 is triggered.

"Warning" means you'll see green squiggle in the code, it'll still let you build, like any other warning.

"Error" means you'll see red squiggle in the code, it won't let you build, like any other error at build.

• "Configure severity for all 'Style' analyzers" means changing the severity of all Code Style options for the whole project,

it might be fun to change them all to Error to spot them all then changing their severity to whichever we want,

i may try that in the future, please let me know how it'll be if you try it.

• "Configure severity for all analyzers" means changing the severity of all "analyzers", i'm NOT sure what it truly means but i guess it's like all hints, screwdriver, light bulb, etc.

2)) About the stupid options that don't change the .editorconfig when we choose the severity options.

The way i handle it is to hover mouse over the option of severity that i want, then click the "Preview changes",
it'll show you the code that should be added into the .editorconfig ,

you copy that code then paste it into the .editorconfig like you saw in the "Preview changes" using something like Notepad.

In my case what solved was putting the widgets inside a Stack and adjust them with the Positioned widget. And the widget that is supposed to be above the other must come last in the stack children list.

Try

OPENXLSX_LIBRARY_TYPE=SHARED cmake ..

Or edit in line 35 of file CMakeLists.txt

With a VBA userform, columns on the sheet can be easily hidden and shown. Sheets of workbook are listed in combobox .With this combobox can be navigated between sheets of workbook. The used columns in the selected sheets are listed in the listbox along with the column headings.

The selected columns from the listbox are hidden.

You can review userform here

The answer, as provided by the publisher via email, is as follows:

Manually Backing Up Your Bartender 5 Configuration  
    - Open Finder on your Mac.  
    - Press Command + Shift + G to open the “Go to Folder” dialog.  
    - Enter ~/Library/Preferences/ and press Enter.  
    - Locate the file named com.surteesstudios.Bartender.plist.  
    - Copy this file to a safe location (e.g., external drive, cloud storage).  
      Once you’ve copied this file, you’ll have a backup of your Bartender settings.  
  
2. Restoring or Transferring Settings: 
    If you need to restore (or transfer) your settings to another Mac:  
    - Replace the existing com.surteesstudios.Bartender.plist file in ~/Library/Preferences/ with your backed-up version.  
    - Restart Bartender to apply your restored settings.  
    - This process can also be used if you’re moving to a new Mac and want to keep your personalized Bartender layout and preferences.  

At the time of this post, the accepted solution includes double quotes, which may not be desirable. A workaround to solving the hyphen evaluating as a minus sign in a situation where the double quotes are not desired, append the string with the invisible character [U+200E] as so:

stringId = `[U+200E]${id}`

This will give a string output instead of evaluating the interpreted expression.

IN response to @Adrian, the following is taken directly from a running instance of our v2 release that uses a Postgres server:

comixed=# \d+ displayable_comics_view
                                  View "public.displayable_comics_view"
        Column         |          Type          | Collation | Nullable | Default | Storage  | Description
-----------------------+------------------------+-----------+----------+---------+----------+-------------
 comic_book_id         | bigint                 |           |          |         | plain    |
 comic_detail_id       | bigint                 |           |          |         | plain    |
 archive_type          | character varying(4)   |           |          |         | extended |
 comic_state           | character varying(64)  |           |          |         | extended |
 is_unscraped          | boolean                |           |          |         | plain    |
 comic_type            | character varying(32)  |           |          |         | extended |
 publisher             | character varying(255) |           |          |         | extended |
 series                | character varying(255) |           |          |         | extended |
 volume                | character varying(4)   |           |          |         | extended |
 issue_number          | character varying(16)  |           |          |         | extended |
 sortable_issue_number | text                   |           |          |         | extended |
 title                 | character varying(255) |           |          |         | extended |
 page_count            | bigint                 |           |          |         | plain    |
 cover_date            | date                   |           |          |         | plain    |
 month_published       | integer                |           |          |         | plain    |
 year_published        | integer                |           |          |         | plain    |
 store_date            | date                   |           |          |         | plain    |
 added_date            | date                   |           |          |         | plain    |
View definition:
 SELECT DISTINCT d.comic_book_id,
    d.id AS comic_detail_id,
    d.archive_type,
    d.comic_state,
        CASE
            WHEN (EXISTS ( SELECT s.id,
                s.comic_book_id,
                s.metadata_source_id,
                s.reference_id
               FROM comic_metadata_sources s
              WHERE s.comic_book_id = d.comic_book_id)) THEN false
            ELSE true
        END AS is_unscraped,
    d.comic_type,
    d.publisher,
    d.series,
    d.volume,
    d.issue_number,
    ( SELECT "right"(concat('0000000000', d.issue_number), 10) AS "right") AS sortable_issue_number,
    d.title,
    ( SELECT count(*) AS count
           FROM comic_pages cp
          WHERE cp.comic_book_id = d.comic_book_id) AS page_count,
    d.cover_date,
        CASE
            WHEN d.cover_date IS NULL THEN 0
            ELSE month(d.cover_date)
        END AS month_published,
        CASE
            WHEN d.cover_date IS NULL THEN 0
            ELSE year(d.cover_date)
        END AS year_published,
    d.store_date,
    d.added_date
   FROM comic_details d;



comixed=# select * from displayable_comics_view limit 5;
 comic_book_id | comic_detail_id | archive_type | comic_state | is_unscraped | comic_type | publisher |          series          | volume | issue_number | sortable_issue_number |               title               | page_count | cover_date | month_published | year_published | store_date | added_date
---------------+-----------------+--------------+-------------+--------------+------------+-----------+--------------------------+--------+--------------+-----------------------+-----------------------------------+------------+------------+-----------------+----------------+------------+------------
         34944 |           34944 | CBZ          | STABLE      | f            | ISSUE      | Ablaze    | Lovecraft Unknown Kadath | 2022   | 1            | 0000000001            | Episode 1: Dylath-Leen            |         36 | 2022-09-13 |               9 |           2022 | 2022-09-13 | 2025-03-08
         34945 |           34945 | CBZ          | STABLE      | f            | ISSUE      | Ablaze    | Lovecraft Unknown Kadath | 2022   | 2            | 0000000002            | Episode 2: Mount Ngranek          |         35 | 2022-10-29 |              10 |           2022 | 2022-10-25 | 2025-03-08
         34946 |           34946 | CBZ          | STABLE      | f            | ISSUE      | Ablaze    | Lovecraft Unknown Kadath | 2022   | 3            | 0000000003            | Episode 3: In the Valley of Pnoth |         34 | 2022-11-24 |              11 |           2022 | 2022-11-22 | 2025-03-08
         34947 |           34947 | CBZ          | STABLE      | f            | ISSUE      | Ablaze    | Lovecraft Unknown Kadath | 2022   | 4            | 0000000004            | Episode 4: The Tower of Koth      |         36 | 2022-12-15 |              12 |           2022 | 2022-12-13 | 2025-03-08
         34948 |           34948 | CBZ          | STABLE      | f            | ISSUE      | Ablaze    | Lovecraft Unknown Kadath | 2022   | 5            | 0000000005            | Episode 5: Celephais              |         36 | 2023-01-23 |               1 |           2023 | 2023-01-24 | 2025-03-08
(5 rows)

If Postgres doesn't have a month() or year() method, then how do the above work?

As of 4/21/2025, Pivot Tables will summarize empty cells. But, the filter function fails to identify a cell using = Empty and = Not Empty (it does not let you use <> Empty). To simply get rid of empty rows, the "Ignore empty rows" works.

if its fastapi you can directly use :

pkill -f uvicorn or

for force case:

sudo pkill -f uvicorn

You can try this . Thanks

As far as I know, Python’s type system doesn’t let you write an overload that only applies when the argument isn’t a literal. There's just no concept of a "non-literal" type as a separate category.

You could handle the type checks manually at runtime, or split the function into a few separate ones depending on the case.

Unfortunately, I don't know of any way to express "this overload is for non-literals only" in a cleaner way :(

This appears to be a bug in SQL Server, the truncation information seems to get corrupted when values are coming from a join.

See bug report: https://feedback.azure.com/d365community/idea/04497da1-5d25-ec11-b6e6-000d3a4f0da0

as well as related stackoverflow question Uniqueidentifier stored as varchar datatype generates random string on concatenation with other varchar values

According to the feedback site, this is fixed in Azure and will be fixed in future SQL Server version

Same problem, any solution? Thanks

I found this error is because the old version of @types/react, I solved this error when I upgrade the version from 18.2.6 to 18.3.20.

Нельзя в ворде добавлять водные знаки на разные страницы, только один и на все страницы

I'm having this same problem when using nuxt 3, but since the beginning I've been creating pages within pages, but it still doesn't update and I need to stop and start the server again.

I think the issue is probably with how you're updating self.items inside the update method. If you're calling char.inv.update(...) from within addItem(), you need to make sure you're passing in the most up-to-date invDBObject, because update() itself doesn’t know where to get the latest data.

Had the same trouble. This link fixed it for me: https://forreststonesolutions.com/robots/

**You will find the solution you are looking for in the link below. **
https://github.com/alirizagurtas/powershell-project-backup-archiver

I’ve created a Laravel package which lets you record a real HTTP request and it will automatically create a Fixture with faker data similar to Laravel factories. It works almost the same way as Charlie mentioned in his comment.

Http::fake(["https://api.stripe.com/v1/*" => Http::response(
    (new StripeFixture())->toJson(),  200),
]);

Check it out here

In that case, you'll want to set the objectWrap option to collapse.

See https://prettier.io/docs/options#object-wrap

This is what pylint warns about:

def f(a=1, *args, **kwargs): 
    pass

f(1, a=1)

Traceback (most recent call last):
    f(1, a=1)
    ~^^^^^^^^
TypeError: f() got multiple values for argument 'a'

Whether this error could happen depends on what circumstances a function used in.

did you figure this out, facing a similar issue with google workspace add ons (I'm a newb)

I need to update the midpoint variable to "chase" the midpoint value if the midpoint gets swapped:

uint partition(Tester &tester, uint start, uint end) {
    uint midpoint = (start + end) >> 1;
    for (;;) {
        while (tester.compare(start, midpoint) < 0)
            ++start;
        while (tester.compare(midpoint, end) < 0)
            --end;
        if (start >= end)
            return end;
        if (midpoint == start)
            midpoint = end;
        else if (midpoint == end)
            midpoint = start;
        tester.swap(start++, end--);
    }
}

The grid.pager.resize in the Databound event wasn't working for me. I finally just went with this:

.Events(e => e.DataBound("onDatabound"))

function onDatabound(e) {
    $('.k-pager-info').show(); // show page 1 of 10 messaging in grid.
};

As you can see:

SyntaxError: invalid syntax

id_count += 1 is a statement which a python dictionary does not allow. Like furas mentioned, try using this:

"id": id_count + 1

Another way to solve this is to look at this other question similar to yours about why Python doesn't dictionaries support operators such as +, +=, etc.

While setting whis=99 to include all samples, how do I use whiskers to present 10%-90% range instead of the min and max values?

you need to wrap your Column with an IntrinsicWidth

example (try to run this):

return IntrinsicWidth(
  child: Column(
    mainAxisAlignment: MainAxisAlignment.center,
    crossAxisAlignment: CrossAxisAlignment.start,
    children: [
      Row(
        children: [
          const Spacer(),
          Container(
            color: Colors.white,
            width: 20,
            height: 40,
          ),
        ],
      ),
      Container(
        color: Colors.orange,
        width: 50,
        height: 40,
      ),
      Container(
        color: Colors.white,
        width: 100,
        height: 20,
      ),
    ],
  ),
);

Okay, after more digging into the source code, I found a very crude solution that works.

One option is to add the following line after the map plotting code that just turns off clipping for everything in the axes.

[x.set_clip_on(False) for x in list(ax.patches)]

You don't show where updateSource is being called, but I'm going to take a guess and assume that this T extends "object" | "array" means you're passing in the string from typeof(myObject)? If that's the case, an array will just return object, not array. If you're only trying to distinguish between an actual object and an array, just pass in the boolean returned from Array.isArray. If you really want to stick with the strings, and just make sure that T fits the case that you have now, you can do Array.isArray(myObject) ? "array" : "object".

Do you have an openly available example repository to reproduce this on? In my experience, syft works well with package.json (not sure if I tried it with package.lock). However, note that syft by default does not include development dependencies. That was one pitfall I encountered. There is a configuration variable for toggling that behaviour, if you need it.

In my case the default TargetFramework didn't work, I had to use Net.Net80

private readonly ReferenceAssemblies referenceAssemblies = Net.Net80
    .WithPackages([new PackageIdentity("Microsoft.EntityFrameworkCore", "8.0.11")]);

You should specify Entrypoint like this

ENTRYPOINT [ "/lambda-entrypoint.sh" ]

There are unofficial ways to switch Python versions, try out this notebook for Python 3.8.

For additional details, see: https://github.com/j3soon/colab-python-version.

Doesn't look like a bot token. Please send me a token of your bot. It should look like this:

123456:ABC-DEF1234ghIkl-zyx57W2v1u123ew11

May be you could just drag those apart-positioned window in android studio form and connect/drop to some edge of inner side in it?

Both ways are good, Usign the context directly without "Provider" property is a feature of React 19 version

For more information you can have a look on react 19 post with the new features released on the framework

https://react.dev/blog/2024/12/05/react-19#context-as-a-provider

from fpdf import FPDF

from PIL import Image

# Load the generated image

image_path = "/mnt/data/carbon_footprint_poster.png"

# Convert the image to A3 size in mm (A3 = 297 x 420 mm)

a3_width_mm = 297

a3_height_mm = 420

# Create a PDF with A3 size

pdf = FPDF(orientation='P', unit='mm', format='A3')

pdf.add_page()

pdf.image(image_path, x=0, y=0, w=a3_width_mm, h=a3_height_mm)

# Save the PDF

pdf_path = "/mnt/data/Carbon_Footprint_Poster.pdf"

pdf.output(pdf_path)

pdf_path

1. open Windows Task Manager

2. right click on emulator process

3. select "Maximize"

Ok here is what worked eventually:

On socketio definition

socketio = SocketIO(app, cors_allowed_origins="*", async_mode='threading')

(I did not have the async_mode set)

And then when initialising:

if __name__ == '__main__':
    socketio.start_background_task(start_stream_consumer, r, emit_leaderboard_updates)
    socketio.run(app, debug=True)

That seems to do the trick

I recommend syft by anchore. It is an open source tool that works reasonably well. It can also include dll files in the output, if you point it at a folder containing them. However, in my experience it can get the PURL and CPE wrong for dlls. If your goal is to compare the SBOM to vulnerability databases (using grype, for example), it won't work. And of course syft won't decompile the dlls for you and include their dependencies as well. I feel like .NET projects are extra tricky, because they offer so many ways of including dependencies. Syft doesn't recognise them all. You'll definetely have to do some experimentation on your project.

If anyone is having issues with Angular version 19 and using hmr, setting projects.{app-name}.architect.build.configurations.development.optimization.scripts: false in angular.json did the trick for me.

I redacted original Matt solution a bit.

@echo off
chcp 1251
::::::::::::::::::::::::::::::::::::::::::::
:: Elevate.cmd - Version 9 custom
:: Automatically check & get admin rights
:: see "https://stackoverflow.com/a/12264592/1016343" for description
::::::::::::::::::::::::::::::::::::::::::::
 CLS
 ECHO.
 ECHO =============================
 ECHO Running Admin shell
 ECHO =============================

:init
 setlocal DisableDelayedExpansion
 set cmdInvoke=1
 set winSysFolder=System32
 set "batchPath=%~dpnx0"
 rem this works also from cmd shell, other than %~0
 for %%k in (%0) do set batchName=%%~nk
 set "vbsGetPrivileges=%temp%\OEgetPriv_%batchName%.vbs"
 setlocal EnableDelayedExpansion

:checkPrivileges
  whoami /groups /nh | find "S-1-16-12288" > nul
  if '%errorlevel%' == '0' ( goto checkPrivileges2 ) else ( goto getPrivileges )


:checkPrivileges2
  net session 1>nul 2>NUL
  if '%errorlevel%' == '0' ( goto gotPrivileges ) else ( goto getPrivileges )

:getPrivileges
  if '%1'=='ELEV' (echo ELEV & shift /1 & goto gotPrivileges)
  ECHO.
  ECHO **************************************
  ECHO Invoking UAC for Privilege Escalation
  ECHO **************************************

  ECHO Set UAC = CreateObject^("Shell.Application"^) > "%vbsGetPrivileges%"
  ECHO args = "ELEV " >> "%vbsGetPrivileges%"
  ECHO For Each strArg in WScript.Arguments >> "%vbsGetPrivileges%"
  ECHO args = args ^& strArg ^& " "  >> "%vbsGetPrivileges%"
  ECHO Next >> "%vbsGetPrivileges%"
  
  if '%cmdInvoke%'=='1' goto InvokeCmd 

  ECHO UAC.ShellExecute "!batchPath!", args, "", "runas", 1 >> "%vbsGetPrivileges%"
  goto ExecElevation

:InvokeCmd
  ECHO args = "/c """ + "!batchPath!" + """ " + args >> "%vbsGetPrivileges%"
  ECHO UAC.ShellExecute "%SystemRoot%\%winSysFolder%\cmd.exe", args, "", "runas", 1 >> "%vbsGetPrivileges%"

:ExecElevation
 "%SystemRoot%\%winSysFolder%\WScript.exe" "%vbsGetPrivileges%" %*
 exit /B

:gotPrivileges
 setlocal & cd /d %~dp0
 if '%1'=='ELEV' (del "%vbsGetPrivileges%" 1>nul 2>nul  &  shift /1)

 ::::::::::::::::::::::::::::
 ::START
 ::::::::::::::::::::::::::::
 your code

Now its much less buggy and properly support both cyrillic and if/else parameters.

Make sure that your Android Studio > Tools > SDK Manager > Flutter is pointing to the correct tools that you're using (e.g. fvm list if you're using fvm. Fixing the tools resolved this problem for me.

A .d.ts file is a type file. E.g. it would contain things like export type Alphabet = 'A' | 'B' | 'C'.

The purpose of the compiler is to transpile .ts files into .js files, so I don't think producing a single .d.ts file would've been perceived as a necessary feature.

See this StackOverflow post: About "*.d.ts" in TypeScript

I think what you really want to do is to compile everything into a single .js file. I believe webpack is the correct tool to use in this case.

Stop using gnatmake and use gprbuild instead.

I located the test.py code on the same level as the my_project folder. I found that in addition to the following entry suggested by @bsraskr.

my_project/__init__.py

from . import draw

You also need:

my_project/draw/__init__.py

from .shapes import box