database creation

Discussion in 'Installation' started by Dune, Feb 10, 2004.

  1. Dune

    Dune Guest

    I try to create maunaly database (websetup not working )
    and still have error (same error show up after websetup )

    MySQL said:
    You have an error in your SQL syntax near '@access_log( log_id int(11) NOT NULL auto_increment, member_id

    I try to run:

    CREATE TABLE @DB_MYSQL_PREFIX@access_log(
    log_id int(11) NOT NULL auto_increment,
    member_id int(11) default '0',
    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`)
    )
    ;

    any help appreciate :)
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    It is possible to resolve, but may I ask? Why don't run amember/setup.php? - it will do work for you.
  3. Dune

    Dune Guest

    I run amember/setup.php as first and get same error.
    So I try to create table maunaly but for some reson I had same error as well.
  4. Dune

    Dune Guest

    Maybe I doing something wrong I will try to run setuo.php again
    please correct me if I'm wrong:
    I create database in mySQL name: "amember" so full name of my database :maxout_info_-_amember

    step 2:
    MySQL Host "localhost"
    MySQL Database "amember"

    MySQL Username "xxxxxxxxxx"

    MySQL Password "xxxxxxxxxx"
    MySQL Tables Prefix "maxout_info_-_amember"

    do I make any mistake in step 2?

    Thank you,
  5. Dune

    Dune Guest

    Anyone clould help please ?
  6. Unregistered

    Unregistered Guest

    Muhhha is working .. thx ..
  7. Dune

    Dune Guest

  8. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    of course, it should be
    MySQL Host "localhost"
    MySQL Database "maxout_info_-_amember"

    MySQL Username "xxxxxxxxxx"

    MySQL Password "xxxxxxxxxx"
    MySQL Tables Prefix "amember_"
  9. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
  10. Dune

    Dune Guest

    Looks so great ..
    Little problem still under testing :)

    http://www.maxout.info/amember/signup.php
    once I signup scrip ask me to set "Please select Membership Type"

    In my case I check "free" (green dot) but after when i hit "Continue" i back again to signup with :

    "Please select Membership Type"
  11. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Just add products from aMember CP.

    Please be careful and follow manual.

Share This Page