Unable to create a launch form Topic is solved

[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

[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

[Duski]

Thanx for your answer Kevin. "zzzzsys_run_list" exists, but is empty

[kev1n]

Is it a view or table?

[Duski]

Table

[Duski]

Information schema VIEWS is empty.

[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

[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'

[kev1n]

That means your user does not have the permission to create views.

[Duski]

What now ?