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.