vb.org Archive - NNTP Gateway (Usenet/Newsgroups)

Page 98 of 99

« First

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)

- - NNTP Gateway (Usenet/Newsgroups) (https://vborg.vbsupport.ru/showthread.php?t=35247)

hubba

05-14-2004 12:28 AM

for me it works just fine... just a question for the crontab: Has to be a Carriage Return at the ent of the line in the crontab.txt?

Edit: Ist has :rolleyes:

lierduh

05-14-2004 12:52 AM

Thanks. Looks like that SQL only works with MySQL 4.

Please download the new version. I have got rid of this section of code altogether.

Quote:

Originally Posted by allan grossman

Output from the manual query -

==========

Error

SQL-query :

UPDATE post,
thread SETpost.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post.isusenetpost = 0 AND thread.forumid NOT IN ( 25, 27, 29, 34 )

MySQL said:

You have an error in your SQL syntax near ' thread SET post.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post' at line 1

==========

MySQL version is 3.23

lierduh

05-14-2004 01:17 AM

Quote:

Originally Posted by Imhotep

installed registry patch from M$, ran setlastmsg.php and got...

Use this modified one. Delete this file after installation!

Imhotep

05-14-2004 06:34 PM

thank you sir! that new file did the trick.

I have a new error now. lol :)

Code:

Database error in vBulletin 3.0.1:



Invalid SQL: UPDATE post 

SET attach=attache + 1 WHERE postid=25711

mysql error: Unknown column 'attache' in 'field list'



mysql error number: 1054



Date: Friday 14th of May 2004 12:20:03 PM

Script: http://

Referer: 

Username: Unregistered

IP Address:

I'm getting this once per hour as my crontab runs.

hmmm... :ermm:

allan grossman

05-14-2004 08:42 PM

Quote:

Originally Posted by lierduh

Thanks. Looks like that SQL only works with MySQL 4.

Please download the new version. I have got rid of this section of code altogether.

That worked. Everything's going swimmingly now, lierduh - thanks :)

allan grossman

05-14-2004 08:48 PM

lierduh, there's a typo in your SQL query for the upgrade from May 12 script - the two-line query at the bottom of the post -

"hohor_no-archive" should read "honor_no-archive"

I fixed my database but others might not have seen it.

cheers -

allan

Imhotep

05-14-2004 11:16 PM

I think we should start another thread... lol

Any thoughts on this new error?

Quote:

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE post
SET attach=attache + 1 WHERE postid=25715 mysql error: Unknown column 'attache' in 'field list'

mysql error number: 1054

Date: Friday 14th of May 2004 04:20:11 PM
Script: http://
Referer:
Username: Unregistered
IP Address

PHP version 4.3.3

Running latest files posted.

allan grossman

05-14-2004 11:34 PM

Quote:

Originally Posted by Imhotep

I think we should start another thread... lol

Any thoughts on this new error?

PHP version 4.3.3

Running latest files posted.

Change line 353 in gateway.php

from

SET attach=attache + 1 WHERE postid=$postid");

to

SET attach=attach + 1 WHERE postid=$postid");

lierduh

05-15-2004 12:23 AM

Thanks Allan.

I will upload the file with the typos corrected shortly.

I have received permission from Gilby allowing me to release this hack under the vB3 section of the forums. So I will create a thread there in the next one or two days. That should make the support easier.

allan grossman

05-15-2004 12:35 AM

Quote:

Originally Posted by lierduh

No - thank you, lierduh - you've really gone above and beyond.

cheers -

allan

All times are GMT. The time now is 10:40 AM.

Page 98 of 99

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02281 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 (1)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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
Messages: