Results 1 to 2 of 2

Thread: MySQL error 1059: Identifier name is too long..

  1. #1
    dsuvankar is offline Sugar Community Member
    Join Date
    Sep 2008

    Default MySQL error 1059: Identifier name is too long..


    I create a relationship between 2 custom modules, but after that instance giving blank screen. In log I have found

    Error creating table: empac_employee_profile_empac_employee_insurance_en rollement_1_c Query Failed: CREATE TABLE empac_employee_profile_empac_employee_insurance_en rollement_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,empac_empl7342profile_ida varchar(36) NULL ,empac_empl889cllement_idb varchar(36) NULL , PRIMARY KEY (id), KEY empac_employee_profile_empac_employee_insurance_en rollement_1_alt (empac_empl7342profile_ida, empac_empl889cllement_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1059: Identifier name 'empac_employee_profile_empac_employee_insurance_e nrollement_1_alt' is too long

    Try to change all custom directories like


    Still having same issue. Any idea..I am not able to login and rebuild as well.


  2. #2
    ashdwi1's Avatar
    ashdwi1 is offline Sugar Community Member
    Join Date
    May 2008

    Default Re: MySQL error 1059: Identifier name is too long..

    delete your relationship and shorten name of your modules , always good to have short name of your modules.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 2013-03-12, 01:32 AM
  2. Replies: 3
    Last Post: 2012-07-11, 10:48 AM
  3. Replies: 1
    Last Post: 2009-11-16, 05:29 AM
  4. how long to pick up PhP, MySQL and Sugar
    By brianwg07sugar in forum Help
    Replies: 6
    Last Post: 2009-02-13, 12:58 PM
  5. Patch 5.1.0b error: multi part identifier cannot be bound
    By weeksandy in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2008-11-10, 09:44 PM


Posting Permissions

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