problems after upgrading phpbb 2.xx to integra

[fablack]

i have copy my db to my own pc and tried to upgrade phpbb to integra, and i have done it succesfully.
before upgrading i installd fi subice theme fot all users.
but when i tried to do the same on my server, i got a lot of problems

Find some problem in the way :

final report after runing the update .script

Code: Select all

   Information  Database type    :: mysql4Previous version :: 2.0.22Updated version  :: 2.0.22Updated IM version  :: 1.4.1  Updating database schema  Progress :: No updates requiredUpdating to IntegraMOD2 1.4.1  Progress :: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Migrating Personal Albums# NOTICE: Smartor's Photo Gallery was not previously installed and therefore there aren't any 'old' personal galleries to migrate. Script is ending.  Updating version and optimizing tables  Progress :: . . DoneResult   :: Some queries failed, the statements and errors are listing below       * Error :: Table 'phpbb_bots' already exists       SQL   :: CREATE TABLE phpbb_bots ( bot_id tinyint(3) unsigned NOT NULL auto_increment, bot_name varchar(255) NOT NULL default '', bot_agent text NOT NULL, last_visit varchar(255) NOT NULL default '', bot_visits varchar(255) NOT NULL default '0', bot_pages varchar(255) NOT NULL default '0', pending_agent text NOT NULL, pending_ip text NOT NULL, bot_ip text NOT NULL, PRIMARY KEY (bot_id) ) TYPE=MyISAM       * Error :: Table 'phpbb_portal_config' already exists       SQL   :: CREATE TABLE phpbb_portal_config ( id int(10) unsigned NOT NULL auto_increment, config_name varchar(255) NOT NULL default '', config_value varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM       * Error :: Table 'phpbb_shout' already exists       SQL   :: CREATE TABLE phpbb_shout ( shout_id mediumint(8) unsigned NOT NULL auto_increment, shout_username varchar(25) NOT NULL default '', shout_user_id mediumint(8) NOT NULL default '0', shout_group_id mediumint(8) NOT NULL default '0', shout_session_time int(11) NOT NULL default '0', shout_ip varchar(8) NOT NULL default '', shout_text text NOT NULL, shout_active mediumint(8) NOT NULL default '0', enable_bbcode tinyint(1) NOT NULL default '0', enable_html tinyint(1) NOT NULL default '0', enable_smilies tinyint(1) NOT NULL default '0', enable_sig tinyint(1) NOT NULL default '0', shout_bbcode_uid varchar(10) NOT NULL default '', KEY shout_id (shout_id) ) TYPE=MyISAM       * Error :: Unknown column 'bot_name' in 'field list'       SQL   :: INSERT INTO phpbb_bots (bot_id, bot_name, bot_agent, last_visit, bot_visits, bot_pages, pending_agent, pending_ip, bot_ip) VALUES (1, 'Googlebot', 'Googlebot', '', '0', '0', '', '', '216.239.46.|64.68.8|64.68.9|164.71.1.|192.51.44.'), (2, 'Alexa', 'ia_archiver', '', '0', '0', '', '', '66.28.250.|209.237.238.'), (3, 'Inktomi', 'Slurp/', '', '0', '0', '', '', '216.35.116.|66.196.|66.94.230.|202.212.5.'), (4, 'Infoseek', 'Infoseek', '', '0', '0', '', '', '204.162.9|205.226.203|206.3.30.|210.236.233.'), (5, 'Alta Vista', 'Scooter', '', '0', '0', '', '', '194.221.84.|204.123.28.|208.221.35|212.187.226.|66.17.148.'), (6, 'Lycos', 'Lycos', '', '0', '0', '', '', '208.146.27.|209.202.19|209.67.22|202.232.118.'), (7, 'FAST', 'alltheweb', '', '0', '0', '', '', '146.101.142.2|216.35.112.|64.41.254.2|213.188.8.'), (8, 'WiseNut', 'WISEnut', '', '0', '0', '', '', '64.241.243.|209.249.67.1|216.34.42.|66.35.208.'), (9, 'MSN', 'msnbot/', '', '0', '0', '', '', '131.107.3.|204.95.98.|131.107.1|65.54.164.95'), (10, 'Looksmart', 'MARTINI', '', '0', '0', '', '', '64.241.242.|207.138.42.212'), (11, 'Ask Jeeves', 'teoma', '', '0', '0', '', '', '216.200.130.|216.34.121.|63.236.92.1|64.55.148.|65.192.195.|65.214.36.')       * Error :: Duplicate entry 'prune_shouts' for key 1       SQL   :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_photo_local', '0'), ('allow_photo_remote', '0'), ('allow_photo_upload', '0'), ('photo_filesize', '102400'), ('photo_max_width', '800'), ('photo_max_height', '600'), ('photo_path', 'images/photos'), ('photo_gallery_path', 'images/photos/gallery'), ('read_viewphoto', ''), ('debug_mode', '1'), ('allow_news', '1'), ('news_item_trim', '0'), ('news_title_trim', '0'), ('news_item_num', '10'), ('news_path', 'images/news'), ('allow_rss', '1'), ('news_rss_desc', ''), ('news_rss_language', 'en_us'), ('news_rss_ttl', '60'), ('news_rss_cat', ''), ('news_rss_image', ''), ('news_rss_image_desc', ''), ('news_rss_item_count', '15'), ('news_rss_show_abstract', '1'), ('news_base_url', ''), ('news_index_file', 'portal.php'), ('prune_shouts', '0'), ('integramod_version', '1.4.1'), ('visit_counter', '3'), ('nextcron', '1163667600'), ('pseudocron', '1'), ('crontest', '2'), ('board_disable_msg', 'Upgrading the site...'), ('bluecard_limit', '3'), ('bluecard_limit_2', '1'), ('max_user_bancard', '10'), ('report_forum', '0'), ('max_link_bookmarks', '0'), ('user_topics_last_per_page_over', '0'), ('mini_cal_calendar_version', 'TOPIC'), ('mini_cal_limit', '10'), ('mini_cal_days_ahead', '30'), ('mini_cal_date_search', 'POSTS'), ('mini_cal_fdow', '0'), ('mini_cal_link_class', 'gensmall'), ('mini_cal_today_class', 'topicTitle'), ('mini_cal_auth', 'auth_view'), ('meta_keywords', ''), ('meta_de.scription', ''), ('meta_author', ''), ('meta_identifier_url', ''), ('meta_reply_to', ''), ('meta_revisit_after', ''), ('meta_category', ''), ('meta_copyright', ''), ('meta_generator', ''), ('meta_robots', ''), ('meta_distribution', ''), ('meta_date_creation_day', ''), ('meta_date_creation_month', ''), ('meta_date_creation_year', ''), ('meta_date_revision_day', ''), ('meta_date_revision_month', ''), ('meta_date_revision_year', ''), ('meta_redirect_url_time', ''), ('meta_redirect_url_adress', ''), ('meta_refresh', ''), ('meta_pragma', ''), ('meta_language', ''), ('auto_lang_en', 'english'), ('auto_lang_en-gb', 'english'), ('auto_lang_en-us', 'english'), ('auto_lang_fr', 'francais'), ('auto_lang_nl', 'nederlands'), ('auto_lang_nl-be', 'nederlands'), ('auto_lang_de', 'deutsch'), ('auto_lang_he', 'hebrew'), ('dbmtnc_rebuild_end', '0'), ('dbmtnc_rebuild_pos', '-1'), ('dbmtnc_rebuildcfg_maxmemory', '500'), ('dbmtnc_rebuildcfg_minposts', '3'), ('dbmtnc_rebuildcfg_php3only', '0'), ('dbmtnc_rebuildcfg_php3pps', '1'), ('dbmtnc_rebuildcfg_php4pps', '8'), ('dbmtnc_rebuildcfg_timelimit', '240'), ('dbmtnc_rebuildcfg_timeoverwrite', '0'), ('dbmtnc_disallow_postcounter', '0'), ('dbmtnc_disallow_rebuild', '0'), ('sig_max_lines', '5'), ('sig_wordwrap', '100'), ('sig_allow_font_sizes', '1'), ('sig_min_font_size', '7'), ('sig_max_font_size', '12'), ('sig_allow_bold', '1'), ('sig_allow_italic', '1'), ('sig_allow_underline', '1'), ('sig_allow_colors', '1'), ('sig_allow_quote', '0'), ('sig_allow_code', '0'), ('sig_allow_list', '0'), ('sig_allow_url', '1'), ('sig_allow_images', '1'), ('sig_max_images', '0'), ('sig_max_img_height', '75'), ('sig_max_img_width', '500'), ('sig_allow_on_max_img_size_fail', '0'), ('sig_max_img_files_size', '10'), ('sig_max_img_av_files_size', '0'), ('sig_exotic_bbcodes_disallowed', ''), ('sig_allow_smilies', '1'), ('logo_image_path', 'images/logo'), ('logo_image', 'phpbb2_logo2.png'), ('logo_image_w', '500'), ('logo_image_h', '110'), ('paypal_p_acct', ''), ('paypal_b_acct', ''), ('paypal_currency_code', 'USD'), ('lw_trial_period', '0'), ('dislay_x_donors', '10'), ('donate_start_time', ''), ('donate_end_time', ''), ('donate_cur_goal', '0'), ('donate_de.scription', ''), ('donate_to_points', '0'), ('donate_to_posts', '0'), ('list_top_donors', '0'), ('donate_to_grp_one', '0'), ('to_grp_one_amount', '0'), ('donate_to_grp_two', '0'), ('to_grp_two_amount', '0'), ('donate_currencies', 'USD;'), ('usd_to_primary', '0'), ('eur_to_primary', '0'), ('gbp_to_primary', '0'), ('cad_to_primary', '0'), ('jpy_to_primary', '0'), ('apmr_deny_msg', 'Sorry %U%, The Admin You Are Trying To Private Message Currently Is Not Accepting Private Messages.'), ('apmr_redirect_msg', 'The admin you have private messaged, has redirected your PM to another member for a faster response time.'), ('donor_rank_id', '0'), ('lw_header_reminder', '0'), ('phpBBSecurity_login_limit', '3'), ('phpBBSecurity_notify_admin', '1'), ('phpBBSecurity_notify_admin_id', '2'), ('phpBBSecurity_auto_ban', '1'), ('phpBBSecurity_allowed_sessions', '50'), ('phpBBSecurity_DDoS_Ban', '1'), ('phpBBSecurity_Encoded_Ban', '1'), ('phpBBSecurity_Union_Ban', '1'), ('phpBBSecurity_Clike_Ban', '1'), ('phpBBSecurity_SQL_Ban', '1'), ('phpBBSecurity_File_Ban', '1'), ('phpBBSecurity_Perl_Ban', '1'), ('phpBBSecurity_total_attempts', '0'), ('phpBBSecurity_Cback_Ban', '1'), ('phpBBSecurity_Allow_Change', '0'), ('phpBBSecurity_notify_admin_pm', '1'), ('phpBBSecurity_notify_admin_em', '1'), ('phpBBSecurity_DDoS_level', '1'), ('phpBBSecurity_per_page', '100'), ('phpBBSecurity_allowed_admins', ''), ('phpBBSecurity_disallowed_agents', ''), ('phpBBSecurity_disallowed_referers', ''), ('phpBBSecurity_last_backup_date', '19'), ('phpBBSecurity_backup_time', '18'), ('phpBBSecurity_backup_on', '1'), ('phpBBSecurity_backup_folder', 'backup'), ('phpBBSecurity_backup_filename', 'backup'), ('phpBBSecurity_guest_matches', '8'), ('phpBBSecurity_use_password_match', '1'), ('phpBBSecurity_password_min_length', '5'), ('phpBBSecurity_version', '1.0.3'), ('cash_disable', '0'), ('cash_display_after_posts', '0'), ('cash_post_message', 'You earned %s for that post'), ('cash_disable_spam_num', '10'), ('cash_disable_spam_time', '24'), ('cash_disable_spam_message', 'You have exceeded the alloted amount of posts and will not earn anything for your post'), ('cash_installed', 'yes'), ('cash_version', '2.2.3'), ('cash_adminbig', '0'), ('cash_adminnavbar', '1'), ('points_name', 'Points'), ('icon_per_row', '10'), ('summer_time', '0'), ('summer_time_auto', '1'), ('board_fdow', '0'), ('user_attachsig', '1'), ('user_notify', '0'), ('user_notify_pm', '1'), ('user_popup_pm', '1'), ('user_viewimg', '1'), ('user_allowhtml', '1'), ('user_buddy_friend_display', '1'), ('user_buddy_ignore_display', '1'), ('user_buddy_friend_of_display', '1'), ('user_buddy_ignored_by_display', '1'), ('user_timezone', '0'), ('user_summer_time', '0'), ('user_fdow', '0'), ('user_privmsgs_per_page', '5'), ('user_allow_viewonline', '1'), ('user_viewemail', '2'), ('user_viewpm', '1'), ('user_viewwebsite', '2'), ('user_viewmessenger', '2'), ('user_viewreal', '2'), ('user_watched_topics_per_page', '15'), ('user_topics_last_per_page', '15'), ('user_setbm', '0'), ('user_allowbbcode', '1'), ('user_allowsmile', '1'), ('user_viewavatar', '1'), ('user_viewsig', '1'), ('user_active', '1'), ('user_allow_email', '1'), ('user_allow_pm', '1'), ('user_allow_website', '1'), ('user_allow_messenger', '1'), ('user_allow_real', '1'), ('user_allowavatar', '1'), ('user_allowphoto', '1'), ('user_allowsignature', '1'), ('user_extra', '0'), ('user_lang', 'english'), ('user_dateformat', 'd M Y h:i a'), ('announcement_date_display', '1'), ('announcement_date_display_over', '0'), ('announcement_display', '1'), ('announcement_display_over', '0'), ('announcement_display_forum', '1'), ('announcement_display_forum_over', '0'), ('announcement_split', '1'), ('announcement_split_over', '0'), ('announcement_forum', '1'), ('announcement_forum_over', '0'), ('announcement_duration', '7'), ('announcement_prune_strategy', '0'), ('calendar_display_open', '0'), ('calendar_display_open_over', '0'), ('calendar_header_cells', '7'), ('calendar_header_cells_over', '0'), ('calendar_title_length', '30'), ('calendar_text_length', '200'), ('calendar_nb_row', '5'), ('calendar_nb_row_over', '0'), ('calendar_birthday', '1'), ('calendar_birthday_over', '0'), ('calendar_forum', '1'), ('calendar_forum_over', '0'), ('sub_forum', '1'), ('sub_forum_over', '0'), ('split_cat', '1'), ('split_cat_over', '0'), ('last_topic_title', '1'), ('last_topic_title_over', '0'), ('last_topic_title_length', '24'), ('sub_level_links', '2'), ('sub_level_links_over', '0'), ('display_viewonline', '2'), ('display_viewonline_over', '0'), ('max_posts', '1'), ('max_topics', '1'), ('max_users', '1'), ('last_topics_from_started', '3'), ('last_topics_from_started_over', '0'), ('last_topics_from_replied', '3'), ('last_topics_from_replied_over', '0'), ('last_topics_from_ended', '3'), ('last_topics_from_ended_over', '0'), ('last_topics_from_split', '1'), ('last_topics_from_split_over', '0'), ('last_topics_from_forum', '1'), ('last_topics_from_forum_over', '0'), ('username', ''), ('username_over', '0'), ('user_realname', ''), ('user_realname_over', '0'), ('user_birthday', ''), ('user_birthday_over', '0'), ('user_gender', ''), ('user_gender_over', '0'), ('user_country', ''), ('user_country_over', '0'), ('user_state', ''), ('user_state_over', '0'), ('user_email', ''), ('user_email_over', '0'), ('user_password', ''), ('user_password_over', '0'), ('phpBBSecurity_question', ''), ('phpBBSecurity_question_over', '0'), ('phpBBSecurity_answer', ''), ('phpBBSecurity_answer_over', '0'), ('user_attachsig_over', '0'), ('user_notify_over', '0'), ('user_notify_pm_over', '0'), ('user_popup_pm_over', '0'), ('user_style', ''), ('user_style_over', '0'), ('user_rules', ''), ('user_rules_over', '0'), ('user_from', ''), ('user_from_over', '0'), ('user_occ', ''), ('user_occ_over', '0'), ('user_holidays', ''), ('user_holidays_over', '0'), ('user_interests', ''), ('user_interests_over', '0'), ('user_home_phone', ''), ('user_home_phone_over', '0'), ('user_home_fax', ''), ('user_home_fax_over', '0'), ('user_work_phone', ''), ('user_work_phone_over', '0'), ('user_work_fax', ''), ('user_work_fax_over', '0'), ('user_cellular', ''), ('user_cellular_over', '0'), ('user_pager', ''), ('user_pager_over', '0'), ('user_msnm', ''), ('user_msnm_over', '0'), ('user_skype', ''), ('user_skype_over', '0'), ('user_icq', ''), ('user_icq_over', '0'), ('user_aim', ''), ('user_aim_over', '0'), ('user_yim', ''), ('user_yim_over', '0'), ('user_website', ''), ('user_website_over', '0'), ('user_lang_over', '0'), ('user_timezone_over', '0'), ('user_summer_time_over', '0'), ('user_dateformat_over', '0'), ('user_fdow_over', '0'), ('user_allow_viewonline_over', '0'), ('user_viewemail_over', '0'), ('user_viewpm_over', '0'), ('user_viewwebsite_over', '0'), ('user_viewmessenger_over', '0'), ('user_viewreal_over', '0'), ('user_setbm_over', '0'), ('user_allowbbcode_over', '0'), ('user_allowhtml_over', '0'), ('user_allowsmile_over', '0'), ('user_buddy_friend_display_over', '0'), ('user_buddy_ignore_display_over', '0'), ('user_buddy_friend_of_display_over', '0'), ('user_buddy_ignored_by_display_over', '0'), ('user_privmsgs_per_page_over', '0'), ('user_watched_topics_per_page_over', '0'), ('user_viewavatar_over', '0'), ('user_viewphoto', ''), ('user_viewphoto_over', '0'), ('user_viewsig_over', '0'), ('user_viewimg_over', '0'), ('icon_per_row_over', '0'), ('summer_time_over', '0'), ('summer_time_auto_over', '0'), ('board_fdow_over', '0'), ('mini_cal_calendar_version_over', '0'), ('mini_cal_limit_over', '0'), ('mini_cal_days_ahead_over', '0'), ('mini_cal_date_search_over', '0'), ('mini_cal_link_class_over', '0'), ('mini_cal_today_class_over', '0'), ('mini_cal_auth_over', '0'), ('user_active_over', '0'), ('user_allow_email_over', '0'), ('user_allow_pm_over', '0'), ('user_allow_website_over', '0'), ('user_allow_messenger_over', '0'), ('user_allow_real_over', '0'), ('user_allowavatar_over', '0'), ('user_allowphoto_over', '0'), ('user_allowsignature_over', '0'), ('user_extra_over', '0'), ('user_posts', ''), ('user_posts_over', '0'), ('user_warnings', ''), ('user_warnings_over', '0'), ('user_rank', ''), ('user_rank_over', '0'), ('split_global_announce', '1'), ('split_global_announce_over', '0'), ('split_announce', '1'), ('split_announce_over', '0'), ('split_sticky', '1'), ('split_sticky_over', '0'), ('split_topic_split', '0'), ('split_topic_split_over', '0'), ('xs_auto_compile', '0'), ('xs_auto_recompile', '0'), ('xs_use_cache', '0'), ('xs_php', 'php'), ('xs_def_template', 'Integra2'), ('xs_check_switches', '0'), ('xs_warn_includes', '0'), ('xs_add_comments', '0'), ('xs_ftp_host', ''), ('xs_ftp_login', ''), ('xs_ftp_path', ''), ('xs_downloads_count', '0'), ('xs_downloads_default', '0'), ('xs_shownav', '1'), ('xs_template_time', '1163665318'), ('xs_version', '7'), ('announcement_last_prune', '1163739599')       * Error :: Duplicate column name 'auth_global_announce'       SQL   :: ALTER TABLE phpbb_forums ADD auth_global_announce tinyint(2) NOT NULL default '0' AFTER auth_announce       * Error :: Duplicate column name 'forum_link'       SQL   :: ALTER TABLE phpbb_forums ADD forum_link varchar(255) default NULL       * Error :: Duplicate column name 'forum_link_hit_count'       SQL   :: ALTER TABLE phpbb_forums ADD forum_link_hit_count tinyint(1) NOT NULL default '0'       * Error :: Duplicate column name 'forum_link_hit'       SQL   :: ALTER TABLE phpbb_forums ADD forum_link_hit bigint(20) unsigned NOT NULL default '0'       * Error :: Duplicate entry '1' for key 1       SQL   :: INSERT INTO phpbb_portal_config (id, config_name, config_value) VALUES (1, 'md_cat_id', '0'), (2, 'md_pics_number', '2'), (3, 'md_pics_sort', '0'), (4, 'md_pics_all', '1'), (5, 'md_cat_id2', '0'), (6, 'md_pics_number2', '2'), (7, 'md_pics_sort2', '0'), (8, 'md_pics_all2', '0'), (9, 'md_num_announcements', '5'), (10, 'md_announcements_length', '250'), (11, 'md_announcements_forum_id', '1'), (12, 'md_num_top_downloads', '10'), (13, 'md_num_new_downloads', '10'), (14, 'md_num_new_donations', '10'), (15, 'md_links_style', '1'), (16, 'md_links_own1', '1'), (17, 'md_links_own2', '1'), (18, 'md_links_code', '1'), (19, 'md_poll_forum_id', '1'), (20, 'md_poll_bar_length', '75'), (21, 'md_ran_att_height', '200'), (22, 'md_ran_att_width', '200'), (23, 'md_ran_att_max', '3'), (24, 'md_ran_att_forums_incl', ''), (25, 'md_ran_att_forums_excl', ''), (26, 'md_except_forum_id', ''), (27, 'md_num_recent_topics', '10'), (28, 'md_approve_mod_installed', '1'), (29, 'md_recent_topics_style', '0'), (30, 'md_num_referers', '10'), (31, 'md_sort_referers', 'referer_hits DESC'), (32, 'md_search_option_text', 'IntegraMOD'), (33, 'md_display_not_visit', '1'), (34, 'md_hours_track_users', '24'), (35, 'md_scroll_delay', '100'), (36, 'header_width', '140'), (37, 'footer_width', '140'), (38, 'md_cache_file_locking', '1'), (39, 'md_cache_write_control', '1'), (40, 'md_cache_read_control', '1'), (41, 'md_cache_read_type', 'md5'), (42, 'md_cache_filename_protect', '0'), (43, 'md_cache_serialize', '1'), (44, 'default_portal', '1'), (45, 'cache_enabled', '1'), (46, 'portal_header', '1'), (47, 'portal_tail', '0')       * Error :: Duplicate column name 'post_icon'       SQL   :: ALTER TABLE phpbb_posts ADD post_icon tinyint(2) default NULL       * Error :: Duplicate key name 'post_icon'       SQL   :: ALTER TABLE phpbb_posts ADD KEY post_icon (post_icon)       * Error :: Duplicate column name 'topic_calendar_time'       SQL   :: ALTER TABLE phpbb_topics ADD topic_calendar_time int(11) default NULL       * Error :: Duplicate column name 'topic_calendar_duration'       SQL   :: ALTER TABLE phpbb_topics ADD topic_calendar_duration int(11) default NULL       * Error :: Duplicate column name 'topic_icon'       SQL   :: ALTER TABLE phpbb_topics ADD topic_icon tinyint(2) default NULL       * Error :: Duplicate key name 'topic_calendar_time'       SQL   :: ALTER TABLE phpbb_topics ADD KEY topic_calendar_time (topic_calendar_time)       * Error :: Duplicate column name 'user_birthday'       SQL   :: ALTER TABLE phpbb_users ADD user_birthday varchar(8) NOT NULL default '0'       * Error :: Duplicate column name 'user_calendar_display_open'       SQL   :: ALTER TABLE phpbb_users ADD user_calendar_display_open tinyint(1) NOT NULL default '0'       * Error :: Duplicate column name 'user_calendar_header_cells'       SQL   :: ALTER TABLE phpbb_users ADD user_calendar_header_cells tinyint(1) NOT NULL default '7'       * Error :: Duplicate column name 'user_calendar_nb_row'       SQL   :: ALTER TABLE phpbb_users ADD user_calendar_nb_row tinyint(2) unsigned NOT NULL default '5'       * Error :: Duplicate column name 'user_unread_topics'       SQL   :: ALTER TABLE phpbb_users ADD user_unread_topics text       * Error :: Column count doesn't match value count at row 1      SQL   :: REPLACE INTO `phpbb_config` VALUES ('gsoxcmjsdsiggifdglzkk', '1')      * Error :: Column count doesn't match value count at row 1       SQL   :: REPLACE INTO `phpbb_config` VALUES ('thpajyibeohxdezpossha', '0')       * Error :: Column count doesn't match value count at row 1      SQL   :: REPLACE INTO `phpbb_config` VALUES ('znierpqqabkiqlsottthb', '0')      * Error :: Column count doesn't match value count at row 1       SQL   :: REPLACE INTO `phpbb_config` VALUES ('sec_admin', 'gsoxcmjsdsiggifdglzkk')       * Error :: Column count doesn't match value count at row 1      SQL   :: REPLACE INTO `phpbb_config` VALUES ('sec_mods', 'thpajyibeohxdezpossha')      * Error :: Column count doesn't match value count at row 1       SQL   :: REPLACE INTO `phpbb_config` VALUES ('sec_name', 'znierpqqabkiqlsottthb')  This is probably nothing to worry about, update will continue. Should this fail to complete you may need to seek help at our development board. See README for details on how to obtain advice.Update completed  Please make sure you have updated your board files too, this file is only updating your database.  Please DELETE the install folder from your webspace!    Then the problems began:      

