If you’ve ever had to clean messy text lists — emails, logs, passwords, or exported data — you know how painful duplicates can be.

Meet NodeDupe.com — a fast, clean, privacy-focused tool that removes duplicate lines instantly ⚡

Perhaps their visibility could be checked whenever they're active, so that if a PanelContainer is on top the nodes below the stack are ignored, i.e. the nodes below either toggle the PanelContainer's mouse_filter and mouse_behavior_recursive properties, or Area2D's properties (monitoring, monitorable, mask, or layer).

Close any open instance of browser first, which is loaded with the same profile sometimes works.

1. Right-click the Docker Desktop icon in your system tray.

2. If it says “Switch to Windows containers”, it’s currently in Linux mode. If not, select Switch to Linux containers.

3. Wait for Docker to restart.

If you move your entities into a shared model or domain package for reuse across services (common in microservices), always add @EntityScan in each service’s Spring Boot app.

i have tbe same issue. Have you found a resolution? any help much appreciated

This seems to be a classic case of, "Help me with my solution, don't ask me about the problem I'm trying to solve."

What are you trying to do overall? What kind of a service are you trying to provide?

It appears that the way you have conceptualized it does not admit of a reasonable architecture.

az account set --subscription xxxxx
az provider register --namespace Microsoft.Datafactory

The HTTP 400 error when sorting in phpMyAdmin happens because the web server (Lighttpd) blocks URLs that contain encoded line-feed characters (%0A) in the `sql_query` parameter. This is a security check that causes phpMyAdmin requests to be rejected.

To fix it, open your Lighttpd configuration file and add this line to allow phpMyAdmin URLs:

$HTTP["url"] =~ "^/phpmyadmin/" { server.http-parseopts += ( "url-ctrls-reject" => "disable" ) }

Then save the file and restart Lighttpd:

systemctl restart lighttpd

After that, phpMyAdmin will be able to sort columns again without returning the 400 error.

If you only use it for local testing, this change is safe.

For production environments, it’s better to keep this limited to phpMyAdmin instead of applying it globally.

I recently built an open-source tool that automatically converts Chrome extensions to Firefox extensions.

It uses Rust and AST-based transformations (via SWC) instead of simple string replacements, so it handles Manifest V3 extensions more reliably than older approaches.

You can check it out here:
https://github.com/OtsoBear/chrome2moz

Might be useful for anyone still looking for a practical Chrome → Firefox converter. Feedback and contributions are welcome.

Столкнулся с аналогичной проблемой: cv2 никак не хотел устанавливаться с Python 3.14. Я пробовал устанавливать компиляторы С++, недостающие файлы и перебирать настройки, но оказалось, что нужно было просто заменить версию Python на 3.10 - с ней cv2 нормально установился и работает.

secp256k1 only has wheels for Linux. This means that it is not compatible with Windows OS.

If you don't have a Linux machine, you can get Linux on Windows with WSL and then install this package in that environment.

The mmec function has been superseded by the mmes function. That is written in the documentation.

I would suggest you use the GWAS by GBLUP approach to make the problem a 500x500 size problem instead of 30K x 30K, where you can still recover the 30K effects with a simple back transformation. That model should take only few seconds to run instead of hours or days. See the last section of the following vignette:

https://cran.r-project.org/web/packages/lme4breeding/vignettes/lmebreed.qg.html

I get the same error. This seems to be already reported here: https://github.com/microsoft/vscode-jupyter/issues/17042

I had the same issue. Resolved by following steps below:

1. Opened Google Chrome signed out of Github
2. In VS2022 upper right corner account button, I clicked on Add another account and signed in to Github when it opened Github.com in the browser
3. I signed in and it redirected to VS2022
4. Problem solved

curl -sSL https://raw.githubusercontent.com/shoneyJ/grepjson/master/install.sh | bash

I replaced jq with grepjson in my workflow to:

✅ Fuzzy-search JSON without knowing structure
✅ Find values across nested documents
✅ Simple pattern matching like grep

https://github.com/shoneyJ/grepjson

Install gcc-9-multilib instead of gcc-multilib.

For my part, I added ".svn" to my URL and it worked: https://xx.yyy.zz -> https://xx.yyy.zz.svn

Some SVN servers configured with Apache + mod_dav_svn use the .svn extension in the URL to point to the actual repository on the server.

If you forget .svn, Apache can't find the repository → Could not find the requested SVN filesystem. Probably the result of the Apache version upgrade!

For a Node.js solution with automatic restart on network loss, you'll need:

1. **Range requests** with the S3 SDK to resume from last byte
2. **State persistence** to track completed chunks
3. **Retry logic** with exponential backoff
4. **Chunk verification** (SHA256)

