 |
SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.
 |
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
| ||||||||||||
|
|
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
(#1)
  |
| New Member Posts: 24 Join Date: Aug 2005 | SQL Error When Searching Tickets -
02-11-2006, 08:31 PM
We are getting the following error when we try to use the Advanced Search to search tickets for an e-mail address. We're doing this from the WinApp, if that matters. Code: Invalid SQL: INSERT INTO `swticketsearches` (`staffid`, `dateline`, `keywords`, `resultscount`, `timetaken`, `ticketidlist`, `rejectedwords`, `relevancelist`, `ticketfilterid`) VALUES ('1', '1162517322', '-- Mixed --', '1', '0.14561700820923', 'a:1:{i:0;s:5:\"19897\";}', '', 'a:0:{}', '0'); (Unknown column 'relevancelist' in 'field list')
|
| |  |
|
(#2)
|
| Member Posts: 345 Join Date: Mar 2006 Location: Manipal |
03-11-2006, 06:19 AM
Which the version you are using (latest stable)? Also, did you get any errors during the last upgrade? |
| | |
|
| Tags |
| searching, sql, tickets |
| Thread Tools | Search this Thread |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL Error When Searching Tickets | ljcaswell | SupportSuite, eSupport and LiveResponse | 2 | 14-12-2006 06:23 AM |
Linear Mode
