NEXTRUN error on install

[bigsoccer tech]

Got this on the blog install. Looks like it couldn't install the crons properly. Maybe they haven't tested it on a master/slave combination? That would be a type of error you'd see if it didn't replicate an insert query in time before a select.

I uninstalled it. Should I disable replication during install?

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE cron
SET nextrun = 1194145140
WHERE cronid = 33 AND nextrun =;

MySQL Error : 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 '' at line 3
Error Number : 1064
Date : Saturday, November 3rd 2007 @ 08:43:20 PM
Script : *******/forum/admincp/plugin.php?do=productimport (http://www1.bigsoccer.privatedns.com/bigsoccer.com/forum/admincp/plugin.php?do=productimport)
Referrer : *******/forum/admincp/plugin.php?do=productadd (http://www1.bigsoccer.privatedns.com/bigsoccer.com/forum/admincp/plugin.php?do=productadd)
IP Address : 24.226.*****
Username : *****
Classname : vB_Database_Slave_MySQLi

[Steve Machol]

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

[bigsoccer tech]

Unfortunately, I suspect I will be told there that I don't have a standard, out of the box, VB install and won't receive support. Am I incorrect?

This is the offending part of the code (it's part of vb, not the blogs). Really there should be no reason for that "AND nextrun =..." part, cronid is the primary key. (Around line 182 of functions_cron.php)

// save it
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "cron
SET nextrun = " . $nextrun . "
WHERE cronid = " . intval($cronid) . " AND nextrun = " . $crondata['nextrun']
);

We are considering patching it like this:

// save it
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "cron
SET nextrun = " . $nextrun . "
WHERE cronid = " . intval($cronid)
);

From what I can tell it should be fine. Though I want to run it by vb first to make sure it won't break other things.

[bigsoccer tech]

Well it worked for others who are curious.

[Spinball]

I think this error is caused by replicating servers. My host set up a http://nocache.forum.com (passworded) access to bypass the replication and only when I tried an install of a product via this did it work.
Ultimately then this is a vBulletin issue.