Problem following User Guide example
Posted: Fri Nov 30, 2018 6:38 am
Hello folks,
Just working through your excellent User Guide and hit a problem on page 33, trying to fill in the Run lookup field in the Run Tab. The lookup table was empty. On investigation with phpMyAdmin, I found the View zzzzsys_run_list was inaccessible, and got the error:
#1356 - View 'ndb.zzzzsys_run_list' references
invalid table(s) or column(s) or function(s) or
definer/invoker of view lack rights to use them.
I found the view was owned by user 'slipstream' which does not exist in my db. I created the user slipstream in mysql and granted it permissions over the db in phpmyadmin, and problem solved. I can now fill in the Run field correctly.
Did I miss something when initially setting up nuBuilder? (I am using a nuBuilder download from 19th Nov 2018)
Cheers,
MikeTee
Just working through your excellent User Guide and hit a problem on page 33, trying to fill in the Run lookup field in the Run Tab. The lookup table was empty. On investigation with phpMyAdmin, I found the View zzzzsys_run_list was inaccessible, and got the error:
#1356 - View 'ndb.zzzzsys_run_list' references
invalid table(s) or column(s) or function(s) or
definer/invoker of view lack rights to use them.
I found the view was owned by user 'slipstream' which does not exist in my db. I created the user slipstream in mysql and granted it permissions over the db in phpmyadmin, and problem solved. I can now fill in the Run field correctly.
Did I miss something when initially setting up nuBuilder? (I am using a nuBuilder download from 19th Nov 2018)
Cheers,
MikeTee