ATutor

Learning Management Tools


  1. Home



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


mysql errors on courses



  • 2008-10-01 15:30:15

    mysql errors on courses

    If you are asking for help, provide lots of detail so problems can be reproduced.


    [ statistics_information ]

    [ database ]:
    0.35 [ mb ]
    [ disk_usage ]:
    0.07 [ mb ]
    Courses:
    1
    Users:
    3
    ATutor Version:
    You are currently using ATutor version 1.5.5. To check if a newer version is available use the button below. View the Change Log for this version.
    [ php_version ]:
    5.2.5
    [ mysql_version ]:
    4.1.22-standard
    [ os ]:
    Linux 2.6.9-67.0.22.ELsmp

    -----------------
    URL: http://www.7toolsworkshop.com/tutor

    -------------
    Theme: Corporate_Blue2 - with header modifications.

    ---------
    viewing on firefox
    ----------

    Created 1 test course and getting the following message when I go to the Course Section in the admin login:

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mw300063/public_html/7toolsworkshop.com/tutor/admin/courses.php on line 105

    And "1" course appears, but I cannot access it in anyway?

    I'm getting other mysql errors on the user side as well, as soon as they login.

    ----------

    We did a cpanel installation of atutor from mewebhost.

    Any guidance/suggestions of what we may be doing wrong, or can do to resolve these db errors would be greatly appreciated!

    Thanks,
    Katie


  • 2008-10-01 15:53:21

    Re: mysql errors on courses

    Do you get the same problem with the default theme. Corporate blue is for 1.6+.


  • 2008-10-01 15:59:12

    Re: mysql errors on courses

    Yes, I just changed the theme to Blumin, as default, and I get the same error message.

    Katie


  • 2008-10-01 16:50:17

    Re: mysql errors on courses

    Try the theme called "default"


  • 2008-10-01 16:56:10

    Re: mysql errors on courses

    have you created any courses yet?

    it seesm like it can not access the courses or course_cats tables.

    Have you modified anything?


  • 2008-10-01 17:27:14

    Re: mysql errors on courses

    Thanks.

    I switched to the "default" theme, went to "Browse Courses" and now I have even more errors, as follows:

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mw300063/public_html/7toolsworkshop.com/tutor/include/html/browse.inc.php on line 21

    Warning: Cannot modify header information - headers already sent by (output started at /home/mw300063/public_html/7toolsworkshop.com/tutor/include/html/browse.inc.php:21) in /home/mw300063/public_html/7toolsworkshop.com/tutor/include/header.inc.php on line 17

    Warning: Cannot modify header information - headers already sent by (output started at /home/mw300063/public_html/7toolsworkshop.com/tutor/include/html/browse.inc.php:21) in /home/mw300063/public_html/7toolsworkshop.com/tutor/include/classes/Language/Language.class.php on line 123

    I have not changed anything, or touched anything in the db, if that's what you mean. The only thing I changed was the header image in that Corporate_Blue theme I originally had.

    Katie


  • 2008-10-01 19:00:18

    Re: mysql errors on courses

    Seems to be a general problem connecting to the database. Check the include/config.inc.php file to be sure the mysql login/pass and location are still correct.

    If you changed you site password recently, your mysql password may have also changed.

    In any case, I'd suggest getting upgraded to a more current version of ATutor.


  • 2008-10-01 19:35:34

    Re: mysql errors on courses

    ok Greg,

    Thanks, I'll try to download/install a newer version and then see what happens. This one was autoloaded by our hosting company....so, I may be back! ;)

    Thanks so much.
    K