I implemented exactly this in S3Ra (https://github.com/Fellurion/NGAPP) - it's an Electron app with a Node.js backend.

**Core implementation approach:**
- Split downloads into configurable chunks (default 200MB)
- Store chunk state in JSON: `{chunks: [{index: 0, completed: true, hash: '...'}]}`
- Use `getObject` with Range header: `Range: 'bytes=start-end'`
- Verify each chunk before marking complete
- On restart: read state file, resume from first incomplete chunk

# Detach apps from Google Play

# Detaches applications from Google Play Store, disabling updates.

# Needs root and wget binary.

PACKAGES_TO_DETACH=$(cat <<-END

'com.google.android.youtube',

'com.sec.android.app.sbrowser',

'com.google.android.inputmethod.latin',

''

END

)

APP_FOLDER=/data/data/com.adamioan.scriptrunner/files

if [ ! -d "$APP_FOLDER" ]; then APP_FOLDER=/data/user/0/com.adamioan.scriptrunner/files; fi

if [ ! -d "$APP_FOLDER" ]; then

echo "Cannot determine SH Script Runner folder. Exiting. $APP_FOLDER"

exit 2

fi

WGET_BIN=/system/bin/wget

if [ ! -f "$WGET_BIN" ]; then WGET_BIN=/system/sbin/wget; fi

if [ ! -f "$WGET_BIN" ]; then WGET_BIN=/system/xbin/wget; fi

if [ ! -f "$WGET_BIN" ]; then

echo "wget binary is missing"

exit 1

fi

echo "WGET binary found in $WGET_BIN"

echo "Application folder found $APP_FOLDER"

SQLITE_FILE="$APP_FOLDER/sqlite"

echo "SQLITE binary path $SQLITE_FILE"

if [ ! -f "$SQLITE_FILE" ]; then

echo "SQLITE binary does not exist. Downloading to $SQLITE_FILE..."

"$WGET_BIN" "http://www.adamioannides.com/sites/com.adamioan.scriptrunner/resources/sqlite" -q -O "$SQLITE_FILE" > /dev/null 2>&1

if [ ! -f "$SQLITE_FILE" ]; then

echo "SQLITE binary cannot be downloaded"

exit 3

fi

else

echo "SQLITE binary exists"

fi

echo "Setting permissions..."

chmod 755 "$SQLITE_FILE"

echo "Killing Play Store..."

am force-stop com.android.vending

echo "Patching database..."

STORE_DB_FILE=/data/data/com.android.vending/databases/library.db

"$SQLITE_FILE" "$STORE_DB_FILE" "UPDATE ownership SET library_id = 'u-wl' WHERE doc_id IN ($PACKAGES_TO_DETACH)"

echo "Process completed"

My solution was, after creating the DB using CodeFirst, I used the context.Database.ExecuteSqlRaw method to create a temporary table with the same structure without a primary key, then I deleted the original table and renamed the new table and that was it.

Just a thought... assuming you aren't dealing with vast quantities of data, the simplest approach might simply be to get everything in your initial fetch request and then filter and sort the resulting array of objects.

Thanks @sakshi-sharma for your informative tips! Here's my fully working solution.

Eventually, I've decided that it's better to create a new file containing build timestamp (and add it to .gitignore) rather than update an existing one. Also, I prefer having it as a data file rather than .py (in case I want to ignore it being missing - like, when running my project from the IDE).

So, in the end, I am creating a .dotenv-like file src/myproject/.build_info containing key like TIMESTAMP=2025-10-11 21:37:57 each time I execute build --wheel.

Changes to pyproject.toml:

dependencies = [
    ...more stuff...
    "python-dotenv>=1.1.0",
]

[build-system]
requires = ["setuptools"]  # no "wheel" needed
build-backend = "setuptools_build_hook"
backend-path = ["."]  # important!

[tool.setuptools.package-data]
"*" = [
    ...more stuff...,
    ".build_info",
]

New file setuptools_build_hook.py in project's root:

"""
Setuptools build hook wrapper that writes file `src/myproject/.build_info`
containing build timestamp when building WHL files with `build --wheel`.
"""

from datetime import datetime
from os import PathLike
from pathlib import Path

from setuptools import build_meta


def build_wheel(
        wheel_directory: str | PathLike[str],
        config_settings: dict[str, str | list[str] | None] | None = None,
        metadata_directory: str | PathLike[str] | None = None,
) -> str:
    """Creates file `src/myproject/.build_info` with key TIMESTAMP, then proceeds normally."""
    Path("src/myproject/.build_info").write_text(f"TIMESTAMP={datetime.now():%Y-%m-%d %H:%M:%S}\n", encoding="utf-8")
    print("* Written .build_info.")
    return build_meta.build_wheel(wheel_directory, config_settings, metadata_directory)


# Proxy (wrappers) for setuptools.build_meta
get_requires_for_build_wheel = build_meta.get_requires_for_build_wheel
get_requires_for_build_sdist = build_meta.get_requires_for_build_sdist
prepare_metadata_for_build_wheel = build_meta.prepare_metadata_for_build_wheel
build_sdist = build_meta.build_sdist
get_requires_for_build_editable = build_meta.get_requires_for_build_editable
prepare_metadata_for_build_editable = build_meta.prepare_metadata_for_build_editable
build_editable = build_meta.build_editable

And now, how to read this value in runtime:

import myproject as this_package


from io import StringIO
build_timestamp: str | None = None
# noinspection PyBroadException
try:
    build_timestamp = dotenv_values(stream=StringIO(resources.files(this_package).joinpath(".build_info")
                                                    .read_text(encoding="utf-8")))["TIMESTAMP"]
except Exception:
    pass

Please vote the question if it helps. Did not found clear information about solving this issue.

Sorry for reopening this old topic, but I'm looking for just the same. Can you clarify (post some code perhaps?) ho you fixed this? Thank you.

So my method is, to roll the dice again and hope for a double six and then usually on the next turn I pass Go. No functions needed. You're welcome x

Typically it's not meant to be human readable, you would either:

1. Export the value for a service to read and use

2. Use the console where there are links to associated resource, or build a console yourself which links these resources.

I'm also encountering it here, it's really annoying. I'm now in the third hour trying to figure out the issue but I haven't

I think you should try unplugging it and then plug it back in. That will fix x

For non-production servers, server.http-parseopts = ( "url-ctrls-reject" => "disable" ) can be set to bypass the problem. This is not recommended for production servers.

Herllo Derek,

I am a bit late but, I was researching stuff like this, so it could be useful to someone passing as I did a while back

I have not quite figured exactly what you (Derek)  want/ wanted  to do.

But I can give a very simple alternative coding to get a UDF to change other cells, directly in terms of simplicity, ( possibly very indirectly in terms of what is happening behind the scenes.: What is going on here is sometimes considered as VBA having some redirection and ended up a bit lost, or rather does not know where it came from ).

No guarantees, but it may be something for you or others to consider

_ First put all these codings in a normal module

 Option Explicit
' This is the main UDF, used by writing in a cell something of this form   =UDF_Where(E3:E5)
Function UDF_Where(ByVal Cels As Range) As String      ' Looking at this conventionally, a string is likely to be returned  by this function in the cell you put the UDF into
 Let UDF_Where = "This is cell " & ActiveCell.Address & ", where the UDF is in" ' Conventional use of UDF to change value of the cell that it is in
Worksheets("Derek").Evaluate Name:="OverProc(" & Cels.Address & ")"             ' Unconventional use of a UDF to change other cells    ' The  Evaluate(" ")  thing takes the syntax of  Excel spreadsheet   So I need this sort of thing
End Function


Sub OverProc(Cels As Range) ' This can be a  Sub  or  Function
Dim SteerCel As Range
    For Each SteerCel In Cels
     Let SteerCel = "This is cell " & SteerCel.Address & ", from the range I passed my UDF (" & Cels.Address & ")"
    Next SteerCel
 ActiveCell.Offset(10, 0) = "This cell is 10 rows down from where my UDF is"
End Sub

( You will need to name a worksheet "Derek"., (That is not a general requirement but just ties up with the demo coding above and  in the uploaded workbook) )

_ Now, In the worksheet named "Derek", type in any cell, for example D2, the following

=UDF_Where(E3:E5)

, then hit Enter

You should see these results

Alan

‘StackOverflowUDFChangeOtherCells.xls’  https://app.box.com/s/knpm51iolgr1pu3ek2j96rju8aifu4ow

I fixed the issue by downgrading the Jupyter extension.

Try setting the topic.prefix value in the Debezium config. Ensure the connectors' status is 'Running.

Check logs for more. It would be helpful if you could share the status of your connectors here and logs to see if anything is wrong?

Late to the party, but I made a package for this purpose, it's out on CRAN: pipetime.
Each time_pipe() reports the cumulative time since the pipeline started.

install.packages("pipetime")
library(pipetime)

rnorm(1E7) %>% mean %>% time_pipe("mean of 10M rnorm")

data.frame(x = 1:3) |>
mutate(y = {Sys.sleep(0.5); x*2 }) |>
time_pipe("calc 1") |>
mutate(z = {Sys.sleep(0.5); x/2 }) |>
time_pipe("total pipeline")

If you want to create HTML options in bulk, try using this tool https://htmltools.dev/html-option-generator
You can even upload excel containing values which will be converted into html <option> tags

I've just spent over an hour trying to make hot reload work on a fresh project and in case anyone else has encountered this issue and is puzzled after having added the @vite directive to their blade layout to no avail: restart the browser. Not sure if it's Firefox specific but it just wouldn't hot reload, not even in private mode, until I restarted the damn thing. Hope this saves somebody some time and nerves!

Could it be that this is a known bug with ffmpeg.wasm? Other folks are also getting 0-byte empty files when attempting to convert and mp3 to ogg when using the libopus codec. You could try their suggestion, which is to use libvorbis intead. To do so, you could change the Zustand store from:

{
  acodec: "opus",
  outputFormat: "ogg",
  bitrate: "128k",
  // ... other settings
}

to:

{
  acodec: "vorbis",
  outputFormat: "ogg",
  bitrate: "128k",
  // ... other settings
}

To follow up on @jakevdp's answer, a completely equivalent but perhaps slightly more elegant way of systematically pre-empting this issue in equinox is to assign a value directly in the attribute definition:

class MyClass(eqx.Module):

    ...

    param: float = 0 # set to a placeholder to allow tracing
    
    def __init__(self):
        self.param = self._integral_moment(3)

    ...

(venv) soniya@Mukund API % pip show uvicorn

Name: uvicorn

Version: 0.37.0

Summary: The lightning-fast ASGI server.

(venv) soniya@Mukund API %  pip show fastapi

Name: fastapi

Version: 0.118.3

Summary: FastAPI framework, high performance, easy to learn, fast to code, ready for production

venv) soniya.jadhav@Mukund API % pip list | grep -E "fastapi|uvicorn"

