Moodle

I am also getting this PHP warning in the logs:

[19-May-2009 17:13:16] PHP Warning: Illegal offset type in E:\webroot\org\dyndns\cjsoftuk\hosting\chrism\moodle\lib\adodb\adodb.inc.php on line 3008
[19-May-2009 17:13:16] PHP Stack trace:
[19-May-2009 17:13:16] PHP 1. {main}() E:\webroot\org\dyndns\cjsoftuk\hosting\chrism\moodle\index.php:0
[19-May-2009 17:13:16] PHP 2. require_once() E:\webroot\org\dyndns\cjsoftuk\hosting\chrism\moodle\index.php:33
[19-May-2009 17:13:16] PHP 3. include_once() E:\webroot\org\dyndns\cjsoftuk\hosting\chrism\moodle\config.php:316
[19-May-2009 17:13:16] PHP 4. get_config() E:\webroot\org\dyndns\cjsoftuk\hosting\chrism\moodle\lib\setup.php:228
[19-May-2009 17:13:16] PHP 5. get_records() E:\webroot\org\dyndns\cjsoftuk\hosting\chrism\moodle\lib\moodlelib.php:655
[19-May-2009 17:13:16] PHP 6. recordset_to_array() E:\webroot\org\dyndns\cjsoftuk\hosting\chrism\moodle\lib\dmllib.php:863
[19-May-2009 17:13:16] PHP 7. ADORecordSet->GetAssoc() E:\webroot\org\dyndns\cjsoftuk\hosting\chrism\moodle\lib\dmllib.php:705

The result being that even when using a known working database and config from an identical install, it fails to load.

Wow, pretty strange!

I've executed this code both under MacOS X and Linux and seems to work ok:

<?php

    include_once ('config.php');

    $rs = $db->Execute("SHOW LOCAL VARIABLES LIKE 'character_set_database'");
    $records = $rs->GetAssoc(true);

    print_object($records);
?>

And I get perfectly character_set_database => utf8

Unluckily I cannot test it under Windows here.

Can you add this line:

print_object($rs);

bellow this one in your install.php script:

$rs = $db->Execute("SHOW VARIABLES LIKE 'character_set_database'");

and post here results? It's to see how the information is originally being retrieved from DB before any other processing.

Also, can you try to use the 'mysqli' driver instead of the 'mysql' one (or viceversa) to see if it's some sort of problem in the PHP side?

Ciao

Here's the output:

object(ADORecordSet_mysql)[5]
public 'databaseType' => string 'mysql' (length=5)
public 'canSeek' => boolean true
public 'dataProvider' => string 'native' (length=6)
public 'fields' =>
array
'Variable_name' => string 'character_set_database' (length=22)
'Value' => string 'utf8' (length=4)
public 'blobSize' => int 100
public 'sql' => string 'SHOW VARIABLES LIKE 'character_set_database'' (length=44)
public 'EOF' => boolean false
public 'emptyTimeStamp' => string ' ' (length=6)
public 'emptyDate' => string ' ' (length=6)
public 'debug' => boolean false
public 'timeCreated' => int 0
public 'bind' => boolean false
public 'fetchMode' => int 1
public 'connection' =>
object(ADODB_mysql)[4]
public 'databaseType' => string 'mysql' (length=5)
public 'dataProvider' => string 'mysql' (length=5)
public 'hasInsertID' => boolean true
public 'hasAffectedRows' => boolean true
public 'metaTablesSQL' => string 'SHOW TABLES' (length=11)
public 'metaColumnsSQL' => string 'SHOW COLUMNS FROM `%s`' (length=22)
public 'fmtTimeStamp' => string ''Y-m-d H:i:s'' (length=13)
public 'hasLimit' => boolean true
public 'hasMoveFirst' => boolean true
public 'hasGenID' => boolean true
public 'isoDates' => boolean true
public 'sysDate' => string 'CURDATE()' (length=9)
public 'sysTimeStamp' => string 'NOW()' (length=5)
public 'hasTransactions' => boolean false
public 'forceNewConnect' => boolean false
public 'poorAffectedRows' => boolean true
public 'clientFlags' => int 0
public 'substr' => string 'substring' (length=9)
public 'nameQuote' => string '`' (length=1)
public 'compat323' => boolean false
public '_genIDSQL' => string 'update %s set id=LAST_INSERT_ID(id+1);' (length=38)
public '_genSeqSQL' => string 'create table %s (id int not null)' (length=33)
public '_genSeqCountSQL' => string 'select count from %s' (length=23)
public '_genSeq2SQL' => string 'insert into %s values (%s)' (length=26)
public '_dropSeqSQL' => string 'drop table %s' (length=13)
public 'database' => string 'mdl_new' (length=7)
public 'host' => string 'localhost' (length=9)
public 'user' => string 'moodle' (length=6)
public 'password' => string '*******' (length=8)
public 'debug' => boolean false
public 'maxblobsize' => int 262144
public 'concat_operator' => string '+' (length=1)
public 'length' => string 'length' (length=6)
public 'random' => string 'rand()' (length=6)
public 'upperCase' => string 'upper' (length=5)
public 'fmtDate' => string ''Y-m-d'' (length=7)
public 'true' => string '1' (length=1)
public 'false' => string '0' (length=1)
public 'replaceQuote' => string '\'' (length=2)
public 'charSet' => boolean false
public 'metaDatabasesSQL' => string '' (length=0)
public 'uniqueOrderBy' => boolean false
public 'emptyDate' => string ' ' (length=6)
public 'emptyTimeStamp' => string ' ' (length=6)
public 'lastInsID' => boolean false
public 'hasTop' => boolean false
public 'readOnly' => boolean false
public 'genID' => int 0
public 'raiseErrorFn' => boolean false
public 'cacheSecs' => int 3600
public 'memCache' => boolean false
public 'memCacheHost' => null
public 'memCachePort' => int 11211
public 'memCacheCompress' => boolean false
public 'arrayClass' => string 'ADORecordSet_array' (length=18)
public 'noNullStrings' => boolean false
public 'numCacheHits' => int 0
public 'numCacheMisses' => int 0
public 'pageExecuteCountRows' => boolean true
public 'uniqueSort' => boolean false
public 'leftOuter' => boolean false
public 'rightOuter' => boolean false
public 'ansiOuter' => boolean false
public 'autoRollback' => boolean false
public 'fnExecute' => boolean false
public 'fnCacheExecute' => boolean false
public 'blobEncodeType' => boolean false
public 'rsPrefix' => string 'ADORecordSet_' (length=13)
public 'autoCommit' => boolean true
public 'transOff' => int 0
public 'transCnt' => int 0
public 'fetchMode' => int 2
public 'null2null' => string 'null' (length=4)
public '_oldRaiseFn' => boolean false
public '_transOK' => null
public '_connectionID' => resource(1, mysql link)
public '_errorMsg' => boolean false
public '_errorCode' => boolean false
public '_queryID' => resource(2, mysql result)
public '_isPersistentConnection' => boolean false
public '_bindInputArray' => boolean false
public '_evalAll' => boolean false
public '_affected' => boolean false
public '_logsql' => boolean false
public '_transmode' => string '' (length=0)
public 'databaseName' => string 'mdl_new' (length=7)
public '_numOfRows' => int 1
public '_numOfFields' => int 2
public '_queryID' => resource(2, mysql result)
public '_currentRow' => int 0
public '_closed' => boolean false
public '_inited' => boolean true
public '_obj' => null
public '_names' => null
public '_currentPage' => int -1
public '_atFirstPage' => boolean false
public '_atLastPage' => boolean false
public '_lastPageNo' => int -1
public '_maxRecordCount' => int 0
public 'datetime' => boolean false
public 'adodbFetchMode' => int 2

re-wow, so, based in your output... the info is being retrieved properly from DB (see the "fields" array above) both the Variable_name and the Value are there!

And, in the other side, the script I wrote above... what does the print_object($records) return? I guess, wrong data (as it's exactly the same code than the executed at install/setuplib... can you confirm if it also fails?

Also, have you tried both with the mysql and mysqli drivers in config.php

Ciao

There's a simple explanation to the failure:

Here's your output:

array
  '' => 
    array
      'Value' => string 'utf8' (length=4)

That explains why, it just needs an explanation.

mysqli isn't enabled on my server. Enabling it is a pain, not least because I need to find a slot to down the web services, update php.ini and bring everything back up - I think it caused errors last time as well.

Oki, oki. np with the mysqli/mysql thing. I've tested both here and are working ok.

So, summarising:

1) The $rs object contains both the column name and the value.
2) When it's processed by ADOdb/Moodle, it ends ($records object) with the column name lost.
3) you get some warnings in your logs at the same time, originated by adodb\adodb.inc.php on line 3008

