Results 1 to 7 of 7

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

  1. #1
    gdetemple is offline Member
    Join Date
    Sep 2009
    Posts
    6

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

    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

  2. #2
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Warning: mysql_fetch_assoc() AND Warning: mysql_data_seek():

    What's the exact version of PHP?

    [EDIT]
    BTW, are you using any double byte characters with Sugar?
    Last edited by Angel; 2009-10-02 at 12:46 AM.
    Regards,

    Angel Magaņa
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

  3. #3
    gdetemple is offline Member
    Join Date
    Sep 2009
    Posts
    6

    Default Re: Warning: mysql_fetch_assoc() AND Warning: mysql_data_seek():

    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.

  4. #4
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Warning: mysql_fetch_assoc() AND Warning: mysql_data_seek():

    Does this happen for all users?

    Have you tried resetting the Home page to the defaults?

    Any custom modules/customizations to the system?
    Regards,

    Angel Magaņa
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

  5. #5
    gdetemple is offline Member
    Join Date
    Sep 2009
    Posts
    6

    Default Re: Warning: mysql_fetch_assoc() AND Warning: mysql_data_seek():

    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

  6. #6
    gdetemple is offline Member
    Join Date
    Sep 2009
    Posts
    6

    Default Re: Warning: mysql_fetch_assoc() AND Warning: mysql_data_seek():

    Any progress with this issue?

  7. #7
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Warning: mysql_fetch_assoc() AND Warning: mysql_data_seek():

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

    Change the following setting from:

    Code:
    display_errors = On
    to

    Code:
    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.
    Regards,

    Angel Magaņa
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Warning msg
    By yomex2play in forum Installation and Upgrade Help
    Replies: 0
    Last Post: 2009-06-06, 02:54 PM
  2. php warning
    By gesuina in forum Help
    Replies: 0
    Last Post: 2006-04-24, 01:19 PM
  3. warning
    By jiji in forum General Discussion
    Replies: 0
    Last Post: 2006-03-08, 08:38 AM
  4. Replies: 1
    Last Post: 2005-09-29, 09:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •