Results 1 to 7 of 7

Thread: MySQL error 1065

  1. #1
    SaintAnthony is offline Sugar Community Member
    Join Date
    Sep 2011
    Posts
    24

    Default MySQL error 1065

    At the bottom of every page where the EULA is posted, instead it shows "Database failure. Please refer to sugarcrm.log for details."

    I referred to the log, and this is what it says:

    Tue Oct 18 18:51:52 2011 [21754][8a2c2fd3-dff3-cbfd-7018-4e931b1b28db][FATAL] MySQL error 1065: Query was empty

    Does anyone know where I might be able to start tracking down this error?

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

    Default Re: MySQL error 1065

    What are you doing that leads to this error?
    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
    ashdwi1's Avatar
    ashdwi1 is offline Sugar Community Member
    Join Date
    May 2008
    Location
    Noida
    Posts
    198

    Default Re: MySQL error 1065

    are you doing any logic hooks , that seems to trying to call an empty sql query.
    if so look at logic_hooks.php and their relavant calls to custom locations.
    thanks
    Almost available at skype or gtalk at ashdwi1.

    SugarForge Project:
    http://www.sugarforge.org/projects/gmapdirection
    Email: ashdwi1@gmail.com
    Mob: +919005468298

    Hire us at Odesk at
    https://www.odesk.com/users/~~b9eff8ff219fd705

    Hire Us at Elance at:
    http://ashdwi1.elance.com

  4. #4
    SaintAnthony is offline Sugar Community Member
    Join Date
    Sep 2011
    Posts
    24

    Default Re: MySQL error 1065

    It's coming up on the bottom of my detail view for my tasks list. My tasks list does have custom fields, but they were created through studio, and aren't anything special. I did make some custom modifications to the search field to have it automatically add the wildcard symbols to the search, and also made any input text show up red in the detail view, but I have not added any custom logic hooks.

  5. #5
    kuske's Avatar
    kuske is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Germany
    Posts
    2,597

    Default Re: MySQL error 1065

    Did you delete any custom fields?
    If yes check custom/Extension/Modules/.../Vardefs for any files belonging to delted custom fields.
    Harald Kuske
    Pre-Sales Engineer Central Europe

    SUGARCRM Deutschland GmbH
    Erika-Mann-Str. 53, 80636 Munich, Germany
    Email: hkuske@sugarcrm.com
    Home: http://www.sugarcrm.com


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

    Default Re: MySQL error 1065

    Are those customizations also being applied to the Tasks module?

    Do you have any other custom modules installed?

    What happens if you temporarily rename the custom/modules/Tasks folder and then try to duplicate the error?
    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)
    ______________________________________________

  7. #7
    SaintAnthony is offline Sugar Community Member
    Join Date
    Sep 2011
    Posts
    24

    Default Re: MySQL error 1065

    Thanks for the responses gentlemen,

    I tried changing the name on the folder, and it displayed the standard Task form.

    Checked the Vardefs folder and also the detailview php file and there are no reference to fields which do not exist.

    One tidbit of information I forgot to provide is that I did export the tasks module from another Sugar install and import it over the tasks module on this install, I don't know if that is going to make a difference to you though.

    Thanks again!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 2009-02-06, 09:15 AM
  2. Replies: 2
    Last Post: 2008-10-20, 06:01 AM
  3. Query Failed: ::MySQL error 1065: Query was empty
    By darcy.rippon in forum Developer Help
    Replies: 3
    Last Post: 2008-10-10, 07:24 AM
  4. Replies: 2
    Last Post: 2006-10-20, 12:00 AM
  5. Query Failed: ::MySQL error 1065: Query was empty
    By suruchi in forum Developer Help
    Replies: 1
    Last Post: 2006-01-21, 03:16 PM

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
  •