July 31st, 2008 by
Juanm in
Miscellanea
When upgrading your database from older versions, please execute queries from your version to the subsequent one and then to the latest one.
Please remember to backup your data before upgrading
File upgrade
Upgrading from each old version, please remember
1
2
| DELETE
includes/guestbook.inc |
Then overwrite all other files 
Database upgrade from 2.0.1
1
2
3
4
5
| INSERT INTO phpbb_guest_config VALUES ('word_wrap_length', '32');
INSERT INTO phpbb_guest_config VALUES ('session_posting', '60');
INSERT INTO phpbb_guest_config VALUES ('password', '12345');
INSERT INTO phpbb_guest_config VALUES ('permit_mod', '0');
INSERT INTO phpbb_guest_config VALUES ('version', '2.2.0'); |
Database upgrade from 1.x.x
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
| #
# Struttura della tabella `phpbb_guest_config`
#
CREATE TABLE phpbb_guest_config (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default '',
PRIMARY KEY (config_name)
) TYPE=MyISAM;
#
# Dump dei dati per la tabella `phpbb_guest_config`
#
INSERT INTO phpbb_guest_config VALUES ('maxlenght_posts', '500');
INSERT INTO phpbb_guest_config VALUES ('posts_per_page', '15');
INSERT INTO phpbb_guest_config VALUES ('hide_posts', '0');
INSERT INTO phpbb_guest_config VALUES ('smilies_column', '6');
INSERT INTO phpbb_guest_config VALUES ('smilies_row', '3');
INSERT INTO phpbb_guest_config VALUES ('no_only_smilies', '1');
INSERT INTO phpbb_guest_config VALUES ('no_only_quote', '1');
INSERT INTO phpbb_guest_config VALUES ('word_wrap', '1');
INSERT INTO phpbb_guest_config VALUES ('flood_interval', '20');
INSERT INTO phpbb_guest_config VALUES ('contatore', '0'); |
Posted in
Miscellanea |
Comments Off
