2. PHPRunner General questions
  3. [SOLVED]  Missing 'active' field in 'login' table
This topic is locked
[SOLVED]

 Missing 'active' field in 'login' table

 		4/24/2008 13:12:20
PHPRunner General questions
C
 cglaeser author

I created a jobs database using the jobs template, and the "active" field was not created in the "login" table. I added the "active" field manually, and that seems to have solved the problem. Question: Are all tables and fields always generated for each template, or is it possible that certain tables and/or fields are conditionally generated based on the options used in the template? What are the possible reasons that the "active" field was not created as part of the "login" table?
Best,

Christopher
C
 		cglaeser author 4/24/2008

I found part of the answer. The active field is apparently affected by the login dialog. Not yet sure when this field gets added to the login table or why my code and tables is out of sync, but I'm getting closer.
Best,

Christopher
J
 		Jane 4/25/2008

Christopher,
I suppose you've used Send actiovation link option on the User login settings dialog on the Security tab. In this case active field is added to the database on this dialog directly.
C
 		cglaeser author 4/25/2008

I suppose you've used Send actiovation link option on the User login settings dialog on the Security tab. In this case active field is added to the database on this dialog directly.


Yes, that is correct. The template initially creates the database without the active field, and then the active field is added later. I'm guessing the build and upload steps do not automatically resync the database, but something I did later apparently did resync the database, which added the active field. I skimmed through the tutorials and documentation, and I need to go back and read the documentation to get a better understanding of the inner workings. I think PHPRunner is going to be pretty easy to use after a few more test projects.
Best,

Christopher