mysql table creation error in trial installation

Discussion in 'Installation' started by ahmedk, Oct 5, 2011.

  1. ahmedk

    ahmedk New Member

    Joined:
    Oct 5, 2011
    Messages:
    4
    Hi

    i'm trying amember trial I just installed latest XAMP on local xp sp2 with iocube and setup stops at database table creation (i created database) with error :


    -----------------------------
    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:
    ----------------------------

    I searched and couldnt find any solution

    any help?
    thanks
    ahmedk, Oct 5, 2011
    #1
  2. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    Did you create the database first in XAMPP? (localhost/phpmyadmin) ?
    skippybosco, Oct 6, 2011
    #2
  3. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Edit /amember/amember.sql file and search & replace all "timestamp(14)" to "timestamp"
    then run setup again.
    alexander, Oct 7, 2011
    #3
  4. ahmedk

    ahmedk New Member

    Joined:
    Oct 5, 2011
    Messages:
    4
    thank you

    this error was on xamp 1.7.7

    i tried it on a earlier version 1.7.3 other pc and it worked with no error
    ahmedk, Oct 10, 2011
    #4

Share This Page