Moodle plugin "Sharing Cart" installation error

最新推荐文章于 2021-07-29 18:40:58 发布

totogogo

最新推荐文章于 2021-07-29 18:40:58 发布

阅读量872

点赞数

分类专栏： Moodle 文章标签： plugins notifications table download file delete

本文链接：https://blog.csdn.net/totogogo/article/details/5880634

版权

Moodle 专栏收录该内容

15 篇文章 1 订阅

订阅专栏

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.