Code: Select all

Could not obtain bot data.  DEBUG MODE  SQL Error : 1054 Unknown column 'bot_ip' in 'field list'  SELECT bot_agent, bot_ip, bot_id, bot_visits, last_visit, bot_pages FROM phpbb_botsLine : 1995File : functions.php  Solved with table drop and created it again.Then new erros come :S  

Code: Select all

   Warning: main(./mods/netclectic/mini_cal/mini_cal_.php) [function.main]: failed to open stream: No such file or directory in /home/mydarcom/public_html/Novo/mods/netclectic/mini_cal/mini_cal.php on line 80  Warning: main() [function.include]: Failed opening './mods/netclectic/mini_cal/mini_cal_.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mydarcom/public_html/Novo/mods/netclectic/mini_cal/mini_cal.php on line 80  Fatal error: Call to undefined function: getminicalforumsauth() in /home/mydarcom/public_html/Novo/mods/netclectic/mini_cal/mini_cal.php on line 83  

Was trying to run the fixed found HERE
BUT
when i try to login i found another problem all accounts were locked up, so i found another post HERE to unlock the account and nothing solved ... so i made another search and try to change data by hand using phpmyadmin i changed the phpBBSecurity_answer and phpBBSecurity_question and it seams to be working since i get "Thank you for unlocking your account. You may now login." but the login keep locked and don't let me work with anything,

