WIKINDX API trunk

UPDATEDATABASE
in package

wikindx

core

startup

UPDATEDATABASE

Update the database as required

Properties

$browserTabID : mixed: bool
$db : mixed: object
$endStepMessage : mixed: string
$interruptStepMessage : mixed: string
$oldTime : mixed: int
$session : mixed: object
$targetVersion : mixed: float

Methods

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
flushTempStorage() : mixed: Flush the temp_storage table (NB old form and new form)
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
removeOldTablePrefix() : string: Return a table name without the old prefix wkx_
renameTable() : mixed: Rename a table
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
startDisplayCode() : string: Return the common code for the HTML display of the install/updage process
startInstallDisplay() : mixed: Start to emit the HTML page of the install process
startUpdateDisplay() : mixed: Start to emit the HTML page of the upgrade process
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)
upgradeTo101() : mixed: Upgrade database schema to version 101 (6.6.0)
upgradeTo101a() : string|bool: Get any languages and print a form if they exist
upgradeTo101b() : mixed: Deal with the languages form: 1. Transfer to resource_language::resourceLanguage column 2. Drop language and resource_language tables 3. Close the upgrade for this loop
upgradeTo102() : mixed: Upgrade database schema to version 102 (6.6.0)
upgradeTo103() : mixed: Upgrade database schema to version 103 (6.6.0)
upgradeTo104() : mixed: Upgrade database schema to version 104 (6.6.0)
upgradeTo106() : mixed: Upgrade database schema to version 106 (6.6.0)
upgradeTo108() : mixed: Upgrade database schema to version 108 (6.6.0)
upgradeTo109() : mixed: Upgrade database schema to version 109 (6.6.0)
upgradeTo11() : mixed: Upgrade database schema to version 11 (6.2.1)
upgradeTo110() : mixed: Upgrade database schema to version 110 (6.6.0)
upgradeTo111() : mixed: Upgrade database schema to version 111 (6.6.4)
upgradeTo112() : mixed: Upgrade database schema to version 112 (6.6.6)
upgradeTo113() : mixed: Upgrade database schema to version 113 (6.6.8)
upgradeTo114() : mixed: Upgrade database schema to version 114 (6.7.1)
upgradeTo117() : mixed: Upgrade database schema to version 117 (6.7.1)
upgradeTo12() : mixed: Upgrade database schema to version 12 (6.2.2 - part A)
upgradeTo120() : mixed: Upgrade database schema to version 120 (6.7.1)
upgradeTo121() : mixed: Upgrade database schema to version 121 (6.7.1)
upgradeTo122() : mixed: Upgrade database schema to version 122 (6.7.1)
upgradeTo123() : mixed: Upgrade database schema to version 123 (6.7.1)
upgradeTo124() : mixed: Upgrade database schema to version 124 (6.7.1)
upgradeTo125() : mixed: Upgrade database schema to version 125 (6.7.1)
upgradeTo126() : mixed: Upgrade database schema to version 126 (6.7.1)
upgradeTo127() : mixed: Upgrade database schema to version 127 (6.7.1)
upgradeTo127_disabled() : mixed: Upgrade database schema to version 127 (6.7.1)
upgradeTo128() : mixed: Upgrade database schema to version 128 (6.8.0)
upgradeTo129() : mixed: Upgrade database schema to version 129 (6.8.0)
upgradeTo13() : mixed: Upgrade database schema to version 13 (6.2.2 - part B)
upgradeTo130() : mixed: Upgrade database schema to version 130 (6.8.0)
upgradeTo130MultiInsert() : mixed: multiple insert routine for upgradeTo130()
upgradeTo131() : mixed: Upgrade database schema to version 131 (6.8.0)
upgradeTo132() : mixed: Upgrade database schema to version 132 (6.8.0)
upgradeTo133() : mixed: Upgrade database schema to version 133 (6.8.0)
upgradeTo135() : mixed: Upgrade database schema to version 135 (6.8.0)
upgradeTo136() : mixed: Upgrade database schema to version 136 (6.8.0)
upgradeTo137() : mixed: Upgrade database schema to version 137 (6.8.0)
upgradeTo138() : mixed: Upgrade database schema to version 138 (6.11.0)
upgradeTo139() : mixed: Upgrade database schema to version 139 (6.12.0)
upgradeTo14() : mixed: Upgrade database schema to version 14 (6.2.2 - part C)
upgradeTo140() : mixed: Upgrade database schema to version 140 (6.12.0)
upgradeTo141() : mixed: Upgrade database schema to version 141 (6.12.0)
upgradeTo142() : mixed: Upgrade database schema to version 142 (6.12.0)
upgradeTo143() : mixed: Upgrade database schema to version 143 (6.12.0)
upgradeTo144() : mixed: Upgrade to version 144 (6.12.0)
upgradeTo145() : mixed: Upgrade database schema to version 145 (6.12.0)
upgradeTo146() : mixed: Upgrade database schema to version 146 (6.12.0)
upgradeTo147() : mixed: Upgrade database schema to version 147 (6.12.0)
upgradeTo148() : mixed: Upgrade database schema to version 148 (6.12.0)
upgradeTo149() : mixed: Upgrade database schema to version 149 (6.12.0)
upgradeTo15() : mixed: Upgrade database schema to version 15 (6.3.8)
upgradeTo150() : mixed: Upgrade database schema to version 150 (6.12.0).
upgradeTo151() : mixed: Upgrade database schema to version 151 (6.12.1)
upgradeTo152() : mixed: Upgrade database schema to version 152 (6.12.1)
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)
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)
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)
upgradeTo43() : mixed: Upgrade database schema to version 43 (6.4.2)
upgradeTo44() : mixed: Upgrade database schema to version 44 (6.4.2)
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)
upgradeTo71() : mixed: Upgrade database schema to version 71 (6.4.10)
upgradeTo74() : mixed: Upgrade database schema to version 74 (6.6.0)
upgradeTo8() : mixed: Upgrade database schema to version 8 (6.0.5)
upgradeTo89() : mixed: Upgrade database schema to version 89 (6.6.0)
upgradeTo9() : mixed: Upgrade database schema to version 9 (6.0.6)
upgradeTo90() : mixed: Upgrade database schema to version 90 (6.6.0)
upgradeTo91() : mixed: Upgrade database schema to version 91 (6.6.0)
upgradeTo92() : mixed: Upgrade database schema to version 92 (6.6.0)
upgradeTo93() : mixed: Upgrade database schema to version 93 (6.6.0)
upgradeTo95() : mixed: Upgrade database schema to version 95 (6.6.0)
upgradeToTargetVersion() : mixed: Performs the most common kind of upgrade

