Skip to main content

HOW-TO:- Solve Moodle 2.7 on MySql 5.7.x Installation

The reason of doing this is I configured my apache for local virtual hosting rather than localhost (available in the next post). I found the error as mentioned below, and I tried different solution to solve it. I did few of the things to solve, they are as follows:
  1. Removed and installed MySQL server.
  2. Installed mysql 5.7v
  3. Installed Moodle 2.7+ stable version 
  4. configured and deleted Moodle config.php few times.
  5. created and deleted database naming moodle(default created when initialized) and few other names.
  6. Gave permission to php5.6 instead of php7.0.2 in Ubuntu 16.04
Here's the Solution, find below lines(183 - 191) or search for "
SELECT @@storage_engine"
and then replace it from "SELECT @@default_storage_engine".

=======Code Snippets(183 - 191):  =======

        // get the default database engine
        $sql = " SELECT @@default_storage_engine";
        $this->query_start($sql, NULL, SQL_QUERY_AUX);
        $result = $this->mysqli->query($sql);
        $this->query_end($result);
        if ($rec = $result->fetch_assoc()) {
            $engine = $rec['@@storage_engine'];
        }
        $result->close();

===============================





Now, run your Moodle installation. It's Working..!



// =============Error while Moodle Installation===========//



Installation





The situations I encountered were 

System





Error reading from database



More information about this error



It is usually not possible to recover from errors triggered during installation, you may need to create a new database or use a different database prefix if you want to retry the installation.





Debug info: Unknown system variable 'storage_engine'
SELECT @@storage_engine
[NULL]
Error code: dmlreadexception



Stack trace:
    

  • line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
    • 

  • line 187 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
    • 

  • line 196 of /lib/ddl/mysql_sql_generator.php: call to mysqli_native_moodle_database->get_dbengine()
    • 

  • line 248 of /lib/ddl/sql_generator.php: call to mysql_sql_generator->getCreateTableSQL()
    • 

  • line 409 of /lib/ddl/database_manager.php: call to sql_generator->getCreateStructureSQL()
    • 

  • line 364 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
    • 

  • line 1498 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
    • 

  • line 233 of /admin/index.php: call to install_core()
    • 























































Comments











Post a Comment






























Popular posts from this blog



















GraphQL vs REST




























  GraphQL   GraphQL is an application layer server-side technology which is developed by Facebook for executing queries with existing data. GraphQL can optimize RESTful API calls. It gives a declarative way of fetching and updating your data. GraphQL helps you to load data from server to client. It enables programmers to choose the types of requests they want to make. REST REST is a software architectural style that defines a set of constraints for creating web services. It is designed specifically for working with media components, files, or hardware device. The full form of REST is Representational State Transfer. ========================================================= Here is the important difference between GraphQL and REST. GraphQL REST GraphQL is an application layer server-side technology which is developed by Facebook for executing queries with existing data. REST is a software architectural style that defines a set of constraints for creating Web services. It follow...




















Post a Comment









Read more




























DBMS ACID Properties




























 1. Atomicity states that database modifications must follow an all or nothing rule 2. Consistency states that only valid data will be written to the database. If, for some reason, a transaction is executed that violates the database's consistency rules, the entire transaction will be rolled back and the database will be restored to a state consistent with those rules.  3. Isolation requires that multiple transactions occurring at the same time not impact each other's execution. For example, if Joe issues a transaction against a database at the same time that Mary issues a different transaction, both transactions should operate on the database in an isolated manner. The database should either perform Joe's entire transaction before executing Mary's or vice-versa. 4.  Durability ensures that any transaction committed to the database will not be lost. Durability is ensured through the use of database backups and transaction logs that facilitate the restoration of committe...




















Post a Comment









Read more




























Git Commands




























  Git commands sorted. Reference:   https://git-scm.com/docs Git task Notes Git commands Tell Git who you are Configure the author name and email address to be used with your commits. Note that Git strips some characters  (for example trailing periods) from user.name . git config --global user.name "Sam Smith" git config --global user.email sam@example.com Create a new local repository   git init Check out a repository Create a working copy of a local repository: git clone /path/to/repository For a remote server, use: git clone username@host:/path/to/repository Add files Add one or more files to staging (index): git add <filename> git add * Commit Commit changes to head (but not yet to the remote repository): git commit -m "Commit message" Commit any files you've added with git add , and also commit any files you've changed since then: git commit -a Push Send changes to the master branch of your remote repository: git push origin master Status List the...




















Post a Comment









Read more