I just updated mysql and I don't see the missing bracket
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 )