Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Re: [Andy] Build-in search logger - duplicate key

Jun 24, 2008, 12:57 AM
DeadMan
User (497 posts)
DeadMan's avatar
Jun 24, 2008, 12:57 AM
Views: 3324
Shortcut
Quote Reply
Re: [Andy] Build-in search logger - duplicate key In reply to
I guess I didn't solve my problme.

I try to use this code:

Code:
ALTER TABLE `lsql_SearchLogs` CHANGE `slog_query` `slog_query` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

and got this error

Code:
#1062 - Duplicate entry 'varazdin' for key 1

Now, I've checked sloq_query and there is not duplicate key 'varazdin' but there are keys like: varazdin, varazdin online, varazdinske ....

UnReal Network
Subject Author Views Date
Thread Build-in search logger - duplicate key DeadMan 3441 Jun 15, 2008, 10:36 PM
Thread Re: [DeadMan] Build-in search logger - duplicate key 		Andy 3349 Jun 15, 2008, 10:59 PM
Post Re: [Andy] Build-in search logger - duplicate key 		DeadMan 3347 Jun 15, 2008, 11:06 PM
Thread Re: [Andy] Build-in search logger - duplicate key 		DeadMan 3324 Jun 24, 2008, 12:57 AM
Post Re: [DeadMan] Build-in search logger - duplicate key 		Wychwood 3306 Jun 24, 2008, 4:59 PM