Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

[Improved] SQL Views

Information about updates, news, Code Library
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

[Improved] SQL Views

Unread post by admin »

nuBuilder's database contains 3 SQL views.
  • zzzzsys_object_list
  • zzzzsys_report_data
  • zzzzsys_run_list
In the past, some users have reported that the views disappeared after an update.
When you log in as an administrator, the system now checks for their existence and creates them if they are not there.

Another problem was that, especially with shared hosting, you do not always have the rights to create SQL views. In this case, static tables are created instead of views, which are updated each time the administrator logs in or hits refresh.
Post Reply