Error code: ddlexecuteerror

Error code: ddlexecuteerror

Afif Alfauzan - келді
Number of replies: 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.

In reply to 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.

In reply to Leon Stringer

Re: Error code: ddlexecuteerror

Afif Alfauzan - келді


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

In reply to 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
In reply to 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)';

In reply to 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.