i hade only attach mod installd on my phpbb,

Can anyone help me

Tks in advanced

[Zappa]

Another one with the same trouble, wellmore or less.

/Zappa

[Frost]

i have copy my db to my own pc and tried to upgrade phpbb to integra, and i have done it succesfully.

Did you copy the db back from your pc to your server then upgrade?
If so that is why you got the errors. It looks like most of what the upgrade .script was trying to do was already done.

Also make sure that all of the chmod's are done correctly

[Zappa]

OK, to make it abit more informative...

I can only speak for my own part though (sorry for hijacking the thread).

[Hijack mode ON]
1. Copy the phpBB 2.0.22 to a new webserver instance on the same physical server, yes it did work before and had it's own DB instance as well.

On this installation I have the following mods already inplace:
- Custom Title Mod
- Admin Userlist
- Mw3
- Skype MOD
- Rank in memberlist
- Login Box At overall header
- Live Email Validate (though manually removed)
- EasyMOD

2. Followed the instructions in the readme file.

This evening I'm gonna try another update but sorry to say I doubt it will go any better, if it doesn't work I'll try to upgrade to 1.4.0 first and then make sure it's workign and the upgrade to 1.4.1.

This time I'm gonna save all information for each step...

Cheers,
Zappa

[fablack]

tanx people i found out what what was wrong.
the db tabels field was wrong.
so i made a backup of mysql db of the old phpbb
so i have copy the db tabels,and some configuretion row's, what i had on my own pc to the server and upload it to the server.
than restored all my massages and users.

