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.
 
  • Like
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.
 

mjp

Your Host
Moderator
Founding member
Over 5000 posts
Two things:

I changed the database search result page to not show items that don't exist. Previously the results page listed every possible result, whether that item was available for the work or not (recordings, broadsides, forum items, etc. - those lines would be there, but they would just be blank if there was nothing available). Now it only returns what it has a link for.

Second, there is a new "external link" field for things like this.
 

mjp

Your Host
Moderator
Founding member
Over 5000 posts
That last link is to a poem, by the way, but above the poem is a review (sort of) of Bukowski's first readings at The Bridge in Los Angeles, and it was written by John Thomas who says he taped both nights.

Everything I've read said he had about a million tapes in his house though, so it's unlikely those will ever be found. If they were even saved.
 
Top