[Code Monkey]

This is such a small but useful mod that I decided to give it away free. This mod will replace your sheduled task image code at the bottom of your pages and run your sheduled tasks via an AJAX...

Click here to read the entire release

[Kihon Kata]

Installed on 3.6!!! Waves to CM!

How do we test this to work properly?

[Code Monkey]

It works. Just empty your cron log and then go back an look at it tommorow.

[Kihon Kata]

Originally Posted by Code Monkey

It works. Just empty your cron log and then go back an look at it tommorow.

yay

[Code Monkey]

Originally Posted by Oblivion Knight

Nominated for MOTM too..

Well, I gues just you and me voted since it didn't make it. LOL

[Eric]

I installed it again for 3.6 and cleaned log, but it is empty for 12 hours now. Does it fill once every 24 hours or should I have already some logs ?

Found that all crons had logging disabled after upgrade, set a few back to yes, now wait..... guess it is all ok

[G_Man]

Originally Posted by Code Monkey

LOL, I don't think it will get enough installs for that. It's one of those apps that people don't get that they need.

Taking your word for it and installed it!!

The forum didn't implode, so.... I guess its all good.

[Kihon Kata]

Yeah mine seems to work good, except for the occasional DB error that I get emailed to me regarding vBajax cron

[Code Monkey]

Those are not from vBajax cron. Those are from scripts vBajax cron is running for you. There are references on this site and in the thread at vBORG on how to fix the bug in the vBulletin script that has the problem.

[Kihon Kata]

Originally Posted by Code Monkey

Those are not from vBajax cron. Those are from scripts vBajax cron is running for you. There are references on this site and in the thread at vBORG on how to fix the bug in the vBulletin script that has the problem.

I guess you're gunna make me hunt those references down. lol

[Code Monkey]

As apposed to me hunting them down? Yes

[testebr]

nice invention

[Code Monkey]

Thanks testebr

[Kihon Kata]

Does the error below still have to do with this? If so, can you point me in the right direction as to the fix?

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT linkid,  name, links.catid, userid, username, dateline, links.lastpostdateline,  title
FROM adv_links AS links
LEFT JOIN adv_links_categories AS categories  USING (catid)
WHERE links.dateline > 1163318449 AND suspended = 0 AND  valid = 1;

MySQL Error  : Column 'valid' in where clause is  ambiguous
Error Number : 1052
Date         : Monday, November 13th 2006 @  12:00:49 AM
Script       : http://www.makeuptalk.com/forums/aja...hp?rand=303218
Referrer      : 
IP  Address   : 125.173.104.124
Username     : Unregistered
Classname    :  vB_Database

[Code Monkey]

Looks like you havs some sort of links script that has a problem. The cron script just runs the other script it doesn't cause or fix the other scripts errors.

[Kihon Kata]

Looks like it's my adv links directory.

[Code Monkey]

I'm thinking maybe "valid" is a reserved word in mysql. Did you upgrade mysql? I heard they added a bunch of reserved words. Try putting `` arround it.

anyway, I have made a new hack thread in the public mods section for this mod since it's a free one so please make all posts there now peeps. I am going to be removing or closing this one.

[NCangler]

Thanks for this CM. I am installing now!

[NCangler]

I installed it. How do you know if its working or not?

[Code Monkey]

it's subtle. As a webmaster you should have the firebug extension installed in Firefox so you can watch AJAX events. Other than that, empty your task log, make sure some things are set to log and then look at the logs.

[vmatt21]

Works great, thanks

[NCangler]

CM, I am running the new vBlogetin forum Blog system, which I ran the first upgrade to Beta 2-5 last night. I had the following error message this morning. Do you think I'll need to uninstall AJAX Cron or should I reinstall? Any insight is most appreciated.

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT user.salt, user.username, user.email, user.languageid, user.usergroupid, user.membergroupids, user.timezoneoffset, usergroup.permissionsField, settings.userid as bloguserid, settings.title as blogtitle, stats.lastentryid, stats.lastprivateentryid, if(user.options & 128, 1, 0) as dstonoff, if(user.options & 8192, 1, 0) as hasaccessmask, entry.title, entry.dateline, entry.categoryid, entry.lastcommentid, entry.lastprivatecommentid, comment.commentid, comment.dateline as lastcomment, subscribeentry.entryid, subscribeentry.subscribeid, subscribeentry.userid
FROM blog_subscribeentry as subscribeentry
LEFT JOIN user as user on (user.userid = subscribeentry.userid)
LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN blog_entry as entry on (entry.entryid = subscribeentry.entryid)
LEFT JOIN blog_settings as settings on (entry.userid = settings.userid)
LEFT JOIN blog_stats as stats on (entry.userid = stats.userid)
LEFT JOIN blog_comment as comment on comment.commentid = if(
entry.lastprivatecommentid > entry.lastcommentid and (
(usergroup.blogCommentPermissions & 2) or
comment.userid = subscribeentry.userid or
entry.userid = subscribeentry.userid
),
entry.lastprivatecommentid,
entry.lastcommentid
)
WHERE subscribeentry.emailupdate = 2 and
comment.dateline > 1164344428 and
entry.deleted = 0 and
entry.visible = 1 and
entry.draft = 0 and
user.usergroupid <> 3 and
(usergroup.genericoptions & 32);

MySQL Error : Unknown column 'usergroup.permissionsField' in 'field list'
Error Number : 1054
Date : Saturday, November 25th 2006 @ 12:03:28 AM
Script : http://www.mysite.com/forums/ajax_cron.php?rand=419691
Referrer : http://www.mysite.com/forums/
IP Address : **.***.***.***
Username : Unregistered
Classname : vb_database