Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-22503

DDL sql execution error upon 1.9 to 2.0 migration

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Administration
    • Labels:
      None
    • Database:
      MySQL
    • Difficulty:
      Easy
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      According to the discussion http://moodle.org/mod/forum/discuss.php?d=150223, following the result of the SQL query suggested by Eloy:

      – phpMyAdmin SQL Dump
      – version 2.11.8.1deb5+lenny4
      http://www.phpmyadmin.net

      -- Host: 192.168.1.12
      – Generato il: 18 Mag, 2010 at 06:58 PM
      – Versione MySQL: 5.0.51
      – Versione PHP: 5.2.13-0.dotdeb.1

      SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


      -- Database: `moodle20`

      – --------------------------------------------------------


      -- Struttura della tabella `mdl_block_instances`

      CREATE TABLE IF NOT EXISTS `mdl_block_instances` (
      `id` int(10) NOT NULL auto_increment,
      `blockid` int(10) NOT NULL default '0',
      `blockname` varchar(40) collate utf8_unicode_ci default NULL,
      `contextid` bigint(10) unsigned default NULL,
      `showinsubcontexts` smallint(4) default NULL,
      `pageid` int(10) NOT NULL default '0',
      `pagetypepattern` varchar(20) collate utf8_unicode_ci NOT NULL default '',
      `subpagepattern` varchar(16) collate utf8_unicode_ci default NULL,
      `defaultregion` varchar(16) collate utf8_unicode_ci NOT NULL default '',
      `defaultweight` smallint(3) NOT NULL default '0',
      `visible` tinyint(1) NOT NULL default '0',
      `configdata` text collate utf8_unicode_ci,
      PRIMARY KEY (`id`),
      KEY `pageid` (`pageid`),
      KEY `pagetype` (`pagetypepattern`),
      KEY `mdl_blocinst_blo_ix` (`blockid`)
      ) Engine=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4788 ;


      -- Dump dei dati per la tabella `mdl_block_instances`

      INSERT INTO `mdl_block_instances` (`id`, `blockid`, `blockname`, `contextid`, `showinsubcontexts`, `pageid`, `pagetypepattern`, `subpagepattern`, `defaultregion`, `defaultweight`, `visible`, `configdata`) VALUES
      (598, 23, NULL, 15, 0, 64, 'course-view-*', NULL, 'side-post', 1, 1, 'Tzo4OiJzdGRDbGFzcyI6NDp7czo1OiJ0aXRsZSI7czozMDoiUml2b2xnaSB1bmEgZG9tYW5kYSBhaSBkb2NlbnRpIjtzOjg6Imxpbmt0ZXh0IjtzOjE3OiJTY3JpdmkgbGEgZG9tYW5kYSI7czoxMToiZGlzcGxheXR5cGUiO3M6MToiMCI7czo3OiJzdWJqZWN0IjtzOjA6IiI7fQ=='),
      (592, 24, NULL, 15, 0, 64, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
      (591, 28, NULL, 203, 0, 1, 'site-index', NULL, 'side-pre', 6, 1, ''),
      (262, 24, NULL, 11, 0, 29, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
      (303, 24, NULL, 9, 0, 26, 'course-view-*', NULL, 'side-pre', 1, 1, ''),
      (304, 23, NULL, 9, 0, 26, 'course-view-*', NULL, 'side-post', 1, 1, ''),
      (305, 24, NULL, 18, 0, 31, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
      (306, 23, NULL, 18, 0, 31, 'course-view-*', NULL, 'side-post', 2, 1, ''),
      (352, 24, NULL, 27, 0, 35, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
      (417, 24, NULL, 35, 0, 41, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
      (736, 24, NULL, 46, 0, 79, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
      (751, 24, NULL, 44, 0, 77, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
      (747, 24, NULL, 45, 0, 78, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
      (762, 24, NULL, 2875, 0, 7, 'blog-index', NULL, 'side-post', 2, 1, ''),
      (803, 24, NULL, 16, 0, 65, 'course-view-*', NULL, 'side-post', 1, 1, '');

        Attachments

          Activity

            People

            • Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              andreabix Andrea Bicciolo
              Tester:
              Nobody
              Participants:
              Component watchers:
              Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                24/Nov/10