and it work again <img>

[Zappa]

I hope it's OK if I hijack this thread completely now... <img>

I still can't logon to the system, first I don't even have a admin user since I've inherite this board and I the first person to install didn't made an universal admin user but he's own. Therefor the SQL code in creating users at the first time can't be run. User ID 2 is already taken. Do the admin have to have User ID 2 or will it work if I enter my next availible number?

Code: Select all

InformationDatabase type    :: mysqlPrevious version :: 2.0.22Updated version  :: 2.0.22  Updated IM version  :: 1.4.1  Updating database schemaProgress :: No updates required  Updating to IntegraMOD2 1.4.1Progress :: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  Migrating Personal AlbumsNOTICE: Smartor's Photo Gallery was not previously installed and therefore there aren't any 'old' personal galleries to migrate. Script is ending.  Updating version and optimizing tablesProgress :: . . DoneResult   :: Some queries failed, the statements and errors are listing below Error :: Table 'phpbb_attach_quota' already existsSQL   :: CREATE TABLE phpbb_attach_quota ( user_id mediumint(8) unsigned NOT NULL default '0', group_id mediumint(8) unsigned NOT NULL default '0', quota_type smallint(2) NOT NULL default '0', quota_limit_id mediumint(8) unsigned NOT NULL default '0', KEY quota_type (quota_type) ) TYPE=MyISAM    Error :: Table 'phpbb_attachments' already existsSQL   :: CREATE TABLE phpbb_attachments ( attach_id mediumint(8) unsigned NOT NULL default '0', post_id mediumint(8) unsigned NOT NULL default '0', privmsgs_id mediumint(8) unsigned NOT NULL default '0', user_id_1 mediumint(8) NOT NULL, user_id_2 mediumint(8) NOT NULL, KEY attach_id_post_id (attach_id,post_id), KEY attach_id_privmsgs_id (attach_id,privmsgs_id), KEY post_id (post_id), KEY privmsgs_id (privmsgs_id) ) TYPE=MyISAM    Error :: Table 'phpbb_attachments_config' already existsSQL   :: CREATE TABLE phpbb_attachments_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name) ) TYPE=MyISAM    Error :: Table 'phpbb_attachments_desc' already existsSQL   :: CREATE TABLE phpbb_attachments_desc ( attach_id mediumint(8) unsigned NOT NULL auto_increment, physical_filename varchar(255) NOT NULL, real_filename varchar(255) NOT NULL, download_count mediumint(8) unsigned NOT NULL default '0', `comment` varchar(255) default NULL, extension varchar(100) default NULL, mimetype varchar(100) default NULL, filesize int(20) NOT NULL, filetime int(11) NOT NULL default '0', thumbnail tinyint(1) NOT NULL default '0', PRIMARY KEY (attach_id), KEY filetime (filetime), KEY physical_filename (physical_filename(10)), KEY filesize (filesize) ) TYPE=MyISAM    Error :: Table 'phpbb_extension_groups' already existsSQL   :: CREATE TABLE phpbb_extension_groups ( group_id mediumint(8) NOT NULL auto_increment, group_name char(20) NOT NULL, cat_id tinyint(2) NOT NULL default '0', allow_group tinyint(1) NOT NULL default '0', download_mode tinyint(1) unsigned NOT NULL default '1', upload_icon varchar(100) default '', max_filesize int(20) NOT NULL default '0', forum_permissions varchar(255) NOT NULL default '', PRIMARY KEY (group_id) ) TYPE=MyISAM    Error :: Table 'phpbb_extensions' already existsSQL   :: CREATE TABLE phpbb_extensions ( ext_id mediumint(8) unsigned NOT NULL auto_increment, group_id mediumint(8) unsigned NOT NULL default '0', extension varchar(100) NOT NULL, `comment` varchar(100) default NULL, PRIMARY KEY (ext_id) ) TYPE=MyISAM    Error :: Table 'phpbb_flags' already existsSQL   :: CREATE TABLE phpbb_flags ( flag_id int(10) NOT NULL auto_increment, flag_name varchar(25) default NULL, flag_image varchar(25) default NULL, PRIMARY KEY (flag_id) ) TYPE=MyISAM    Error :: Table 'phpbb_forbidden_extensions' already existsSQL   :: CREATE TABLE phpbb_forbidden_extensions ( ext_id mediumint(8) unsigned NOT NULL auto_increment, extension varchar(100) NOT NULL, PRIMARY KEY (ext_id) ) TYPE=MyISAM    Error :: Table 'phpbb_quota_limits' already existsSQL   :: CREATE TABLE phpbb_quota_limits ( quota_limit_id mediumint(8) unsigned NOT NULL auto_increment, quota_desc varchar(20) NOT NULL default '', quota_limit bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (quota_limit_id) ) TYPE=MyISAM    Error :: Duplicate column name 'auth_download'SQL   :: ALTER TABLE phpbb_auth_access ADD auth_download tinyint(1) NOT NULL default '0'    Error :: Duplicate entry 'upload_dir' for key 1SQL   :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_dir', 'files'), ('upload_img', 'images/icon_clip.gif'), ('topic_icon', 'images/icon_clip.gif'), ('display_order', '0'), ('max_filesize', '262144'), ('attachment_quota', '52428800'), ('max_filesize_pm', '262144'), ('max_attachments', '3'), ('max_attachments_pm', '1'), ('disable_mod', '0'), ('allow_pm_attach', '1'), ('attachment_topic_review', '0'), ('allow_ftp_upload', '0'), ('show_apcp', '0'), ('attach_version', '2.3.13'), ('default_upload_quota', '0'), ('default_pm_quota', '0'), ('ftp_server', ''), ('ftp_path', ''), ('download_path', ''), ('ftp_user', ''), ('ftp_pass', ''), ('ftp_pasv_mode', '1'), ('img_display_inlined', '1'), ('img_max_width', '0'), ('img_max_height', '0'), ('img_link_width', '0'), ('img_link_height', '0'), ('img_create_thumbnail', '0'), ('img_min_thumb_filesize', '12000'), ('img_imagick', ''), ('use_gd2', '1'), ('wma_autoplay', '0'), ('flash_autoplay', '0')    Error :: Duplicate entry 'user_topics_last_per_page_over' for key 1SQL   :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_photo_local', '0'), ('allow_photo_remote', '0'), ('allow_photo_upload', '0'), ('photo_filesize', '102400'), ('photo_max_width', '800'), ('photo_max_height', '600'), ('photo_path', 'images/photos'), ('photo_gallery_path', 'images/photos/gallery'), ('read_viewphoto', ''), ('debug_mode', '1'), ('allow_news', '1'), ('news_item_trim', '0'), ('news_title_trim', '0'), ('news_item_num', '10'), ('news_path', 'images/news'), ('allow_rss', '1'), ('news_rss_desc', ''), ('news_rss_language', 'en_us'), ('news_rss_ttl', '60'), ('news_rss_cat', ''), ('news_rss_image', ''), ('news_rss_image_desc', ''), ('news_rss_item_count', '15'), ('news_rss_show_abstract', '1'), ('news_base_url', ''), ('news_index_file', 'portal.php'), ('prune_shouts', '0'), ('integramod_version', '1.4.1'), ('visit_counter', '3'), ('nextcron', '1163667600'), ('pseudocron', '1'), ('crontest', '2'), ('board_disable_msg', 'Upgrading the site...'), ('bluecard_limit', '3'), ('bluecard_limit_2', '1'), ('max_user_bancard', '10'), ('report_forum', '0'), ('max_link_bookmarks', '0'), ('user_topics_last_per_page_over', '0'), ('mini_cal_calendar_version', 'TOPIC'), ('mini_cal_limit', '10'), ('mini_cal_days_ahead', '30'), ('mini_cal_date_search', 'POSTS'), ('mini_cal_fdow', '0'), ('mini_cal_link_class', 'gensmall'), ('mini_cal_today_class', 'topicTitle'), ('mini_cal_auth', 'auth_view'), ('meta_keywords', ''), ('meta_de.scription', ''), ('meta_author', ''), ('meta_identifier_url', ''), ('meta_reply_to', ''), ('meta_revisit_after', ''), ('meta_category', ''), ('meta_copyright', ''), ('meta_generator', ''), ('meta_robots', ''), ('meta_distribution', ''), ('meta_date_creation_day', ''), ('meta_date_creation_month', ''), ('meta_date_creation_year', ''), ('meta_date_revision_day', ''), ('meta_date_revision_month', ''), ('meta_date_revision_year', ''), ('meta_redirect_url_time', ''), ('meta_redirect_url_adress', ''), ('meta_refresh', ''), ('meta_pragma', ''), ('meta_language', ''), ('auto_lang_en', 'english'), ('auto_lang_en-gb', 'english'), ('auto_lang_en-us', 'english'), ('auto_lang_fr', 'francais'), ('auto_lang_nl', 'nederlands'), ('auto_lang_nl-be', 'nederlands'), ('auto_lang_de', 'deutsch'), ('auto_lang_he', 'hebrew'), ('dbmtnc_rebuild_end', '0'), ('dbmtnc_rebuild_pos', '-1'), ('dbmtnc_rebuildcfg_maxmemory', '500'), ('dbmtnc_rebuildcfg_minposts', '3'), ('dbmtnc_rebuildcfg_php3only', '0'), ('dbmtnc_rebuildcfg_php3pps', '1'), ('dbmtnc_rebuildcfg_php4pps', '8'), ('dbmtnc_rebuildcfg_timelimit', '240'), ('dbmtnc_rebuildcfg_timeoverwrite', '0'), ('dbmtnc_disallow_postcounter', '0'), ('dbmtnc_disallow_rebuild', '0'), ('sig_max_lines', '5'), ('sig_wordwrap', '100'), ('sig_allow_font_sizes', '1'), ('sig_min_font_size', '7'), ('sig_max_font_size', '12'), ('sig_allow_bold', '1'), ('sig_allow_italic', '1'), ('sig_allow_underline', '1'), ('sig_allow_colors', '1'), ('sig_allow_quote', '0'), ('sig_allow_code', '0'), ('sig_allow_list', '0'), ('sig_allow_url', '1'), ('sig_allow_images', '1'), ('sig_max_images', '0'), ('sig_max_img_height', '75'), ('sig_max_img_width', '500'), ('sig_allow_on_max_img_size_fail', '0'), ('sig_max_img_files_size', '10'), ('sig_max_img_av_files_size', '0'), ('sig_exotic_bbcodes_disallowed', ''), ('sig_allow_smilies', '1'), ('logo_image_path', 'images/logo'), ('logo_image', 'phpbb2_logo2.png'), ('logo_image_w', '500'), ('logo_image_h', '110'), ('paypal_p_acct', ''), ('paypal_b_acct', ''), ('paypal_currency_code', 'USD'), ('lw_trial_period', '0'), ('dislay_x_donors', '10'), ('donate_start_time', ''), ('donate_end_time', ''), ('donate_cur_goal', '0'), ('donate_de.scription', ''), ('donate_to_points', '0'), ('donate_to_posts', '0'), ('list_top_donors', '0'), ('donate_to_grp_one', '0'), ('to_grp_one_amount', '0'), ('donate_to_grp_two', '0'), ('to_grp_two_amount', '0'), ('donate_currencies', 'USD;'), ('usd_to_primary', '0'), ('eur_to_primary', '0'), ('gbp_to_primary', '0'), ('cad_to_primary', '0'), ('jpy_to_primary', '0'), ('apmr_deny_msg', 'Sorry %U%, The Admin You Are Trying To Private Message Currently Is Not Accepting Private Messages.'), ('apmr_redirect_msg', 'The admin you have private messaged, has redirected your PM to another member for a faster response time.'), ('donor_rank_id', '0'), ('lw_header_reminder', '0'), ('phpBBSecurity_login_limit', '3'), ('phpBBSecurity_notify_admin', '1'), ('phpBBSecurity_notify_admin_id', '2'), ('phpBBSecurity_auto_ban', '1'), ('phpBBSecurity_allowed_sessions', '50'), ('phpBBSecurity_DDoS_Ban', '1'), ('phpBBSecurity_Encoded_Ban', '1'), ('phpBBSecurity_Union_Ban', '1'), ('phpBBSecurity_Clike_Ban', '1'), ('phpBBSecurity_SQL_Ban', '1'), ('phpBBSecurity_File_Ban', '1'), ('phpBBSecurity_Perl_Ban', '1'), ('phpBBSecurity_total_attempts', '0'), ('phpBBSecurity_Cback_Ban', '1'), ('phpBBSecurity_Allow_Change', '0'), ('phpBBSecurity_notify_admin_pm', '1'), ('phpBBSecurity_notify_admin_em', '1'), ('phpBBSecurity_DDoS_level', '1'), ('phpBBSecurity_per_page', '100'), ('phpBBSecurity_allowed_admins', ''), ('phpBBSecurity_disallowed_agents', ''), ('phpBBSecurity_disallowed_referers', ''), ('phpBBSecurity_last_backup_date', '19'), ('phpBBSecurity_backup_time', '18'), ('phpBBSecurity_backup_on', '1'), ('phpBBSecurity_backup_folder', 'backup'), ('phpBBSecurity_backup_filename', 'backup'), ('phpBBSecurity_guest_matches', '8'), ('phpBBSecurity_use_password_match', '1'), ('phpBBSecurity_password_min_length', '5'), ('phpBBSecurity_version', '1.0.3'), ('cash_disable', '0'), ('cash_display_after_posts', '0'), ('cash_post_message', 'You earned %s for that post'), ('cash_disable_spam_num', '10'), ('cash_disable_spam_time', '24'), ('cash_disable_spam_message', 'You have exceeded the alloted amount of posts and will not earn anything for your post'), ('cash_installed', 'yes'), ('cash_version', '2.2.3'), ('cash_adminbig', '0'), ('cash_adminnavbar', '1'), ('points_name', 'Points'), ('icon_per_row', '10'), ('summer_time', '0'), ('summer_time_auto', '1'), ('board_fdow', '0'), ('user_attachsig', '1'), ('user_notify', '0'), ('user_notify_pm', '1'), ('user_popup_pm', '1'), ('user_viewimg', '1'), ('user_allowhtml', '1'), ('user_buddy_friend_display', '1'), ('user_buddy_ignore_display', '1'), ('user_buddy_friend_of_display', '1'), ('user_buddy_ignored_by_display', '1'), ('user_timezone', '0'), ('user_summer_time', '0'), ('user_fdow', '0'), ('user_privmsgs_per_page', '5'), ('user_allow_viewonline', '1'), ('user_viewemail', '2'), ('user_viewpm', '1'), ('user_viewwebsite', '2'), ('user_viewmessenger', '2'), ('user_viewreal', '2'), ('user_watched_topics_per_page', '15'), ('user_topics_last_per_page', '15'), ('user_setbm', '0'), ('user_allowbbcode', '1'), ('user_allowsmile', '1'), ('user_viewavatar', '1'), ('user_viewsig', '1'), ('user_active', '1'), ('user_allow_email', '1'), ('user_allow_pm', '1'), ('user_allow_website', '1'), ('user_allow_messenger', '1'), ('user_allow_real', '1'), ('user_allowavatar', '1'), ('user_allowphoto', '1'), ('user_allowsignature', '1'), ('user_extra', '0'), ('user_lang', 'english'), ('user_dateformat', 'd M Y h:i a'), ('announcement_date_display', '1'), ('announcement_date_display_over', '0'), ('announcement_display', '1'), ('announcement_display_over', '0'), ('announcement_display_forum', '1'), ('announcement_display_forum_over', '0'), ('announcement_split', '1'), ('announcement_split_over', '0'), ('announcement_forum', '1'), ('announcement_forum_over', '0'), ('announcement_duration', '7'), ('announcement_prune_strategy', '0'), ('calendar_display_open', '0'), ('calendar_display_open_over', '0'), ('calendar_header_cells', '7'), ('calendar_header_cells_over', '0'), ('calendar_title_length', '30'), ('calendar_text_length', '200'), ('calendar_nb_row', '5'), ('calendar_nb_row_over', '0'), ('calendar_birthday', '1'), ('calendar_birthday_over', '0'), ('calendar_forum', '1'), ('calendar_forum_over', '0'), ('sub_forum', '1'), ('sub_forum_over', '0'), ('split_cat', '1'), ('split_cat_over', '0'), ('last_topic_title', '1'), ('last_topic_title_over', '0'), ('last_topic_title_length', '24'), ('sub_level_links', '2'), ('sub_level_links_over', '0'), ('display_viewonline', '2'), ('display_viewonline_over', '0'), ('max_posts', '1'), ('max_topics', '1'), ('max_users', '1'), ('last_topics_from_started', '3'), ('last_topics_from_started_over', '0'), ('last_topics_from_replied', '3'), ('last_topics_from_replied_over', '0'), ('last_topics_from_ended', '3'), ('last_topics_from_ended_over', '0'), ('last_topics_from_split', '1'), ('last_topics_from_split_over', '0'), ('last_topics_from_forum', '1'), ('last_topics_from_forum_over', '0'), ('username', ''), ('username_over', '0'), ('user_realname', ''), ('user_realname_over', '0'), ('user_birthday', ''), ('user_birthday_over', '0'), ('user_gender', ''), ('user_gender_over', '0'), ('user_country', ''), ('user_country_over', '0'), ('user_state', ''), ('user_state_over', '0'), ('user_email', ''), ('user_email_over', '0'), ('user_password', ''), ('user_password_over', '0'), ('phpBBSecurity_question', ''), ('phpBBSecurity_question_over', '0'), ('phpBBSecurity_answer', ''), ('phpBBSecurity_answer_over', '0'), ('user_attachsig_over', '0'), ('user_notify_over', '0'), ('user_notify_pm_over', '0'), ('user_popup_pm_over', '0'), ('user_style', ''), ('user_style_over', '0'), ('user_rules', ''), ('user_rules_over', '0'), ('user_from', ''), ('user_from_over', '0'), ('user_occ', ''), ('user_occ_over', '0'), ('user_holidays', ''), ('user_holidays_over', '0'), ('user_interests', ''), ('user_interests_over', '0'), ('user_home_phone', ''), ('user_home_phone_over', '0'), ('user_home_fax', ''), ('user_home_fax_over', '0'), ('user_work_phone', ''), ('user_work_phone_over', '0'), ('user_work_fax', ''), ('user_work_fax_over', '0'), ('user_cellular', ''), ('user_cellular_over', '0'), ('user_pager', ''), ('user_pager_over', '0'), ('user_msnm', ''), ('user_msnm_over', '0'), ('user_skype', ''), ('user_skype_over', '0'), ('user_icq', ''), ('user_icq_over', '0'), ('user_aim', ''), ('user_aim_over', '0'), ('user_yim', ''), ('user_yim_over', '0'), ('user_website', ''), ('user_website_over', '0'), ('user_lang_over', '0'), ('user_timezone_over', '0'), ('user_summer_time_over', '0'), ('user_dateformat_over', '0'), ('user_fdow_over', '0'), ('user_allow_viewonline_over', '0'), ('user_viewemail_over', '0'), ('user_viewpm_over', '0'), ('user_viewwebsite_over', '0'), ('user_viewmessenger_over', '0'), ('user_viewreal_over', '0'), ('user_setbm_over', '0'), ('user_allowbbcode_over', '0'), ('user_allowhtml_over', '0'), ('user_allowsmile_over', '0'), ('user_buddy_friend_display_over', '0'), ('user_buddy_ignore_display_over', '0'), ('user_buddy_friend_of_display_over', '0'), ('user_buddy_ignored_by_display_over', '0'), ('user_privmsgs_per_page_over', '0'), ('user_watched_topics_per_page_over', '0'), ('user_viewavatar_over', '0'), ('user_viewphoto', ''), ('user_viewphoto_over', '0'), ('user_viewsig_over', '0'), ('user_viewimg_over', '0'), ('icon_per_row_over', '0'), ('summer_time_over', '0'), ('summer_time_auto_over', '0'), ('board_fdow_over', '0'), ('mini_cal_calendar_version_over', '0'), ('mini_cal_limit_over', '0'), ('mini_cal_days_ahead_over', '0'), ('mini_cal_date_search_over', '0'), ('mini_cal_link_class_over', '0'), ('mini_cal_today_class_over', '0'), ('mini_cal_auth_over', '0'), ('user_active_over', '0'), ('user_allow_email_over', '0'), ('user_allow_pm_over', '0'), ('user_allow_website_over', '0'), ('user_allow_messenger_over', '0'), ('user_allow_real_over', '0'), ('user_allowavatar_over', '0'), ('user_allowphoto_over', '0'), ('user_allowsignature_over', '0'), ('user_extra_over', '0'), ('user_posts', ''), ('user_posts_over', '0'), ('user_warnings', ''), ('user_warnings_over', '0'), ('user_rank', ''), ('user_rank_over', '0'), ('split_global_announce', '1'), ('split_global_announce_over', '0'), ('split_announce', '1'), ('split_announce_over', '0'), ('split_sticky', '1'), ('split_sticky_over', '0'), ('split_topic_split', '0'), ('split_topic_split_over', '0'), ('xs_auto_compile', '0'), ('xs_auto_recompile', '0'), ('xs_use_cache', '0'), ('xs_php', 'php'), ('xs_def_template', 'Integra2'), ('xs_check_switches', '0'), ('xs_warn_includes', '0'), ('xs_add_comments', '0'), ('xs_ftp_host', ''), ('xs_ftp_login', ''), ('xs_ftp_path', ''), ('xs_downloads_count', '0'), ('xs_downloads_default', '0'), ('xs_shownav', '1'), ('xs_template_time', '1163665318'), ('xs_version', '7'), ('announcement_last_prune', '1163739599')    Error :: Duplicate entry '1' for key 1SQL   :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (1, 'Images', 1, 1, 1, '', 0, ''), (2, 'Archives', 0, 1, 1, '', 0, ''), (3, 'Plain Text', 0, 0, 1, '', 0, ''), (4, 'Documents', 0, 0, 1, '', 0, ''), (5, 'Real Media', 0, 0, 2, '', 0, ''), (6, 'Streams', 2, 0, 1, '', 0, ''), (7, 'Flash Files', 3, 0, 1, '', 0, '')    Error :: Duplicate entry '1' for key 1SQL   :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (1, 1, 'gif', ''), (2, 1, 'png', ''), (3, 1, 'jpeg', ''), (4, 1, 'jpg', ''), (5, 1, 'tif', ''), (6, 1, 'tga', ''), (7, 2, 'gtar', ''), (8, 2, 'gz', ''), (9, 2, 'tar', ''), (10, 2, 'zip', ''), (11, 2, 'rar', ''), (12, 2, 'ace', ''), (13, 3, 'txt', ''), (14, 3, 'c', ''), (15, 3, 'h', ''), (16, 3, 'cpp', ''), (17, 3, 'hpp', ''), (18, 3, 'diz', ''), (19, 4, 'xls', ''), (20, 4, 'doc', ''), (21, 4, 'dot', ''), (22, 4, 'pdf', ''), (23, 4, 'ai', ''), (24, 4, 'ps', ''), (25, 4, 'ppt', ''), (26, 5, 'rm', ''), (27, 6, 'wma', ''), (28, 7, 'swf', '')    Error :: Duplicate entry '1' for key 1SQL   :: INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES (1, 'Afghanistan', 'afghanistan.gif'), (2, 'Albania', 'albania.gif'), (3, 'Algeria', 'algeria.gif'), (4, 'Andorra', 'andorra.gif'), (5, 'Angola', 'angola.gif'), (6, 'Antigua and Barbuda', 'antiguabarbuda.gif'), (7, 'Argentina', 'argentina.gif'), (8, 'Armenia', 'armenia.gif'), (9, 'Australia', 'australia.gif'), (10, 'Austria', 'austria.gif'), (11, 'Azerbaijan', 'azerbaijan.gif'), (12, 'Bahamas', 'bahamas.gif'), (13, 'Bahrain', 'bahrain.gif'), (14, 'Bangladesh', 'bangladesh.gif'), (15, 'Barbados', 'barbados.gif'), (16, 'Belarus', 'belarus.gif'), (17, 'Belgium', 'belgium.gif'), (18, 'Belize', 'belize.gif'), (19, 'Benin', 'benin.gif'), (20, 'Bhutan', 'bhutan.gif'), (21, 'Bolivia', 'bolivia.gif'), (22, 'Bosnia Herzegovina', 'bosnia_herzegovina.gif'), (23, 'Botswana', 'botswana.gif'), (24, 'Brazil', 'brazil.gif'), (25, 'Brunei', 'brunei.gif'), (26, 'Bulgaria', 'bulgaria.gif'), (27, 'Burkina Faso', 'burkinafaso.gif'), (28, 'Burma', 'burma.gif'), (29, 'Burundi', 'burundi.gif'), (30, 'Cambodia', 'cambodia.gif'), (31, 'Cameroon', 'cameroon.gif'), (32, 'Canada', 'canada.gif'), (33, 'Central African Rep', 'centralafricanrep.gif'), (34, 'Chad', 'chad.gif'), (35, 'Chile', 'chile.gif'), (36, 'China', 'china.gif'), (37, 'Columbia', 'columbia.gif'), (38, 'Comoros', 'comoros.gif'), (39, 'Congo', 'congo.gif'), (40, 'Costa Rica', 'costarica.gif'), (41, 'Croatia', 'croatia.gif'), (42, 'Cuba', 'cuba.gif'), (43, 'Cyprus', 'cyprus.gif'), (44, 'Czech Republic', 'czechrepublic.gif'), (45, 'Dem Rep Congo', 'demrepcongo.gif'), (46, 'Denmark', 'denmark.gif'), (47, 'Djibouti', 'djibouti.gif'), (48, 'Dominica', 'dominica.gif'), (49, 'Dominican Rep', 'dominicanrep.gif'), (50, 'Ecuador', 'ecuador.gif'), (51, 'Egypt', 'egypt.gif'), (52, 'El Salvador', 'elsalvador.gif'), (53, 'Eq Guinea', 'eq_guinea.gif'), (54, 'Eritrea', 'eritrea.gif'), (55, 'Estonia', 'estonia.gif'), (56, 'Ethiopia', 'ethiopia.gif'), (57, 'Fiji', 'fiji.gif'), (58, 'Finland', 'finland.gif'), (59, 'France', 'france.gif'), (60, 'Gabon', 'gabon.gif'), (61, 'Gambia', 'gambia.gif'), (62, 'Georgia', 'georgia.gif'), (63, 'Germany', 'germany.gif'), (64, 'Ghana', 'ghana.gif'), (65, 'Greece', 'greece.gif'), (66, 'Grenada', 'grenada.gif'), (67, 'Grenadines', 'grenadines.gif'), (68, 'Guatemala', 'guatemala.gif'), (69, 'Guinea', 'guinea.gif'), (70, 'Guinea Bissau', 'guineabissau.gif'), (71, 'Guyana', 'guyana.gif'), (72, 'Haiti', 'haiti.gif'), (73, 'Honduras', 'honduras.gif'), (74, 'Hong Kong', 'hong_kong.gif'), (75, 'Hungary', 'hungary.gif'), (76, 'Iceland', 'iceland.gif'), (77, 'India', 'india.gif'), (78, 'Indonesia', 'indonesia.gif'), (79, 'Iran', 'iran.gif'), (80, 'Iraq', 'iraq.gif'), (81, 'Ireland', 'ireland.gif'), (82, 'Israel', 'israel.gif'), (83, 'Italy', 'italy.gif'), (84, 'Ivory Coast', 'ivorycoast.gif'), (85, 'Jamaica', 'jamaica.gif'), (86, 'Japan', 'japan.gif'), (87, 'Jordan', 'jordan.gif'), (88, 'Kazakhstan', 'kazakhstan.gif'), (89, 'Kenya', 'kenya.gif'), (90, 'Kiribati', 'kiribati.gif'), (91, 'Kuwait', 'kuwait.gif'), (92, 'Kyrgyzstan', 'kyrgyzstan.gif'), (93, 'Laos', 'laos.gif'), (94, 'Latvia', 'latvia.gif'), (95, 'Lebanon', 'lebanon.gif'), (96, 'Liberia', 'liberia.gif'), (97, 'Libya', 'libya.gif'), (98, 'Liechtenstein', 'liechtenstein.gif'), (99, 'Lithuania', 'lithuania.gif'), (100, 'Luxembourg', 'luxembourg.gif'), (101, 'Macadonia', 'macadonia.gif'), (102, 'Macau', 'macau.gif'), (103, 'Madagascar', 'madagascar.gif'), (104, 'Malawi', 'malawi.gif'), (105, 'Malaysia', 'malaysia.gif'), (106, 'Maldives', 'maldives.gif'), (107, 'Mali', 'mali.gif'), (108, 'Malta', 'malta.gif'), (109, 'Mauritania', 'mauritania.gif'), (110, 'Mauritius', 'mauritius.gif'), (111, 'Mexico', 'mexico.gif'), (112, 'Micronesia', 'micronesia.gif'), (113, 'Moldova', 'moldova.gif'), (114, 'Monaco', 'monaco.gif'), (115, 'Mongolia', 'mongolia.gif'), (116, 'Morocco', 'morocco.gif'), (117, 'Mozambique', 'mozambique.gif'), (118, 'Namibia', 'namibia.gif'), (119, 'Nauru', 'nauru.gif'), (120, 'Nepal', 'nepal.gif'), (121, 'Neth Antilles', 'neth_antilles.gif'), (122, 'Netherlands', 'netherlands.gif'), (123, 'New Zealand', 'newzealand.gif'), (124, 'Nicaragua', 'nicaragua.gif'), (125, 'Niger', 'niger.gif'), (126, 'Nigeria', 'nigeria.gif'), (127, 'North Korea', 'north_korea.gif'), (128, 'Norway', 'norway.gif'), (129, 'Oman', 'oman.gif'), (130, 'Pakistan', 'pakistan.gif'), (131, 'Panama', 'panama.gif'), (132, 'Papua New Guinea', 'papuanewguinea.gif'), (133, 'Paraguay', 'paraguay.gif'), (134, 'Peru', 'peru.gif'), (135, 'Philippines', 'philippines.gif'), (136, 'Poland', 'poland.gif'), (137, 'Portugal', 'portugal.gif'), (138, 'Puerto Rico', 'puertorico.gif'), (139, 'Qatar', 'qatar.gif'), (140, 'Quebec', 'quebec.gif'), (141, 'Rawanda', 'rawanda.gif'), (142, 'Romania', 'romania.gif'), (143, 'Russia', 'russia.gif'), (144, 'Sao Tome', 'sao_tome.gif'), (145, 'Saudi Arabia', 'saudiarabia.gif'), (146, 'Senegal', 'senegal.gif'), (147, 'Serbia', 'serbia.gif'), (148, 'Seychelles', 'seychelles.gif'), (149, 'Sierra Leone', 'sierraleone.gif'), (150, 'Singapore', 'singapore.gif'), (151, 'Slovakia', 'slovakia.gif'), (152, 'Slovenia', 'slovenia.gif'), (153, 'Solomon Islands', 'solomon_islands.gif'), (154, 'Somalia', 'somalia.gif'), (155, 'South Korea', 'south_korea.gif'), (156, 'South Africa', 'southafrica.gif'), (157, 'Spain', 'spain.gif'), (158, 'Sri Lanka', 'srilanka.gif'), (159, 'St Kitts Nevis', 'stkitts_nevis.gif'), (160, 'St Lucia', 'stlucia.gif'), (161, 'Sudan', 'sudan.gif'), (162, 'Suriname', 'suriname.gif'), (163, 'Sweden', 'sweden.gif'), (164, 'Switzerland', 'switzerland.gif'), (165, 'Syria', 'syria.gif'), (166, 'Taiwan', 'taiwan.gif'), (167, 'Tajikistan', 'tajikistan.gif'), (168, 'Tanzania', 'tanzania.gif'), (169, 'Thailand', 'thailand.gif'), (170, 'Togo', 'togo.gif'), (171, 'Tonga', 'tonga.gif'), (172, 'Trinidad and Tobago', 'trinidadandtobago.gif'), (173, 'Tunisia', 'tunisia.gif'), (174, 'Turkey', 'turkey.gif'), (175, 'Turkmenistan', 'turkmenistan.gif'), (176, 'Tuvala', 'tuvala.gif'), (177, 'United Arab Emirates', 'uae.gif'), (178, 'Uganda', 'uganda.gif'), (179, 'United Kingdom', 'uk.gif'), (180, 'Ukraine', 'ukraine.gif'), (181, 'Uruguay', 'uruguay.gif'), (182, 'United States of America', 'usa.gif'), (183, 'USSR', 'ussr.gif'), (184, 'Uzbekistan', 'uzbekistan.gif'), (185, 'Vanuatu', 'vanuatu.gif'), (186, 'Venezuela', 'venezuela.gif'), (187, 'Vietnam', 'vietnam.gif'), (188, 'Western Samoa', 'western_samoa.gif'), (189, 'Yemen', 'yemen.gif'), (190, 'Yugoslavia', 'yugoslavia.gif'), (191, 'Zaire', 'zaire.gif'), (192, 'Zambia', 'zambia.gif'), (193, 'Zimbabwe', 'zimbabwe.gif')    Error :: Duplicate entry '1' for key 1SQL   :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1, 'php'), (2, 'php3'), (3, 'php4'), (4, 'phtml'), (5, 'pl'), (6, 'asp'), (7, 'cgi')    Error :: Duplicate column name 'auth_download'SQL   :: ALTER TABLE phpbb_forums ADD auth_download tinyint(2) NOT NULL default '0'    Error :: Duplicate column name 'post_attachment'SQL   :: ALTER TABLE phpbb_posts ADD post_attachment tinyint(1) NOT NULL default '0'    Error :: Duplicate column name 'privmsgs_attachment'SQL   :: ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment tinyint(1) NOT NULL default '0'    Error :: Duplicate entry '1' for key 1SQL   :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144), (2, 'Medium', 2097152), (3, 'High', 5242880)    Error :: Duplicate column name 'topic_attachment'SQL   :: ALTER TABLE phpbb_topics ADD topic_attachment tinyint(1) NOT NULL default '0'    Error :: Duplicate column name 'user_skype'SQL   :: ALTER TABLE phpbb_users ADD user_skype varchar(255) default NULL    This is probably nothing to worry about, update will continue. Should this fail to complete you may need to seek help at our development board. See README for details on how to obtain advice.  Update completedPlease make sure you have updated your board files too, this file is only updating your database.  Please DELETE the install folder from your webspace!        