$browserTabID

bool


        private
            mixed
    $browserTabID
     = \FALSE

$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

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

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

copyWpContents()

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


    private
                    copyWpContents() : mixed

correctCreators()

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


    private
                    correctCreators() : 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.

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

createSuperAdmin()

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


    private
                    createSuperAdmin() : mixed

displayUpdatePreambule()

Check and print status of update scripts


    private
                    displayUpdatePreambule() : 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.

flushTempStorage()

Flush the temp_storage table (NB old form and new form)


    private
                    flushTempStorage() : mixed

intervalVersion2publicVersion()

Get the minimum public version corresponding to an internal version


    private
                    intervalVersion2publicVersion(float|int $version) : string

Parameters

$version : float|int: 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.

removeOldTablePrefix()

Return a table name without the old prefix wkx_


    private
                    removeOldTablePrefix(string $table) : string

Parameters

$table : string: A prefixed table name

Return values

string

renameTable()

Rename a table


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

Parameters

$tablesrc : string: Fullname of a source table
$tabledst : string: Fullname of a destination table

requestSuperAdminLogin()

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


    private
                    requestSuperAdminLogin(string $currentdbVersion) : mixed

Parameters

$currentdbVersion : string

rewriteConfigFile()

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


    private
                    rewriteConfigFile() : mixed

