WIKINDX API 6.4.12

UPDATEDATABASE
in package

wikindx

core

startup

UPDATEDATABASE

Update the database as required

$db : mixed: object
$endStepMessage : mixed: string
$interruptStepMessage : mixed: string
$oldTime : mixed: int
$session : mixed: object
$targetVersion : mixed: float
checkConfigFile() : mixed: Check permissions on config.php
CheckDatabaseEngineVersion() : bool: Check if the MySql/MariaDB engine version is right
copyBibContents() : mixed: Copy non-official bibliographic styles (if they exist)
copyFolderContents() : mixed: Copy folder contents Code modified from: https://stackoverflow.com/questions/2082138/move-all-files-in-a-folder-to-another
copyWpContents() : mixed: Copy and update papers in the word processor plugin (if it/they exist)
correctCreators() : mixed: Fix creator errors In some cases, 'resourcecreatorCreatorSurname' does not match the id in resourcecreatorCreatorMain
correctDatetimeFields() : mixed: Correct anomalies in the datetime fields Рthere should be no occurrence of '0000-00-00 00:00:00' as a value.
correctIndices() : mixed: Correct parameters of indices that are varchars by ensuring they have a limited prefix of (100)
createSuperAdmin() : mixed: Intercept for initial configuration by admin and, if necessary, display admin configuration interface (new installation means users table is empty).
displayUpdatePreambule() : mixed: Check and print status of update scripts
endDisplay() : mixed: End to emit the HTML page of the upgrade process
escapePHPDoubleQuotedString() : mixed: Escape a string that should be used as a double quoted string value in PHP code
flushTempStorage() : mixed: Flush the temp_storage table
intervalVersion2publicVersion() : string: Get the minimum public version corresponding to an internal version
pauseUpdateDisplay() : mixed: End an upgrade step by displaying a message and a form
renameTable() : mixed
requestSuperAdminLogin() : mixed: Only the superadmin may update the database -- ask for login
rewriteConfigFile() : mixed: Write new config.php with upgrade to >= WIKINDX v6.4.2
startInstallDisplay() : mixed: Start to emit the HTML page of the upgrade process
startUpdateDisplay() : mixed: Start to emit the HTML page of the upgrade process
styleLocaleFix() : mixed: Fix locale in style XML files
transferStatistics() : mixed: Transfer statistics data to new tables then drop old table
transferUrls() : mixed: Transfer urls data from resource_text to resource_url table
updateCoreInternalVersion() : mixed: Write the internal version in the database
updateDatabase() : mixed: Update the database if required based on the current version
updateImageLinks() : mixed: Update 'images' links in metadata to new images folder location
updatePluginTables() : mixed: Copy papers table (word processor) to new format if it exists then drop it. Upgrade the soundExplorer table
upgradeTo10() : mixed: Upgrade database schema to version 10 (6.0.8)
upgradeTo11() : mixed: Upgrade database schema to version 11 (6.2.1)
upgradeTo12() : mixed: Upgrade database schema to version 12 (6.2.2 - part A)
upgradeTo13() : mixed: Upgrade database schema to version 13 (6.2.2 - part B)
upgradeTo14() : mixed: Upgrade database schema to version 14 (6.2.2 - part C)
upgradeTo15() : mixed: Upgrade database schema to version 15 (6.3.8)
upgradeTo16() : mixed: Upgrade database schema to version 16 (6.3.8)
upgradeTo17() : mixed: Upgrade database schema to version 17 (6.3.8)
upgradeTo18() : mixed: Upgrade database schema to version 18 (6.3.8)
upgradeTo19() : mixed: Upgrade database schema to version 19 (6.3.8)
upgradeTo20() : mixed: Upgrade database schema to version 20 (6.3.8)
upgradeTo21() : mixed: Upgrade database schema to version 21 (6.3.8)
upgradeTo22() : mixed: Upgrade database schema to version 22 (6.3.8)
upgradeTo23() : mixed: Upgrade database schema to version 23 (6.4.0)
upgradeTo24() : mixed: Upgrade database schema to version 24 (6.4.0)
upgradeTo25() : mixed: Upgrade database schema to version 25 (6.4.0)
upgradeTo26() : mixed: Upgrade database schema to version 26 (6.4.0)
upgradeTo27() : mixed: Upgrade database schema to version 27 (6.4.0)
upgradeTo28() : mixed: Upgrade database schema to version 28 (6.4.0)
upgradeTo29() : mixed: Remove unwanted rows in user_bibliography_resource (6.4.0)
upgradeTo30() : mixed: Remove mistakenly named configBrowserTagID from config table (6.4.0)
upgradeTo31() : mixed: Upgrade database schema to version 31 (6.4.0)
upgradeTo32() : mixed: Upgrade database schema to version 32 (6.4.0)
upgradeTo33() : mixed: Upgrade database schema to version 33 (6.4.0)
upgradeTo34() : mixed: Upgrade database schema to version 34 (6.4.0)
upgradeTo35() : mixed: Upgrade database schema to version 35 (6.4.0)
upgradeTo36() : mixed: Upgrade database schema to version 36 (6.4.0)
upgradeTo37() : mixed: Upgrade database schema to version 37 (6.4.0)
upgradeTo38() : mixed: Upgrade database schema to version 38 (6.4.1)
upgradeTo39() : mixed: Upgrade database schema to version 39 (6.4.1)
upgradeTo40() : mixed: Upgrade database schema to version 40 (6.4.1)
upgradeTo41() : mixed: Upgrade database schema to version 41 (6.4.1)
upgradeTo42() : mixed: Upgrade database schema to version 42 (6.4.2)
upgradeTo43() : mixed: Upgrade database schema to version 43 (6.4.2)
upgradeTo44() : mixed: Upgrade database schema to version 44 (6.4.2)
upgradeTo45() : mixed: Upgrade database schema to version 45 (6.4.2)
upgradeTo46() : mixed: Upgrade database schema to version 46 (6.4.4)
upgradeTo47() : mixed: Upgrade database schema to version 47 (6.4.4)
upgradeTo48() : mixed: Upgrade database schema to version 48 (6.4.4)
upgradeTo49() : mixed: Upgrade database schema to version 49 (6.4.4)
upgradeTo50() : mixed: Upgrade database schema to version 50 (6.4.4)
upgradeTo51() : mixed: Upgrade database schema to version 51 (6.4.4)
upgradeTo52() : mixed: Upgrade database to version 52 (6.4.4)
upgradeTo53() : mixed: Upgrade database to version 53 (6.4.4)
upgradeTo54() : mixed: Upgrade database to version 54 (6.4.5)
upgradeTo55() : mixed: Upgrade database to version 55 (6.4.6)
upgradeTo56() : mixed: Upgrade database to version 56 (6.4.6)
upgradeTo57() : mixed: Upgrade database to version 57 (6.4.7)
upgradeTo58() : mixed: Upgrade database schema to version 58 (6.4.7)
upgradeTo59() : mixed: Upgrade database schema to version 59 (6.4.8)
upgradeTo5_2() : mixed: Upgrade database schema to version 5.2
upgradeTo5_3() : mixed: Upgrade database schema to version 5.3
upgradeTo5_4() : mixed: Upgrade database schema to version 5.4.
upgradeTo5_5() : mixed: Upgrade database schema to version 5.5.
upgradeTo5_6() : mixed: Upgrade database schema to version 5.6.
upgradeTo5_7() : mixed: Upgrade database schema to version 5.7.
upgradeTo5_8() : mixed: Upgrade database schema to version 5.8. There are no changes to DB structure so no call to updateDbSchema('5.8').
upgradeTo5_9() : mixed: Upgrade database schema to version 5.9
upgradeTo6() : mixed: Upgrade database schema to version 6
upgradeTo60() : mixed: Upgrade database schema to version 60 (6.4.8)
upgradeTo61() : mixed: Upgrade database schema to version 61 (6.4.8)
upgradeTo62() : mixed: Upgrade database schema to version 62 (6.4.8)
upgradeTo63() : mixed: Upgrade database schema to version 63 (6.4.8)
upgradeTo64() : mixed: Upgrade database schema to version 64 (6.4.8)
upgradeTo65() : mixed: Upgrade database schema to version 65 (6.4.9)
upgradeTo66() : mixed: Upgrade database schema to version 66 (6.4.9)
upgradeTo67() : mixed: Upgrade database schema to version 67 (6.4.9)
upgradeTo68() : mixed: Upgrade database schema to version 68 (6.4.9)
upgradeTo69() : mixed: Upgrade database schema to version 69 (6.4.9)
upgradeTo7() : mixed: Upgrade database schema to version 7 (6.0.4)
upgradeTo70() : mixed: Upgrade database schema to version 70 (6.4.9)
upgradeTo71() : mixed: Upgrade database schema to version 71 (6.4.10)
upgradeTo72() : mixed: Upgrade database schema to version 72 (6.4.11)
upgradeTo8() : mixed: Upgrade database schema to version 8 (6.0.5)
upgradeTo9() : mixed: Upgrade database schema to version 9 (6.0.6)
upgradeToTargetVersion() : mixed: Performs the most common kind of upgrade

