Undefined index: LBL_NO_ACTION

[mptaszek]

I'm using Sugar 6.0.2 (upgraded from 5.5 AFAIR)

When entering the Quick Repair tab (index.php?module=Administration&action=repair), I was getting an empty file as a response. After changing the php.ini logs verbosity to include notice errors, server replies with:

( ! ) Notice: Undefined index: LBL_NO_ACTION in /(...)/sugarcrm/include/MVC/Controller/SugarController.php on line 395
Call Stack
#	Time	Memory	Function	Location
1	0.0000	54292	{main}( )	../index.php:0
2	0.0166	2496220	SugarApplication->execute( )	../index.php:43
3	0.0312	3865688	SugarController->execute( )	../SugarApplication.php:84
4	0.0312	3865688	SugarController->process( )	../SugarController.php:270
5	0.0314	3866428	SugarController->handleActionMaps( )	../SugarController.php:321
6	0.0314	3866428	SugarController->no_action( )	../SugarController.php:814

There are no errors in sugarcrm.log (even with debug error level set).

Moreover, the same error pops up when trying to e.g. edit campaigns index.php?module=EmailMan&action=campaignconfig

Finally, when trying to reach campaigns list (index.php?module=ProspectLists&action=index&retur n_module=ProspectLists&return_action=index), I'm getting:

Error retrieving ProspectList list: Query Failed: SELECT prospect_lists.* FROM prospect_lists where (prospect_lists.list_type like 'default%') AND prospect_lists.deleted=0 ORDER BY assigned_user_name asc LIMIT 0,30::MySQL error 1054: Unknown column 'assigned_user_name' in 'order clause'

How can I fix this problem?

[sts]

I think something with your update went wrong.

1st problem:
Have a look into include/language/en_us.lang.php
In my (6.0.1) installation there is an entry like this:
'LBL_NO_ACTION' => 'There is no action by that name.',
Including this into en_us.lang.php should help.

2nd problem:
Data table 'prospect_lists' does not contain a column named 'assigned_user_name'. Use 'assigned_user_id' in the SQL statement instead.

[mptaszek]

1. I checked the include language file and the entry is there:

'LBL_NO_ACTION'                         => 'There is no action by that name.',

2. I grepped through the code and it looks like assigned_user_name is used pretty intensively almost everywhere (220 occurrences in modules/*/*php

If I would like to change SQL statement - where is the best place to do so?

[sts]

concerning the sql statement:

In my installation there are several usages of a variable named 'assigned_user_name' too, but there is no database table element with the same name. The error messages indicates that the sql statement tries to access this element nevertheless.
I've searched for such a statement in my installation, but didn't find one. I think this should be somewhere in modules/ProspectList/* files. In ProspectList.php I found the following:

$query = "SELECT ";
$query .= "users.user_name as assigned_user_name, ";
$query .= "prospect_lists.*";

if($custom_join){
$query .= $custom_join['select'];
}
$query .= " FROM prospect_lists ";

$query .= "LEFT JOIN users
ON prospect_lists.assigned_user_id=users.id ";

A similar machanism to access the assigned_user_name would be neccessary in your case I think.