2. PHPRunner General questions
  3. Delete Selected not working
This topic is locked

Delete Selected not working

 		8/28/2007 6:11:28 PM
PHPRunner General questions
C
 Crimson author

I m pretty new to PHPR so please do not kill me if this has been asked. I searched but could not find anything. Does anyone know what may be causing the Delete Selected option on the List page to not work right? I select a record by clicking the check box, then I click on the Delete Selected link. The confirmation window pops up, I click OK. The page refreshes but the record I was trying to delete remains. The record is linked to a file and I checked the one box that prompts to delete the file when the record is deleted. But nothing.
I have checked to make sure the account logged in has permission to delete the file. I have confirmed that the files folder on the server is set to 777. And I have double checked to make sure the mySQL account I am using has permissions to delete records. Any ideas anyone?
Alexey admin 8/29/2007

Hi,
this is not a permissions-related problem.

Looks like you selected wrong key fields for your table.

Proceed to the Choose pages tab in PHPRunner and choose proper keys.
If this doesn't help publish your project on Demo account and send a link to it to support@xlinesoft.com

The Publish on Demo Account button is on the last tab in PHPRunner.
C
 		Crimson author 8/29/2007

OK, I created the demo account and sent the info to the support email. But I do not see what I can do differently. I have an ID field that is set to auto increment so it is a unique id. And I have that field set to be the key field. Maybe I do not understand that page as well as I thought, but there is no documentation to let users know what the best field is to select as a key field. The help only mentions Access but still does not properly explain what to select or why that should be selected.
C
 		Crimson author 8/29/2007

Here is something new I discovered. The PHPR site I am trying to setup has a place to allow file uploads. Essentially, it if for posting PDFs. If the record I add has an attachment of any type, I can not delete the record. If I add a record without an attachment, I can delete the record just fine. So it seems to have something to do with attaching a file to the record or there is some error in the code to delete the file as well as the record. I am going to uncheck the box that is supposed to delete the file as well as the record to see if that has any effect on the bug.