fastapi           0.118.3

uvicorn           0.37.0

There is a known issue in react that the translate feature on chrome breaks React's way of tracking components. You can try to replicate it on your own by checking if your page works with translate on.

The issues has been discussed here in great detail https://github.com/facebook/react/issues/11538#issuecomment-417504600

Indeed setting "org.gradle.daemon=false" does not work. But one workaround (that works for me) is to set "org.gradle.daemon.idletimeout=1".

We have created a dedicated tool for this - - - HANACV2SQL.

Multi cloud support. It will generate optimized, production ready sql.

Importantly, it is not a 1:1 CTE Conversion tool.

MockedStatic<StaticClass> mocked = mockStatic(StaticClass.class)
ArgumentCaptor<String> captor = ArgumentCaptor.forClass(String.class);
mocked.verify(() -> StaticClass.staticMethod(captor.capture()));

Was there a solution to this issue? We are on Win 11 / Excel 2016 / Foxit 11.0 and have the same issue using VBA.

If you need a tool to just dump the openapi.json file to disk, you can use this script (NestJS 11): https://gist.github.com/iTrooz/94b2254f808fbe6186b8b375eef0e3a5

To make your Mineflayer bot right-click and interact with custom menus (like GUI interfaces triggered by items or blocks), you need to use the correct interaction methods based on the server's mechanics. For blocks, use bot.activateBlock(block) where block is obtained from bot.blockAt(position). For items in hand (like opening a menu with a compass), use bot.activateItem() or simulate a use with bot._client.write('block_place', {...}) for more custom behavior. Keep in mind some servers use plugins that require exact packet handling or have anti-bot protections, so you may need to listen for window events like bot.on('windowOpen', ...) to handle menus properly.