$db

object


    private
        mixed
    $db

$endStepMessage

string


    private
        mixed
    $endStepMessage
     = FALSE

$interruptStepMessage

string


    private
        mixed
    $interruptStepMessage
     = FALSE

$oldTime

int


    private
        mixed
    $oldTime

$session

object


    private
        mixed
    $session

$targetVersion

float


    private
        mixed
    $targetVersion
     = NULL

checkConfigFile()

Check permissions on config.php


    private
                checkConfigFile() : mixed

6.4.0 (internal version 32) is the last version to modify the config file

Return values

mixed —

CheckDatabaseEngineVersion()

Check if the MySql/MariaDB engine version is right


    private
                CheckDatabaseEngineVersion() : bool

Return values

bool —

copyBibContents()

Copy non-official bibliographic styles (if they exist)


    private
                copyBibContents() : mixed

Return values

mixed —

copyFolderContents()

Copy folder contents Code modified from: https://stackoverflow.com/questions/2082138/move-all-files-in-a-folder-to-another


    private
                copyFolderContents(mixed $old, mixed $new) : mixed

Parameters

$old : mixed: source folder
$new : mixed: destination folder

Return values

mixed —

copyWpContents()

Copy and update papers in the word processor plugin (if it/they exist)


    private
                copyWpContents() : mixed

