https://www.icyphoenix.com/viewtopic.php?f=35&t=1754
-----------------------------------
Vortex
Thu 26 Apr, 2007 20:25

Error Upgrading From XS0.58 To Icy
-----------------------------------
I did a backup of all my forum and installed a clone forum to test before official upgrade... and I got many errors.

Then, I installed a vanilla XS and [u]just after having completed the installation[/u] I tryed the upgrade to Icy.


I got this strange alternance of errors, the same I had with my forum... 



[spoiler]
# UPDATE phpbbXS_config SET config_value = '0' WHERE url_rw = 'ip_version'
+++ Error: Unknown column 'url_rw' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('xmas_fx', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE xmas_fx = 'ip_version'
+++ Error: Unknown column 'xmas_fx' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('switch_header_table', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE switch_header_table = 'ip_version'
+++ Error: Unknown column 'switch_header_table' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('header_table_text', 'Text')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = 'Text' WHERE header_table_text = 'ip_version'
+++ Error: Unknown column 'header_table_text' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('switch_footer_table', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE switch_footer_table = 'ip_version'
+++ Error: Unknown column 'switch_footer_table' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('footer_table_text', 'Text')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = 'Text' WHERE footer_table_text = 'ip_version'
+++ Error: Unknown column 'footer_table_text' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('fast_n_furious', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE fast_n_furious = 'ip_version'
+++ Error: Unknown column 'fast_n_furious' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('new_msgs_mumber', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE new_msgs_mumber = 'ip_version'
+++ Error: Unknown column 'new_msgs_mumber' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('index_last_msgs', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE index_last_msgs = 'ip_version'
+++ Error: Unknown column 'index_last_msgs' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('portal_last_msgs', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE portal_last_msgs = 'ip_version'
+++ Error: Unknown column 'portal_last_msgs' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('online_last_msgs', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE online_last_msgs = 'ip_version'
+++ Error: Unknown column 'online_last_msgs' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('index_shoutbox', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE index_shoutbox = 'ip_version'
+++ Error: Unknown column 'index_shoutbox' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('portal_shoutbox', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE portal_shoutbox = 'ip_version'
+++ Error: Unknown column 'portal_shoutbox' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('online_shoutbox', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE online_shoutbox = 'ip_version'
+++ Error: Unknown column 'online_shoutbox' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('last_msgs_n', '5')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '5' WHERE last_msgs_n = 'ip_version'
+++ Error: Unknown column 'last_msgs_n' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('last_msgs_x', '')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '' WHERE last_msgs_x = 'ip_version'
+++ Error: Unknown column 'last_msgs_x' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('posts_precompiled', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE posts_precompiled = 'ip_version'
+++ Error: Unknown column 'posts_precompiled' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('index_links', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE index_links = 'ip_version'
+++ Error: Unknown column 'index_links' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('index_birthday', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE index_birthday = 'ip_version'
+++ Error: Unknown column 'index_birthday' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('db_cron', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE db_cron = 'ip_version'
+++ Error: Unknown column 'db_cron' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('site_history', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE site_history = 'ip_version'
+++ Error: Unknown column 'site_history' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('smilies_topic_title', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE smilies_topic_title = 'ip_version'
+++ Error: Unknown column 'smilies_topic_title' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('html_email', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE html_email = 'ip_version'
+++ Error: Unknown column 'html_email' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('config_cache', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE config_cache = 'ip_version'
+++ Error: Unknown column 'config_cache' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('admin_protect', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE admin_protect = 'ip_version'
+++ Error: Unknown column 'admin_protect' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('disable_ftr', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE disable_ftr = 'ip_version'
+++ Error: Unknown column 'disable_ftr' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('disable_logins', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE disable_logins = 'ip_version'
+++ Error: Unknown column 'disable_logins' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('last_logins_n', '20')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '20' WHERE last_logins_n = 'ip_version'
+++ Error: Unknown column 'last_logins_n' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('edit_notes', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE edit_notes = 'ip_version'
+++ Error: Unknown column 'edit_notes' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('edit_notes_n', '5')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '5' WHERE edit_notes_n = 'ip_version'
+++ Error: Unknown column 'edit_notes_n' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('quote_iterations', '2')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '2' WHERE quote_iterations = 'ip_version'
+++ Error: Unknown column 'quote_iterations' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('page_gen', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE page_gen = 'ip_version'
+++ Error: Unknown column 'page_gen' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('birthday_viewtopic', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE birthday_viewtopic = 'ip_version'
+++ Error: Unknown column 'birthday_viewtopic' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('img_shoutbox', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE img_shoutbox = 'ip_version'
+++ Error: Unknown column 'img_shoutbox' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('split_ga_ann_sticky', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE split_ga_ann_sticky = 'ip_version'
+++ Error: Unknown column 'split_ga_ann_sticky' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('email_notification_html', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE email_notification_html = 'ip_version'
+++ Error: Unknown column 'email_notification_html' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('select_theme', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE select_theme = 'ip_version'
+++ Error: Unknown column 'select_theme' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('select_lang', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE select_lang = 'ip_version'
+++ Error: Unknown column 'select_lang' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('show_icons', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE show_icons = 'ip_version'
+++ Error: Unknown column 'show_icons' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('show_random_quote', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE show_random_quote = 'ip_version'
+++ Error: Unknown column 'show_random_quote' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_portal', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_portal = 'ip_version'
+++ Error: Unknown column 'auth_view_portal' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_forum', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_forum = 'ip_version'
+++ Error: Unknown column 'auth_view_forum' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_viewf', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_viewf = 'ip_version'
+++ Error: Unknown column 'auth_view_viewf' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_viewt', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_viewt = 'ip_version'
+++ Error: Unknown column 'auth_view_viewt' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_faq', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_faq = 'ip_version'
+++ Error: Unknown column 'auth_view_faq' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_memberlist', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_memberlist = 'ip_version'
+++ Error: Unknown column 'auth_view_memberlist' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_group_cp', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_group_cp = 'ip_version'
+++ Error: Unknown column 'auth_view_group_cp' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_profile', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_profile = 'ip_version'
+++ Error: Unknown column 'auth_view_profile' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_search', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_search = 'ip_version'
+++ Error: Unknown column 'auth_view_search' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_album', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_album = 'ip_version'
+++ Error: Unknown column 'auth_view_album' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_links', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_links = 'ip_version'
+++ Error: Unknown column 'auth_view_links' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_calendar', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_calendar = 'ip_version'
+++ Error: Unknown column 'auth_view_calendar' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_attachments', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_attachments = 'ip_version'
+++ Error: Unknown column 'auth_view_attachments' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_download', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_download = 'ip_version'
+++ Error: Unknown column 'auth_view_download' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_kb', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_kb = 'ip_version'
+++ Error: Unknown column 'auth_view_kb' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_ranks', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_ranks = 'ip_version'
+++ Error: Unknown column 'auth_view_ranks' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_statistics', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_statistics = 'ip_version'
+++ Error: Unknown column 'auth_view_statistics' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_recent', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_recent = 'ip_version'
+++ Error: Unknown column 'auth_view_recent' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_referrers', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_referrers = 'ip_version'
+++ Error: Unknown column 'auth_view_referrers' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_rules', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_rules = 'ip_version'
+++ Error: Unknown column 'auth_view_rules' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_site_hist', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_site_hist = 'ip_version'
+++ Error: Unknown column 'auth_view_site_hist' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_shoutbox', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_shoutbox = 'ip_version'
+++ Error: Unknown column 'auth_view_shoutbox' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('auth_view_viewonline', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE auth_view_viewonline = 'ip_version'
+++ Error: Unknown column 'auth_view_viewonline' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('switch_header_banner', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE switch_header_banner = 'ip_version'
+++ Error: Unknown column 'switch_header_banner' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('switch_viewtopic_banner', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE switch_viewtopic_banner = 'ip_version'
+++ Error: Unknown column 'switch_viewtopic_banner' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('header_banner_text', 'Text')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = 'Text' WHERE header_banner_text = 'ip_version'
+++ Error: Unknown column 'header_banner_text' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('viewtopic_banner_text', 'Text')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = 'Text' WHERE viewtopic_banner_text = 'ip_version'
+++ Error: Unknown column 'viewtopic_banner_text' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('visit_counter_switch', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE visit_counter_switch = 'ip_version'
+++ Error: Unknown column 'visit_counter_switch' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('emails_only_to_admins', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE emails_only_to_admins = 'ip_version'
+++ Error: Unknown column 'emails_only_to_admins' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('no_right_click', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE no_right_click = 'ip_version'
+++ Error: Unknown column 'no_right_click' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('gd_version', '2')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '2' WHERE gd_version = 'ip_version'
+++ Error: Unknown column 'gd_version' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('show_img_no_gd', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE show_img_no_gd = 'ip_version'
+++ Error: Unknown column 'show_img_no_gd' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('show_pic_size_on_thumb', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE show_pic_size_on_thumb = 'ip_version'
+++ Error: Unknown column 'show_pic_size_on_thumb' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('thumbnail_posts', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE thumbnail_posts = 'ip_version'
+++ Error: Unknown column 'thumbnail_posts' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('thumbnail_cache', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE thumbnail_cache = 'ip_version'
+++ Error: Unknown column 'thumbnail_cache' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('thumbnail_quality', '85')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '85' WHERE thumbnail_quality = 'ip_version'
+++ Error: Unknown column 'thumbnail_quality' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('thumbnail_size', '400')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '400' WHERE thumbnail_size = 'ip_version'
+++ Error: Unknown column 'thumbnail_size' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('disable_html_guests', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE disable_html_guests = 'ip_version'
+++ Error: Unknown column 'disable_html_guests' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('disable_email_error', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE disable_email_error = 'ip_version'
+++ Error: Unknown column 'disable_email_error' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('switch_header_dropdown', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE switch_header_dropdown = 'ip_version'
+++ Error: Unknown column 'switch_header_dropdown' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('switch_poster_info_topic', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE switch_poster_info_topic = 'ip_version'
+++ Error: Unknown column 'switch_poster_info_topic' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('switch_bbcb_active_content', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE switch_bbcb_active_content = 'ip_version'
+++ Error: Unknown column 'switch_bbcb_active_content' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('thumbnail_lightbox', '1')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '1' WHERE thumbnail_lightbox = 'ip_version'
+++ Error: Unknown column 'thumbnail_lightbox' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('enable_quick_quote', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE enable_quick_quote = 'ip_version'
+++ Error: Unknown column 'enable_quick_quote' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('enable_xs_version_check', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE enable_xs_version_check = 'ip_version'
+++ Error: Unknown column 'enable_xs_version_check' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('allow_all_bbcode', '0')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '0' WHERE allow_all_bbcode = 'ip_version'
+++ Error: Unknown column 'allow_all_bbcode' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('xs_version', '.0.58')
+++ Error: Duplicate entry 'xs_version' for key 1

# UPDATE phpbbXS_config SET config_value = '.0.58' WHERE xs_version = 'ip_version'
+++ Error: Unknown column 'xs_version' in 'where clause'

# INSERT INTO phpbbXS_config (config_name, config_value) VALUES ('xs_version2', '2 (build 058)')
+++ Successfull

# UPDATE phpbbXS_config SET config_value = '2 (build 058)' WHERE xs_version2 = 'ip_version'
+++ Error: Unknown column 'xs_version2' in 'where clause'
[/spoiler]



After having changed the files I got


[quote]
Critical Error

Could not open ca_aphrodite template config file
[/quote]


Any idea of what the problem could be?


Remember that all has been done on a [b][u]fresh installed[/u][/b] XS 0.58b... 


PS: I attached a .zip with an html page of the results in case you need it (greens and reds are more comfortable to read ;) ). Don't worry about the CHMOD, I tryed to chmod all correctly but errors appear the same :(


-----------------------------------
Vortex
Sat 28 Apr, 2007 11:50

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
I did more tests but the result is always the same...  :?


-----------------------------------
andrea75
Sat 28 Apr, 2007 12:45

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
The errors on update are normal. 

About template missing: try to upload def_*.php file from installcontribcleanincludes directory and let me know.


-----------------------------------
Vortex
Sat 28 Apr, 2007 17:20

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="andrea75" post="12979"]The errors on update are normal. 

About template missing: try to upload def_*.php file from installcontribcleanincludes directory and let me know.[/quote]


Thanks for help Andrea,


Now I got

[quote]Critical Error

Could not locate valid language pack[/quote]


-----------------------------------
Vortex
Sat 28 Apr, 2007 17:29

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="Vortex" post="12991"]

Now I got

[quote]Critical Error

Could not locate valid language pack[/quote][/quote]


Solved, I had italian language saved in my profile, I changed it from phpmyadmin ;)


But now I still got 

Critical Error

Could not open ca_aphrodite template config file


I uploaded clean def_ files...


-----------------------------------
andrea75
Sat 28 Apr, 2007 21:02

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="Vortex" post="12992"][quote user="Vortex" post="12991"]

Now I got

[quote]Critical Error

Could not locate valid language pack[/quote][/quote]


Solved, I had italian language saved in my profile, I changed it from phpmyadmin ;)


But now I still got 

Critical Error

Could not open ca_aphrodite template config file


I uploaded clean def_ files...[/quote]

If you can, change the default theme from phpmyadmin, with ID of an existing template (Icyphoenix or MG_Autumn). Other way is install the ca_aphrodite theme... you can find it on downloads section.


-----------------------------------
Vortex
Sat 28 Apr, 2007 21:11

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="andrea75" post="12997"][quote user="Vortex" post="12992"][quote user="Vortex" post="12991"]

Now I got

[quote]Critical Error

Could not locate valid language pack[/quote][/quote]


Solved, I had italian language saved in my profile, I changed it from phpmyadmin ;)


But now I still got 

Critical Error

Could not open ca_aphrodite template config file


I uploaded clean def_ files...[/quote]

If you can, change the default theme from phpmyadmin, with ID of an existing template (Icyphoenix or MG_Autumn). Other way is install the ca_aphrodite theme... you can find it on downloads section.[/quote]


- How can I install a new theme if I can't access the ACP? I don't know how to install it manually.


- In config and users (to my user) tables I set the id of the theme to "0" (which should be Icy) but the error is the same... I'd like to know where does it find "ca_aphrodite"...


-----------------------------------
tiolalu
Sat 28 Apr, 2007 23:18

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
Hi! I had the same problem!!

Upload ca_aphrodite directory from XS to your new forum, so you can enter with too many errors. Enter in ACP, and install the new theme (icy, or autumn), after that put by default, for all users one of the new themes ;) .


-----------------------------------
andrea75
Sun 29 Apr, 2007 08:44

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
Try solution of [b]tiolalu[/b].

You have only to upload the ca_aphrodite folder. The theme was just installed.


-----------------------------------
Vortex
Sun 29 Apr, 2007 15:26

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
Ok, thanks for help ;)


I succeeded to install Icy theme after accessing the ACP with ca_aphrodite. When selecting Icy theme I got


General Error
CBACK CrackerTracker couldn't run the database operation correctly.


Is it me or the update process should be revisited?  :mrviolet:


-----------------------------------
Mighty Gorgon
Tue 01 May, 2007 19:58

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
I think you didn't upgrade your forum properly... I did several tests and all upgrades have been performed correctly. :roll:

If you have a backup, try to roll back to it and start again following these instructions step by step.

[url=docs/readme_english.html#upgrade_xs]Readme


-----------------------------------
tiolalu
Tue 01 May, 2007 21:17

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[b]Mighty Gorgon[/b], why backup .htaccess if you don't use it after ;) :P .


-----------------------------------
Vortex
Tue 01 May, 2007 22:09

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="Mighty Gorgon" post="13174"]I think you didn't upgrade your forum properly... I did several tests and all upgrades have been performed correctly. :roll:

[/quote]


Mighty I tryed even upgrading a vanilla XS...   :cry:


-----------------------------------
Mighty Gorgon
Sun 06 May, 2007 17:43

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
Do you still have problems with this?

Can you please check that all the needed files are there?

Are you sure you are choosing the correct option from the update script?

The cache has been cleaned after the upgrade?

A new installation is working fine?


-----------------------------------
Vortex
Sun 06 May, 2007 19:11

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="Mighty Gorgon" post="13512"]Do you still have problems with this?[/quote]

I tried again and doesn't work. Nor for my actual site nor for a vanilla XS0.58 installation.

[quote]
Can you please check that all the needed files are there?[/quote]

Done, and all seems to be right...

[quote]Are you sure you are choosing the correct option from the update script?[/quote]

Yes, I am... I chose "Upgrade from XS 0.58" and I got many errors ALL updating the config table... you can see it from the file I attached.

I tried two times upgrading from a vanilla XS installation and I got the same errors I got upgrading my actual site... ALL errors are related to the upgrade of the config table... I am not expert so sorry if I dare ask this, but are you sure the upgrade file doesn't have any bug or something? 


[quote]The cache has been cleaned after the upgrade?[/quote]

Yes, I cleared it from FTP because I had problems with the template.


[quote]A new installation is working fine?[/quote]


I tried again both a new installation (of XS, then upgrading) and upgrading from my site. Always the same errors.

I proceeded as the other guys suggested me as you can see in this topic... now I succeded to login and access the acp, after having uploaded the aphrodite XS theme, and changed it from phpMyAdmin... when I got to ACP and try to change the template to Icy I got this error:

CBACK CrackerTracker couldn't run the database operation correctly.



Now I am very busy with examinations... When I got a little time I will start from zero, cloning again my site and upgrading it to the new RC3 ;)


-----------------------------------
Vortex
Tue 22 May, 2007 13:29

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
Ok, I started from the beginning updating my real forum: phpbbXS 0.58b


What I did till now.


1. Backup database. 

2. Backup files. 

3. Created subdomain and database for tests.

4. Imported files and database. 

5. Modified config.php and config table in order to make the forum work on the test subdomain. 

6. Check if the clone forum is correctly running: OK. 


Then, I proceed to the upgrade:

7. Uploaded [b]update_to_ip.php[/b] to my root 

8. Logged in as admin.

9. Launched [b]update_to_ip.php[/b] and chose "Upgrade from phpBBXS 2 0.58"

10. Upgrade done, no errors except for a duplicate entry for the xs version, nothing important I think.

11. Moved album files.

12. Deleted folders and files as suggested by MG.

13. Uploaded new files.

14. Uploaded backup of config.php and def_*

15. CHMODs checked.

Try to access site and [color=red]ERROR: ca_aphrodite not found.[/color]

so

16. Uploaded ca_aphrodite folder.

[color=red]Template->make_filename(): Error - template file not found: portal_page_headerleft.tpl[/color]


I'm stuck here  :cry:


-----------------------------------
kappaponza
Tue 22 May, 2007 13:39

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
i've done the same procedure of Vortex and i've the same problem....

i don't know where i can find the afrodite theme of xs... heeeeeeeeeeeeeeelp


-----------------------------------
TheSteffen
Tue 22 May, 2007 14:47

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="Vortex" post="14637"]Try to access site and [color=red]ERROR: ca_aphrodite not found.[/color]

so

16. Uploaded ca_aphrodite folder.

[color=red]Template->make_filename(): Error - template file not found: portal_page_headerleft.tpl[/color]


I'm stuck here  :cry:[/quote]

Did you use the new aphrodite? [url=http://www.icyphoenix.com/dload.php?action=category&cat_id=12]Link


-----------------------------------
kappaponza
Tue 22 May, 2007 15:44

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="TheSteffen" post="14655"]Did you use the new aphrodite? [url=http://www.icyphoenix.com/dload.php?action=category&cat_id=12]Link[/quote]

i've updated the aprodite theme and now the forum works but..... ALL THE PHOTOS ARE GONE!!! An "X" appears instead of the photo... [url=http://www.pazziperponza.it/Forum/index.php]look... siighhhh :cry:

P.s. on ftp there are all the photos....


-----------------------------------
TheSteffen
Tue 22 May, 2007 16:59

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
@MG: Maybe aphrodite should be also in standard IP release... because of update from XS

@[b]kappaponza[/b]: For the pictures I couldn't help you.  :oops:  Sorry


-----------------------------------
Vortex
Tue 22 May, 2007 17:17

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="TheSteffen" post="14676"]@MG: Maybe aphrodite should be also in standard IP release... because of update from XS
[/quote]


I was about to suggest the same ;)



I uploaded aphrodite for icy... thanks, now I can access ACP ;)


I also installed Icy Phoenix and MG Autumn. But when I go to change theme from board configuration I got:


[quote]CBACK CrackerTracker couldn't run the database operation correctly.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'text/javascript" language="JavaScript" src="http://keyword.pro-advertising.com/a' at line 1

INSERT INTO phpbb_ctracker_backup (`config_name`, `config_value`) VALUES ("header_banner_text", "")

Line : 637
File : class_ct_adminfunctions.php[/quote]



That is my entry for advertising in posts... the error before this was the header banner html formatted, I deleted that and got this... it seems like it gets annoyed by html formatting?


-----------------------------------
kappaponza
Tue 22 May, 2007 17:34

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="TheSteffen" post="14676"]
@[b]kappaponza[/b]: For the pictures I couldn't help you.  :oops:  Sorry[/quote]

wait!!! i need those photos, they are years of memories!!!
Someone else help me, please


-----------------------------------
Vortex
Tue 22 May, 2007 17:41

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
For the moment I solved clearing all banners... I will do further tests and let you know.


-----------------------------------
Vortex
Tue 22 May, 2007 17:51

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
I added a simple 

[code linenumbers=false]<font color="red">test</font>[/code]

in header field, and I got


[code linenumbers=false]CBACK CrackerTracker couldn't run the database operation correctly.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'red">test")' at line 1

INSERT INTO phpbb_ctracker_backup (`config_name`, `config_value`) VALUES ("top_html_block_text", "test")

Line : 637
File : class_ct_adminfunctions.php[/code]



I got this problem when I have some kind of html tag stored in header & banners (config table I think) and try to change theme.


-----------------------------------
fracs
Tue 22 May, 2007 17:52

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
Try to change album path in constants.


-----------------------------------
kappaponza
Tue 22 May, 2007 18:05

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="fracs" post="14690"]Try to change album path in constants.[/quote]

The path seems right. If i insert the complete url of the photo in the browser, it returns this error

[quote]Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, postmaster@pazziperponza.it and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
[/quote]


-----------------------------------
Vortex
Tue 22 May, 2007 20:38

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
I did many tests and definitely think this is a bug.


If I put a [b]"[/b] character in any of the text fields of the headers and banners page (so config table I suppose) I am not able to change theme and got the Ctracker error.


I will post it in bugtracker


-----------------------------------
kappaponza
Tue 22 May, 2007 21:24

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
Only the photos in the folder "files" give the server error and don't show. If i insert the url of the photos in others folders on ftp, they are looked at correctly.


-----------------------------------
Mighty Gorgon
Sat 26 May, 2007 00:10

Re: Error Upgrading From XS0.58 To Icy
-----------------------------------
[quote user="Vortex" post="14738"]I did many tests and definitely think this is a bug.


If I put a [b]"[/b] character in any of the text fields of the headers and banners page (so config table I suppose) I am not able to change theme and got the Ctracker error.


I will post it in bugtracker[/quote]
I don't have this bug... I've tried on two different sites and worked correctly.

[quote user="kappaponza" post="14750"]Only the photos in the folder "files" give the server error and don't show. If i insert the url of the photos in others folders on ftp, they are looked at correctly.[/quote]
Remove htaccess.