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
