Mysql giving A comma or a closing bracket was expected (near "(" at position 109)
<p>I just updated mysql and I don't see the missing bracket</p>

<pre><code>CREATE TABLE payments 
(   id int(11) NOT NULL, 
    amount int(11) NOT NULL, 
    alloted datetime NOT NULL, 
    dateadded datetime NOT NULL, 
    modified datetime NOT NULL, 
    userid int(11) NOT NULL 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO payments (`amount`,`alotted`, `dateadded`, `modified`, `userid`)
VALUES ( 100, DATE_ADD( NOW(), INTERVAL 6 MONTHS),NOW(),NOW(),139107 )
</code></pre>