FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Newsgroup importing
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Newsgroup importing [message #4615] Thu, 01 August 2002 10:01 Go to next message
Lupetto is currently offline  Lupetto   Italy
Messages: 9
Registered: July 2002
Karma: 0
Junior Member
I'm tetsting 2.2.4RC2 with nntp functions; i'm not able to import any newsgroup into an existing (but empty) forum becouse i always get this error:

-----------------------------------
query failed: %( INSERT INTO fud21_nntp( forum_id, nntp_post_apr, allow_frm_post, frm_post_apr, allow_nntp_attch, complex_reply_match, server, port, login, pass, timeout, newsgroup, auth ) VALUES( , 'N', 'N', 'N', 'N', 'N', '', 0, '', '', 0, '', 'NONE' ) )% because %( You have an error in your SQL syntax near ' 'N', 'N', 'N', 'N', 'N', '', 0, '', '', 0, '',' at line 17 )%
-------------------------------------

It seems that $this->forum_is is not recognized so the query can't work.

Any ideas?
Thanks
Re: Newsgroup importing [message #4624 is a reply to message #4615] Thu, 01 August 2002 14:21 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You get this error while using the admnntp control panel, while trying to add an NTTP importing rule, or does it happen else where?

FUDforum Core Developer
Re: Newsgroup importing [message #4632 is a reply to message #4624] Thu, 01 August 2002 15:42 Go to previous messageGo to next message
Lupetto is currently offline  Lupetto   Italy
Messages: 9
Registered: July 2002
Karma: 0
Junior Member
It appears only while using the admnntp control panel. Do i have to give more info about my forum configuration ?

Thanks
Re: Newsgroup importing [message #4633 is a reply to message #4632] Thu, 01 August 2002 15:58 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The output of PHPinfo would be useful, the reason I need this info is because I am unable to replicate the problem you are experiencing on my test systems.

FUDforum Core Developer
Re: Newsgroup importing [message #4645 is a reply to message #4633] Thu, 01 August 2002 18:16 Go to previous messageGo to next message
Lupetto is currently offline  Lupetto   Italy
Messages: 9
Registered: July 2002
Karma: 0
Junior Member
Here the steps i follow ti import a newsgroup:
a) create a category to manage all the newsgroup 'd like to import
b) create an empty forum named as the the ng i want to import
c) go to newsgroup manager to make aa correct coinfiguration
d) press the 'add newsgroup rule'
e) get the ** query failed: %( INSERT INTO fud21_nntp( forum_id, nntp_post_apr, allow_frm_post, frm_post_apr, allow_nntp_attch, complex_reply_match, server, port, login, pass, timeout, newsgroup, auth ) VALUES( , 'N', 'N', 'N', 'N', 'N', '', 0, '', '', 0, '', 'NONE' ) )% because %( You have an error in your SQL syntax near ' 'N', 'N', 'N', 'N', 'N', '', 0, '', '', 0, '',' at line 17 )% ** error message
f) maybe i'll attempt a fresh install

Bye
  • Attachment: info.php.html
    (Size: 55.20KB, Downloaded 1224 times)
Re: Newsgroup importing [message #4646 is a reply to message #4645] Thu, 01 August 2002 18:18 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The problem appears to be that NONE of the form's values get imported into the object. Very unusual problem, tell me does your forum work without problems, can you post messages etc...?

FUDforum Core Developer
Re: Newsgroup importing [message #4663 is a reply to message #4646] Fri, 02 August 2002 07:57 Go to previous messageGo to next message
Lupetto is currently offline  Lupetto   Italy
Messages: 9
Registered: July 2002
Karma: 0
Junior Member
yes, i can post messages as usual.

Maybe today i'll try to setup fud in a public server, all my previous attempts were made on my develop pc.
Re: Newsgroup importing [message #4672 is a reply to message #4663] Fri, 02 August 2002 13:31 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
If you can meet me on FUDforum's IRC channel, I am sure we can solve the problem in no time, but it is a little hard to do when we do not have real time communication.

I've tried but not matter what I do I cannot seem to replicate the problem you are having.


FUDforum Core Developer
Re: Newsgroup importing [message #4673 is a reply to message #4672] Fri, 02 August 2002 14:17 Go to previous messageGo to next message
Lupetto is currently offline  Lupetto   Italy
Messages: 9
Registered: July 2002
Karma: 0
Junior Member
Infact everything was very strange, now i've installed FUD on a public web server and i'm able to create importing rule....

In the meanwhile i found a little bug for serevr protected by firewalls; some of them don't allow simple "GET /" request as install.php do. maybe it's enough to change WWW_ROOT_CHECK into something different.

Bye
Re: Newsgroup importing [message #4674 is a reply to message #4673] Fri, 02 August 2002 14:33 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
That is why the check is merely an advisory in the event that GET request fails or the connection cannot be established.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: strange error when accessing FUD
Next Topic: message editor problem
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 20:52:35 GMT 2024

Total time taken to generate the page: 0.02824 seconds