From: George Clark <gac@sp...> - 2003-05-15 23:57:39
I've upgraded from _62 to _94 on a test system. I've been seeing a few
issues with the multiple topic support.
1) Searcing for a story by topic shows a line similar to:
Section: Main > Wireless Networking , Hardware
All of the listed topics have the same topic (tid=193) in the search.
So regardless of whether you click on "wireless networking" or "hardware"
in the above topics string, you get the same search.
Another example from slashdot. Searching for "Wireless Networking"
returned this story in the list.
FreeNetworks Conference in Las Vegas
On May 9th, 2003 with 43 comments
belial writes "The FreeNetworks Conference is in less than a month (June
6-8). If you want to find out what's happening in the Community Wireless
Section: Main > Announcements , Hardware , Wireless Networking , News
However, Hardware, Wireless and News all search on tid=162.
2) On my own site, I was unable to find older stories in the topic
search - it appears that the topic search uses the story_topics table,
but nothing in the upgrades script copies the topics from the stories
table to the story_topics table. Once I copied them over it worked
fine, but its tricky because it created duplicate rows in story_topics
(due to stories added since the initial multiple-topic support was
added). which leads to...
3) Duplicate entries were permitted in story_topics. It would make the
copy operation easier if the sql definition prevented the duplicate sid,
tid entires. The following sequence copies over the topics without
mysql> alter table story_topics add UNIQUE sid_tid (sid,tid);
mysql> INSERT INTO story_topics SELECT "",sid,tid,"no" FROM topics;
mysql> alter table story_topics drop INDEX sid_tid ;