ATutor

Learning Management Tools







Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Warning mysqlfetchassoc


  • 2004-05-06 15:45:10

    Warning mysqlfetchassoc

    Installations works fine without errors but then the following messages appears at login:

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tursidan/public_html/ATutor/include/lib/select_lang.inc.php on line 75

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tursidan/public_html/ATutor/include/classes/ContentManager.class.php on line 63

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tursidan/public_html/ATutor/include/vitals.inc.php on line 126

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tursidan/public_html/ATutor/include/vitals.inc.php on line 162

    Etc. and similar messages. What's the problem?
    I've seen this on another site, I found it when searching with Google.

  • 2004-05-06 15:55:41

    Also tried 1.4, no difference

    Don't know what to do to make this work.

    This is my server configuration:

    http://www.tursidan.se/php/test.php

    And the login is at:

    http://www.tursidan.se/ATutor/login.php

  • 2004-05-07 08:02:28

    Set language to en

    In the include/config.inc.php set the DEFAULT_LANGUAGE constant to "en" to begin with. When you have other language packs installed, then change this value to default to a different language.

  • 2004-05-07 11:20:53

    Already have language "en"

    I haven't changed anything from the default installation, DEFAULT_LANGUAGE is still "en" in include/config.inc.php

    During the installation I had to use chmod on a couple of files. Is this required for other files as well?

  • 2004-05-07 12:27:07

    Broken file maybe

    Remove any spaces after the trailing ?> in file you have opened and saved. Particularly the vitals.inc.php and the config.inc.php files. Be sure your editor is set to use UNIX end of lines

    or

    Try a fresh install.

    Setting permissions is a normal part of a Linux install

    Are you on a hosted system, or a root user.?

    Have you sucessfully used mysql for other purposes?

  • 2004-05-07 14:25:24

    I haven't changed anything

    I've already tried fresh installs a couple of times. The installation works fine and the mysql tables are created OK. I haven't edited any files, only changed the permissions for some files as indicated by the install script. I'm on a hosted system. There were a couple of paths that I didn't fill in during the install, I wasn't sure if they were necessary. Anyway, the install script didn't require them (header/footer file or similar).

  • 2004-11-15 17:37:14

    Having same problem

    I am having the same problem as listed above. Login page has many many errors with:

    mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

    I changed some permissions, but did not alter any php files. Has any resolution been found?

    I am running Php 4.39 on a debian linux box. MySql is remote running 3.23.

    [reply][b]In reply to:[/b]
    I've already tried fresh installs a couple of times. The installation works fine and the mysql tables are created OK. I haven't edited any files, only changed the permissions for some files as indic...
    [op]forums/view.php?fid=7;pid=1601;page=1#1611[/op][/reply]

  • 2004-11-15 18:21:29

    mysql connectivity

    I'd guess your mysql access info in the include/config.inc.php is incorrect. We have not been able to reproduced the problem ourselves.

    a link to a phpinfo page on your server may help.

  • 2004-11-16 10:27:40

    Info

    Here is our php info and login page:

    http://atutor.trexx.net/info.php
    http://atutor.trexx.net/login.php

    I agree it looks like a mysql access issue. The information appears to be correct. I can independantly access the database with the connection info. The database is not on the same physical machine. It is remote.

    Any help would be appreciated.

    [reply][b]In reply to:[/b]
    I'd guess your mysql access info in the include/config.inc.php is incorrect. We have not been able to reproduced the problem ourselves.

    a link to a phpinfo page on your server may help.
    [op]forums/view.php?fid=7;pid=1601;page=1#3069[/op][/reply]

  • 2004-11-16 10:32:02

    additional info

    We are using the same set up for a moodle installation without problem.

  • 2004-11-16 11:16:19

    nightly build or svn?

    Ah! You are using a nightly build or a version out of SVN, neither of which are stable at the moment. If you are using the SVN version you will need to create the config.inc.php file manually before installing, and make it writable by the web server.

    prompt >touch include/config.inc.php
    then
    prompt> chmod a+rwx include/config.inc.php

    There's also a temporary directory call "pub/" (and pub/logs/) that needs to be set to writable for the time being. This directory will be removed with the final release.

    There is a lot in transition at the moment in the live source code. You should probably wait a week or two as we stablize things for the coming release.

    If you just want to see how ATutor works, use the lastest stable release (1.4.2).

    [reply][b]In reply to:[/b]
    We are using the same set up for a moodle installation without problem.
    [op]forums/view.php?fid=7;pid=1601;page=1#3074[/op][/reply]

  • 2004-11-16 11:40:06

    That was it!

    Thank you.