Return values

mixed —

correctCreators()

Fix creator errors In some cases, 'resourcecreatorCreatorSurname' does not match the id in resourcecreatorCreatorMain


    private
                correctCreators() : mixed

Return values

mixed —

correctDatetimeFields()

Correct anomalies in the datetime fields Рthere should be no occurrence of '0000-00-00 00:00:00' as a value.


    private
                correctDatetimeFields() : mixed

The strategy is:

If default is NULL, set all incorrect values to that. Otherwise,
Find the minimum value in the table then set all incorrect fields to that. Otherwise,
If all values are incorrect, then set all values to default.

Return values

mixed —

correctIndices()

Correct parameters of indices that are varchars by ensuring they have a limited prefix of (100)


    private
                correctIndices() : mixed

There is no DROP INDEX IF EXISTS . . . syntax so another way must be found to check if the index exists before trying to drop it

Return values

mixed —

createSuperAdmin()

Intercept for initial configuration by admin and, if necessary, display admin configuration interface (new installation means users table is empty).


    private
                createSuperAdmin() : mixed

Return values

mixed —

displayUpdatePreambule()

Check and print status of update scripts


    private
                displayUpdatePreambule() : mixed

Return values

mixed —

endDisplay()

End to emit the HTML page of the upgrade process


    private
                endDisplay() : mixed

The upgrade process needs a separate display function so that it does not depend on the template system while the configuration is incomplete.

Return values

mixed —

escapePHPDoubleQuotedString()

Escape a string that should be used as a double quoted string value in PHP code


    private
                escapePHPDoubleQuotedString(mixed $str) : mixed

Parameters

$str : mixed

Return values

mixed —

flushTempStorage()

Flush the temp_storage table


    private
                flushTempStorage() : mixed

Return values

mixed —

intervalVersion2publicVersion()

Get the minimum public version corresponding to an internal version


    private
                intervalVersion2publicVersion(float $version) : string

Parameters

$version : float: Internal version number

Return values

string —

Public version number

pauseUpdateDisplay()

End an upgrade step by displaying a message and a form


    private
                pauseUpdateDisplay() : mixed

Can be a pause during a too long operation or the end of a step

For an interrupt, fill in the $interruptStepMessage member before calling the function.
For a normal end of step, fill in the endStepMessage member before calling the function.

Return values

mixed —

renameTable()


    private
                renameTable(mixed $tablesrc, mixed $tabledst) : mixed

Parameters

