Problem in list view pagination in opportunity module

[swaroops1]

Dear All,

I am hereby posting this problem and found no solved thread previously.

It would be of great help if you join your hands in solving this issue which are discussed repeatedly.

Sugar Version - CE 6
OS - Linux CentOS

In the opportunity module there are 225 records which are shown 20 at a time by default in sugar.

When I click next it simply displays a blank screen depicting displaying 21-40. I tried by increasing the count as well but after doing it even stopped showing first 20 records also.

I checked the roles and everything was working fine until I found

SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = '44a90be4-0fa4-55ed-41bc-4c73b8d0d062' AND visible = 1) Query Failed:SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = '44a90be4-0fa4-55ed-41bc-4c73b8d0d062' AND visible = 1) LIMIT 0,10::MySQL error 1030: Got error 134 from storage engine

I repaired the table which eliminated this message from the application but the blank screen problem still remains.

Please do help me in finding a solution if there were any previous such cases.


Thank you in Advance..

Cheers,
Swaroop S.

[swaroops1]

Hi,

I am not able to understand is this the problem with the database or with the application. Kindly let me know a way to correct this..

As it has been a major problem in navigation among tons of records.

Thank you in advance..

Swaroop S.

[swaroops1]

Hi,

I am not able to understand, is there nobody over there who could reply back whether it is a bug or a know issue in sugarCRM.

Awaiting a reply