GitLab

Maria Sorica authored Dec 28, 2017 and Cecilia Vela Gurovic committed Jan 19, 2018

On site update, delete Privacy Statement from the 'site_content'
table and add it to the 'site_content_version' table.

behatnotneeded

Change-Id: Idd765bad0e72165c940e5f6090d3c8861ae8fcd5

Maria Sorica authored Dec 28, 2017 and Robert Lyon committed Jan 09, 2018

behatnotneeded

Change-Id: I2cecf16fbbd54b8e4b95ba9d78c51c34d19171f4

This way if we ever query / display who has edited the content we can
know user = 0 is the installed version.

behatnotneeded

Change-Id: I81973a315d7953f29249425ae52712ec2334634f
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Maria Sorica authored Jan 03, 2018 and Robert Lyon committed Jan 09, 2018

behatnotneeded

Change-Id: Ifabd4eade9fe94ed2dd1d61ed041a36544be74be

behatnotneeded

Change-Id: I0037ead6646e002c5cf96b43343f9aefc1a71754

The changes should allow ithe install of either a utf8 or utf8mb4 site

behatnotneeded

Change-Id: I23479c50f2dc2ac197f244cf723a60e79f88c561
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Due to not using an alias for the view table

The code is correct for MySql though

behatnotneeded

Change-Id: I5622bde057c70cf7d140044ac213bf3f299abefc
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Forgot to wrap the table name event_log with curly brackets.

Sponsored by Australian National University

behatnotneeded

Change-Id: Ia598632b1f0ae177fe646312ea5c2b38a9e83d51

Several issues resolved:
1. The event_log.time column has been removed
and replaced by ctime. The handl_event() call is using
the new column even though the new column has
not been created yet in the upgrade script.
Therefore, include both columns in the event handling.

2. The 'deleteartefacts' event stores multiple
artefact IDs in the one event_log record. Therefore,
there is not a one-to-one relationship when converting the
record to the new format. Ignore the record when setting
the resourceid and resourcetype.

3. In the 'saveartefact' and 'deleteartefact' events,
not all of the event_log records have 'id' and 'artefact'.
Ignore setting the resourceid and resourcetype fields
when the data is not available.

4. For newer versions of Postgres and MySql, utilise
the json dattype to convert the data held in the
event_log.data column. This will speed up the
processing of the table for sites with large data
in the event_log table.

Sponsored by Australian National University

behatnotneeded

Change-Id: If068dac825b9cef6301cd970f0a368124a67b3f1

Cecilia Vela Gurovic authored Nov 16, 2016 and Robert Lyon committed Nov 17, 2017

Added new html custom filter to allow
voki embed code with javascript tags.

issue with the creation/edition of blocks:

Voki embed code its a javascript code that loads
js functions from a remote file and makes a call to a
AC_Voki_Embed() function

parameters:

function AC_Voki_Embed (width, height, chsm, sc,
transparent, bgcolor, returnFlag, playerType)

The number of parameter makes the difference between
old and new voki code. The old one will have only 7,
the new one will have one more.

The new embed code will have playerType = 1
The function uses an XMLHttpRequest to obtain the
new embed code. When we are loading the page,
there is no problem. But when we are editing or
creating the block, the the connection with the object
gets lost and the embed code is never loaded.
Solution found: reload the page after editing or adding
a block with new voki code.

The old voki code can have
returnFlag = 1 will return a string with the code
returnFlag = 0 will load the embed code in the page (by default)
In this last case, after the function creates the embed code,
it will call document.write('embed code')
if we are loading a page with the embed code, we have no problem
but if we have the page already loaded and we are editing the block
or creating it, the document.write will replace all the html
with the embed code.
Solution found: change parameter of the function so it returns
the code instead, then manually add it in the correct place
of the html.

behatnotneeded

Change-Id: Ieed00b6c6887715b707b8123082a1312f3db1d9c

As per convention when adding an upgrade block

behatnotneeded

Change-Id: Ifb33f6e588093d800ea983347ba888a9c5ed18d2
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Cecilia Vela Gurovic authored Oct 03, 2017 and Robert Lyon committed Oct 31, 2017

removed code from htdocs/api/module/ files and replace it with a json reply error message.
removed the 'allowmobileuploads' config variable since it is only used by the old mobile api.
removed the 'mobileuploadtoken' values in usr_account_preferences since they are only used by old mobile api. The new mahara mobile uses external_tokens table to store its access tokens.

behatnotneeded

Change-Id: I02e94079fc83aa6a81534b70446f7e8ab2ebd7a4

1. when a user logs in it clears any obsolete
   usr_session cookies for the user
2. recording the user-agent of the session
   and if it changes to prompt the user to
   login again
3. when self adding / editing email address(es)
   send 2 emails
	- one to the new email address asking user to confirm address
	- and one to the primary email address to alert user
	that a new email is being added to their account and
	if this is bad how to contact their admin about the problem.

behatnotneeded
Change-Id: Ia44b66cf831abd553b72aa8b1d58d2a2634863b8

As part of the db upgrade process. This allows us to turn the triggers
off while updating a certain table and turning them on again afterwards.

behatnotneeded

Change-Id: I5d6f2f7fb7075fca5fe8c811820abe87d92790b3
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

So that they have artefact_file_embedded rows associated with them and
can display to non-admins

behatnotneeded

Change-Id: I477a910637ffc53e0e5be9ed44d0188f49b61bad
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

behatnotneeded

Change-Id: I589cc42dd543ea4edfa418de8b85b711d3f0dd3e
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Now that it has been obsolete for 1 year