Looks like I have few mods before in the forum: Flag mod and something else...

When I try to reach the site now I can see in the logs...

Code: Select all

[27-Mar-2007 22] PHP Warning:  main(./mods/netclectic/mini_cal/mini_cal_.php) [<a>function.main</a>]: failed to open stream: No such file or directory in /home/httpd/hoorc.test/mods/netclectic/mini_cal/mini_cal.php on line 80[27-Mar-2007 22] PHP Warning:  main() [<a>function.include</a>]: Failed opening './mods/netclectic/mini_cal/mini_cal_.php' for inclusion (include_path='.:/usr/lib/php4') in /home/httpd/hoorc.test/mods/netclectic/mini_cal/mini_cal.php on line 80[27-Mar-2007 22] PHP Fatal error:  Call to undefined function: getminicalforumsauth() in /home/httpd/hoorc.test/mods/netclectic/mini_cal/mini_cal.php on line 83[27-Mar-2007 22] PHP Warning:  main(./mods/netclectic/mini_cal/mini_cal_.php) [<a>function.main</a>]: failed to open stream: No such file or directory in /home/httpd/hoorc.test/mods/netclectic/mini_cal/mini_cal.php on line 80[27-Mar-2007 22] PHP Warning:  main() [<a>function.include</a>]: Failed opening './mods/netclectic/mini_cal/mini_cal_.php' for inclusion (include_path='.:/usr/lib/php4') in /home/httpd/hoorc.test/mods/netclectic/mini_cal/mini_cal.php on line 80[27-Mar-2007 22] PHP Fatal error:  Call to undefined function: getminicalforumsauth() in /home/httpd/hoorc.test/mods/netclectic/mini_cal/mini_cal.php on line 83  

