NZBget, Feedtime, usenet indexers... and my own solution.

[jasch]

Sanbznd functionality is basically done. Just have to incorporate the options in the "Profile" page, so the user can select it instead of nzbget.

[chris57]

Just a couple of new issues:-

1. If I enter Swamp People in the My Shows it finds it but when loading I get some foreign language 'ueberleben in sumpf'.
2. If I enter 'americas most wanted' as a search it does not pick up any of the TrollHD releases that are available. I wonder if it picks any TrollHD releases up. Enter the same search in nzbs.org and you'll see the ones I mean. They are from the Group a.b.hdtv

[jasch]

The spider sometimes get's the titles wrong. But each shows is updated once a week (Current Status, episode names, and titles). The last update on this show was March 23, it was due to a refresh on the 30th, where it normally would have update the correct title.

I just forced the update, and the title is showing correctly.

I checked my list of releases on a.b.hdtv, vs the one on nzbs.org (for the last 48 hours), and it's strange. There's lots of stuff I have, they don't, and viceversa. Perhaps it has to do with the provider they are using to index the newsgroups? (we are using astraweb).

(I know we are pickinh up TrollHD releases, because a search for TrollHD returns thousands of hits)

Also, sabnzbd support is ready for general public use now.

[Slevin]

(03-27-2012 02:24 PM)jasch Wrote:  Yes, that's the only IP. Are you sure your NZBget control port is listening using the default password of tegbzn6789? (this is different than the Login password for NZBgetWeb)

NZBGetWeb password was changed even before doggy,
since i had my webserver port open on my router.

since i opened port 6789 i also changed the nzbgetServer Password from the standard tegbzn6789 to to another one;
so you can not use:
'http://nzbget:tegbzn6789@localhost:6789/xmlrpc'
but it should be
'http://nzbget:$slevinsPassword@localhost:6789/xmlrpc'

that is what the password field in the Push-form is for no?

---

Since the new update that includes Sabnzb i don't have the problem anymore..
looks like it was something temporarly during transition...

[jasch]

Try configuring it again on DOGnzb, so I can take a look.

---

Slevin, are you sure it's not working? I just logged in with your user to DOGnzb, and was able to see your download queue... (currently downloading Nova Zembla at 467k).

[Slevin]

jasch, i updated my previous post.

(03-27-2012 09:16 PM)Slevin Wrote:  Since the new update that includes Sabnzb i don't have the problem anymore..
looks like it was something temporarly during transition...

so it is working as it should now

[jasch]

Yeah, you tried while I was in the middle of modifying the library.

[chris57]

Got an error when logging in tonight:-

Code:

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Error Executing Database Query.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'e on e.rageID = userseries.rageID WHERE userID = '15' AND airdate IS NOT NUL' at line 4

The error occurred in D:/domains/dognzb.com/htdocs/shows_browse.cfm: line 19
Called from D:/domains/dognzb.com/htdocs/shows.cfm: line 221
Called from D:/domains/dognzb.com/htdocs/shows.cfm: line 1
Called from D:/domains/dognzb.com/htdocs/shows_browse.cfm: line 19
Called from D:/domains/dognzb.com/htdocs/shows.cfm: line 221
Called from D:/domains/dognzb.com/htdocs/shows.cfm: line 1

17 :     WHERE userID = <CFQUERYPARAM Value="#user.ID#">
18 :     <cfif IsDefined('last') AND last EQ 'true'>AND userseries.rageid <> #browse_last.rageid#</cfif>
19 :     <cfif IsDefined('st') AND len(st) GT 0>AND status = <CFQUERYPARAM Value="#st#"></cfif>
20 :     AND airdate IS NOT NULL
21 :     GROUP BY rageid