This is not a complete solution, but for my purposes (being able to run the module from the command line with arguments) I found a workaround. I found out that calling python script.py [options...] forwards those given options to sys.argv in script.py, which I could then read normally using argparser. That was my real objective, not necessarily making a distributable executable, so this worked out fine.

I'm still open for a solution to my original question though.

Moderate Acceptable Use Policy

h2

Effective Date: June 18, 2024

h3

Qualification.

h4

Never use Bitly services to distribute abusive, harmful, or illegal content.

h5

Never engage in abusive, dangerous, or illegal behavior.

h5

Reporting abuse and violations.

h5

Action to be taken if not complied with

h3

Shorter than a link.

h2

We use cookies on our website

h3

Manage cookie preferences

h4

Essential Cookies

h4

Marketing Cookies

h4

Performance Cookies

h4

Targeting Cookies

h4

Web Analytics

h3

Cookie List

Skip Navigation

Menu

Bitly Acceptable Use Policy

Effective Date: June 18, 2024

At Bitly, our aim is to be a catalyst for connections; to empower people, brands, and businesses of all sizes to engage their customers anywhere at scale.

Bitly is committed to protecting and supporting the right to free expression. At the same time, we take the trust and safety of our platform and community of users seriously. Accordingly, any attempt to use the Bitly Services to distribute harmful, false or misleading content or otherwise manipulate the Bitly Services (as defined in the Bitly Terms of Service) for such purposes, is strictly prohibited. If we determine that you are using or have used the Bitly Services to engage in any form of misconduct, including violating this Policy, we may restrict your ability to use our platform, remove your content or suspend or terminate your account. Misconduct may also violate applicable laws and can lead to legal action and civil and criminal penalties.

By accessing or using the Bitly Services, you agree to abide by this Acceptable Use Policy as well as the Bitly Terms of Service, Bitly Privacy Policy and Bitly’s DMCA Copyright Policy and to (collectively, the “Bitly Terms”), as may be modified from time to time.

Eligibility

You may only use the Bitly Services in compliance with the Bitly Terms. If we suspend or revoke your privileges to use the Bitly Services, you will not be eligible to access them again until further notice from us and any attempt to circumvent such access restrictions (e.g. by creating additional accounts or identities) are strictly prohibited and will result in the permanent disabling of such accounts and flagging them for future enforcement purposes.

Never use the Bitly Services to distribute abusive, dangerous, or illegal content

You are prohibited from using the Bitly Services to distribute or promote the following types of content (including but not limited to text, images, video and audio):

Content that attacks individuals or groups on the basis of race, gender, ethnicity, national origin, immigration status, religion, sex or gender identity, sexual orientation, disability, or medical condition, as well as any content promoting organizations with such views.

Content that exploits children

Misinformation, including but not limited to, medical or civic misinformation

Content that threatens, encourages, or promotes violence or graphic imagery

Sexually explicit or intimate content shared without the subject’s consent

Any content that glamorizes or promotes self-harm or endangers your safety or the safety of others

Any content that promotes terrorism

Any other content that is illegal

Never engage in abusive, dangerous, or illegal behavior

You are prohibited from using the Bitly Services to engage in the following types of behavior:

Distributing malware, viruses, badware, or other types of disruptive software

Engaging in phishing, spoofing, hacking, or other attempts to fraudulently gain access to someone’s information

Sending bulk commercial emails or SMA (i.e. spam)

Circumventing Bitly’s systems to evade detection of abuse outlined in the Bitly Terms

Cloaking the destination URL through another redirect service or an open redirect endpoint

Sharing someone’s private information without their consent (i.e. doxxing)

