search

jreklund / php4dvd

php4dvd is an open source php/mysql powered movie database. Catalog your video collection with ease. Automatic update of information and images.
GNU General Public License v3.0
82 stars 44 forks source link

Blank page when saving new title #98

Open nickcharles23 opened 1 month ago

nickcharles23 commented 1 month ago

Hi, Just checking if anyone has seen this issue. I added a new title a few weeks back and when I wanted to add a new title yesterday I get a blank page when clicking on the save or save and add new title.

I reinstalled php4dvd using upgrade procedure and cleared browser cache and still get a blank web page after save. Still using the same php version 8.2 and not aware of any server files being change. This issue seems similar to issue 93 that has been posted. Editing titles seem to be working without any issues.

Here is the imdb data ID I am trying to add is http://localhost/php4dvd/?go=add&imdbid=7733396. All the imdb available data is populated in the fields. I have 1461 titles save in the MYSQL database.

Can anyone give any guidance on helping resolve this issue. Thanks

jreklund commented 1 month ago

Do you have any error logs? Can you add another title except that one?

nickcharles23 commented 1 month ago

I have checked the php and mysql logs and found nothing.

I can add a new movie title and save it using the search function.

But can't using the hack for adding tv titles as http://localhost/php4dvd/?go=add&imdbid=7733396 or 7733388 both resulting in getting a blank page.

I was able to enter a new tv title with the id 0676168.

Since I can add some tv titles and not others. This leads me to believe it has to do with IMDB fields that have null data being downloaded or non at all /empty. Then pfp4dvd is failing on saving the data into mysql due to a field in mysql requiring non null data or an null. Thus not competing the save process in mysql in resulting seeing a blank page.

Possible fix to ensure the add title page have all fields have a default to be null. Or the mysql schema table fields be set to default val nullable to yes except title and year. Currently all are set to no.

jreklund commented 1 month ago

Based on 7733396 and 7733388 compared to 0676168 some number fields aren't populated. Add a 0/1 in those fields and it should save just fine for now.

You should troubleshoot why you aren't getting any error logs as these type of problems will be logged there.