Database updated

Pogue Mahone

Officials say drugs may have played a part
Over 1000 posts
It was edited, but it was only a change from p.m. to a.m., and the change made sense in the context of the poem. Imagine that.
Damn typesetters, always screwing up the editor's work...
 

mjp

Your Host
Moderator
Founding member
Over 5000 posts
In the never-ending quest to appease the Gods (a.k.a. Google), I have made some changes to the database code to add the poem, book, magazine, recording, etc. titles to the URLs on the results pages.

Like so:

greatman.png


To get that to work I had to update the code in pretty much every file that the database uses, and I think I've tested all the options, but if you notice something that doesn't seem to be working as you'd expect in the database, please let me know.

Thank you for your kind indulgence.
 

Purple Stickpin

Over 5000 posts
I thought that I'd run some checks and got over to the Wormwood site here (database/lists/Wormwood Review Appearances). The first poem listed there is Thank God for Alleys. If I click the link, I am brought to the page that lists books, magazines, manuscripts, etc. All of those headers are present, but they are not populated (everything is grayed out). Conversely, if I search for the same poem at the main database search page, I get the a hit and when I click that link, I get to the same page, but it is populated with book and magazine appearances that are links to further info.

Maybe I'm missing something, but I'm assuming that searching through Wormwood should bring up the same info that comes up from the main search page. I also tried this for the NYQ and I found the same issue, so perhaps the links through the individual magazines (and/or other routes) aren't connected somehow. I tried the "Books" link and that seemed to work OK.
 

Purple Stickpin

Over 5000 posts
It looks like Broadsides, Wormwood, NYQ and Chronological Magazine Appearances are the ones that aren't functioning. The rest appear to be.
 
Reactions: mjp

mjp

Your Host
Moderator
Founding member
Over 5000 posts
Yeah, I fixed the lists that rely on database queries, but the lists that are static pages are going to take more time.

I made a temporary fix to prevent the blank results, so they should all work now, they just don't have the title URL.
 
Top