http://www.phpbb.com/kb/article/manuall ... se-schema/
Ik heb net een fix proberen te doen omdat ik denk dat update_to_latest niet werd gedaan en kwam bij dit uit:
Code: Selecteer alles
Some queries failed
Be sure to post this message in your topic on phpBB.com. For security reasons, delete this file when you are finished. A detailed report follows:
Query 1: CREATE TABLE confirm (`confirm_id` char(32) NOT NULL default '', `session_id` char(32) NOT NULL default '', `code` char(6) NOT NULL default '', PRIMARY KEY (`session_id`,`confirm_id`)) TYPE=MyISAM;
Status: Ran successfully
Query 2: ALTER TABLE sessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL
Status: Error (Duplicate column name 'session_admin')
Query 3: CREATE TABLE sessions_keys (`key_id` varchar(32) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `last_ip` varchar(8) NOT NULL default '0', `last_login` int(11) NOT NULL default '0', PRIMARY KEY (`key_id`,`user_id`), KEY `last_login` (`last_login`)) TYPE=MyISAM;
Status: Error (Table 'sessions_keys' already exists)
Query 4: UPDATE users SET user_active = 0 WHERE user_id = -1
Status: Ran successfully
Query 5: INSERT INTO config (config_name, config_value) VALUES ('allow_autologin','1')
Status: Error (Duplicate entry 'allow_autologin' for key 1)
Query 6: INSERT INTO config (config_name, config_value) VALUES ('max_autologin_time','0')
Status: Error (Duplicate entry 'max_autologin_time' for key 1)
Query 7: ALTER TABLE users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL
Status: Error (Duplicate column name 'user_last_login_try')
Query 8: ALTER TABLE users ADD COLUMN user_login_tries smallint(5) unsigned NOT NULL default '0'
Status: Error (Duplicate column name 'user_login_tries')
Query 9: INSERT INTO config (config_name, config_value) VALUES ('max_login_attempts', '5')
Status: Error (Duplicate entry 'max_login_attempts' for key 1)
Query 10: INSERT INTO config (config_name, config_value) VALUES ('login_reset_time', '30')
Status: Error (Duplicate entry 'login_reset_time' for key 1)
Query 11: ALTER TABLE search_results ADD COLUMN `search_time` int(11) NOT NULL default '0'
Status: Error (Duplicate column name 'search_time')
Query 12: INSERT INTO config (config_name, config_value) VALUES ('search_flood_interval', '15')
Status: Error (Duplicate entry 'search_flood_interval' for key 1)
Query 13: INSERT INTO config (config_name, config_value) VALUES ('rand_seed', '0')
Status: Error (Duplicate entry 'rand_seed' for key 1)
Query 14: ALTER TABLE search_results MODIFY COLUMN search_array MEDIUMTEXT NOT NULL
Status: Ran successfully
Query 15: UPDATE config SET config_value = '.0.22' WHERE config_name = 'version'
Status: Ran successfully
Query 16: TRUNCATE TABLE sessions
Status: Ran successfully
Query 17: TRUNCATE TABLE sessions_keys
Status: Ran successfully
De laatste zijn succesvol gerund, dus dacht ik ok, dan ga ik naar phpmyadmin en voeg ik enkel die code toe van php2.0.20 naar 22 in het tweede deel van de fix op de webpagina.
Maar daar moet ik 'phpbb_' vervangen door de prefix van config.php
Probleem is dat er daar bij prefix staat : ' ' , maw helemaal niks. Klopt dit ??
Als ik 'phpbb_' vervang door ' ' , dan werkt de code niet.
Sorry voor de vele vragen, maar ik probeer er wel iets aan te doen.
dank bij voorbaat
edit: op miraculeuze wijze werkt mn 'visuele bevestiging' nu wel. Kunnen jullie om problemen te voorkomen toch nog even bovenstaande code inkijken voor eventuele fouten ?
