Warning: mysql_fetch_row()

Discussion in 'Installation' started by kshoesmith, Oct 8, 2009.

  1. kshoesmith

    kshoesmith New Member

    Joined:
    Aug 7, 2009
    Messages:
    3
    I've been trying for the better part of a day to create a local install of aMember on MAMP.

    I keep getting this message at Step 3 of 4 of the installation process:
    Code:
    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /Applications/MAMP/htdocs/directory/amember/setup.php on line 521
    I can't find an answer here or on Google. Please, tell me what I'm missing.
  2. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    Stupid question I know, but do you have MySQL running? And all of the info to connect to it is valid?

    What version of PHP and MySQL are you running?

    Another consideration is to use XAMPP.. I use it for a lot of testing and have been very happy with it.
  3. kshoesmith

    kshoesmith New Member

    Joined:
    Aug 7, 2009
    Messages:
    3
    It's running, yes. The setup script actually writes several tables to the database before it hangs up.

    I'm running:

    MySQL client version: 5.0.41
    PHP Version 5.2.3

    I used XAMPP on my Windows box. This should work, though, I think I'm just missing something.
  4. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Edit /amember/setup.php and find 521 line:
    Code:
                    while (list($f,$t,$null,$index,$add) = mysql_fetch_row($q)){ 
    
    place one line before it:
    Code:
                    print mysql_error();
                    while (list($f,$t,$null,$index,$add) = mysql_fetch_row($q)){ 
    
    Then when you will run setup next time it should show MySQL error message
    I guess the problem can be in MySQL user permissions.

Share This Page