DDL sql execution error Error after trying to install plugins
moodle 3.11.7
wins server 2016
maria db 10.4.20
php 7.4.29
Was able to get moodle up and running. So now was trying to install a plugin (qtype_mulitchoiceset) from the moodle directory. When it went to install it came up with this error:
I did try to delete the mdl_recent_block_activity from the moodle database inside mariadb, but no luck after that.
I was able to restore webpage access by removing the new plug folder. But will need to still figure out error so i can get it installed
Re: DDL sql execution error Error after trying to install plugins
Recent Activity Block is part of core. Anything core you don't want to use should be hidden ... not erased ... especially not removing entries in DB related because the code is still there.
You recently installed and had issues with installing ... related to DB ... your solution to that was to use utf8 character set - is that correct?
Debug shows table for recent activity block is using utf8mb4_unicode_ci collation. Character sets and collations should match.
There is a command line only php script in admin/cli/ that can sort that out for ya. Matter of fact, there are 3 or 4 that relate to DB. Suggest you run them.
When installing plugins, the web based interface does an environment check to see if the plugin you are attempting to install meets requirements/versions. Mind sharing the link to that plugin found in Moodle.org plugins?
'SoS', Ken
Re: DDL sql execution error Error after trying to install plugins
This is the plugin i initially tried, but got error on any plugin i tried to install
https://moodle.org/plugins/qtype_multichoiceset
Re: DDL sql execution error Error after trying to install plugins
That plugin ...
https://moodle.org/plugins/qtype_multichoiceset/versions
You need the
1.9.1 (Build: 2021071200) (2021071200)
Moodle 3.9, 3.10, 3.11, 4.0Re: DDL sql execution error Error after trying to install plugins
I turned of debugging, and this was the output:
Re: DDL sql execution error Error after trying to install plugins
Difficult to read your post ... but here goes ....
So your moodle version is 3.11.7
Earlier, you said ...
"I did try to delete the mdl_recent_block_activity from the moodle database inside mariadb"
One should never have to resort to manual removal of rows in DB for Moodle IN the DB interface. Did you remove rows or the table?
That block is a core block ... comes with moodle.
Do the admin/cli/mysql_ scripts again and pay attention to the tables it shows especially
mdl_block_recent_activity
mysql> show tables like '%recent%';
+---------------------------------+
| Tables_in_moodle311 (%recent%) |
+---------------------------------+
| mdl_block_recent_activity |
| mdl_block_recentlyaccesseditems |
explain mdl_block_recent_activity;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| courseid | bigint(10) | NO | MUL | NULL | |
| cmid | bigint(10) | NO | | NULL | |
| timecreated | bigint(10) | NO | | NULL | |
| userid | bigint(10) | NO | | NULL | |
| action | tinyint(1) | NO | | NULL | |
| modname | varchar(20) | YES | | NULL
Can that table be queried?
select * from mdl_block_recent_activity;
Screen shot shows the plugin is already installed????!!!!
"A lock was created but not released"
Is there a 'locks' directory in your moodledata directory?
IF there is, manually remove the contents of it ... leaving the directory.
PHP Warning: rename(C:\inetpub\moodledata/cache/cachestore_file/default_application/core_string/en_-cache/ZBmAQQEBIm.627d620d78e7b6.36636309.temp,C:\inetpub\moodledata/cache/cachestore_file/default_application/core_string/en_-cache/en_core_repository_1652384255-277226e45591af7469fb4178ae34f5fc.cache): Access is denied. (code: 5)
Error 5 indicates that you do not have the required permissions to access a file. With File Manager, all the read/write permissions are taken from the username and password used at login.
We sure are having to 'work to work' on this. All of this is not typical experience with new sites. If you've not created courses yet and this is a fresh install, you might consider starting over!
'SoS', Ken
Re: DDL sql execution error Error after trying to install plugins
Re: DDL sql execution error Error after trying to install plugins
Might be wise!
https://docs.moodle.org/400/en/Windows_installation
Is there a reason for Windows server? If one looks at platform, mariadb/mysql not really native to Windows. Neither is Apache. While programmers of PHP apps used to use Windows for development, they were developing to run on Linux. Many are not using Windows any more but Ubuntu.
One can find more support if Moodle installed on Linux ...
https://docs.moodle.org/400/en/Step-by-step_Installation_Guide_for_Ubuntu
'SoS', Ken