startDisplayCode()

Return the common code for the HTML display of the install/updage process


    private
                    startDisplayCode(string $heading) : string

Parameters

$heading : string

Return values

string

startInstallDisplay()

Start to emit the HTML page of the install process


    private
                    startInstallDisplay() : mixed

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

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.

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 ...

transferUrls()

Transfer urls data from resource_text to resource_url table


    private
                    transferUrls() : mixed

updateCoreInternalVersion()

Write the internal version in the database


    private
                    updateCoreInternalVersion(float|int $version) : 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.

Parameters

$version : float|int

updateDatabase()

Update the database if required based on the current version


    private
                    updateDatabase(float|int $dbVersion) : mixed

Parameters

$dbVersion : float|int

updateImageLinks()

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


    private
                    updateImageLinks() : mixed

updatePluginTables()

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


    private
                    updatePluginTables() : mixed

upgradeTo10()

Upgrade database schema to version 10 (6.0.8)


    private
                    upgradeTo10() : mixed

Add FULLTEXT indices

upgradeTo101()

Upgrade database schema to version 101 (6.6.0)


    private
                    upgradeTo101() : mixed

Conform resource language to locales:

Add resourceLanguage column to resource table
If language table exists: a. each languageLanguage is matched to a top-level locale (e.g., 'fr', 'en') and potential matches displayed in a form that must be submitted before the update is complete. b. write the selected locales to resourceLanguage in resource table for relevant resources
Drop both language and resource_language tables.

upgradeTo101a()

Get any languages and print a form if they exist


    private
                    upgradeTo101a() : string|bool

Return values

string|bool

upgradeTo101b()

Deal with the languages form: 1. Transfer to resource_language::resourceLanguage column 2. Drop language and resource_language tables 3. Close the upgrade for this loop


    private
                    upgradeTo101b() : mixed

upgradeTo102()

Upgrade database schema to version 102 (6.6.0)


    private
                    upgradeTo102() : mixed

Replace configMailSmtpAuth by configMailSmtpAuthType option

upgradeTo103()

Upgrade database schema to version 103 (6.6.0)


    private
                    upgradeTo103() : mixed

Remove the cache/languages/locales_system.json file. The translation système don't use it anymore

upgradeTo104()

Upgrade database schema to version 104 (6.6.0)


    private
                    upgradeTo104() : mixed

Transcode system locale codes to Intl locale codes

LkpPo(Fix), 2023-02-08: the upgrade of XML styles was broken and the code have been removed

upgradeTo106()

Upgrade database schema to version 106 (6.6.0)


    private
                    upgradeTo106() : mixed

Add a column to users_basket to store ideas in a basket

upgradeTo108()

Upgrade database schema to version 108 (6.6.0)


    private
                    upgradeTo108() : mixed

Add the wordprocessor table
If plugin_wordprocessor exists: a) transfer its contents to the new table if the hashfile exists in data/plugins/wordprocessor/ b) set up default paper preferences
Remove Word Processor plugin folders and its contents

LkpPo(Fix), 2023-06-08: XML styles upgrade was broken and the corresponding code was removed from this step

upgradeTo109()

Upgrade database schema to version 109 (6.6.0)


    private
                    upgradeTo109() : mixed

Remove WIKINDX_MAX_WRITECHUNK option. Add type parameters to:

WIKINDX_DB_HOST
WIKINDX_DB
WIKINDX_DB_USER
WIKINDX_DB_PASSWORD
WIKINDX_PATH_AUTO_DETECTION
WIKINDX_URL_BASE

Rewrite the config file

upgradeTo11()

Upgrade database schema to version 11 (6.2.1)


    private
                    upgradeTo11() : mixed

Convert tag sizes to scale factors

