[#MDL-10436] 1.9 installation hangs at "Setting up block tables"

Issue Details (XML | Word | Printable)

Key:	MDL-10436
Type:	Bug
Status:	Resolved
Resolution:	Fixed
Priority:	Blocker
Assignee:	Nicolas Connault
Reporter:	Urs Hunkler
Votes:	0
Watchers:	0

Operations

Add/Edit UI Mockup to this issue

If you were logged in you would be able to see more operations.

Moodle

1.9 installation hangs at "Setting up block tables"

Created: 13/Jul/07 02:39 AM Updated: 25/Aug/07 12:20 AM

Return to search

Component/s:

Installation

Affects Version/s:

1.9

Fix Version/s:

1.9

Database:	MySQL
Participants:	Martin Dougiamas, Matt Campbell, Nicolas Connault and Urs Hunkler
Security Level:	None
Resolved date:	25/Aug/07
Affected Branches:	MOODLE_19_STABLE
Fixed Branches:	MOODLE_19_STABLE

Description

« Hide

1067: Invalid default value for 'updated'

            ADOConnection._Execute(CREATE TABLE mdl_search_documents (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    docid VARCHAR(32) NOT NULL DEFAULT '..., false) % line 891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_search_documents (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    docid VARCHAR(32) NOT NULL DEFAULT '...) % line 89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_search_documents (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    docid VARCHAR(32) NOT NULL DEFAULT '..., true) % line 1919, file: dmllib.php
   execute_sql_arr(Array[5]) % line 548, file: ddllib.php
install_from_xmldb_file(/var/www/moodle_19/blocks/search/db/install.xml) % line 1323, file: blocklib.php

ErrorScroll to next warning

(mysql): ALTER TABLE mdl_search_documents COMMENT='table to store search index backups' 1146: Table 'moodle_19a.mdl_search_documents' doesn't exist

            ADOConnection._Execute(ALTER TABLE mdl_search_documents COMMENT='table to store search index backups', false) % line 891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_search_documents COMMENT='table to store search index backups') % line 89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_search_documents COMMENT='table to store search index backups', true) % line 1919, file: dmllib.php
   execute_sql_arr(Array[5]) % line 548, file: ddllib.php
install_from_xmldb_file(/var/www/moodle_19/blocks/search/db/install.xml) % line 1323, file: blocklib.php

Scroll to previous warningErrorScroll to next warning

All

Comments

Change History

Version Control

Sort Order:

[ Permalink | « Hide ]

Urs Hunkler added a comment - 13/Jul/07 02:32 PM

Just in the moment my 1.9 update hangs with the same isuue.

Page "Setting up block tables"

This script generated 6 warnings - Scroll to the first warning

New version of Global Search (search) exists

(mysql): ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype`
1146: Table 'moodle_19.mdl_search_documents' doesn't exist
ADOConnection._Execute(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype`, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype`) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` ; ) % line 17, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php
ErrorScroll to next warning

(mysql): ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` )
1146: Table 'moodle_19.mdl_search_documents' doesn't exist
ADOConnection._Execute(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` )) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) ; ) % line 18, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php
Scroll to previous warningErrorScroll to next warning

(mysql): ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none'
1146: Table 'moodle_19.mdl_search_documents' doesn't exist
ADOConnection._Execute(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none', false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none') % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' ; ) % line 19, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php
Scroll to previous warningErrorScroll to next warning

(mysql): ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 )
1146: Table 'moodle_19.mdl_search_documents' doesn't exist
ADOConnection._Execute(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 )) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) ; ) % line 20, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php
Scroll to previous warningErrorScroll to next warning

(mysql): ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 )
1146: Table 'moodle_19.mdl_search_documents' doesn't exist
ADOConnection._Execute(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 )) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) ; ) % line 21, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php
Scroll to previous warningErrorScroll to next warning

(mysql): ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 )
1146: Table 'moodle_19.mdl_mdl_search_documents' doesn't exist
ADOConnection._Execute(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 )) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) ; ) % line 22, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php
Scroll to previous warningErrorScroll to continue button

Global Search tables have been set up correctly

[ Show » ]

