Warning: mysql_fetch_assoc() AND Warning: mysql_data_seek():

[gdetemple]

Hi,

When i log into SugarCRM, i see the following errors on my Homepage. I need to get rid of these errors ASAP. Please help. I cant find anything anywhere in any posts or the Wiki docs. I am running Centos/PHP5/MySql5

Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource in /hermes/web03/b467/as.gdetemple1/public_html/sugar/include/database/PearDatabase.php on line 491

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hermes/web03/b467/as.gdetemple1/public_html/sugar/include/database/PearDatabase.php on line 495

Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource in /hermes/web03/b467/as.gdetemple1/public_html/sugar/include/database/PearDatabase.php on line 491

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hermes/web03/b467/as.gdetemple1/public_html/sugar/include/database/PearDatabase.php on line 495

Glenn Detemple
-------
DeTemple Virtual Properties
http://detdev.com
glenn.detemple@gmail.com

[Angel]

What's the exact version of PHP?

[EDIT]
BTW, are you using any double byte characters with Sugar?

[gdetemple]

Hi,

Thank you for taking the time to help me out.

I am using PHP Version 5.2.2 and i am not using any double byte Characters.

It is weird that no one else has had this problem.

Thanks again.

[Angel]

Does this happen for all users?

Have you tried resetting the Home page to the defaults?

Any custom modules/customizations to the system?

[gdetemple]

Hi,

Thank you for your help.

1. Yes, this happens to all users.
2. Im exactly sure how to restore the home page to defaults...BUT i did click the Restore Button on the System Settings page and this did NOT resolve the problem. I also used the "rebuild function" and it did nothing when i repaired everything.
3. No there is not Any custom modules/customizations to the system? This issue happened as soon as i logged in for the first time.

From what i can see, it is not effecting the functionality of SugarCRM...So, is there anyway i can just tell the script NOT to display the warnings? i am still a little new to SugarCRM and PHP/Mysql.

Thank you very much for your time.

Glenn Detemple

[gdetemple]

Any progress with this issue?

[Angel]

You should be able to suppress them by modifying your PHP.INI.

Change the following setting from:

display_errors = On

to

display_errors = Off

Make sure to restart your web service after saving your PHP.INI changes.

As a side note, while this should hide the error, I wouldn't advice it as a longterm solution. There is no reason as to why you should be getting the errors in the first place and may be indicative of other (perhaps even more serious) problems. This is kind of like treating the symptom versus the disease.