CREATE TABLE `ip_tickets_cat` ( ticket_cat_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT, ticket_cat_title VARCHAR(255) NOT NULL DEFAULT '', ticket_cat_des TEXT NOT NULL, ticket_cat_emails TEXT NOT NULL, PRIMARY KEY (ticket_cat_id) )
+++ Error: Table 'ip_tickets_cat' already exists
ALTER TABLE `ip_users` ADD `username_clean` varchar(255) DEFAULT '' NOT NULL AFTER `username`
+++ Error: Duplicate column name 'username_clean'
ALTER TABLE `ip_ina_scores` ADD `user_plays` int(6) default '0' AFTER `score`
+++ Error: Table 'zonadown_pheonix.ip_ina_scores' doesn't exist
ALTER TABLE `ip_ina_scores` ADD `play_time` int(11) default '0' AFTER `user_plays`
+++ Error: Table 'zonadown_pheonix.ip_ina_scores' doesn't exist
UPDATE ip_cms_block_settings` SET `content` = REPLACE(`content`, '\"', '"')
+++ Error: 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 'content` = REPLACE(`content`, '\"', '"')' at line 1
UPDATE ip_cms_block_settings` SET `content` = REPLACE(`content`, "\'", "'")
+++ Error: 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 'content` = REPLACE(`content`, "\'", "'")' at line 1
ALTER TABLE `ip_cms_blocks` CHANGE `block_settings_id` `bs_id` INT(10) UNSIGNED NOT NULL
+++ Error: Unknown column 'block_settings_id' in 'ip_cms_blocks'
INSERT INTO `___sessions___` SELECT s.session_id, s.session_user_id, s.session_start, s.session_time, s.session_ip, s.session_user_agent, s.session_page, s.session_logged_in, 0, 0, '', 1, 0, s.session_admin FROM `ip_sessions` s ORDER BY s.session_id
+++ Error: Column count doesn't match value count at row 1
ALTER TABLE `ip_blogs_posts` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
+++ Error: Table 'zonadown_pheonix.ip_blogs_posts' doesn't exist
ALTER TABLE `ip_guestbooks_posts` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
+++ Error: Table 'zonadown_pheonix.ip_guestbooks_posts' doesn't exist
UPDATE `ip_blogs_posts` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
+++ Error: Table 'zonadown_pheonix.ip_blogs_posts' doesn't exist
UPDATE `ip_guestbooks_posts` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
+++ Error: Table 'zonadown_pheonix.ip_guestbooks_posts' doesn't exist
ALTER TABLE `ip_cms_block_settings` DROP `edit_auth`
+++ Error: Can't DROP 'edit_auth'; check that column/key exists
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 1, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cms_%' AND is_global = 1
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 2, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cms_%' AND auth_option NOT IN ('cms_admin', 'cms_settings', 'cms_permissions', 'cms_menu', 'cms_ads') AND is_global = 1
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 3, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option = 'cms_blocks' AND is_global = 1
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 4, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cmsl_%' AND is_local = 1
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 5, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cmss_%' AND is_local = 1
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 6, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cmsb_%' AND is_local = 1
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 7, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'a_%'
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 8, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'a_%' AND auth_option NOT IN ('a_modules', 'a_aauth', 'a_roles')
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 9, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%'
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 10, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option NOT IN ('m_topicdelete')
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 11, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option IN ('m_', 'm_topicdelete')
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 12, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%'
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 13, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_html')
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 14, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_html')
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 15, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%'
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 16, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option NOT IN ('f_html')
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 17, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option = 'f_'
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 18, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'pl_%'
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 19, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'pl_%' AND auth_option NOT IN ('pl_admin', 'pl_delete')
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 20, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option = 'pl_'
+++ Error: Table 'zonadown_pheonix.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_users (user_id, forum_id, auth_option_id, auth_role_id, auth_setting) SELECT user_id, 0, 0, 7, 0 FROM phpbb_users WHERE user_level = 1
+++ Error: Table 'zonadown_pheonix.phpbb_users' doesn't exist
INSERT INTO ip_config VALUES ('ip_version', '1.3.24.77')
+++ Error: Duplicate entry 'ip_version' for key 'PRIMARY'