Is 1-2-3 correct, yup?

I'm going to review ADOdb code (around those lines to see if I can detect any reason for those column names disappearing). Really strange, really, really!

One more question... have you tried Moodle 1.9.5+ installation, does that work? Just trying to find differences between 1.8 and 1.9... ciao

Oki, I think I've traced the lines when the problem is happening and have created one script to test them in your server.

Can you copy the script below to any file in your main moodle directory and execute it via browser:

<?php

    include_once ('config.php');

    key_and_slice(array('Variable_name' => 'character_set_database',
                        'Value'         => 'utf8'));

    key_and_slice(array('field1' => 'value1',
                        'field2'  => 'value2'));

function key_and_slice($arr) {

    $keys   = array_keys($arr);
    $sliced = array_slice($keys, 1);
    $sliced_array = array();

    foreach ($sliced as $key) {
        $sliced_array[$key] = $arr[$key];
    }

    $results[trim(reset($arr))] = $sliced_array;

    print_object($arr);
    print_object($keys);
    print_object($sliced);
    print_object($results);
}
?>

Here there are the (correct) results I get here:

Array
(
    [Variable_name] => character_set_database
    [Value] => utf8
)
Array
(
    [0] => Variable_name
    [1] => Value
)
Array
(
    [0] => Value
)
Array
(
    [character_set_database] => Array
        (
            [Value] => utf8
        )

)
Array
(
    [field1] => value1
    [field2] => value2
)
Array
(
    [0] => field1
    [1] => field2
)
Array
(
    [0] => field2
)
Array
(
    [value1] => Array
        (
            [field2] => value2
        )

)

Let's see what are you getting to continue tracing the thing... ciao

Here's the results:

array
  'Variable_name' => string 'character_set_database' (length=22)
  'Value' => string 'utf8' (length=4)

array
  0 => string 'Variable_name' (length=13)
  1 => string 'Value' (length=5)

array
  0 => string 'Value' (length=5)

array
  'character_set_database' => 
    array
      'Value' => string 'utf8' (length=4)

array
  'field1' => string 'value1' (length=6)
  'field2' => string 'value2' (length=6)

array
  0 => string 'field1' (length=6)
  1 => string 'field2' (length=6)

array
  0 => string 'field2' (length=6)

array
  'value1' => 
    array
      'field2' => string 'value2' (length=6)

I should point out that print_object was undefined so I substituted var_dump instead, which is using xdebug, hence the slightly funny output.

For reference: in 1.9.5 (latest) the following error is shown on screen:

Warning: reset() [function.reset]: Passed variable is not an array or object in E:\webroot\org\dyndns\cjsoftuk\hosting\mdl19\lib\adodb\adodb.inc.php on line 3011
Call Stack
#	Time	Memory	Function	Location
1	0.0002	47208	{main}( )	..\install.php:0
2	0.2539	612824	form_table( )	..\install.php:724
3	0.2546	612824	check_moodle_environment( )	..\install.php:912
4	0.2779	785368	environment_check( )	..\environmentlib.php:86
5	0.2780	785368	environment_check_unicode( )	..\environmentlib.php:445
6	0.2781	785368	setup_is_unicodedb( )	..\environmentlib.php:729
7	0.2796	785576	ADORecordSet->GetAssoc( )	..\setuplib.php:221
8	0.2796	785648	reset ( )	..\adodb.inc.php:3011

and the Unicode check fails.

I'm seeing this exact same issue on a new Moodle install (1.9.5+ Build 20090610).

Platform: CentOS 5.3
PHP: Zend Community Edition, 5.2.9
MySQL: 5.0.45

MySQLi is installed & activated.

I ran Eloy Lafuente's script - my output matches his exactly.

Thanks for reporting this issue.

We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.

If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

Michael d;

lqjjLKA0p6

I'm closing this issue as it appears to have become inactive and is probably not relevant to a current supported version. If you are encountering this problem or one similar, please launch a new issue.