phpBB2 by Przemo

kwh · **Pomógł:** 12 razy Posty: 194

It's a full version either for clean install or upgrade from any version of phpBB and by Przemo versions 1.5-1.9.5.
An universal installation script (/scripts/update.php) is equipped with all database updates. Some of them are executed only when needed (eg. "clean" phpBB upgrade or different by Przemo versions).

Update from clean phpBB or by Przemo older than 1.12.5:
- Bacup your files and database.
- Delete old /scripts/ folder (not necessary)
- Copy /scripts/ folder from version 1.12.5 main folder to main forums folder on your server.
- Login as an admin, go to /scripts/update.php and run update script.
- Overwrite all files with new 1.12.5 files except config.php file (Attention: just after database update ! If you do it with wrong order, you will have to upload old version files, and do it again because updater won't work !)
- Empty /cache/ folder, you don't have to delete .htaccess file if such exists.
- Login on forums with admin acccount, execute /scripts/update_useragent.php file.
- Check database synchronization in check_files.php, synchronize database if needed.

If you're neat you can delete all old files and folders because some files are redundant in 1.12.x. In this case you have to upload again /album_mod/upload/ , /files/ , /images/avatars/ , /images/photos/ , /images/signatures/ , /pafiledb/uploads/ folders. These folders contains attachments, download files, avatars, signatures and photos. Additionally you have to restore yous custom ranks images and smiles. These steps are not necessary it deals not with performance.

During 1.9.4 -> 1.12.4 Przemo has had

Kod:

Instructions executed:: 248, not executed: 544

These values may vary at your boards.

phpBB by Przemo 1.12.5

Update 1.12.3 to 1.12.4:
Execute these queries (eg. in phpMyAdmin):

Kod:

ALTER TABLE phpbb_read_history DROP PRIMARY KEY;
ALTER TABLE phpbb_read_history ADD topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_read_history ADD forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_read_history ADD INDEX (user_id);
ALTER TABLE phpbb_read_history ADD INDEX (post_id);
ALTER TABLE phpbb_read_history ADD INDEX (topic_id);
ALTER TABLE phpbb_read_history ADD INDEX (forum_id);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rh_without_days', '3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rh_max_posts', '1000');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('public_category', '');
UPDATE phpbb_config SET config_value = '1.12.4' WHERE config_name = 'version';
UPDATE phpbb_portal_config SET config_value = '' WHERE config_name = 'ri_time';
UPDATE phpbb_portal_config SET config_value = '' WHERE config_name = 'ri_data';

Now, you have to replace all the files fromr: http://www.przemo.org/php...12.3-1.12.4.zip

Update 1.12.4 to 1.12.5
Execute these queries (eg. in phpMyAdmin):

Kod:

UPDATE phpbb_config SET config_value = '1.12.5' WHERE config_name = 'version';
UPDATE phpbb_portal_config SET config_value = '' WHERE config_name = 'ri_time';
UPDATE phpbb_portal_config SET config_value = '' WHERE config_name = 'ri_data';

Now, you have to replace all the files from: http://www.przemo.org/php...12.4-1.12.5.zip

Gadatliwa Kasia

petekin74 · Posty: 79

where do i get the 1.12.5 english version. I went to http://www.przemo.org/ and when I click on the 1.12.5 download it says english version not available.

Rif_Raf · **Pomógł:** 71 razy Posty: 468

http://www.przemo.org/phpBB2/index.php?id=0 this should work. Set language to english.

[ Dodano: 12-05-2006, 03:45 ]
After you install

tristan/SMM · Posty: 13

HELP!

Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM phpbb_users WHERE username = 'tristan'

Line : 65
File : login.php

This is what I got when I tried to log in after a failed attempt to update database!

Gracek · **Pomógł:** 222 razy Posty: 1781

first - update database
second - upload new files

tristan/SMM · Posty: 13

Ok, I tried installing it from scratch on another directory and here's the problem. I accidentally banned myself. So I tried everything and in the end had to delete the database and reinstall the software. Guess what? I try it, I'm still banned! HELP!

MaciekP · **Pomógł:** 12 razy Posty: 137

delete your cookies

tristan/SMM · Posty: 13

Oh! So this has the ban by cookie modification on? Can that be turned off? What happens when someone is un-banned or their ban expires? Is the cookie deactivated? Or do I need to notify an unbanned user that their cookies need to be deleted?

regua · **Pomógł:** 74 razy Posty: 444

ROTFL... no... but when you reinstall your board with database ALL settings are deleted, so you can't be banned. The only reason of this is that your browser "remembered" that you're banned - using cookies. When you delete them, everything should work fine. It isn't so easy that you just have to delete your cookies to remove your ban...

duyvan82 · Posty: 3

Hi,
I'm trying to upgrade my board from phpbb 2.0.20 to przemo 1.12.5 but i've got a problem while trying to upgrade the database. When I try to run scripts/upgrade.php I got an error message saying "Wrong file checkcum ./update.sql ! (9202778aed040c6f949a2072f7abc6a2)
Try to copy file on the server.". Could anyone tell me what went wrong?
Thanks in advance

Rif_Raf · **Pomógł:** 71 razy Posty: 468

Have you tried to copy this file on the server?

Set to passive mode in your ftp client, or try in binary mode

duyvan82 · Posty: 3

i have copied all the files in scripts folder to my server. I still got the same error message, I really have no idea what is going on.
Also, I'm not sure what you meant by setting to passive mod in the FTP client

I'm using FileZilla as my FTP client. Thanks for your help.

Rif_Raf · **Pomógł:** 71 razy Posty: 468

I don't now how FileZilla looks, mayby try this one:
http://www.ghisler.com/download.htm

Ctr+F to open ftp connections. If you configure it to your server "Edit" and on the bottom you have option "Use passive mode...."

When you are connected on the top of the program you have sth like this:
FTP Transfer mode... ; if the passive mode don't work try changing this

[ Dodano: 01-06-2006, 13:00 ]
hope you understand this

duyvan82 · Posty: 3

still got the same error message
Wrong file checkcum ./update.sql ! (9202778aed040c6f949a2072f7abc6a2)
Try to copy file on the server.

i'm hopeless

[ Added: 01-06-2006, 12:13 ]
do i have to upload my existing database to that scripts folder as well?

Gadatliwa Kasia

Rif_Raf · **Pomógł:** 71 razy Posty: 468

Hmm... well download .zip package of 1.12.5 again, unzip and try again.
If it don't work, you can send me PM with ftp server, login and pass and password to admin account and I'll try.