Urs Hunkler added a comment - 13/Jul/07 02:32 PM Just in the moment my 1.9 update hangs with the same isuue. Page "Setting up block tables" This script generated 6 warnings - Scroll to the first warning New version of Global Search (search) exists (mysql): ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` 1146: Table 'moodle_19.mdl_search_documents' doesn't exist ADOConnection._Execute(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype`, false) % line 891, file: adodb.inc.php ADOConnection.Execute(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype`) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` ; ) % line 17, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php ErrorScroll to next warning (mysql): ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) 1146: Table 'moodle_19.mdl_search_documents' doesn't exist ADOConnection._Execute(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ), false) % line 891, file: adodb.inc.php ADOConnection.Execute(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` )) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) ; ) % line 18, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php Scroll to previous warningErrorScroll to next warning (mysql): ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' 1146: Table 'moodle_19.mdl_search_documents' doesn't exist ADOConnection._Execute(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none', false) % line 891, file: adodb.inc.php ADOConnection.Execute(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none') % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' ; ) % line 19, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php Scroll to previous warningErrorScroll to next warning (mysql): ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) 1146: Table 'moodle_19.mdl_search_documents' doesn't exist ADOConnection._Execute(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ), false) % line 891, file: adodb.inc.php ADOConnection.Execute(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 )) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) ; ) % line 20, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php Scroll to previous warningErrorScroll to next warning (mysql): ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) 1146: Table 'moodle_19.mdl_search_documents' doesn't exist ADOConnection._Execute(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ), false) % line 891, file: adodb.inc.php ADOConnection.Execute(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 )) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) ; ) % line 21, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php Scroll to previous warningErrorScroll to next warning (mysql): ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) 1146: Table 'moodle_19.mdl_mdl_search_documents' doesn't exist ADOConnection._Execute(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ), false) % line 891, file: adodb.inc.php ADOConnection.Execute(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 )) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) ; ) % line 22, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1252, file: blocklib.php Scroll to previous warningErrorScroll to continue button Global Search tables have been set up correctly

[ Permalink | « Hide ]

Urs Hunkler added a comment - 13/Jul/07 02:34 PM

Is it only me having this issue?

Urs Hunkler made changes - 13/Jul/07 02:34 PM

Field	Original Value	New Value
Priority	Minor [ 4 ]	Blocker [ 1 ]

[ Permalink | « Hide ]

Martin Dougiamas added a comment - 13/Jul/07 02:56 PM

cvs update again ... I just fixed this

Martin Dougiamas made changes - 13/Jul/07 02:56 PM

Resolution		Fixed [ 1 ]
Fix Version/s		1.9 [ 10190 ]
Status	Open [ 1 ]	Resolved [ 5 ]

[ Permalink | « Hide ]

Matt Campbell added a comment - 18/Aug/07 01:14 AM

Brand new test install on 1.9 Beta, pulled from CVS on 08/17/2007, getting this error:

New version of Global Search (search) exists
(mysql): ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` 1146: Table 'moodle3.mdl_search_documents' doesn't exist

adodb_mysql._execute(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype`, false) % line 891, file: adodb.inc.php
adodb_mysql.execute(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype`) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` ; ) % line 17, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php

ErrorScroll to next warning

(mysql): ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) 1146: Table 'moodle3.mdl_search_documents' doesn't exist

