Staff CP, Closed tickets error.

[Success]

I get this error in Staff CP, Closed tickets view.

Tickets List (Default View)

Invalid SQL: SELECT t.*, tl.lockdateline, tl.lockstaffid, tp.contents AS preview FROM `swtickets` AS t LEFT JOIN `swticketlocks` AS tl ON (t.ticketid = tl.ticketid) LEFT JOIN `swticketposts` AS tp ON (tp.ticketpostid = t.lastpostid) WHERE t.ticketid IN ('5755','5749','5754','5748','5747','5745','5742', '5739','5732','5731','5722','5721','5719','5695',' 5681','5680','5678','5677','5676','5675') ORDER BY t.lastactivity DESC; (Got error 134 from table handler)

It shows the above error and now I cannot see my closed tickets. How to repair?

[Success]

I tried to do a mysqlcheck.

-bash-2.05b$ mysqlcheck -r -u mysqlusername -p databasename
Enter password:
kayako.swadcampaigns OK
kayako.swadhitlogs OK
kayako.swadsearchqueries OK
kayako.swalertactions OK
kayako.swalertrules OK
kayako.swattachmentchunks OK
kayako.swattachments OK
kayako.swattachmenttypes OK
kayako.swauditlogs OK
kayako.swbreaklines OK
kayako.swcalendarcategories OK
kayako.swcalendardata OK
kayako.swcalendarevents OK
kayako.swcalendarlabels OK
kayako.swcalendarlinks OK
kayako.swcalendarpriorities OK
kayako.swcalendarstatus OK
kayako.swcalendartasks OK
kayako.swcannedcategories OK
kayako.swcannedresponsedata OK
kayako.swcannedresponses OK
kayako.swcatchallrules OK
kayako.swchatchilds
error : The handler for the table doesn't support repair
kayako.swchatdata OK
kayako.swchatobjects OK
kayako.swcommentdata OK
kayako.swcomments OK
kayako.swcontacts OK
kayako.swcountryinfo OK
kayako.swcron OK
kayako.swcronlogs OK
kayako.swcustomfielddeplinks OK
kayako.swcustomfieldgroups OK
kayako.swcustomfieldlinks OK
kayako.swcustomfieldoptions OK
kayako.swcustomfields OK
kayako.swcustomfieldvalues OK
kayako.swdepartments OK
kayako.swdownloadcategories OK
kayako.swdownloaddesc OK
kayako.swdownloaditems OK
kayako.swemailqueues OK
kayako.swescalationrules OK
kayako.swgroupassigns OK
kayako.swkbarticledata OK
kayako.swkbarticlefiles OK
kayako.swkbarticlelinks OK
kayako.swkbarticles OK
kayako.swkbcategories OK
kayako.swlanguagephrases OK
kayako.swlanguages OK
kayako.swmailqueuedata OK
kayako.swmessagedata OK
kayako.swmessagequeue OK
kayako.swmessages OK
kayako.swnews OK
kayako.swnewsdata OK
kayako.swnewssubscribers OK
kayako.swnewsverihash OK
kayako.swparserbans OK
kayako.swparserlogdata OK
kayako.swparserlogs OK
kayako.swparserrules OK
kayako.swpredefinedcategories OK
kayako.swpredefinedreplies OK
kayako.swpredefinedreplydata OK
kayako.swprivatemessagedata OK
kayako.swprivatemessages OK
kayako.swqueuesignatures OK
kayako.swregistry OK
kayako.swruleactions OK
kayako.swrulecriteria OK
kayako.swsessions
error : The handler for the table doesn't support repair
kayako.swsettings OK
kayako.swsettingsfields OK
kayako.swsettingsgroups OK
kayako.swsignatures OK
kayako.swslaplanprioritylink OK
kayako.swslaplans OK
kayako.swslaplanstatuslink OK
kayako.swslaschedules OK
kayako.swstaff OK
kayako.swstaffassigns OK
kayako.swstaffgroup OK
kayako.swstaffgroupsettings OK
kayako.swstaffschedules OK
kayako.swsynclog OK
kayako.swsyncworksguid OK
kayako.swtempfiles OK
kayako.swtemplatecategories OK
kayako.swtemplatedata OK
kayako.swtemplategroups OK
kayako.swtemplates OK
kayako.swtgroupassigns OK
kayako.swticketdrafts OK
kayako.swticketemails OK
kayako.swticketlabellinks OK
kayako.swticketlabels OK
kayako.swticketlocks
error : The handler for the table doesn't support repair
kayako.swticketmergelog OK
kayako.swticketmessageids OK
kayako.swticketnotes OK
kayako.swticketpostindex OK
kayako.swticketposts OK
kayako.swticketpriorities OK
kayako.swticketrecipients OK
kayako.swtickets OK
kayako.swticketsearches OK
kayako.swticketstatus OK
kayako.swtickettimetrack OK
kayako.swticketviewfields OK
kayako.swticketviews OK
kayako.swticketwords OK
kayako.swtroubleshootercat OK
kayako.swtroubleshooterdata OK
kayako.swtroubleshooterlinks OK
kayako.swtroubleshootersteps OK
kayako.swtwdeletelog OK
kayako.swuseremails OK
kayako.swusergroups OK
kayako.swusergroupsettings OK
kayako.swusers OK
kayako.swuserverifyhash OK
kayako.swvisitorbans OK
kayako.swvisitorfootprints
error : The handler for the table doesn't support repair
kayako.swvisitornotedata OK
kayako.swvisitornotes OK
kayako.swvisitorpulls
error : The handler for the table doesn't support repair

[Neil-UKWSD]

Hi,

The errors listed in the check are fine, those tables ue HEAP which does not support repair, the check it just warning you of this.

[Neil-UKWSD]

What version are you running and have you recently upgraded from one version to another?

If you upgraded did you also run the upgrade script?