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

Home » FUDforum » How To » I cant connect to my forum neither to ftp (...after setting a job newsgroup)
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
I cant connect to my forum neither to ftp [message #165672] Thu, 04 August 2011 02:05 Go to next message
zino is currently offline  zino
Messages: 24
Registered: August 2011
Location: Greece
Karma: 0
Junior Member
Today i installed the fud forum but when i created a minute (*/2) job schedule with one newsgroup, i cant connect to forum neither to ftp.
How can i resolve this problem ?
Re: I cant connect to my forum neither to ftp [message #165673 is a reply to message #165672] Thu, 04 August 2011 03:52 Go to previous messageGo to next message
zino is currently offline  zino
Messages: 24
Registered: August 2011
Location: Greece
Karma: 0
Junior Member
The job is for "Minute */2" (i mean for eatch 2 minutes)
Is this correct ?

[Updated on: Thu, 04 August 2011 03:53]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165674 is a reply to message #165673] Thu, 04 August 2011 04:26 Go to previous messageGo to next message
zino is currently offline  zino
Messages: 24
Registered: August 2011
Location: Greece
Karma: 0
Junior Member
I send a ticket to my web host and now i can connect, but the cronjob newsgroup dont run !

see the errors that i receive :

Latest SQL Errors
Time	Error Description
Thu Aug 4 4:19:39 GMT 2011	(/home/zinobios/FUDforum/include/theme/default/db.inc:75
/home/zinobios/FUDforum/include/job.inc:103
/home/zinobios/FUDforum/scripts/cron.php:78
) 1064: 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 'WHERE id = 1' at line 1
Query: UPDATE fud30_jobs SET locked = 1312431579, nextrun = WHERE id = 1
Database version: 5.0.77
[Referring Page] http://zinobios.webfactional.com/adm/admjobs.php?log=1&S=e77bcdc2356afc61cd6994afc90561e5&SQ=7f62fd9fbd99f6467dae5415e52d6e7c&rand=416613021
Thu Aug 4 4:16:56 GMT 2011	(/home/zinobios/FUDforum/include/theme/default/db.inc:75
/home/zinobios/FUDforum/include/job.inc:103
/home/zinobios/FUDforum/scripts/cron.php:78
) 1064: 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 'WHERE id = 1' at line 1
Query: UPDATE fud30_jobs SET locked = 1312431416, nextrun = WHERE id = 1
Database version: 5.0.77
[Referring Page] http://zinobios.webfactional.com/adm/admjobs.php

  Total: 2 error(s). [ clear log ]
Latest Newsgroup Errors
Time	Error Description
Wed Aug 3 21:11:16 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312405880_b8ed67064dc5fed1d50e7d6273e595fb
Wed Aug 3 21:11:16 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312405879_3ad3f3f5ef89a78be1d8e1a18664d2b5
Wed Aug 3 21:11:16 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312405879_f740d267c02552311b78c215e478d24a
Wed Aug 3 21:11:16 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312405879_4b5ab521df3d58f8eab059d51415a569
Wed Aug 3 20:47:12 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312404435_49d8e5f31b6b4966b57c3b711c8d3e0b
Re: I cant connect to my forum neither to ftp [message #165679 is a reply to message #165674] Thu, 04 August 2011 06:25 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
To be honest, it was tested with x,y,x... syntax, but never with x/y.
I'll get back to this later.
Re: I cant connect to my forum neither to ftp [message #165680 is a reply to message #165679] Thu, 04 August 2011 06:44 Go to previous messageGo to next message
zino is currently offline  zino
Messages: 24
Registered: August 2011
Location: Greece
Karma: 0
Junior Member
At the Scheduled jobs , when i click "Run now" the job run correct.
But the Scheduled job dont run by self ** !
I changed the Minute field to : "0,5,10,15,20,25,30,35,40,45,50,5" but the last number is corrupted (55)*. The Scheduled job dont run by self again!

* I want to set the scheduled job run every 3 minutes.This is not possible !

**Why dont run by self ?

[Updated on: Thu, 04 August 2011 06:49]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165681 is a reply to message #165680] Thu, 04 August 2011 09:17 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
It is stored in a VARCHAR(32) and truncated. I'll increase the length before the next release.

Jobs won't run by itself. You need to schedule a cron job or sign up for a scheduling service like setcronjob.com or cronless.com. You can also write a patch/plugin to trigger cron as users visit the site, but that isn't currently implemented. Something you can maybe help us with? Rolling Eyes
Re: I cant connect to my forum neither to ftp [message #165682 is a reply to message #165681] Thu, 04 August 2011 13:55 Go to previous messageGo to next message
zino is currently offline  zino
Messages: 24
Registered: August 2011
Location: Greece
Karma: 0
Junior Member
At the start of nntp.php there is :

#!/usr/bin/php -q


At my cace the PHP CLI Executable is: /usr/local/bin/php (i ran the "which php" shell command to find this)

Need to change the above code with this at the nntp.php ?

 #!/usr/local/bin/php -q


Wait for your answer.

See at the http://cvs.prohost.org/index.php/Job_Administration_System
It say that :
Minute

Minute(s) when the job should run. Multiple values should be comma separated.

For example:

    enter * to run on every minute.
    enter */2 to run it every 2 minutes.
    enter 0,15,30,45 to run it on minutes 0, 15, 30 and 45. 


and it say that :

The Job Manager admin control panel can be used to schedule or run ad hoc tasks like backups, import messages from a mailing list, USENET groups or XML Feeds.

[Updated on: Thu, 04 August 2011 14:28]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165683 is a reply to message #165682] Thu, 04 August 2011 15:12 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Then you will probably have to change it to /usr/local/bin/php.

I've added the */2 example today while I was writing a patch to support it. It will, however, only be available in the next release.
Re: I cant connect to my forum neither to ftp [message #165684 is a reply to message #165683] Thu, 04 August 2011 15:21 Go to previous messageGo to next message
zino is currently offline  zino
Messages: 24
Registered: August 2011
Location: Greece
Karma: 0
Junior Member
The http://cvs.prohost.org/index.php/Job_Administration_System is wrong ?

1)The Job Manager dont work for schedule tasks ?
2)The example dont work for */2 ?
Re: I cant connect to my forum neither to ftp [message #165685 is a reply to message #165684] Thu, 04 August 2011 15:44 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
1) Yes, it does schedule jobs, but only if you have cron set-up. It is confusing, I know, but it is optional and you can still schedule/run your jobs manually without it.

2) Yes, it's wrong! I'm a bad and cruel person, ain't I?
Re: I cant connect to my forum neither to ftp [message #165686 is a reply to message #165685] Thu, 04 August 2011 15:57 Go to previous messageGo to next message
zino is currently offline  zino
Messages: 24
Registered: August 2011
Location: Greece
Karma: 0
Junior Member
I am sorry ! (and sorry for my english !)

Please, can you say me how can i scedule a a nntp job manually ?
The example: ( at http://cvs.prohost.org/index.php/NNTP_Manager )

*/2 * * * * /home/forum/forum/scripts/nntp.php 1

is correct ?
The */2 works ? Or i will have problem ?
What must i write with ssh ? Please write me an example.

[Updated on: Thu, 04 August 2011 15:57]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165687 is a reply to message #165686] Thu, 04 August 2011 16:21 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Yes, it's correct.
And yes, the */2 will work in cron.
You can ask you hosting provider to help you to set-up the job.
Re: I cant connect to my forum neither to ftp [message #165688 is a reply to message #165687] Thu, 04 August 2011 16:30 Go to previous messageGo to next message
zino is currently offline  zino
Messages: 24
Registered: August 2011
Location: Greece
Karma: 0
Junior Member
At the Job Administration, the nntp_1 Scheduled job must be enable or disable, so i can run the external crontab ?
Re: I cant connect to my forum neither to ftp [message #165691 is a reply to message #165688] Thu, 04 August 2011 18:26 Go to previous messageGo to next message
zino is currently offline  zino
Messages: 24
Registered: August 2011
Location: Greece
Karma: 0
Junior Member
I wrote at the crontab this line :

*/3 * * * * /usr/local/bin/php  /home/zinobios/FUDforum/scripts/nntp.php 1 


and works fine !

Please read my other post about the subjects with greek letters...

[Updated on: Thu, 04 August 2011 18:32]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165695 is a reply to message #165691] Thu, 04 August 2011 19:51 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Well done!
Re: I cant connect to my forum neither to ftp [message #166219 is a reply to message #165695] Fri, 14 October 2011 03:22 Go to previous message
shenglu is currently offline  shenglu   China
Messages: 1
Registered: October 2011
Karma: 0
Junior Member
You need to arrange a cron job, or as setcronjob.com or cronless.com dispatch services. When a user accesses the site, you can write a patch / plug-in cron trigger.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Scrunched menu
Next Topic: Reorder User Control Icons
Goto Forum:
  

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

Current Time: Thu Oct 31 22:59:05 GMT 2024

Total time taken to generate the page: 0.04364 seconds