upgradeTo110()

Upgrade database schema to version 110 (6.6.0)


    private
                    upgradeTo110() : mixed

Remove 'data/files' folder (WIKINDX_DIR_DATA_FILES).

Rewrite the config file

upgradeTo111()

Upgrade database schema to version 111 (6.6.4)


    private
                    upgradeTo111() : mixed

Purge the style cache (cache files were not always refreshed if the original style files had a future date)

upgradeTo112()

Upgrade database schema to version 112 (6.6.6)


    private
                    upgradeTo112() : mixed

Clear the version table after the wordprocessor migration to the core

Missing instruction of step 108.

upgradeTo113()

Upgrade database schema to version 113 (6.6.8)


    private
                    upgradeTo113() : mixed

Not an upgrade of the database but just a flush of the temp storage table and some sessions to ensure the debugged list/search code works fine.

upgradeTo114()

Upgrade database schema to version 114 (6.7.1)


    private
                    upgradeTo114() : mixed

Purge the Smarty compilation cache (for Smarty 5 migration)

upgradeTo117()

Upgrade database schema to version 117 (6.7.1)


    private
                    upgradeTo117() : mixed

Redefine the cache table with a primary key and transpose columns to lines [#528]

upgradeTo12()

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


    private
                    upgradeTo12() : mixed

Convert tag sizes to scale factors

upgradeTo120()

Upgrade database schema to version 120 (6.7.1)


    private
                    upgradeTo120() : mixed

The indexes could not all be deleted or created due to syntax errors in the SQL queries of the previous steps.

We delete all non PRIMARY indexes to recreate them in the 4 next steps. The two operations are separated because creating indexes can take quite a long time on large tables.

The indexes to be recreated are divided into roughly equal batches.

upgradeTo121()

Upgrade database schema to version 121 (6.7.1)


    private
                    upgradeTo121() : mixed

Rebuild indexes deleted during step 120 (batch 1)

upgradeTo122()

Upgrade database schema to version 122 (6.7.1)


    private
                    upgradeTo122() : mixed

Rebuild indexes deleted during step 120 (batch 2)

upgradeTo123()

Upgrade database schema to version 123 (6.7.1)


    private
                    upgradeTo123() : mixed

Rebuild indexes deleted during step 120 (batch 3)

upgradeTo124()

Upgrade database schema to version 124 (6.7.1)


    private
                    upgradeTo124() : mixed

Rebuild indexes deleted during step 120 (batch 4)

upgradeTo125()

Upgrade database schema to version 125 (6.7.1)


    private
                    upgradeTo125() : mixed

Fixes custom XML styles and upgrade them to JSON from osbibVersion v3.1 to v28 (become v29)

upgradeTo126()

Upgrade database schema to version 126 (6.7.1)


    private
                    upgradeTo126() : mixed

Fix a syntaxic error of SQL code for MySQL ("COLUMN IF EXISTS" is unknown) [#569]

Replay SQL queries with syntactical errors from previous steps found during development of version 6.7.1:

Drop columns relating to the forgotten password system using questions and answers (steps 118, 119)
Drop configPHP (step 96)
Drop configFloat (step 11)
Drop usersChangePasswordTimestamp column (step 13)
Drop usersCmsTag column (step 97)
Drop UserSession column (step 33)
Rename users.usersCookie db field to users.usersAuthRememberMe step 92)

upgradeTo127()

Upgrade database schema to version 127 (6.7.1)


    private
                    upgradeTo127() : mixed

This step is removed because the issue is not resolved satisfactorily

upgradeTo127_disabled()

Upgrade database schema to version 127 (6.7.1)


    private
                    upgradeTo127_disabled() : mixed

Compute all BibTeX keys with a clean ASCII transliteration

upgradeTo128()

Upgrade database schema to version 128 (6.8.0)


    private
                    upgradeTo128() : mixed

Fix the ASCII transliteration of BibTeX keys

upgradeTo129()

Upgrade database schema to version 129 (6.8.0)


    private
                    upgradeTo129() : mixed

Parse again MS Word binary attachments with PHPWord library (added with 6.8.0)

upgradeTo13()

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


    private
                    upgradeTo13() : mixed

upgradeTo130()

Upgrade database schema to version 130 (6.8.0)


    private
                    upgradeTo130() : mixed

Create the new tables search_xxx which hold HTML-free duplicates of fields originating tinyMCE's textareas and which are used in quicksearch and advanced search.

Duplicate and clean the fields.

Note that ideas were originally transferred here but are now dealt with in step 131

Speed things up using multiInserts but be careful where fields are mediumtext types

upgradeTo130MultiInsert()

multiple insert routine for upgradeTo130()


    private
                    upgradeTo130MultiInsert(string $table, array<string|int, mixed> $fields, array<string|int, mixed> $values) : mixed

Parameters

$table : string
$fields : array<string|int, mixed>
$values : array<string|int, mixed>

upgradeTo131()

Upgrade database schema to version 131 (6.8.0)


    private
                    upgradeTo131() : mixed

Transfer ideas from resource_metadata to ideas and to search_ideas

Transfer idea keywords from resource_keyword to ideas_keyword

upgradeTo132()

Upgrade database schema to version 132 (6.8.0)


    private
                    upgradeTo132() : mixed

Add style_titleInvertFormat to each bibliographic JSON file

NB: this code have been migrated inside class PARSESTYLEJSON.

upgradeTo133()

Upgrade database schema to version 133 (6.8.0)


    private
                    upgradeTo133() : mixed

Remove column usersDisplayBibtexLink from users table

upgradeTo135()

Upgrade database schema to version 135 (6.8.0)


    private
                    upgradeTo135() : mixed

Merge resourcecustomShort and resourcecustomLong into resourcecustomText and convert 'S' custom fields to 'L' custom fields

upgradeTo136()

Upgrade database schema to version 136 (6.8.0)


    private
                    upgradeTo136() : mixed

Rebuild the search_custom table data since the content of resourcecustomShort and resourcecustomLong have been merged

upgradeTo137()

Upgrade database schema to version 137 (6.8.0)


    private
                    upgradeTo137() : mixed

Auto-update the timestamp of temp_storage

upgradeTo138()

Upgrade database schema to version 138 (6.11.0)


    private
                    upgradeTo138() : mixed

Fix incorrect collection types and defaults

upgradeTo139()

Upgrade database schema to version 139 (6.12.0)


    private
                    upgradeTo139() : mixed

Rewrite the config file.

This secures the file with an HTTP 403 error code in case of unauthorized access.

upgradeTo14()

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


    private
                    upgradeTo14() : mixed

Convert tag sizes to scale factors

upgradeTo140()

Upgrade database schema to version 140 (6.12.0)


    private
                    upgradeTo140() : mixed

Changes the type of sessionLastAccessTimestamp field (2038 proof)

upgradeTo141()

Upgrade database schema to version 141 (6.12.0)


    private
                    upgradeTo141() : mixed

Add a tagUserId column to the tag table and update any existing tag with userId information

upgradeTo142()

Upgrade database schema to version 142 (6.12.0)


    private
                    upgradeTo142() : mixed

Add a userbibliographyPublic column to the user_bibliography table

upgradeTo143()

Upgrade database schema to version 143 (6.12.0)


    private
                    upgradeTo143() : mixed

Add a userbibliographyPublicViewAttach column to the user_bibliography table

upgradeTo144()

Upgrade to version 144 (6.12.0)


    private
                    upgradeTo144() : mixed

Remove all bookmarks and sessions relating to stored searches

upgradeTo145()

Upgrade database schema to version 145 (6.12.0)


    private
                    upgradeTo145() : mixed

Set up the publication_list and publication_list_bib tables and amend the user_bibliography table

upgradeTo146()

Upgrade database schema to version 146 (6.12.0)


    private
                    upgradeTo146() : mixed

Set usersBrowseBibliography to 0 (WIKINDX master bibliography) for all users and set usersHomeBib to 0 (off)

upgradeTo147()

Upgrade database schema to version 147 (6.12.0)


    private
                    upgradeTo147() : mixed

Remove the ideas basket of every user (somewhere down the line there was an error: ideas that should be deleted were not)

upgradeTo148()

Upgrade database schema to version 148 (6.12.0)


    private
                    upgradeTo148() : mixed

Fix potential NULL resourcemiscAddUserIdResource by setting to WIKINDX_SUPERADMIN_ID. Not sure why this has happened—perhaps an interrupted import?
Fix missing rows in search_resources and search_abstractnotes. Code to write these rows was missing in the import code for bibtex and endnote (now fixed in this release).

upgradeTo149()

Upgrade database schema to version 149 (6.12.0)


    private
                    upgradeTo149() : mixed

Remove rows from resource_category in the general (1) category if the resource is already in another category, and remove subcategories that are in the general category.
Fix some other errors with resource_category

upgradeTo15()

Upgrade database schema to version 15 (6.3.8)


    private
                    upgradeTo15() : mixed

Convert tag sizes to scale factors

upgradeTo150()

Upgrade database schema to version 150 (6.12.0).


    private
                    upgradeTo150() : mixed

In the previous step dealing with changes to the General category, I forgot to remove General from the list of available categories when importing a bibliography via bibTeX or Endnote. Repeat the first part of upgradeTo149() in case anyone has been using the SVN code prior to this 150 step.

Remove rows from resource_category in the general (1) category if the resource is already in another category.

upgradeTo151()

Upgrade database schema to version 151 (6.12.1)


    private
                    upgradeTo151() : mixed

Replace temp_storage table with session_browser_tab table

upgradeTo152()

Upgrade database schema to version 152 (6.12.1)


    private
                    upgradeTo152() : mixed

Add publicationlistUserId to publication_list table

upgradeTo17()

Upgrade database schema to version 17 (6.3.8)


    private
                    upgradeTo17() : mixed

Convert tag sizes to scale factors

upgradeTo18()

Upgrade database schema to version 18 (6.3.8)


    private
                    upgradeTo18() : 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

upgradeTo20()

Upgrade database schema to version 20 (6.3.8)


    private
                    upgradeTo20() : mixed

Create new keyword groups table

upgradeTo21()

Upgrade database schema to version 21 (6.3.8)


    private
                    upgradeTo21() : mixed

Correct default value in user_kg_usergroups

upgradeTo22()

Upgrade database schema to version 22 (6.3.8)


    private
                    upgradeTo22() : mixed

Correct default value for usersFullname to '';

upgradeTo23()

Upgrade database schema to version 23 (6.4.0)


    private
                    upgradeTo23() : mixed

Correct default value for usersFullname to '';

upgradeTo25()

Upgrade database schema to version 25 (6.4.0)


    private
                    upgradeTo25() : mixed

upgradeTo26()

Upgrade database schema to version 26 (6.4.0)


    private
                    upgradeTo26() : mixed

Drop form_data and create temp_storage table

upgradeTo27()

Upgrade database schema to version 27 (6.4.0)


    private
                    upgradeTo27() : mixed

Drop form_data and create temp_storage table

upgradeTo28()

Upgrade database schema to version 28 (6.4.0)


    private
                    upgradeTo28() : mixed

Drop form_data and create temp_storage table

upgradeTo29()

Remove unwanted rows in user_bibliography_resource (6.4.0)


    private
                    upgradeTo29() : mixed

upgradeTo30()

Remove mistakenly named configBrowserTagID from config table (6.4.0)


    private
                    upgradeTo30() : mixed

Rename option configBrowserTagID to configBrowserTabID

upgradeTo31()

Upgrade database schema to version 31 (6.4.0)


    private
                    upgradeTo31() : mixed

Rename option LdapGroupCn to LdapGroupDn

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

upgradeTo35()

Upgrade database schema to version 35 (6.4.0)


    private
                    upgradeTo35() : mixed

Remove database_summary table

upgradeTo36()

Upgrade database schema to version 36 (6.4.0)


    private
                    upgradeTo36() : mixed

Add a default value to users.usersPassword

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

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)

