Thanks for the efforts Rick, I spoke with the guys on IRC, I originally thought I had something messed up, but alas they were like, 'nah, terms and tags have been changed significantly), so yeah can't say anything more than thanks.
I'll keep tinkering and coming up with issues, I'm sure :) Thanks again, ----------------------------------------- Khaled Abou Alfa www.brokenkode.com On Sun, Dec 5, 2010 at 4:28 PM, rick c <[email protected]> wrote: > 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 -- 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
