Page 1 of 1

How to delete old script from database?

Posted: Sunday 05 May 2019 22:48
by astrapowerrr
Hi all.

I have this error in my log:

Code: Select all

2019-05-02 16:00:54.099 Error: Error opening url: http://192.168.1.xxx:8080/json.htm?type=command&param=thermostatstate&idx=5&state=1
This is from my old toon Lua script as writen in the wiki.
As I reinstalled my complete pi I never reinstalled my scripts.
I believe these came with importing the old database.
But there is no script in the lua or the script folder. And also from settings-events. There is no script present.

How do I delete this script?
Where is it hidden? In the database?

I hope someone can help me.
Greets marco


Verzonden vanaf mijn iPhone met Tapatalk

Re: How to delete old script from database?

Posted: Monday 06 May 2019 7:52
by waaren
astrapowerrr wrote: Sunday 05 May 2019 22:48

Code: Select all

2019-05-02 16:00:54.099 Error: Error opening url: http://192.168.1.xxx:8080/json.htm?
Scripts are either stored in the database (tables EventMaster end EventRules) or directly on the filesystem (ls -lR <domoticz dir>/scripts)
But in this case the command could also be generated by a Level Action of a Selector-switch.

Re: How to delete old script from database?

Posted: Monday 06 May 2019 10:40
by astrapowerrr
2 questions?

1 if its triggerd bij script then it must be in database because folders are empty.
if i want to look in the database i use sqllite?
can i open this on my windows laptop and try with an old backup .db extension?


2 and if its triggered by a Level Action of a Selector-switch how can i find out what made the trigger?
because in my opinion i dont have any triggers set for my thermostaat.

edit: tried to look in the database.. but nothing there what got my attention.
so started digging what triggered my url.. had nothing to do with script..
i had the url triggered by a device :oops: :oops: :oops:
thanks waaren for pointing me in the right direction!!


greets marco