upgradeTo39()

Upgrade database schema to version 39 (6.4.1)


    private
                    upgradeTo39() : mixed

Flush temp_storage table and fix locale in style XML files

LkpPo(Fix), 2023-02-08: the upgrade of XML styles was broken and the code have been removed

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

upgradeTo41()

Upgrade database schema to version 41 (6.4.1)


    private
                    upgradeTo41() : mixed

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

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.

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.

upgradeTo47()

Upgrade database schema to version 47 (6.4.4)


    private
                    upgradeTo47() : mixed

Create table resource_url.

upgradeTo48()

Upgrade database schema to version 48 (6.4.4)


    private
                    upgradeTo48() : mixed

Drop url-related columns from resource_text.

upgradeTo49()

Upgrade database schema to version 49 (6.4.4)


    private
                    upgradeTo49() : mixed

Add column resourcemiscMetadata to resource_misc.

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

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()

upgradeTo52()

Upgrade database to version 52 (6.4.4)


    private
                    upgradeTo52() : mixed

Remove base64 encoding from collectionDefault field in collection table

upgradeTo53()

Upgrade database to version 53 (6.4.4)


    private
                    upgradeTo53() : mixed

Remove base64 encoding from global options

upgradeTo54()

Upgrade database to version 54 (6.4.5)


    private
                    upgradeTo54() : mixed

