I have moved server from shared to VPS, it is CENTOS 7.2 x86_64 virtuozzo – dedivps WHM 56.0 (build 21) - I have just upgraded from easy apache 2 to 4 - and am using php 5.6 i believe.
I have turned debugging on and have no errors showing.
The issues is the site is working perfect apart from no-one can download any files, it either says network connection lost or the url of the file cannot be found on the server.
Thanks in advance
Provider makes a diff. Who host it for you please?
Providers who offer customers a path from shared to a VPS, normally copy the user /home directory onto the new server in a 'user space' as opposed to true Apache web root /var/www/html/
Three parts to Moodle ... code, DB, and data directory. The code is evidently in the right spot or you wouldn't be able to access. DB is restored corretly or you wouldn't be see the site at all. Domain name didn't change ... right? Are there any images you uploaded to the theme ... like a banner, or some such that isn't displaying?
So ... has your login name on new server changed?
IF so, depending upon where the code and moodledata directories are and how this new site is configured, it might be a simple matter of changing ownerships and permissions on moodledata and all it's contents to the new user name.
Did the path to moodledata change? Check config.php file for that info/location.
To acquire better info, please turn on debugging and let's see what Moodle is saying.
'spirit of sharing', Ken
Hi Ken
Firstly Thanks for your help!
The Host is unlimited web hosting based in Manchester, Uk
- All Images on site seem ok and working ,
-The moodledata folder is located one level up from public_html folder and the config reads (changed some info for stars ) :
<?php // Moodle configuration file
unset($CFG);
global $CFG;
$CFG = new stdClass();
$CFG->dbtype = 'mysqli';
$CFG->dblibrary = 'native';
$CFG->dbhost = 'localhost';
$CFG->dbname = 'oc******_mood***';
$CFG->dbuser = 'oc******_mood***';
$CFG->dbpass = '***********';
$CFG->prefix = 'mdl_';
$CFG->dboptions = array (
'dbpersist' => 0,
'dbport' => '',
'dbsocket' => '',
);
$CFG->wwwroot = 'http://domain.here';
$CFG->dataroot = '/home/oc******/moodledata';
$CFG->admin = 'admin';
$CFG->directorypermissions = 0777;
require_once(dirname(__FILE__) . '/lib/setup.php');
// There is no php closing tag in this file,
// it is intentional because it prevents trailing whitespace problems!
- What do you mean by login name? the one that i used to get onto cpanel / whm ?
- Moodle data folder permission is currently set at 700 throughout
- I have debugging on and it shows no errors and the log is clear
All directories as far as i am aware have remained in the same location as when they were on the original server
Thanks Ken!
Login name is the oc**** you've ob-secured (pun intended) - or that's how it was on old server.
Obviously, I don't host with the provider .. but it does appear they are using 'user space' for customers moved from shared to VPS. That's why 'public_html' exist in /home/occ****/
public_html is your web document root ... whatever in there is served out by apache. Moodle code you say is in 'training' (do see on directory there [admin]) ... so the URL to your site would be http://FQDN/training/. Is that correct? So the $CFG->wwwroot should be pointed to:
http://FQDN/training/
The other directories above training are for some other application ... and you might also have a /sandbox/ thing you can access. Don't recognize those directories but there should be an index.php or an index.html or some default file that servers that stuff out. Whatever that is, it might have something in it's config that could possibly mess with serving out Moodle - depends upon what that is and how configured.
There is an index.php in training which is the index file for Moodle.
Would think all the files/directories/subdirs in /home/occ*****/public_html/ are owned by occ*** which is now part of the apache group. That's partially how one sets up user directories in CentOS.
This just for additional/comparison ...
had you started on a dedicated VPS there's a good chance provider would have left typical CentOS config. Document root would have been in /var/www/html/[moodlecodehere] and moodledata would have been in /var/www/
all of [moodlecodehere] and moodledata (as was as it's contents) would belong to the user under which apache on a typical CentOS box runs ... user: apache ... group: apache.
Am not saying move things there ... again ... just for comparison ... true VPS that started as a VPS and a user that has moved from shared to a VPS. Easier for provider to copy a user directory to a VPS than it is to do it properly for a dedicated VPS. (they all do it)
2 cent lesson which means absolutely nothing ;)
'spirit of sharing', Ken
Hi Ken,
Thanks for your reply,
Right training is a subdomain so the address is normally http://training.xyz.co.uk - which i know should be the same think as http://xyz.co.uk/training - now i have tried changing the config to http://xyz.co.uk/training and i get an error (detected invalid url) then redirects and loads the site with images missing and it will not let me log in with a correct password.
I believe that is correct all directories are owned by the oc**** user as this would be the login within the cpanel to gain access to all these domains/subdomains (training, sandbox, and the root ocol (which is a WP site)
Thanks for the very well explained explanation, the question is how can i sort the issues? Would it be any easier to provide you with access and then you could possibly tell the boys and girls what they had done ? :P
2 cent lesson For sure!!
Regards
Dan
First, be very careful about offering folks access to your system. Nice that you think I am 'trustworthy' (while I think I am) ... will decline. Reason: after 'touching' your system, will I be held responsible for *any* issues your account on your dedicated server might develop in the future or currently has but that hasn't been discovered yet? Besides that, hosting providers frown upon that. That's what yo pay the for!!!!
Now before reading on or doing anything mentioned/explained below, how about turning on debugging to see what Moodle does say about the missing images first. If it reports something please come back and copy and paste the text of that (not an image screen shot). We might discover the reason that way.
Now the rest of this ... adding 10 cents ...
First:
http://www.webhostingsecretrevealed.net/the-truth-about-unlimited-hosting/
Boring reading for non-techies but since you've chosen a hosting solution for your Moodle
it might be informative.
Information concerning the problem you've not shared before is the fact that this
moodle implementation is really under a sub-domain ... domain still unknown.
So showing a folder/file structure a little mis-leading without that bit of knowledge.
So the Moodle code is in /home/occ***/public_html/training.
What domain/subdomain serves out *anything* in public_html?
Can one have a subdomain (training.FQDN inside a another domain (FQDN)?
Answer should be yes ... there's the condition ... by example:
tcea.org is a real domain - in DNS if one uses that URL it points to one IP address
that is autoforwarded to the server ... at www.tcea.org
moodle.tcea.org is a sub-domain (as far as DNS is concerned that is technically correct, however,
IF one were to go via browser to tcea.org one will hit a different server from the
server that uses moodle.tcea.org
So this to say ... training.DOMAIN is configured on your server to point to what physical
directories? According to what you've shown so far:
/home/occ***/public_html/training/
BUT, there is something served out by accessing /home/occ***/public_hmtl ... isn't there?
What is that? Another application ... like a WordPress? (don't think it is cause didn't see any word-press diretories). There is something there, however ... we don't know what. It might have protections set so that it thinks training is ok, but moodledata is not.
Moodle requires moodledata NOT to be in a directory that can be accessed directly.
Example: (this won't work: http://moodle.tcea.org/moodledata/)
But moodledata needs to be readable/writable by the apache user **and apache group** ... in your case occ**** because occ*** is part of the apache group - that's an educated guess.
What you could try is putting moodledata in the training directory and then protecting it
with an .htaccess file that basically denies any direct browsing.
You would have to change the config.php file's pointer to the location of moodledata if you did that.
Begin here:
https://docs.moodle.org/20/en/Creating_Moodle_site_data_directory
That's old documentation and tells you that.
Section on CPanel and webhosts
Moodle.org doesn't appear to have updated pages related. Hard for them to do that
cause web host don't do things the same way.
This, then, necessitates consulting with your provider - how to protect a data directory
inside an application directory (i.e., your training directory).
'spirit of sharing', Ken
Thanks once again for your very informative response
so a little about the file structure and setup just out of interest..
So the moodle data sits outside of the public_html as you could see
Within the Public html Is a wordpress site (bog standard really)
Then you have the training subdomain (where the moodle is installed)
Then Sandbox (Which is a duplicate of the training, uses a seperate moodledata and db) used for testing updates with setup
Then Calendar Which is a free booking system (unused)
Then Portal which is a free ticketing system (unused)
All of these are located on same server (VPS) under same ip address.
- I have tried moving the moodledata within the public_html and altered the config file accordingly and site works normally but with same issue, files wont open and when it download it says network connection lost
- I have also tried moving the moodledata to the training folder where the moodle installation is and editing the config to suit and get exactly the same effect as above
Its worth noting that files download normally but always fail in the last 1 or 2kb for some reason. (see screenshot)
So the next thing i tried was to change the config back from http://training.xyz.co.uk to http://xyz.co.uk/training..
This caused a few issues :
Pages are difficult to load throwing up page unavailable errors then you refresh and they finally load but with images missing. Also the admin menu doesn't work and you are unable to click any options. I Enabled debugging by adding
$CFG->debug = 2047;
to the config file but nothing is displayed. Also under the error log within the training folder all i have is :
[27-May-2016 20:53:44 UTC] PHP Parse error: syntax error, unexpected ':' in /home/oc014285/public_html/training/config.php on line 20
[27-May-2016 20:53:44 UTC] PHP Parse error: syntax error, unexpected ':' in /home/oc014285/public_html/training/config.php on line 20
[27-May-2016 20:53:46 UTC] PHP Parse error: syntax error, unexpected ':' in /home/oc014285/public_html/training/config.php on line 20
[27-May-2016 20:54:07 UTC] PHP Parse error: syntax error, unexpected ':' in /home/oc014285/public_html/training/config.php on line 20
[27-May-2016 20:54:09 UTC] PHP Parse error: syntax error, unexpected ':' in /home/oc014285/public_html/training/config.php on line 20
[27-May-2016 21:34:44 UTC] Default exception handler: Course or activity not accessible. Debug: You are not logged in
Error code: requireloginerror
* line 2906 of /lib/moodlelib.php: require_login_exception thrown
* line 3306 of /lib/moodlelib.php: call to require_login()
* line 343 of /mod/resource/lib.php: call to require_course_login()
* line 4630 of /lib/filelib.php: call to resource_pluginfile()
* line 37 of /pluginfile.php: call to file_pluginfile()
[27-May-2016 21:34:46 UTC] Default exception handler: Course or activity not accessible. Debug: You are not logged in
Error code: requireloginerror
* line 2906 of /lib/moodlelib.php: require_login_exception thrown
* line 3306 of /lib/moodlelib.php: call to require_login()
* line 343 of /mod/resource/lib.php: call to require_course_login()
* line 4630 of /lib/filelib.php: call to resource_pluginfile()
* line 37 of /pluginfile.php: call to file_pluginfile()
As far as the user oc**** - the only way i know to check and see what permissions this user has is by looking on mysql and what permissions this user has to the db? I'm not sure how else this user can be edited or checked?
I have been consulting with my provider to no avail - They just keep saying that the VPS is using cpanel the same as the shared hosting i was on and the directories will be identical in every way! :-|
Is there another way i can try and get debugging information out of it?
Thanks again for your patience Ken
Just a sub note-
curiously i have also found one file within a course that downloads normally and works! but all others don't!
I would suggest your first requirement is to check out line 20 of config.php and find out why its reporting that error.
Once that is gone, then see about whatever else may be causing problems, but an error in your config.php is going to lead to problems of some description anyway and so needs to be fixed - especially as L20 could be around where teh wwwroot and dataroot are configured (they are L20 and 21 in my localhost for example)
+1 to what Richard has already told you ... check out line 20 of config.php ...
each of those lines must end with a ";" (semicolon) ... 'ticks' in the config.php file are normally "'".
Error says:
PHP Parse error: syntax error, unexpected ':' ... hint ... with variables that require enclosing so the application knows what 'www-root' (as an example) is the value must be enclosed in matching enclosing characters and something PHP will accept. Working from a Mac that has setting to use 'smart quotes' bites sometimes .... PHP may not understand 'smart quotes'.
How does 'sandbox' work? Does it? Did it? Is there a config.php file in there you might be able to use for comparisons with training? ** Important question ** was sandbox installed by the infamous one click installer providers sometimes have for customers? Where was sandbox's moodledata directory placed? Am now wondering IF the training site is really using the moodledata directory from the sandbox installation.
As far as broken links/images missing ... the files uploaded to moodle are stored in moodledata/filedir/ ... but not by names that are humanly recognizable. And that information is really meta data coming from the database. Database has a contenthash field for a file ... that is converted into a path in moodledata/filedir/ and a file. You see it in 'English'.
So one one of those broken images, right click or whatever click you to look at properties of the link. You can then see some of the obscurement links to files are undergone in Moodle. Obviously, If moodledata directory cannot be found/read then that's the major cause.
Now this is interesting ... files always fail at the tail end ... with what you say is 1K or so left of the file.
That could be an apache issue and or a php issue. There is a setting for 'slash arguments' in Moodle (use the Site Admin Search box to find it). How is that set on your server? On or Off ...
Here's a clip of what the comments are in a 2.9.x Moodle:
"'Slash arguments' (using PATH_INFO) is required for SCORM packages and multiple-file resources to display correctly. If your web server doesn't support 'slash arguments' and you are unable to configure it, this setting can be disabled, though it will result in things not working.
Note: The use of 'slash arguments' will be required in future versions of Moodle."
Am about out of ideas here ... :\
'spirit of sharing', Ken
Thanks Both for your help -
Line 20 in the config is :
$CFG->wwwroot = 'http://training.ocol.co.uk';
The whole unedited file :
<?php // Moodle configuration file
unset($CFG);
global $CFG;
$CFG = new stdClass();
$CFG->dbtype = 'mysqli';
$CFG->dblibrary = 'native';
$CFG->dbhost = 'localhost';
$CFG->dbname = 'oc*****_mood557';
$CFG->dbuser = 'oc*****_mood557';
$CFG->dbpass = 'EDITED';
$CFG->prefix = 'mdl_';
$CFG->dboptions = array (
'dbpersist' => 0,
'dbport' => '',
'dbsocket' => '',
);
$CFG->wwwroot = 'http://training.ocol.co.uk';
$CFG->dataroot = '/home/oc*****/moodledata';
$CFG->admin = 'admin';
$CFG->directorypermissions = 0777;
require_once(dirname(__FILE__) . '/lib/setup.php');
// There is no php closing tag in this file,
// it is intentional because it prevents trailing whitespace problems!
The sandbox was created by myself manually by exporting the db, copying the moodle data and installing a fresh copy of moodle on the sandbox then importing the db and duplicating and renaming the dupe moodledata to moodledatasandbox - the location of this is the same as the other though (one level up from public_html) and then editing the config to match.
I will have a look at the broken images upon change to http://ocol.co.uk/training and let you know
Slash arguments are enabled, if i disable it and go to environment under server option it says check it (it should be enabled) but in doing so i found this error although i don't think this is the cause of this issue (please see screenshot)
Here is my php info also :
PHP Version 5.6.21 |
System | Linux dedivps-50909 2.6.32-042stab108.8 #1 SMP Wed Jul 22 17:23:23 MSK 2015 x86_64 |
Build Date | May 2 2016 19:34:22 |
Configure Command | './configure' '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--program-prefix=' '--disable-dependency-tracking' '--prefix=/opt/cpanel/ea-php56/root/usr' '--exec-prefix=/opt/cpanel/ea-php56/root/usr' '--bindir=/opt/cpanel/ea-php56/root/usr/bin' '--sbindir=/opt/cpanel/ea-php56/root/usr/sbin' '--sysconfdir=/opt/cpanel/ea-php56/root/etc' '--datadir=/opt/cpanel/ea-php56/root/usr/share' '--includedir=/opt/cpanel/ea-php56/root/usr/include' '--libdir=/opt/cpanel/ea-php56/root/usr/lib64' '--libexecdir=/opt/cpanel/ea-php56/root/usr/libexec' '--localstatedir=/opt/cpanel/ea-php56/root/usr/var' '--sharedstatedir=/opt/cpanel/ea-php56/root/usr/com' '--mandir=/opt/cpanel/ea-php56/root/usr/share/man' '--infodir=/opt/cpanel/ea-php56/root/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib64' '--with-config-file-path=/opt/cpanel/ea-php56/root/etc' '--with-config-file-scan-dir=/opt/cpanel/ea-php56/root/etc/php.d' '--disable-debug' '--with-pic' '--enable-rpath=/opt/cpanel/ea-php56/root/usr/lib64' '--without-pear' '--with-bz2' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-vpx-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-sockets' '--with-kerberos' '--enable-shmop' '--enable-calendar' '--with-libxml-dir=/usr' '--enable-xml' '--with-system-tzdata' '--with-mhash' '--enable-dtrace' '--libdir=/opt/cpanel/ea-php56/root/usr/lib64/php' '--enable-pcntl' '--enable-opcache' '--with-imap=shared,/opt/cpanel/ea-php56/root/usr' '--with-imap-ssl' '--enable-mbstring=shared' '--enable-mbregex' '--with-t1lib=/usr' '--with-gd=shared' '--with-gmp=shared' '--enable-calendar=shared' '--enable-bcmath=shared' '--with-bz2=shared' '--enable-ctype=shared' '--enable-dba=shared' '--with-db4=/usr' '--with-tcadb=/usr' '--enable-exif=shared' '--enable-ftp=shared' '--with-gettext=shared' '--with-iconv=shared' '--enable-sockets=shared' '--enable-tokenizer=shared' '--with-xmlrpc=shared' '--with-ldap=shared' '--with-ldap-sasl' '--enable-mysqlnd=shared' '--with-mysql=shared,mysqlnd' '--with-mysqli=shared,mysqlnd' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--enable-dom=shared' '--with-pgsql=shared' '--enable-simplexml=shared' '--enable-xml=shared' '--enable-wddx=shared' '--with-snmp=shared,/usr' '--enable-soap=shared' '--with-xsl=shared,/usr' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--with-curl=shared,/usr' '--enable-pdo=shared' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-mysql=shared,mysqlnd' '--with-pdo-pgsql=shared,/usr' '--with-pdo-sqlite=shared,/usr' '--with-sqlite3=shared,/usr' '--enable-json=shared' '--enable-zip=shared' '--without-readline' '--with-libedit' '--with-pspell=shared' '--enable-phar=shared' '--with-mcrypt=shared,/opt/cpanel/libmcrypt' '--enable-sysvmsg=shared' '--enable-sysvshm=shared' '--enable-sysvsem=shared' '--enable-shmop=shared' '--enable-posix=shared' '--with-unixODBC=shared,/usr' '--enable-intl=shared' '--with-icu-dir=/usr' '--with-enchant=shared,/usr' '--with-recode=shared,/usr' '--enable-fileinfo=shared' 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu' 'CFLAGS=-O2 '-g' '-pipe' '-Wall' '-Wp,-D_FORTIFY_SOURCE=2' '-fexceptions' '-fstack-protector-strong' '--param=ssp-buffer-size=4' '-grecord-gcc-switches' '-specs=/usr/lib/rpm/redhat/redhat-hardened-cc1' '-m64' '-mtune=generic' '-fno-strict-aliasing' '-Wno-pointer-sign'' 'LDFLAGS=-Wl,-z,relro '-specs=/usr/lib/rpm/redhat/redhat-hardened-ld'' 'CXXFLAGS=-O2 '-g' '-pipe' '-Wall' '-Wp,-D_FORTIFY_SOURCE=2' '-fexceptions' '-fstack-protector-strong' '--param=ssp-buffer-size=4' '-grecord-gcc-switches' '-specs=/usr/lib/rpm/redhat/redhat-hardened-cc1' '-m64' '-mtune=generic'' |
Server API | CGI/FastCGI |
Virtual Directory Support | disabled |
Configuration File (php.ini) Path | /opt/cpanel/ea-php56/root/etc |
Loaded Configuration File | /opt/cpanel/ea-php56/root/etc/php.ini |
Scan this dir for additional .ini files | /opt/cpanel/ea-php56/root/etc/php.d |
Additional .ini files parsed | /opt/cpanel/ea-php56/root/etc/php.d/01-ioncube.ini, /opt/cpanel/ea-php56/root/etc/php.d/bcmath.ini, /opt/cpanel/ea-php56/root/etc/php.d/bz2.ini, /opt/cpanel/ea-php56/root/etc/php.d/calendar.ini, /opt/cpanel/ea-php56/root/etc/php.d/ctype.ini, /opt/cpanel/ea-php56/root/etc/php.d/curl.ini, /opt/cpanel/ea-php56/root/etc/php.d/dba.ini, /opt/cpanel/ea-php56/root/etc/php.d/dom.ini, /opt/cpanel/ea-php56/root/etc/php.d/enchant.ini, /opt/cpanel/ea-php56/root/etc/php.d/exif.ini, /opt/cpanel/ea-php56/root/etc/php.d/fileinfo.ini, /opt/cpanel/ea-php56/root/etc/php.d/ftp.ini, /opt/cpanel/ea-php56/root/etc/php.d/gd.ini, /opt/cpanel/ea-php56/root/etc/php.d/gettext.ini, /opt/cpanel/ea-php56/root/etc/php.d/gmp.ini, /opt/cpanel/ea-php56/root/etc/php.d/iconv.ini, /opt/cpanel/ea-php56/root/etc/php.d/imap.ini, /opt/cpanel/ea-php56/root/etc/php.d/intl.ini, /opt/cpanel/ea-php56/root/etc/php.d/json.ini, /opt/cpanel/ea-php56/root/etc/php.d/ldap.ini, /opt/cpanel/ea-php56/root/etc/php.d/local.ini, /opt/cpanel/ea-php56/root/etc/php.d/mbstring.ini, /opt/cpanel/ea-php56/root/etc/php.d/mcrypt.ini, /opt/cpanel/ea-php56/root/etc/php.d/mysqlnd.ini, /opt/cpanel/ea-php56/root/etc/php.d/mysqlnd_mysql.ini, /opt/cpanel/ea-php56/root/etc/php.d/mysqlnd_mysqli.ini, /opt/cpanel/ea-php56/root/etc/php.d/odbc.ini, /opt/cpanel/ea-php56/root/etc/php.d/pdo.ini, /opt/cpanel/ea-php56/root/etc/php.d/pdo_mysqlnd.ini, /opt/cpanel/ea-php56/root/etc/php.d/pdo_odbc.ini, /opt/cpanel/ea-php56/root/etc/php.d/pdo_pgsql.ini, /opt/cpanel/ea-php56/root/etc/php.d/pdo_sqlite.ini, /opt/cpanel/ea-php56/root/etc/php.d/pgsql.ini, /opt/cpanel/ea-php56/root/etc/php.d/phar.ini, /opt/cpanel/ea-php56/root/etc/php.d/posix.ini, /opt/cpanel/ea-php56/root/etc/php.d/pspell.ini, /opt/cpanel/ea-php56/root/etc/php.d/shmop.ini, /opt/cpanel/ea-php56/root/etc/php.d/simplexml.ini, /opt/cpanel/ea-php56/root/etc/php.d/snmp.ini, /opt/cpanel/ea-php56/root/etc/php.d/soap.ini, /opt/cpanel/ea-php56/root/etc/php.d/sockets.ini, /opt/cpanel/ea-php56/root/etc/php.d/sourceguardian.ini, /opt/cpanel/ea-php56/root/etc/php.d/sqlite3.ini, /opt/cpanel/ea-php56/root/etc/php.d/sysvmsg.ini, /opt/cpanel/ea-php56/root/etc/php.d/sysvsem.ini, /opt/cpanel/ea-php56/root/etc/php.d/sysvshm.ini, /opt/cpanel/ea-php56/root/etc/php.d/tokenizer.ini, /opt/cpanel/ea-php56/root/etc/php.d/xml.ini, /opt/cpanel/ea-php56/root/etc/php.d/xml_wddx.ini, /opt/cpanel/ea-php56/root/etc/php.d/xmlreader.ini, /opt/cpanel/ea-php56/root/etc/php.d/xmlrpc.ini, /opt/cpanel/ea-php56/root/etc/php.d/xmlwriter.ini, /opt/cpanel/ea-php56/root/etc/php.d/xsl.ini, /opt/cpanel/ea-php56/root/etc/php.d/zendguard.ini, /opt/cpanel/ea-php56/root/etc/php.d/zip.ini |
PHP API | 20131106 |
PHP Extension | 20131226 |
Zend Extension | 220131226 |
Zend Extension Build | API220131226,NTS |
PHP Extension Build | API20131226,NTS |
Debug Build | no |
Thread Safety | disabled |
Zend Signal Handling | disabled |
Zend Memory Manager | enabled |
Zend Multibyte Support | provided by mbstring |
IPv6 Support | enabled |
DTrace Support | enabled |
Registered PHP Streams | https, ftps, compress.zlib, php, file, glob, data, http, ftp, compress.bzip2, phar, zip |
Registered Stream Socket Transports | tcp, udp, unix, udg, ssl, sslv3, sslv2, tls, tlsv1.0, tlsv1.1, tlsv1.2 |
Registered Stream Filters | zlib.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, bzip2.*, convert.iconv.*, mcrypt.*, mdecrypt.* |
Configuration
bcmath
BCMath support | enabled |
Directive | Local Value | Master Value |
---|---|---|
bcmath.scale | 0 | 0 |
bz2
BZip2 Support | Enabled |
Stream Wrapper support | compress.bzip2:// |
Stream Filter support | bzip2.decompress, bzip2.compress |
BZip2 Version | 1.0.6, 6-Sept-2010 |
calendar
Calendar support | enabled |
cgi-fcgi
Directive | Local Value | Master Value |
---|---|---|
cgi.check_shebang_line | 1 | 1 |
cgi.discard_path | 0 | 0 |
cgi.fix_pathinfo | 1 | 1 |
cgi.force_redirect | 1 | 1 |
cgi.nph | 0 | 0 |
cgi.redirect_status_env | no value | no value |
cgi.rfc2616_headers | 0 | 0 |
fastcgi.logging | 1 | 1 |
Core
PHP Version | 5.6.21 |
Directive | Local Value | Master Value |
---|---|---|
allow_url_fopen | On | On |
allow_url_include | Off | Off |
always_populate_raw_post_data | 0 | 0 |
arg_separator.input | & | & |
arg_separator.output | & | & |
asp_tags | Off | Off |
auto_append_file | no value | no value |
auto_globals_jit | On | On |
auto_prepend_file | no value | no value |
browscap | no value | no value |
default_charset | UTF-8 | UTF-8 |
default_mimetype | text/html | text/html |
disable_classes | no value | no value |
disable_functions | no value | no value |
display_errors | On | Off |
display_startup_errors | Off | Off |
doc_root | no value | no value |
docref_ext | no value | no value |
docref_root | no value | no value |
enable_dl | Off | Off |
enable_post_data_reading | On | On |
error_append_string | no value | no value |
error_log | error_log | error_log |
error_prepend_string | no value | no value |
error_reporting | 30719 | 32759 |
exit_on_timeout | Off | Off |
expose_php | Off | Off |
extension_dir | /opt/cpanel/ea-php56/root/usr/lib64/php/modules | /opt/cpanel/ea-php56/root/usr/lib64/php/modules |
file_uploads | On | On |
highlight.comment | #FF8000 | #FF8000 |
highlight.default | #0000BB | #0000BB |
highlight.html | #000000 | #000000 |
highlight.keyword | #007700 | #007700 |
highlight.string | #DD0000 | #DD0000 |
html_errors | On | On |
ignore_repeated_errors | Off | Off |
ignore_repeated_source | Off | Off |
ignore_user_abort | Off | Off |
implicit_flush | Off | Off |
include_path | /home/oc014285/public_html/training/lib/zend:/home/oc014285/public_html/training/lib/pear:.;/path/to/php/pear | .;/path/to/php/pear |
input_encoding | no value | no value |
internal_encoding | no value | no value |
log_errors | On | On |
log_errors_max_len | 1024 | 1024 |
mail.add_x_header | On | On |
mail.force_extra_parameters | no value | no value |
mail.log | no value | no value |
max_execution_time | 90 | 90 |
max_file_uploads | 20 | 20 |
max_input_nesting_level | 64 | 64 |
max_input_time | 600 | 600 |
max_input_vars | 1000 | 1000 |
memory_limit | 512M | 512M |
open_basedir | no value | no value |
output_buffering | no value | no value |
output_encoding | no value | no value |
output_handler | no value | no value |
post_max_size | 8M | 8M |
precision | 14 | 12 |
realpath_cache_size | 16K | 16K |
realpath_cache_ttl | 120 | 120 |
register_argc_argv | Off | Off |
report_memleaks | On | On |
report_zend_debug | On | On |
request_order | GP | GP |
sendmail_from | no value | no value |
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i |
serialize_precision | 17 | 100 |
short_open_tag | On | On |
SMTP | localhost | localhost |
smtp_port | 25 | 25 |
sql.safe_mode | Off | Off |
sys_temp_dir | no value | no value |
track_errors | On | Off |
unserialize_callback_func | no value | no value |
upload_max_filesize | 1g | 1g |
upload_tmp_dir | no value | no value |
user_dir | no value | no value |
user_ini.cache_ttl | 300 | 300 |
user_ini.filename | .user.ini | .user.ini |
variables_order | GPCS | GPCS |
xmlrpc_error_number | 0 | 0 |
xmlrpc_errors | Off | Off |
zend.detect_unicode | On | On |
zend.enable_gc | On | On |
zend.multibyte | Off | Off |
zend.script_encoding | no value | no value |
ctype
ctype functions | enabled |
curl
cURL support | enabled |
cURL Information | 7.29.0 |
Age | 3 |
Features | |
AsynchDNS | Yes |
CharConv | No |
Debug | No |
GSS-Negotiate | Yes |
IDN | Yes |
IPv6 | Yes |
krb4 | No |
Largefile | Yes |
libz | Yes |
NTLM | Yes |
NTLMWB | Yes |
SPNEGO | No |
SSL | Yes |
SSPI | No |
TLS-SRP | No |
Protocols | dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp |
Host | x86_64-redhat-linux-gnu |
SSL Version | NSS/3.19.1 Basic ECC |
ZLib Version | 1.2.7 |
libSSH Version | libssh2/1.4.3 |
date
date/time support | enabled |
"Olson" Timezone Database Version | 0.system |
Timezone Database | internal |
Default timezone | UTC |
Directive | Local Value | Master Value |
---|---|---|
date.default_latitude | 31.7667 | 31.7667 |
date.default_longitude | 35.2333 | 35.2333 |
date.sunrise_zenith | 90.583333 | 90.583333 |
date.sunset_zenith | 90.583333 | 90.583333 |
date.timezone | UTC | UTC |
dba
DBA support | enabled |
Supported handlers | cdb cdb_make db4 inifile flatfile tcadb |
Directive | Local Value | Master Value |
---|---|---|
dba.default_handler | flatfile | flatfile |
dom
DOM/XML | enabled |
DOM/XML API Version | 20031129 |
libxml Version | 2.9.1 |
HTML Support | enabled |
XPath Support | enabled |
XPointer Support | enabled |
Schema Support | enabled |
RelaxNG Support | enabled |
enchant
enchant support | enabled |
---|---|
Version | 1.1.0 |
Libenchant Version | 1.5.x |
Revision | $Id: 2b1a7a0910b094a8f56f81d474ff1837c4389a28 $ |
myspell | Myspell Provider | /usr/lib64/enchant/libenchant_myspell.so |
ereg
Regex Library | Bundled library enabled |
exif
EXIF Support | enabled |
EXIF Version | 1.4 $Id: db007ca2e6d0b4513ae77990972997fad8bfe9c9 $ |
Supported EXIF Version | 0220 |
Supported filetypes | JPEG,TIFF |
Directive | Local Value | Master Value |
---|---|---|
exif.decode_jis_intel | JIS | JIS |
exif.decode_jis_motorola | JIS | JIS |
exif.decode_unicode_intel | UCS-2LE | UCS-2LE |
exif.decode_unicode_motorola | UCS-2BE | UCS-2BE |
exif.encode_jis | no value | no value |
exif.encode_unicode | ISO-8859-15 | ISO-8859-15 |
fileinfo
fileinfo support | enabled |
version | 1.0.5 |
libmagic | 517 |
filter
Input Validation and Filtering | enabled |
Revision | $Id: 0a967738ca580e8bfdacb06853749743fc79b969 $ |
Directive | Local Value | Master Value |
---|---|---|
filter.default | unsafe_raw | unsafe_raw |
filter.default_flags | no value | no value |
ftp
FTP support | enabled |
gd
GD Support | enabled |
GD Version | bundled (2.1.0 compatible) |
FreeType Support | enabled |
FreeType Linkage | with freetype |
FreeType Version | 2.4.11 |
T1Lib Support | enabled |
GIF Read Support | enabled |
GIF Create Support | enabled |
JPEG Support | enabled |
libJPEG Version | 6b |
PNG Support | enabled |
libPNG Version | 1.5.13 |
WBMP Support | enabled |
XPM Support | enabled |
libXpm Version | 30411 |
XBM Support | enabled |
WebP Support | enabled |
Directive | Local Value | Master Value |
---|---|---|
gd.jpeg_ignore_warning | 0 | 0 |
gettext
GetText Support | enabled |
gmp
gmp support | enabled |
GMP version | 6.0.0 |
hash
hash support | enabled |
Hashing Engines | md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 |
iconv
iconv support | enabled |
iconv implementation | glibc |
iconv library version | 2.17 |
Directive | Local Value | Master Value |
---|---|---|
iconv.input_encoding | no value | no value |
iconv.internal_encoding | no value | no value |
iconv.output_encoding | no value | no value |
imap
IMAP c-Client Version | 2007f |
SSL Support | enabled |
Kerberos Support | enabled |
intl
Internationalization support | enabled |
---|---|
version | 1.1.0 |
ICU version | 50.1.2 |
ICU Data version | 50.1 |
Directive | Local Value | Master Value |
---|---|---|
intl.default_locale | no value | no value |
intl.error_level | 0 | 0 |
intl.use_exceptions | 0 | 0 |
json
json support | enabled |
json version | 1.2.1 |
ldap
LDAP Support | enabled |
RCS Version | $Id: 5ffc17b96f6abc34bc3607bc1131ea7a79586613 $ |
Total Links | 0/unlimited |
API Version | 3001 |
Vendor Name | OpenLDAP |
Vendor Version | 20439 |
SASL Support | Enabled |
Directive | Local Value | Master Value |
---|---|---|
ldap.max_links | Unlimited | Unlimited |
libxml
libXML support | active |
libXML Compiled Version | 2.9.1 |
libXML Loaded Version | 20901 |
libXML streams | enabled |
mbstring
Multibyte Support | enabled |
Multibyte string engine | libmbfl |
HTTP input encoding translation | disabled |
libmbfl version | 1.3.2 |
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1. |
---|
Multibyte (japanese) regex support | enabled |
Multibyte regex (oniguruma) backtrack check | On |
Multibyte regex (oniguruma) version | 5.9.5 |
Directive | Local Value | Master Value |
---|---|---|
mbstring.detect_order | no value | no value |
mbstring.encoding_translation | Off | Off |
mbstring.func_overload | 0 | 0 |
mbstring.http_input | no value | no value |
mbstring.http_output | no value | no value |
mbstring.http_output_conv_mimetypes | ^(text/|application/xhtml\+xml) | ^(text/|application/xhtml\+xml) |
mbstring.internal_encoding | no value | no value |
mbstring.language | neutral | neutral |
mbstring.strict_detection | Off | Off |
mbstring.substitute_character | no value | no value |
mcrypt
mcrypt support | enabled |
---|---|
mcrypt_filter support | enabled |
Version | 2.5.8 |
Api No | 20021217 |
Supported ciphers | cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes |
Supported modes | cbc cfb ctr ecb ncfb nofb ofb stream |
Directive | Local Value | Master Value |
---|---|---|
mcrypt.algorithms_dir | no value | no value |
mcrypt.modes_dir | no value | no value |
mhash
MHASH support | Enabled |
MHASH API Version | Emulated Support |
mysql
MySQL Support | enabled |
---|---|
Active Persistent Links | 0 |
Active Links | 0 |
Client API version | mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ |
Directive | Local Value | Master Value |
---|---|---|
mysql.allow_local_infile | On | On |
mysql.allow_persistent | On | On |
mysql.connect_timeout | 60 | 60 |
mysql.default_host | no value | no value |
mysql.default_password | no value | no value |
mysql.default_port | no value | no value |
mysql.default_socket | /var/lib/mysql/mysql.sock | /var/lib/mysql/mysql.sock |
mysql.default_user | no value | no value |
mysql.max_links | Unlimited | Unlimited |
mysql.max_persistent | Unlimited | Unlimited |
mysql.trace_mode | Off | Off |
mysqli
MysqlI Support | enabled |
---|---|
Client API library version | mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ |
Active Persistent Links | 0 |
Inactive Persistent Links | 0 |
Active Links | 1 |
Directive | Local Value | Master Value |
---|---|---|
mysqli.allow_local_infile | On | On |
mysqli.allow_persistent | On | On |
mysqli.default_host | no value | no value |
mysqli.default_port | 3306 | 3306 |
mysqli.default_pw | no value | no value |
mysqli.default_socket | /var/lib/mysql/mysql.sock | /var/lib/mysql/mysql.sock |
mysqli.default_user | no value | no value |
mysqli.max_links | Unlimited | Unlimited |
mysqli.max_persistent | Unlimited | Unlimited |
mysqli.reconnect | Off | Off |
mysqli.rollback_on_cached_plink | Off | Off |
mysqlnd
mysqlnd | enabled |
---|---|
Version | mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ |
Compression | supported |
core SSL | supported |
extended SSL | supported |
Command buffer size | 4096 |
Read buffer size | 32768 |
Read timeout | 31536000 |
Collecting statistics | Yes |
Collecting memory statistics | No |
Tracing | n/a |
Loaded plugins | mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password |
API Extensions | mysql,mysqli,pdo_mysql |
mysqlnd statistics | |
---|---|
bytes_sent | 9181 |
bytes_received | 136283 |
packets_sent | 156 |
packets_received | 2252 |
protocol_overhead_in | 9008 |
protocol_overhead_out | 624 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 522 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 1196 |
bytes_received_prepare_response_packet | 18941 |
bytes_received_change_user_packet | 115241 |
packets_sent_command | 77 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 58 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 77 |
packets_received_prepare_response | 241 |
packets_received_change_user | 1874 |
result_set_queries | 58 |
non_result_set_queries | 19 |
no_index_used | 10 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 58 |
unbuffered_sets | 0 |
ps_buffered_sets | 0 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 0 |
rows_fetched_from_server_normal | 1816 |
rows_fetched_from_server_ps | 0 |
rows_buffered_from_client_normal | 1816 |
rows_buffered_from_client_ps | 0 |
rows_fetched_from_client_normal_buffered | 1816 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 1816 |
rows_skipped_ps | 0 |
copy_on_write_saved | 8 |
copy_on_write_performed | 4916 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 0 |
active_connections | 1 |
active_persistent_connections | 0 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 58 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estndup_count | 0 |
mem_strdup_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 41 |
proto_text_fetched_short | 6 |
proto_text_fetched_int24 | 1 |
proto_text_fetched_int | 2 |
proto_text_fetched_bigint | 1218 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 2502 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 1144 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 0 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 0 |
proto_binary_fetched_int24 | 0 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 0 |
proto_binary_fetched_decimal | 0 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 0 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 0 |
proto_binary_fetched_blob | 0 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 77 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 0 |
com_stmt_execute | 0 |
com_stmt_send_long_data | 0 |
com_stmt_close | 0 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 102651 |
bytes_received_real_data_ps | 0 |
odbc
ODBC Support | enabled |
---|---|
Active Persistent Links | 0 |
Active Links | 0 |
ODBC library | unixODBC |
ODBC_INCLUDE | -I/usr/include |
ODBC_LFLAGS | -L/usr/lib64 |
ODBC_LIBS | -lodbc |
Directive | Local Value | Master Value |
---|---|---|
odbc.allow_persistent | On | On |
odbc.check_persistent | On | On |
odbc.default_cursortype | Static cursor | Static cursor |
odbc.default_db | no value | no value |
odbc.default_pw | no value | no value |
odbc.default_user | no value | no value |
odbc.defaultbinmode | return as is | return as is |
odbc.defaultlrl | return up to 4096 bytes | return up to 4096 bytes |
odbc.max_links | Unlimited | Unlimited |
odbc.max_persistent | Unlimited | Unlimited |
openssl
OpenSSL support | enabled |
OpenSSL Library Version | OpenSSL 1.0.1e-fips 11 Feb 2013 |
OpenSSL Header Version | OpenSSL 1.0.1e-fips 11 Feb 2013 |
Openssl default config | /etc/pki/tls/openssl.cnf |
Directive | Local Value | Master Value |
---|---|---|
openssl.cafile | no value | no value |
openssl.capath | no value | no value |
pcntl
pcntl support | enabled |
---|
pcre
PCRE (Perl Compatible Regular Expressions) Support | enabled |
PCRE Library Version | 8.32 2012-11-30 |
Directive | Local Value | Master Value |
---|---|---|
pcre.backtrack_limit | 20971520 | 1000000 |
pcre.recursion_limit | 100000 | 100000 |
PDO
PDO support | enabled |
---|---|
PDO drivers | mysql, odbc, pgsql, sqlite |
pdo_mysql
PDO Driver for MySQL | enabled |
---|---|
Client API version | mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ |
Directive | Local Value | Master Value |
---|---|---|
pdo_mysql.default_socket | /var/lib/mysql/mysql.sock | /var/lib/mysql/mysql.sock |
PDO_ODBC
PDO Driver for ODBC (unixODBC) | enabled |
---|---|
ODBC Connection Pooling | Enabled, strict matching |
pdo_pgsql
PDO Driver for PostgreSQL | enabled |
---|---|
PostgreSQL(libpq) Version | 9.2.7 |
Module version | 1.0.2 |
Revision | $Id: 0e858dd2051ca8c2fd3c781909a0670ab5fecd36 $ |
pdo_sqlite
PDO Driver for SQLite 3.x | enabled |
---|---|
SQLite Library | 3.7.17 |
pgsql
PostgreSQL Support | enabled |
---|---|
PostgreSQL(libpq) Version | 9.2.7 |
PostgreSQL(libpq) | PostgreSQL 9.2.7 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.2 20140120 (Red Hat 4.8.2-16), 64-bit |
Multibyte character support | enabled |
SSL support | enabled |
Active Persistent Links | 0 |
Active Links | 0 |
Directive | Local Value | Master Value |
---|---|---|
pgsql.allow_persistent | On | On |
pgsql.auto_reset_persistent | Off | Off |
pgsql.ignore_notice | Off | Off |
pgsql.log_notice | Off | Off |
pgsql.max_links | Unlimited | Unlimited |
pgsql.max_persistent | Unlimited | Unlimited |
Phar
Phar: PHP Archive support | enabled |
---|---|
Phar EXT version | 2.0.2 |
Phar API version | 1.1.1 |
SVN revision | $Id: 14b80e175ed4d5bf11c890e1f30ea8225935b16c $ |
Phar-based phar archives | enabled |
Tar-based phar archives | enabled |
ZIP-based phar archives | enabled |
gzip compression | enabled |
bzip2 compression | enabled |
Native OpenSSL support | enabled |
Phar based on pear/PHP_Archive, original concept by Davey Shafik. Phar fully realized by Gregory Beaver and Marcus Boerger. Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle. |
Directive | Local Value | Master Value |
---|---|---|
phar.cache_list | no value | no value |
phar.readonly | On | On |
phar.require_hash | On | On |
posix
Revision | $Id: 5f4acc20904b1406142f2a0ede068db048c77e77 $ |
pspell
PSpell Support | enabled |
readline
Readline Support | enabled |
---|---|
Readline library | EditLine wrapper |
Directive | Local Value | Master Value |
---|---|---|
cli.pager | no value | no value |
cli.prompt | \b \> | \b \> |
Reflection
Reflection | enabled |
---|---|
Version | $Id: fbcf7a77ca8e3d4cd7501de8025235b947b8240f $ |
session
Session Support | enabled |
Registered save handlers | files user |
Registered serializer handlers | php_serialize php php_binary wddx |
Directive | Local Value | Master Value |
---|---|---|
session.auto_start | Off | Off |
session.cache_expire | 180 | 180 |
session.cache_limiter | nocache | nocache |
session.cookie_domain | no value | no value |
session.cookie_httponly | Off | Off |
session.cookie_lifetime | 0 | 0 |
session.cookie_path | / | / |
session.cookie_secure | Off | Off |
session.entropy_file | /dev/urandom | /dev/urandom |
session.entropy_length | 32 | 32 |
session.gc_divisor | 1000 | 100 |
session.gc_maxlifetime | 345600 | 1440 |
session.gc_probability | 1 | 1 |
session.hash_bits_per_character | 5 | 5 |
session.hash_function | 0 | 0 |
session.name | MoodleSession | PHPSESSID |
session.referer_check | no value | no value |
session.save_handler | files | files |
session.save_path | /home/oc014285/moodledata/sessions | no value |
session.serialize_handler | php | php |
session.upload_progress.cleanup | On | On |
session.upload_progress.enabled | On | On |
session.upload_progress.freq | 1% | 1% |
session.upload_progress.min_freq | 1 | 1 |
session.upload_progress.name | PHP_SESSION_UPLOAD_PROGRESS | PHP_SESSION_UPLOAD_PROGRESS |
session.upload_progress.prefix | upload_progress_ | upload_progress_ |
session.use_cookies | On | On |
session.use_only_cookies | On | On |
session.use_strict_mode | Off | Off |
session.use_trans_sid | 0 | 0 |
shmop
shmop support | enabled |
SimpleXML
Simplexml support | enabled |
---|---|
Revision | $Id: 07fc6546e896094aed794aea4691f0151774d955 $ |
Schema support | enabled |
snmp
NET-SNMP Support | enabled |
NET-SNMP Version | 5.7.2 |
PHP SNMP Version | 0.1 |
soap
Soap Client | enabled |
Soap Server | enabled |
Directive | Local Value | Master Value |
---|---|---|
soap.wsdl_cache | 1 | 1 |
soap.wsdl_cache_dir | /tmp | /tmp |
soap.wsdl_cache_enabled | 1 | 1 |
soap.wsdl_cache_limit | 5 | 5 |
soap.wsdl_cache_ttl | 86400 | 86400 |
sockets
Sockets Support | enabled |
SourceGuardian
SourceGuardian Loader Support | enabled |
SourceGuardian Loader Version | 10.1.5 |
SourceGuardian Loader Build Number | 0x00000016 |
phpSHIELD Support | enabled |
Directive | Local Value | Master Value |
---|---|---|
sourceguardian.restrict_unencoded | 0 | 0 |
SPL
SPL support | enabled |
---|---|
Interfaces | Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject |
Classes | AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException |
sqlite3
SQLite3 support | enabled |
---|---|
SQLite3 module version | 0.7-dev |
SQLite Library | 3.7.17 |
Directive | Local Value | Master Value |
---|---|---|
sqlite3.extension_dir | no value | no value |
standard
Dynamic Library Support | enabled |
Path to sendmail | /usr/sbin/sendmail -t -i |
Directive | Local Value | Master Value |
---|---|---|
assert.active | 1 | 1 |
assert.bail | 0 | 0 |
assert.callback | no value | no value |
assert.quiet_eval | 0 | 0 |
assert.warning | 1 | 1 |
auto_detect_line_endings | 0 | 0 |
default_socket_timeout | 60 | 60 |
from | no value | no value |
url_rewriter.tags | a=href,area=href,frame=src,input=src,form=fakeentry | a=href,area=href,frame=src,input=src,form=fakeentry |
user_agent | no value | no value |
sysvmsg
sysvmsg support | enabled |
Revision | $Id: 58590192720bc56939152fde3645d808b348bb9b $ |
tokenizer
Tokenizer Support | enabled |
wddx
WDDX Support | enabled |
---|---|
WDDX Session Serializer | enabled |
xml
XML Support | active |
XML Namespace Support | active |
libxml2 Version | 2.9.1 |
xmlreader
XMLReader | enabled |
xmlrpc
core library version | xmlrpc-epi v. 0.51 |
php extension version | 0.51 |
author | Dan Libby |
homepage | http://xmlrpc-epi.sourceforge.net |
open sourced by | Epinions.com |
xmlwriter
XMLWriter | enabled |
xsl
XSL | enabled |
libxslt Version | 1.1.28 |
libxslt compiled against libxml Version | 2.9.1 |
EXSLT | enabled |
libexslt Version | 1.1.28 |
Zend Guard Loader
Zend Guard Loader | enabled |
License Path | no value |
Obfuscation level | 0 |
Zend OPcache
Opcode Caching | Up and Running |
Optimization | Enabled |
Startup | OK |
Shared memory model | mmap |
Cache hits | 4 |
Cache misses | 409 |
Used memory | 34371448 |
Free memory | 32737416 |
Wasted memory | 0 |
Interned Strings Used memory | 3977400 |
Interned Strings Free memory | 216904 |
Cached scripts | 409 |
Cached keys | 413 |
Max keys | 3907 |
OOM restarts | 0 |
Hash keys restarts | 0 |
Manual restarts | 0 |
Directive | Local Value | Master Value |
---|---|---|
opcache.blacklist_filename | no value | no value |
opcache.consistency_checks | 0 | 0 |
opcache.dups_fix | Off | Off |
opcache.enable | On | On |
opcache.enable_cli | Off | Off |
opcache.enable_file_override | Off | Off |
opcache.error_log | no value | no value |
opcache.fast_shutdown | 0 | 0 |
opcache.file_update_protection | 2 | 2 |
opcache.force_restart_timeout | 180 | 180 |
opcache.inherited_hack | On | On |
opcache.interned_strings_buffer | 4 | 4 |
opcache.load_comments | 1 | 1 |
opcache.log_verbosity_level | 1 | 1 |
opcache.max_accelerated_files | 2000 | 2000 |
opcache.max_file_size | 0 | 0 |
opcache.max_wasted_percentage | 5 | 5 |
opcache.memory_consumption | 64 | 64 |
opcache.optimization_level | 0xFFFFFFFF | 0xFFFFFFFF |
opcache.preferred_memory_model | no value | no value |
opcache.protect_memory | 0 | 0 |
opcache.restrict_api | no value | no value |
opcache.revalidate_freq | 2 | 2 |
opcache.revalidate_path | Off | Off |
opcache.save_comments | 1 | 1 |
opcache.use_cwd | On | On |
opcache.validate_timestamps | On | On |
zend_optimizerplus.blacklist_filename | no value | no value |
zend_optimizerplus.consistency_checks | 0 | 0 |
zend_optimizerplus.dups_fix | Off | Off |
zend_optimizerplus.enable | On | On |
zend_optimizerplus.enable_cli | Off | Off |
zend_optimizerplus.enable_file_override | Off | Off |
zend_optimizerplus.error_log | no value | no value |
zend_optimizerplus.fast_shutdown | 0 | 0 |
zend_optimizerplus.file_update_protection | 2 | 2 |
zend_optimizerplus.force_restart_timeout | 180 | 180 |
zend_optimizerplus.inherited_hack | On | On |
zend_optimizerplus.interned_strings_buffer | 4 | 4 |
zend_optimizerplus.load_comments | 1 | 1 |
zend_optimizerplus.log_verbosity_level | 1 | 1 |
zend_optimizerplus.max_accelerated_files | 2000 | 2000 |
zend_optimizerplus.max_file_size | 0 | 0 |
zend_optimizerplus.max_wasted_percentage | 5 | 5 |
zend_optimizerplus.memory_consumption | 64 | 64 |
zend_optimizerplus.optimization_level | 0xFFFFFFFF | 0xFFFFFFFF |
zend_optimizerplus.preferred_memory_model | no value | no value |
zend_optimizerplus.protect_memory | 0 | 0 |
zend_optimizerplus.restrict_api | no value | no value |
zend_optimizerplus.revalidate_freq | 2 | 2 |
zend_optimizerplus.revalidate_path | Off | Off |
zend_optimizerplus.save_comments | 1 | 1 |
zend_optimizerplus.use_cwd | On | On |
zend_optimizerplus.validate_timestamps | On | On |
zip
Zip | enabled |
Zip version | 1.12.5 |
Libzip version | 0.11.2 |
zlib
ZLib Support | enabled |
---|---|
Stream Wrapper | compress.zlib:// |
Stream Filter | zlib.inflate, zlib.deflate |
Compiled Version | 1.2.7 |
Linked Version | 1.2.7 |
Directive | Local Value | Master Value |
---|---|---|
zlib.output_compression | Off | Off |
zlib.output_compression_level | -1 | -1 |
zlib.output_handler | no value | no value |
Additional Modules
Module Name |
---|
ionCube Loader |
sysvsem |
sysvshm |
PHP Variables
Variable | Value |
---|---|
_COOKIE["MOODLEID1_"] | %EA%95IQJq%03%01%92%BA |
_COOKIE["MoodleSession"] | gkas19eksnbl46ga31acv90en3 |
_SERVER["SERVER_SIGNATURE"] | <address>Apache/2.4.20 (cPanel) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 Server at training.ocol.co.uk Port 80</address> |
_SERVER["UNIQUE_ID"] | V0oFf0xCwldZAKhRgdTLZgAAAJE |
_SERVER["HTTP_USER_AGENT"] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_4) AppleWebKit/601.5.17 (KHTML, like Gecko) Version/9.1 Safari/601.5.17 |
_SERVER["SERVER_PORT"] | 80 |
_SERVER["HTTP_HOST"] | training.ocol.co.uk |
_SERVER["REDIRECT_HANDLER"] | application/x-httpd-ea-php56 |
_SERVER["DOCUMENT_ROOT"] | /home/oc014285/public_html/training |
_SERVER["SCRIPT_FILENAME"] | /home/oc014285/public_html/training/admin/phpinfo.php |
_SERVER["REQUEST_URI"] | /admin/phpinfo.php |
_SERVER["SCRIPT_NAME"] | /admin/phpinfo.php |
_SERVER["HTTP_CONNECTION"] | keep-alive |
_SERVER["REMOTE_PORT"] | 31704 |
_SERVER["PATH"] | /usr/local/bin:/usr/bin:/bin |
_SERVER["CONTEXT_PREFIX"] | /cgi-sys |
_SERVER["PWD"] | /usr/local/cpanel/cgi-sys |
_SERVER["SERVER_ADMIN"] | webmaster@training.ocol.co.uk |
_SERVER["REQUEST_SCHEME"] | http |
_SERVER["REDIRECT_STATUS"] | 200 |
_SERVER["HTTP_ACCEPT_LANGUAGE"] | en-us |
_SERVER["HTTP_REFERER"] | http://training.ocol.co.uk/admin/environment.php |
_SERVER["HTTP_ACCEPT"] | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
_SERVER["REMOTE_ADDR"] | 94.197.120.158 |
_SERVER["SHLVL"] | 0 |
_SERVER["SERVER_NAME"] | training.ocol.co.uk |
_SERVER["SERVER_SOFTWARE"] | Apache/2.4.20 (cPanel) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 |
_SERVER["QUERY_STRING"] | no value |
_SERVER["SERVER_ADDR"] | 149.255.57.90 |
_SERVER["GATEWAY_INTERFACE"] | CGI/1.1 |
_SERVER["SERVER_PROTOCOL"] | HTTP/1.1 |
_SERVER["HTTP_ACCEPT_ENCODING"] | gzip, deflate |
_SERVER["REDIRECT_URL"] | /admin/phpinfo.php |
_SERVER["REQUEST_METHOD"] | GET |
_SERVER["HTTP_COOKIE"] | MOODLEID1_=%25EA%2595IQJq%2503%2501%2592%25BA; MoodleSession=gkas19eksnbl46ga31acv90en3 |
_SERVER["CONTEXT_DOCUMENT_ROOT"] | /usr/local/cpanel/cgi-sys/ |
_SERVER["ORIG_SCRIPT_FILENAME"] | /usr/local/cpanel/cgi-sys/ea-php56 |
_SERVER["ORIG_PATH_INFO"] | /admin/phpinfo.php |
_SERVER["ORIG_PATH_TRANSLATED"] | /home/oc014285/public_html/training/admin/phpinfo.php |
_SERVER["ORIG_SCRIPT_NAME"] | /cgi-sys/ea-php56 |
_SERVER["PHP_SELF"] | /admin/phpinfo.php |
_SERVER["REQUEST_TIME_FLOAT"] | 1464468863.6965 |
_SERVER["REQUEST_TIME"] | 1464468863 |
So i changed the config to http://ocol.co.uk/training from http://training.ocol.co.uk - i got the error then redirect site loaded , so i selected one of the page elements that don't load under this condition but do normally and here is the result :
Site is training.ocol.co.uk/
That's what should be in the config.php file
When changing the domain name, one also has to run search and replace
to replace the data contained in the DB for the old domain/location
to the new location.
Search for: http://ocol.co.uk/training/
and
replace with: http://training.ocol.co.uk/
Go to the tool via URL after logging on as admin user:
http://yoursite/admin/tool/replace/
Since that tool is potentially harmful, *** BACKUP YOUR DB FIRST *** ... just in case you get the search/replace parameters in-correct.
'spirit of sharing', Ken
Thanks ken ill do this now and let you know -
also under inspect element there has been a development, my sandbox site works fine! so i have gone to a course where i am having the issue and inspect page here is what i found :
On the training site that is not working :
[Error] Error: DD.Drop: Invalid Node Given: null
error (yui_combo.php:9:3673)
setter (combo:88:393)
_setAttrVal (yui_combo.php:263:3347)
_setAttr (yui_combo.php:263:2345)
set (yui_combo.php:303:226)
addAttr (yui_combo.php:263:1416)
_addAttrs (yui_combo.php:263:4265)
addAttrs (yui_combo.php:263:3992)
_initHierarchy (yui_combo.php:279:3723)
_baseInit (yui_combo.php:279:1101)
_defInitFn (yui_combo.php:311:1184)
fireComplex (yui_combo.php:271:1788)
_fire (yui_combo.php:39:4531)
fire (yui_combo.php:40:5473)
init (yui_combo.php:311:677)
_initBase (yui_combo.php:279:954)
v (yui_combo.php:279:105)
o (yui_combo.php:319)
f (combo:88:199)
(anonymous function) (yui_combo.php:8:1437)
(anonymous function) (yui_combo.php:99:1122)
forEach
(anonymous function) (yui_combo.php:10:1344)
each (yui_combo.php:99:1071)
initializer (yui_combo.php:8:1411)
_initHierarchy (yui_combo.php:279:3768)
_baseInit (yui_combo.php:279:1101)
init (yui_combo.php:311:704)
_initBase (yui_combo.php:279:954)
v (yui_combo.php:279:105)
o (yui_combo.php:319)
r (yui_combo.php:6:198)
s (yui_combo.php:8:494)
init (yui_combo.php:8:5266)
init_dragdrop (yui_combo.php:8:5371)
(anonymous function) (view.php:228:98)
_notify (yui_combo.php:9:1497)
(anonymous function) (yui_combo.php:9:974)
_notify (yui_combo.php:9:1497)
T (yui_combo.php:9:2429)
_finish (yui_combo.php:16:4858)
_onSuccess (yui_combo.php:16:5375)
p (yui_combo.php:17:1326)
onSuccess (yui_combo.php:17:2126)
_finish (yui_combo.php:12:3832)
_next (yui_combo.php:12:5473)
_progress (yui_combo.php:13:320)
h (yui_combo.php:12:4474)
[Error] Failed to load resource: The network connection was lost. (Module 1.pdf, line 0)
> Selected Element
< <h2>Module 1 </h2> = $1
And on the sandbox site that works:
[Error] TypeError: a is not a function. (In 'a(document)', 'a' is an instance of Object)
(anonymous function) (first.js:1)
execCb (require.min.js:27:7704)
check (require.min.js:27:2008)
(anonymous function) (require.min.js:27:4212)
(anonymous function) (require.min.js:9)
(anonymous function) (require.min.js:27:4643)
v (require.min.js:3)
emit (require.min.js:27:4614)
check (require.min.js:27:2505)
enable (require.min.js:27:4516)
init (require.min.js:27:1126)
E (require.min.js:25)
completeLoad (require.min.js:27:6982)
onScriptLoad (require.min.js:27:7836)
> Selected Element
< <div class="wrapper clearfix">…</div> = $1
Does this mean anything to you?
Thanks ken!!
i do appreciate your time and wisdom!
Ok so i did this with this output but still no joy
Query took: 0.00040316581726074 seconds.
UPDATE mdl_assign SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00044107437133789 seconds.
UPDATE mdl_assign SET attemptreopenmethod = REPLACE(attemptreopenmethod, ?, ?) WHERE attemptreopenmethod IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00027298927307129 seconds.
UPDATE mdl_assign_plugin_config SET plugin = REPLACE(plugin, ?, ?) WHERE plugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.001154899597168 seconds.
UPDATE mdl_assign_plugin_config SET subtype = REPLACE(subtype, ?, ?) WHERE subtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0010309219360352 seconds.
UPDATE mdl_assign_plugin_config SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0010879039764404 seconds.
UPDATE mdl_assign_plugin_config SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0010669231414795 seconds.
UPDATE mdl_assign_submission SET status = REPLACE(status, ?, ?) WHERE status IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0003058910369873 seconds.
UPDATE mdl_assign_user_flags SET workflowstate = REPLACE(workflowstate, ?, ?) WHERE workflowstate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021219253540039 seconds.
UPDATE mdl_assignfeedback_comments SET commenttext = REPLACE(commenttext, ?, ?) WHERE commenttext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023508071899414 seconds.
UPDATE mdl_assignfeedback_editpdf_annot SET path = REPLACE(path, ?, ?) WHERE path IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017189979553223 seconds.
UPDATE mdl_assignfeedback_editpdf_annot SET type = REPLACE(type, ?, ?) WHERE type IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013208389282227 seconds.
UPDATE mdl_assignfeedback_editpdf_annot SET colour = REPLACE(colour, ?, ?) WHERE colour IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013017654418945 seconds.
UPDATE mdl_assignfeedback_editpdf_cmnt SET rawtext = REPLACE(rawtext, ?, ?) WHERE rawtext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001530647277832 seconds.
UPDATE mdl_assignfeedback_editpdf_cmnt SET colour = REPLACE(colour, ?, ?) WHERE colour IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018095970153809 seconds.
UPDATE mdl_assignfeedback_editpdf_quick SET rawtext = REPLACE(rawtext, ?, ?) WHERE rawtext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018191337585449 seconds.
UPDATE mdl_assignfeedback_editpdf_quick SET colour = REPLACE(colour, ?, ?) WHERE colour IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012803077697754 seconds.
UPDATE mdl_assignment SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016117095947266 seconds.
UPDATE mdl_assignment SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014901161193848 seconds.
UPDATE mdl_assignment SET assignmenttype = REPLACE(assignmenttype, ?, ?) WHERE assignmenttype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014495849609375 seconds.
UPDATE mdl_assignment_submissions SET data1 = REPLACE(data1, ?, ?) WHERE data1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016093254089355 seconds.
UPDATE mdl_assignment_submissions SET data2 = REPLACE(data2, ?, ?) WHERE data2 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013303756713867 seconds.
UPDATE mdl_assignment_submissions SET submissioncomment = REPLACE(submissioncomment, ?, ?) WHERE submissioncomment IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_assignsubmission_onlinetext SET onlinetext = REPLACE(onlinetext, ?, ?) WHERE onlinetext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016283988952637 seconds.
UPDATE mdl_backup_controllers SET backupid = REPLACE(backupid, ?, ?) WHERE backupid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016307830810547 seconds.
UPDATE mdl_backup_controllers SET operation = REPLACE(operation, ?, ?) WHERE operation IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001380443572998 seconds.
UPDATE mdl_backup_controllers SET type = REPLACE(type, ?, ?) WHERE type IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012898445129395 seconds.
UPDATE mdl_backup_controllers SET format = REPLACE(format, ?, ?) WHERE format IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014495849609375 seconds.
UPDATE mdl_backup_controllers SET checksum = REPLACE(checksum, ?, ?) WHERE checksum IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012588500976562 seconds.
UPDATE mdl_backup_controllers SET controller = REPLACE(controller, ?, ?) WHERE controller IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014901161193848 seconds.
UPDATE mdl_backup_courses SET laststatus = REPLACE(laststatus, ?, ?) WHERE laststatus IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001518726348877 seconds.
UPDATE mdl_backup_logs SET backupid = REPLACE(backupid, ?, ?) WHERE backupid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015997886657715 seconds.
UPDATE mdl_backup_logs SET message = REPLACE(message, ?, ?) WHERE message IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012588500976562 seconds.
UPDATE mdl_badge SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018000602722168 seconds.
UPDATE mdl_badge SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001370906829834 seconds.
UPDATE mdl_badge SET issuername = REPLACE(issuername, ?, ?) WHERE issuername IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013303756713867 seconds.
UPDATE mdl_badge SET issuerurl = REPLACE(issuerurl, ?, ?) WHERE issuerurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014901161193848 seconds.
UPDATE mdl_badge SET issuercontact = REPLACE(issuercontact, ?, ?) WHERE issuercontact IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012993812561035 seconds.
UPDATE mdl_badge SET message = REPLACE(message, ?, ?) WHERE message IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016093254089355 seconds.
UPDATE mdl_badge SET messagesubject = REPLACE(messagesubject, ?, ?) WHERE messagesubject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013303756713867 seconds.
UPDATE mdl_badge_backpack SET email = REPLACE(email, ?, ?) WHERE email IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015902519226074 seconds.
UPDATE mdl_badge_backpack SET backpackurl = REPLACE(backpackurl, ?, ?) WHERE backpackurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013113021850586 seconds.
UPDATE mdl_badge_backpack SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016403198242188 seconds.
UPDATE mdl_badge_criteria_param SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017499923706055 seconds.
UPDATE mdl_badge_criteria_param SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013399124145508 seconds.
UPDATE mdl_badge_issued SET uniquehash = REPLACE(uniquehash, ?, ?) WHERE uniquehash IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015401840209961 seconds.
UPDATE mdl_block SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018095970153809 seconds.
UPDATE mdl_block_community SET coursename = REPLACE(coursename, ?, ?) WHERE coursename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016188621520996 seconds.
UPDATE mdl_block_community SET coursedescription = REPLACE(coursedescription, ?, ?) WHERE coursedescription IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013184547424316 seconds.
UPDATE mdl_block_community SET courseurl = REPLACE(courseurl, ?, ?) WHERE courseurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001530647277832 seconds.
UPDATE mdl_block_community SET imageurl = REPLACE(imageurl, ?, ?) WHERE imageurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001368522644043 seconds.
UPDATE mdl_block_positions SET pagetype = REPLACE(pagetype, ?, ?) WHERE pagetype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016593933105469 seconds.
UPDATE mdl_block_positions SET subpage = REPLACE(subpage, ?, ?) WHERE subpage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013494491577148 seconds.
UPDATE mdl_block_positions SET region = REPLACE(region, ?, ?) WHERE region IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014090538024902 seconds.
UPDATE mdl_block_recent_activity SET modname = REPLACE(modname, ?, ?) WHERE modname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015497207641602 seconds.
UPDATE mdl_block_rss_client SET title = REPLACE(title, ?, ?) WHERE title IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013613700866699 seconds.
UPDATE mdl_block_rss_client SET preferredtitle = REPLACE(preferredtitle, ?, ?) WHERE preferredtitle IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013303756713867 seconds.
UPDATE mdl_block_rss_client SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014114379882812 seconds.
UPDATE mdl_block_rss_client SET url = REPLACE(url, ?, ?) WHERE url IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012302398681641 seconds.
UPDATE mdl_blog_external SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014209747314453 seconds.
UPDATE mdl_blog_external SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013613700866699 seconds.
UPDATE mdl_blog_external SET url = REPLACE(url, ?, ?) WHERE url IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014305114746094 seconds.
UPDATE mdl_blog_external SET filtertags = REPLACE(filtertags, ?, ?) WHERE filtertags IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012707710266113 seconds.
UPDATE mdl_book SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014114379882812 seconds.
UPDATE mdl_book SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014805793762207 seconds.
UPDATE mdl_book_chapters SET title = REPLACE(title, ?, ?) WHERE title IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014114379882812 seconds.
UPDATE mdl_book_chapters SET content = REPLACE(content, ?, ?) WHERE content IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012779235839844 seconds.
UPDATE mdl_book_chapters SET importsrc = REPLACE(importsrc, ?, ?) WHERE importsrc IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012707710266113 seconds.
UPDATE mdl_cache_filters SET filter = REPLACE(filter, ?, ?) WHERE filter IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016403198242188 seconds.
UPDATE mdl_cache_filters SET md5key = REPLACE(md5key, ?, ?) WHERE md5key IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014114379882812 seconds.
UPDATE mdl_cache_filters SET rawtext = REPLACE(rawtext, ?, ?) WHERE rawtext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012397766113281 seconds.
UPDATE mdl_cache_flags SET flagtype = REPLACE(flagtype, ?, ?) WHERE flagtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021100044250488 seconds.
UPDATE mdl_cache_flags SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013399124145508 seconds.
UPDATE mdl_cache_flags SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013613700866699 seconds.
UPDATE mdl_capabilities SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00060606002807617 seconds.
UPDATE mdl_capabilities SET captype = REPLACE(captype, ?, ?) WHERE captype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00056791305541992 seconds.
UPDATE mdl_capabilities SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00054311752319336 seconds.
UPDATE mdl_chat SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_chat SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013995170593262 seconds.
UPDATE mdl_chat_messages SET message = REPLACE(message, ?, ?) WHERE message IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014090538024902 seconds.
UPDATE mdl_chat_messages_current SET message = REPLACE(message, ?, ?) WHERE message IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014686584472656 seconds.
UPDATE mdl_chat_users SET version = REPLACE(version, ?, ?) WHERE version IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014281272888184 seconds.
UPDATE mdl_chat_users SET ip = REPLACE(ip, ?, ?) WHERE ip IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013113021850586 seconds.
UPDATE mdl_chat_users SET sid = REPLACE(sid, ?, ?) WHERE sid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014686584472656 seconds.
UPDATE mdl_chat_users SET lang = REPLACE(lang, ?, ?) WHERE lang IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012397766113281 seconds.
UPDATE mdl_choice SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014305114746094 seconds.
UPDATE mdl_choice SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014615058898926 seconds.
UPDATE mdl_choice_options SET text = REPLACE(text, ?, ?) WHERE text IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017213821411133 seconds.
UPDATE mdl_cohort SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017213821411133 seconds.
UPDATE mdl_cohort SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001380443572998 seconds.
UPDATE mdl_cohort SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012588500976562 seconds.
UPDATE mdl_cohort SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014209747314453 seconds.
UPDATE mdl_comments SET commentarea = REPLACE(commentarea, ?, ?) WHERE commentarea IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015115737915039 seconds.
UPDATE mdl_comments SET content = REPLACE(content, ?, ?) WHERE content IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012898445129395 seconds.
UPDATE mdl_context SET path = REPLACE(path, ?, ?) WHERE path IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.099632978439331 seconds.
UPDATE mdl_context_temp SET path = REPLACE(path, ?, ?) WHERE path IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014805793762207 seconds.
UPDATE mdl_course SET fullname = REPLACE(fullname, ?, ?) WHERE fullname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002291202545166 seconds.
UPDATE mdl_course SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020003318786621 seconds.
UPDATE mdl_course SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018119812011719 seconds.
UPDATE mdl_course SET summary = REPLACE(summary, ?, ?) WHERE summary IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00090503692626953 seconds.
UPDATE mdl_course SET format = REPLACE(format, ?, ?) WHERE format IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001978874206543 seconds.
UPDATE mdl_course SET lang = REPLACE(lang, ?, ?) WHERE lang IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019097328186035 seconds.
UPDATE mdl_course SET calendartype = REPLACE(calendartype, ?, ?) WHERE calendartype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021910667419434 seconds.
UPDATE mdl_course SET theme = REPLACE(theme, ?, ?) WHERE theme IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019311904907227 seconds.
UPDATE mdl_course_categories SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015902519226074 seconds.
UPDATE mdl_course_categories SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015592575073242 seconds.
UPDATE mdl_course_categories SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013899803161621 seconds.
UPDATE mdl_course_categories SET path = REPLACE(path, ?, ?) WHERE path IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001368522644043 seconds.
UPDATE mdl_course_categories SET theme = REPLACE(theme, ?, ?) WHERE theme IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00027990341186523 seconds.
UPDATE mdl_course_completion_criteria SET module = REPLACE(module, ?, ?) WHERE module IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00028300285339355 seconds.
UPDATE mdl_course_format_options SET format = REPLACE(format, ?, ?) WHERE format IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00031304359436035 seconds.
UPDATE mdl_course_format_options SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018692016601562 seconds.
UPDATE mdl_course_format_options SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001828670501709 seconds.
UPDATE mdl_course_modules SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00051999092102051 seconds.
UPDATE mdl_course_modules SET availability = REPLACE(availability, ?, ?) WHERE availability IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0004420280456543 seconds.
UPDATE mdl_course_published SET huburl = REPLACE(huburl, ?, ?) WHERE huburl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014495849609375 seconds.
UPDATE mdl_course_request SET fullname = REPLACE(fullname, ?, ?) WHERE fullname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014305114746094 seconds.
UPDATE mdl_course_request SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_course_request SET summary = REPLACE(summary, ?, ?) WHERE summary IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012397766113281 seconds.
UPDATE mdl_course_request SET reason = REPLACE(reason, ?, ?) WHERE reason IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012397766113281 seconds.
UPDATE mdl_course_request SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012898445129395 seconds.
UPDATE mdl_course_sections SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0003209114074707 seconds.
UPDATE mdl_course_sections SET summary = REPLACE(summary, ?, ?) WHERE summary IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00048303604125977 seconds.
UPDATE mdl_course_sections SET sequence = REPLACE(sequence, ?, ?) WHERE sequence IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00030899047851562 seconds.
UPDATE mdl_course_sections SET availability = REPLACE(availability, ?, ?) WHERE availability IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029301643371582 seconds.
UPDATE mdl_data SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016093254089355 seconds.
UPDATE mdl_data SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014400482177734 seconds.
UPDATE mdl_data SET singletemplate = REPLACE(singletemplate, ?, ?) WHERE singletemplate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014805793762207 seconds.
UPDATE mdl_data SET listtemplate = REPLACE(listtemplate, ?, ?) WHERE listtemplate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014209747314453 seconds.
UPDATE mdl_data SET listtemplateheader = REPLACE(listtemplateheader, ?, ?) WHERE listtemplateheader IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012683868408203 seconds.
UPDATE mdl_data SET listtemplatefooter = REPLACE(listtemplatefooter, ?, ?) WHERE listtemplatefooter IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012588500976562 seconds.
UPDATE mdl_data SET addtemplate = REPLACE(addtemplate, ?, ?) WHERE addtemplate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012588500976562 seconds.
UPDATE mdl_data SET rsstemplate = REPLACE(rsstemplate, ?, ?) WHERE rsstemplate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014996528625488 seconds.
UPDATE mdl_data SET rsstitletemplate = REPLACE(rsstitletemplate, ?, ?) WHERE rsstitletemplate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012612342834473 seconds.
UPDATE mdl_data SET csstemplate = REPLACE(csstemplate, ?, ?) WHERE csstemplate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012302398681641 seconds.
UPDATE mdl_data SET jstemplate = REPLACE(jstemplate, ?, ?) WHERE jstemplate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001220703125 seconds.
UPDATE mdl_data SET asearchtemplate = REPLACE(asearchtemplate, ?, ?) WHERE asearchtemplate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012302398681641 seconds.
UPDATE mdl_data_content SET content = REPLACE(content, ?, ?) WHERE content IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014114379882812 seconds.
UPDATE mdl_data_content SET content1 = REPLACE(content1, ?, ?) WHERE content1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012993812561035 seconds.
UPDATE mdl_data_content SET content2 = REPLACE(content2, ?, ?) WHERE content2 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019097328186035 seconds.
UPDATE mdl_data_content SET content3 = REPLACE(content3, ?, ?) WHERE content3 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013995170593262 seconds.
UPDATE mdl_data_content SET content4 = REPLACE(content4, ?, ?) WHERE content4 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013995170593262 seconds.
UPDATE mdl_data_fields SET type = REPLACE(type, ?, ?) WHERE type IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015401840209961 seconds.
UPDATE mdl_data_fields SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012707710266113 seconds.
UPDATE mdl_data_fields SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012707710266113 seconds.
UPDATE mdl_data_fields SET param1 = REPLACE(param1, ?, ?) WHERE param1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015020370483398 seconds.
UPDATE mdl_data_fields SET param2 = REPLACE(param2, ?, ?) WHERE param2 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012421607971191 seconds.
UPDATE mdl_data_fields SET param3 = REPLACE(param3, ?, ?) WHERE param3 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001368522644043 seconds.
UPDATE mdl_data_fields SET param4 = REPLACE(param4, ?, ?) WHERE param4 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012087821960449 seconds.
UPDATE mdl_data_fields SET param5 = REPLACE(param5, ?, ?) WHERE param5 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014114379882812 seconds.
UPDATE mdl_data_fields SET param6 = REPLACE(param6, ?, ?) WHERE param6 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00011992454528809 seconds.
UPDATE mdl_data_fields SET param7 = REPLACE(param7, ?, ?) WHERE param7 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001220703125 seconds.
UPDATE mdl_data_fields SET param8 = REPLACE(param8, ?, ?) WHERE param8 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00011801719665527 seconds.
UPDATE mdl_data_fields SET param9 = REPLACE(param9, ?, ?) WHERE param9 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013208389282227 seconds.
UPDATE mdl_data_fields SET param10 = REPLACE(param10, ?, ?) WHERE param10 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013303756713867 seconds.
UPDATE mdl_editor_atto_autosave SET elementid = REPLACE(elementid, ?, ?) WHERE elementid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00034594535827637 seconds.
UPDATE mdl_editor_atto_autosave SET pagehash = REPLACE(pagehash, ?, ?) WHERE pagehash IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00030016899108887 seconds.
UPDATE mdl_editor_atto_autosave SET drafttext = REPLACE(drafttext, ?, ?) WHERE drafttext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00033903121948242 seconds.
UPDATE mdl_editor_atto_autosave SET pageinstance = REPLACE(pageinstance, ?, ?) WHERE pageinstance IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00030803680419922 seconds.
UPDATE mdl_enrol SET enrol = REPLACE(enrol, ?, ?) WHERE enrol IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002129077911377 seconds.
UPDATE mdl_enrol SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018405914306641 seconds.
UPDATE mdl_enrol SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018692016601562 seconds.
UPDATE mdl_enrol SET cost = REPLACE(cost, ?, ?) WHERE cost IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018501281738281 seconds.
UPDATE mdl_enrol SET currency = REPLACE(currency, ?, ?) WHERE currency IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020718574523926 seconds.
UPDATE mdl_enrol SET customchar1 = REPLACE(customchar1, ?, ?) WHERE customchar1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017595291137695 seconds.
UPDATE mdl_enrol SET customchar2 = REPLACE(customchar2, ?, ?) WHERE customchar2 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017714500427246 seconds.
UPDATE mdl_enrol SET customchar3 = REPLACE(customchar3, ?, ?) WHERE customchar3 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017499923706055 seconds.
UPDATE mdl_enrol SET customtext1 = REPLACE(customtext1, ?, ?) WHERE customtext1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017189979553223 seconds.
UPDATE mdl_enrol SET customtext2 = REPLACE(customtext2, ?, ?) WHERE customtext2 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018906593322754 seconds.
UPDATE mdl_enrol SET customtext3 = REPLACE(customtext3, ?, ?) WHERE customtext3 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017285346984863 seconds.
UPDATE mdl_enrol SET customtext4 = REPLACE(customtext4, ?, ?) WHERE customtext4 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022602081298828 seconds.
UPDATE mdl_enrol_flatfile SET action = REPLACE(action, ?, ?) WHERE action IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015711784362793 seconds.
UPDATE mdl_enrol_paypal SET business = REPLACE(business, ?, ?) WHERE business IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015497207641602 seconds.
UPDATE mdl_enrol_paypal SET receiver_email = REPLACE(receiver_email, ?, ?) WHERE receiver_email IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_enrol_paypal SET receiver_id = REPLACE(receiver_id, ?, ?) WHERE receiver_id IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012898445129395 seconds.
UPDATE mdl_enrol_paypal SET item_name = REPLACE(item_name, ?, ?) WHERE item_name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001530647277832 seconds.
UPDATE mdl_enrol_paypal SET memo = REPLACE(memo, ?, ?) WHERE memo IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012898445129395 seconds.
UPDATE mdl_enrol_paypal SET tax = REPLACE(tax, ?, ?) WHERE tax IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013494491577148 seconds.
UPDATE mdl_enrol_paypal SET option_name1 = REPLACE(option_name1, ?, ?) WHERE option_name1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014400482177734 seconds.
UPDATE mdl_enrol_paypal SET option_selection1_x = REPLACE(option_selection1_x, ?, ?) WHERE option_selection1_x IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012397766113281 seconds.
UPDATE mdl_enrol_paypal SET option_name2 = REPLACE(option_name2, ?, ?) WHERE option_name2 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012302398681641 seconds.
UPDATE mdl_enrol_paypal SET option_selection2_x = REPLACE(option_selection2_x, ?, ?) WHERE option_selection2_x IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012516975402832 seconds.
UPDATE mdl_enrol_paypal SET payment_status = REPLACE(payment_status, ?, ?) WHERE payment_status IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012302398681641 seconds.
UPDATE mdl_enrol_paypal SET pending_reason = REPLACE(pending_reason, ?, ?) WHERE pending_reason IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00011992454528809 seconds.
UPDATE mdl_enrol_paypal SET reason_code = REPLACE(reason_code, ?, ?) WHERE reason_code IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012588500976562 seconds.
UPDATE mdl_enrol_paypal SET txn_id = REPLACE(txn_id, ?, ?) WHERE txn_id IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012993812561035 seconds.
UPDATE mdl_enrol_paypal SET parent_txn_id = REPLACE(parent_txn_id, ?, ?) WHERE parent_txn_id IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012516975402832 seconds.
UPDATE mdl_enrol_paypal SET payment_type = REPLACE(payment_type, ?, ?) WHERE payment_type IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012493133544922 seconds.
UPDATE mdl_event SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016307830810547 seconds.
UPDATE mdl_event SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014400482177734 seconds.
UPDATE mdl_event SET modulename = REPLACE(modulename, ?, ?) WHERE modulename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013899803161621 seconds.
UPDATE mdl_event SET eventtype = REPLACE(eventtype, ?, ?) WHERE eventtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013399124145508 seconds.
UPDATE mdl_event SET uuid = REPLACE(uuid, ?, ?) WHERE uuid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017189979553223 seconds.
UPDATE mdl_event_subscriptions SET url = REPLACE(url, ?, ?) WHERE url IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015687942504883 seconds.
UPDATE mdl_event_subscriptions SET eventtype = REPLACE(eventtype, ?, ?) WHERE eventtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014710426330566 seconds.
UPDATE mdl_event_subscriptions SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012993812561035 seconds.
UPDATE mdl_events_handlers SET eventname = REPLACE(eventname, ?, ?) WHERE eventname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014686584472656 seconds.
UPDATE mdl_events_handlers SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013899803161621 seconds.
UPDATE mdl_events_handlers SET handlerfile = REPLACE(handlerfile, ?, ?) WHERE handlerfile IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013113021850586 seconds.
UPDATE mdl_events_handlers SET handlerfunction = REPLACE(handlerfunction, ?, ?) WHERE handlerfunction IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013303756713867 seconds.
UPDATE mdl_events_handlers SET schedule = REPLACE(schedule, ?, ?) WHERE schedule IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001518726348877 seconds.
UPDATE mdl_events_queue_handlers SET errormessage = REPLACE(errormessage, ?, ?) WHERE errormessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013995170593262 seconds.
UPDATE mdl_external_functions SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029206275939941 seconds.
UPDATE mdl_external_functions SET classname = REPLACE(classname, ?, ?) WHERE classname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024104118347168 seconds.
UPDATE mdl_external_functions SET methodname = REPLACE(methodname, ?, ?) WHERE methodname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024318695068359 seconds.
UPDATE mdl_external_functions SET classpath = REPLACE(classpath, ?, ?) WHERE classpath IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025606155395508 seconds.
UPDATE mdl_external_functions SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00027108192443848 seconds.
UPDATE mdl_external_functions SET capabilities = REPLACE(capabilities, ?, ?) WHERE capabilities IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025296211242676 seconds.
UPDATE mdl_external_services SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018310546875 seconds.
UPDATE mdl_external_services SET requiredcapability = REPLACE(requiredcapability, ?, ?) WHERE requiredcapability IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_external_services SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001521110534668 seconds.
UPDATE mdl_external_services SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015687942504883 seconds.
UPDATE mdl_external_services_functions SET functionname = REPLACE(functionname, ?, ?) WHERE functionname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019288063049316 seconds.
UPDATE mdl_external_services_users SET iprestriction = REPLACE(iprestriction, ?, ?) WHERE iprestriction IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_external_tokens SET token = REPLACE(token, ?, ?) WHERE token IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001530647277832 seconds.
UPDATE mdl_external_tokens SET sid = REPLACE(sid, ?, ?) WHERE sid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013113021850586 seconds.
UPDATE mdl_external_tokens SET iprestriction = REPLACE(iprestriction, ?, ?) WHERE iprestriction IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013184547424316 seconds.
UPDATE mdl_facetoface SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.25400018692017 seconds.
UPDATE mdl_facetoface SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001988410949707 seconds.
UPDATE mdl_facetoface SET thirdparty = REPLACE(thirdparty, ?, ?) WHERE thirdparty IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001528263092041 seconds.
UPDATE mdl_facetoface SET confirmationsubject = REPLACE(confirmationsubject, ?, ?) WHERE confirmationsubject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017213821411133 seconds.
UPDATE mdl_facetoface SET confirmationinstrmngr = REPLACE(confirmationinstrmngr, ?, ?) WHERE confirmationinstrmngr IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015592575073242 seconds.
UPDATE mdl_facetoface SET confirmationmessage = REPLACE(confirmationmessage, ?, ?) WHERE confirmationmessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018501281738281 seconds.
UPDATE mdl_facetoface SET waitlistedsubject = REPLACE(waitlistedsubject, ?, ?) WHERE waitlistedsubject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016093254089355 seconds.
UPDATE mdl_facetoface SET waitlistedmessage = REPLACE(waitlistedmessage, ?, ?) WHERE waitlistedmessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018811225891113 seconds.
UPDATE mdl_facetoface SET cancellationsubject = REPLACE(cancellationsubject, ?, ?) WHERE cancellationsubject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014710426330566 seconds.
UPDATE mdl_facetoface SET cancellationinstrmngr = REPLACE(cancellationinstrmngr, ?, ?) WHERE cancellationinstrmngr IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_facetoface SET cancellationmessage = REPLACE(cancellationmessage, ?, ?) WHERE cancellationmessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016999244689941 seconds.
UPDATE mdl_facetoface SET remindersubject = REPLACE(remindersubject, ?, ?) WHERE remindersubject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014686584472656 seconds.
UPDATE mdl_facetoface SET reminderinstrmngr = REPLACE(reminderinstrmngr, ?, ?) WHERE reminderinstrmngr IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016999244689941 seconds.
UPDATE mdl_facetoface SET remindermessage = REPLACE(remindermessage, ?, ?) WHERE remindermessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016880035400391 seconds.
UPDATE mdl_facetoface SET requestsubject = REPLACE(requestsubject, ?, ?) WHERE requestsubject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_facetoface SET requestinstrmngr = REPLACE(requestinstrmngr, ?, ?) WHERE requestinstrmngr IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016117095947266 seconds.
UPDATE mdl_facetoface SET requestmessage = REPLACE(requestmessage, ?, ?) WHERE requestmessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001678466796875 seconds.
UPDATE mdl_facetoface SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015592575073242 seconds.
UPDATE mdl_facetoface_notice SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013899803161621 seconds.
UPDATE mdl_facetoface_notice SET text = REPLACE(text, ?, ?) WHERE text IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015401840209961 seconds.
UPDATE mdl_facetoface_notice_data SET data = REPLACE(data, ?, ?) WHERE data IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015091896057129 seconds.
UPDATE mdl_facetoface_session_data SET data = REPLACE(data, ?, ?) WHERE data IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014615058898926 seconds.
UPDATE mdl_facetoface_session_field SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015783309936523 seconds.
UPDATE mdl_facetoface_session_field SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018596649169922 seconds.
UPDATE mdl_facetoface_session_field SET possiblevalues = REPLACE(possiblevalues, ?, ?) WHERE possiblevalues IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015997886657715 seconds.
UPDATE mdl_facetoface_session_field SET defaultvalue = REPLACE(defaultvalue, ?, ?) WHERE defaultvalue IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012803077697754 seconds.
UPDATE mdl_facetoface_sessions SET details = REPLACE(details, ?, ?) WHERE details IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016498565673828 seconds.
UPDATE mdl_facetoface_signups SET discountcode = REPLACE(discountcode, ?, ?) WHERE discountcode IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_facetoface_signups_status SET note = REPLACE(note, ?, ?) WHERE note IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015497207641602 seconds.
UPDATE mdl_facetoface_signups_status SET advice = REPLACE(advice, ?, ?) WHERE advice IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012993812561035 seconds.
UPDATE mdl_feedback SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022220611572266 seconds.
UPDATE mdl_feedback SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013113021850586 seconds.
UPDATE mdl_feedback SET site_after_submit = REPLACE(site_after_submit, ?, ?) WHERE site_after_submit IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014305114746094 seconds.
UPDATE mdl_feedback SET page_after_submit = REPLACE(page_after_submit, ?, ?) WHERE page_after_submit IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012612342834473 seconds.
UPDATE mdl_feedback_completedtmp SET guestid = REPLACE(guestid, ?, ?) WHERE guestid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014710426330566 seconds.
UPDATE mdl_feedback_item SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017905235290527 seconds.
UPDATE mdl_feedback_item SET label = REPLACE(label, ?, ?) WHERE label IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013113021850586 seconds.
UPDATE mdl_feedback_item SET presentation = REPLACE(presentation, ?, ?) WHERE presentation IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014805793762207 seconds.
UPDATE mdl_feedback_item SET typ = REPLACE(typ, ?, ?) WHERE typ IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012803077697754 seconds.
UPDATE mdl_feedback_item SET dependvalue = REPLACE(dependvalue, ?, ?) WHERE dependvalue IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012588500976562 seconds.
UPDATE mdl_feedback_item SET options = REPLACE(options, ?, ?) WHERE options IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014495849609375 seconds.
UPDATE mdl_feedback_template SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014400482177734 seconds.
UPDATE mdl_feedback_value SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015401840209961 seconds.
UPDATE mdl_feedback_valuetmp SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017690658569336 seconds.
UPDATE mdl_files SET contenthash = REPLACE(contenthash, ?, ?) WHERE contenthash IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0025207996368408 seconds.
UPDATE mdl_files SET pathnamehash = REPLACE(pathnamehash, ?, ?) WHERE pathnamehash IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0027799606323242 seconds.
UPDATE mdl_files SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0024659633636475 seconds.
UPDATE mdl_files SET filearea = REPLACE(filearea, ?, ?) WHERE filearea IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.002377986907959 seconds.
UPDATE mdl_files SET filepath = REPLACE(filepath, ?, ?) WHERE filepath IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0024759769439697 seconds.
UPDATE mdl_files SET filename = REPLACE(filename, ?, ?) WHERE filename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0024251937866211 seconds.
UPDATE mdl_files SET mimetype = REPLACE(mimetype, ?, ?) WHERE mimetype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0022809505462646 seconds.
UPDATE mdl_files SET source = REPLACE(source, ?, ?) WHERE source IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0022599697113037 seconds.
UPDATE mdl_files SET author = REPLACE(author, ?, ?) WHERE author IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0020360946655273 seconds.
UPDATE mdl_files SET license = REPLACE(license, ?, ?) WHERE license IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0020570755004883 seconds.
UPDATE mdl_files_reference SET reference = REPLACE(reference, ?, ?) WHERE reference IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014901161193848 seconds.
UPDATE mdl_files_reference SET referencehash = REPLACE(referencehash, ?, ?) WHERE referencehash IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015091896057129 seconds.
UPDATE mdl_filter_active SET filter = REPLACE(filter, ?, ?) WHERE filter IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015401840209961 seconds.
UPDATE mdl_folder SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014710426330566 seconds.
UPDATE mdl_folder SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015592575073242 seconds.
UPDATE mdl_forum SET type = REPLACE(type, ?, ?) WHERE type IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017690658569336 seconds.
UPDATE mdl_forum SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015616416931152 seconds.
UPDATE mdl_forum SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017499923706055 seconds.
UPDATE mdl_forum_discussions SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017380714416504 seconds.
UPDATE mdl_forum_posts SET subject = REPLACE(subject, ?, ?) WHERE subject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015497207641602 seconds.
UPDATE mdl_forum_posts SET message = REPLACE(message, ?, ?) WHERE message IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013899803161621 seconds.
UPDATE mdl_forum_posts SET attachment = REPLACE(attachment, ?, ?) WHERE attachment IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014591217041016 seconds.
UPDATE mdl_glossary SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020313262939453 seconds.
UPDATE mdl_glossary SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015115737915039 seconds.
UPDATE mdl_glossary SET displayformat = REPLACE(displayformat, ?, ?) WHERE displayformat IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021505355834961 seconds.
UPDATE mdl_glossary SET approvaldisplayformat = REPLACE(approvaldisplayformat, ?, ?) WHERE approvaldisplayformat IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013399124145508 seconds.
UPDATE mdl_glossary_alias SET alias = REPLACE(alias, ?, ?) WHERE alias IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016903877258301 seconds.
UPDATE mdl_glossary_categories SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014209747314453 seconds.
UPDATE mdl_glossary_entries SET concept = REPLACE(concept, ?, ?) WHERE concept IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017499923706055 seconds.
UPDATE mdl_glossary_entries SET definition = REPLACE(definition, ?, ?) WHERE definition IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012803077697754 seconds.
UPDATE mdl_glossary_entries SET attachment = REPLACE(attachment, ?, ?) WHERE attachment IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012803077697754 seconds.
UPDATE mdl_glossary_formats SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001978874206543 seconds.
UPDATE mdl_glossary_formats SET popupformatname = REPLACE(popupformatname, ?, ?) WHERE popupformatname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014114379882812 seconds.
UPDATE mdl_glossary_formats SET defaultmode = REPLACE(defaultmode, ?, ?) WHERE defaultmode IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014996528625488 seconds.
UPDATE mdl_glossary_formats SET defaulthook = REPLACE(defaulthook, ?, ?) WHERE defaulthook IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018811225891113 seconds.
UPDATE mdl_glossary_formats SET sortkey = REPLACE(sortkey, ?, ?) WHERE sortkey IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016403198242188 seconds.
UPDATE mdl_glossary_formats SET sortorder = REPLACE(sortorder, ?, ?) WHERE sortorder IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013303756713867 seconds.
UPDATE mdl_grade_categories SET path = REPLACE(path, ?, ?) WHERE path IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017595291137695 seconds.
UPDATE mdl_grade_categories SET fullname = REPLACE(fullname, ?, ?) WHERE fullname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017714500427246 seconds.
UPDATE mdl_grade_categories_history SET source = REPLACE(source, ?, ?) WHERE source IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024700164794922 seconds.
UPDATE mdl_grade_categories_history SET path = REPLACE(path, ?, ?) WHERE path IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002439022064209 seconds.
UPDATE mdl_grade_categories_history SET fullname = REPLACE(fullname, ?, ?) WHERE fullname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023007392883301 seconds.
UPDATE mdl_grade_grades SET feedback = REPLACE(feedback, ?, ?) WHERE feedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00053596496582031 seconds.
UPDATE mdl_grade_grades SET information = REPLACE(information, ?, ?) WHERE information IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00046014785766602 seconds.
UPDATE mdl_grade_grades SET aggregationstatus = REPLACE(aggregationstatus, ?, ?) WHERE aggregationstatus IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00054788589477539 seconds.
UPDATE mdl_grade_grades_history SET source = REPLACE(source, ?, ?) WHERE source IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0016059875488281 seconds.
UPDATE mdl_grade_grades_history SET feedback = REPLACE(feedback, ?, ?) WHERE feedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0011749267578125 seconds.
UPDATE mdl_grade_grades_history SET information = REPLACE(information, ?, ?) WHERE information IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0011978149414062 seconds.
UPDATE mdl_grade_import_newitem SET itemname = REPLACE(itemname, ?, ?) WHERE itemname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014805793762207 seconds.
UPDATE mdl_grade_import_values SET feedback = REPLACE(feedback, ?, ?) WHERE feedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015902519226074 seconds.
UPDATE mdl_grade_items SET itemname = REPLACE(itemname, ?, ?) WHERE itemname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00040388107299805 seconds.
UPDATE mdl_grade_items SET itemtype = REPLACE(itemtype, ?, ?) WHERE itemtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00038290023803711 seconds.
UPDATE mdl_grade_items SET itemmodule = REPLACE(itemmodule, ?, ?) WHERE itemmodule IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00041389465332031 seconds.
UPDATE mdl_grade_items SET iteminfo = REPLACE(iteminfo, ?, ?) WHERE iteminfo IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00033402442932129 seconds.
UPDATE mdl_grade_items SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00036191940307617 seconds.
UPDATE mdl_grade_items SET calculation = REPLACE(calculation, ?, ?) WHERE calculation IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00030303001403809 seconds.
UPDATE mdl_grade_items_history SET source = REPLACE(source, ?, ?) WHERE source IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0013890266418457 seconds.
UPDATE mdl_grade_items_history SET itemname = REPLACE(itemname, ?, ?) WHERE itemname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0017108917236328 seconds.
UPDATE mdl_grade_items_history SET itemtype = REPLACE(itemtype, ?, ?) WHERE itemtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0016148090362549 seconds.
UPDATE mdl_grade_items_history SET itemmodule = REPLACE(itemmodule, ?, ?) WHERE itemmodule IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0016100406646729 seconds.
UPDATE mdl_grade_items_history SET iteminfo = REPLACE(iteminfo, ?, ?) WHERE iteminfo IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0013840198516846 seconds.
UPDATE mdl_grade_items_history SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0015859603881836 seconds.
UPDATE mdl_grade_items_history SET calculation = REPLACE(calculation, ?, ?) WHERE calculation IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0013949871063232 seconds.
UPDATE mdl_grade_letters SET letter = REPLACE(letter, ?, ?) WHERE letter IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016117095947266 seconds.
UPDATE mdl_grade_outcomes SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014686584472656 seconds.
UPDATE mdl_grade_outcomes SET fullname = REPLACE(fullname, ?, ?) WHERE fullname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001521110534668 seconds.
UPDATE mdl_grade_outcomes SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012683868408203 seconds.
UPDATE mdl_grade_outcomes_history SET source = REPLACE(source, ?, ?) WHERE source IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018310546875 seconds.
UPDATE mdl_grade_outcomes_history SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014090538024902 seconds.
UPDATE mdl_grade_outcomes_history SET fullname = REPLACE(fullname, ?, ?) WHERE fullname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016307830810547 seconds.
UPDATE mdl_grade_outcomes_history SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013589859008789 seconds.
UPDATE mdl_grade_settings SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019001960754395 seconds.
UPDATE mdl_grade_settings SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015401840209961 seconds.
UPDATE mdl_grading_areas SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021886825561523 seconds.
UPDATE mdl_grading_areas SET areaname = REPLACE(areaname, ?, ?) WHERE areaname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025010108947754 seconds.
UPDATE mdl_grading_areas SET activemethod = REPLACE(activemethod, ?, ?) WHERE activemethod IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018000602722168 seconds.
UPDATE mdl_grading_definitions SET method = REPLACE(method, ?, ?) WHERE method IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018310546875 seconds.
UPDATE mdl_grading_definitions SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012993812561035 seconds.
UPDATE mdl_grading_definitions SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.13709187507629 seconds.
UPDATE mdl_grading_definitions SET options = REPLACE(options, ?, ?) WHERE options IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022006034851074 seconds.
UPDATE mdl_grading_instances SET feedback = REPLACE(feedback, ?, ?) WHERE feedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029206275939941 seconds.
UPDATE mdl_gradingform_guide_comments SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023603439331055 seconds.
UPDATE mdl_gradingform_guide_criteria SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00062704086303711 seconds.
UPDATE mdl_gradingform_guide_criteria SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021910667419434 seconds.
UPDATE mdl_gradingform_guide_criteria SET descriptionmarkers = REPLACE(descriptionmarkers, ?, ?) WHERE descriptionmarkers IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00069117546081543 seconds.
UPDATE mdl_gradingform_guide_fillings SET remark = REPLACE(remark, ?, ?) WHERE remark IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022983551025391 seconds.
UPDATE mdl_gradingform_rubric_criteria SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023293495178223 seconds.
UPDATE mdl_gradingform_rubric_fillings SET remark = REPLACE(remark, ?, ?) WHERE remark IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024890899658203 seconds.
UPDATE mdl_gradingform_rubric_levels SET definition = REPLACE(definition, ?, ?) WHERE definition IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023913383483887 seconds.
UPDATE mdl_groupings SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022506713867188 seconds.
UPDATE mdl_groupings SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023293495178223 seconds.
UPDATE mdl_groupings SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021505355834961 seconds.
UPDATE mdl_groupings SET configdata = REPLACE(configdata, ?, ?) WHERE configdata IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022006034851074 seconds.
UPDATE mdl_groups SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00063300132751465 seconds.
UPDATE mdl_groups SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023603439331055 seconds.
UPDATE mdl_groups SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00067806243896484 seconds.
UPDATE mdl_groups SET enrolmentkey = REPLACE(enrolmentkey, ?, ?) WHERE enrolmentkey IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021505355834961 seconds.
UPDATE mdl_groups_members SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023102760314941 seconds.
UPDATE mdl_imscp SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026893615722656 seconds.
UPDATE mdl_imscp SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0012481212615967 seconds.
UPDATE mdl_imscp SET structure = REPLACE(structure, ?, ?) WHERE structure IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021195411682129 seconds.
UPDATE mdl_label SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026798248291016 seconds.
UPDATE mdl_label SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021791458129883 seconds.
UPDATE mdl_lesson SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025081634521484 seconds.
UPDATE mdl_lesson SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022292137145996 seconds.
UPDATE mdl_lesson SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021505355834961 seconds.
UPDATE mdl_lesson SET conditions = REPLACE(conditions, ?, ?) WHERE conditions IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023889541625977 seconds.
UPDATE mdl_lesson SET mediafile = REPLACE(mediafile, ?, ?) WHERE mediafile IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002288818359375 seconds.
UPDATE mdl_lesson SET bgcolor = REPLACE(bgcolor, ?, ?) WHERE bgcolor IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022697448730469 seconds.
UPDATE mdl_lesson_answers SET answer = REPLACE(answer, ?, ?) WHERE answer IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024795532226562 seconds.
UPDATE mdl_lesson_answers SET response = REPLACE(response, ?, ?) WHERE response IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020599365234375 seconds.
UPDATE mdl_lesson_attempts SET useranswer = REPLACE(useranswer, ?, ?) WHERE useranswer IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024509429931641 seconds.
UPDATE mdl_lesson_high_scores SET nickname = REPLACE(nickname, ?, ?) WHERE nickname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023007392883301 seconds.
UPDATE mdl_lesson_pages SET title = REPLACE(title, ?, ?) WHERE title IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022983551025391 seconds.
UPDATE mdl_lesson_pages SET contents = REPLACE(contents, ?, ?) WHERE contents IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023007392883301 seconds.
UPDATE mdl_license SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024700164794922 seconds.
UPDATE mdl_license SET fullname = REPLACE(fullname, ?, ?) WHERE fullname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023412704467773 seconds.
UPDATE mdl_license SET source = REPLACE(source, ?, ?) WHERE source IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014400482177734 seconds.
UPDATE mdl_local_globalmessages SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017690658569336 seconds.
UPDATE mdl_local_globalmessages SET summary = REPLACE(summary, ?, ?) WHERE summary IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013494491577148 seconds.
UPDATE mdl_local_globalmessages SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013899803161621 seconds.
UPDATE mdl_local_globalmessages_designs SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015592575073242 seconds.
UPDATE mdl_local_globalmessages_designs SET bgcolor = REPLACE(bgcolor, ?, ?) WHERE bgcolor IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014209747314453 seconds.
UPDATE mdl_local_globalmessages_designs SET bgimage = REPLACE(bgimage, ?, ?) WHERE bgimage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014710426330566 seconds.
UPDATE mdl_local_globalmessages_designs SET bgimageposition = REPLACE(bgimageposition, ?, ?) WHERE bgimageposition IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013399124145508 seconds.
UPDATE mdl_local_globalmessages_designs SET bgimagerepeat = REPLACE(bgimagerepeat, ?, ?) WHERE bgimagerepeat IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001370906829834 seconds.
UPDATE mdl_local_globalmessages_designs SET bordercolor = REPLACE(bordercolor, ?, ?) WHERE bordercolor IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016903877258301 seconds.
UPDATE mdl_local_globalmessages_designs SET bordershape = REPLACE(bordershape, ?, ?) WHERE bordershape IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013208389282227 seconds.
UPDATE mdl_local_globalmessages_designs SET padding = REPLACE(padding, ?, ?) WHERE padding IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001518726348877 seconds.
UPDATE mdl_local_globalmessages_designs SET innerpadding = REPLACE(innerpadding, ?, ?) WHERE innerpadding IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014281272888184 seconds.
UPDATE mdl_local_globalmessages_rules SET construct = REPLACE(construct, ?, ?) WHERE construct IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019502639770508 seconds.
UPDATE mdl_local_globalmessages_rules SET leftside = REPLACE(leftside, ?, ?) WHERE leftside IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012707710266113 seconds.
UPDATE mdl_local_globalmessages_rules SET operator = REPLACE(operator, ?, ?) WHERE operator IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015401840209961 seconds.
UPDATE mdl_local_globalmessages_rules SET rightside = REPLACE(rightside, ?, ?) WHERE rightside IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012493133544922 seconds.
UPDATE mdl_lock_db SET resourcekey = REPLACE(resourcekey, ?, ?) WHERE resourcekey IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014996528625488 seconds.
UPDATE mdl_lock_db SET owner = REPLACE(owner, ?, ?) WHERE owner IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017714500427246 seconds.
UPDATE mdl_log_display SET module = REPLACE(module, ?, ?) WHERE module IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00032496452331543 seconds.
UPDATE mdl_log_display SET action = REPLACE(action, ?, ?) WHERE action IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029110908508301 seconds.
UPDATE mdl_log_display SET mtable = REPLACE(mtable, ?, ?) WHERE mtable IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00028204917907715 seconds.
UPDATE mdl_log_display SET field = REPLACE(field, ?, ?) WHERE field IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029087066650391 seconds.
UPDATE mdl_log_display SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00030612945556641 seconds.
UPDATE mdl_log_queries SET sqltext = REPLACE(sqltext, ?, ?) WHERE sqltext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001521110534668 seconds.
UPDATE mdl_log_queries SET sqlparams = REPLACE(sqlparams, ?, ?) WHERE sqlparams IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014209747314453 seconds.
UPDATE mdl_log_queries SET info = REPLACE(info, ?, ?) WHERE info IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012516975402832 seconds.
UPDATE mdl_log_queries SET backtrace = REPLACE(backtrace, ?, ?) WHERE backtrace IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014305114746094 seconds.
UPDATE mdl_logstore_standard_log SET eventname = REPLACE(eventname, ?, ?) WHERE eventname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.032226800918579 seconds.
UPDATE mdl_logstore_standard_log SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.030220985412598 seconds.
UPDATE mdl_logstore_standard_log SET action = REPLACE(action, ?, ?) WHERE action IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.030566930770874 seconds.
UPDATE mdl_logstore_standard_log SET target = REPLACE(target, ?, ?) WHERE target IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.030211925506592 seconds.
UPDATE mdl_logstore_standard_log SET objecttable = REPLACE(objecttable, ?, ?) WHERE objecttable IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.027420997619629 seconds.
UPDATE mdl_logstore_standard_log SET crud = REPLACE(crud, ?, ?) WHERE crud IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.029375076293945 seconds.
UPDATE mdl_logstore_standard_log SET other = REPLACE(other, ?, ?) WHERE other IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.034083127975464 seconds.
UPDATE mdl_logstore_standard_log SET origin = REPLACE(origin, ?, ?) WHERE origin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.030146837234497 seconds.
UPDATE mdl_logstore_standard_log SET ip = REPLACE(ip, ?, ?) WHERE ip IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.030186891555786 seconds.
UPDATE mdl_lti SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018000602722168 seconds.
UPDATE mdl_lti SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012898445129395 seconds.
UPDATE mdl_lti SET toolurl = REPLACE(toolurl, ?, ?) WHERE toolurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014305114746094 seconds.
UPDATE mdl_lti SET securetoolurl = REPLACE(securetoolurl, ?, ?) WHERE securetoolurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012493133544922 seconds.
UPDATE mdl_lti SET instructorcustomparameters = REPLACE(instructorcustomparameters, ?, ?) WHERE instructorcustomparameters IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014495849609375 seconds.
UPDATE mdl_lti SET resourcekey = REPLACE(resourcekey, ?, ?) WHERE resourcekey IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012898445129395 seconds.
UPDATE mdl_lti SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013208389282227 seconds.
UPDATE mdl_lti SET servicesalt = REPLACE(servicesalt, ?, ?) WHERE servicesalt IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013995170593262 seconds.
UPDATE mdl_lti SET icon = REPLACE(icon, ?, ?) WHERE icon IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012087821960449 seconds.
UPDATE mdl_lti SET secureicon = REPLACE(secureicon, ?, ?) WHERE secureicon IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014901161193848 seconds.
UPDATE mdl_lti_tool_proxies SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021910667419434 seconds.
UPDATE mdl_lti_tool_proxies SET regurl = REPLACE(regurl, ?, ?) WHERE regurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013113021850586 seconds.
UPDATE mdl_lti_tool_proxies SET guid = REPLACE(guid, ?, ?) WHERE guid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015401840209961 seconds.
UPDATE mdl_lti_tool_proxies SET secret = REPLACE(secret, ?, ?) WHERE secret IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012993812561035 seconds.
UPDATE mdl_lti_tool_proxies SET vendorcode = REPLACE(vendorcode, ?, ?) WHERE vendorcode IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001370906829834 seconds.
UPDATE mdl_lti_tool_proxies SET capabilityoffered = REPLACE(capabilityoffered, ?, ?) WHERE capabilityoffered IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013494491577148 seconds.
UPDATE mdl_lti_tool_proxies SET serviceoffered = REPLACE(serviceoffered, ?, ?) WHERE serviceoffered IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012397766113281 seconds.
UPDATE mdl_lti_tool_proxies SET toolproxy = REPLACE(toolproxy, ?, ?) WHERE toolproxy IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012302398681641 seconds.
UPDATE mdl_lti_tool_settings SET settings = REPLACE(settings, ?, ?) WHERE settings IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014400482177734 seconds.
UPDATE mdl_lti_types SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014686584472656 seconds.
UPDATE mdl_lti_types SET baseurl = REPLACE(baseurl, ?, ?) WHERE baseurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001518726348877 seconds.
UPDATE mdl_lti_types SET tooldomain = REPLACE(tooldomain, ?, ?) WHERE tooldomain IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012707710266113 seconds.
UPDATE mdl_lti_types SET enabledcapability = REPLACE(enabledcapability, ?, ?) WHERE enabledcapability IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012588500976562 seconds.
UPDATE mdl_lti_types SET parameter = REPLACE(parameter, ?, ?) WHERE parameter IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012516975402832 seconds.
UPDATE mdl_lti_types SET icon = REPLACE(icon, ?, ?) WHERE icon IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012397766113281 seconds.
UPDATE mdl_lti_types SET secureicon = REPLACE(secureicon, ?, ?) WHERE secureicon IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016307830810547 seconds.
UPDATE mdl_lti_types_config SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014209747314453 seconds.
UPDATE mdl_lti_types_config SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012588500976562 seconds.
UPDATE mdl_message SET subject = REPLACE(subject, ?, ?) WHERE subject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00047087669372559 seconds.
UPDATE mdl_message SET fullmessage = REPLACE(fullmessage, ?, ?) WHERE fullmessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00098299980163574 seconds.
UPDATE mdl_message SET fullmessagehtml = REPLACE(fullmessagehtml, ?, ?) WHERE fullmessagehtml IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0010979175567627 seconds.
UPDATE mdl_message SET smallmessage = REPLACE(smallmessage, ?, ?) WHERE smallmessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00074291229248047 seconds.
UPDATE mdl_message SET contexturl = REPLACE(contexturl, ?, ?) WHERE contexturl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00036191940307617 seconds.
UPDATE mdl_message SET contexturlname = REPLACE(contexturlname, ?, ?) WHERE contexturlname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00035691261291504 seconds.
UPDATE mdl_message_processors SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001680850982666 seconds.
UPDATE mdl_message_providers SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017809867858887 seconds.
UPDATE mdl_message_providers SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019001960754395 seconds.
UPDATE mdl_message_providers SET capability = REPLACE(capability, ?, ?) WHERE capability IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001518726348877 seconds.
UPDATE mdl_message_read SET subject = REPLACE(subject, ?, ?) WHERE subject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00028300285339355 seconds.
UPDATE mdl_message_read SET fullmessage = REPLACE(fullmessage, ?, ?) WHERE fullmessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00043606758117676 seconds.
UPDATE mdl_message_read SET fullmessagehtml = REPLACE(fullmessagehtml, ?, ?) WHERE fullmessagehtml IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00032401084899902 seconds.
UPDATE mdl_message_read SET smallmessage = REPLACE(smallmessage, ?, ?) WHERE smallmessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00030303001403809 seconds.
UPDATE mdl_message_read SET contexturl = REPLACE(contexturl, ?, ?) WHERE contexturl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021505355834961 seconds.
UPDATE mdl_message_read SET contexturlname = REPLACE(contexturlname, ?, ?) WHERE contexturlname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021791458129883 seconds.
UPDATE mdl_messageinbound_datakeys SET datakey = REPLACE(datakey, ?, ?) WHERE datakey IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001518726348877 seconds.
UPDATE mdl_messageinbound_handlers SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001838207244873 seconds.
UPDATE mdl_messageinbound_handlers SET classname = REPLACE(classname, ?, ?) WHERE classname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014996528625488 seconds.
UPDATE mdl_messageinbound_messagelist SET messageid = REPLACE(messageid, ?, ?) WHERE messageid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016403198242188 seconds.
UPDATE mdl_messageinbound_messagelist SET address = REPLACE(address, ?, ?) WHERE address IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012493133544922 seconds.
UPDATE mdl_mnet_application SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001528263092041 seconds.
UPDATE mdl_mnet_application SET display_name = REPLACE(display_name, ?, ?) WHERE display_name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014495849609375 seconds.
UPDATE mdl_mnet_application SET xmlrpc_server_url = REPLACE(xmlrpc_server_url, ?, ?) WHERE xmlrpc_server_url IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001530647277832 seconds.
UPDATE mdl_mnet_application SET sso_land_url = REPLACE(sso_land_url, ?, ?) WHERE sso_land_url IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013017654418945 seconds.
UPDATE mdl_mnet_application SET sso_jump_url = REPLACE(sso_jump_url, ?, ?) WHERE sso_jump_url IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015902519226074 seconds.
UPDATE mdl_mnet_host SET wwwroot = REPLACE(wwwroot, ?, ?) WHERE wwwroot IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015115737915039 seconds.
UPDATE mdl_mnet_host SET ip_address = REPLACE(ip_address, ?, ?) WHERE ip_address IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017094612121582 seconds.
UPDATE mdl_mnet_host SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013589859008789 seconds.
UPDATE mdl_mnet_host SET public_key = REPLACE(public_key, ?, ?) WHERE public_key IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001370906829834 seconds.
UPDATE mdl_mnet_host SET theme = REPLACE(theme, ?, ?) WHERE theme IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015902519226074 seconds.
UPDATE mdl_mnet_log SET ip = REPLACE(ip, ?, ?) WHERE ip IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014495849609375 seconds.
UPDATE mdl_mnet_log SET coursename = REPLACE(coursename, ?, ?) WHERE coursename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013208389282227 seconds.
UPDATE mdl_mnet_log SET module = REPLACE(module, ?, ?) WHERE module IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013589859008789 seconds.
UPDATE mdl_mnet_log SET action = REPLACE(action, ?, ?) WHERE action IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012898445129395 seconds.
UPDATE mdl_mnet_log SET url = REPLACE(url, ?, ?) WHERE url IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012898445129395 seconds.
UPDATE mdl_mnet_log SET info = REPLACE(info, ?, ?) WHERE info IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012493133544922 seconds.
UPDATE mdl_mnet_remote_rpc SET functionname = REPLACE(functionname, ?, ?) WHERE functionname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019502639770508 seconds.
UPDATE mdl_mnet_remote_rpc SET xmlrpcpath = REPLACE(xmlrpcpath, ?, ?) WHERE xmlrpcpath IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016403198242188 seconds.
UPDATE mdl_mnet_remote_rpc SET plugintype = REPLACE(plugintype, ?, ?) WHERE plugintype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014090538024902 seconds.
UPDATE mdl_mnet_remote_rpc SET pluginname = REPLACE(pluginname, ?, ?) WHERE pluginname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017309188842773 seconds.
UPDATE mdl_mnet_rpc SET functionname = REPLACE(functionname, ?, ?) WHERE functionname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019311904907227 seconds.
UPDATE mdl_mnet_rpc SET xmlrpcpath = REPLACE(xmlrpcpath, ?, ?) WHERE xmlrpcpath IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015807151794434 seconds.
UPDATE mdl_mnet_rpc SET plugintype = REPLACE(plugintype, ?, ?) WHERE plugintype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019311904907227 seconds.
UPDATE mdl_mnet_rpc SET pluginname = REPLACE(pluginname, ?, ?) WHERE pluginname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001671314239502 seconds.
UPDATE mdl_mnet_rpc SET help = REPLACE(help, ?, ?) WHERE help IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019001960754395 seconds.
UPDATE mdl_mnet_rpc SET profile = REPLACE(profile, ?, ?) WHERE profile IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017595291137695 seconds.
UPDATE mdl_mnet_rpc SET filename = REPLACE(filename, ?, ?) WHERE filename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017094612121582 seconds.
UPDATE mdl_mnet_rpc SET classname = REPLACE(classname, ?, ?) WHERE classname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014710426330566 seconds.
UPDATE mdl_mnet_service SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015783309936523 seconds.
UPDATE mdl_mnet_service SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001370906829834 seconds.
UPDATE mdl_mnet_service SET apiversion = REPLACE(apiversion, ?, ?) WHERE apiversion IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014305114746094 seconds.
UPDATE mdl_mnet_session SET username = REPLACE(username, ?, ?) WHERE username IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014805793762207 seconds.
UPDATE mdl_mnet_session SET token = REPLACE(token, ?, ?) WHERE token IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016307830810547 seconds.
UPDATE mdl_mnet_session SET useragent = REPLACE(useragent, ?, ?) WHERE useragent IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00012707710266113 seconds.
UPDATE mdl_mnet_session SET session_id = REPLACE(session_id, ?, ?) WHERE session_id IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014781951904297 seconds.
UPDATE mdl_mnet_sso_access_control SET username = REPLACE(username, ?, ?) WHERE username IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014305114746094 seconds.
UPDATE mdl_mnet_sso_access_control SET accessctrl = REPLACE(accessctrl, ?, ?) WHERE accessctrl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.058716058731079 seconds.
UPDATE mdl_mnetservice_enrol_courses SET categoryname = REPLACE(categoryname, ?, ?) WHERE categoryname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024986267089844 seconds.
UPDATE mdl_mnetservice_enrol_courses SET fullname = REPLACE(fullname, ?, ?) WHERE fullname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023412704467773 seconds.
UPDATE mdl_mnetservice_enrol_courses SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020694732666016 seconds.
UPDATE mdl_mnetservice_enrol_courses SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022506713867188 seconds.
UPDATE mdl_mnetservice_enrol_courses SET summary = REPLACE(summary, ?, ?) WHERE summary IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021195411682129 seconds.
UPDATE mdl_mnetservice_enrol_courses SET rolename = REPLACE(rolename, ?, ?) WHERE rolename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020503997802734 seconds.
UPDATE mdl_mnetservice_enrol_enrolments SET rolename = REPLACE(rolename, ?, ?) WHERE rolename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022506713867188 seconds.
UPDATE mdl_mnetservice_enrol_enrolments SET enroltype = REPLACE(enroltype, ?, ?) WHERE enroltype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021696090698242 seconds.
UPDATE mdl_modules SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024700164794922 seconds.
UPDATE mdl_modules SET search = REPLACE(search, ?, ?) WHERE search IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022697448730469 seconds.
UPDATE mdl_my_pages SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022697448730469 seconds.
UPDATE mdl_page SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00034594535827637 seconds.
UPDATE mdl_page SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025701522827148 seconds.
UPDATE mdl_page SET content = REPLACE(content, ?, ?) WHERE content IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0005640983581543 seconds.
UPDATE mdl_page SET displayoptions = REPLACE(displayoptions, ?, ?) WHERE displayoptions IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024580955505371 seconds.
UPDATE mdl_portfolio_instance SET plugin = REPLACE(plugin, ?, ?) WHERE plugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00031590461730957 seconds.
UPDATE mdl_portfolio_instance SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020885467529297 seconds.
UPDATE mdl_portfolio_instance_config SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025486946105957 seconds.
UPDATE mdl_portfolio_instance_config SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024318695068359 seconds.
UPDATE mdl_portfolio_instance_user SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022292137145996 seconds.
UPDATE mdl_portfolio_instance_user SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022602081298828 seconds.
UPDATE mdl_portfolio_log SET caller_class = REPLACE(caller_class, ?, ?) WHERE caller_class IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022697448730469 seconds.
UPDATE mdl_portfolio_log SET caller_file = REPLACE(caller_file, ?, ?) WHERE caller_file IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020885467529297 seconds.
UPDATE mdl_portfolio_log SET caller_component = REPLACE(caller_component, ?, ?) WHERE caller_component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0005040168762207 seconds.
UPDATE mdl_portfolio_log SET caller_sha1 = REPLACE(caller_sha1, ?, ?) WHERE caller_sha1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021696090698242 seconds.
UPDATE mdl_portfolio_log SET returnurl = REPLACE(returnurl, ?, ?) WHERE returnurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022697448730469 seconds.
UPDATE mdl_portfolio_log SET continueurl = REPLACE(continueurl, ?, ?) WHERE continueurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020384788513184 seconds.
UPDATE mdl_portfolio_mahara_queue SET token = REPLACE(token, ?, ?) WHERE token IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025296211242676 seconds.
UPDATE mdl_portfolio_tempdata SET data = REPLACE(data, ?, ?) WHERE data IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022387504577637 seconds.
UPDATE mdl_post SET module = REPLACE(module, ?, ?) WHERE module IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025796890258789 seconds.
UPDATE mdl_post SET subject = REPLACE(subject, ?, ?) WHERE subject IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023794174194336 seconds.
UPDATE mdl_post SET summary = REPLACE(summary, ?, ?) WHERE summary IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002129077911377 seconds.
UPDATE mdl_post SET content = REPLACE(content, ?, ?) WHERE content IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022602081298828 seconds.
UPDATE mdl_post SET uniquehash = REPLACE(uniquehash, ?, ?) WHERE uniquehash IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021982192993164 seconds.
UPDATE mdl_post SET attachment = REPLACE(attachment, ?, ?) WHERE attachment IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020599365234375 seconds.
UPDATE mdl_post SET publishstate = REPLACE(publishstate, ?, ?) WHERE publishstate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022792816162109 seconds.
UPDATE mdl_profiling SET runid = REPLACE(runid, ?, ?) WHERE runid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022721290588379 seconds.
UPDATE mdl_profiling SET url = REPLACE(url, ?, ?) WHERE url IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021004676818848 seconds.
UPDATE mdl_profiling SET data = REPLACE(data, ?, ?) WHERE data IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021600723266602 seconds.
UPDATE mdl_profiling SET runcomment = REPLACE(runcomment, ?, ?) WHERE runcomment IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020289421081543 seconds.
UPDATE mdl_publication SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024986267089844 seconds.
UPDATE mdl_publication SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022411346435547 seconds.
UPDATE mdl_publication SET allowedfiletypes = REPLACE(allowedfiletypes, ?, ?) WHERE allowedfiletypes IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022602081298828 seconds.
UPDATE mdl_publication_file SET filename = REPLACE(filename, ?, ?) WHERE filename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025701522827148 seconds.
UPDATE mdl_publication_file SET contenthash = REPLACE(contenthash, ?, ?) WHERE contenthash IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020909309387207 seconds.
UPDATE mdl_qtype_essay_options SET responseformat = REPLACE(responseformat, ?, ?) WHERE responseformat IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023102760314941 seconds.
UPDATE mdl_qtype_essay_options SET graderinfo = REPLACE(graderinfo, ?, ?) WHERE graderinfo IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024318695068359 seconds.
UPDATE mdl_qtype_essay_options SET responsetemplate = REPLACE(responsetemplate, ?, ?) WHERE responsetemplate IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022196769714355 seconds.
UPDATE mdl_qtype_match_options SET correctfeedback = REPLACE(correctfeedback, ?, ?) WHERE correctfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.000244140625 seconds.
UPDATE mdl_qtype_match_options SET partiallycorrectfeedback = REPLACE(partiallycorrectfeedback, ?, ?) WHERE partiallycorrectfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021100044250488 seconds.
UPDATE mdl_qtype_match_options SET incorrectfeedback = REPLACE(incorrectfeedback, ?, ?) WHERE incorrectfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022792816162109 seconds.
UPDATE mdl_qtype_match_subquestions SET questiontext = REPLACE(questiontext, ?, ?) WHERE questiontext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024604797363281 seconds.
UPDATE mdl_qtype_match_subquestions SET answertext = REPLACE(answertext, ?, ?) WHERE answertext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024318695068359 seconds.
UPDATE mdl_qtype_multichoice_options SET correctfeedback = REPLACE(correctfeedback, ?, ?) WHERE correctfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00061297416687012 seconds.
UPDATE mdl_qtype_multichoice_options SET partiallycorrectfeedback = REPLACE(partiallycorrectfeedback, ?, ?) WHERE partiallycorrectfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00056290626525879 seconds.
UPDATE mdl_qtype_multichoice_options SET incorrectfeedback = REPLACE(incorrectfeedback, ?, ?) WHERE incorrectfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00052285194396973 seconds.
UPDATE mdl_qtype_multichoice_options SET answernumbering = REPLACE(answernumbering, ?, ?) WHERE answernumbering IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00049901008605957 seconds.
UPDATE mdl_qtype_randomsamatch_options SET correctfeedback = REPLACE(correctfeedback, ?, ?) WHERE correctfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024700164794922 seconds.
UPDATE mdl_qtype_randomsamatch_options SET partiallycorrectfeedback = REPLACE(partiallycorrectfeedback, ?, ?) WHERE partiallycorrectfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022578239440918 seconds.
UPDATE mdl_qtype_randomsamatch_options SET incorrectfeedback = REPLACE(incorrectfeedback, ?, ?) WHERE incorrectfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002281665802002 seconds.
UPDATE mdl_question SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0015749931335449 seconds.
UPDATE mdl_question SET questiontext = REPLACE(questiontext, ?, ?) WHERE questiontext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0020370483398438 seconds.
UPDATE mdl_question SET generalfeedback = REPLACE(generalfeedback, ?, ?) WHERE generalfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0045750141143799 seconds.
UPDATE mdl_question SET qtype = REPLACE(qtype, ?, ?) WHERE qtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0020439624786377 seconds.
UPDATE mdl_question SET stamp = REPLACE(stamp, ?, ?) WHERE stamp IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0021388530731201 seconds.
UPDATE mdl_question SET version = REPLACE(version, ?, ?) WHERE version IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0091941356658936 seconds.
UPDATE mdl_question_answers SET answer = REPLACE(answer, ?, ?) WHERE answer IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0017828941345215 seconds.
UPDATE mdl_question_answers SET feedback = REPLACE(feedback, ?, ?) WHERE feedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0015590190887451 seconds.
UPDATE mdl_question_attempt_step_data SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.01799201965332 seconds.
UPDATE mdl_question_attempt_step_data SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.019004106521606 seconds.
UPDATE mdl_question_attempt_steps SET state = REPLACE(state, ?, ?) WHERE state IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.016494035720825 seconds.
UPDATE mdl_question_attempts SET behaviour = REPLACE(behaviour, ?, ?) WHERE behaviour IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.011689901351929 seconds.
UPDATE mdl_question_attempts SET questionsummary = REPLACE(questionsummary, ?, ?) WHERE questionsummary IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.016363859176636 seconds.
UPDATE mdl_question_attempts SET rightanswer = REPLACE(rightanswer, ?, ?) WHERE rightanswer IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.011645078659058 seconds.
UPDATE mdl_question_attempts SET responsesummary = REPLACE(responsesummary, ?, ?) WHERE responsesummary IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.011723041534424 seconds.
UPDATE mdl_question_calculated SET tolerance = REPLACE(tolerance, ?, ?) WHERE tolerance IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019001960754395 seconds.
UPDATE mdl_question_calculated_options SET correctfeedback = REPLACE(correctfeedback, ?, ?) WHERE correctfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018978118896484 seconds.
UPDATE mdl_question_calculated_options SET partiallycorrectfeedback = REPLACE(partiallycorrectfeedback, ?, ?) WHERE partiallycorrectfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014901161193848 seconds.
UPDATE mdl_question_calculated_options SET incorrectfeedback = REPLACE(incorrectfeedback, ?, ?) WHERE incorrectfeedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017285346984863 seconds.
UPDATE mdl_question_calculated_options SET answernumbering = REPLACE(answernumbering, ?, ?) WHERE answernumbering IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014281272888184 seconds.
UPDATE mdl_question_categories SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018906593322754 seconds.
UPDATE mdl_question_categories SET info = REPLACE(info, ?, ?) WHERE info IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018596649169922 seconds.
UPDATE mdl_question_categories SET stamp = REPLACE(stamp, ?, ?) WHERE stamp IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016999244689941 seconds.
UPDATE mdl_question_dataset_definitions SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017905235290527 seconds.
UPDATE mdl_question_dataset_definitions SET options = REPLACE(options, ?, ?) WHERE options IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018095970153809 seconds.
UPDATE mdl_question_dataset_items SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00018191337585449 seconds.
UPDATE mdl_question_hints SET hint = REPLACE(hint, ?, ?) WHERE hint IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026702880859375 seconds.
UPDATE mdl_question_hints SET options = REPLACE(options, ?, ?) WHERE options IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023412704467773 seconds.
UPDATE mdl_question_multianswer SET sequence = REPLACE(sequence, ?, ?) WHERE sequence IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024199485778809 seconds.
UPDATE mdl_question_numerical SET tolerance = REPLACE(tolerance, ?, ?) WHERE tolerance IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002899169921875 seconds.
UPDATE mdl_question_numerical_units SET unit = REPLACE(unit, ?, ?) WHERE unit IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002591609954834 seconds.
UPDATE mdl_question_response_analysis SET hashcode = REPLACE(hashcode, ?, ?) WHERE hashcode IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026607513427734 seconds.
UPDATE mdl_question_response_analysis SET whichtries = REPLACE(whichtries, ?, ?) WHERE whichtries IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023412704467773 seconds.
UPDATE mdl_question_response_analysis SET subqid = REPLACE(subqid, ?, ?) WHERE subqid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022792816162109 seconds.
UPDATE mdl_question_response_analysis SET aid = REPLACE(aid, ?, ?) WHERE aid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021600723266602 seconds.
UPDATE mdl_question_response_analysis SET response = REPLACE(response, ?, ?) WHERE response IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023603439331055 seconds.
UPDATE mdl_question_statistics SET hashcode = REPLACE(hashcode, ?, ?) WHERE hashcode IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023198127746582 seconds.
UPDATE mdl_question_statistics SET subquestions = REPLACE(subquestions, ?, ?) WHERE subquestions IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021195411682129 seconds.
UPDATE mdl_question_statistics SET positions = REPLACE(positions, ?, ?) WHERE positions IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020694732666016 seconds.
UPDATE mdl_question_usages SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00035786628723145 seconds.
UPDATE mdl_question_usages SET preferredbehaviour = REPLACE(preferredbehaviour, ?, ?) WHERE preferredbehaviour IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00035595893859863 seconds.
UPDATE mdl_quiz SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00036311149597168 seconds.
UPDATE mdl_quiz SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025200843811035 seconds.
UPDATE mdl_quiz SET overduehandling = REPLACE(overduehandling, ?, ?) WHERE overduehandling IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002598762512207 seconds.
UPDATE mdl_quiz SET preferredbehaviour = REPLACE(preferredbehaviour, ?, ?) WHERE preferredbehaviour IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023889541625977 seconds.
UPDATE mdl_quiz SET navmethod = REPLACE(navmethod, ?, ?) WHERE navmethod IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023794174194336 seconds.
UPDATE mdl_quiz SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025081634521484 seconds.
UPDATE mdl_quiz SET subnet = REPLACE(subnet, ?, ?) WHERE subnet IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023198127746582 seconds.
UPDATE mdl_quiz SET browsersecurity = REPLACE(browsersecurity, ?, ?) WHERE browsersecurity IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023293495178223 seconds.
UPDATE mdl_quiz_attempts SET layout = REPLACE(layout, ?, ?) WHERE layout IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0006718635559082 seconds.
UPDATE mdl_quiz_attempts SET state = REPLACE(state, ?, ?) WHERE state IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0003972053527832 seconds.
UPDATE mdl_quiz_feedback SET feedbacktext = REPLACE(feedbacktext, ?, ?) WHERE feedbacktext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002598762512207 seconds.
UPDATE mdl_quiz_overrides SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022721290588379 seconds.
UPDATE mdl_quiz_reports SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024795532226562 seconds.
UPDATE mdl_quiz_reports SET capability = REPLACE(capability, ?, ?) WHERE capability IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023698806762695 seconds.
UPDATE mdl_quiz_statistics SET hashcode = REPLACE(hashcode, ?, ?) WHERE hashcode IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022602081298828 seconds.
UPDATE mdl_rating SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022411346435547 seconds.
UPDATE mdl_rating SET ratingarea = REPLACE(ratingarea, ?, ?) WHERE ratingarea IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024604797363281 seconds.
UPDATE mdl_registration_hubs SET token = REPLACE(token, ?, ?) WHERE token IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002281665802002 seconds.
UPDATE mdl_registration_hubs SET hubname = REPLACE(hubname, ?, ?) WHERE hubname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021100044250488 seconds.
UPDATE mdl_registration_hubs SET huburl = REPLACE(huburl, ?, ?) WHERE huburl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025391578674316 seconds.
UPDATE mdl_registration_hubs SET secret = REPLACE(secret, ?, ?) WHERE secret IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021004676818848 seconds.
UPDATE mdl_repository SET type = REPLACE(type, ?, ?) WHERE type IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024890899658203 seconds.
UPDATE mdl_repository_instances SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023698806762695 seconds.
UPDATE mdl_repository_instances SET username = REPLACE(username, ?, ?) WHERE username IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029993057250977 seconds.
UPDATE mdl_repository_instances SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002138614654541 seconds.
UPDATE mdl_resource SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00049710273742676 seconds.
UPDATE mdl_resource SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0005340576171875 seconds.
UPDATE mdl_resource SET displayoptions = REPLACE(displayoptions, ?, ?) WHERE displayoptions IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0004580020904541 seconds.
UPDATE mdl_resource_old SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023889541625977 seconds.
UPDATE mdl_resource_old SET type = REPLACE(type, ?, ?) WHERE type IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024986267089844 seconds.
UPDATE mdl_resource_old SET reference = REPLACE(reference, ?, ?) WHERE reference IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020790100097656 seconds.
UPDATE mdl_resource_old SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020384788513184 seconds.
UPDATE mdl_resource_old SET alltext = REPLACE(alltext, ?, ?) WHERE alltext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025105476379395 seconds.
UPDATE mdl_resource_old SET popup = REPLACE(popup, ?, ?) WHERE popup IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0003960132598877 seconds.
UPDATE mdl_resource_old SET options = REPLACE(options, ?, ?) WHERE options IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021791458129883 seconds.
UPDATE mdl_resource_old SET newmodule = REPLACE(newmodule, ?, ?) WHERE newmodule IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021100044250488 seconds.
UPDATE mdl_role SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026416778564453 seconds.
UPDATE mdl_role SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021505355834961 seconds.
UPDATE mdl_role SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021982192993164 seconds.
UPDATE mdl_role SET archetype = REPLACE(archetype, ?, ?) WHERE archetype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024700164794922 seconds.
UPDATE mdl_role_assignments SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029802322387695 seconds.
UPDATE mdl_role_capabilities SET capability = REPLACE(capability, ?, ?) WHERE capability IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0018279552459717 seconds.
UPDATE mdl_role_names SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029087066650391 seconds.
UPDATE mdl_scale SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026512145996094 seconds.
UPDATE mdl_scale SET scale = REPLACE(scale, ?, ?) WHERE scale IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021791458129883 seconds.
UPDATE mdl_scale SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021791458129883 seconds.
UPDATE mdl_scale_history SET source = REPLACE(source, ?, ?) WHERE source IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023603439331055 seconds.
UPDATE mdl_scale_history SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023484230041504 seconds.
UPDATE mdl_scale_history SET scale = REPLACE(scale, ?, ?) WHERE scale IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024795532226562 seconds.
UPDATE mdl_scale_history SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022292137145996 seconds.
UPDATE mdl_scorm SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00027608871459961 seconds.
UPDATE mdl_scorm SET scormtype = REPLACE(scormtype, ?, ?) WHERE scormtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021100044250488 seconds.
UPDATE mdl_scorm SET reference = REPLACE(reference, ?, ?) WHERE reference IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024294853210449 seconds.
UPDATE mdl_scorm SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020790100097656 seconds.
UPDATE mdl_scorm SET version = REPLACE(version, ?, ?) WHERE version IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020694732666016 seconds.
UPDATE mdl_scorm SET sha1hash = REPLACE(sha1hash, ?, ?) WHERE sha1hash IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023508071899414 seconds.
UPDATE mdl_scorm SET md5hash = REPLACE(md5hash, ?, ?) WHERE md5hash IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021100044250488 seconds.
UPDATE mdl_scorm SET options = REPLACE(options, ?, ?) WHERE options IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020313262939453 seconds.
UPDATE mdl_scorm_aicc_session SET hacpsession = REPLACE(hacpsession, ?, ?) WHERE hacpsession IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022602081298828 seconds.
UPDATE mdl_scorm_aicc_session SET scormmode = REPLACE(scormmode, ?, ?) WHERE scormmode IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020813941955566 seconds.
UPDATE mdl_scorm_aicc_session SET scormstatus = REPLACE(scormstatus, ?, ?) WHERE scormstatus IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002129077911377 seconds.
UPDATE mdl_scorm_aicc_session SET lessonstatus = REPLACE(lessonstatus, ?, ?) WHERE lessonstatus IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021505355834961 seconds.
UPDATE mdl_scorm_aicc_session SET sessiontime = REPLACE(sessiontime, ?, ?) WHERE sessiontime IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023794174194336 seconds.
UPDATE mdl_scorm_scoes SET manifest = REPLACE(manifest, ?, ?) WHERE manifest IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022196769714355 seconds.
UPDATE mdl_scorm_scoes SET organization = REPLACE(organization, ?, ?) WHERE organization IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024008750915527 seconds.
UPDATE mdl_scorm_scoes SET parent = REPLACE(parent, ?, ?) WHERE parent IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023102760314941 seconds.
UPDATE mdl_scorm_scoes SET identifier = REPLACE(identifier, ?, ?) WHERE identifier IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023484230041504 seconds.
UPDATE mdl_scorm_scoes SET launch = REPLACE(launch, ?, ?) WHERE launch IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023198127746582 seconds.
UPDATE mdl_scorm_scoes SET scormtype = REPLACE(scormtype, ?, ?) WHERE scormtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020194053649902 seconds.
UPDATE mdl_scorm_scoes SET title = REPLACE(title, ?, ?) WHERE title IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020480155944824 seconds.
UPDATE mdl_scorm_scoes_data SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023889541625977 seconds.
UPDATE mdl_scorm_scoes_data SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020503997802734 seconds.
UPDATE mdl_scorm_scoes_track SET element = REPLACE(element, ?, ?) WHERE element IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022006034851074 seconds.
UPDATE mdl_scorm_scoes_track SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020718574523926 seconds.
UPDATE mdl_scorm_seq_objective SET objectiveid = REPLACE(objectiveid, ?, ?) WHERE objectiveid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00028014183044434 seconds.
UPDATE mdl_scorm_seq_rolluprule SET childactivityset = REPLACE(childactivityset, ?, ?) WHERE childactivityset IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024294853210449 seconds.
UPDATE mdl_scorm_seq_rolluprule SET conditioncombination = REPLACE(conditioncombination, ?, ?) WHERE conditioncombination IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024580955505371 seconds.
UPDATE mdl_scorm_seq_rolluprule SET action = REPLACE(action, ?, ?) WHERE action IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020503997802734 seconds.
UPDATE mdl_scorm_seq_rolluprulecond SET operator = REPLACE(operator, ?, ?) WHERE operator IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025796890258789 seconds.
UPDATE mdl_scorm_seq_rolluprulecond SET cond = REPLACE(cond, ?, ?) WHERE cond IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023293495178223 seconds.
UPDATE mdl_scorm_seq_rulecond SET refrencedobjective = REPLACE(refrencedobjective, ?, ?) WHERE refrencedobjective IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022506713867188 seconds.
UPDATE mdl_scorm_seq_rulecond SET operator = REPLACE(operator, ?, ?) WHERE operator IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024008750915527 seconds.
UPDATE mdl_scorm_seq_rulecond SET cond = REPLACE(cond, ?, ?) WHERE cond IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022006034851074 seconds.
UPDATE mdl_scorm_seq_ruleconds SET conditioncombination = REPLACE(conditioncombination, ?, ?) WHERE conditioncombination IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022697448730469 seconds.
UPDATE mdl_scorm_seq_ruleconds SET action = REPLACE(action, ?, ?) WHERE action IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002291202545166 seconds.
UPDATE mdl_stats_daily SET stattype = REPLACE(stattype, ?, ?) WHERE stattype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0032639503479004 seconds.
UPDATE mdl_stats_monthly SET stattype = REPLACE(stattype, ?, ?) WHERE stattype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00073790550231934 seconds.
UPDATE mdl_stats_user_daily SET stattype = REPLACE(stattype, ?, ?) WHERE stattype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00098896026611328 seconds.
UPDATE mdl_stats_user_monthly SET stattype = REPLACE(stattype, ?, ?) WHERE stattype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00059914588928223 seconds.
UPDATE mdl_stats_user_weekly SET stattype = REPLACE(stattype, ?, ?) WHERE stattype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00089406967163086 seconds.
UPDATE mdl_stats_weekly SET stattype = REPLACE(stattype, ?, ?) WHERE stattype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0013949871063232 seconds.
UPDATE mdl_survey SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024294853210449 seconds.
UPDATE mdl_survey SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026297569274902 seconds.
UPDATE mdl_survey SET questions = REPLACE(questions, ?, ?) WHERE questions IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021505355834961 seconds.
UPDATE mdl_survey_analysis SET notes = REPLACE(notes, ?, ?) WHERE notes IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022101402282715 seconds.
UPDATE mdl_survey_answers SET answer1 = REPLACE(answer1, ?, ?) WHERE answer1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025510787963867 seconds.
UPDATE mdl_survey_answers SET answer2 = REPLACE(answer2, ?, ?) WHERE answer2 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020599365234375 seconds.
UPDATE mdl_survey_questions SET text = REPLACE(text, ?, ?) WHERE text IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00036001205444336 seconds.
UPDATE mdl_survey_questions SET shorttext = REPLACE(shorttext, ?, ?) WHERE shorttext IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00027918815612793 seconds.
UPDATE mdl_survey_questions SET multi = REPLACE(multi, ?, ?) WHERE multi IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00030088424682617 seconds.
UPDATE mdl_survey_questions SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002741813659668 seconds.
UPDATE mdl_survey_questions SET options = REPLACE(options, ?, ?) WHERE options IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00031590461730957 seconds.
UPDATE mdl_tag SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022506713867188 seconds.
UPDATE mdl_tag SET rawname = REPLACE(rawname, ?, ?) WHERE rawname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020623207092285 seconds.
UPDATE mdl_tag SET tagtype = REPLACE(tagtype, ?, ?) WHERE tagtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025177001953125 seconds.
UPDATE mdl_tag SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020790100097656 seconds.
UPDATE mdl_tag_correlation SET correlatedtags = REPLACE(correlatedtags, ?, ?) WHERE correlatedtags IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022315979003906 seconds.
UPDATE mdl_tag_instance SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002288818359375 seconds.
UPDATE mdl_tag_instance SET itemtype = REPLACE(itemtype, ?, ?) WHERE itemtype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021004676818848 seconds.
UPDATE mdl_task_adhoc SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023102760314941 seconds.
UPDATE mdl_task_adhoc SET classname = REPLACE(classname, ?, ?) WHERE classname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020694732666016 seconds.
UPDATE mdl_task_adhoc SET customdata = REPLACE(customdata, ?, ?) WHERE customdata IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024008750915527 seconds.
UPDATE mdl_task_scheduled SET component = REPLACE(component, ?, ?) WHERE component IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026917457580566 seconds.
UPDATE mdl_task_scheduled SET classname = REPLACE(classname, ?, ?) WHERE classname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00027298927307129 seconds.
UPDATE mdl_task_scheduled SET minute = REPLACE(minute, ?, ?) WHERE minute IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024580955505371 seconds.
UPDATE mdl_task_scheduled SET hour = REPLACE(hour, ?, ?) WHERE hour IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026702880859375 seconds.
UPDATE mdl_task_scheduled SET day = REPLACE(day, ?, ?) WHERE day IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024008750915527 seconds.
UPDATE mdl_task_scheduled SET month = REPLACE(month, ?, ?) WHERE month IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023913383483887 seconds.
UPDATE mdl_task_scheduled SET dayofweek = REPLACE(dayofweek, ?, ?) WHERE dayofweek IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00027894973754883 seconds.
UPDATE mdl_timezone SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024795532226562 seconds.
UPDATE mdl_timezone SET tzrule = REPLACE(tzrule, ?, ?) WHERE tzrule IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020813941955566 seconds.
UPDATE mdl_timezone SET dst_time = REPLACE(dst_time, ?, ?) WHERE dst_time IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022101402282715 seconds.
UPDATE mdl_timezone SET std_time = REPLACE(std_time, ?, ?) WHERE std_time IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020790100097656 seconds.
UPDATE mdl_tool_customlang SET lang = REPLACE(lang, ?, ?) WHERE lang IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.025094032287598 seconds.
UPDATE mdl_tool_customlang SET stringid = REPLACE(stringid, ?, ?) WHERE stringid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.026076078414917 seconds.
UPDATE mdl_tool_customlang SET original = REPLACE(original, ?, ?) WHERE original IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.032291173934937 seconds.
UPDATE mdl_tool_customlang SET master = REPLACE(master, ?, ?) WHERE master IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.032023906707764 seconds.
UPDATE mdl_tool_customlang SET local = REPLACE(local, ?, ?) WHERE local IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.018857002258301 seconds.
UPDATE mdl_tool_customlang_components SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00049614906311035 seconds.
UPDATE mdl_tool_customlang_components SET version = REPLACE(version, ?, ?) WHERE version IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00047993659973145 seconds.
UPDATE mdl_tool_monitor_events SET eventname = REPLACE(eventname, ?, ?) WHERE eventname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001981258392334 seconds.
UPDATE mdl_tool_monitor_events SET link = REPLACE(link, ?, ?) WHERE link IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014805793762207 seconds.
UPDATE mdl_tool_monitor_rules SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019001960754395 seconds.
UPDATE mdl_tool_monitor_rules SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014805793762207 seconds.
UPDATE mdl_tool_monitor_rules SET plugin = REPLACE(plugin, ?, ?) WHERE plugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014305114746094 seconds.
UPDATE mdl_tool_monitor_rules SET eventname = REPLACE(eventname, ?, ?) WHERE eventname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015497207641602 seconds.
UPDATE mdl_tool_monitor_rules SET template = REPLACE(template, ?, ?) WHERE template IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019097328186035 seconds.
UPDATE mdl_url SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017094612121582 seconds.
UPDATE mdl_url SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00017404556274414 seconds.
UPDATE mdl_url SET externalurl = REPLACE(externalurl, ?, ?) WHERE externalurl IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014400482177734 seconds.
UPDATE mdl_url SET displayoptions = REPLACE(displayoptions, ?, ?) WHERE displayoptions IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020194053649902 seconds.
UPDATE mdl_url SET parameters = REPLACE(parameters, ?, ?) WHERE parameters IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021719932556152 seconds.
UPDATE mdl_user SET auth = REPLACE(auth, ?, ?) WHERE auth IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00059294700622559 seconds.
UPDATE mdl_user SET username = REPLACE(username, ?, ?) WHERE username IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00051188468933105 seconds.
UPDATE mdl_user SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00057697296142578 seconds.
UPDATE mdl_user SET idnumber = REPLACE(idnumber, ?, ?) WHERE idnumber IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00053286552429199 seconds.
UPDATE mdl_user SET firstname = REPLACE(firstname, ?, ?) WHERE firstname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00051593780517578 seconds.
UPDATE mdl_user SET lastname = REPLACE(lastname, ?, ?) WHERE lastname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00051403045654297 seconds.
UPDATE mdl_user SET email = REPLACE(email, ?, ?) WHERE email IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00052499771118164 seconds.
UPDATE mdl_user SET icq = REPLACE(icq, ?, ?) WHERE icq IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00049710273742676 seconds.
UPDATE mdl_user SET skype = REPLACE(skype, ?, ?) WHERE skype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00044894218444824 seconds.
UPDATE mdl_user SET yahoo = REPLACE(yahoo, ?, ?) WHERE yahoo IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00046586990356445 seconds.
UPDATE mdl_user SET aim = REPLACE(aim, ?, ?) WHERE aim IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00045013427734375 seconds.
UPDATE mdl_user SET msn = REPLACE(msn, ?, ?) WHERE msn IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00042986869812012 seconds.
UPDATE mdl_user SET phone1 = REPLACE(phone1, ?, ?) WHERE phone1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00048398971557617 seconds.
UPDATE mdl_user SET phone2 = REPLACE(phone2, ?, ?) WHERE phone2 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00044488906860352 seconds.
UPDATE mdl_user SET institution = REPLACE(institution, ?, ?) WHERE institution IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00045108795166016 seconds.
UPDATE mdl_user SET department = REPLACE(department, ?, ?) WHERE department IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00043296813964844 seconds.
UPDATE mdl_user SET address = REPLACE(address, ?, ?) WHERE address IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00046896934509277 seconds.
UPDATE mdl_user SET city = REPLACE(city, ?, ?) WHERE city IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00043797492980957 seconds.
UPDATE mdl_user SET country = REPLACE(country, ?, ?) WHERE country IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00047087669372559 seconds.
UPDATE mdl_user SET lang = REPLACE(lang, ?, ?) WHERE lang IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00047397613525391 seconds.
UPDATE mdl_user SET calendartype = REPLACE(calendartype, ?, ?) WHERE calendartype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0004432201385498 seconds.
UPDATE mdl_user SET theme = REPLACE(theme, ?, ?) WHERE theme IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0004279613494873 seconds.
UPDATE mdl_user SET timezone = REPLACE(timezone, ?, ?) WHERE timezone IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00049710273742676 seconds.
UPDATE mdl_user SET lastip = REPLACE(lastip, ?, ?) WHERE lastip IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00045013427734375 seconds.
UPDATE mdl_user SET secret = REPLACE(secret, ?, ?) WHERE secret IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00043416023254395 seconds.
UPDATE mdl_user SET url = REPLACE(url, ?, ?) WHERE url IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00046801567077637 seconds.
UPDATE mdl_user SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00037789344787598 seconds.
UPDATE mdl_user SET imagealt = REPLACE(imagealt, ?, ?) WHERE imagealt IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00044417381286621 seconds.
UPDATE mdl_user SET lastnamephonetic = REPLACE(lastnamephonetic, ?, ?) WHERE lastnamephonetic IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00039100646972656 seconds.
UPDATE mdl_user SET firstnamephonetic = REPLACE(firstnamephonetic, ?, ?) WHERE firstnamephonetic IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00049519538879395 seconds.
UPDATE mdl_user SET middlename = REPLACE(middlename, ?, ?) WHERE middlename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00038409233093262 seconds.
UPDATE mdl_user SET alternatename = REPLACE(alternatename, ?, ?) WHERE alternatename IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00042295455932617 seconds.
UPDATE mdl_user_devices SET appid = REPLACE(appid, ?, ?) WHERE appid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002448558807373 seconds.
UPDATE mdl_user_devices SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014686584472656 seconds.
UPDATE mdl_user_devices SET model = REPLACE(model, ?, ?) WHERE model IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00015592575073242 seconds.
UPDATE mdl_user_devices SET platform = REPLACE(platform, ?, ?) WHERE platform IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00014710426330566 seconds.
UPDATE mdl_user_devices SET version = REPLACE(version, ?, ?) WHERE version IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00016093254089355 seconds.
UPDATE mdl_user_devices SET pushid = REPLACE(pushid, ?, ?) WHERE pushid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0001380443572998 seconds.
UPDATE mdl_user_devices SET uuid = REPLACE(uuid, ?, ?) WHERE uuid IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00013899803161621 seconds.
UPDATE mdl_user_info_category SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00019001960754395 seconds.
UPDATE mdl_user_info_data SET data = REPLACE(data, ?, ?) WHERE data IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020790100097656 seconds.
UPDATE mdl_user_info_field SET shortname = REPLACE(shortname, ?, ?) WHERE shortname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022292137145996 seconds.
UPDATE mdl_user_info_field SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020909309387207 seconds.
UPDATE mdl_user_info_field SET datatype = REPLACE(datatype, ?, ?) WHERE datatype IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023889541625977 seconds.
UPDATE mdl_user_info_field SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021886825561523 seconds.
UPDATE mdl_user_info_field SET defaultdata = REPLACE(defaultdata, ?, ?) WHERE defaultdata IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020384788513184 seconds.
UPDATE mdl_user_info_field SET param1 = REPLACE(param1, ?, ?) WHERE param1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021100044250488 seconds.
UPDATE mdl_user_info_field SET param2 = REPLACE(param2, ?, ?) WHERE param2 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023198127746582 seconds.
UPDATE mdl_user_info_field SET param3 = REPLACE(param3, ?, ?) WHERE param3 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020194053649902 seconds.
UPDATE mdl_user_info_field SET param4 = REPLACE(param4, ?, ?) WHERE param4 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020313262939453 seconds.
UPDATE mdl_user_info_field SET param5 = REPLACE(param5, ?, ?) WHERE param5 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023198127746582 seconds.
UPDATE mdl_user_password_resets SET token = REPLACE(token, ?, ?) WHERE token IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023484230041504 seconds.
UPDATE mdl_user_preferences SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00045204162597656 seconds.
UPDATE mdl_user_preferences SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00044417381286621 seconds.
UPDATE mdl_user_private_key SET script = REPLACE(script, ?, ?) WHERE script IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022602081298828 seconds.
UPDATE mdl_user_private_key SET value = REPLACE(value, ?, ?) WHERE value IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020694732666016 seconds.
UPDATE mdl_user_private_key SET iprestriction = REPLACE(iprestriction, ?, ?) WHERE iprestriction IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024199485778809 seconds.
UPDATE mdl_webdav_locks SET token = REPLACE(token, ?, ?) WHERE token IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022506713867188 seconds.
UPDATE mdl_webdav_locks SET path = REPLACE(path, ?, ?) WHERE path IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00034499168395996 seconds.
UPDATE mdl_webdav_locks SET owner = REPLACE(owner, ?, ?) WHERE owner IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020718574523926 seconds.
UPDATE mdl_wiki SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022697448730469 seconds.
UPDATE mdl_wiki SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024104118347168 seconds.
UPDATE mdl_wiki SET firstpagetitle = REPLACE(firstpagetitle, ?, ?) WHERE firstpagetitle IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020980834960938 seconds.
UPDATE mdl_wiki SET wikimode = REPLACE(wikimode, ?, ?) WHERE wikimode IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020885467529297 seconds.
UPDATE mdl_wiki SET defaultformat = REPLACE(defaultformat, ?, ?) WHERE defaultformat IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00030398368835449 seconds.
UPDATE mdl_wiki_links SET tomissingpage = REPLACE(tomissingpage, ?, ?) WHERE tomissingpage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022602081298828 seconds.
UPDATE mdl_wiki_locks SET sectionname = REPLACE(sectionname, ?, ?) WHERE sectionname IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023508071899414 seconds.
UPDATE mdl_wiki_pages SET title = REPLACE(title, ?, ?) WHERE title IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00037908554077148 seconds.
UPDATE mdl_wiki_pages SET cachedcontent = REPLACE(cachedcontent, ?, ?) WHERE cachedcontent IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020813941955566 seconds.
UPDATE mdl_wiki_synonyms SET pagesynonym = REPLACE(pagesynonym, ?, ?) WHERE pagesynonym IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022602081298828 seconds.
UPDATE mdl_wiki_versions SET content = REPLACE(content, ?, ?) WHERE content IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025010108947754 seconds.
UPDATE mdl_wiki_versions SET contentformat = REPLACE(contentformat, ?, ?) WHERE contentformat IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021600723266602 seconds.
UPDATE mdl_workshop SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023818016052246 seconds.
UPDATE mdl_workshop SET intro = REPLACE(intro, ?, ?) WHERE intro IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00027585029602051 seconds.
UPDATE mdl_workshop SET instructauthors = REPLACE(instructauthors, ?, ?) WHERE instructauthors IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002140998840332 seconds.
UPDATE mdl_workshop SET instructreviewers = REPLACE(instructreviewers, ?, ?) WHERE instructreviewers IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021195411682129 seconds.
UPDATE mdl_workshop SET strategy = REPLACE(strategy, ?, ?) WHERE strategy IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00028514862060547 seconds.
UPDATE mdl_workshop SET evaluation = REPLACE(evaluation, ?, ?) WHERE evaluation IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020813941955566 seconds.
UPDATE mdl_workshop SET conclusion = REPLACE(conclusion, ?, ?) WHERE conclusion IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020790100097656 seconds.
UPDATE mdl_workshop_assessments SET feedbackauthor = REPLACE(feedbackauthor, ?, ?) WHERE feedbackauthor IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002748966217041 seconds.
UPDATE mdl_workshop_assessments SET feedbackreviewer = REPLACE(feedbackreviewer, ?, ?) WHERE feedbackreviewer IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020909309387207 seconds.
UPDATE mdl_workshop_assessments_old SET generalcomment = REPLACE(generalcomment, ?, ?) WHERE generalcomment IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002288818359375 seconds.
UPDATE mdl_workshop_assessments_old SET teachercomment = REPLACE(teachercomment, ?, ?) WHERE teachercomment IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00027799606323242 seconds.
UPDATE mdl_workshop_assessments_old SET newplugin = REPLACE(newplugin, ?, ?) WHERE newplugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020909309387207 seconds.
UPDATE mdl_workshop_comments_old SET comments = REPLACE(comments, ?, ?) WHERE comments IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022721290588379 seconds.
UPDATE mdl_workshop_comments_old SET newplugin = REPLACE(newplugin, ?, ?) WHERE newplugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00028300285339355 seconds.
UPDATE mdl_workshop_elements_old SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022697448730469 seconds.
UPDATE mdl_workshop_elements_old SET newplugin = REPLACE(newplugin, ?, ?) WHERE newplugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024294853210449 seconds.
UPDATE mdl_workshop_grades SET strategy = REPLACE(strategy, ?, ?) WHERE strategy IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022697448730469 seconds.
UPDATE mdl_workshop_grades SET peercomment = REPLACE(peercomment, ?, ?) WHERE peercomment IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023698806762695 seconds.
UPDATE mdl_workshop_grades_old SET feedback = REPLACE(feedback, ?, ?) WHERE feedback IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022506713867188 seconds.
UPDATE mdl_workshop_grades_old SET newplugin = REPLACE(newplugin, ?, ?) WHERE newplugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002601146697998 seconds.
UPDATE mdl_workshop_old SET name = REPLACE(name, ?, ?) WHERE name IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023508071899414 seconds.
UPDATE mdl_workshop_old SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00024008750915527 seconds.
UPDATE mdl_workshop_old SET password = REPLACE(password, ?, ?) WHERE password IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00031113624572754 seconds.
UPDATE mdl_workshop_old SET newplugin = REPLACE(newplugin, ?, ?) WHERE newplugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020909309387207 seconds.
UPDATE mdl_workshop_rubrics_old SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029993057250977 seconds.
UPDATE mdl_workshop_rubrics_old SET newplugin = REPLACE(newplugin, ?, ?) WHERE newplugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020790100097656 seconds.
UPDATE mdl_workshop_stockcomments_old SET comments = REPLACE(comments, ?, ?) WHERE comments IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00031399726867676 seconds.
UPDATE mdl_workshop_stockcomments_old SET newplugin = REPLACE(newplugin, ?, ?) WHERE newplugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022411346435547 seconds.
UPDATE mdl_workshop_submissions SET title = REPLACE(title, ?, ?) WHERE title IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00023221969604492 seconds.
UPDATE mdl_workshop_submissions SET content = REPLACE(content, ?, ?) WHERE content IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00032401084899902 seconds.
UPDATE mdl_workshop_submissions SET feedbackauthor = REPLACE(feedbackauthor, ?, ?) WHERE feedbackauthor IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020790100097656 seconds.
UPDATE mdl_workshop_submissions_old SET title = REPLACE(title, ?, ?) WHERE title IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022792816162109 seconds.
UPDATE mdl_workshop_submissions_old SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.0002739429473877 seconds.
UPDATE mdl_workshop_submissions_old SET newplugin = REPLACE(newplugin, ?, ?) WHERE newplugin IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021195411682129 seconds.
UPDATE mdl_workshopallocation_scheduled SET settings = REPLACE(settings, ?, ?) WHERE settings IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00033187866210938 seconds.
UPDATE mdl_workshopallocation_scheduled SET resultmessage = REPLACE(resultmessage, ?, ?) WHERE resultmessage IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00021004676818848 seconds.
UPDATE mdl_workshopallocation_scheduled SET resultlog = REPLACE(resultlog, ?, ?) WHERE resultlog IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020503997802734 seconds.
UPDATE mdl_workshopform_accumulative SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022792816162109 seconds.
UPDATE mdl_workshopform_comments SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00029397010803223 seconds.
UPDATE mdl_workshopform_numerrors SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00025701522827148 seconds.
UPDATE mdl_workshopform_numerrors SET grade0 = REPLACE(grade0, ?, ?) WHERE grade0 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00031208992004395 seconds.
UPDATE mdl_workshopform_numerrors SET grade1 = REPLACE(grade1, ?, ?) WHERE grade1 IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00020909309387207 seconds.
UPDATE mdl_workshopform_rubric SET description = REPLACE(description, ?, ?) WHERE description IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00026822090148926 seconds.
UPDATE mdl_workshopform_rubric_config SET layout = REPLACE(layout, ?, ?) WHERE layout IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00022220611572266 seconds.
UPDATE mdl_workshopform_rubric_levels SET definition = REPLACE(definition, ?, ?) WHERE definition IS NOT NULL [array ( 0 => 'http://ocol.co.uk/training/', 1 => 'http://training.ocol.co.uk/', )]
Query took: 0.00030708312988281 seconds.
Uhhh ... a small representative output clip would have sufficed. ;)
I see your site fine at: training.ocol.co.uk
At least the images for the theme show ... nothing broken.
Yes, some code is brought into Moodle from api sites ... yahoo specifically ... there is an option to load the local code or in combo.
Think you are closer than you were when ya started! I'll PM ya.
'spirit of sharing', Ken
I found this forum with searching for the truth about unlimited hosting , I myself need to get my moodle hosting set up. I have some questions about shared, but when i searched truth unlimited hosting i saw a post about dedicated is unlimited with no restrictions? Is this correct ? With our project we need true unlimited hosting
My source was this http://www.dailyhosting.net/shared-hosting-vs-dedicated-hosting-big-difference-performance/
You need to hear back from @Daniel in this thread ... not me ... but ... can't resist ....
Think about it a minute ... what does 'unlimited' mean?
Am not even going over to the link provided to read it because if they are advertising 'unlimited' one had better read the fine print ... that's probably either so small or so hard to find that most folks give up!!!
Am sure the company selling you 'unlimited' hosting is meaning you can purchase as many hosts as you like ... and not that the technology running the servers/services is truely 'unlimited'.
Research how much memory a Linux server can address. Google that ... read it ... then think about the 'unlimited' offer really is.
Ok, since we might need some help ...
https://access.redhat.com/articles/rhel-limits
'spirit of sharing', Ken
Hi nick,
I only have very high praise for unlimited! i have used them from day 1 and can honestly say their support is top notch! even answering the phone 24 hours a day!! although the ticket system is just as quick!
It is unlimited (in terms of bandwidth / traffic) and i have never had any complaints with speed. You will definitely need a Dedicated server (FORGET shared hosting trust me!) we pay around £70 per month for mid range specs but its definitely well worth it just for the dedicated ip.
I hope that helps
Dan
Think you have the paths worked out, but maybe not ownerships/permissions on the data directory for training domain. It's OK to make them globally read/write for everyone cause the directory itself shouldn't be directly accessible.
What I get is error 500's on some files need to generate parts of themes ... etc.
Those apache error 500's could be many things. Check the logs you have for CGI/FastCGI ... there could be tweaks one could change to enable downloading of files - larger files/timeouts, etc.. I don't run a fastcgi but a mod - am not saying you should change that either!
With Debugging on to developer mode the course did NOT display
any errors. But, inspection with a web tool shows
things like an icon error 500 ... Internal Server Error
DNS related?
The reverse lookup on your domain's IP address gets: no-dns-yet.unlimited.uk.net.
So there is a reverse but it doesn't match domain of training.xxxxx.co.uk
Something else might be choaking off downloads ... files are not that large.
Your provider needs to be involved and assist with checking config of apache - copying files is one thing ... having the site function with Moodle 2.8.x is yet another.
In environment test:
unsupported_db_table_row_format if this test fails, it indicates a potential problem
Your database has tables using Antelope as the file format. You are recommended to convert the tables to the Barracuda file format. See the documentation Administration via command line for details of a tool for converting InnoDB tables to Barracuda.
http://docs.moodle.org/28/en/admin/environment/custom_check/unsupported_db_table_row_format
https://docs.moodle.org/en/cli
Am outta ideas for you to try.
'spirit of sharing', Ken
Thanks Again ken.
I will get the host involved on this again with your suggestions.
I have just attempted to convert the barracuda tables as per the guide and its thrown back :
Cannot change GLOBAL innodb_file_format setting, use --showsql option and execute the statements manually.!!! Error writing to database !!!
Its as if this user hasn't got the privileges ? so I was logged into ssh with root and the user for moodle oc... has all privileges!
Would this be related do you think ?
My sandbox site is working properly wouldnt this rule out a server wide php setting issue? The only difference is that the sandbox site is updated to a later version of moodle.. would this help maybe? or would this just confuse an already confusing issue ?
Is there a way of copying this sandbox's site over whilst keeping students changes / work that has been created and added since the sandbox was created (a few months ago now .. )
Thanks Ken
Regards
Dan
The scripts in moodlecode/admin/cli/ read the DB information from config.php. So the DB user in config.php doesn't have the priv level to do that.
If you know the superuser for the DB you could edit config.php file and use that superuser with the superuser password in the script. Then turn the command again. Afterwards, change back the DB user and DB password in config.php.
Yes, if sandbox is working then that does indicate the problem exist with training alone.
Think PHP CGI/fastcgi settings are set per domain ... check your CPanel for such settings for the training domain. If you can find that, check with provider for the location of those files for the training site.
Have 'clients' that run 2.8 sites and have seen no issues like yours. But they do run the highest 2.8.12. And don't re-call seeing any tracker item/bug report like you are experiencing.
"Is there a way of copying this sandbox's site over whilst keeping
students changes / work that has been created and added since the
sandbox was created (a few months ago now."
About the only way to get data from sandbox to training is by saving a full course backup and restoring that backup. That will **NOT** combine anything without some risk ... import backup into an exsisting course might result in duplication and other errors that would difficult to correct.
My advice ... don't do that.
Take a gander at training logs ... apache error log, php error log, etc.. NO don't attach an entire log file to every one to view ... look for related clips - errors having to do with downloading ... if you share back here, do NOT upload the entire log file ... just a few representative lines.
Keep your cool now ... don't do anything drastic!!! ;)
'spirit of sharing', Ken
HI Ken,
Only me again after your wisdom!
I think i have had a breakthrough in the sense of i have found an error log within the public_html - i was asked to look at it by my host they have asked if this is the cause? it says multiple lines of :
PHP Deprecated: Automatically populating $HTTP_RAW_POST_DATA is deprecated and will be removed in a future version. To avoid this warning set 'always_populate_raw_post_data' to '-1' in php.ini and use the php://input stream instead. in Unknown on line 0
[26-May-2016 21:34:31 UTC] PHP Deprecated: Automatically populating $HTTP_RAW_POST_DATA is deprecated and will be removed in a future version. To avoid this warning set 'always_populate_raw_post_data' to '-1' in php.ini and use the php://input stream instead. in Unknown on line 0
I am also getting loads of 500 internal errors still when i inspect elements on safari.
If this is the case what is the best way of editing the php.ini ? and where can i find access.
Thanks Ken
"Testing your patience since 2016"
One thing at a time ... save safari for last ...
The PHP errors however, are significant! In a virtual system like yours, it might be possible to use two different versions of PHP ... the PHP 5.6.x with the training site ... and yet another with your sandbox.
Go to the PHP info in both sites via Moodle Admin UI and look for which php.ini file it loads. That will give you a path to it. Are they pointed to the same php.ini file?
Sandbox works Training doesn't ... sounds like they are pointed to different php.ini's and thus might also be running different versions of PHP!
Admin Moodle 2.8's running CentOS 6 with PHP 5.6 and I haven't seen that error before on those other systems.
BTW, googling for
"PHP Deprecated: Automatically populating $HTTP_RAW_POST_DATA"
one will see that other software (not just Moodle) affected by same ... certain versions of Drupal and WordPress as well.
Since you run multiple apps on your box, a WP at least, keep in mind that changes one might make for Moodle might have a domino affect with other software ... IF they run under the same PHP version pulling the same php.ini.
'spirit of sharing', Ken
Wait a minute here ... the hosting company is sharing a reference in a log file they see and asking you to ask in these forums for what could be wrong with the setup of their systems???? Hmmmmm ... can't always blame code. besides that ... this is a warning ... not an error. And php 5.6 is set to log that by default.
PHP Deprecated: Automatically populating $HTTP_RAW_POST_DATA is deprecated
Hmmmm google that ... what you'll get is multiple hits.
Looks to be a change in behavior of php 5.6. that has caught the attention of not only Moodle but other php based apps/scripts.
Hmmmm how much is your hosting provider gonna pay for this tip on php 5.6?
always_populate_raw_post_data=-1in php.ini.
Hmmmm some more and MORE IMPORTANTLY ... when are they gonna upgrade PHP to 7?
'spirit of sharing', Ken
Once that is gone, then see about whatever else may be causing problems, but an error in your config.php is going to lead to problems of some description anyway and so needs to be fixed - especially as L20 could be around where teh wwwroot and dataroot are configured (they are L20 and 21 in my localhost for example)