4.5.1h SugarCRM
9.3 SUSE LINUX Pro
4.1.10a MySQL
5.0.3 PHP5
2.0.53 Apache
I have not added any custom modules.

I am adding to a Target List from the Leads Popup access. I press the [Select] within the Target List page and get the expected Leads Search and Lead List page. When using the Lead List [Next] button it will allow a single page forward but not further. The [End] button if clicked first will go to the end but the [Previous] button will not go backwards.

I do hear a double clicking sound through the speaker confirming the button click. The screen inside the popup windows rewrites but the windows content is the same after clicking on the [Next] or [Previous] buttons.

I've speculated but not found yet the MySQL cursors, data table segment pointers, are advancing but the new segment, the next records are not being displayed. That's theory at this point.

I tried several ways to get at this problem using different starting pages but always came to the same problem.

I also I have seen a MySQL error message which today I have not yet seen again today. The error was displayed in the browser, which actually is a kind of security breach. I went directly to the Leads tab and attempted to view a Lead. The result was...

Error retrieving Lead list: Query Failed:SELECT leads.*,
users.user_name assigned_user_name ,
leads_cstm.* FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id
LEFT JOIN leads_cstm
ON leads.id = leads_cstm.id_c
where (leads.last_name like 'm%') AND leads.deleted=0
ORDER BY name ASC LIMIT 17,1::MySQL error 1054: Unknown column 'name' in 'order clause'