MySQL error 1062 relating to Case Module.

[rbaird]

Hello,

I have recently deployed Version 5.5.1RC onto a Windows Server 2003 R2 using the WIndows MySQL faststack install.

The current version through the admin tool is Version 5.5.1RC (Build 1141).

I have been trying to setup the inbound email to so that I can work on getting case module to auto generate case numbers and emails for our support desk.

After following all the steps in the manual, I manually created 2 cases in the cases module to test outbound email notification which worked fine.

I deleted the 2 test cases on purpose, since the deletion, I have been trying to get the inbound email to case auto generation working, I need to setup the cron job on the windows server of which I am still learning how this is done.

Since the deletion of the old 2 test cases, I have been trying to manually create more test cases, I end up getting the following:

(indication in my work email

Administrator has assigned a Case to Richard Baird.

Subject: TEST EMAIL
Priority: High
Status: New
Description: test

You may review this Case at:
<http://10.2.3.47/sugarcrm/index.php?module=Cases&action=DetailView&record=b1 5e45b7-37ba-4a7c-a332-4b85e1e1841c>

I have tried this a few times and get the following MySQL error for each case I try to manually create.

Query Failed:INSERT into cases set id='544a745b-8d26-a5bb-f8a3-4b85ee9baed5', name='I need some help here', date_entered='2010-02-25 03:30:26', date_modified='2010-02-25 03:30:26', modified_user_id='90ac8902-d655-a4fc-abf8-4b1483d75000', created_by='90ac8902-d655-a4fc-abf8-4b1483d75000', description='Test', deleted='0', assigned_user_id='90ac8902-d655-a4fc-abf8-4b1483d75000', type='Administration', status='New', priority='P1', resolution='Test', account_id='5829551c-517b-d53f-8942-4b0f5b860165'::MySQL error 1062: Duplicate entry '0' for key 2

From reading a lot of posts I believe that there maybe a duplication in the Cases table with regards to the auto increment section??

I have ensured that the case macro retains the [CASE:%1] as per the note in the web gui.

I need to provide my IT department instructions to rectify this issue, can annoy help as to how I can fix this MySQL error?

Kind Regards,

Richard Baird
Service Delivery Manager
rbaird@vexpress.com.au

[Angel]

Unless I've misinterpreted your comments, it sounds like you don't have anything in the Cases module that you actually need to keep.

Assuming my interpretation is correct, try truncating the cases table to correct the problem.

You can truncate it by running the following command via a MySQL admin utilty:

TRUNCATE TABLE cases

[monofia]

Unless I've misinterpreted your comments, it sounds like you don't have anything in the Cases module that you actually need to keep.

Assuming my interpretation is correct, try truncating the cases table to correct the problem.

You can truncate it by running the following command via a MySQL admin utilty:

TRUNCATE TABLE cases

i have the same problem, i keep trying ths, it does not work, is there any solution?

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Query Failed:INSERT into cases set id='6ec1ed71-9173-62c0-f062-4bd5d98b17b1', name='dhlkjs dsd s', date_entered='2010-04-26 18:21:15', date_modified='2010-04-26 18:21:15', modified_user_id='4a8de105-8a0d-32a0-3490-4bd56148415b', created_by='4a8de105-8a0d-32a0-3490-4bd56148415b', description='sdjf dfdsfkjdf', deleted='0', assigned_user_id='150c6a5f-d01d-6522-9537-4bd56355d0ba', type='Administration', status='New', priority='P1', resolution='dsjkfh skdfh', account_id='9cd88208-af19-1620-1d2a-4bd56e009cc9'::MySQL error 1062: Duplicate entry '0' for key 2
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[Angel]

I don't know of any circumstance where this type of error would come up for erroneous reasons, although I do find it odd that it is trying to use 0 as the case number as it usually starts at 1. Did you reset the numbering at some point?

[monofia]

I don't know of any circumstance where this type of error would come up for erroneous reasons, although I do find it odd that it is trying to use 0 as the case number as it usually starts at 1. Did you reset the numbering at some point?

No i did not reset numbering, we just installed it new, and this is the frist case we try to open.