SQLHelper: Error script not found

[boggiz]

Hello,
I am a French newbee on Domoticz and I have a minor problem that I don't understand.
APIR-2150 is a movie sensor with "Action off= nothing" and "Action on= script://CmdEclairageExt.lua" a lua program stocked in DataBase (domoticz.db)
This script switch On a lamp at night when a movie sensor is detected


log
1) 2019-03-07 11:32:25.429 (RFXtrx433XL Somfy) Lighting 2 (APIR-2150)
2) 2019-03-07 11:32:25.430 Status: LUA: Script Started ...DB
3) 2019-03-07 11:32:25.430 Status: LUA: Script Finished ...DB
4) 2019-03-07 11:32:25.427 Error: SQLHelper: Error script not found '/usr/local/domoticz/var/scripts/CmdEclairageExt.lua'
5) 2019-03-07 11:32:26.087 (RFXtrx433XL Somfy) Lighting 2 (APIR-2150)
6) 2019-03-07 11:32:26.088 Status: LUA: Script Started ...DB
7) 2019-03-07 11:32:26.088 Status: LUA: Script Finished ...DB
8) 2019-03-07 11:32:26.085 Error: SQLHelper: Error script not found '/usr/local/domoticz/var/scripts/CmdEclairageExt.lua'
9) 2019-03-07 11:33:03.395 Status: Notification sent (Email) [/size][/size]

No scripts are stored in domoticz directory.
At line 4 and 8 Why a SQL error is send before the script started ?
I suppose it is a request for the script CmdEclairageExt.lua in the DB.
Why it says I can't find it when he executes it a few hundredths of a second later ?

thank you for your answers

[waaren]

Why it says I can't find it when he executes it a few hundredths of a second later ?

domoticz Lua and dzVents scripts in domoticz are not to be used in the On or Off section as script:// types.
It will not work as they need domoticz data that is not available to OS level Lua scripts.
The script:// in the "Action on" section of the device refer to an OS script. The error message tells you that that script does not exist in the directory domoticz is looking for it.
It looks like the script is created and saved using the internal event editor and triggered by the event system. If that's the case, you don't have to refer to it in the On section.
What do you see / experience when you remove the script from the On section ?

[boggiz]

It looks like the script is created and saved using the internal event editor and triggered by the event system. If that's the case, you don't have to refer to it in the On section.
What do you see / experience when you remove the script from the On section ?

Thank's for your response.
I have deleted "Action on=empty" and it has worked without an error message! but if there are several scripts, how the system does it to assign them to different events without error ?

[waaren]

It looks like the script is created and saved using the internal event editor and triggered by the event system. If that's the case, you don't have to refer to it in the On section.
What do you see / experience when you remove the script from the On section ?

Thank's for your response.
I have deleted "Action on=empty" and it has worked without an error message! but if there are several scripts, how the system does it to assign them to different events without error ?

The way that's handled depends on the script type. Is it a standard Lua script or a dzVents Lua script.
DzVents identify when a script needs to be activated based on the "on = " section.
In standard Lua it can be based on the name of the script or inside the code . https://www.domoticz.com/wiki/LUA_commands#Devices
I can only comment on the way it is handled in your script if you include name and code in your post.

[boggiz]

Thank you for your answer.

Here is my basic code:
---------------------------------------
-- External Lighting Control
---------------------------------------
commandArray = {}
print ('Script Started...Database')
if (devicechanged['APIR-2150'] =='On' and other devices['NIGHT'] =='On') then
commandArray['Ext Lighting']='On'
end
print ('Script Finished...Database')
return commandArray

If I understood correctly, the whole Blockly and LUA code stored in the database is executed as soon as an event is sent by Domoticz.
For Dzevents and all other languages, only the event programmed in "Action on" or "off" is processed not by the database but by the OS.