2. PHPRunner General questions
  3. [SOLVED]  New User Registration and
This topic is locked
[SOLVED]

 New User Registration and

 		7/3/2012 7:57:46 AM
PHPRunner General questions
S
 sradforth author

I have been using PHPRunner6.1 connecting directly to my hosted server for a while and now moved it to my own local server running XAMPP on another laptop. Generally worked although I had to manually edit the .phpr file with the new connection host/user/password settings for some reason as the connection items weren't being updated. All was looking good UNTIL trying to build it and got a build error. After a bit of forum searching and trial and error I've narrowed it down to the new user registration part.
When I have the Security->User Login Settings... and tick the 'New User Registration' option on I get a build error and everything stops working (the build aborts half way). If I turn the option off it all works again but lose the ability to create new users.
Here's a snapshot of the errors


I've tried deleting Output folder, restarting, etc... but nothing seems to fix it.

Any help really appreciated as totally stuck.
Admin 7/3/2012

As a first step make sure that you run the latest build of PHPRunner. Then make sure that correct table is selected as a login table. The error message suggests that login table is no longer in the database. Please note that table names are case-sensitive i.e. 'Users' and 'users' are two different tables to PHPRunner.
S
 		sradforth author 7/3/2012



As a first step make sure that you run the latest build of PHPRunner. Then make sure that correct table is selected as a login table. The error message suggests that login table is no longer in the database. Please note that table names are case-sensitive i.e. 'Users' and 'users' are two different tables to PHPRunner.



Thanks for the fast reply. I'm using version 6.1 which I think is the latest. The users table is still there and working as it's being used to login with via the PHP user login system, the problem only appears when I tick the 'New User registration page' and get these build errors.

Is there anything I can do to debug it to narrow the build problem further? Can I safely modify the PHP files in the PHPRunner directory or anything else worth checking?

Thanks again,
Admin 7/3/2012

You need to make sure you have the latest build of PHPRunner 6.1.
If this doesn't help contact support directly sending your database and project directory for investigation.
S
 		sradforth author 7/4/2012



You need to make sure you have the latest build of PHPRunner 6.1.
If this doesn't help contact support directly sending your database and project directory for investigation.


Ahh, ok I see there are multiple 6.1 versions. I read the titlebar and my build was 11708 so downloaded the new Build 12231.

(Wasn't sure where to download it from as there is the download page and the link when purchasing the software. Both seemed to say they were build 12231 but have different filenames?) I used the pw&link for a licensed download just in case it matters. Unfortunately the glitch of 'new registration page' causing a build error remains so I'll open up a support ticket to send in the db to try. I'll post my fix on here should others encounter it later as I think this will be something trivial to fix but just hard to identify <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=66917&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
S
 		sradforth author 7/6/2012

So support found the glitch (Excellent support btw and thank you again if you're reading this!). It was because when I migrated the server from one machine to another I did an SQL export from myphpadmin and reimported it to the other windows PC.

In the process, somehow, that import/export process converted my tables like AgendaItems to agendaitems... the one this was failing on was it was looking for a table called 'Users' yet in the database it was called 'users' which prompted the obfuscated missing table errors to pop up during the build.

Parts seem to be case insensitive while others are very case sensitive. My learning here is do everything in lowercase to avoid this potential issue again.

I'm a full PHPRunner lover again!