$tablesrc : mixed
$tabledst : mixed

Return values

mixed —

requestSuperAdminLogin()

Only the superadmin may update the database -- ask for login


    private
                requestSuperAdminLogin(string $currentdbVersion) : mixed

Parameters

$currentdbVersion : string

Return values

mixed —

rewriteConfigFile()

Write new config.php with upgrade to >= WIKINDX v6.4.2


    private
                rewriteConfigFile() : mixed

Return values

mixed —

startInstallDisplay()

Start to emit the HTML page of the upgrade process


    private
                startInstallDisplay() : mixed

The upgrade process needs a separate display function so that it does not depend on the template system while the configuration is incomplete.

Return values

mixed —

startUpdateDisplay()

Start to emit the HTML page of the upgrade process


    private
                startUpdateDisplay() : mixed

The upgrade process needs a separate display function so that it does not depend on the template system while the configuration is incomplete.

Return values

mixed —

styleLocaleFix()

Fix locale in style XML files


    private
                styleLocaleFix() : mixed

NB (currently) is always English

Return values

mixed —

transferStatistics()

Transfer statistics data to new tables then drop old table


    private
                transferStatistics() : mixed

A fault in the previous statistics compilation means that each month's statistics needs to be backdated one month ...

Return values

mixed —

transferUrls()

Transfer urls data from resource_text to resource_url table


    private
                transferUrls() : mixed

Return values

mixed —

updateCoreInternalVersion()

Write the internal version in the database


    private
                updateCoreInternalVersion([string $version = NULL ]) : mixed

This function should be called as the last instruction of an upgradeToXXX() function.

If a crash occurs, updateCoreInternalVersion() is not called and the upgrade can resume safly at the start of the failed step after a fix.

If $version is NULL, the version number used it $this->targetVersion.

Parameters

$version : string = NULL: (Default is NULL)

Return values

mixed —

updateDatabase()

Update the database if required based on the current version


    private
                updateDatabase(float $dbVersion) : mixed

Parameters

$dbVersion : float

Return values

mixed —

updateImageLinks()

Update 'images' links in metadata to new images folder location


    private
                updateImageLinks() : mixed

Return values

mixed —

updatePluginTables()

Copy papers table (word processor) to new format if it exists then drop it. Upgrade the soundExplorer table


    private
                updatePluginTables() : mixed

Return values

mixed —

upgradeTo10()

Upgrade database schema to version 10 (6.0.8)


    private
                upgradeTo10() : mixed

Add FULLTEXT indices

Return values

mixed —

upgradeTo11()

Upgrade database schema to version 11 (6.2.1)


    private
                upgradeTo11() : mixed

Convert tag sizes to scale factors

Return values

mixed —

upgradeTo12()

Upgrade database schema to version 12 (6.2.2 - part A)


    private
                upgradeTo12() : mixed

Convert tag sizes to scale factors

Return values

mixed —

upgradeTo13()

Upgrade database schema to version 13 (6.2.2 - part B)


    private
                upgradeTo13() : mixed

Return values

mixed —

upgradeTo14()

Upgrade database schema to version 14 (6.2.2 - part C)


    private
                upgradeTo14() : mixed

Convert tag sizes to scale factors

Return values

mixed —

upgradeTo15()

Upgrade database schema to version 15 (6.3.8)


    private
                upgradeTo15() : mixed

Convert tag sizes to scale factors

Return values

mixed —

upgradeTo16()

Upgrade database schema to version 16 (6.3.8)


    private
                upgradeTo16() : mixed

This stage was doing a config change that have been moved to stage 24

Return values

mixed —

upgradeTo17()

Upgrade database schema to version 17 (6.3.8)


    private
                upgradeTo17() : mixed

Convert tag sizes to scale factors

Return values

mixed —

upgradeTo18()

Upgrade database schema to version 18 (6.3.8)


    private
                upgradeTo18() : mixed

Return values

mixed —

upgradeTo19()

Upgrade database schema to version 19 (6.3.8)


    private
                upgradeTo19() : mixed

Following change to storage of session arrays, reset the session state variable to NULL

Return values

mixed —

upgradeTo20()

Upgrade database schema to version 20 (6.3.8)


    private
                upgradeTo20() : mixed

Create new keyword groups table

Return values

mixed —

upgradeTo21()

