Old Templates

[Lionel]

The upgrade did not deleted the old blogcicles templates. Is there a command I could type to delete them all, instead of having to do so one by one?

[Brian]

It should have... Though IIRC, you had some problems with the upgrade and ended up re-installing, right? Either way, here's the queries from the upgrade file that you can run that should remove all unnecessary info from beta 1/2.

DELETE FROM template WHERE title LIKE 'adv_blog%' AND styleid = '-1';

DELETE FROM phrase WHERE product = 'adv_blog' AND languageid = '-1';

DELETE FROM adv_settinggroup WHERE grouptitle IN('adv_blog_title_paths', 'adv_blog_main', 'adv_blog_index', 'adv_blog_categorybit', 'adv_blog_browsecategory', 'adv_blog_showentry', 'adv_blog_newentry', 'adv_blog_attach', 'adv_blog_posting', 'adv_blog_usercats', 'adv_blog_moduleopts', 'adv_blog_external');

ALTER TABLE language
DROP phrasegroup_adv_blog,
DROP phrasegroup_adv_blog_cp,
DROP phrasegroup_adv_blog_cp_cats,
DROP phrasegroup_adv_blog_cp_modules,
DROP phrasegroup_adv_blog_cp_perms,
DROP phrasegroup_adv_blog_modules,
DROP phrasegroup_adv_blog_managecats,
DROP phrasegroup_adv_blog_attach;


DELETE FROM phrasetype WHERE fieldname IN('adv_blog', 'adv_blog_cp', 'adv_blog_cp_cats', 'adv_blog_cp_modules', 'adv_blog_cp_perms', 'adv_blog_attach', 'adv_blog_managecats', 'adv_blog_modules');

DELETE FROM datastore WHERE title IN('adv_blog_cats', 'adv_blog_mods', 'adv_blog_modpos', 'adv_blog_module', 'adv_blog_opts', 'adv_blog_perms', 'adv_blog_rand');

That should clean up anything that could be left over from the failed beta upgrade.