forked from tecnickcom/tcexam
/
UPGRADE.TXT
executable file
·149 lines (109 loc) · 4.82 KB
/
UPGRADE.TXT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
TCExam - GENERAL UPGRADE PROCESS
============================================================
IMPORTANT:
Starting from 11.3.000 version the encryption algorithm for
passwords was improved and is NOT compatible with the old
method.
If you are upgrading and you do not want to manually reset
all passwords, set the K_STRONG_PASSWORD_ENCRYPTION constant
to FALSE on shared/config/tce_config.php
The default password for admin is 1234 and the correspondent
encoding is on install/dbdata.sql
This is the general upgrade process for TCExam.
-----------------------------------------------------------
1. Backup you entire existing database data and
TCExam Folder.
2. If the new main version number (Y) is different than
your installed main version number (X), execute one of
the following SQL files to upgrade your TCExam database
schema:
install/upgrade/mysql/mysql_db_upgrade_XtoY.sql
install/upgrade/postgresql/postgresql_db_upgrade_XtoY.sql
install/upgrade/oracle/oracle_db_upgrade_XtoY.sql
3. Rename the current TCExam folder
(eg: from /var/www/tcexam to /var/www/tcexam.old).
4. Extract the new TCExam version to the same folder where
it was previously installed (eg: /var/www/tcexam).
5. Delete the tcexam/install folder.
6. Manually edit all configuration files (check the values
of previous installation). The configuration files are
located on the following folders:
admin/config/
public/config/
shared/config/
7. Copy the multimedia content (images etc.) from your old
cache folder to the new cache folder.
8. Set the right files permissions to work with your
WebServer/PHP environment:
cd /var/www/tcexam
find . -exec chown -R www-data:www-data {} \;
find . -type f -exec chmod 544 {} \;
find cache/ -type f -exec chmod 644 {} \;
find cache/backup -type f -exec chmod 644 {} \;
find cache/lang -type f -exec chmod 544 {} \;
find admin/log/ -type f -exec chmod 644 {} \;
find public/log/ -type f -exec chmod 644 {} \;
find . -type d -exec chmod 755 {} \;
(in this example /var/www/tcexam is the installation
folder, www-data is the name of Apache user and group)
9. If you are using custom language files, replace the
shared/config/lang/language_tmx.xml and delete the PHP
files on cache folder.
10. Check if TCExam is working fine.
11. Backup and delete the old TCExam installation
(tcexam.old).
------------------------------------------------------------
------------------------------------------------------------
UPGRADE FROM OBSOLETE VERSIONS
------------------------------------------------------------
TCExam - UPGRADE FROM VERSION 4 to 5
============================================================
On TCExam 5 the database schema is changed, so you need to
alter your existing database installation.
1. Backup you entire existing database data and
TCExam Folder before any change.
2. From your favourite database management application (e.g.
phpMyAdmin, phpPgAdmin, ...), use one of the following
file to upgrade your TCExam database schema:
install/mysql_db_upgrade_4to5.sql
install/postgresql_db_upgrade_4to5.sql
3. Replace the following directories and files with the new
files on TCExam 5:
admin/code
admin/doc
shared/code/tce_functions_test.php
shared/config/lang
4. delete the cache/language_tmx_**.php files.
5. edit the shared/config/tce_config.php file and change the
value of K_TCEXAM_VERSION constant:
define ("K_TCEXAM_VERSION", "5.0.004");
------------------------------------------------------------
TCExam - UPGRADE FROM VERSION 3 to 4
============================================================
TCExam 4 has a new database schema and other improvements
that requires a new installation.
To import your questions and users database from version 3
to 4, try the following:
1. Backup you entire existing database data (this is not
necessary for upgrading but it's a good thing to do).
2. Use the phpPgAdmin or phpMyAdmin application to export
the following tables from the old database in SQL format:
tce_subjects
tce_questions
tce_answers
tce_users
(remove "admin" and "anonymous" users from this dump
because they will be recreated)
Note that on tce_users table the user_group_id field has
been removed and the user_verifycode field has been
introduced. So, when exporting this table exclude the
user_group_id field and use complete SQL inserts.
Users' groups must be created manually from TCExam
interface.
3. Install TCExam 4 on a new directory and with a new
database name.
4. Use a DBMS manager application (pgAdmin3, phpPgAdmin,
phpMyAdmin, ...) to import the SQL previously saved.
5. If you are using the PostgreSQL database please update
also the sequences for the imported data.
============================================================