Author: 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
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:
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
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
Don't tell anyone this is my normal debugging mode... <img> 