by CM & Sugar

Need to set up a numbering system to track your records? Define and add a unique ID identifier field to any SugarCRM record. Many options to define any alphanumeric format you need. Start tracking your Quote, Cases, Accounts and any other module today..

Includes a 30 day guarantee
Try it Now

By clicking you consent to be contacted by the developer

#764 - Sequence add on didn't stay the same number when edited.

Closed Bug? created by matoulas Verified Purchase 7 years ago

Hi,

I bought the sequence add on from you guy a month ago. When I create a new Contact in the Contact Module I have a Contact Number field to be auto generated read only field like CN000001 and save. it's working fine, but I did not realize that until when I go back to the same Contact and edit some information the Contact Number field changing from CN000001 to CN000002 by itself. It did not stay the same only happened when I edit the Contact. Please I am looking forward to your help to resolve this issue. Thanks

Regard, Matoula Senethavong

  1. matoulas member avatar

    matoulas Verified Purchase

    7 years ago

    Addition, I also receive an error message when click on Contact edit tab. This error message regarding to the Sequence Module from sugar.log file

    09/04/14 16:14:13 [9044][1][FATAL] Error receiving the max sequence of contacts for field contact_number_c: Query Failed:SELECT MAX( SUBSTRING( contact_number_c, 2 + 1, ( LEN( contact_number_c ) - 2 ) ) ) AS contact_number_c FROM contacts LEFT JOIN contacts_cstm ON contacts_cstm.id_c = contacts.id WHERE contact_number_c IS NOT NULL ORDER BY contact_number_c ::: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid length parameter passed to the LEFT or SUBSTRING function.

  2. matoulas member avatar

    matoulas Verified Purchase

    7 years ago

    This error message originates from line 134 in Sequences.php of the Sequences package.

  3. cm_sugar member avatar

    CM & Sugar Provider Affiliate

    7 years ago

    I will need a session again, because it is a MSSQL issue. It can't handle negative values at the native function. Guess, this is also the reason for your other problem of the changing numbers. You can leave me an E-Mail with the session paramters. However, it is quite late, I can't do it right now.

    • matoulas member avatar

      matoulas Verified Purchase

      7 years ago

      Sound good. Let schedule on Monday September 8, at 10 am Pacific time and we can go to Team viewer to resolve the problem. I will send the session to you on Monday before we connected. Thanks

  4. matoulas member avatar

    matoulas Verified Purchase

    7 years ago

    Here is the TeamViewer ID. I’m ready and awaiting for your connection at 10 am Pacific time. Thanks

    ID: 605 229 116 Password: 4765

    • cm_sugar member avatar

      CM & Sugar Provider Affiliate

      7 years ago

      Problems got resolved. Thanks for your time!

  5. matoulas member avatar

    matoulas Verified Purchase

    7 years ago

    Hi Roger,

    I have a duplicate sequence on my contact number. The sequence should auto-increment from the last number like CN029420 and so on when I initial fill all the contact number. When I start create the new contact the contact number auto-generate this CN000008. Even though this CN000008 is already assign to existing contact. Please can you remote in and take a quick look. I’m available all day. Thanks

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating