Run the following SQL using sqlite3 on your
main.db
database (which is inside your
$HOME/.Skype/<skype_username>
directory) ...
UPDATE messages
SET body_xml =(
SELECT SUBSTR( body_xml, files_start, alt_end - files_start ) ||
SUBSTR( body_xml, 0, files_start ) ||
SUBSTR( body_xml, alt_end )
FROM (
SELECT msg.body_xml,
instr( msg.body_xml, '<files' ) files_start,
instr( msg.body_xml, 'alt="' ) + 5 alt_end
FROM messages msg
WHERE msg.id = messages.id
)
)
WHERE type = 68
AND body_xml NOT LIKE '<file%';
Recent comments
1 year 43 weeks ago
3 years 13 weeks ago
3 years 13 weeks ago
3 years 15 weeks ago
3 years 16 weeks ago
3 years 22 weeks ago
3 years 22 weeks ago
3 years 23 weeks ago
3 years 23 weeks ago
3 years 23 weeks ago