Errore DB importazione corso

Errore DB importazione corso

di Lorenzo Greco -
Numero di risposte: 10

incollo qui gli errori che vedo con il debug durante l'importazione dei corsi


Error: mdb->get_record() found more than one record!


    line 1583 of /lib/dml/moodle_database.php: call to debugging()

    line 1644 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()

    line 4493 of /backup/moodle2/restore_stepslib.php: call to moodle_database->get_field_sql()

    line 137 of /backup/util/plan/restore_structure_step.class.php: call to restore_create_categories_and_questions->process_question_hint()

    line 112 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()

    line 178 of /backup/util/xml/parser/processors/grouped_parser_processor.class.php: call to restore_structure_parser_processor->dispatch_chunk()

    line 100 of /backup/util/helper/restore_structure_parser_processor.class.php: call to grouped_parser_processor->postprocess_chunk()

    line 148 of /backup/util/xml/parser/processors/simplified_parser_processor.class.php: call to restore_structure_parser_processor->postprocess_chunk()

    line 92 of /backup/util/xml/parser/processors/progressive_parser_processor.class.php: call to simplified_parser_processor->process_chunk()

    line 190 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()

    line 278 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->publish()

    line ? of unknownfile: call to progressive_parser->end_tag()

    line 179 of /backup/util/xml/parser/progressive_parser.class.php: call to xml_parse()

    line 158 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->parse()

    line 110 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()

    line 181 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()

    line 178 of /backup/util/plan/base_plan.class.php: call to base_task->execute()

    line 167 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()

    line 339 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()

    line 188 of /backup/import.php: call to restore_controller->execute_plan()



Moodle 3.4.5

mariadb (5.5.5-10.1.36-MariaDB)

dbcollation => 'utf8mb4_unicode_ci'

PHP 7.2.11

Onestamente non so da cosa siano stati causati questi problemi, ma probabilmente partono da quando cambiando hosting ho fatto l'upgrade del database ad INNODB e trasformato in utf8mb4

lanciando php mysql_collation.php -l dentro admin/cli ho tutto
utf8mb4_unicode_ci quindi tutto regolare.


Premetto che ho anche dovuto correggere degli errori dentro la tabella MDL_question praticamente durante gli importa creava una marea di record con qtype = random e campo stamp duplicato un sacco di volte.

Did you remember to make the first column something unique in your call to get_records? Duplicate value 'VALORI PRESENTI DI STAMP + VERSION CHE VI STO NASCONDENDO' found in column 'concat(stamp, ' ', version)'.

probabilmente gli errori nella tabella MDL_questions derivavano dal fatto che ho lavorato alcuni giorni senza specificare nel file di configurazione di moodle questo dbcollation => 'utf8mb4_unicode_ci'


Ora però non riesco a capire su quale punto del DB trovi errori

La procedura di importazione da un corso ad un altro va lentamente a buon fine, ma con tutti gli errori ripetuti una marea di volte.

nel file my.cnf ho anche fatto tutte queste procedure

[client] default-character-set = utf8mb4 [mysqld] innodb_file_format = Barracuda innodb_file_per_table = 1 innodb_large_prefix character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci skip-character-set-client-handshake [mysql] default-character-set = utf8mb4


Sto uscendo pazzo....



Media dei voti:  -
In riposta a Lorenzo Greco

Re: Errore DB importazione corso

di Matteo Scaramuccia -

Ciao Lorenzo,
non credo che il problema sia nato dalla collation modificata: probabilmente già prima usavi UTF-8 (a 3 byte) e hai "solo" allargato il supporto su MySQL a quella parte di carattteri che richiedono 4 o più bytes per essere rappresentati.

Il problema sulle domande deve essere stato generato da qualcos'altro: comprendo che possa essere complesso provare a risistemare il DB.
Sul Tracker stanno lavorando a provare a risolvere alcune inconsistenze che si generano nel tempo ma non trovo nulla per il tuo caso: MDL-54724, MDL-60897 e MDL-63260 .

Purtroppo temo che tu debba indagare a fondo il contenuto del file di backup di Moodle (è uno archivio compresso, zip), in particolare esaminando il file XML contenuto in esso, dove sono scritte molte informazioni da ripristinare e quanto si trova su database recuperando la query di cui al https://github.com/moodle/moodle/blob/28f6460de388d77d95112e58463c04e69be5e208/backup/moodle2/restore_stepslib.php#L4488 perché è "così" che troverai tutti i duplicati che sono stati generati.

HTH,
Matteo

Media dei voti:  -
In riposta a Matteo Scaramuccia

Re: Errore DB importazione corso

di Lorenzo Greco -

