From: Chris J. <jo...@nm...> - 2003-11-05 13:30:38
|
On Wed, 5 Nov 2003, Clifton Wood wrote: > >From admin.pl, around line 1351: > > my $topic_values = $slashdb->getDescriptions('topics_section', > $storyref->{section}); > $topic_select = createSelect('tid', > $topic_values, > $storyref->{tid}, 1, 0, 1 > ); > > This is where the topic list is generated, there are a few things you > can try, here: > > >From the command line: > > perl -MSlash::Test=<vu> -le 'print > Dumper($slashdb->getDescriptions("topics_section", $section)' Oh this is interesting. I get absolutely nothing. > > Replace $section with the name of a defined section, and "<vu>" with > the virtual user of your site. You might want to iterate through the > sections, to see which ones are defined, you can do this from the > command-line: > > perl -MSlash::Test=<vu> -le 'print Dumper(keys %{$slashdb->getSections()})' Thisgives me all the sections ok. > > Collect that output and see if you can find your new topic in ANY of > the sections that it should be in. If you want further help > interpreting the output, I'd be glad to assist you. > > I *suspect* that the section_topics table may be slightly wonky and > a mismatched topic ID is the cause of your problem. I would need to > know the contents of your section_topics table, and your topics > table, to be sure, however. > > - Cliff mysql> select * from slashdotdb.topics\g +-----+------------+--------------------+--------------+-------+--------+ | tid | name | image | alttext | width | height | +-----+------------+--------------------+--------------+-------+--------+ | 1 | news | topicnews.gif | News | 34 | 44 | | 2 | linux | topiclinux.gif | Linux | 60 | 70 | | 3 | slashdot | topicslashdot.gif | Slashdot | 100 | 34 | | 4 | slash | topicslash.gif | Slash | 81 | 36 | | 5 | journal | topiceditorial.gif | User Journal | 58 | 55 | | 11 | bad peotry | topiceditorial.gif | Bad Poetry | 58 | 55 | +-----+------------+--------------------+--------------+-------+--------+ 6 rows in set (0.00 sec) mysql> select * from slashdotdb.section_topics\g +----------+-----+ | section | tid | +----------+-----+ | articles | 1 | | articles | 2 | | articles | 3 | | articles | 4 | | articles | 5 | | features | 1 | | poetry | 11 | +----------+-----+ 7 rows in set (0.00 sec) It knows what the section is, "bad poetry", which has a tid of 11. And the section_topics table looks like it knows that section "poetry" and topic "bad poetry" are related. > > PS: I'm really beginning to loathe some of the things KMail does. I sent this to > the list days ago from the wrong address (the one I *expressly* told it not > to use) and it used it anyway and is hung in approvals. I'll just continue > to send mail to the list from here, but be aware that this message may > appear twice. > > Redundancy I can deal with. ------------------------------------------------------------------------------- Chris Johnson |Internet: jo...@nm... Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson NMR Center |Voice: 617.726.0949 Mass. General Hospital |FAX: 617.726.7422 149 (2301) 13th Street |Life, a bad idea who's time is past. Charlestown, MA., 02129 USA | Me ------------------------------------------------------------------------------- |