Crons Don't Install With Mysql_Slave Datatype

When you import the product with mysql_slave as the datatype the product produces an sql error.

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

		UPDATE forums_cron
		SET nextrun = 1187492340
		WHERE cronid = 31 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
Username     : Tech Admin
Classname    : vB_Database_Slave

Works fine with mysql as the datatype.

Try to manually remove <cron> section from vbseo_sitemap.xml product file, install it and create a scheduled task manually.

It's just easier to change the data_type to mysql and then back That way the crons install with the plugin. I just wanted to report it because I didn't know if it was a vbulletin bug or vbseo bug.

hey, i am having this same problem installing 3.2 rc5 , but i don't see a <cron> section, only cron entries. lil help?

There is a section:

HTML Code:

<cron varname="vbseo_serviceupdate"...
</cron>

worked, thanks

just as an update, i had to do this same thing for the sitemap ver 2.2