vb.org Archive
Page 35 of 69 « First 253334 35 363745 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Usenet gateway (https://vborg.vbsupport.ru/showthread.php?t=7100)

fastforward 05-03-2001 12:55 PM
OK... sorry about all these posts. I have just found the problem with the date thing. The problem is obvious and I have no idea how I missed it! The conversion is only done when a thread starter is loaded. For replies I still had a hard code of '$dtm=time();' in there... ooops

Sorry about that.

Mark Hewitt 05-03-2001 01:48 PM
Ah right :cool: good to hear it's not my misconfiguration again :).

fastforward 05-04-2001 02:47 AM
Here's another one that attempts to fix the recent issues.
  1. Eliminated parse errors by removing the function that appended to the vB templates. It was too unreliable and prone to error. In order to display the usenet counts on template pages you must now make a code edit. There is also a requirement to make one common code change if any of the optional code edits are made.
  2. Fixed the NNTP/LOCAL time issues. (really this time... honest!)
  3. There is also an addition to the code change instructions if you are using the lastactivethread hack.

Download v20010504 for RC2

fastforward 05-04-2001 03:07 AM
I messed up again... I forgot to include the new usenet.php file in the package! I've edited the previous post and changed the version and download link. All should be OK now.

Mark Hewitt 05-04-2001 08:45 AM
When I run newnews.pl I get this

Code:
Fetching article body 64980... OK
Processing article batch...
Use of uninitialized value in numeric gt (>) at newnews.pl line 216.
Use of uninitialized value in concatenation (.) at newnews.pl line 228.
Use of uninitialized value in concatenation (.) at newnews.pl line 228.
Use of uninitialized value in concatenation (.) at newnews.pl line 228.
Use of uninitialized value in concatenation (.) at newnews.pl line 228.
Use of uninitialized value in concatenation (.) at newnews.pl line 228.
Use of uninitialized value in concatenation (.) at newnews.pl line 228.
Use of uninitialized value in concatenation (.) at newnews.pl line 228.

Query failed:
INSERT LOW_PRIORITY IGNORE INTO usenet_ref (msgid,ref,cnt,dtm) VALUES ('<9abt4l$eqr$4@dyfi.aber.ac.uk>','<99pjhv$6tt$1@dyfi.aber.ac.uk>',6+1,),('<9abt4l$eqr$4@dyfi.aber.ac.uk>','<%k2w6.3328$W51.2310054@e3500-chi1.usenetserver.com>',6+1,),('<9abt4l$eqr$4@dyfi.aber.ac.uk>','<3AC0F88A.312BF9B7@crosslink.net>',6+1,),('<9abt4l$eqr$4@dyfi.aber.ac.uk>','<3AC3FEDC.4043@i-plus.net>',6+1,),('<9abt4l$eqr$4@dyfi.aber.ac.uk>','<99vgrr$g0k$2@dyfi.aber.ac.uk>',6+1,),('<9abt4l$eqr$4@dyfi.aber.ac.uk>','<290320010806569457%scott@nospam.winders.com>',6+1,),('<9abt4l$eqr$4@dyfi.aber.ac.uk>','<9a9ehk$5fu$5@dyfi.ab',6+1,)

DBD::mysql::db do failed: You have an error in your SQL syntax near '),('<9abt4l$eqr$4@dyfi.aber.ac.uk>','<%k2w6.3328$W51.2310054@e3500-chi1.usenetse' at line 1 at newnews.pl line 576.
I try running it again until it gets to that particular post and it fails again :( Previous to that though I had imported some posts and was working correctly.

fastforward 05-04-2001 12:05 PM
What's the size and type of your ref column in the usenet_ref table. Try making it bigger.

Mark Hewitt 05-04-2001 12:17 PM
It was varchar(128).

I've tried changing it to varchar(255) but get the same error.

Mark Hewitt 05-04-2001 12:29 PM
If you need to test it the import was
Code:
Getting article batch from rec.motorcycles.racing
Fetching headers of articles 64663 to 64980...

fastforward 05-04-2001 01:04 PM
It' the usenet date/time. It either doesn't exist (unlikely) or it's malformed in the usenet post header. This is one of the reasons I went to local time. Have a look at the article on the server and see what the date looks like. I can't see it as your article numbers mean nothing to my server. As a workround you can add the following code at line immediately above line 216 that reads: if ($dtm > time()+600) { $dtm = time(); }
Code:
if (!$dtm) { $dtm = time(); }
That is an addition, NOT a replacement.

fastforward 05-04-2001 01:09 PM
Note the little change I just made to that change. It should be !$dtm.


All times are GMT. The time now is 11:21 PM.
Page 35 of 69 « First 253334 35 363745 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01890 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete