I am getting the following error. Not sure what this means. near '(14) NOT NULL, PRIMARY KEY (payment_id), KEY member_id (member_id) )' at line 16 SQL: How do I fix this. I am using MAMP 2.0.3 on a MacBookPro
additional info Here is the complete error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, PRIMARY KEY (payment_id), KEY member_id (member_id) )' at line 16 SQL: # Table structure for table 'payments' # CREATE TABLE amember_payments ( payment_id int(11) NOT NULL auto_increment, member_id int(11) NOT NULL , product_id int(11) NOT NULL , begin_date date NOT NULL , expire_date date NOT NULL , paysys_id varchar(32) NOT NULL default '', receipt_id varchar(32) NOT NULL default '', amount decimal(12,2) NOT NULL default '0.00', completed smallint(6) default '0', remote_addr varchar(15) NOT NULL default '', data text, time timestamp(14) NOT NULL, PRIMARY KEY (payment_id), KEY member_id (member_id)