Threatening violence or harm to others

Bullying, harassing, or coordinated online attacks targeting individuals or groups (i.e. brigading)

Impersonating others or misrepresenting your affiliation with any people, organizations or other entities

Facilitating illegal activity such as the sale of prohibited goods and/or services

Infringing another person or entity’s intellectual property

Reporting abuse and violations

We encourage anyone who suspects that someone is manipulating the Bitly Services or violating our Acceptable Use Policy in any way to notify us. We investigate concerns thoroughly and take appropriate actions, up to and including terminating user accounts.

If you believe Bitly mistakenly flagged your activity as

Herllo,

I have been struggling for a few hours to understand some of the answers here, in particular the ones from Cem Firat and Greg. I am thinking perhaps there may be some typos or procedures have got a bit mixed up.  Or I have simply missed the point that was trying to be made in those answers. That is always possible. I did not know what to do with the example procedures, or if I did, it was not clear to me what they were telling me. I apologise if I am wrong, but I suspect the people answering had a good answer, but writing it went astray a bit, maybe not enough for them themselves  to be thrown off, but enough to make it very hard or impossible to see what was trying to be explained.

In the Thread in general it is not always clear if we are talking about Functions and/ or User Defined Functions (UDFs) and so on

However, I have gleaned some info and  I think I can make a useful contribution by giving my take on both

_ what the question is

and

_  what a simply direct answer could be..

First the question:

I have a UDF(User-Defined Function) in VBA that needs to modify cell range on Excel.

(Since a UDF cannot do this……) …. how do I update other cells by calling a UDF?

Before my take on an answer, there may have been a bit of confusion as to what the requirement was, that is to say what we a talking about in terms of functions.

I suggest we are talking about

_ a UDF(User-Defined Function) "making a call" from a worksheet

, and not

_a function in general, or a UDF, which is called from VBA. As TimWilliams said in a comment, …. As long as you're not calling it as a UDF then yes a function can modify the sheet in the ……

In other words a UDF called from VBA or any function called from VBA are in principal the same thing.

But when one refers to a UDF, I think, it generally implies that the user wants to call it from a worksheet. Perhaps this definition is not set in stone, hence the confusion and uncertainty in what we are talking about, in terms of the requirement. The original question did ask …. how do I update other cells by calling a UDF? … This is implying, I think, that we are calling the function from a cell.

Now my answer.

The first part of my answer is to say, JIMVHO, is that it's usually a bad idea to say that something can't be done. I am very open to discusion of why maybe it should not be done, Saying it cannot be done is, JIMVHO, incorrect

My answer does something similar to the worded suggestion from Cem Firat  …..If call other function with ..........Evaluate method in your UDF function you can change everything on sheet (Values,Steel,Etc.) because VBA does not know which function is called….

