2. PHPRunner General questions
  3. PHP errors after DB changes
This topic is locked

PHP errors after DB changes

 		12/23/2012 20:47:41
PHPRunner General questions
S
 seedavidwork author

On two different occasions I've made changes to my project design (including changes to the DB) which have broken the project after update. I believe that in both occasions the dbconnection.my.mysqli.php or some related file was not updated after the project change.
First occasion I changed the user table from a table called 'estimator' to 'user'. After making the change I looked for every occasion where 'estimator' was called in the application and changed it to the corresponding field in 'user'. All of the query's look good in the application. I can build the project and remove the data from 'estimator' and the program runs fine, but as soon as I remove the table I get a php error that referencing a query in dbconnection.my.mysqli.php which references the original table (which should be completely gone from the program).
Second occasion I set up user can only see own data and set a field in each table which is 'table_own'. Later I decided I did not want this security and changed it back to everyone sees everything. I removed the fields 'table_own' but when I run the application I get a php error that refers to a query in dbconnection.my.mysqli.php that is selecting the removed 'table_own' field.
Is there something I can do to force to the application to recognize removed tables or fields so that they are not selected in queries. I've tried saving, syncing the database, and doing full rebuilds to no avail.
P
 		procheck 12/23/2012

Hi David,
Check to make sure that your table is not in the Datasource tables section.

A couple of things you could try. I've had similar problems to you. Go to the output section and click on the "Full Build" checkbox. I find that this works much better than the Full Rebuild link.
The other is to clear out your output folder completely and do Build.
Hope this helps
Al
S
 		seedavidwork author 12/23/2012



Hi David,
Check to make sure that your table is not in the Datasource tables section.

A couple of things you could try. I've had similar problems to you. Go to the output section and click on the "Full Build" checkbox. I find that this works much better than the Full Rebuild link.
The other is to clear out your output folder completely and do Build.
Hope this helps
Al


I checked the Full Build box but I don't know that it's helped. I just had a table not sorting how I wanted it (looks fine in the SQL results but not in the live page) so I removed it from the project, rebuilt and re-uploaded the project (the table menu is gone). Then I re added the table, rebuilt the query, and then rebuilt and re-uploaded the whole project ( I even erased it from the server completely), but the menu that shows up in PHP runner is not being uploaded to the server. The table that I removed and re-added is not available in the live application. Any thoughts would be helpful as I would prefer not to start again from scratch.
Sergey Kornilov admin 12/25/2012

As a rule of thumb - perform a full project and upload all files to the web server. This solves most of issues somilar to this one.
Another thing - if you use User Group Permissions make sure that table in question has been assigned access rights. It won't be visible in generated application if permissions are not assinged.
If more help is required post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.