2. PHPRunner General questions
  3. [SOLVED] Build Error
This topic is locked
[SOLVED]

Build Error

 		2/5/2022 10:30:06 AM
PHPRunner General questions
S
 SwissCharles author

Hi folks
[Using PHPR 10.7 - Windows 10 Pro 64 Bit - Apache 2.4 via XAMPP 3.2 - PostgreSQL 13 on localhost]

Now that my dashboard shows as landing page, this build error remains.
Here's what I get:

img alt

And that's what I did to get there ;-):

  • On the database backend I deleted all tables related to dynamic permissions.
  • In PHPRunner I did a 'sync database'.
  • In PHPRunner I deactivated the dynamic permissions by de-selecting 'Enable database authentication' .
  • I then built the project anew. Et voilà the long missed landing page showed my dashboard!
  • I then went back into PHPRunner and re-selected 'Enable database authentication' and created a 'New Table' as tbl_user:

img alt

  • I then did 'Add new user' and added a user called 'Admin' .
  • Under 'Permissions' I kept the option 'Dynamic Permissions'
    • Under 'change table settings' I selected the option 'use existing tables' and added the 'table prefix' to repairshack.usr_ .


  • Again under 'Permissions' I selected 'Add admin user from database' I selected the option 'Add existing user to admin group' where I selected the user 'Admin' as created above.
  • I then re-built the project again and received the build error as shown above.

With a utility (PostgreSQL Maestro) I then peeked into the db and checked on those tables as created by PHPRunner.
Here's what I got:

img alt

img alt

img alt

(What I do find a bit strange is the minus-sign in front of GroupID..?. )

And that's the user table:

img alt

Again, thanks for each and every input on this!

Charles
S
 		SwissCharles author 2/5/2022

Well, if I get this error message right, it originates when parsing file : C:\Program Files\PHPRunner10.7\source\ug_rights.php
In case, (8) means the line number, here are the first 10 lines ( guess I can't add the file as an attachment here..):

<?php
@ini_set("display_errors","1");
@ini_set("display_startup_errors","1");

require_once("include/dbcommon.php");
header("Expires: Thu, 01 Jan 1970 00:00:01 GMT");

require_once("include/##@TABLE.strShortTableName s##_variables.php"); <--- this being line 8...

if( !Security::processAdminPageSecurity( false ) )
return;

HTH

Charles
K
 		kohle 2/5/2022

This helped for me:

turn the Dynamic Permissions off and then back on.
That will fix the problem.
On the Security screen press Permssions, then switch to Static permissions and press OK.
Then open the Permissions dialog again, switch to Dynamic and press OK.

rg
J.
S
 		SwissCharles author 2/5/2022

Hey Kohle J.

Ha - I will go check this right away.
I did turn off dynamic permissions, but did not switch to static permissions...

Stay tuned and thanks for pointing this out!

Charles
S
 		SwissCharles author 2/5/2022

Hey again Kohle J.

Yes, this did the trick - I can now build the project just fine - thanks for the tipp!

But: When I now launch the project in the browser, I only get a blank screen e.g. no login screen!
What else could that be in addition to the issue solved?

Thanks for any further tip!

Charles