Custom database query always the same error

GoJoe · March 25, 2021, 7:25pm

Hi,
When I try to build a custom database query and try to execute it, I always get an “request failed”. And in the logs I find:

— 550 dmxConnect/api/__exec_query.php: No such file or directory

I’m not sure what that is supposed to mean. Was a temporary file creation not successful?

Single Datebase Querys using the Query Builder work and show up on my website successfully.

Thank you

Teodor · March 25, 2021, 7:30pm

Can you share some screenshots of how’s the custom query set up in Wappler UI? Also are you able to run it from within Wappler?

GoJoe · March 25, 2021, 7:42pm

Sure thing:

It’s a API Action step like all of my other Actions.

I want to do a simple JOIN of two tables (standard SQL Query, so it seems to me) - but I’m not that much of an expert:

When I hit the play button I get two overlapping errors:

grafik

And here is the glory from the logfile:

Start delete for dmxConnect/api/__exec_query.php

set color:use-color yes
set cmd:interactive yes
set file:charset utf-8
set xfer:clobber on
set ftp:timezone
set cmd:show-status yes
set cmd:set-term-status yes
set ftp:list-options -a
set cmd:fail-exit yes
set cmd:time-style “%Y-%m-%d %H:%M:%S”
set ftp:ssl-allow no
set ssl:verify-certificate no
set net:max-retries 3
set net:timeout 20
set net:reconnect-interval-base 5
set net:reconnect-interval-multiplier 1
open -u ftp************ ftp://w************
---- Resolving host address…
---- 1 address found: ***********
cd ftp://ftp************
---- Connecting to wp************ port 21
<— 220 ::ffff:5************ FTP server ready
—> FEAT
<— 211-Features:
<— AUTH TLS
<— CCC
<— CLNT
<— EPRT
<— EPSV
<— HOST
<— LANG en-US;fr-FR;ja-JP;ko-KR;zh-CN;es-ES;it-IT;ru-RU.UTF-8;ru-RU
<— MDTM
<— MFF modify;UNIX.group;UNIX.mode;
<— MFMT
<— MLST modify*;perm*;size*;type*;unique*;UNIX.group*;UNIX.groupname*;UNIX.mode*;UNIX.owner*;UNIX.ownername*;
<— PBSZ
<— PROT
<— REST STREAM
<— SIZE
<— SSCN
<— TVFS
<— UTF8
<— 211 End
—> CLNT lftp/4.8.4
<— 200 OK
—> LANG
<— 200 Using default language en_US.UTF-8
—> OPTS UTF8 ON
<— 200 UTF8 set to on
—> HOST w************
<— 504 w************ Unknown hostname provided
—> USER ftp************
<— 331 Password required for ftp************
—> PASS ************
<— 230 User ftp************ logged in
—> OPTS MLST modify;perm;size;type;UNIX.group;UNIX.mode;UNIX.owner
<— 200 MLST OPTS modify;perm;size;type;UNIX.group;UNIX.mode;
—> PWD
<— 257 “/” is the current directory
---- CWD path to be sent is `/www/crass-ai/app’
—> CWD /www/crass-ai/app
<— 250 CWD command successful
cd ok, cwd=/www/crass-ai/app
rm dmxConnect/api/__exec_query.php
—> DELE dmxConnect/api/__exec_query.php
<— 550 dmxConnect/api/__exec_query.php: No such file or directory
rm: Access failed: 550 dmxConnect/api/__exec_query.php: No such file or directory
—> QUIT
<— 221 Goodbye.
---- Closing control socket

Teodor · March 25, 2021, 7:44pm

Do you have any steps defined under Globals? In Server Connect panel?

GoJoe · March 25, 2021, 7:49pm

Yes, one. But that was more from playing around. Haven’t deleted it yet:

Deleted it now. Behaviour didn’t change

Teodor · March 25, 2021, 7:50pm

That’s strange. Maybe @patrick can check what’s going wrong here.

George · March 25, 2021, 7:53pm

Seems to me like your ftp is not defined properly in the project target settings.

What do you have there and did the test went ok?

George · March 25, 2021, 7:55pm

Why do you have your site in a subfolder?

GoJoe · March 25, 2021, 7:57pm

See Screenshots, and yep, test went through just fine.

And thanks for helping out - appriciate it.

GoJoe · March 25, 2021, 8:01pm

I planned to setup a structure which might be more flexible, as I have a protected ressource: https://www.crass.ai/databaseapi/ which provides a REST API for my database, so some external partners can access it.

I, probably, could move it to a subfolder of the actual website and have the index files on the “upper” level, if that helps.