SQL OTRS Problem

Moderator: crythias

Locked
matiasmarquez
Znuny newbie
Posts: 5
Joined: 04 Sep 2012, 10:02
Znuny Version: 2.4.7
Real Name: Matias
Company: Donauer solartechnik Vertriebs GmbH

SQL OTRS Problem

Post by matiasmarquez »

Hi all,

We have problems with our OTRS system, better to say with SQL.
I'm not a SQL profi , it would be good if I have a simple solution!

if someone wants to create a new ticket, you get the error message: "Duplicate entry '22172 'for key 1, SQL:' INSERT INTO article"

can someone help me?

Thank you,

Matias
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: SQL OTRS Problem

Post by jojo »

your database seems to be broken. Did you have a crash due to a full disk?
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
matiasmarquez
Znuny newbie
Posts: 5
Joined: 04 Sep 2012, 10:02
Znuny Version: 2.4.7
Real Name: Matias
Company: Donauer solartechnik Vertriebs GmbH

Re: SQL OTRS Problem

Post by matiasmarquez »

No, the hard drive has 70 gb free
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: SQL OTRS Problem

Post by jojo »

try a repair of the mysql tables
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked