Page 1 of 3

Unable to create a launch form

Posted: Sat Jan 22, 2022 4:45 pm
by Duski
I'm a newbie in nuBuilder 4.5 and I have a problem with creation a launch form.

1. I created a launch form Code="start" Description="Start form", Tab="Main"
StartForm.png
2. On "Main" Tab I created a button ID="launch_books_public", Type="Run", Label="Books", Cloneable="No", Align="Center", Validation="None", Access="Editable"
Button.png
3. on Details of this button, in Tab="Run" I tried to select the apropriate form to open, but the lookup list of forms is empty and I'm not able to finish creating the launch form.
Detail.png
Run.png
List.png
But there are 68 forms in the database, 9 of them created by me and working. The apropriate form is "frm_books_public"
Forms.png
What I'm doing uncorrect ?

Thanx in advance
Duski

Re: Unable to create a launch form

Posted: Sat Jan 22, 2022 5:09 pm
by kev1n
Hi,

Check in your db if the VIEW zzzzsys_run_list exists.
If it doesn't, create it. (The other 2 views might be missing as well)

viewtopic.php?p=24616#p24616

Re: Unable to create a launch form

Posted: Sat Jan 22, 2022 6:04 pm
by Duski
Thanx for your answer Kevin. "zzzzsys_run_list" exists, but is empty :-(

Re: Unable to create a launch form

Posted: Sat Jan 22, 2022 6:08 pm
by kev1n
Is it a view or table?

Re: Unable to create a launch form

Posted: Sat Jan 22, 2022 6:09 pm
by Duski
Table

Re: Unable to create a launch form

Posted: Sat Jan 22, 2022 6:11 pm
by Duski
Information schema VIEWS is empty.

Re: Unable to create a launch form

Posted: Sat Jan 22, 2022 6:13 pm
by kev1n
Drop these 3 tables
`zzzzsys_report_data`
`zzzzsys_run_list`
`zzzzsys_object_list`

And run the sql from the link above to create the views

Re: Unable to create a launch form

Posted: Sat Jan 22, 2022 6:24 pm
by Duski
3 tables dropped, but when creating view "zzzzsys_object_list", server response:
#1142 - CREATE VIEW command denied to user 'duski1641832389'@'klokanek.stable.cz' for table 'zzzzsys_object_list'

Re: Unable to create a launch form

Posted: Sat Jan 22, 2022 6:29 pm
by kev1n
That means your user does not have the permission to create views.

Re: Unable to create a launch form

Posted: Sat Jan 22, 2022 6:31 pm
by Duski
What now ?