On Thu, Dec 2, 2010 at 11:04 AM, Khaled Abou Alfa <[email protected]> wrote: > Okay, it seems like there is some light at the end of the tunnel - > hopefully. I've checked and both the terms in habari_tags and > habari_terms is exactly the same. > > Just so that I can review what I need to do so that I can try and resolve > this. > > 1. Backup the database > 2. Go into habari_terms and change all the vocabularies_id to 1. I > guess this would involve going into each entry and changing it.I'm > kinda weary since you used the word 'dangerous' for this action. Won't > changing it back to 0 just make anything that happened as a > consequence just go away? > 3. Should I be doing anything to the tables in either habari_tags or > habari_tag2posts? Ie should I be deleting any values or something? > 4. Remove id=2 from habari__object_terms as well. >
Looks good, just a few comments: You can do step #2 in one SQL command: UPDATE habari_terms SET vocabularies_id = 1; The reason I said this was a bit dangerous as doing it individually could result in errors quite easily and getting the single SQL command wrong could cause problems too. This one command will update all entries in the barari_terms table. For step #3: leave them be for the moment. I seem to have been uber efficient and emptied my tables and completely forgot about it. As the ticket Michael pointed out, this should be deleted at a later stage by Habari. -- Colin Seymour Blog: http://colinseymour.co.uk Tech Stuff: http://lildude.co.uk Barefoot Running: http://barefootrunner.co.uk IRC: lildude #habari -- To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/habari-users