Store session in session table

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

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.

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.

upgradeTo58()

Upgrade database schema to version 58 (6.4.7)


    private
                    upgradeTo58() : mixed

Clear missing attachments (code moved outside of the upgrade)

upgradeTo59()

Upgrade database schema to version 59 (6.4.8)


    private
                    upgradeTo59() : mixed

Add usersDisplayResourceStatistics column to users table

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

upgradeTo5_3()

Upgrade database schema to version 5.3


    private
                    upgradeTo5_3() : mixed

5.3 is a missing internal version, just bump the number

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

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

upgradeTo5_6()

Upgrade database schema to version 5.6.


    private
                    upgradeTo5_6() : mixed

Convert the database to utf8 charset and utf8_unicode_ci collation

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

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

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

upgradeTo6()

Upgrade database schema to version 6


    private
                    upgradeTo6() : mixed

Move word processor papers and styles custom styles components

upgradeTo60()

Upgrade database schema to version 60 (6.4.8)


    private
                    upgradeTo60() : mixed

Add resourceattachmentsText column to resource_attachments table

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

upgradeTo62()

Upgrade database schema to version 62 (6.4.8)


    private
                    upgradeTo62() : mixed

Remove the content of attachment cache files

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

upgradeTo64()

Upgrade database schema to version 64 (6.4.8)


    private
                    upgradeTo64() : mixed

