MySQL error

Discussion in 'Troubleshooting' started by protraffic, Feb 3, 2009.

  1. protraffic

    protraffic New Member

    Joined:
    Feb 3, 2009
    Messages:
    6
    Ok, installed the demo earlier today used it for a bit was impressed, then decided to purchase AMember.

    So I go and delete the demo(found out I didnt have to after) but anyway deleted the demo install and demo database, COMPLTELY recreated and downloaded the pay for version, recreated a new database/user etc.

    I go to setup.php enter my info and get this error. I have been hitting my head against a wall for hours on this. I tried to install the demo version again with a different database and am still getting this error. ANYONE know why this would be happening?

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pro/public_html/newsite/members/setup.php on line 521

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pro/public_html/newsite/members/setup.php on line 521

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pro/public_html/newsite/members/setup.php on line 521

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pro/public_html/newsite/members/setup.php on line 521

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pro/public_html/newsite/members/setup.php on line 521

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pro/public_html/newsite/members/setup.php on line 521

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pro/public_html/newsite/members/setup.php on line 521

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pro/public_html/newsite/members/setup.php on line 521

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pro/public_html/newsite/members/setup.php on line 521
    aMember Installation

    # Duplicate column name 'use_count'
    SQL:

    ALTER TABLE amember_coupon ADD use_count int NOT NULL DEFAULT 0

    Please return and fix these errors.
  2. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    Since you are a pro customer- ask them to do the free install.

    David
  3. protraffic

    protraffic New Member

    Joined:
    Feb 3, 2009
    Messages:
    6
    Well figured it out, my /tmp partition on my dedicated server was full, since I have root access to my server, I deleted the files out and it works now hehe. Took a while to figure out tho.

Share This Page