[RELEASE] Usenet Gateway for vB 2.01

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JCDR
    Member
    • May 2001
    • 81

    Re: Re: Usenet Reply

    Originally posted by fastforward

    It goes out the next time you run the script. How long it takes before it shows up on the news server is dependent on each server. Assuming the post was accepted, and you are reading from the same server to which you posted, it should be only a few minutes.
    Sorry FF I didn't explain fully, the message was posted but the subject of the message was not so all that was posted to the newsgroup was a blank message but the subject was there.

    Comment

    • express
      Senior Member
      • Apr 2001
      • 1470
      • 3.6.x

      Fastforward you might wnat to take a look at this thread then come back and read what happens when you do this. This will happen to all users with next version if not corrected.




      I did what the above thread mentioned and it did work after I replaced script in functions.php. Then I updated counters in control panel the forums that were empty it cleared out the last username and date/time of the last post.
      The problem came with the usenet groups even though they all had tons of post's in them the last post column on all of them also got cleared out. The other regular forums that did have post's in them did not. So if even though this does fix a bug with vb it screws with the usenet hack a little. I ran the pl file again and any newsgroups that had new posts they were installed in the last post column so this is just a small problem. Just wanted everyone that is using the usenet to know that until this is somehow fixed everytime you update counters if you make the change mentioned in the above thread that this will happen.

      Joey
      Real Web Host

      Comment

      • DarkReaper
        Senior Member
        • May 2001
        • 731

        A small bug:

        In new reply, at the very top I get "8/10/08" before any of the header loads. I've figure out that when there's stuff way up there, its usually because a variable is being called that has no value. I find this strange though, as the only change I have made to newreply.php is the single code change for the usenet hack, and the template for it is still the same.

        Any ideas?
        Seriously! - The Definitive Home of All Things Serious
        Seriously! Forums

        To recieve support on these forums, enter your username here.

        Comment

        • Dibble
          New Member
          • May 2001
          • 29

          Anyone help

          Hi,

          I have installed the hack on my server
          v20010820 (for 2.03)

          I think this is a great hack, but I'm having trouble

          ========================
          When I run newnews.pl
          - I succesfully connect to the news server
          - I get a load of NNTPERROR: 430 No such Article
          - Then says fetching xxxx... OK for a while
          - NNTPERROR: 421 No next article
          - NNTPERROR: 423 No such article in group
          - NNTPERROR: 430 No such article a few times
          - -> Processing article batch -> requested 56 messages 0 not available or rejected
          - -> inserting new threads from alt.comp.periphs.cdr.mitsumi

          Then
          Query failed
          INSERT INTO post (blah blah blah)

          DBD::mysql::db do failed: You have an error in your SQL syntax near '998959523,994399103,'This message posted with trial version of Express News Post' at line 1 at newnews.pl line 741, <SOCK1> line 2375
          =====================

          Anyone shed any light on this?

          Any help greatly appreciated

          Cheers

          Dibble

          Comment

          • fastforward
            Senior Member
            • Nov 2000
            • 1013

            Re: Anyone help

            Originally posted by Dibble
            Hi,

            I have installed the hack on my server
            v20010820 (for 2.03)

            I think this is a great hack, but I'm having trouble

            ========================
            When I run newnews.pl
            - I succesfully connect to the news server
            - I get a load of NNTPERROR: 430 No such Article
            - Then says fetching xxxx... OK for a while
            - NNTPERROR: 421 No next article
            - NNTPERROR: 423 No such article in group
            - NNTPERROR: 430 No such article a few times
            - -> Processing article batch -> requested 56 messages 0 not available or rejected
            - -> inserting new threads from alt.comp.periphs.cdr.mitsumi

            Then
            Query failed
            INSERT INTO post (blah blah blah)

            DBD::mysql::db do failed: You have an error in your SQL syntax near '998959523,994399103,'This message posted with trial version of Express News Post' at line 1 at newnews.pl line 741, <SOCK1> line 2375
            =====================

            Anyone shed any light on this?

            Any help greatly appreciated

            Cheers

            Dibble
            The 'No such Article' messages are normal. Read back and you'll see explanations on this.

            I'll need to see the full SQL error to tell you what's wrong with the other thing.
            http://britishexpats.com/ - British expatriate community

            Comment

            • Dibble
              New Member
              • May 2001
              • 29

              Thanks for the quick reply

              I'll post the full error when I have a sec. (I use SSH and I cant paste out of the damn thing....)

              Anyway its 03:15 in the UK, and I shoudl probably turn up for work later.

              Cheers

              Dibble.

              Comment

              • express
                Senior Member
                • Apr 2001
                • 1470
                • 3.6.x

                try blocking everything with the mouse and using ctrl key then go to notepad place your cursor where you want it and it paste.
                Real Web Host

                Comment

                • Dibble
                  New Member
                  • May 2001
                  • 29

                  Aha!


                  I defeated the evil SSH and used Telnet (no-one looking at my password? Good.)

                  So, here is most of the error message.

                  =============
                  There was stuff before this............
                  NNTPERROR: 430 No Such Article
                  NNTPERROR: 430 No Such Article
                  NNTPERROR: 430 No Such Article
                  NNTPERROR: 430 No Such Article
                  NNTPERROR: 430 No Such Article
                  -> processing article batch...
                  -> requested 56 messages... 0 not available or rejected.
                  -> inserting new threads from alt.comp.periphs.cdr.mitsumi

                  Query failed:
                  INSERT INTO post (title,allowsmilie,threadid,dateline,nntpdateline,pagetext,visi
                  ble,msgid,ord,username,userid,nntpfrom,ipaddress,isusenetpost) VALUES ('What do
                  you think? I want to know!!!',0,,998965144,994399103,'This message posted with t
                  rial version of Express News Poster\n___________________________________________
                  __________________\n\nWant to voice your opinion or belief? Visit my new site Ca
                  lled "Alternatives To Popular Beliefs"\n(www.jrbjr.freeservers.com) I have a chatroom, messageboard and poll. I a
                  m looking for new topics,\nso please send me ideas for topics you would like to
                  see on my site.','1','<[email protected]>','0','
                  Jrbjr',0,'&quot;jrbjr&quot; &lt;[email protected]&gt;',0,1)

                  DBD::mysql::db do failed: You have an error in your SQL syntax near '998965144,9
                  94399103,'This message posted with trial version of Express News Post' at line 1
                  at newnews.pl line 741, <SOCK1> line 2409.
                  ============

                  Thanks for any advice,

                  I've forked out for a paid usenet feed so it'll be cool if I can get this hack to fit around it as well. Its a darn site better than the usenet feed I get with my paid ISP.


                  Cheers

                  Dibble

                  Comment

                  • fastforward
                    Senior Member
                    • Nov 2000
                    • 1013

                    Re: Aha!

                    Originally posted by Dibble
                    So, here is most of the error message.
                    Query failed:
                    INSERT INTO post (title,allowsmilie,threadid,dateline,nntpdateline,pagetext,visi
                    ble,msgid,ord,username,userid,nntpfrom,ipaddress,isusenetpost) VALUES ('What do you think? I want to know!!!',0,,998965144,994399103,'This ... etc, etc...
                    As I thought. The threadid (third value in the insert clause) is null. You need to upgrade your Perl DBI and MySQL modules.
                    http://britishexpats.com/ - British expatriate community

                    Comment

                    • Dibble
                      New Member
                      • May 2001
                      • 29

                      Argh.

                      Sounds serious.

                      Please post rough details, as I will have to ask my hosting company to do this for me.
                      (Unless it is very easy)

                      Cheers

                      Dibble.

                      Comment

                      • DarkReaper
                        Senior Member
                        • May 2001
                        • 731

                        Originally posted by DarkReaper
                        A small bug:

                        In new reply, at the very top I get "8/10/08" before any of the header loads. I've figure out that when there's stuff way up there, its usually because a variable is being called that has no value. I find this strange though, as the only change I have made to newreply.php is the single code change for the usenet hack, and the template for it is still the same.

                        Any ideas?
                        ...

                        Need help
                        Seriously! - The Definitive Home of All Things Serious
                        Seriously! Forums

                        To recieve support on these forums, enter your username here.

                        Comment

                        • fastforward
                          Senior Member
                          • Nov 2000
                          • 1013

                          Originally posted by DarkReaper


                          ...

                          Need help
                          No idea. If I can reproduce it I'll let you know.
                          http://britishexpats.com/ - British expatriate community

                          Comment

                          • JCDR
                            Member
                            • May 2001
                            • 81

                            Re: Re: Re: Usenet Reply

                            Originally posted by JCDR
                            Sorry FF I didn't explain fully, the message was posted but the subject of the message was not so all that was posted to the newsgroup was a blank message but the subject was there.
                            Anyone any idea why the message gets posted to the newsgroup but there is no 'message' just the heading??

                            Comment

                            • Dibble
                              New Member
                              • May 2001
                              • 29

                              I can import news ok now, but I cant seem to export locally sent messages to usenet.

                              ============
                              bash$ perl newnews.pl


                              Connecting to news-central.giganews.com:119... Connected
                              Sending authentication info... Authenticated and logged in

                              Pulling alt.comp.periphs.cdr.mitsumi... No new messages.
                              Clean disconnection from news-central.giganews.com:119

                              Expiring usenet articles older than 150 days...
                              -> alt.comp.periphs.cdr.mitsumi... OK
                              Expire completed.
                              =================

                              This doesnt seem to be posting any back to usenet.
                              Anyone have any pointers about where I should look to fix this?

                              FYI - my board is at www.mitsumicdr.com/forums

                              Cheers,

                              Dibble.

                              Comment

                              • DarkReaper
                                Senior Member
                                • May 2001
                                • 731

                                Originally posted by fastforward

                                No idea. If I can reproduce it I'll let you know.
                                ROFL. Flame me, kick me, torture me, I deserve it. Before the <?php... in newthread.php there was...guess what! 8/10/08...how the hell did that get there and what is it? lol!
                                Seriously! - The Definitive Home of All Things Serious
                                Seriously! Forums

                                To recieve support on these forums, enter your username here.

                                Comment

                                Related Topics

                                Collapse

                                Working...