behatnotneeded

Change-Id: Ifa784d9e815b950e4d8725a99acfc57e098ade65
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

This value would be present in < 1.10 versions

behatnotneeded

Change-Id: Ic92beea1a209580f798716227a7c53fb600a8869
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

We want to record things like so:

resourceid = view_access.id
resourcetype = what type the view_access row is for, eg 'token',
'user', 'loggedin' etc
parentresourceid = the id if the view the access is for
parentresourcetype = 'view';
ownerid = the id of the owning resource, eg usr.id / group.id / institution.name
ownertype = what owns the resource, eg user / group / institution

Also this patch adjusts how we index things into elasticsearch

behatnotneeded

Change-Id: I079a42ded2fefaab64a6e49fc26e8aad303c9e8a
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Add 5 new new columns to event_log table make searching over the
data easier and also record the id of any parent/related info as well

Eg, if one deletes an image block from a page we now record:
id - the event id
resourceid - the block id
resourcetype - the blocktype, eg image
parentresourceid - the id of the parent, eg view id
parentresourcetype - the type of parent, eg 'view'

Because we would not be able to find related view info from just the
block id anymore.

Also added the ability to index and search over event information in
elasticsearch search type event_log

Change-Id: I280c1c75c35a6c58f42d8acb36cf5c24c70b902d
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

behatnotneeded - to come later

Change-Id: I42f40d997559c4fda132e9c36dc8e2c9d016c61e
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

behatnotneeded

Change-Id: I488cc4cfffdc9c30f67f001c6d7ce72ae71cc20d

As part of the install process

behatnotneeded

Change-Id: I0d74698a61f74508d2ab8ed5dcb4695e39a0c3fd
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Ilya Tregubov authored Jun 01, 2017 and Robert Lyon committed Jul 08, 2017

behatnotneeded

Change-Id: I26a13d2ef060078abd14bb21a61db147112a4100

Added db upgrade where we update only the existing groupviews blocks where:
1) the group is submittable to
2) no choice has been selected to view submissions

This way we don't accidentially overwrite a user's choice

behatnotneeded

Change-Id: Idd50fe3a75a7434cbbd5ff30d755708c9f855e7b
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Cecilia Vela Gurovic authored May 24, 2017 and Robert Lyon committed Jun 29, 2017

behatnotneeded

Change-Id: Ic74144a55e7e3f8e82380b6d5394e258787e0471

Making the admin/statistics.php obsolete and getting admin/users/statistics.php
to do the work.

The institution 'all' shows the site statistics

Sponsored by University of Sussex and Dublin City University

behatnotneeded

Change-Id: Ic2fb9d4ef355fdc5e5527c1ce776463d821c0c08
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

This patch only deals with:
1) removing passwords from existing event_log table data
2) stopping the recording of passwords into the event_log table
3) sets the reset password on next login for those users

It doesn't deal with removing the unnecessary cruft information
that will be handled by the bug 1692385

behatnotneeded

Change-Id: Id29148f78fa6918f5f5afcb89d211ccb3b60c95b
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

When copying a page with an annotation artefact on it

behatnotneeded

Change-Id: Ib40e6c4fdf2c31830c3855dcd5b5eedbcebce875
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Change-Id: Ib68c1b57bf8910702678b43b4499456ed88b53dc

Allow to set the theme in view table on the DB only when
  we have userscanchooseviewthemes = true and
  the theme is set when we are editing page

behatnotneeded

Change-Id: I16ef25e8efa6060aa7e5a30a44ed2f4698f6d625

To avoid potential upgrade problems

Change-Id: If2c70c092aa5e71e02e7180a9dc7062640f3ac9a
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

behatnotneeded
Change-Id: If45120ccbd387b7198a3e15b666d43f14386a9a2

Problem when upgrading from version where smartevidence does not exist

behatnotneeded

Change-Id: If2797efafa84fc3e6a90e9aef95ed4f4a3097796
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Kristina Hoeppner authored Jan 16, 2017 and Robert Lyon committed Feb 25, 2017

Fixing a spelling mistake in English.
No string ID change required.

behatnotneeded

Change-Id: Ie00c6ceb061cf0a09e65a4766f6f06ff6ec13075

behatnotneeded

Change-Id: I3a59c08e5bed2a43759cb30e44b246f4f1ea934c
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

This patch allows the dataroot/metadata/*.xml file to be named after
the idp rather than the Mahara institution.

Also added
- A select dropdown so that institution can pick existing auth to be
paired to
- Upgrade to rename the dataroot/metadata/*.xml file
- Check to stop being able to add blank metadata field
- An alert for user when updating metadata if other institutions are also being effected
- Delete the metadata if deleted institution is only one using it

behatnotneeded

Change-Id: Ie3f5cdc523404b1081352ede67aab591e79b6dbb
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Collection shared to a group was not displaying
in group page and shared with me page
after first page of collection was deleted.
Fixed by resetting the order when deleting a view.

behatnotneeded

Change-Id: I096114ecf50b7a3af6d1393b387073676a984006

To allow us to easily turn of a 'bad' auth when it is trying to
connect to a third party server but that server is not reachable.

Currently it makes logging in slow as it needs to timeout on that auth
instance before trying the next one.

behatnotneeded

Change-Id: Ieeaeeaeb1bc0aa61ed3faad8f3bf751edd9c1023
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>

Evonne Cheung authored Jan 17, 2017 and Robert Lyon committed Jan 25, 2017

behatnotneeded

Change-Id: I68b0b86fe46945dc539193df789fa9f27cc70077