i broke project tasks error 1054

[excess1973]

Ok, I was adding new fiedls to modify the layout of the project task list view.
I was trying to find the one that identifies and links to the project that task is under.
So I added from sugar bin the one that said TAG MAIN PROJECT TASK ID and I guess PARENT ID NAME or something along these lines, and it didn't work.

Then I removed all the fields that I thought were wrong and saved it, and it saying:

Error retrieving ProjectTask list: Query Failed:SELECT users.user_name assigned_user_name, project.name parent_name, project.assigned_user_id parent_name_owner, project_task.* , project_task_cstm.* FROM project_task LEFT JOIN users ON project_task.assigned_user_id=users.id LEFT JOIN project ON project_task.parent_id=project.id LEFT JOIN project_task_cstm ON project_task.id = project_task_cstm.id_c where project_task.deleted=0 AND project.deleted=0 ORDER BY project_task.parent_name asc LIMIT 0,40::MySQL error 1054: Unknown column 'project_task.parent_name' in 'order clause'

How can I reset the entire view to the original view that I once had??? any ideas
(Oh right, and I didn't do any backups This is great.

Thanks for any help!

[excess1973]

i went to phpadmin and added a field called parent_name in the project task table. I have no idea what it does, but it seems like it might be working now. if not i'll report back in.

[excess1973]

ok, now I'm back to the original problem. What is the name of the project itself in the project tasks list view page.
I want to get it back to the default like it was when it said:
the name of the project task | the name of the project its about \ etc.

any ideas?

[staibha]

To restore the Listview, just ftp the original ListView.html into /modules/ProjectTask. Download the appropriate sugar version and extract the original file from there.

[excess1973]

i did reset that listview and the php too. I think it's the php file that fixed it.
but when I go to sort on the project name, (parent name) I get the error again.

I then deleted the field that I added to mysql (see above post) and so far, all is well.


Thanks for your help!