The Arrow to see the next contacts listed under an account doesn't work

šŸ’¬ General Discussion
1

Hello,
Since weā€™ve restored our CRM database, it seems that the arrow to move from one page to the other in the Contacts listed under a company doesnā€™t work (either the one to go to the next page or the one to go to the last page).
Is there something we should do?
Thanks,
Kind regards,
Regine

2

Hi RĆ©gine,

Have tried resetting permissions and run a quick repair and rebuild?

3

In addition you should also check your logs to see if there are any errors.

4

Ok, iā€™ll do that and let you know, thanks Amariussi! :slight_smile:

5

Hello,
Iā€™ve tried running a diagnostic, but it gets stuck at 15%, a quick repair, it didnā€™t change anything, I checked the log file but I canā€™t see any error related to this:

This is an extract of the log file:
Fri Jul 10 09:52:50 2015 [12610][824f01af-3ea3-8e59-5775-53ba45733d30][FATAL] Query Failed: Select id, email_address from email_addresses where id in (): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ā€˜)ā€™ at line 1
Fri Jul 10 09:52:50 2015 [12610][824f01af-3ea3-8e59-5775-53ba45733d30][FATAL] project_resource for projects_contacts_resources failed to load

Fri Jul 10 09:52:50 2015 [12610][824f01af-3ea3-8e59-5775-53ba45733d30][FATAL] project_resource for projects_contacts_resources failed to load

Fri Jul 10 09:52:50 2015 [12610][824f01af-3ea3-8e59-5775-53ba45733d30][FATAL] error loading relationship project_resource
Fri Jul 10 09:52:50 2015 [12610][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone Europe/Berlin. Please set date.timezone=ā€œEurope/Berlinā€ in php.ini!

What is strange is that in the test version (which was a restored version of the same database at an earlier time), we donā€™t have that problemā€¦

We are planning on updating the system to the latest version (we have the Version 7.2.1, Sugar Version 6.5.20 (Build 1001), and weā€™ve noticed that there was a Version 7.2.2 available now, but as the version of the test database is the same as the live one, the problem shouldnā€™t be linked to the versionā€¦

Do you have any other idea?
Thanks!
Regine

6

Hello,
We have updated Sugar CRM, but the problem remains. I also noticed that we cannot sort the information in the different columns.
On the other hand, when we are in the lists of Contacts or Accounts (not in sub-categories), the arrows function and we can sort the information in the different columns.
Iā€™ve asked another user to check, but he has the same problem.
Could you please help?
Thanks,
Kind regards,
Regine

7

Hello,
This is really a serious bug for usā€¦
Could you let me know what we should do to solve the problem?
Thanks,
Kind regards,
Regine