Upgrade database schema to version 21 (6.3.8)


    private
                upgradeTo21() : mixed

Correct default value in user_kg_usergroups

Return values

mixed —

upgradeTo22()

Upgrade database schema to version 22 (6.3.8)


    private
                upgradeTo22() : mixed

Correct default value for usersFullname to '';

Return values

mixed —

upgradeTo23()

Upgrade database schema to version 23 (6.4.0)


    private
                upgradeTo23() : mixed

Correct default value for usersFullname to '';

Return values

mixed —

upgradeTo24()

Upgrade database schema to version 24 (6.4.0)


    private
                upgradeTo24() : mixed

This code removed fields from the configuration file. It has been moved to version 32 which removes others.

Return values

mixed —

upgradeTo25()

Upgrade database schema to version 25 (6.4.0)


    private
                upgradeTo25() : mixed

Return values

mixed —

upgradeTo26()

Upgrade database schema to version 26 (6.4.0)


    private
                upgradeTo26() : mixed

Drop form_data and create temp_storage table

Return values

mixed —

upgradeTo27()

Upgrade database schema to version 27 (6.4.0)


    private
                upgradeTo27() : mixed

Drop form_data and create temp_storage table

Return values

mixed —

upgradeTo28()

Upgrade database schema to version 28 (6.4.0)


    private
                upgradeTo28() : mixed

Drop form_data and create temp_storage table

Return values

mixed —

upgradeTo29()

Remove unwanted rows in user_bibliography_resource (6.4.0)


    private
                upgradeTo29() : mixed

Return values

mixed —

upgradeTo30()

Remove mistakenly named configBrowserTagID from config table (6.4.0)


    private
                upgradeTo30() : mixed

Rename option configBrowserTagID to configBrowserTabID

Return values

mixed —

upgradeTo31()

Upgrade database schema to version 31 (6.4.0)


    private
                upgradeTo31() : mixed

Rename option LdapGroupCn to LdapGroupDn

Return values

mixed —

upgradeTo32()

Upgrade database schema to version 32 (6.4.0)


    private
                upgradeTo32() : mixed

Clear missing attachments (code moved outside of the upgrade)

Return values

mixed —

upgradeTo33()

Upgrade database schema to version 33 (6.4.0)


    private
                upgradeTo33() : mixed

Remove session state from the database

Return values

mixed —

upgradeTo34()

Upgrade database schema to version 34 (6.4.0)


    private
                upgradeTo34() : mixed

Add new table to keep the current internal version number of components and core

Return values

mixed —

upgradeTo35()

Upgrade database schema to version 35 (6.4.0)


    private
                upgradeTo35() : mixed

Remove database_summary table

Return values

mixed —

upgradeTo36()

Upgrade database schema to version 36 (6.4.0)


    private
                upgradeTo36() : mixed

Add a default value to users.usersPassword

Return values

mixed —

upgradeTo37()

Upgrade database schema to version 37 (6.4.0)


    private
                upgradeTo37() : mixed

Clear the cache of attachments because their creation has been greatly improved and search results will be better

Return values

mixed —

upgradeTo38()

Upgrade database schema to version 38 (6.4.1)


    private
                upgradeTo38() : mixed

Fix the wrong definition of user_kg_usergroups.userkgusergroupsUserGroupId (NULL is allowed)

Return values

mixed —

upgradeTo39()

Upgrade database schema to version 39 (6.4.1)


    private
                upgradeTo39() : mixed

Flush temp_storage table and fix locale in style XML files

Return values

mixed —

upgradeTo40()

Upgrade database schema to version 40 (6.4.1)


    private
                upgradeTo40() : mixed

Set utf8mb4_unicode_520_ci as the default collation of the database

Return values

mixed —

upgradeTo41()

Upgrade database schema to version 41 (6.4.1)


    private
                upgradeTo41() : mixed

