Woohooo!!!! Good to hear it Khaled.
On Thu, Dec 2, 2010 at 6:05 PM, Khaled Abou Alfa <[email protected]> wrote: > Just to say it's worked!!!! Thanks Colin, I definitely owe you a beer. > There's a tiny bit of borkage with regards to the tag.tagword.php > template but I can start tinkering around with that to see what's > wrong. Otherwise it was definitely the terms not working properly. > > Just as a quick one, to complete the circle if someone else happens to > stumble on this later on, basically the mysql command should be: > > UPDATE habari_terms SET vocabulary_id = 1; > > (not many vocabularies ;)). > > Also for some reason by habari__terms was basically two underscores, > so check that out as well. > > Once again thanks Colin. > > ----------------------------------------- > Khaled Abou Alfa > www.brokenkode.com > > > > On Thu, Dec 2, 2010 at 2:00 PM, Colin <[email protected]> wrote: >> 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 > > -- > 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 -- 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
