Khaled, Re the tag.tagname.php template issue: This did manage to get broken in the tags to terms transition. Michael and I are looking at the best way to fix this. You've evidently become the test bed for finding what all isn't working properly.
Rick On Dec 2, 1: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 Alfawww.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 > > athttp://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
