Error on executing shell script via sqlpage.exec

[heejit]

index.sql

set num = COALESCE(sqlpage.cookie('num'), "0");

SELECT
  'cookie' as component,
  'num' as name,
   cast(cast($num as int)+1 as text) as value;

set file_name = concat('FILE~', current_date, '~', $num, '.png');

select
  'form' as component,
   $file_name as title,
  'Scan' as validate,
   sqlpage.exec('run_naps2', $file_name) ) as action;


select
  'card' as component,
  'Last Scan File' as title;

select
  $file_name as top_image;

Error ->

Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

Error in function call sqlpage.exec('run_naps2', $file_name).
Expected sqlpage.exec(program_name, args)

Backtrace

Unable to execute command: run_naps2 FILE~2025-01-12~31.png

Exec format error (os error 8)

I have tested the script and it is working properly in the terminal.

[lovasoa]

exec format error means that your "run_naps2" file is not a valid executable.

Can you give more information about your configuration? Where are SQLPage and the run_naps2 executable? Can you upload the executable here?

[heejit]

found the issue i am running fish shell and i forgot to add shebang at the start of the script now it is working.

#!/bin/sh
flatpak run com.naps2.Naps2 console \
--bitdepth bw \
--dpi 200 \
--noprofile \
--driver escl \
--device "Brother DCP-T520W" \
--output $1

[heejit]

when I am running it via script it works but if i run like this is not and no error ->

 sqlpage.exec('/usr/bin/flatpak', 'run', 'com.naps2.Naps2', 'console',
   '--bitdepth bw',
   '--dpi 200',
   '--noprofile',
   '--driver escl',
   '--device "Brother DCP-T520W"',
   '--output ', $file_name)  as link;

[heejit]

One more issue with this whenever we load the page it start executing the command I want it to execute only on click of button.