Random snippets of all sorts of code, mixed with a selection of help and advice.
Excel Macro has randomly stopped working despite working well for several months
18 January 2026 @ 11:48 am
I made and have been using an Excel sheet at work for the last 6 months without any issues but the last few days it seems some of my macros are broken and no longer functioning as expected.
They keep stopping and requiring debugging but I can't see any issues nothing looks to have changed that I can see.
Here's the code:
Sub Hour_1()
Dim myurl As String
myurl = Worksheets("Config").Range("A39").Value
Sheets("H1").Visible = True
Sheets("H1").Select
Sheets("H1").UsedRange.ClearContents
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" + myurl, Destination:=Range("$A$1"))
.Name = "287%2C321%2C362%2C632%2C379%2C426%2C720&osm_ids=&oxm_ids=445%2C442&ofm_ids=&datasource_viz=nvd3Table"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.
Failed to read data from: wordlist, punc, numbers
18 January 2026 @ 11:48 am
I want to train tesseract. I tried many tutorials and also the official how-to guide that is on the github for example.
This is the command I run after setting ground truths and line images:
sudo make training RATIO_TRAIN=1.0 MODEL_NAME=gg_custom_1 DATA_DIR=./data GROUND_TRUTH_DIR=./data/gg_custom_1-ground-truth START_MODEL=eng MAX_ITERATIONS=500 TESSDATA=/mnt/tesseract/tessdata TESSDATA_PREFIX=/mnt/tesseract/tessdata
This is what the console is telling me, when I try running it for the first time:
combine_lang_model \
--input_unicharset ./data/gg_custom_1/unicharset \
--script_dir ./data/langdata \
--numbers ./data/gg_custom_1/gg_custom_1.numbers \
--puncs ./data/gg_custom_1/gg_custom_1.punc \
--words ./data/gg_custom_1/gg_custom_1.wordlist \
--output_dir ./data \
\
--lang gg_custom_1
Failed to read data from: ./data/gg_custom_1/gg_custom_1.wordlist
Failed to read data from: ./data/gg_custom_1/gg_custom_1.punc
F
underscore in folder name crashes "ignite scaffold module mymodule"
18 January 2026 @ 11:46 am
I have a package name with underscore "space_chain" and when i trying run "ignite scaffold module customcheck" i got error:
✘ Error while running command /home/mf/go/bin/buf generate /mnt/e/w/go/src/github.com/imbamf/space_chain/proto --error-format=json --log-format=json --template=/mnt/e/w/go/src/github.com/imbamf/space_chain/proto/buf.gen.gogo.yaml --output=/tmp/2933124691 --path=/mnt/e/w/go/src/github.com/imbamf/space_chain/proto/spacechain/customcheck/genesis.proto --path=/mnt/e/w/go/src/github.com/imbamf/space_chain/proto/spacechain/customcheck/params.proto --path=/mnt/e/w/go/src/github.com/imbamf/space_chain/proto/spacechain/customcheck/query.proto --path=/mnt/e/w/go/src/github.com/imbamf/space_chain/proto/spacechain/customcheck/tx.proto: panic: file name spacechain/customcheck/params.proto does not start with expected space_chain/customcheck/; please make sure your folder structure matches the proto files fully-qualified names
Telegram Login Widget does not send the message
18 January 2026 @ 11:33 am
I have a site on React on which I want to register my users - give them token response after they will be verified by Telegram Login Widget.
When I was debugging I used VS Code ports and everything was working exactly as a I wanted. Now when I deployed the site with Nginx inside the Docker and host Nginx the Telegram Button only renders but when I input the phone and send the code I have nothing in my telegram.
In BotFather everything is fine. So I set the domain and it's working correctly I think.
Common:
Button also doesn't collect the redirect_url I gave it it just takes current page URL
Maybe it's because I have 2 Nginx - inside Docker and host Nginx
Maybe something is wrong with the domain
I need to put telegram in the trash can
js methods includes() solve this
18 January 2026 @ 11:33 am
Now use either a template literal or string concatenation to log the message fccSentence.includes("freeCodeCamp") returns <hasFreeCodeCamp> because the word "freeCodeCamp" is in the sentence. to the console. Replace <hasFreeCodeCamp> with the actual value of the variable.
const fccSentence = "freeCodeCamp is a great place to learn web development.";
console.log("Here are some examples of the includes() method:");
const hasFreeCodeCamp = fccSentence.includes("freeCodeCamp");
Pango passes wrong glyph indices to custom renderer
18 January 2026 @ 11:30 am
I'm trying to implement a custom renderer for Pango, but in the draw_glyphs function, I run into the problem that the PangoGlyph glyph codes in the glyph info I get passed by Pango through the PangoGlyphInfos in the PangoGlyphString are wrong:
draw_glyphs(PangoFont* font, PangoGlyphString* glyphs, int x, int y) {
for (int i = 0; i < glyphs->num_glyphs; i++) {
printf("glyph: %u", gi->glyph);
PangoGlyphInfo *gi = &glyphs->glyphs[i];
draw_glyph(font, gi->glyph, p->x, p->y);
x_position += gi->geometry.width;
}
}
If I look at the output of this function, if in the input text i have a c for example, the value of gi->glyph for that is 102 which according to the ASCII table is the letter f, not the letter c.
On top of that, this offset changes depend
Error while importing strawberry-graphql library
18 January 2026 @ 11:23 am
In my virtualenv folder installed strawberry library, checking version:
pip show strawberry-graphql
Shows:
Name: strawberry-graphql
Version: 0.196.2
...
In a Python file, when I do:
import pydantic
print(pydantic.__version__)
the result is 2.5.3.
But when I'm trying to import strawberry itself, getting error (OS is Ubuntu 22.04):
import strawberry
Error:
UserWarning: `pydantic.utils:lenient_issubclass` has been removed. We are importing from `pydantic.v1.utils:lenient_issubclass` instead.
What can be the issue? As I understand it, "importing from pydantic.v1" tries t
Projecting a Text onto a wave Like Loft Prior tobextrude it
18 January 2026 @ 11:20 am
I am in Desperate need of sine advice. After spending several hours of yesterdays evening, Most of Last night and the whole morning today in eager discussion with Copilot and Gemini, I'm lretty lost.
I designed a structure in Grasshopper, which cinsists of several Standing Pipes of a few cm Diameter (all Pipes Same Diameter and length), all Pipes are arranged in the x axis and their middle lies on Y 0 withe the middle of the very First Pipe srarting at Point 0;0;0.
There are bows with a radius around half the size of the Pipe ones, which are placed between each twi pipes, so the area between two Pipes ist flattened a little. All in all, the on top View Looks Wave Like
I created a Text which ist already aligned and sized and which I want to Project / Morph onto my Wave surface.
I already read, that I need a corresponding Loft for this and I created one that resembles half my Objekts Profile (basiyally Eversthing with Y <= 0).
But no Matter what
Angular Electron: Typescript component is not rendered in index.html
18 January 2026 @ 10:46 am
I am new in Angular environment and I am actually developing a little desktop app with electron.
I have inserted the selector (app-root) of the App component (generated automatically) into index.html's main section.
The problem is that when I run ng serve, the web page is rendered correctly even with the component html injected, as you can see in the attached chrome browser screenshot; since a desktop app is my goal, I have to run npm run eb but the result desktop app is quite differently than the expected one: component html (app.html) is not injected into index.html neither any console.log() from main.ts is called.
What's wrong with my configuration (I suppose it is a conf problem since component is rendered only with ng serve)? What should I do to render it even under electron?
index.html:
<!doctype html>
<html lang="en">
<head>
<link rel="stylesheet" href="./index.css&qu
Route admin and user for Marketplace Website
18 January 2026 @ 10:27 am
I'm building a marketplace website for my school project using laravel. I do not have any background, how do I route admin and user for marketplace website?
<?php
namespace App\Models;
// use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
class User extends Authenticatable
{
use HasFactory, Notifiable;
/**
* The attributes that are mass assignable.
*
* @var array<int, string>
*/
protected $fillable = [
'name',
'email',
'password',
];
/**
* The attributes that should be hidden for serialization.
*
* @var array<int, string>
*/
protected $hidden = [
'password',
'remember_token',
];
/**
* Get the attributes that should be cast.
*
* @return array<string, string>
*/
pr