Yes, something doesn't look right here. It looks like your tags may have been converted to terms and the old tables not emptied.
As tags are your only vocab, you may find the total number of rows in your habari_tags table is the same as the number of rows in your habari_terms table. If they are, then I think we can say the tags have been converted to terms, just the clean up fairy hasn't done her job for some reason. The vocabulary_id in habari_terms should definitely be 1 (to match the ID for tags in habari_vocabularies). The easiest option would be to change the ID in habari_vocabularies to 0, but I'm not too happy with this idea as I don't know what else may break. All my installs have the ID = 1. Changing the posts, whilst more dangerous, is probably the better option. HTH Colin On Wed, Dec 1, 2010 at 8:59 PM, Khaled Abou Alfa <[email protected]> wrote: > Hey Colin, > > Thanks for all the help, seriously really appreciate it. Going through > the tables above there seems to be something fishy going on. > > I've attached a couple of screenshot of my the various tables, as I > think the habari_tags and habari_tag2post are not empty. > > Also the vocabulary_id for habari_terms is 0, but I think the tag id > is 1 (but I could be wrong about that) .... > > I think I'll wait before I delete that id just yet. > > ----------------------------------------- > Khaled Abou Alfa > www.brokenkode.com > > > > On Wed, Dec 1, 2010 at 3:11 PM, Colin <[email protected]> wrote: >> Hi Khaled >> >> Sorry about the delay. I don't think this would confuse things, but >> you certainly don't need two of the same type. >> >> Backup your DB and remove the id=2 entry and see if that makes any >> difference. >> >> Also check your "habari__terms" table and ensure all your tags have >> the same vocabulary_id as the "tags" entry in "habari__vocabularies" >> and that your "habari__tag2post" and "habari__tags" tables, if they >> exist, are empty. If these last two are NOT empty, then I think the >> tag-to-terms migration may have gone a bit wrong somewhere. >> >> If all looks good and removing the id=2 entry doesn't solve the >> problem, then I'm not sure what else to suggest. Hopefully someone >> else will be able to chime in. >> >> HTH >> Colin >> >> >> >> On Mon, Nov 29, 2010 at 7:49 PM, Khaled Abou Alfa >> <[email protected]> wrote: >>> Hey Colin, >>> >>> Thanks for that. So I looked at the database, specifically the >>> habari__object_types table and I've got two entries: >>> id :1 >>> name: post >>> >>> id:2 >>> name:post >>> >>> Now I checked in my habari__object_terms and it seems that it only >>> references id:1. Dunno where id:2 came from. Do you think this might >>> be confusing things? >>> >>> ----------------------------------------- >>> Khaled Abou Alfa >>> www.brokenkode.com >>> >>> >>> >>> On Mon, Nov 29, 2010 at 12:22 PM, Colin <[email protected]> wrote: >>>> Hi Khaled >>>> >>>> I've hit this issue too, but can't quite remember how I fixed it, but >>>> I'll try anyway. >>>> >>>> The functionality should still work exactly the same way without any >>>> need for changes from you, however I discovered several of my sites >>>> had this problem after I moved the database from one host to another >>>> where I'd neglected to ensure both instances of Habari were running >>>> the same version (and thus have the same database "stuff"). >>>> >>>> In my case, I found I needed to make a change to my database itself >>>> but I can't remember exactly what it is, so I'm going to try and >>>> remember this from the top of my head (whilst poking around my >>>> database)... >>>> >>>> I believe I had to add/modify the entry in "habrai__object_types" and >>>> ensure the entry in there (I only have one) is: >>>> >>>> id: 1 >>>> name: post >>>> >>>> I think my problem was either the entry was missing or id was set to 0. >>>> >>>> If I remember correctly, my problem was caused by the fact all the >>>> entries in "habari__object_terms" referenced an "object_type_id" of 1, >>>> yet I didn't have a corresponding entry in the "habrai__object_types" >>>> table. >>>> >>>> I also think when I was having this problem, my posts weren't showing >>>> tags either. >>>> >>>> I hope I've got the right tables in this explanation. I know for sure >>>> I needed to poke around in the DB to solve this. >>>> >>>> NOTE: This is all referring to MySQL and make sure you take a backup >>>> of your DB before tatting about with it. >>>> >>>> HTH >>>> Colin >>>> >>>> >>>> On Sun, Nov 28, 2010 at 6:46 PM, Khaled Abou Alfa >>>> <[email protected]> wrote: >>>>> So I just noticed something, hopefully there's an easy answer for this. I >>>>> used to be able to go to: www.myurl.com/tag/tagname >>>>> and I would be presented with a list of the actual posts associated with >>>>> that tag. I could also theme a tag.tagname.php file in my theme and that >>>>> would show up in a specific way. >>>>> This functionality seems to have broken in version 0.7 for me, any ideas >>>>> how >>>>> I can get this back? >>>>> Thanks, >>>>> ----------------------------------------- >>>>> Khaled Abou Alfa >>>>> www.brokenkode.com >>>>> >>>>> -- >>>>> 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 >>> >>> -- >>> 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 > > -- > 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