Add a default value to the users.usersFullname field (bugfix #316)

Return values

mixed —

upgradeTo42()

Upgrade database schema to version 42 (6.4.2)


    private
                upgradeTo42() : mixed

Recreate the usersUsernameUnique index with a BTREE type (bugfix #318) The HASH type seems not well supported by InnoDB

Return values

mixed —

upgradeTo43()

Upgrade database schema to version 43 (6.4.2)


    private
                upgradeTo43() : mixed

Resize collectionType field. Resize publisherType field. Resize resourceattachmentsFileSize field. Resize resourceattachmentsHashFilename field. Resize resourcemetadataType field. Resize resourceType field.

Add a missing index on resourceattachmentsResourceId (previous upgrade code missing). Add a missing index on resourcecustomCustomId (previous upgrade code missing). Add a missing index on resourcelanguageLanguageId (previous upgrade code missing). Add a missing index on resourcelanguageResourceId (previous upgrade code missing). Add a missing index on resourcemiscCollection (previous upgrade code missing). Add a missing index on resourcemiscPublisher (previous upgrade code missing). Add a missing index on resourcetimestampTimestamp (previous upgrade code missing). Add a missing index on resourcetimestampTimestamp (previous upgrade code missing). Add a missing index on resourcetimestampTimestampAdd (previous upgrade code missing).

Add a missing index on collection. Add a missing index on publisherType. Add a missing index on resourceattachmentsEmbargo. Add a missing index on resourceattachmentsEmbargoUntil. Add a missing index on resourceattachmentsHashFilename. Add a missing index on resourceattachmentsPrimary. Add a missing index on resourceattachmentsTimestamp. Add a missing index on resourcecategorySubcategoryId. Add a missing index on resourcecreatorRole. Add a missing index on resourcekeywordMetadataId. Add a missing index on resourcemetadataPrivate. Add a missing index on resourcemetadataType. Add a missing index on resourcemiscAddUserIdResource. Add a missing index on resourcemiscEditUserIdResource. Add a missing index on resourcemiscPeerReviewed. Add a missing index on resourcemiscQuarantine. Add a missing index on resourcetextAddUserIdAbstract. Add a missing index on resourcetextAddUserIdNote. Add a missing index on resourcetextEditUserIdAbstract. Add a missing index on resourcetextEditUserIdNote. Add a missing index on resourceusertagsTagId. Add a missing index on resourceyearYear2. Add a missing index on resourceyearYear3. Add a missing index on resourceyearYear4. Add a missing index on subcategoryCategoryId. Add a missing index on tempstorageTimestamp. Add a missing index on userbibliographyresourceBibliographyId. Add a missing index on userbibliographyUserGroupId. Add a missing index on userbibliographyUserId. Add a missing index on usergroupsAdminId. Add a missing index on usergroupsusersGroupId. Add a missing index on usergroupsusersUserId. Add a missing index on userkeywordgroupsUserId. Add a missing index on userkgkeywordsKeywordGroupId. Add a missing index on userregisterConfirmed. Add a missing index on userregisterTimestamp. Add a missing index on usersBlock. Add a missing index on usertagsUserId.

Drop old form_data table

Redefine categoryCategory index. Redefine keywordKeyword index. Redefine resourceType index. Redefine resourceTitle index.

Return values

mixed —

upgradeTo44()

Upgrade database schema to version 44 (6.4.2)


    private
                upgradeTo44() : mixed

Ensure utf8mb4_unicode_520_ci is always the default collation of the database.

Return values

mixed —

upgradeTo45()

Upgrade database schema to version 45 (6.4.2)


    private
                upgradeTo45() : mixed

Rewrite the config file

Return values

mixed —

upgradeTo46()

Upgrade database schema to version 46 (6.4.4)


    private
                upgradeTo46() : mixed

Add again missing indices from step 43 because some queries could have failed with a MySQL engine during 6.4.2 upgrade.

Return values

mixed —

upgradeTo47()

Upgrade database schema to version 47 (6.4.4)


    private
                upgradeTo47() : mixed

Create table resource_url.

Return values

mixed —

upgradeTo48()

Upgrade database schema to version 48 (6.4.4)


    private
                upgradeTo48() : mixed

Drop url-related columns from resource_text.

Return values

mixed —

upgradeTo49()

Upgrade database schema to version 49 (6.4.4)


    private
                upgradeTo49() : mixed

Add column resourcemiscMetadata to resource_misc.

Return values

mixed —

upgradeTo50()

Upgrade database schema to version 50 (6.4.4)


    private
                upgradeTo50() : mixed

Drop resource_summary table Flush cache table as no longer using base64 encoding/decoding

Return values

mixed —

upgradeTo51()

Upgrade database schema to version 51 (6.4.4)


    private
                upgradeTo51() : mixed

Add column usersLastInternalVersion to users Remove super admin's bookmark and other session variables storing SQL statements to account for changes at upgradeTo49()

Return values

mixed —

upgradeTo52()

Upgrade database to version 52 (6.4.4)


    private
                upgradeTo52() : mixed

Remove base64 encoding from collectionDefault field in collection table

Return values

mixed —

upgradeTo53()

Upgrade database to version 53 (6.4.4)


    private
                upgradeTo53() : mixed

Remove base64 encoding from global options

Return values

mixed —

upgradeTo54()

Upgrade database to version 54 (6.4.5)


    private
                upgradeTo54() : mixed

Store session in session table

Return values

mixed —

upgradeTo55()

Upgrade database to version 55 (6.4.6)


    private
                upgradeTo55() : mixed

Rename configImagesMaxSize option to configImgUploadMaxSize Rename configImagesAllow option to configImgAllow Rename configFileAttach option to configFileAttachAllow

Return values

mixed —

upgradeTo56()

Upgrade database to version 56 (6.4.6)


    private
                upgradeTo56() : mixed

Check there are no non wikindx table in the db and block the upgrade if we find one.

Return values

mixed —

upgradeTo57()

Upgrade database to version 57 (6.4.7)


    private
                upgradeTo57() : mixed

Check there are no non wikindx table in the db and block the upgrade if we find one.

Return values

mixed —

upgradeTo58()

Upgrade database schema to version 58 (6.4.7)


    private
                upgradeTo58() : mixed

Clear missing attachments (code moved outside of the upgrade)

Return values

mixed —

upgradeTo59()

Upgrade database schema to version 59 (6.4.8)


    private
                upgradeTo59() : mixed

Add usersDisplayResourceStatistics column to users table

Return values

mixed —

upgradeTo5_2()

Upgrade database schema to version 5.2


    private
                upgradeTo5_2() : mixed

Use MySQL utf8 encode and collation utf8_unicode_520_ci Lowercase all table names Use InnoDB for all tables

Return values

mixed —

upgradeTo5_3()

Upgrade database schema to version 5.3


    private
                upgradeTo5_3() : mixed

5.3 is a missing internal version, just bump the number

Return values

mixed —

upgradeTo5_4()

Upgrade database schema to version 5.4.


    private
                upgradeTo5_4() : mixed

Reconfiguration of config table and shifting many variables to it from config.php

Return values

mixed —

upgradeTo5_5()

Upgrade database schema to version 5.5.


    private
                upgradeTo5_5() : mixed

Addition of new fields to users table for auth security and GDPR

Return values

mixed —

upgradeTo5_6()

Upgrade database schema to version 5.6.


    private
                upgradeTo5_6() : mixed

Convert the database to utf8 charset and utf8_unicode_ci collation

Return values

mixed —

upgradeTo5_7()

Upgrade database schema to version 5.7.


    private
                upgradeTo5_7() : mixed

Convert the database to utf8mb4 charset and utf8mb4_unicode_520_ci collation Fix resource_metadata.resourcemetadataPrivate size to 1 character

Return values

mixed —

upgradeTo5_8()

Upgrade database schema to version 5.8. There are no changes to DB structure so no call to updateDbSchema('5.8').


    private
                upgradeTo5_8() : mixed

Check resource totals are correct Check creator correlations are correct

Return values

mixed —

upgradeTo5_9()

Upgrade database schema to version 5.9


    private
                upgradeTo5_9() : mixed

Move directories attachments, attachments_cache, images, and files Change configuration Update images links

Return values

mixed —

upgradeTo6()

Upgrade database schema to version 6


    private
                upgradeTo6() : mixed

Move word processor papers and styles custom styles components

Return values

mixed —

upgradeTo60()

Upgrade database schema to version 60 (6.4.8)


    private
                upgradeTo60() : mixed

Add resourceattachmentsText column to resource_attachments table

Return values

mixed —

upgradeTo61()

Upgrade database schema to version 61 (6.4.8)


    private
                upgradeTo61() : mixed

Copy the content of attachment cache files in the resourceattachmentsText column to resource_attachments table keep a copy on the cache attachment folder

Return values

mixed —

upgradeTo62()

Upgrade database schema to version 62 (6.4.8)


    private
                upgradeTo62() : mixed

Remove the content of attachment cache files

Return values

mixed —

upgradeTo63()

Upgrade database schema to version 63 (6.4.8)


    private
                upgradeTo63() : mixed

Recreate the session table and keep only valide sessions for the max life time of the custom GC

Return values

mixed —

upgradeTo64()

Upgrade database schema to version 64 (6.4.8)


    private
                upgradeTo64() : mixed

Add

Return values

mixed —

upgradeTo65()

Upgrade database schema to version 65 (6.4.9)


    private
                upgradeTo65() : mixed

Remove configRssBibstyle option Replace configSiteMapAllow by configSiteMapDisallow option Replace configRssAllow by configRssDisallow option Replace configGsAllow by configGsDisallow option

Return values

mixed —

upgradeTo66()

Upgrade database schema to version 66 (6.4.9)


    private
                upgradeTo66() : mixed

Rename option configRssDisplay to configRssDisplayEditedResources

Return values

mixed —

upgradeTo67()

Upgrade database schema to version 67 (6.4.9)


    private
                upgradeTo67() : mixed

Fix the mimetype of attachments in db and rebuild the cache of attachments with a wrong mimetype

Return values

mixed —

upgradeTo68()

Upgrade database schema to version 68 (6.4.9)


    private
                upgradeTo68() : mixed

Replace configBibutilsPath by configBinFolderBibutils option

Return values

mixed —

upgradeTo69()

Upgrade database schema to version 69 (6.4.9)


    private
                upgradeTo69() : mixed

Force rebuild of attachment cache

Return values

mixed —

upgradeTo7()

Upgrade database schema to version 7 (6.0.4)


    private
                upgradeTo7() : mixed

Return values

mixed —

upgradeTo70()

Upgrade database schema to version 70 (6.4.9)


    private
                upgradeTo70() : mixed

Not a database upgrade but an upgrade to citation styles from osbibversion 5 ––> 6.

Return values

mixed —

upgradeTo71()

Upgrade database schema to version 71 (6.4.10)


    private
                upgradeTo71() : mixed

Switch the old chicago style to chicago-ft (rename, no feature change)

Return values

mixed —

upgradeTo72()

Upgrade database schema to version 72 (6.4.11)


    private
                upgradeTo72() : mixed

Not a database upgrade but an upgrade to citation styles from osbibversion 6 ––> 7.

Return values

mixed —

upgradeTo8()

Upgrade database schema to version 8 (6.0.5)


    private
                upgradeTo8() : mixed

Return values

mixed —

upgradeTo9()

Upgrade database schema to version 9 (6.0.6)


    private
                upgradeTo9() : mixed

Return values

mixed —

upgradeToTargetVersion()

Performs the most common kind of upgrade


    private
                upgradeToTargetVersion() : mixed

Upgrade to the targetVersion with the most common operations:

Simple DB upgrade
Bump version
Display upgrade report

This function should not be called directly. You must define an upgradeToN function to manage the upgrade of version N. This function is just a helper. This is preferable to avoid performing operations by mistake which corrupt the database.

Return values

mixed —

UPDATEDATABASE in package wikindx core startup

Table of Contents

Properties

$db

$endStepMessage

$interruptStepMessage

$oldTime

$session

$targetVersion

Methods

checkConfigFile()

Return values

CheckDatabaseEngineVersion()

Return values

copyBibContents()

Return values

copyFolderContents()

Parameters

Return values

copyWpContents()

Return values

correctCreators()

Return values

correctDatetimeFields()

Return values

correctIndices()

Return values

createSuperAdmin()

Return values

displayUpdatePreambule()

Return values

endDisplay()

Return values

escapePHPDoubleQuotedString()

Parameters

Tags

Return values

flushTempStorage()

Return values

intervalVersion2publicVersion()

Parameters

Return values

pauseUpdateDisplay()

Return values

renameTable()

Parameters

Return values

requestSuperAdminLogin()

Parameters

Return values

rewriteConfigFile()

Return values

startInstallDisplay()

Return values

startUpdateDisplay()

Return values

styleLocaleFix()

Return values

transferStatistics()

Return values

transferUrls()

Return values

updateCoreInternalVersion()

Parameters

Return values

updateDatabase()

Parameters

Return values

updateImageLinks()

Return values

updatePluginTables()

Return values

upgradeTo10()

Return values

upgradeTo11()

Return values

upgradeTo12()

Return values

upgradeTo13()

Return values

UPDATEDATABASE
in package

wikindx

core

startup