How to fix your Skype profile/database after switching from 4.2 to 4.3 on Ubuntu 14.04 (x86_64)

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%';

Syndicate content