Error code: ddlexecuteerror

Error code: ddlexecuteerror

написао/ла Afif Alfauzan -
Број одговора: 8

Please help me

i want to install moodle version 2.9 in my local server using xampp. But in instalation i get a error code ddlexecuteerror.

i'm put the error log in my pastebin https://pastebin.com/XddAP9Q1

Thank's before.

У одговору на Afif Alfauzan

Re: Error code: ddlexecuteerror

написао/ла Leon Stringer -
Слика Core developers Слика Particularly helpful Moodlers

This post describes the cause and solution.

The version of MariaDB is too recent for Moodle 2.9 because MariaDB 10.2.0 (and above) won't allow a column called recursive.

But the database table with that column name – mdl_webdav_locks – is not actually used in Moodle 2.9 so you can edit lib/db/install.xml in Moodle to remove that table before you install:

2178     <TABLE NAME="webdav_locks" COMMENT="Resource locks for WebDAV users">
2179       <FIELDS>
2180         <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
            ⋮
2197         <INDEX NAME="expiry" UNIQUE="false" FIELDS="expiry"/>
2198       </INDEXES>
2199     </TABLE>

Because Moodle 2.9 is old you may encounter other problems with dependencies. This page lists some minimum and maximum versions, although not for Moodle 2.9.

У одговору на Leon Stringer

Re: Error code: ddlexecuteerror

написао/ла Afif Alfauzan -


i'm sorry sir, but after installation complete i get a some error

У одговору на Afif Alfauzan

Re: Error code: ddlexecuteerror

написао/ла Leon Stringer -
Слика Core developers Слика Particularly helpful Moodlers

What version of PHP do you have?

What does your config.php look like? It should start:

<?php  // Moodle configuration file

unset($CFG);
global $CFG;
$CFG = new stdClass();

and end:

require_once(__DIR__ . '/lib/setup.php');

// There is no php closing tag in this file,
// it is intentional because it prevents trailing whitespace problems!

You can attach the config.php file to the reply for us to check but remove passwords and anything else you don't want to share on the Internet.

Can you tell us the exact version of Moodle 2.9? You can check this in $release line in version.php, e.g.:

$release  = '2.9.9+ (Build: 20161129)'; // Human-friendly version name
У одговору на Leon Stringer

Re: Error code: ddlexecuteerror

написао/ла Afif Alfauzan -

My php version is 5.5.19 and mariaDB is 10.2.34

and this is $release variable in my moodle

$release  = '2.9.9+ (Build: 20161129)';

У одговору на Afif Alfauzan

Re: Error code: ddlexecuteerror

написао/ла Leon Stringer -
Слика Core developers Слика Particularly helpful Moodlers

Your config.php looks correct, as expected the $CFG object variable is created on line 5:

  5 $CFG = new stdClass();

C:\xampp\htdocs\moodle\index.php should contain:

 30 require_once('config.php');
 31 require_once($CFG->dirroot .'/course/lib.php');

Which should read config.php then use $CFG, so there should be no "undefined variable" error. Does the index.php contain these two lines? Again you can attach this file you want us to check.