Calling Stored Procedure Error

Wappler General How To
#1

Hi,

When I call the following MySQL stored Procedure using a Custom Query I get the following error;

Cannot read properties of undefined (reading ‘name’)

wappler error-2
wappler error-21920×1041 108 KB

Can anyone explain why?

Many thanks
Charles

#2

There appears to be a typo in the query syntax. P:1 instead of :P1

#3

Hi,
Thank you for looking. I have corrected the typo but still get the same error.

#4

Have you defined a direct database connection in the Database Manager?

#5

Yes I have.

wappler error-3
wappler error-3915×891 67.5 KB

#6

I mean in the Database Manager panel

#7

Yes, there is a direction in there.!

wappler error-4
wappler error-41281×816 66.6 KB

#8

And when you test it - is it also fine and do you see the tables there?

#9

Yes, all seems to be working fine.

wappler error-5
wappler error-51281×816 71.5 KB

#10

If you need me to ask the developer of the SP anything please let me know.

#11
#12

Hi Teodor,

Are you able to shed any light as to what the error, (reading ‘name’) is referring to?

#13

One more thing i see here is the syntax - it should be without the quotes around :P1

#14

Hi Teodor,
I have tried it with and without as per another post I found and I still get the same error.

In phpMyAdmin the SP executes OK and returns the expected values so I don’t understand what the (reading ‘name’) is referring to.

wappler error-6
wappler error-61019×518 33.6 KB

#15

Maybe @patrick can help here.

#16

Does the SP work when you have no parameter?

#17

Unfortunately not and that id number works within phpMyAdmin and dbForge query mySQL builder

wappler error-7
wappler error-71920×1038 114 KB

#18

Do you see an error in the Wappler console? Please start Wappler with logging enabled and send us the log file.

#19

Could you also try to turn the experimental options on in Wapplers Global Seetings / System.

Then try again.

#20

Have uploaded bug report