I was not able to see an actual answer from his (Cem Firat's), examples.

That is what I am doing here in my answer: In my UDF I am calling another procedure  with the Evaluate method, and that procedure will  modify a cell range on Excel.

Let me make it clear again what I am doing, as it is easy to get things in a muddle: I am going to write a function which I will name UDFfunction( ). It will take two arguments, a range,  and a text. The range is where you want the text to go. The function is to be put in a normal code module. This means that if I write a  = in a cell, followed by the function name ( and arguments if it requires them, as it does in this case ), then the function will run. I might refer to this as calling the function from Excel, or calling the function from a cell, or calling a UDF(User-Defined Function) in VBA from an Excel cell range.

So…

All of this coding should be put into a normal module. (Change the worksheet name to suit the worksheet you want to use the function from, in other words, change the worksheet name to suit the worksheet in which you will write the formula/ funtion)

    ' This is the UDF.  A user would use it by typing in any cell in a spreadsheet, something like   = UDFfunction(A1:B2)
    Public Function UDFfunction(Rng As Range, Txt As String) As String
    Worksheets("CemFiratGreg").Evaluate "OtherProc(" & Rng.Address & ", """ & Txt & """)"                  ' Unconventional use of a UDF
     Let UDFfunction = "You did just put the text of """ & Txt & """ in range " & Rng.Address(RowAbsolute:=False, ColumnAbsolute:=False) ' A conventional use of a UDF
    End Function
    
    ' This can be a  Sub  or a  Function
    Sub OtherProc(ByVal Rng As Range, ByVal Txt As String)
     Let Rng = ""
     Let Rng = Txt
    End Sub

(For some versions of Excel it may be necessary at this point to save and close and reopen the file)

Now type something like this in any cell

=UDFfunction(A1:B2;"Texties")

As a result of this, two things should happen.

_(i)  In the cell you typed the UDF  into, you will get the text You did just put the text of "Texties" in cell A1:B2. That is what one might commonly expect a UDF to do, in other words give some text or numbers in the cell that it is written in. Commonly one hears that A UDF is a function that returns a value in the cell where it is called.

_(ii)  The word Texties will appear in the range A1:B2. That is doing something often regarded as impossible. One often hears it said that A UDF cannot change the contents of any cell, other than the one it is in.

I apologise if I have repeated something in the answers so far, but I could not get this far for love nor money from reading any of them. But it gave me some thoughts in the direction.

If pip is not recognized by default, use this method,

        python -m pip --version

for older version,

        py -m pip --version

install pip,

        python get-pip.py

By adding Distinct and Union, I was able to satisfy EF Core.

Instead of query.Concat(query), I used query.Distinct().Concat(query.Distinct()). You might not need Distinct on both branches. See the comment below for more info.

https://github.com/dotnet/efcore/issues/32046#issuecomment-3393373171

Add swap file:

sudo fallocate -l 16G /swapfile
sudo chmod 600 /swapfile
sudo mkswap /swapfile
sudo swapon /swapfile

After this try to build again - works for 16GB ram machine.

You can also use the rename command.

Open your terminal, navigate to the relevant folder using cd, then paste:

rename -f 'y/A-Z/a-z/' *

It will rename all your files to lowercase.

I made a video this week on how to do this without any scripting or apps. Just Shopify flow.

How to Create Best Seller Collections Step by Step (2025)

https://youtu.be/YcG-Mw5DAyo

You can try this one: https://github.com/dameng324/LightProto.

If you run into any problems, open an issue on it's github repo.

uses
jpeg;

procedure TForm1.BitBtn1Click(Sender: TObject);
var
  pict : TPicture;
begin
 pict := TPicture.Create;
  try
    pict.LoadFromFile('D:\Projets Delphi\Dimensions jpeg\Test.jpg');
    LabeledEdit1.Text:=IntToStr(pict.Width);
    LabeledEdit2.Text:=IntToStr(pict.Height);
  finally
    pict.Free;
  end;
end;

After repo sync (when you got make files). - after this step:

cd ~/aosp || { echo " ~/aosp not exists :)"; exit 1; }
repo init -u https://android.googlesource.com/platform/manifest -b android-15.0.0_r1
repo sync

Try to do this command in aosp folder.

. build/envsetup.sh
export TARGET_RELEASE=ap2a  

if ap2a doesnt work try to ap3a ,then

build_build_var_cache 
lunch

Now you got full list of Android builds.

I assume you are using AWS Organizations.

One way to achieve this is to combine with IAM Identity Center.

This is AWS preferred way to grant permissions to human users. IAM Identity Center is a centralized place where you can grant users permissions to accounts and resources.
https://docs.aws.amazon.com/singlesignon/latest/userguide/what-is.html

On your management account IAM Identity Center console you can:

1. Create a group -> Dev

2. Assign uses to this group -> Ben

3. Assign accounts -> Dev account
   

4. Assign permission set -> Admin Role
   

IAM Identity Center configure users through Identity Providers. If you don't have one, AWS has its own Identity Provider for that. You can configure the identity source on Settings -> Identity Source.

Once the users log in, they will be presented with the roles they can assume for each account:

This approach is interesting because users can assume different roles depending on the account, or even have the possibility to assume different roles in the same account.

You won't need to set the same Admin Role in all the accounts. This is going to be configured only on your management account.

This is where you can configure these permissions:

Revised figure

Well, I attached the revised figure, you can see **0.01 and *0.05 significant level without p<0.001

Convert mesh to graph by merging nearby vertices during triangle processing

Instead of building adjacency after the whole mesh is processed, you can build it incrementally as you iterate through triangles.

1. For each triangle, create a small local graph of its 3 vertices (fully connected).

2. Clamp or round vertex positions to a fixed precision (e.g. 0.01 or 0.1 units) to handle float errors.

3. Use a hash table (keyed by clamped position) to cache vertices.

Key format can be a packed integer or a string fallback like "x_y_z".

4. When a new vertex reuses an existing key, merge it —

"steal" its existing connections and link the current triangle’s vertices to it.

This automatically stitches triangles together without needing a second pass.

This method builds the navigation graph in one pass, with automatic adjacency discovery, tolerance for float noise, and minimal overhead.

On the bottom right of the PyCharm screen you will be able to setup the interpreter options for your project like creating a new one (with venv, conda, poetry etc) or switch between multiple interpreters (if you need to test you app with multiple versions of python for example).

Easier one to use in my opinion is venv, it will create a .venv folder in the project and store the installed modules there.

More information here in the official docs: https://www.jetbrains.com/help/pycharm/configuring-python-interpreter.html#interpreter

I2uu uu27 yu3y3t3g3fy2uy 662u3jj2g3k2utwj2uu2u2u3j3j3j3ju3yyj2i4u4iy3j3u3u3u646uyrh3yrytrtdtwgyey3h3jej3jj2j2u3u3uyeuy3u2h4u6ehhryy2jy4uyeuu3hey3yjejuusjèjueuuayyuwuuuusjjjeuryrjhzgdhhdhdjddjjejejeurhj3hfufjrjdjhdjdhdjdhjdhfjfjhdjhhhuu32uuu2u3u3jurjydjruur4uuuehhhehhhrhhjhth

I hacked the eslint-plugin-php-markup package to make it work. The hacked code are available at here: https://github.com/dannyniu/eslint-plugin-php-markup along with a short guide on how to configure the eslint.config.mjs, here's an excerpt:

...
import html from "eslint-plugin-html";
import php from "eslint-plugin-php-markup";
...
... { files: ["**/*.php"],
  plugins: { html, php },
  processor: php.processor,
  settings: {
    "php/php-extensions": [".php"],
    "php/markup-replacement": {"php": "", "=": "0"},
    "php/keep-eol": false,
    "php/remove-whitespace": false,
    "php/remove-empty-line": false,
    "php/remove-php-lint": false
  },
} ...
...

Xcode- Product- Scheme- Edit Scheme，chose Run，then change the Build Configuration mode：Realese.

same problem, looks its a bug.

i am using std::view in c++20, try compiler clang, clang_cl and `"microsoft.com/VisualStudioSettings/CMake/1.0": { "intelliSenseMode": "windows-clang-x64" }` still problem

An array is a collection of elements stored in a contiguous block of memory, which allows direct access to any element using its index in O(1) time. Arrays have a fixed size in static languages, but dynamic arrays (like C++’s vector) can grow or shrink as needed. They are efficient for random access and have better cache locality, making sequential operations faster. However, inserting or deleting elements in the middle or at the beginning of an array requires shifting elements, which takes O(n) time, making such operations slower.

On the other hand, a linked list consists of nodes scattered in memory, where each node stores the data and a pointer to the next node (or previous node in doubly linked lists). Linked lists allow efficient insertion and deletion at the beginning or middle in O(1) time, provided we have a pointer to the relevant node. However, they have slower access times since you need to traverse nodes sequentially (O(n) time) to reach a specific element. Linked lists also use extra memory for storing pointers and have poorer cache performance due to scattered memory allocation.

reloadium can't do monitor single file. but can monitor single running python application.

I want to change my operator from jio to airtel I have port my sim mobile number-9098988825

Have you tried following the steps described here?
https://pages.community.sap.com/topics/crystal-reports/visual-studio

If you still need further assistance, I’d be happy to help.

13 years later, still functional. :)

$(".btn").on("click", function (e) {
    console.log(e.target.id)
})

<meta property="og:locale" content="ar_AR" />

<meta property="og:type" content="<b:if cond='data:view.isSingleItem'>article<b:else/>website</b:if>" />

<meta property="og:title" content="<data:blog.title/>" />

<meta property="og:description" content="<b:if cond='data:view.isSingleItem'><data:post.snippet/><b:else/><data:blog.metaDescription/></b:if>" />

<meta property="og:url" content="<data:view.url.canonical/>" />

<meta property="og:site_name" content="<data:blog.title/>" />

I am not entirely sure what is causing the issue but seems to be related to the server setup.

I tried creating a fresh server in VBox with a fresh install of Ubuntu. The issue still presisted.

However, when I installed XAMPP on my Windows host machine and run the code from there, the issue is not there.

The only thing I can think of that might have caused it could be an incompatible PHP version because XAMPP PHP version is 8.2.12 and Ubuntu's version is 8.3.6.

The main difference between these noations is the part of code execution they describe like upper bound, lower bound or tight bound.

Big O gives an upper limit on how fast the time can grow or we can simply say that it gives the highest limit that the execution of this code can never take more time than this in any of the case or with any input size.

Big-Ω gives the lower bound or it describes the best possible growth rate or we can say that it tells us that the algorithm will take atleast this much time in all the cases now matter how big or how small the size of input is. it is the best case because when on a given input the algorithm takes minimum time the execution is faster.

Big-Θ is used when both upper and lower bounds are the same. it means that the algorithms growth rate is tightly bound on both the sides.

It seems like a bug in cmake https://gitlab.kitware.com/cmake/cmake/-/issues/24163 . When using `PRIVATE`, outer scope will not link torch lib and thus will not trigger the problem.

Updating to newest version of cmake will solve it.

When the MCP server expects as input depends on what tool is selected, for example in the image below, RUBE_SEARCH_TOOL is selected, the input for this will be different to when other tools are selected. So select you MCP node, and make sure you've selected the tool appropriate for you.

Fixing the multiple spaces case that are not stripped in the second post...

void strip_extra_spaces(char *str) {
  int i, x;

  for(i = x = 0; str[i]; ++i) {
      if(!isspace(str[x]) && !isspace(str[i]))
          str[x++] = str[i];
  }

  str[x] = '\0';
}

You can use some online tools to check it

1. parse vless/vmess URL to see if it is valid

2. test the connection by online proxy tester

try google it by "online proxy checker", or directly use the online tools https://getfreeproxy.com/tools/proxy-protocol-parser and https://getfreeproxy.com/tools/proxy-checker .

Add workflow_run to the GitHub Actions .yml, the Coding Agent ignores workflow_call or workflow_dispatch

Upon searching and trying several solutions - > arch -x86_64 pod install --repo-update this command worked. Seemingly it happened due to M1 build.

The function codes for reading holding registers and reading input registers are different. You cannot read multiple registers of both kind using the same kind. Please check the function codes for reading both of these types. You will have to send two different commands - one to read multiple holding registers and one to read multiple input registers.

So what I get to know from documentation is, you can't upload images on Firebase unless a user is logged in/authenticated. If you want anonymous users to upload images without authentication, then you have to change the rules.

Attaching a global key to the local widget surrounding GestureDetector, and using that key to map and fetch point offset solved the issue.

Found that multiple instances of my screen(widget) were being pushed into the navigation stack. Scroll controllers should be one for one view, we cannot share controllers through multiple rendered instances at the same time.

https://dart.dev/null-safety/faq#the-iterablefirstwhere-method-no-longer-accepts-orelse---null
Import package:collection and use the extension method firstWhereOrNull instead of firstWhere.

There exists a method on Navigator class to check if a route can be popped:

  if (Navigator.canPop(context)) {
      Navigator.pop(context);
  }

Reference Article

scenario is needing polymorphic relation.

Laravel Reference: https://laravel.com/docs/12.x/eloquent-relationships#one-to-many-polymorphic-relatio

Did you check the Area2D's collision layer and mask if they match with the first enemy's Area2D?

Maybe they weren't set yet so that the player can't be detected, which then ignores the animations you mentioned.

Here's another idea that avoids using verbs in the url, by treating the reset token like a resource:

POST /accounts/password/reset-token  // creates a new reset token (sent over email)
POST /accounts/password              // resets the password using the reset token

Use the “Show Missing Files” tool in Visual Studio — when you build the project, it will display any files that are not included in the project in the Error List window.

Use docker.

Container all systems in you repo you can.

Add to docker.ignore: docs directory, indexed docs directory, api (because api in the docker deploying and proceed all your containers.

Each of these data structures is designed for a different purpose and therefore has different performance characteristics.

Arrays -

• Fixed size

• Provide O(1) access to any element using its index.

• Insertion/deletion in the middle requires shifting elements → O(n).

  Stacks(LIFO - LAST IN, FIRST OUT) -

• Access is limited to the top element.

• Push and Pop operations → O(1).

• No random access to middle elements.

  Queues (FIFO – First In, First Out) -

• Elements are added at the rear and removed from the front.

• Enqueue (push) and Dequeue (pop) → O(1).

• No direct access to middle elements.

UI Design Draft usually means a preliminary or rough version of a user interface design like an early sketch or wireframe showing the basic layout and flow. It’s not exactly the same as UI, which is the complete, polished interface users interact with. So think of a design draft as a first step in creating the final UI, helping designers explore ideas before finalizing details.

const std = @import("std");
const print = std.debug.print;

pub fn main() void {
    const number_or_error: anyerror!i32 = error.ArgNotFound;
    print("\nOption 1\nType: {}\nValue: {}", 
        .{
             @TypeOf(number_or_error), 
             number_or_error
         }
    );
}

Also, where you have

if( j < start )
{
    quickSort( numbers, start, j );
}

the condition should be

if( start < j )

and just below that, where you have

if( i < start )
{
    quickSort( numbers, i, end);
}

the condition should be

if( i < end )

I was wondering the same thing! Turns out how that options works has changed. It no longer filters when just typing. Now you have to use a search keyboard shortcut first then start typing. If "Filter on Type" is enabled then it will start filtering.

You can find the default keyboard shortcut for your platform here: https://code.visualstudio.com/updates/v1_89#_find-in-trees-keybinding

Uninstall the Microsoft Visual C++ 2015-2022 redistributable and the PostgreSQL with installation failed and try install again.

Has worked for me to upgrade PostgreSQL 17 to 18.

there isn’t a “remote switch” in the Firebase Console that forces the outer email-sign-in link to use your custom domain without updating how the link is generated. After the Dynamic Links migration, Auth uses your Hosting domain by default (e.g. PROJECT_ID.firebaseapp.com) for mobile flows unless you explicitly tell it otherwise.

Oajwobeje no dbeibr Jr RN bright Jen is jtnib iotjtni irjiebbrieb s to go to the year y and the police have Justin and the police

In Python the from A import C syntax looks for the module/file A, grabs C, and puts it into your namespace. What exactly A is is complicated and can very a lot; basically, it can be the name of a module/folder/file in either Python's module library or in the same directory as the script.

For example, if you ran this:

from my_module import add, subtract

This is what Python would do:

• Looks for a module named my_module.
• Gets the objects add and subtract.
• Puts references to them into the local file's namespace.
• If the module is not found, it raises ModuleNotFoundError.
• If the module is found but the target (C) is not found, it raises ImportError.

So you can do this:

from my_module import add, subtract
add(1, 2)

When you do A.B, Python is targeting B, which is inside A. For example if you had this file structure:

| my_module [folder]
| -- __init__.py
| -- functions.py [contains add]
| -- other.py

If you ran from my_module.functions import add, Python is first locating my_module, then looking for functions, and then grabs add. The __init__.py file tells Python that this is a module folder and gets run at import time. That file is not essential in Python 3.x, but it is recommended. (There are also other ways to do this, such as setup.py and packaging it with a distributor, but __init__.py is the most modern and recommended way.)

With the setup above, if you tried to do this:

from my_module import add

...you'd get an ImportError because add is not directly inside the my_module folder.

You can go even further and do this:

from my_module import add as renamed_add
renamed_add(1, 3)

(This will install add exactly the same, but it's imported as renamed_add instead.

---

As for how do install qpid_messaging and qpid, I recognize them vaguely, but I haven't done anything with them personally. you can try running pip install qpid and pip install qpid_messaging in your terminal, if qpid is in the PyPI. If that throws an error or hangs forever, you can maybe look on GitHub or Apache's website for it. When you find it, put it in your site-packages folder. To find the location of your site-packages folder:

import site
print(site.getsitepackages())

(You can do that in an REPL if you don't want to save a file just for that.)