ATutor

Learning Management Tools


  1. Home



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


MySQL error



  • 2012-07-12 09:22:01

    MySQL error

    New install, everything appears to be working fine but when I log in as a student or instructor I am getting the following error:

    Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/llygedyn/public_html/lk/mods/_standard/reading_list/module_news.php on line 25

    Things to describe:
    Operating system ATutor is installed on -
    Linux 2.6.32-220.17.1.el6.x86_64
    ATutor version -
    2.0.3(r11495 - 2011-09-13 13:27:29)
    Patch #s applied - Patch ID 1-5 installed
    ATutor theme name - Tried them all no difference
    PHP version - 5.3.13
    MySQL version - 5.1.63-dl

    Screen shot of error
    http://screencast.com/t/5l8GC3bj


  • 2012-07-12 10:06:08

    Re: MySQL error

    This sounds like it might be the result of a corrupted file. Did you unpack ATutor locally, then upload via FTP to the server file-by-file, or did you upload ATutor to the server then unpack it there? The former inevitably breaks files.

    I've looked at the reading list module_new.php file, and tried it. All is in order. Your system specs seem fine, so nothing there that would suggest a problem.


  • 2012-07-12 11:29:25

    Re: MySQL error

    It was installed by Softaculous a feature my host provides through Cpanel. So it sounds like maybe I simply need to remove it and then reinstall it again.

    Will let you know


  • 2012-07-12 12:03:44

    Re: MySQL error

    Ok I have narrowed down the issue to when Path ID 04 is installed.

    It says it "Fixes the issue that the Things Current displays the activities from the courses that the login user is not enrolled in."

    And it changes these:
    /home/llygedyn/public_html/lore/mods/_standard/forums/module_news.php.04.old
    /home/llygedyn/public_html/lore/mods/_standard/reading_list/module_news.php.04.old

    The SQL error occurs after this patch is installed, I installed each patch in order and tested after install and the error occurs after patch ID 04 is installed.


  • 2012-07-12 12:27:34

    Re: MySQL error

    That's not creating the problem for me either. The patch seems fine.

    Do your have Pretty URL turned on in your ATutor System Preferences? If its on, turn it off and see if that make a difference.

    As a last resort you can try copying the module_news.new contents into your module.news.php file manually.

    http://update.atutor.ca/patch/2_0_3/2_0_3-4/module_news.new


  • 2012-07-12 12:56:06

    Re: MySQL error

    The module.new.php you show is exactly the same as the updated one in the patch.

    Everything is default at this point including default theme. Only difference is I created a new user and made them an instructor.

    I made no other changes except to start installing patches


  • 2012-07-12 13:07:00

    Re: MySQL error

    I reverted the one file

    /home/llygedyn/public_html/lore/mods/_standard/reading_list/module_news.php

    Back to previous version and error goes away

    [reply][b]In reply to:[/b]
    The module.new.php you show is exactly the same as the updated one in the patch.

    Everything is default at this point including default theme. Only difference is I created a new user and made them ...
    [op]forums/view.php?fid=7&pid=23289&page=1#23295[/op][/reply]


  • 2012-07-12 13:30:25

    Re: MySQL error

    I can't say why that patch won't work. It's not causing problems elsewhere that we are aware of. We've applied the patch many times ourselves with no trouble.

    I guess if it works with the original file, go with that.

    It would be good to know if Softaculous use the file-by-file ftp method. Are you able to confirm one way or the other?


  • 2012-07-12 13:43:05

    Re: MySQL error

    I am not. Sorry.


  • 2012-09-15 02:04:54

    Re: MySQL error

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

    Things to describe:
    Operating system ATutor is installed on -
    ATutor version -2.0.3
    Patch #s applied -1 to 5
    ATutor theme name -aTutor
    PHP version -5.3.15
    MySQL version - 5.1.63-cll
    Webserver & version - Apache 2.2.22
    Copies of error messages -same as above
    Changes to default settings - just added a test student
    Web browser being used - IE 9
    ...and anything else relevant -
    I reverted back to the old 4 files before the patch and all is well...must be a glitch in #4 patch?