Accidentally truncated yout kaltura.entry table?

Fear not!, for you can rebuild it with this SQL statement:

INSERT INTO kaltura.entry (id, kshow_id, kuser_id, name, type, media_type, data,
thumbnail, views, votes, comments, favorites, total_rank, rank, tags, anonymous,
status, source, source_id, source_link, license_type, credit, length_in_msecs,
partner_id, group_id, int_id, subp_id, display_in_search, puser_id, plays,
permissions, partner_data, access_control_id, conversion_profile_id, categories,
categories_ids, created_at) SELECT de.entry_id, de.kshow_id, de.kuser_id, de.entry_name,
de.entry_type_id, de.entry_media_type_id, de.data, de.thumbnail, de.views, de.votes,
de.comments, [...]

October 28, 2011 • Tags: , , • Posted in: Computers • No Comments