JA$ON - 19-07-2006, 00:53 i had the same problem when trying to upgrade to Przemo 1.12.5 from phpBB 2.0.20.... it said "Wrong file checkcum ./update.sql ! (9202778aed040c6f949a2072f7abc6a2) Try to copy file on the server." can you try to upgrade for me, too? please, i need to get it upgraded quickly, please help me. thanks in advance for the support. btw: the forum that i set as my homepage when i registered is my old forum, i dont want to upgrade from that one, i want to upgrade from a plain phpBB version. regua - 19-07-2006, 00:59 I had same problem when I tried to upload the update.sql file with any FTP client other than Total Commander. Try it 
JA$ON - 19-07-2006, 01:14 wow that answer was quick i tried the program and it did actually change something. the upgrade now at least did somethign but now it says: The result of updating a database to phpBB modified v1.12.5 by Przemo Instructions executed: 819, not executed: 55 •Check the following SQL instructions It's important to check the reason for the action not having been executed. A missing table, column or a table already in the database are correct signs. Only information about no access to a command or an error in the SQL syntax are incorrect signs. Should you have any doubts, you can look for the answer or ask a question at http://www.przemo.org/phpBB2/ by pasting the line which hasn't been executed. Notice, you shouldn't use the file update.sql to make an update on your own because it doesn't contain all the necessary instructions! • Overwrite all files except config.php • Check in your Adminstrator's Control Panel: System Control, Take in account the logging ability of your catalogues • If your updating from the original version of phpBB correct the ranks in your Administrator's Control Panel and move them to the styles' folder. • If you're updating from the "by Przemo" version lower than 1.12.5 you can use the file /scripts/update_useragent.php to adjust the browser icons for "old" posts (use after sending the files) • Match the new Admin, JR Admin, Moderator colours and OnMouseOver colours in the Administrator's Control Panel and in your template data. DROP TABLE phpbb_topic_view Failed - Unknown table 'phpbb_topic_view' DROP TABLE phpbb_ignores Failed - Unknown table 'phpbb_ignores' ALTER TABLE phpbb_ignore RENAME phpbb_ignores Failed - Table 'hb-thug.phpbb_ignore' doesn't exist CREATE TABLE phpbb_sessions_keys ( key_id varchar(32) DEFAULT '0' NOT NULL, user_id mediumint(8) DEFAULT '0' NOT NULL, last_ip varchar(8)[...] Failed - Table 'phpbb_sessions_keys' already exists CREATE TABLE phpbb_themes_name ( themes_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, tr_color1_name char(50), tr_color2_name char(50), [...] Failed - Table 'phpbb_themes_name' already exists DROP TABLE phpbb_cat_rel_cat_parents Failed - Unknown table 'phpbb_cat_rel_cat_parents' DROP TABLE phpbb_cat_rel_forum_parents Failed - Unknown table 'phpbb_cat_rel_forum_parents' DROP TABLE phpbb_chat2box Failed - Unknown table 'phpbb_chat2box' DROP TABLE phpbb_chat2box_session Failed - Unknown table 'phpbb_chat2box_session' DROP TABLE phpbb_counter Failed - Unknown table 'phpbb_counter' DROP TABLE phpbb_junior_auth_panel Failed - Unknown table 'phpbb_junior_auth_panel' DROP TABLE phpbb_quickstats Failed - Unknown table 'phpbb_quickstats' DROP TABLE phpbb_rate_results Failed - Unknown table 'phpbb_rate_results' DROP TABLE phpbb_rate_config Failed - Unknown table 'phpbb_rate_config' DROP TABLE phpbb_rate_result Failed - Unknown table 'phpbb_rate_result' DROP TABLE phpbb_rate_config Failed - Unknown table 'phpbb_rate_config' ALTER TABLE phpbb_album_cat ADD cat_parent mediumint(8) unsigned NOT NULL default '0' AFTER cat_id Failed - Duplicate column name 'cat_parent' ALTER TABLE phpbb_album_cat ADD cat_type tinyint(2) NOT NULL default '0' AFTER cat_parent Failed - Duplicate column name 'cat_type' ALTER TABLE phpbb_banlist DROP ban_by Failed - Can't DROP 'ban_by'; check that column/key exists ALTER TABLE phpbb_banlist DROP ban_reason Failed - Can't DROP 'ban_reason'; check that column/key exists ALTER TABLE phpbb_categories DROP parent_forum_id Failed - Can't DROP 'parent_forum_id'; check that column/key exists ALTER TABLE phpbb_categories DROP cat_hier_level Failed - Can't DROP 'cat_hier_level'; check that column/key exists ALTER TABLE phpbb_forums DROP forum_hier_level Failed - Can't DROP 'forum_hier_level'; check that column/key exists ALTER TABLE phpbb_forums DROP forum_issub Failed - Can't DROP 'forum_issub'; check that column/key exists ALTER TABLE phpbb_forums DROP auth_rate Failed - Can't DROP 'auth_rate'; check that column/key exists ALTER TABLE phpbb_jr_admin_users DROP start_date Failed - Can't DROP 'start_date'; check that column/key exists ALTER TABLE phpbb_jr_admin_users DROP update_date Failed - Can't DROP 'update_date'; check that column/key exists ALTER TABLE phpbb_jr_admin_users DROP admin_notes Failed - Can't DROP 'admin_notes'; check that column/key exists ALTER TABLE phpbb_jr_admin_users DROP notes_view Failed - Can't DROP 'notes_view'; check that column/key exists ALTER TABLE phpbb_pa_settings ADD directly_linked int(5) NOT NULL default '0' Failed - Duplicate column name 'directly_linked' ALTER TABLE phpbb_profile_fields ADD prefix varchar(255) DEFAULT '' NOT NULL Failed - Table 'hb-thug.phpbb_profile_fields' doesn't exist ALTER TABLE phpbb_profile_fields ADD suffix varchar(255) DEFAULT '' NOT NULL Failed - Table 'hb-thug.phpbb_profile_fields' doesn't exist ALTER TABLE phpbb_profile_fields ADD editable tinyint(1) DEFAULT '1' NOT NULL Failed - Table 'hb-thug.phpbb_profile_fields' doesn't exist ALTER TABLE phpbb_profile_fields ADD view_by tinyint(1) DEFAULT '0' NOT NULL Failed - Table 'hb-thug.phpbb_profile_fields' doesn't exist ALTER TABLE phpbb_sessions ADD session_admin tinyint(2) DEFAULT '0' NOT NULL Failed - Duplicate column name 'session_admin' ALTER TABLE phpbb_users DROP custom_form Failed - Can't DROP 'custom_form'; check that column/key exists ALTER TABLE phpbb_users DROP can_custom_form Failed - Can't DROP 'can_custom_form'; check that column/key exists ALTER TABLE phpbb_users DROP page_avatar Failed - Can't DROP 'page_avatar'; check that column/key exists ALTER TABLE phpbb_users DROP user_traffic Failed - Can't DROP 'user_traffic'; check that column/key exists ALTER TABLE phpbb_users DROP user_allow_sig_image Failed - Can't DROP 'user_allow_sig_image'; check that column/key exists ALTER TABLE phpbb_users DROP user_allow_signature Failed - Can't DROP 'user_allow_signature'; check that column/key exists ALTER TABLE phpbb_users DROP user_posts_per_page Failed - Can't DROP 'user_posts_per_page'; check that column/key exists ALTER TABLE phpbb_users DROP user_topics_per_page Failed - Can't DROP 'user_topics_per_page'; check that column/key exists ALTER TABLE phpbb_users DROP user_hot_threshold Failed - Can't DROP 'user_hot_threshold'; check that column/key exists ALTER TABLE phpbb_users DROP user_sub_forum Failed - Can't DROP 'user_sub_forum'; check that column/key exists ALTER TABLE phpbb_users DROP user_split_cat Failed - Can't DROP 'user_split_cat'; check that column/key exists ALTER TABLE phpbb_users DROP user_last_topic_title Failed - Can't DROP 'user_last_topic_title'; check that column/key exists ALTER TABLE phpbb_users DROP user_sub_level_links Failed - Can't DROP 'user_sub_level_links'; check that column/key exists ALTER TABLE phpbb_users DROP user_display_viewonline Failed - Can't DROP 'user_display_viewonline'; check that column/key exists ALTER TABLE phpbb_users DROP view_ignore_topics Failed - Can't DROP 'view_ignore_topics'; check that column/key exists ALTER TABLE phpbb_users DROP user_showavatars Failed - Can't DROP 'user_showavatars'; check that column/key exists ALTER TABLE phpbb_users_warnings ADD warning_viewed smallint(1) DEFAULT '0' NOT NULL Failed - Duplicate column name 'warning_viewed' ALTER TABLE phpbb_shoutbox DROP sb_username Failed - Can't DROP 'sb_username'; check that column/key exists INSERT INTO phpbb_config (config_name, config_value) VALUES ('sendmail_fix', '0') Failed - Duplicate entry 'sendmail_fix' for key 1 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin', '1') Failed - Duplicate entry 'allow_autologin' for key 1 btw: i dont really know anything about MySQL and MyAdmin or how to use it thanks again for the support btw: it says im using firefox but im not, i did when i registered and when i first postet but only because my opera crashed. im using opera again now but it shows the firefox symbol even though i edited this post.. also im not using the windows version that its saying, im using windows xp with some windows vista inspirat modifications. is that mod also included in the latest version by przemo? geman - 19-07-2006, 01:24 it's ok, don't worry about it
JA$ON - 19-07-2006, 01:28 so i can just carry on even though it didn't work corectly??? geman - 19-07-2006, 01:34
everything was updated correctly. It shows that information because the updater is universal. Read this carefully:
JA$ON - 19-07-2006, 01:42 wow this support is soo fast
i post something and the answer is already written 
everything worked fine!! 
i cant believe that the only problem was my ftp program, filezilla alway worked fine before.. anyway thanks again for the support. [ Added: 19-07-2006, 02:43 ] wow it all works and i am amazed by the features that the przemo forum verison has!   
but is there a way to have a link to the portal (portal.php) in front of the index link that is on every page? also on the demo that i saw there was a box on the portal page with the most recent downloads under the box with the recentpublic pics. its not there on my portal, where can i turn these funktions on/off and change and edit them? btw: my browser crashed whilest i was logged in and when i opened it again i could log in but when i wanted to log in for the admin panel it said i have no authorisation!! but i tried again for about a minute and now it works again and accepts me as the admin. regua - 19-07-2006, 10:52
but try ACP => Configuration => Main Page => Portal link set it to Yes.
Try to search your ACP a little bit more before you ask us such questions 
JA$ON - 19-07-2006, 13:34 thanks its actually quiet easy to use i just had to get to know the new admin panel better and where i can change what. i ment that on the forum navigation there is for example: Forum Name Forum Index ť Category ť Topic ť Post when you have opened a post. and i wanted to have something like: Portal ť Forum Name Forum Index ť Category ť Topic ť Post and another question: what about installing languages or templates? are there problems when installing common styles or do i have to start making my own style and translate everything by myself? regua - 19-07-2006, 14:53 JA$ON, try enabling the Portal link in ACP. You can find some interesting styles on style.vplus.pl [use the jumpbox to change style and go to Download to get the style]. Styles from phpBB cannot be used with Przemo's modification. I'm afraid you have to translate it by yourself. JA$ON - 21-07-2006, 11:54 - problem solved - spacegoose - 21-01-2007, 16:43 Temat postu: problem with 1.8 to 1.12 upgrade i'm testing an upgrade from 1.8 to 1.12 and get: • You have damaged: config.php file ! • File must begin with: <?php and finish with ?> with any other chars (spaces, tabs or new line) before <?php and after ?> • You must correct the file ! • Remember it is not mistake, if your text editor can not see this space, tab or new line, use other editor with operating multi (CR/LF) format or create new file with clean content. • Forum will not work correctly with damaged config.php file. i followed the instructions above, checked permissions on config.php, etc. but still receive the error. thanks, sg azwel - 21-01-2007, 17:25 spacegoose, this is the most common case:
Check this in notepad and if there are any spaces, remove them. spacegoose - 22-01-2007, 01:22 Temat postu: spaces in config.php i removed every space, made the whole thing 1 line. in any event after logging-in i still receive the error. if i go back though, i am logged-in - same with the admin area, i get the config.php space error, but going back a page, and clicking on theadmin area link again, i can get in. also - user name "nick" is hardcoded into index_body.tpl ??? thanks for any hints to resolve the config.php problems, sg [ Added: 22-01-2007, 01:42 ] i decided to delete config.php, and do what i suppose is a full-install - i chose a new prefix e.g. phpbb2 - i followed the upgrade instructions (except for not replacing config.php), i replaced it with the empty file included in the .zip because mine was not working. the install script generated a working config.php (i could see the example forum, albeit in polish) - however as soon as i edited config.php (in vi) to use my original prefix phpbb_ i received the same errors. does this indicate a problem not with the config.ph file, but my phpbb_ upgraded database? the config file worked before the upgrade from 1.8 to 1.12. thanks again, sg azwel - 22-01-2007, 10:20 spacegoose, the fact that you get the same error indicates that your text editor must have added a blank invisible line after "?>". There's no other logical explanation. |
||||||||||||||||
