Ticket

Read 5210 times
Hi, >:( >:( >:( >:( >:(

All  my ticket  are be delate from cantova   and now  over i month i wait to get  a answer.
i oppen a news ticket today  but i get  a error from the website

PLEACE AKTIVE MY LICENSE  >:( >:( >:( >:( >:( >:( >:(

SQL Error: Could not execute query in /www/common/cms/components/helpdesk/common/class_SupportTicket.php:138
Query:    INSERT INTO c_helpdesktickets (`subject`,`status`,`resolution`,`priority`,`clientid`,`departmentid`,`lastupdateby`,`ident`,`suggestedids`,`opentime`,`lastupdated`) VALUES ('susspended','new','open','none','2438','1','client','GC8-UXW7-877','33|48|53',NOW(),NOW())
Error:   Duplicate entry '69601' for key 1
Call:   $SQL->insert_query()
SQL Error: Could not execute query in /www/common/cms/components/helpdesk/common/class_SupportTicket.php:402
Query:    INSERT INTO c_helpdeskemails (`ticketid`,`fromid`,`author`,`originalmessage`,`textmessage`,`htmlmessage`,`subject`,`internalnote`,`messagetime`) VALUES ('','2438','client','From: \"Martin Boehringer\" <m.boehringer@banglounge.fm>\r\nSubject: susspended\r\nDate: Wed, 11 May 2011 02:06:05 -0700\r\nX-Mailer: MIME Emulation\r\n\r\nHello my licent are now suspended over a month i send a lot aof ticket but a U never get a anwser from your side.\r\n\r\nPleace cancell my order to upgrad I don\'t need it and aktiv my licence key \r\n\r\nThanks \r\n\r\n\r\n\r\nProduct of interest:\r\nCentova Cast\r\n\r\n','Hello my licent are now suspended over a month i send a lot aof ticket but a U never get a anwser from your side.\r\n\r\nPleace cancell my order to upgrad I don\'t need it and aktiv my licence key \r\n\r\nThanks \r\n\r\n\r\n\r\nProduct of interest:\r\nCentova Cast','Hello my licent are now suspended over a month i send a lot aof ticket but a U never get a anwser from your side.<br />\n<br />\nPleace cancell my order to upgrad I don\'t need it and aktiv my licence key <br />\n<br />\nThanks <br />\n<br />\n<br />\n<br />\nProduct of interest:<br />\nCentova Cast<br />\n<br />\n','susspended','0',NOW())
Error:   Table './centovacom/c_helpdeskemails' is marked as crashed and should be repaired
Call:   $SQL->insert_query()
SQL Error: Could not execute query in /www/common/cms/components/helpdesk/common/class_SupportTicket.php:452
Query:    UPDATE c_helpdesktickets SET `lastupdateby`="client",`lastupdated`=NOW()
Error:   Table 'c_helpdesktickets' is marked as crashed and should be repaired
Call:   $SQL->misc_query()

Fatal error: Call to a member function get() on a non-object in /www/common/cms/components/helpdesk/common/class_Client.php on line 171
Same problem here. All tickets are gone (without reply) and i cannot manage to create a new ticket.
Same mysql errors.

Addition: it seems the mysql table has been crashed. When logging in too the client area, you see error message on some tables who has been crashed.

Can you take a look at that Steve and answer the tickets too? Thanks