Blank page for certain Movie Categories

[epig]

I am running vcddb 0.991 in apache 2 with php5 and mysql 5.0.45.

When I click on a movie category in the left sidebar, I often get a blank page. Specific categories will always lead to a blank page, while other categories work as expected. If I browse the mysql database that contains the vcddb data, the vcd_MovieCategories table contains an entry for the category_ids that don't work, and there are movies in the main vcd table that have the category_id values that don't work.

However, if I go to My Movies > Pick a movie to watch and choose one of the categories that does not work in the sidebar, the Pick a movie to watch tool will find a movie in that category, so clearly vcddb CAN access information in the database with those category_ids.

memory_limit is set very high in php.ini for another program, so I don't think memory is the issue. I am at a loss for additional things to try. Thanks in advance for any insights anyone might have.

[epig]

I figured this one out when I noticed that the Movie Categories that didn't work also had an extra, unlabeled column in the My Movies > Collection overview popup window. I then noticed that each Movie category that didn’t work had a media_type_id of 27 in the VCDToUsers table of the vcddb database. This media_type_id wasn’t mapped to anything in the MediaTypes table. Each of these should have been media_type_id of 10 (DVD-R). I changed all these values to 10, and then the left sidebar buttons worked, and the extra column disappeared from the My Movies > Collection overview popup window.

[Carpo]

Thanks for sharing the solution

[killbill]

I figured this one out when I noticed that the Movie Categories that didn't work also had an extra, unlabeled column in the My Movies > Collection overview popup window. I then noticed that each Movie category that didn’t work had a media_type_id of 27 in the VCDToUsers table of the vcddb database. This media_type_id wasn’t mapped to anything in the MediaTypes table. Each of these should have been media_type_id of 10 (DVD-R). I changed all these values to 10, and then the left sidebar buttons worked, and the extra column disappeared from the My Movies > Collection overview popup window.

I had something similar happen. I got blank pages on a few seemingly random pages (loans, collections, various categories). In my case I had created a media type subcategory, Screener, to DVD-R (media_type_id = '10'). When I reassigned DVD-R to another parent (DVD), that is when I started getting all these blank pages. In order for me to fix the problem I restored the category, created a new media category under DVD, manually updated each movie (there were only 4 so i didn't bother with an update script) and deleted the old record.