Error while Updating to IntegraMOD2 1.4.1

[quky]

nedd help trying to migrated to this great phpbb mod board
the problem is that i am using a moded PhpBB from [url=http]ptifo[/url] (categories hierarchy v2.1.6

)
This is the error that i get

Information

Database type :: mysql4
Previous version :: 2.0.21
Updated version :: 2.0.22
Updated IM version :: 1.4.1

Updating database schema

Progress :: . Done
Result :: No errors
Updating to IntegraMOD2 1.4.1

Progress :: No updates were required
Migrating Personal Albums

Fatal error: Call to undefined function session_pagestart() in /var/www/vhosts/satprolatino.org/httpdocs/phpBB22/includes/functions.php on line 1714
Any help would be really appreciated

HP <img>

[quky]

well i delete the part from the update .script that does the albun deal
and run the install again and got this error

Information

Database type :: mysql4
Previous version :: 2.0.22
Updated version :: 2.0.22
Updated IM version :: 1.4.1

Updating database schema

Progress :: No updates required
Updating to IntegraMOD2 1.4.1

Progress :: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Updating version and optimizing tables

Progress :: . . Done
Result :: 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 :: 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 'sub_forum' 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 '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 column name 'post_attachment'
SQL :: ALTER TABLE phpbb_posts ADD post_attachment tinyint(1) NOT NULL default '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 'privmsgs_attachment'
SQL :: ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment tinyint(1) NOT NULL default '0'

* Error :: Duplicate column name 'topic_attachment'
SQL :: ALTER TABLE phpbb_topics ADD topic_attachment tinyint(1) NOT NULL default '0'

* 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 :: Column count doesn't match value count at row 1
SQL :: REPLACE INTO `phpbb_config` VALUES ('cxhyspzjhnmqjithegefg', '1')

* Error :: Column count doesn't match value count at row 1
SQL :: REPLACE INTO `phpbb_config` VALUES ('lxfepeszwuctbalrzuyng', '0')

* Error :: Column count doesn't match value count at row 1
SQL :: REPLACE INTO `phpbb_config` VALUES ('pwpieupizvuxbzmfrlbmn', '0')

* Error :: Column count doesn't match value count at row 1
SQL :: REPLACE INTO `phpbb_config` VALUES ('sec_admin', 'cxhyspzjhnmqjithegefg')

* Error :: Column count doesn't match value count at row 1
SQL :: REPLACE INTO `phpbb_config` VALUES ('sec_mods', 'lxfepeszwuctbalrzuyng')

* Error :: Column count doesn't match value count at row 1
SQL :: REPLACE INTO `phpbb_config` VALUES ('sec_name', 'pwpieupizvuxbzmfrlbmn')

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!



and in the site page this error

General Error

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_bots

Line : 1995
File : functions.php

[quky]

and upgrade
delete the phpbb_bots table and and run the install again

now on the site page this is the problem

Sorry, it appears this is your first visit since we added some required fields to the system.
Once you update the fields marked with *, you will be able to enjoy the whole site.
Thanks!

Click on the fieldnames below to complete them:
The Field "Security Answer" is required
The Field "Security Question" is required
The Field "Country Flag" is required
The Field "Rules" is required
The Field "Birthday" is required


the problem is that when i click on the files to upgrade it shows me the same screen and no let me go to profile for editing them.

Any help would be really appreciated

HP Mr. Green

[Helter]

There is currently no upgrade from this version of CH, However, Teelk is currently coding an upgrade from Integramod2.0 from integramod.com. Since they are both using the same CH version, he may be able to isolate the querries you would need to remove it and treat it as a plain phpbb upgrade. I have not looked into this myself, so I cant comment further on this

[quky]

unfortunately that site is down http://integramod.com/home/portal.php