Error Adding movies
-
version 0.1.8 MbC
Angels & Demons (2009)
i will say this, during the import it was interuptted and when i went to re-add the movie is when i started getting the error
Also what port is MbC running on? so that i can port forward to it and a=have it accessible outside the network for my family
and is there a way that you could do some sort of login auth for it? -
this has now happened to several movies for me, and i believe i know why.
to replacate the issue:
import from web,
when you click save click on refresh page and then resend info,
try adding the movie again.
the reason:
on several movies (for me) after clicking on save it gets to the rotten tomatoe scrapper and hangs, i try to refresh page and resend the info and get an error 500 message
[code]
500 Unexpected problem running servlet: java.lang.NullPointerException
--------------------------------------------------------------------------------
D. Rogatkin's TJWS based on Acme.Serve Version 1.60, $Revision: 1.8 $
[\code]
i then close the browser (IE9) and reopen and try to add the movie again and it fails with the previously mentioned error.
Possible solution:
add a connection timeout check with the scrappers
example:
if rotten tomatoes scrapper tries to connect for X ms with no response continue to next scrapper -
1) The page refresh did not stop the save which continues to run on the server. This is why the constraint violation showed up on subsequent imports. Eventually the movie should save successfully. In a future release I will see how I can improve this.
2) MbC defaults to port 80.
3) I am looking into some sort of authentication -
the movies that errored out still havent added to the list nor will it allow me to re add them im still getting the same error message when trying to readd them.
is there a way to connect to the database and edit it directly?
i tried to use razorSQL to connect to the HSQLDB but its not wanting to connect for some reason, what version jdbcDriver are you using to create the db? -
Here's what you can do.
Stop MbC if it is running. Run the following (on one line) to run the database in a separate process.
java -Xmx768m -cp C:/xxx/craigworks/movies/lib/hsqldb.jar org.hsqldb.server.Server -database.0 file:"C:/xxx/craigworks/movies/data/data";hsqldb.tx=mvcc -dbname.0 xdb
Then run the sql tools. This will bring up a front-end where you can view the table and run sql commands.
java -Xmx256m -cp C:/xxx/craigworks/movies/lib/hsqldb.jar org.hsqldb.util.DatabaseManager
When the connect dialog pops up, change "Type:" to "HSQL Database Engine Server" and set "URL:" to "jdbc:hsqldb:hsql://localhost/xdb"
If you don't mind, can you send a copy of your db so I can analyze it and prevent this problem in the future. Thanks.
support@craigworks.org -
i have deleted the log file and was able to add the movies without fail. so the error seems to be there.
HERE is the log file
so this issue is resolved, now to figure out why it was happening, i will continue to add movies and if i get the same error again i will make a copy of the log/data files and shoot them over to you. -
I was having the same problem as OP. Version 0.1.8d seems to have addressed the issue for me.
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
