[nimonogi]

Originally Posted by Kriminal

I think it wolud be the same problem: "repeat" could not be a field name in MySQL 5
I finally made a modification to original plugin, changing repeat for repeated everywhere it appears.
PLEASE, backup before using this. It's working for me, but it doesn't means that it would work for everybody.

The installation process was successfull but when i'm trying to Add New Rule i'm getting a mysql error.

Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO ruleshack 
  	  			(forumid, ruletitle, ruletext, ruleurl, firstnewthread, groupids, memberids, userids,
  	  			 usernames, postmore, postless, joindateafter, joindatebefore, 
  	  			 lastactiveafter, lastactivebefore, lastpostafter, lastpostbefore, 
				 conditions, allowbbcode, active, repeated, childforum, newthread, newreply, viewforum, fileurl, exactmatch) 
  	  			 values ('6', 'Text', 'Text[/b]', '', '0', 
  	  			 '2', '', '', '', '0', 
  	  			 '10', UNIX_TIMESTAMP(''), 
  	  			 UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''), 
  	  			 UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''), 
 	  			 UNIX_TIMESTAMP(''), '1', '1', '1', '1', '1', '1', '0', '0', '', 
 	  			 '0');

MySQL Error  : Unknown column 'repeated' in 'field list'
Error Number : 1054
Date         : Friday, September 22nd 2006 @ 05:55:25 AM
Script       : http://www.domain.com/admincp/rulesagreement.php?do=submitrule
Referrer     : http://www.domain.com/login.php?do=login
IP Address   : ***
Username     : ***
Classname    : vb_database