2. PHPRunner General questions
  3. [SOLVED]  View Link Shows Blank Page & Edit Links to same List
This topic is locked
[SOLVED]

 View Link Shows Blank Page & Edit Links to same List

 		1/6/2010 2:27:56 PM
PHPRunner General questions
U
 UpAllNight author

PHP Runner 5.1 - Win XP SP3 - After adding an additonal table to an existing project, I'm having the following 2 things happen:
When on the list page, I can see the records in the table. If I click on the "View" link, it takes me to the ..view.php?editid1= page but the page is blank. The only source code is:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD>

<META content="text/html; charset=windows-1252" http-equiv=Content-Type></HEAD>

<BODY></BODY></HTML>
Also on the List page, hovering over the Edit link shows the ..edit.php?editid1= link but when I click on the link, it refreshes to the List page.
It's happening in all of the tables in the database / project and only started after adding a new table.
Can anyone suggest what I'm doing wrong? Appreciate any help in advance.

Thanks, David
Sergey Kornilov admin 1/6/2010

David,
make sure you have selected a proper key column on 'Choose pages' screen.
Key column cannot be empty or NULL which seems to be the case.
U
 		UpAllNight author 1/7/2010



David,
make sure you have selected a proper key column on 'Choose pages' screen.
Key column cannot be empty or NULL which seems to be the case.


Thanks for the reply.
That does not appear to be the problem. I have confirmed the ID field is the primary field in each table which it has always been. I have confirmed that each table has the ID field (auto incrementing int) checked as the key column on the Choose pages screen. Confirmed and rebuilt twice. Same exact 2 problems.
Any other ideas?
J
 		Jane 1/7/2010

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
U
 		UpAllNight author 1/7/2010



Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.


I'm not on a support contract??
Sergey Kornilov admin 1/7/2010

This is not a problem.
U
 		UpAllNight author 1/7/2010



This is not a problem.


Thanks. Do you want the tables too?
J
 		Jane 1/8/2010

David,
this error happens because you've added aliases for key fields in the SQL query on the Edit SQL query tab.

Please reset queries, then you can edit labels in the Label Editor on the Miscellaneous tab and rebuild your project.
U
 		UpAllNight author 1/8/2010



David,
this error happens because you've added aliases for key fields in the SQL query on the Edit SQL query tab.

Please reset queries, then you can edit labels in the Label Editor on the Miscellaneous tab and rebuild your project.


Thanks Jane. That was it. You guys are great. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=46788&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />