[fishhub]

Originally Posted by Mudvayne

fishhub try this version. This should also work on vb 3.5.x

thanks, I tried and got this.

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '1', 'Threads started by User: Hourly Cron', 'cron_script_cleanup', '$vbulletin->db->query_write(\"\r\n UPDATE \" . TABLE_PREFIX . \"user AS user \r\n SET user.threads =\r\n (\r\n SELECT COUNT(threadid)\r\n FROM \" . TABLE_PREFIX . \"thread AS thread\r\n LEFT JOIN \" . TABLE_PREFIX . \"forum AS forum ON forum.forumid = thread.forumid \r\n WHERE visible = 1 \r\n AND (forum.options & 4096) \r\n AND user.userid=postuserid\r\n )\r\n\");', 'thread_count_7272');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054