I solved it by applying the configuration entries in [url=http]this thread[/url].

But in the end I still get this error while trying to logon.

"Sorry, this account has exceeded its log in attempts. It is now locked. f you are the rightfull user, please click below to be redirected to a page to unlock your id."

Found a few notes about clearing stuff out in the _banlist but mine is empty???

So in the end I don't have an admin user and I can't logon to the board...

Any ideas???

Cheers,
Zappa

[Zappa]

OK I got another question...

When I look in the DB in table phpbb_config I see that almost every field is doubled???
I.e
I've got phpBBSecurity_question = '' and phpBBSecurity_question_over = '0'.

Is the _over the old version for the field??? If soo then I got a huge bunch om empty entried in _config. That might be my problem.

Or is it override? If then everything should be fine...

Cheers,
Zappa

[Helter]

you can give yourself admin, and "Board Founder" status, by opening

root/profilcp/functions_profile.php

find

Code: Select all

          $res = USER;         if ( ($userdata['user_level'] == ADMIN) && ($userdata['user_id'] == 2)  

inline, after, add

Code: Select all

   || ($userdata['user_level'] == ADMIN) && ($userdata['user_id'] == **)  

replace ** with your user id

when finished, it will look like

Code: Select all

          $res = USER;         if ( ($userdata['user_level'] == ADMIN) && ($userdata['user_id'] == 2) || ($userdata['user_level'] == ADMIN) && ($userdata['user_id'] == **))  

If you did not previously have admin, be sure to go to acp/security/special
and update the number of allowed admins. If the previous board founder should no longer be admin, you can simply replace
['user_id'] == 2) , with your id ... ['user_id'] == **)

[Zappa]

Sorry to say but I still get the same error without any error in any file and no debug information in IM.

Gonna a thing by taking a backup of the existing DB and make a fresh IM install, I don't think it will wok since there's a few mods on the board. But it's worth a try.

BTW on thing before I try it. Where in the DB can I find the number of admins allowed, I think I had to change the numbers since I have more users that are admins then the number of admins...

Cheers,
Zappa

[Helter]

phpbb_config

phpBBSecurity_allowed_admins =


usually around page 7

[Zappa]

OK, I've done some progress, now I prolly know what the problem is but not why...

I'm missing around 100 entries or so in phpbb_config table... Among alot of the phpBBSecurity entries.

Yes I can see that they should have been entered during the upgrade but something must have gone wrong...

Well gonna have to wait and investigate more another day/night...

Cheers,
Zappa

[Zappa]

Thanks alot ppl!

I can now login after doing some major research and going through tha fields in the config table and compare them to the ones in the phpbb_to_IM.php file.

It was a bunch of entries missing... Don't tell anyone this is my normal debugging mode... <img>

Cheers,
Zappa