Allora, ho cercato di analizzare l'XML ma dentro moodle_backup.xml a rapido sguardo non ho trovato nulla di incoerente e poi è un file di 33.236,

mentre quello che mi ha stupito è il file questions.xml di dimensioni esagerate 35940104  guardando dentro vedo una marea di domande che non sono riportate nel quiz dentro quel corso.

è bene precisare che è possibile prendere le domande anche da categorie generali, nessun corso usa domande nel suo deposito di DEFAULT.


Media dei voti:  -
In riposta a Lorenzo Greco

Re: Errore DB importazione corso

di Matteo Scaramuccia -

Ciao Lorenzo,
la dimensione del file questions.xml non è un problema di per se: dovresti riproporre la query che incontra le domande duplicate su DB - magari loggandola (MySQL, per esempio: https://stackoverflow.com/a/20485975/6142224) - per sbloccare questo tuo problema molto probabilmente non sul contenuto del backup ma sullo stato del tuo DB.

HTH,
Matteo

Media dei voti:  -
In riposta a Matteo Scaramuccia

Re: Errore DB importazione corso

di Lorenzo Greco -

allora vediamo se ho capito

lavoro nella tabella questions_hint

e faccio questa query   ( il risultato sono 27 righe nell'immagine)


SELECT 

`id`

`questionid`, COUNT(`questionid`),

`hint`, COUNT(`hint`),

`hintformat`, COUNT(`hintformat`),

    `shownumcorrect`, COUNT(`shownumcorrect`),

    `clearwrong`,  COUNT(`clearwrong`),

    `options`, COUNT(`options`)

FROM `PREFIX_question_hints` 

GROUP BY 

`questionid`,

`hint`,

`hintformat`,

`shownumcorrect`,

`clearwrong`

HAVING COUNT(`questionid`) >1

AND count(`hint`) >1

AND COUNT(`hintformat`) >1

and COUNT(`shownumcorrect`) >1

AND COUNT(`clearwrong`) >1;


sarebbero i duplicati da cancellare?

Allegato duplicati.png
Media dei voti:  -
In riposta a Lorenzo Greco

Re: Errore DB importazione corso

di Lorenzo Greco -

anche cancellando i duplicati in questions_hints rimane sempre l'errore in debug  ( in un importa è ripetuto 156 volte)


Error: mdb->get_record() found more than one record!


    line 1583 of /lib/dml/moodle_database.php: call to debugging()

    line 1644 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()

    line 4493 of /backup/moodle2/restore_stepslib.php: call to moodle_database->get_field_sql()

    line 137 of /backup/util/plan/restore_structure_step.class.php: call to restore_create_categories_and_questions->process_question_hint()

    line 112 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()

    line 178 of /backup/util/xml/parser/processors/grouped_parser_processor.class.php: call to restore_structure_parser_processor->dispatch_chunk()

    line 100 of /backup/util/helper/restore_structure_parser_processor.class.php: call to grouped_parser_processor->postprocess_chunk()

    line 148 of /backup/util/xml/parser/processors/simplified_parser_processor.class.php: call to restore_structure_parser_processor->postprocess_chunk()

    line 92 of /backup/util/xml/parser/processors/progressive_parser_processor.class.php: call to simplified_parser_processor->process_chunk()

    line 190 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()

    line 278 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->publish()

    line ? of unknownfile: call to progressive_parser->end_tag()

    line 179 of /backup/util/xml/parser/progressive_parser.class.php: call to xml_parse()

    line 158 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->parse()

    line 110 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()

    line 181 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()

    line 178 of /backup/util/plan/base_plan.class.php: call to base_task->execute()

    line 167 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()

    line 339 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()

    line 188 of /backup/import.php: call to restore_controller->execute_plan()

Media dei voti:  -
In riposta a Lorenzo Greco

Re: Errore DB importazione corso

di Matteo Scaramuccia -

Ciao Lorenzo,
la query che fallisce nel codice indicato dallo stack trace è la seguente:

            // Look in question_hints by hint text matching
            $sql = 'SELECT id
                      FROM {question_hints}
                     WHERE questionid = ?
                       AND ' . $DB->sql_compare_text('hint', 255) . ' = ' . $DB->sql_compare_text('?', 255);
            $params = array($newquestionid, $data->hint);
            $newitemid = $DB->get_field_sql($sql, $params);

Prova a loggare le query da Moodle modificando il codice di cui sopra mettendo in debug "la connessione Moodle" al DB:

           $DB->set_debug(true);
           $newitemid = $DB->get_field_sql($sql, $params);
           $DB->set_debug(false);

Così almeno abbiamo 156 casi reali da esaminare uno per uno per capire quale sia il reale problema di queste "presunte duplicazioni".

HTH,
Matteo

Media dei voti:  -
In riposta a Matteo Scaramuccia

Re: Errore DB importazione corso

di Lorenzo Greco -

Matteo Grazie,  ho aggiunto il debug  nella posizione che mi hai indicato, lo ho fatto, ma non riesco a trovare dove dovrebbe essere il log.

ho esaminato i log del backup del corso ma non ci sono errori

il file error_log dentro la cartella di installazione

il file /var/log/apache2/error_log

il file cartella_di_installazione/backup/error_log

il file /var/log/mysql_error_log


Ti premetto che ho notato 2 differenze sostanziali:

se faccio un backup di un corso, lo scarico in locale e lo analizzo fila tutto liscio, infatti lo fa velocemente, mentre se :

creo un corso chiamato A ed importo i contenuti di un altro corso esistente chiamato MODELLO allora ho gli errori di debug a video

ti allego il file zip del copia incolla che ho fatto degli errori a video ( perchè quando l'importa arriva a termine la finestra degli errori scompare)


ed ecco qui invece il 

moodle_backup_log  ( dal file di backup)

[ven 26 ott 2018 12:55:33 CEST] [info] instantiating backup controller 8d00dc0518baac7bead68bda8f4af72d

[ven 26 ott 2018 12:55:33 CEST] [debug] setting controller status to 100

[ven 26 ott 2018 12:55:33 CEST] [debug] loading controller plan

[ven 26 ott 2018 12:55:33 CEST] [debug] setting controller status to 300

[ven 26 ott 2018 12:55:33 CEST] [debug] applying plan defaults

[ven 26 ott 2018 12:55:33 CEST] [debug] setting controller status to 400

[ven 26 ott 2018 12:55:33 CEST] [debug] setting file inclusion to 1

[ven 26 ott 2018 12:55:33 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:33 CEST] [debug] setting controller status to 500

[ven 26 ott 2018 12:55:33 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:33 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:33 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:33 CEST] [debug] saving controller to db

[ven 26 ott 2018 12:55:33 CEST] [debug] calculating controller checksum b6f6045bc687882b54a13849b5dac31a

[ven 26 ott 2018 12:55:35 CEST] [debug] loading controller from db

[ven 26 ott 2018 12:55:35 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:35 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:35 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:35 CEST] [debug] saving controller to db

[ven 26 ott 2018 12:55:35 CEST] [debug] calculating controller checksum b6f6045bc687882b54a13849b5dac31a

[ven 26 ott 2018 12:55:40 CEST] [debug] loading controller from db

[ven 26 ott 2018 12:55:40 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:40 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:40 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:40 CEST] [debug] saving controller to db

[ven 26 ott 2018 12:55:40 CEST] [debug] calculating controller checksum b6f6045bc687882b54a13849b5dac31a

[ven 26 ott 2018 12:55:56 CEST] [debug] loading controller from db

[ven 26 ott 2018 12:55:56 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:56 CEST] [info] checking plan security

[ven 26 ott 2018 12:55:56 CEST] [debug] setting controller status to 700

[ven 26 ott 2018 12:55:56 CEST] [debug] saving controller to db

[ven 26 ott 2018 12:55:56 CEST] [debug] calculating controller checksum 8b7c8947c79e77dc2efa49cb86d2d604

[ven 26 ott 2018 12:55:57 CEST] [debug] loading controller from db

[ven 26 ott 2018 12:55:57 CEST] [debug] setting controller status to 800

Media dei voti:  -
In riposta a Lorenzo Greco

Re: Errore DB importazione corso

di Matteo Scaramuccia -

Ciao Lorenzo,
in realtà da quanto hai allegato la query SQL viene stampata come ti indicavo, quindi per trovare le istanze di query "colpevoli" puoi fare qualcosa del tipo:

$ grep "found more than one record" -B 1 errori\ su\ importa.txt | sed -e 's/Query took:.*seconds.$//g' -e 's/^Error:.*$//' | sort | uniq

--
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1005', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1018', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1032', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '10423', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '10429', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1045', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1056', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1062', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1068', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1079', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1090', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1101', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1102', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1118', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1124', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1130', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1141', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '115', 1 => '<p>Troppo presto per darti la soluzione..... cancello le domande errate, tenta ancora.</p>', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1152', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1163', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1174', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1190', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '11916', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1198', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1205', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1217', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1228', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1239', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1250', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1268', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1274', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1280', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1286', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1295', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1303', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1314', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1326', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '13356', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1343', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1359', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1375', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1392', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1403', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1414', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '14235', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1425', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1436', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1447', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1458', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1464', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1465', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1476', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1516', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1541', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1547', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1553', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1559', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1565', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1571', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1577', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1583', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1589', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1611', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1617', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1663', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1699', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '17392', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '17408', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '17419', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '17430', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '17436', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '17437', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '17448', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1807', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '182', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1829', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1849', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '18750', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '188', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1941', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1953', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1968', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1974', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1980', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1986', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '19894', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '199', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '1995', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '200', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2003', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2004', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2015', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2026', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2032', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '20363', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2038', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2044', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2053', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2061', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2062', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2073', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2086', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '2143', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '215', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '216', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '237', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '239', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '241', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '242', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '249', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '256', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '259', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '260', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '262', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '263', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '264', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '274', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '281', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '288', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '296', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '297', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '304', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '312', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '313', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '314', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '320', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '321', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '322', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '323', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '324', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '330', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '331', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '341', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '342', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '361', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '372', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '378', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '384', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '385', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '386', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '392', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '398', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '400', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '406', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '412', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '413', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '414', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '415', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '416', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '417', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '418', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '424', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '471', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '477', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '478', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '479', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '486', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '496', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '497', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '503', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '506', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '513', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '514', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '539', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '540', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '541', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '542', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '543', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '544', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '545', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '547', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '549', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '550', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '551', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '553', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '555', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '562', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '568', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '569', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '570', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '571', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '573', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '574', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '581', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '587', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '588', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '594', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '600', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '601', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '602', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '603', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '609', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '615', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '616', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '617', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '618', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '619', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '620', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '626', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '637', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '638', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '644', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '645', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '645', 1 => '<p><strong>9   tell a story in an engaging way</strong></p> <p>1 e   2 b   3 a   4 c   5 d</p>', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '648', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '649', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '657', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '664', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '670', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '676', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '676', 1 => '<p>1 c   2 b   3 d   4 c   5 b</p>', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '677', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '678', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '689', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '695', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '696', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '697', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '698', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '704', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '710', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '711', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '717', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '723', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '724', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '725', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '726', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '732', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '733', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '739', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '745', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '751', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '757', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '763', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '764', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '770', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '776', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '777', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '778', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '784', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '792', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '798', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '800', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '806', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '812', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '818', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '824', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '831', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '832', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '838', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '839', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '840', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '846', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '852', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '858', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '864', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '865', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '866', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '867', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '873', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '879', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '885', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '891', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '892', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '898', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '904', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '905', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '911', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '917', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '923', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '924', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '930', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '931', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '937', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '938', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '944', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '945', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '951', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '952', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '958', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '964', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '965', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '979', 1 => '', )]
SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '992', 1 => '', )]

Qundi potresti iniziare a prendere un log di query a caso ad esempio:

SELECT id FROM blab_question_hints WHERE questionid = ? AND hint = ? [array ( 0 => '992', 1 => '', )]

e lanciarla sul DB come:

SELECT id FROM blab_question_hints WHERE questionid = 992 AND hint = ''

per verificare che effettivamente ti ritorni più di un risultato e quindi iniziare a capire come mai ci sia più di una corrispondenza.

HTH,
Matteo

Media dei voti:  -
In riposta a Matteo Scaramuccia

Re: Errore DB importazione corso

di Lorenzo Greco -

Matteo Grazie di cuore in effetti il record è parzialmente ripetuto ma non è identico

i campi nella tabella sono:

id   questionid  hint  hintformat shownumcorrect  clearwong  options
396  992                         1                     1                          0                    NULL
397  992                          1                     1                          1                   NULL

i record differiscono per il campo clearwrong,  
Non conosco bene le relazioni delle tabelle moodle, ma avevo capito che fossero 2 impostazioni diverse per lo stesso tipo di domanda riportata in più test.


Media dei voti:  -
In riposta a Lorenzo Greco

Re: Errore DB importazione corso

di Matteo Scaramuccia -

Ciao Lorenzo,
temo di no: non ho una grossa esperienza di quiz "nativi" in Moodle ma dal fatto che il codice consideri nella fase di restore, come chiave, il solo id della domanda (questionid) e l'hint mi fa pensare che non sia possibile avere la stessa domanda con le due impostazioni.

Non c'è traccia da nessuna parte di un eventuale problema o bug sul Tracker quindi non saprei consigliarti altro che, in un sistema di test, provare ad eliminare tutte le domande "doppioni" facendo considerazioni se vuoi o non vuoi l'opzione clearwrong attiva.

Puoi provare a sintetizzare questo thread in una domanda sulla Community Inglese: https://moodle.org/mod/forum/view.php?id=737 per ricevere qualche feedback in più, cercando di "catturare" l'attenzione di uno dei moderatori, Tim Hunt.

HTH,
Matteo

Media dei voti:  -