[squidsk]

Originally Posted by DiageoLiam

Is there a fix for automation yet? Getting the following when trying to run the scheduled task. Am using the fix posted by another developer a few pages back.

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT userid, award_id, award_cgroup
FROM award_user
WHERE (userid=19005) AND (award_id=7) AND (award_cgroup='postcount');

MySQL Error : Unknown column 'award_cgroup' in 'field list'
Error Number : 1054
Request Date : Monday, June 25th 2012 @ 09:16:10 AM
Error Date : Monday, June 25th 2012 @ 09:16:10 AM
Script : XX/cronadmin.php?do=runcron&cronid=55
Referrer : XX/cronadmin.php?do=modify
IP Address : XX
Username : XX
Classname : vB_Database
MySQL Version : 5.5.23-55

Looking at the xml for automation it looks like you didn't install the automation plugin properly, or there was an error with the installation. The reason I say this is the first thing that should be done by the install script is to add that column to the award_user table. You could try changing line 22 so that ADD award_cgroup instead says ADD COLUMN award_cgroup. If the automation plugin is showing up in your product list I'd uninstall it and re-install it. You'll also need to manually delete the award_automation table if you're doing a re-install since the table is not removed during an uninstall.