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

Details

Type: Bug
Status: Closed
Priority: Blocker
Resolution: Fixed
Affects Version/s: 1.9
Fix Version/s: 1.9
Component/s: Installation
Labels:
None

Database:

MySQL
Affected Branches:
MOODLE_19_STABLE
Fixed Branches:
MOODLE_19_STABLE

Description

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

Issue Links

This issue will be resolved by:
MDL-13621	Installation process stops on "Setting up block table".

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Urs Hunkler added a comment - 13/Jul/07 2: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 2: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

Hide

Permalink

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

Is it only me having this issue?

Show

Urs Hunkler added a comment - 13/Jul/07 2:34 PM Is it only me having this issue?

Hide

Permalink

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

cvs update again ... I just fixed this

Show

Martin Dougiamas added a comment - 13/Jul/07 2:56 PM cvs update again ... I just fixed this

Hide

Permalink

Matt Campbell added a comment - 18/Aug/07 1: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 1: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.

Hide

Permalink

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

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

Show

Martin Dougiamas added a comment - 21/Aug/07 1:40 PM Nicolas, can you look into this? The upgrade.php and install.xml code looks OK. to me (in blocks/search/db)

Hide

Permalink

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

ping

Show

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

Hide

Permalink

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

Show

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

Hide

Permalink

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.

Show

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.

Hide

Permalink

Andrew Davis added a comment - 27/Nov/09 3:46 PM

A multitude of 1.9 installs have been done since this was marked resolved. Closing.

Show

Andrew Davis added a comment - 27/Nov/09 3:46 PM A multitude of 1.9 installs have been done since this was marked resolved. Closing.

People

Assignee:

Nicolas Connault

Reporter:

Urs Hunkler

Tester:

Andrew Davis

Participants:

Andrew Davis, Martin Dougiamas, Matt Campbell, Nicolas Connault, Urs Hunkler

Vote (0)

Watch (0)

Dates

Created:

13/Jul/07 2:39 AM

Updated:

30/Nov/09 3:22 PM

Resolved:

25/Aug/07 12:19 AM