New procedures not added to zzzzsys_run_list

[Henk_2a]

Hello all,
I have several applications with nubuilder, and a few weeks ago I started a new one.
This time my procedures do not appear in the run_list and when I look in the database it shows that new procedures are not added to the view zzzzsys_run_list.
This is new to me, I can't find any suggestions in this forum, any idea how to solve this?
Thanks for your help

[kev1n]

Do you get an error message when you add a new procedure? Also check the output in the developer console (F12)

[Henk_2a]

No errors, I can run the new procedure by the button "Run Procedure" in the main form without problems.
But I cannot run the procedure by an selfmade button since the name of the procedure does not appear in the listbox.

run proc.jpg

[kev1n]

Could you run a select on the database and post the output?

Code: Select all

SELECT * FROM `zzzzsys_php` WHERE `sph_code` = 'nuuser_BS'  --- replace with your procedure code

It should look like this:

2020-02-24_151505.png

[Henk_2a]

run proc.jpg

[kev1n]

And please also an output of this query:

Code: Select all

SELECT * FROM zzzzsys_run_list WHERE code = 'trefwoord_rpt'

[Henk_2a]

Here it is

run proc.jpg

[kev1n]

Can you paste the SQL of the view zzzzsys_run_list ?

edit_view.png

Mine looks like this:

Code: Select all

select `nubuilder4`.`zzzzsys_form`.`zzzzsys_form_id` AS `id`,'Form' AS `run`,`nubuilder4`.`zzzzsys_form`.`sfo_code` AS `code`,`nubuilder4`.`zzzzsys_form`.`sfo_description` AS `description` from `nubuilder4`.`zzzzsys_form` union select `nubuilder4`.`zzzzsys_report`.`zzzzsys_report_id` AS `id`,'Report' AS `run`,`nubuilder4`.`zzzzsys_report`.`sre_code` AS `code`,`nubuilder4`.`zzzzsys_report`.`sre_description` AS `description` from `nubuilder4`.`zzzzsys_report` union select `nubuilder4`.`zzzzsys_php`.`zzzzsys_php_id` AS `id`,'Procedure' AS `run`,`nubuilder4`.`zzzzsys_php`.`sph_code` AS `code`,`nubuilder4`.`zzzzsys_php`.`sph_description` AS `description` from `nubuilder4`.`zzzzsys_php` where `nubuilder4`.`zzzzsys_php`.`sph_system` <> 1 order by `code`

[Henk_2a]

Mine looks very much the same =

run proc.jpg

[kev1n]

Anyway, can you paste it as text? It's easier to compare.