Skip to main content
I am am running a #mysql optimize, usually the output looks like this:

ylms_friendica.item-activity
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK


But for one table it returned this: 

ylms_friendica.item-content
note     : Table does not support optimize, doing recreate + analyze instead
error    : Duplicate entry '' for key 'uri-plink-hash'
status   : Operation failed


Should I worry about that?

!Friendica Support
#mysql !Friendica Support
Michael Vogel
Michael Vogel  
That's weird, because that field had always been unique. Can you check how much duplicates are there around and how they look alike?
Michael Vogel
Michael Vogel  
@utzer yeah
@utzer [Friendica]
utzer [Friendica]
utzer [Friendica]  
@Michael Vogel in PHPmyAdmin I only get one line where the field uri-plink-hash is empty, not sure if it is a space. I just sorted by "uri-plink-hash", but I can't run a query there, in PHPmyAdmin I get a timeout.
@Michael Vogel
utzer [Friendica]
utzer [Friendica]  
@Michael Vogel so I would need to put together a query for the ' ' entry, let me look into this the next days.
@Michael Vogel
utzer [Friendica]
utzer [Friendica]  
@Michael Vogel I started another run of mysqlcheck for just the table in question and will see what the output is, after this I will try to put together a query for mysql for the double entry and for the one will ' ' (space only) in the column.
@Michael Vogel
utzer [Friendica]
utzer [Friendica]  
@Michael Vogel kannst du mir sagen wie ich die query schreiben muss?

SELECT * FROM "item-content" WHERE uri-plink-hash = ' ';

Die " nehme ich, weil sonst glaub ich - ein Problem macht, aber wie kann ich denn das space in der query suchen lassen?
@Michael Vogel
Michael Vogel
Michael Vogel  
Auf alle Fälle machst Du da nichts mit diesem PHPMyMurks. Das Teil rennt sowieso in einen Time-Out. Da kannst Du nur per Konsole was machen.
utzer [Friendica]
utzer [Friendica]  
@Michael Vogel gestartet hab ich mysql so:
mysql friendica

Somit sollte die DB ja schon ausgewählt sein.
@Michael Vogel
⇧