Re: [Slashcode-development] Re: Weird Slash Behavior / Bad Topics

[Chris J. <jo...@nm...>]

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
-------------------------------------------------------------------------------