Setup cannot create database

Discussion in 'Troubleshooting' started by jonnywales, Aug 24, 2013.

  1. jonnywales

    jonnywales New Member

    Joined:
    Oct 27, 2007
    Messages:
    11
    I am setting up Amember and get the following error... when it tries to setup Db tables:

    ----------------------------------------------------------------------------



    • 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, url varchar(255) default NULL, remote_addr varchar(15) default ' at line 13
      SQL:

      ###############################################################
      # #
      # aMember MySQL DATABASE DUMP #
      # #
      # This file is to use with amember/setup.php only #
      # It cannot be loaded to MySQL as is. #
      # #
      ###############################################################

      CREATE TABLE amember_access_log(
      log_id int(11) NOT NULL auto_increment,
      member_id int(11) NOT NULL,
      time timestamp(14) NOT NULL,
      url varchar(255) default NULL,
      remote_addr varchar(15) default NULL,
      referrer varchar(255) default NULL,
      PRIMARY KEY (log_id),
      INDEX (member_id, time, remote_addr),
      INDEX (time)
      )

      -----------------------------------------------------------------------------------------------
      Anyone know how to correct this?

      Thanks

      jonny2

Share This Page