Getting error during setup

Discussion in 'Installation' started by rmjones, Oct 11, 2011.

  1. rmjones

    rmjones New Member

    Joined:
    Oct 3, 2011
    Messages:
    14
    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
  2. rmjones

    rmjones New Member

    Joined:
    Oct 3, 2011
    Messages:
    14
    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)
  3. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526

Share This Page