14.5.0: a specific webquery no longer works #23245

2000ede · 2025-04-04T08:17:46Z

2000ede
Apr 4, 2025

Hi,

in script and in console webquery works fine, for example to telegram

=>webquery https://api.telegram.org/XXXXXXXXXXXXXXXXXXXX/sendMessage?chat_id=-4140173122&text=RESPONSE_NULL get

but not this one:
=> webquery https://script.google.com/macros/s/AKfycbzkxhfOjPI5m8_GNL-uC7kuwZUfXx1ZbsC8OOdnVpDkFYTfJWg-bPjOQ2p-YoAV7EEiQA/exec?2_Spalte=TEST get

tasmota restarts immediately.

It works in the old version, even in the browser via a URL.

Maybe the error is on my end (e.g., bin creation). but I don't believe it anymore

Thanks for your help!

Answered by 2000ede

May 9, 2025

too little stack

View full answer

sfromis · 2025-04-04T12:00:54Z

sfromis
Apr 4, 2025

Testing the last command on different ESP32 devices (with varying variants of ESP32), on current Tasmota 14.5.0.3, I'm not seeing any failures. However, reverting one of them to release version 14.5.0 did produce a crash.
"RestartReason":{"Exception":1,"Reason":"Syscall","EPC":"4008ca74","EXCVADDR":"00000000","CallChain":["4008ca71".....

Appears to be fixed with latest dev builds.

1 reply

2000ede Apr 4, 2025
Author

Thanks for helping., @sfromis

I've now installed version 14.5.0.3. (ESP32 S3)
Unfortunately, the error still occurs for me.

2000ede · 2025-04-10T22:25:41Z

2000ede
Apr 10, 2025
Author

Unfortunately, the error is still present in 14.5.0.3

0 replies

scargill · 2025-05-04T16:47:47Z

scargill
May 4, 2025

Well, I could not get anything out on webquery in my rule on 14.5.0 and I noted there was an issue so I upated to 14.6.0.1 and still nothing...

Rule1 ON system#boot do power1 1 ENDON ON Time#Minute|2 DO WebQuery http://google.com/ GET ENDON ON WebQuery#Data=Done DO TimedPower 15000,off ENDON ON event#manualcycle DO TimedPower1 15000,off ENDON

The rule is turned on and in the log I see the query says Done....

18:42:00.248 RUL: TIME#MINUTE|2 performs 'WebQuery http://google.com/ GET'
18:42:00.482 MQT: stat/localbytes-pm-spain/RESULT = {"WebQuery":"Done"}

But my timedpower1 isn't flicking the output off. I have a light attached so I can watch while testing.... I can manually tun the timedpower command in the console and that works perfectly.

18:46:38.265 CMD: TimedPower1 15000,off
18:46:38.273 MQT: stat/localbytes-pm-spain/RESULT = {"POWER":"OFF"}
18:46:38.275 MQT: stat/localbytes-pm-spain/POWER = OFF
18:46:53.283 MQT: stat/localbytes-pm-spain/RESULT = {"POWER":"ON"}
18:46:53.286 MQT: stat/localbytes-pm-spain/POWER = ON

Any ideas anyone? My device is a LOCALBYTES smartplug which runs Tasmota. @sfromis you any ideas? I was convinced it was pe but AI Perplexity told me othere were having issues...

4 replies

scargill May 4, 2025

Oh hang on - just tried another sonoff-like Tuya device with v13.3.04 Tasmota and tht doesn't trigger - but if I send an mqtt payload "manualcycle" the light works - and it's not the TimedPower command as, for a test, I tried power1 0...
It seems to be this section that is failing for whatever reason..

ON WebQuery#Data=Done DO TimedPower 15000,off ENDON

I've even removed =Done so that it should trigger the TimedPower if it sees any response - but no.

sfromis May 4, 2025

An important note from the Tasmota docs about rules:

When the JSON payload response is produced by a command executed by a rule i.e. on time=120 do status 8 endon, the StatusSNS#Data trigger will not fire unless the command is wrapped in backlog i.e. on time=120 do backlog status 8 endon

That's why.

scargill May 4, 2025

Ok, Did I put teh backlog in the wrong place? Here's the full rule with backlog added..

Rule1 ON system#boot do power1 1 ENDON ON Time#Minute|2 DO WebQuery http://google.com/ GET ENDON ON WebQuery#Data=Done DO Backlog TimedPower 15000,off ENDON ON event#manualcycle DO TimedPower1 15000,off ENDON

scargill May 4, 2025

Right - backlog now in the webquery - mine works - thank you as always.

2000ede · 2025-05-04T18:58:58Z

2000ede
May 4, 2025
Author

I use scripts. My web queries work perfectly under 13.x.
They don't work under 14.5.x. They don't work under 14.5.0.3 either.

After that, I stopped trying and migrated back to 13.x.

0 replies

2000ede · 2025-05-06T15:44:06Z

2000ede
May 6, 2025
Author

What I also noticed is that under 13.x it works, and it arrives cleanly at the receiver. However, in the console, it says:
17:38:06.398 RSL: RESULT = {"WebQuery":"Connect failed"}

in the 14.x versions it crashes and when restarting automatically it writes "done" - but nothing arrives at the receiver

1 reply

sfromis May 6, 2025

Do you have a test case to reproduce the issue you have? Hard to debug anything without having that.

2000ede · 2025-05-06T16:04:33Z

2000ede
May 6, 2025
Author

@sfromis test case:

UPDATE: IT DOESNT WORK: GOOGLE now blocked it. sorry.

URL: (Also works via browser as URL input)

https://script.google.com/macros/s/AKfycbxq63V9FEV9aUpU7MyTPDbA3XG-qejyDisMk-zxQYUDpKMIr2kRJTQI025af8MwTZzp/exec?1_Spalte=100

Tasmota:
=>WebQuery https://script.google.com/macros/s/AKfycbxq63V9FEV9aUpU7MyTPDbA3XG-qejyDisMk-zxQYUDpKMIr2kRJTQI025af8MwTZzp/exec?1_Spalte=100 GET

Recipient - this is where it comes/should arrive (Page must be updated manually):
https://docs.google.com/spreadsheets/d/e/2PACX-1vSuhijc4dm2PeB8ptef25qCHPPhXFJWINUGWaH42_hKXkdE3XHK1KdTjNw9ly2Y3ijRfpCa0YPnLxxO/pubhtml?gid=0&single=true

10 replies

2000ede May 6, 2025
Author

Oh, Google seems to have blocked it. A friend was still able to run it perfectly at 6 p.m. It's enough to make me tear my hair out. I've been using it for over two years, but I've never had this happen.

update: 401 disabled_client: Die App ist blockiert.

sfromis May 6, 2025

Details of "my user override and platform override" is what you changed.

2000ede May 6, 2025
Author

override.zip

I use these files 1:1 for version 13 as well as 14. Everything works with them, only in 14 not the webquery.

If I'm the only one having the problem, or if it's me, I now use a workaround (global variables and I send with version 13. It works).
It's taken me an infinite amount of time so far. Unfortunately, I'm not a profi.

Noschvie May 7, 2025

Maybe you can take the time to find out the commit that is causing the crash.

scargill May 7, 2025

Maybe you can take the time to find out the commit that is causing the crash.

Mine is working just fine on several versions once sfromis pointed out I needed to wrap the query in a "backlog".

2000ede · 2025-05-08T18:09:17Z

2000ede
May 8, 2025
Author

only for @s-hadinger and @sfromis :

(if too many people use it, Google will block it again)

Command e.g. directly in the browser:
https://script.google.com/macros/s/AKfycbziFCdRacwxA3VwQ3tg-cHl5mej5IwFdWZtgFeyez2KRyLkrfci5WaiMkIFHVwnWmOr/exec?1_Spalte=TEST

Tasmota: Works fine under script 13.x, not under script 14.x:
=>webquery https://script.google.com/macros/s/AKfycbziFCdRacwxA3VwQ3tg-cHl5mej5IwFdWZtgFeyez2KRyLkrfci5WaiMkIFHVwnWmOr/exec?1_Spalte=TEST GET

Check page / recipient (must be updated manually via browser)
https://docs.google.com/spreadsheets/d/e/2PACX-1vS8uuZVPvsxwN8Y2Kf1Di7sIN0xp1ciBMJb-vCzVwKuVOvPbv5HcRnCV5tjZqYfBet_crEH_MM4SUr-/pubhtml?gid=0&single=true

6 replies

s-hadinger May 9, 2025
Collaborator

I also tried on the standard ESP32S2 build, it works fine:

webquery https://script.google.com/macros/s/AKfycbziFCdRacwxA3VwQ3tg-cHl5mej5IwFdWZtgFeyez2KRyLkrfci5WaiMkIFHVwnWmOr/exec?1_Spalte=TEST2 GET
16:00:00.281 CMD: webquery https://script.google.com/macros/s/AKfycbziFCdRacwxA3VwQ3tg-cHl5mej5IwFdWZtgFeyez2KRyLkrfci5WaiMkIFHVwnWmOr/exec?1_Spalte=TEST2 GET
16:00:00.293 SRC: Serial
16:00:00.294 CMD: Grp 0, Cmd 'WEBQUERY', Idx 1, Len 131, Pld -99, Data 'https://script.google.com/macros/s/AKfycbziFCdRacwxA3VwQ3tg-cHl5mej5IwFdWZtgFeyez2KRyLkrfci5WaiMkIFHVwnWmOr/exec?1_Spalte=TEST2 GET'
16:00:02.478 RSL: RESULT = {"WebQuery":"Done"}

2000ede May 9, 2025
Author

Thank you very much for your efforts!

I can assure you that I've tried it over 50 times, always creating new files. It was always the same picture. (13.x works, 14.x doesn't. Everything else remained the same.)

I also asked a friend, and he had exactly the same result.

I've now ordered other ESP models and will replicate it there. I'll report back.

2000ede May 9, 2025
Author

Here again:

created a new bin under 13.x
installed
works

created a new bin under 14.x

installed
aborts, restarts, says it has executed "done." Nothing arrives

console:

00:00:00.001 HDW: ESP32-D0WD-V3 v3.1 
00:00:00.145 UFS: FlashFS mounted with 156 kB free
00:00:00.165 CFG: Loaded from File, Count 1081
00:00:00.174 QPC: Count 1
00:00:00.175 CFG: CR 384/699, Busy 0
00:00:00.179 SPI: Bus1 using GPIO18(CLK), GPIO23(MOSI) and GPIO19(MISO)
00:00:00.179 SCR: ufilesystem found
00:00:00.209 SCR: nv=40, tv=0, vns=208, vmem=14824, smem=49000, gmem=540, pmem=0, tmem=64572
00:00:00.215 TFS: File 'mcp23x.dat' not found
00:00:00.216 MCP: Invalid template
00:00:00.217 TYA: Active=0
00:00:00.220 ROT: Mode 1
00:00:00.228 BRY: GC from 3692 to 3492 bytes, objects freed 4/20 (in 0 ms) - slots from 36/61 to 28/61
00:00:00.312 CFG: No '*.autoconf' file found
00:00:00.316 BRY: GC from 5795 to 3796 bytes, objects freed 8/35 (in 1 ms) - slots from 68/91 to 35/91
00:00:00.317 BRY: Berry initialized, RAM used 3796 bytes
00:00:00.336 BRY: No 'preinit.be'
00:00:00.338 SRC: Restart
00:00:00.342 Project tasmota -  Version 14.6.0.1(efGM9924)-3_1_3(2025-05-09T19:25:07)
00:00:00.413 v1 loaded
00:00:00.477 v2 loaded
00:00:00.542 v3 loaded
00:00:00.547 ETH: No ETH MDC and ETH MDIO GPIO defined
00:00:00.623 DSB: Sensors found 5
00:00:00.624 no meter section found!
00:00:00.718 BRY: No 'autoexec.be'
**00:00:00.831 SCR: performs "WebQuery https://script.google.com/macros/s/AKfycbwVwr55am1tiG7KpOfm4okXQhsimLQ8cqkxaLERB5_ZptqlIAJbQfE3LiPSv6JrCPAU8g/exec?1_Spalte=01IMPx&2_Spalte=xxxx GET"**
00:00:00.842 SRC: Rule
**00:00:00.843 CMD: Grp 0, Cmd 'WEBQUERY', Idx 1, Len 148, Pld -99, Data 'https://script.google.com/macros/s/AKfycbwVwr55am1tiG7KpOfm4okXQhsimLQ8cqkxaLERB5_ZptqlIAJbQfE3LiPSv6JrCPAU8g/exec?1_Spalte=01IMPx&2_Spalte=xxxx GET'
00:00:00.866 RSL: RESULT = {"WebQuery":"Done"}**
00:00:00.870 Durchlauf beendet
00:00:00.001 WIF: Checking connection...
00:00:00.002 WIF: Attempting connection...
00:00:02.000 WIF: Connecting to AP1 Fichtenstr9 Channel 1 BSSId E8:DF:70:6E:3A:4B in mode HT40 as tasmota-2C99D8-6616...
00:00:04.138 WIF: Checking connection...
00:00:04.138 WIF: Attempting connection...
00:00:04.747 WIF: IPv4 192.168.178.135, mask 255.255.255.0, gateway 192.168.178.1
00:00:05.140 WIF: Checking connection...
00:00:05.141 WIF: Connected
00:00:05.435 HTP: Web server active on tasmota-2C99D8-6616 with IP address 192.168.178.135
00:00:05.828 NTP: Sync time...
00:00:05.854 RTC: UTC 2025-05-09T17:49:38Z, DST 2025-03-30T02:00:00, STD 2025-10-26T03:00:00
19:49:38.000 RTC: Synced by NTP
19:49:38.028 WIF: IPv6 Local fe80::a2a3:b3ff:fe2c:99d8%st1
19:49:38.410 RSL: INFO1 = {"Info1":{"Module":"Wetterstation","Version":"14.6.0.1(efGM9924)","FallbackTopic":"cmnd/DVES_2C99D8_fb/","GroupTopic":"cmnd/tasmotas/"}}
19:49:38.423 RSL: INFO2 = {"Info2":{"WebServerMode":"Admin","Hostname":"tasmota-2C99D8-6616","IPAddress":"192.168.178.135","IP6Global":"2a02:8206:a665:7c00:a2a3:b3ff:fe2c:99d8","IP6Local":"fe80::a2a3:b3ff:fe2c:99d8%st1"}}
19:49:38.440 RSL: INFO3 = {"Info3":{"RestartReason":{"Exception":1,"Reason":"Syscall","EPC":"4016b341","EXCVADDR":"00000000","CallChain":["4016b33e","4016be29","4016c69d","4016e664","4016ec52","4016ecfa","4016fd5a","4016fee9","40187a36","401907e9","40185ffb","40170b06","40170f0f","40174ca0","401752f5","401758f8","4019f619","400eb367","400d44ce","400f0591","401464ed","400d92d9","400d951a","401051e3","401904d0","40106a7b","401464ed","400df254","400da76e","4018224a"]},"BootCount":840}}
19:49:38.486 TFS: File 'autoexec.bat' not found
19:49:39.831 QPC: Reset
19:49:40.028 WIF: IPv6 Global 2a02:8206:a665:7c00:a2a3:b3ff:fe2c:99d8
19:49:41.007 v1 saved
19:49:41.161 v2 saved
19:49:41.663 v3 saved
19:49:41.665 Durchlauf beendet
19:49:41.897 APP: Boot Count 840
19:49:43.009 CFG: Saved, Count 1082, Bytes 4096
19:49:43.013 BRY: GC from 5976 to 4576 bytes, objects freed 19/60 (in 1 ms) - slots from 92/106 to 63/106
19:49:43.015 RSL: STATE = {"Time":"2025-05-09T19:49:43","Uptime":"0T00:00:11","UptimeSec":11,"Heap":87,"SleepMode":"Dynamic","Sleep":50,"LoadAvg":57,"MqttCount":0,"Berry":{"HeapUsed":4,"Objects":60},"Wifi":{"AP":1,"SSId":"Fichtenstr9","BSSId":"E8:DF:70:6E:3A:4B","Channel":1,"Mode":"HT40","RSSI":52,"Signal":-74,"LinkCount":1,"Downtime":"0T00:00:05"}}
19:49:43.115 RSL: SENSOR = {"Time":"2025-05-09T19:49:43","DS18B20_0E4404":{"Id":"0E24610E4404","Temperature":15.8},"DS18B20_496EBC":{"Id":"0E2461496EBC","Temperature":16.0},"DS18B20_0E2AFC":{"Id":"0E24610E2AFC","Temperature":15.6},"DS18B20_0C7515":{"Id":"0E24610C7515","Temperature":15.7},"DS18B20_94ED2F":{"Id":"00000094ED2F","Temperature":15.4},"TempUnit":"C"}

s-hadinger May 9, 2025
Collaborator

You are doing the WebQuery before the Wifi is connected...

It shouldn't say "Done" but it can certainly not work

2000ede May 9, 2025
Author

Yes, I understand. But the problem was there before. It crashes at that point (at least I assume it's exactly that point), and when it boots up, it tries again.
If it then gets back to that point in the code, it crashes again, and it starts all over again.

(If I just remove the web query, it no longer crashes under 14.x.
It never crashes under 13.x.)

2000ede · 2025-05-09T20:02:58Z

2000ede
May 9, 2025
Author

@s-hadinger @sfromis

A very valued and helpful man also invested time and was able to find the error causing it.

The web query only failed in 14.x.

Cause: too little stack. After increasing the stack in the bin, it now works.

As a beginner, I lacked the knowledge to derive something like this.

I would like to thank you for your search and support!

1 reply

2000ede May 9, 2025
Author

too little stack

Answer selected by 2000ede

14.5.0: a specific webquery no longer works #23245

Uh oh!

Replies: 8 comments · 23 replies

Uh oh!

Uh oh!

Uh oh!

2000ede Apr 4, 2025 Author

Uh oh!

2000ede Apr 10, 2025 Author

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

2000ede May 4, 2025 Author

Uh oh!

2000ede May 6, 2025 Author

Uh oh!

Uh oh!

Uh oh!

Uh oh!

2000ede May 6, 2025 Author

Uh oh!

Uh oh!

2000ede May 6, 2025 Author

Uh oh!

Uh oh!

2000ede May 6, 2025 Author

Uh oh!

Uh oh!

Uh oh!

Uh oh!

2000ede May 8, 2025 Author

Uh oh!

s-hadinger May 9, 2025 Collaborator

Uh oh!

2000ede May 9, 2025 Author

Uh oh!

Uh oh!

2000ede May 9, 2025 Author

Uh oh!

s-hadinger May 9, 2025 Collaborator

Uh oh!

Uh oh!

2000ede May 9, 2025 Author

Uh oh!

2000ede May 9, 2025 Author

Uh oh!

2000ede May 9, 2025 Author

Replies: 8 comments 23 replies

2000ede Apr 4, 2025
Author

2000ede
Apr 10, 2025
Author

2000ede
May 4, 2025
Author

2000ede
May 6, 2025
Author

2000ede
May 6, 2025
Author

2000ede May 6, 2025
Author

2000ede May 6, 2025
Author

2000ede
May 8, 2025
Author

s-hadinger May 9, 2025
Collaborator

2000ede May 9, 2025
Author

2000ede May 9, 2025
Author

s-hadinger May 9, 2025
Collaborator

2000ede May 9, 2025
Author

2000ede
May 9, 2025
Author

2000ede May 9, 2025
Author