[Discuss] Success on the pre/next episode error from Wednesday's BLU meeting

[John Abreau]

When I was demo'ing my video system on Wednesday, I mentioned a problem I
ran into where the linking from an episode to its previous and next
episodes had broken after an update of the IMDB tables.

I spent some time this evening examining the problem. When I pasted the
query into  psql, it gave the correct results,  and I found no obvious
errors in the  code.

To debug it further, I decided to run the cgi script from the command line
so I could add diagnostic printf's that would cause a web browser to fail.
The first time I ran it, it worked fine.

Given that the problem was not with the SQL and not the CGI script, I
figured it must be a problem with permissions. Upon investigation, I found
that the episode_list view was accessible to jabr, but not to apache.

The last time I reloaded a fresh copy of the IMDB tables, I was developing
and testing a script to automate the process. To speed up the process, I
found it necessary to delete all the indexes and table constraints before
deleting the table rows and importing the fresh ones, and then add back the
indexes and constraints afterward. I did it for all the TABLEs, but
apparently I overlooked at least one of the VIEWs.

Once I granted SELECT privileges on the episode_list view to apache, the
links began working again.

-- 
John Abreau / Executive Director, Boston Linux & Unix
Email: abreauj at gmail.com / WWW http://www.abreau.net / PGP-Key-ID 0x920063C6
PGP-Key-Fingerprint A5AD 6BE1 FEFE 8E4F 5C23  C2D0 E885 E17C 9200 63C6