Ivan Lulukyan writes:
> Hi All.
> Strange thing.The query below:
>
> select concat(domain,path,file) as url, title, '' as blank1, docdate, size,
> date as lastmod, 'keywords' as keyw, description as descr, a.ID, sum((word
> like 'acc')) as r, ( sum(word like 'acc')) as qu, f.ID, author,
> class,charset,lang,'content' as content, count(*) as suma from words as w
> left join aname_word as aw on w.ID=aw.wordID left join anames as a on
> a.ID=aw.anameID left join files as f on f.ID=a.fileID left join paths as p
> on p.ID=f.pathID left join domains as d on d.ID=p.domainID left join
> file_names as fn on fn.ID=f.file_nameID left join path_names as pn on
> pn.ID=p.path_nameID left join charsets as c on c.ID=f.charsetID left join
> classes as l on l.fileID=f.ID left join class_names as ln on ln.ID=l.classID
> where ((word like 'acc')) group by f.ID having qu>0 order by r desc
>
> answer me with
>
> ERROR 1062 at line 1: Duplicate entry '4783' for key 1
>
> How can it be?
>
> Regards,
>
> Ivan Lulukyan
> ACC
> Armenia
>
Hi!
Please CHECK all of the above tables for a corruption. If any of them
is corrupted, REPAIR it and try again the above query.
If the above errors happens with non-corrupted tables and with our
latest binary for your OS, we would like to take a closer look at it.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php