search error

f0rd42 · **search error -** 28-06-2006, 09:06 AM

Hi all

when I use the Search funktion I get the following error message:

Quote:

Invalid SQL: INSERT INTO `swticketsearches` (`staffid`, `dateline`, `keywords`, `resultscount`, `timetaken`, `ticketidlist`, `rejectedwords`, `relevancelist`, `ticketfilterid`) VALUES ('3', '1151474637', 'scholich', '1', '0.00310111045837', 'a:1:{i:0;s:3:\"224\";}', '', 'a:1:{i:224;d:100;}', '0'); (Unknown column 'ticketfilterid' in 'field list')
Warning: Cannot modify header information - headers already sent by (output started at /var/www/supportsuite/includes/functions.php:410) in /var/www/supportsuite/modules/tickets/staff_search.php on line 71

if I try the advanced search, i get the same error.

Any ideas?

Any help is highly appreciated.

Andre

f0rd42 · 31-08-2006, 01:44 PM

gents

anything? I have this problem now for month through several versions.
any help is highly appreciated.

f0rd42

supportskins · 31-08-2006, 02:13 PM

Hi,
It seems your database structure has a problem. Did you recently upgrade your helpdesk? If yes, your upgrade was not successfully executed.

f0rd42 · 31-08-2006, 11:29 PM

Hi

good point. Yes, I upgraded several times, without any (ovious) problems.
So, waht's the best was to fix it?

f0rd42

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP error in Search	ells	SupportSuite, eSupport and LiveResponse	0	15-02-2007 07:03 PM
Search Error	snook789	SupportSuite, eSupport and LiveResponse	3	12-06-2006 11:53 AM

f0rd42 Offline Member Posts: 62 Join Date: Feb 2006	31-08-2006, 01:44 PM gents anything? I have this problem now for month through several versions. any help is highly appreciated. f0rd42

supportskins Online Senior Member Posts: 3,846 Join Date: Aug 2006 Location: Mumbai, India	31-08-2006, 02:13 PM Hi, It seems your database structure has a problem. Did you recently upgrade your helpdesk? If yes, your upgrade was not successfully executed. Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support Our Skins and Services - http://www.supportskins.com/store/ SupportSkins.com - http://www.supportskins.com/

f0rd42 Offline Member Posts: 62 Join Date: Feb 2006	31-08-2006, 11:29 PM Hi good point. Yes, I upgraded several times, without any (ovious) problems. So, waht's the best was to fix it? f0rd42