2. PHPRunner General questions
  3. New Tables & Menu Items Not Publishing
This topic is locked

New Tables & Menu Items Not Publishing

 		4/20/2025 6:36:45 AM
PHPRunner General questions
W
 WisTex author

I have an existing project that was previosly a PHPRunner 10 Enterprise project that has been loaded (converted) to PHPRunner 11 Enterprise.

  1. I added two new tables in phpMyAdmin, and the synced the database with PHPRunner 11.
  2. I checked the boxes next to the new tables on the tables screen so they can be used in PHPRunner.
  3. I made sure the relevant fields are checked in the Quuery Designer (they were already checked).
  4. I use the designer to create the forms.
  5. I add links in the menu on the style screen.
  6. I save the project.
  7. I build the project and view in the browser as localhost.
  8. I upload the project to a server and view in a browser.

The result: none of this appears in the browser.

  • The menu items I added aren't there.
  • If I try to go directly to the expected URLs, it redirects to the menu.php page.

It is as if what I added doesn't exist.

Weird quirk. If I add fields to other existing forms I created, I can do so, and I can even query the tables I added to create drop downs. So PHPRunner knows the tables are there and can access its data. It just refuses to display the new form based on the new table.

Did I miss a step? Why would it not show up?
W
 		wpl 4/20/2025

Hi WisTex,

what about security settings? Could it be that there are simply no rights on the new tables?
Just my two cents.
W
 		WisTex author 4/22/2025

I checked the advanced security settings, and it is set to "Users can see and edit other users data."

Although this table does not have a UserID field because the records are not associated with particular users.

I compared it with similar tables that show up, and the settings appear to be the same. The only difference is that the tables that work were created in PHPRunner 10, and the tables that do not work were created in PHPRunner 11.

W
 		wpl 4/23/2025

I was thinking of permissions on tables in security settings. Did you check these?
J
 		JCoffren 4/26/2025

If you set up advanced security the admin section under the login will be active and you need to make it visible.

I use ASP Runner but I did run into this by accident where the after login / landing page had been modified so the Admin section menu was disabled and I could not access the admin to enable it.

there is also a default admin set up and in the app you can add an existing user to admin to enable your user to see the admin section.

You can look at the database under dbo. usergroups and membership to see what users are in the admin group value will be -1