adodb_mysql._execute(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ), false) % line 891, file: adodb.inc.php
adodb_mysql.execute(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` )) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) ; ) % line 18, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php

Scroll to previous warningErrorScroll to next warning

(mysql): ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' 1146: Table 'moodle3.mdl_search_documents' doesn't exist

adodb_mysql._execute(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none', false) % line 891, file: adodb.inc.php
adodb_mysql.execute(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none') % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' ; ) % line 19, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php

Scroll to previous warningErrorScroll to next warning

(mysql): ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) 1146: Table 'moodle3.mdl_search_documents' doesn't exist

adodb_mysql._execute(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ), false) % line 891, file: adodb.inc.php
adodb_mysql.execute(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 )) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) ; ) % line 20, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php

Scroll to previous warningErrorScroll to next warning

(mysql): ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) 1146: Table 'moodle3.mdl_search_documents' doesn't exist

adodb_mysql._execute(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ), false) % line 891, file: adodb.inc.php
adodb_mysql.execute(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 )) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) ; ) % line 21, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php

Scroll to previous warningErrorScroll to next warning

(mysql): ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) 1146: Table 'moodle3.mdl_mdl_search_documents' doesn't exist

adodb_mysql._execute(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ), false) % line 891, file: adodb.inc.php
adodb_mysql.execute(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 )) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) ) % line 233, file: dmllib.php
modify_database(, ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) ; ) % line 22, file: mysql.php
search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php

Scroll to previous warningErrorScroll to continue button

It may be worth noting that I had Global Search turned off in the 1.8 test install I upgraded this from.

[ Show » ]

Matt Campbell added a comment - 18/Aug/07 01:14 AM Brand new test install on 1.9 Beta, pulled from CVS on 08/17/2007, getting this error: New version of Global Search (search) exists (mysql): ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` 1146: Table 'moodle3.mdl_search_documents' doesn't exist adodb_mysql._execute(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype`, false) % line 891, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype`) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` ADD `item_type` VARCHAR( 32 ) NOT NULL AFTER `doctype` ; ) % line 17, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php ErrorScroll to next warning (mysql): ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) 1146: Table 'moodle3.mdl_search_documents' doesn't exist adodb_mysql._execute(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ), false) % line 891, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` )) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` ADD INDEX ( `item_type` ) ; ) % line 18, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php Scroll to previous warningErrorScroll to next warning (mysql): ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' 1146: Table 'moodle3.mdl_search_documents' doesn't exist adodb_mysql._execute(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none', false) % line 891, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none') % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `doctype` `doctype` VARCHAR( 32 ) DEFAULT 'none' ; ) % line 19, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php Scroll to previous warningErrorScroll to next warning (mysql): ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) 1146: Table 'moodle3.mdl_search_documents' doesn't exist adodb_mysql._execute(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ), false) % line 891, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 )) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `title` `title` VARCHAR( 255 ) ; ) % line 20, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php Scroll to previous warningErrorScroll to next warning (mysql): ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) 1146: Table 'moodle3.mdl_search_documents' doesn't exist adodb_mysql._execute(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ), false) % line 891, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 )) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_search_documents` CHANGE `url` `url` VARCHAR( 255 ) ; ) % line 21, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php Scroll to previous warningErrorScroll to next warning (mysql): ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) 1146: Table 'moodle3.mdl_mdl_search_documents' doesn't exist adodb_mysql._execute(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ), false) % line 891, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 )) % line 89, file: dmllib.php execute_sql(ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) ) % line 233, file: dmllib.php modify_database(, ALTER TABLE `mdl_mdl_search_documents` CHANGE `docid` `docid` VARCHAR( 32 ) ; ) % line 22, file: mysql.php search_upgrade(2006062500, Object:stdClass) % line 1272, file: blocklib.php Scroll to previous warningErrorScroll to continue button It may be worth noting that I had Global Search turned off in the 1.8 test install I upgraded this from.

Matt Campbell made changes - 18/Aug/07 01:14 AM

Resolution	Fixed [ 1 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

[ Permalink | « Hide ]

Martin Dougiamas added a comment - 21/Aug/07 01:40 PM

Nicolas, can you look into this? The upgrade.php and install.xml code looks OK. to me (in blocks/search/db)

Martin Dougiamas made changes - 21/Aug/07 01:40 PM

Assignee

Martin Dougiamas [ dougiamas ]

Nicolas Connault [ nicolasconnault ]

[ Permalink | « Hide ]

Martin Dougiamas added a comment - 23/Aug/07 03:12 PM

ping

[ Permalink | « Hide ]

Nicolas Connault added a comment - 23/Aug/07 10:56 PM

Ping.

I looked into it, performed two fresh 1.9 installations on 2 completely different machines... No problems at all. I''ll try upgrading from a 1.8 site

[ Permalink | « Hide ]

Matt Campbell added a comment - 25/Aug/07 12:17 AM - edited

I do NOT have this issue when I do an upgrade or fresh install using Moodle 1.9 Beta + (2007082200). If I try to use Moodle 1.9 Beta + (2007081700), I get this issue. Both versions pulled from CVS. Moving this back to resolved.

Matt Campbell made changes - 25/Aug/07 12:19 AM

Resolution		Fixed [ 1 ]
Status	Reopened [ 4 ]	Resolved [ 5 ]

All content on this web site is made available under the GNU General Public License, unless otherwise stated.