Add

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

upgradeTo66()

Upgrade database schema to version 66 (6.4.9)


    private
                    upgradeTo66() : mixed

Rename option configRssDisplay to configRssDisplayEditedResources

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

upgradeTo68()

Upgrade database schema to version 68 (6.4.9)


    private
                    upgradeTo68() : mixed

Replace configBibutilsPath by configBinFolderBibutils option

upgradeTo69()

Upgrade database schema to version 69 (6.4.9)


    private
                    upgradeTo69() : mixed

Force rebuild of attachment cache

upgradeTo7()

Upgrade database schema to version 7 (6.0.4)


    private
                    upgradeTo7() : 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)

upgradeTo74()

Upgrade database schema to version 74 (6.6.0)


    private
                    upgradeTo74() : mixed

Remove config options used by the removed CMS print feature

upgradeTo8()

Upgrade database schema to version 8 (6.0.5)


    private
                    upgradeTo8() : mixed

upgradeTo89()

Upgrade database schema to version 89 (6.6.0)


    private
                    upgradeTo89() : mixed

Fix the case of the usersListLink field

upgradeTo9()

Upgrade database schema to version 9 (6.0.6)


    private
                    upgradeTo9() : mixed

upgradeTo90()

Upgrade database schema to version 90 (6.6.0)


    private
                    upgradeTo90() : mixed