VENDORERRORCODE       1064
SQLSTATE       42000
SQL        SELECT userseries.*, tvrage.releasetitle, tvrage.tvdbid, status, lastDownload, genre, e.airDate FROM userseries INNER JOIN (SELECT ID, releasetitle, rageid, tvdbid, genre, status FROM tvrage) tvrage on tvrage.rageID = userseries.rageID LEFT JOIN (SELECT airdate, rageid FROM episodeinfo WHERE airdate >= (param 1) ) episodeinfo e on e.rageID = userseries.rageID WHERE userID = (param 2) AND airdate IS NOT NULL GROUP BY rageid ORDER BY airdate, releasetitle
DATASOURCE       dognzb
Resources:

    Check the ColdFusion documentation to verify that you are using the correct syntax.
    Search the Knowledge Base to find a solution to your problem.

Browser       Mozilla/5.0 (Windows NT 6.1; rv:10.0.2) Gecko/20100101 Firefox/10.0.2
Remote Address       94.194.90.253
Referrer       http://www.dognzb.com/browse
Date/Time       31-Mar-12 06:36 PM
Stack Trace
at cfshows_browse2ecfm1519915910.runPage(D:/domains/dognzb.com/htdocs/shows_browse.cfm:19) at cfshows2ecfm2136801271._factor2(D:/domains/dognzb.com/htdocs/shows.cfm:221) at cfshows2ecfm2136801271.runPage(D:/domains/dognzb.com/htdocs/shows.cfm:1) at cfshows_browse2ecfm1519915910.runPage(D:/domains/dognzb.com/htdocs/shows_browse.cfm:19) at cfshows2ecfm2136801271._factor2(D:/domains/dognzb.com/htdocs/shows.cfm:221) at cfshows2ecfm2136801271.runPage(D:/domains/dognzb.com/htdocs/shows.cfm:1)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'e on e.rageID = userseries.rageID
    WHERE userID = '15'
    AND airdate IS NOT NUL' at line 4
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorI​mpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorA​ccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.Util.getInstance(Util.java:381)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
    at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.j​ava:91)
    at coldfusion.sql.Executive.executeQuery(Executive.java:1436)
    at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
    at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
    at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
    at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
    at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
    at cfshows_browse2ecfm1519915910.runPage(D:\domains\dognzb.com\htdocs\shows_browse.​cfm:19)
    at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
    at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
    at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
    at cfshows2ecfm2136801271._factor2(D:\domains\dognzb.com\htdocs\shows.cfm:221)
    at cfshows2ecfm2136801271.runPage(D:\domains\dognzb.com\htdocs\shows.cfm:1)
    at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
    at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
    at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
    at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
    at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
    at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
    at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
    at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
    at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilt​er.java:28)
    at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
    at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
    at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
    at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
    at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
    at coldfusion.CfmServlet.service(CfmServlet.java:200)
    at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
    at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
    at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilte​r.java:42)
    at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
    at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
    at jrun.servlet.FilterChain.service(FilterChain.java:101)
    at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
    at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
    at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
    at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
    at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
    at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)​
    at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
    at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
    at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

I was logging in on a laptop and I may also have been logged in on my desktop PC.

[jasch]

Fixed

[Slevin]

Shows are being pushed the last few days as they should..
Works fine with me.

Any way to add an option to disable the mails with tv schedule?

[jasch]

I have disabled the option for now, since it was still in 'beta' with some obvious problems that needed to be fixed.

[RangerXXX]

When I try to enable bookmark push functionality I keep getting an error like this:
An error happened during the execution of this webpage. A detailed report has been stored for further analysis. If the problem continues, please mention this reference number to an administrator: 7C798F64.

Also is the api key just for sabnzbd?

[jasch]

I fixed the error. The problem is that you're leaving the password field blank.

It should return an error now.

Now, the API key is only for SABNzb. When you switch to NZBget, it should change the text "API Key" to "Password"

[RangerXXX]

I still can't get it to connect I'm getting "connection failure. status code unavailable." I have the port forwarded on my router and made sure the password was correct. Is there a setting I need to change in NZBget to make it work?

[jasch]

Check Config -> Client/Server Communication -> ServerIP (should be 0.0.0.0)