Moodle plugin "Sharing Cart" installation error

来源:互联网 发布:wifi广告软件 编辑:程序博客网 时间:2024/06/05 13:28

download latest version (2009040600) sharing cart and install it, following error may occurs:

1101: BLOB/TEXT column 'data' can't have a default value
ADOConnection._Execute(CREATE TABLE mdl_sharing_cart_plugins (
...
install_from_xmldb_file(D:/iis7/public/Sandbox/blocks/sharing_cart/db/install.xml) % line 1374, file: blocklib.php


----------------------------------------------------------------------------
(mysql): ALTER TABLE mdl_sharing_cart_plugins COMMENT='table to store sharing cart plugins data'
--------------------------------------------------------------------------------
1146: Table 'xxxxxx.mdl_sharing_cart_plugins' doesn't exist
....


Solution is:
1. modify file "install.xml" (under sharing_cart/db).
    find the following line:
    <FIELD NAME="data" TYPE="text" NOTNULL="true" DEFAULT="" SEQUENCE="false" ENUM="false" PREVIOUS="user"/>
    and delete the text that says Default='', so the line ends looking like this:
    <FIELD NAME="data" TYPE="text" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="user"/>

2. drop table 'mdl_sharing_cart' (and 'mdl_sharing_cart', though it should not exist).
3. do the 'administration > notifications' process again.