Not a database upgrade but a clean out of bookmarks, lastMulti, and lastSolo to account for the new citation engine which has diffferent SQL statements. Clear out also the temporary storage.

upgradeTo91()

Upgrade database schema to version 91 (6.6.0)


    private
                    upgradeTo91() : mixed

Change db field to LONGBLOB type because they store serialized PHP:

cacheConferenceOrganisers
cacheKeywords
cacheMetadataCollections
cacheMetadataCreators
cacheMetadataKeywords
cacheMetadataPublishers
cacheMusingKeywords
cacheParaphraseKeywords
cacheQuoteKeywords
cacheResourceCollections
cacheResourceCollectionShorts
cacheResourceCollectionTitles
cacheResourceCreators
cacheResourceKeywords
cacheResourcePublishers

upgradeTo92()

Upgrade database schema to version 92 (6.6.0)


    private
                    upgradeTo92() : mixed

Change db field to LONGBLOB type because they store serialized PHP:

collection.collectionDefault
session.sessionData
temp_storage.tempstorageData
users.usersCmsTag
users_basket.usersbasketBasket
users_bookmarks.usersbookmarksBookmarks

upgradeTo93()

Upgrade database schema to version 93 (6.6.0)


    private
                    upgradeTo93() : mixed

Change db field to LONGBLOB type because they store serialized PHP:

bibtex_string.bibtexstringText
import_raw.importrawText

upgradeTo95()

Upgrade database schema to version 95 (6.6.0)


    private
                    upgradeTo95() : mixed

Unserialize some config options:

configDeactivateResourceTypes
configNoSort
configSearchFilter

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.

UPDATEDATABASE in package wikindx core startup

Table of Contents

Properties

Methods

Properties

$browserTabID

$db

$endStepMessage

$interruptStepMessage

$oldTime

$session

$targetVersion

Methods

checkConfigFile()

CheckDatabaseEngineVersion()

Return values

copyBibContents()

copyFolderContents()

Parameters

copyWpContents()

correctCreators()

correctDatetimeFields()

correctIndices()

createSuperAdmin()

displayUpdatePreambule()

endDisplay()

flushTempStorage()

intervalVersion2publicVersion()

Parameters

Return values

pauseUpdateDisplay()

removeOldTablePrefix()

Parameters

Return values

renameTable()

Parameters

requestSuperAdminLogin()

Parameters

rewriteConfigFile()

startDisplayCode()

Parameters

Return values

startInstallDisplay()

startUpdateDisplay()

transferStatistics()

transferUrls()

updateCoreInternalVersion()

Parameters

updateDatabase()

Parameters

updateImageLinks()

updatePluginTables()

upgradeTo10()

upgradeTo101()

upgradeTo101a()

Return values

upgradeTo101b()

upgradeTo102()

upgradeTo103()

upgradeTo104()

upgradeTo106()

upgradeTo108()

upgradeTo109()

upgradeTo11()

upgradeTo110()

upgradeTo111()

upgradeTo112()

upgradeTo113()

upgradeTo114()

upgradeTo117()

upgradeTo12()

upgradeTo120()

upgradeTo121()

upgradeTo122()

upgradeTo123()

upgradeTo124()

upgradeTo125()

upgradeTo126()

upgradeTo127()

upgradeTo127_disabled()

UPDATEDATABASE
in package

wikindx

core

startup