ATutor

Learning Management Tools


  1. Home



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


Cant install 22 on new database Upgrade not successful either



  • 2015-02-12 08:34:26

    Cant install 22 on new database Upgrade not successful either

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

    Things to describe:
    Operating system ATutor is installed on - linux
    ATutor version -2.2
    Patch #s applied -
    ATutor theme name -
    PHP version -5.5.19
    MySQL version -4.1.10+
    Webserver & version - apache
    Copies of error messages - on new install - Fatal error: Call to a member function real_escape_string() on a non-object in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 81
    Changes to default settings - no
    Web browser being used - godaddy recommended chrome + safari
    ...and anything else relevant -

    this occurs on upgrade

    Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 18

    Warning: mysqli::set_charset() [mysqli.set-charset]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 20

    Warning: mysqli::real_escape_string() [mysqli.real-escape-string]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 81

    Warning: mysqli::real_escape_string() [mysqli.real-escape-string]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 189

    Warning: mysqli::query() [mysqli.query]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: execute_sql() [function.execute-sql]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: mysqli_affected_rows() [function.mysqli-affected-rows]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 230

    Warning: Invalid argument supplied for foreach() in /home/content/44/5552344/html/isensei/mods/_core/modules/classes/Module.class.php on line 80

    Warning: mysqli::query() [mysqli.query]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: execute_sql() [function.execute-sql]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: mysqli_affected_rows() [function.mysqli-affected-rows]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 230

    Warning: mysqli::query() [mysqli.query]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: execute_sql() [function.execute-sql]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: mysqli_affected_rows() [function.mysqli-affected-rows]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 230

    Warning: mysqli::query() [mysqli.query]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: execute_sql() [function.execute-sql]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: mysqli_affected_rows() [function.mysqli-affected-rows]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 230

    Warning: mysqli::query() [mysqli.query]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: execute_sql() [function.execute-sql]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 215

    Warning: mysqli_affected_rows() [function.mysqli-affected-rows]: Couldn't fetch mysqli in /home/content/44/5552344/html/isensei/include/lib/mysql_connect.inc.php on line 230


    Once the upgrade succeeded

    The following errors occurred:

    ATutor was unable to access the database. If the problem persists, please report this to an Administrator with this date reference (02/12/2015 06:32:15 am)


  • 2015-02-12 09:29:09

    Re: Can't install 2.2 on new database Upgrade not successful either

    Its not something we are able to reproduce so its difficult to say what the problem is. It would take some debugging.

    You can learn about the debug() function in the developer documentation.
    http://help.atutor.ca/developer/guidelines.html#fn-debug


  • 2015-02-12 21:29:54

    Re: Can't install 2.2 on new database Upgrade not successful either

    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 -
    Patch #s applied -
    ATutor theme name -
    PHP version -
    MySQL version -
    Webserver & version -
    Copies of error messages -
    Changes to default settings -
    Web browser being used -
    ...and anything else relevant -

    Greg,

    SInce I cannot install 2.2 I went back to 2.1.1 on the old database but now I get the following error message: Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/content/44/5552344/html/isensei/include/lib/vital_funcs.inc.php on line 683

    Now I know you can't reproduce the problem, but this a fresh install of software that has been working perfectly in the past. I have not changed anything. is the there something that needs to be changed on that line 683?


  • 2015-02-13 09:42:39

    Re: Can't install 2.2 on new database Upgrade not successful either

    The primary change in ATutor 2,2 is the switch to mysqli DB access function, which get run through the main queryDB() function.

    Did you revert to a backup of the database you took before attempting to upgrade?

    It would seem the query is not finding the "customized" field in the themes table. Check to make sure its there.


  • 2015-02-14 20:57:27

    Re: Can't install 2.2 on new database Upgrade not successful either

    I created two new databases on godaddy in mysql 5.5. The php version is 5.3.14. I do not know if godaddy supports mysqli.

    I installed 2.1.1 on one new DB and transferred the old tables to the new database by sql query. This one has the customized field in themes.

    I attempted a 2.2 upgrade on 2.1.1 DB and a fresh install on the blank one. In neither case was it able to complete the process.

    Now I find I cannot create quiz questions or question categories in 2.1.1, except phpmyadmin. It will, however, add the questions to the quiz.

    Another problem I have also had is with the gradebook function in 2.1.1. It no longer enters the grades.

    I have made no changes to the code. I wouldn't know how.

    I only have two courses that use the quiz function. Is it possible on atutorspaces to upload existing db tables? If so, I could put the two courses there. But it's far too much work to go back and recreate all the existing quizzes.


  • 2015-02-16 08:39:52

    Re: Can't install 2.2 on new database Upgrade not successful either

    Greg,

    Due to the lack of mysqli on godaddy regular hosting, I moved over to cpanel, with mysqli, and was able to install 2.2 with no problem.

    Post install, one problem remains. The quiz question maker cannot contact the database to save the quiz questions. I had the same problem before the switch, using 2.1.1. But hadn't discovered it until now because I didn't need to write new quizzes for two years.


  • 2015-02-16 09:13:54

    Re: Can't install 2.2 on new database Upgrade not successful either

    Is it a specific type of question that won't save? Or, all questions?

    Also, can you confirm that when you installed/upgraded, you uploaded the ATutor achived file and unpacked it on the server. Or did you unpack locally and upload the files one-by-one? The latter often produces what seem like random errors like you've described.

    As far as I can tell, the question maker is work properly. Are you able to reprodice the problem on the demo site?

    http://www.atutor.ca/atutor/demo.php

    I'm surprised to hear that Godaddy is not supporting mysqli. It should be available by default after php 4.1. You can also disabled mysqli by commenting out the test for mysqli in the following files:

    https://github.com/atutor/ATutor/blob/master/install/include/common.inc.php#L9-L11

    https://github.com/atutor/ATutor/blob/master/include/lib/vital_funcs.inc.php#L17-L19


  • 2015-02-17 00:45:17

    Re: Can't install 2.2 on new database Upgrade not successful either

    I uploaded the whole thing by zip. I will try unpacking locally and uoloading individual folders, but the upload time is horendous that way.

    Thanks, Greg

    I tried Chamilo due to its greater option of quiz types but came back to atutor because of the learning curve.

    Any plans to increase the quiz types with the next upgrade? I would love to see a machine gradable fill in the blank.


  • 2015-02-17 02:39:31

    Re: Can't install 2.2 on new database Upgrade not successful either

    It appears I am not the only person here having this problem with the test questions. Jim Barnes also complains about it.

    I tried uploading the vitals and test files and reinstalling, but that did not do it. Are there other files that pertain or do I have to upload everything. There are hundreds of file and the server does not take folders unless they are zipped.

    I still get the cannot connect to server message. But changes I make in phpmy admin do show up.

    I have a huge number of questions to input and edit due to a textbook revision and this is a major head ache. I have to pick through the sql file to find what needs changing and it has hundreds of questions in it.


  • 2015-02-17 06:49:19

    Re: Can't install 2.2 on new database Upgrade not successful either

    I was suggesting "not" to upload files one-by-one. It tends to creates errors.

    No current plans to change test.


  • 2015-02-17 17:31:19

    Re: Can't install 2.2 on new database Upgrade not successful either

    In that case the upload isn't the issue because I unpacked on the server originally. But I had to repack it as a zip because godaddy doesn't take tar.bz, though that has never been an issue before. Maybe I need to change hosting companies.

    I never had an issue until I installed 2.2. last summer. Once it was loaded in my database, I began to have problems. Even with a fresh install of 2.1.1, the gradebook didn't recognize quiz grades. It was poppy field of N/A. Then I couldn't write quiz questions. Now, the quiz function says it can't communicate with the database.

    I tried writing questions on atutorspaces and transferring them to my site, but it wouldn't accept the ims file. It never accepts ims files. So what is the good of ims?

    Then yesterday I downloaded the sql file so I could edit all my questions to match a textbook upgrade, and the server wouldn't accept the questions back. Every line seemed to have an sql syntax error, even lines I didn't alter. When I took out the offending line and reran it, it didn't like the line before it. The sql was pristine. Everything its proper color. Nothing out of place. I'm lucky I have two months to fix it. If classes weren't over for the year, I would be screwed.

    It is not a browser issue. I use web standard browsers and none of them make a difference.
    Godaddy is optimized for chrome so that is what I use there. I use safari for everything else.

    I would transfer everything to atutorspaces, but how would I upload the sql files? I can't rewrite the whole database in xml.


  • 2015-02-17 20:24:35

    Re: Can't install 2.2 on new database Upgrade not successful either

    Greg,

    I installed atutor 2.2 on the latest version of MAMP and I still can't create test questions. I get the same error message I get on godaddy. It can't access the database. There has got to be a bug in the download folder somewhere.

    IRT my previous post, it did accept the sql file for the test questions, so I can tell godaddy there is something wrong with their sql server.


  • 2015-02-18 09:15:02

    Re: Can't install 2.2 on new database Upgrade not successful either

    Editing sql files, particularly with window, runs the risk of introducing foreign characters into the file that will break import. Make sure to save file with unix line endings. There should be a setting in your text editor.

    The problem you describe importing ims files, suggest that the permissions on the content directory may not be set correctly. It might explain some of the other issues. Make sure the directory is recursively readable and writable by the web server.

    Normally on linux systems your run something like

    chmod -R 777 content


  • 2015-02-18 17:22:06

    Re: Can't install 2.2 on new database Upgrade not successful either

    I will try that. Thank you.