Hola amigos, he actualizado mi foro... y se ve ... digamos Actualizado..
solo que al ir a install.php y darle actualizar desde el 27 me da estos errores
Las siguientes consultas SQL no se han podido ejecutar:
Spoiler: [ Esconder ]
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('show_thanks_profile', '0')
+++ Error: Duplicate entry 'show_thanks_profile' for key 1
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('show_thanks_viewtopic', '0')
+++ Error: Duplicate entry 'show_thanks_viewtopic' for key 1
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('index_top_posters', '1')
+++ Error: Duplicate entry 'index_top_posters' for key 1
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('global_disable_upi2db', '0')
+++ Error: Duplicate entry 'global_disable_upi2db' for key 1
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('last_user_id', '2')
+++ Error: Duplicate entry 'last_user_id' for key 1
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('write_errors_log', '0')
+++ Error: Duplicate entry 'write_errors_log' for key 1
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('write_digests_log', '0')
+++ Error: Duplicate entry 'write_digests_log' for key 1
•CREATE TABLE `ip_attachments_stats` ( `attach_id` mediumint(8) unsigned NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `user_ip` VARCHAR(8) NOT NULL DEFAULT '', `user_http_agents` VARCHAR(255) NOT NULL DEFAULT '', `download_time` INT(11) NOT NULL DEFAULT '0', KEY `attach_id` (`attach_id`) )
+++ Error: Table 'ip_attachments_stats' already exists
•ALTER TABLE `ip_pa_download_info` ADD COLUMN `download_time` INT(11) DEFAULT '0' NOT NULL AFTER `user_id`
+++ Error: Duplicate column name 'download_time'
•ALTER TABLE `ip_users` ADD COLUMN `user_download_counter` MEDIUMINT(8) DEFAULT '0' NOT NULL AFTER `user_traffic`
+++ Error: Duplicate column name 'user_download_counter'
•INSERT INTO `ip_dl_config` (config_name, config_value) VALUES ('user_download_limit_flag', '0')
+++ Error: Duplicate entry 'user_download_limit_flag' for key 1
•INSERT INTO `ip_dl_config` (config_name, config_value) VALUES ('user_download_limit', '30')
+++ Error: Duplicate entry 'user_download_limit' for key 1
•ALTER TABLE `ip_cms_nav_menu` ADD COLUMN menu_default MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'
+++ Error: Duplicate column name 'menu_default'
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('no_bump', '0')
+++ Error: Duplicate entry 'no_bump' for key 1
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('link_this_topic', '0')
+++ Error: Duplicate entry 'link_this_topic' for key 1
•ALTER TABLE `ip_cms_layout` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'
+++ Error: Unknown column 'forum_wide' in 'ip_cms_layout'
•ALTER TABLE `ip_cms_layout` ADD `page_nav` TINYINT(1) NOT NULL DEFAULT '1' AFTER `global_blocks`
+++ Error: Duplicate column name 'page_nav'
•ALTER TABLE `ip_cms_layout` ADD `config_vars` TEXT AFTER `page_nav`
+++ Error: Duplicate column name 'config_vars'
•ALTER TABLE `ip_cms_layout_special` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'
+++ Error: Unknown column 'forum_wide' in 'ip_cms_layout_special'
•ALTER TABLE `ip_cms_layout_special` ADD `page_nav` TINYINT(1) NOT NULL DEFAULT '1' AFTER `global_blocks`
+++ Error: Duplicate column name 'page_nav'
•ALTER TABLE `ip_cms_layout_special` ADD `config_vars` TEXT AFTER `page_nav`
+++ Error: Duplicate column name 'config_vars'
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('link_this_topic', '0')
+++ Error: Duplicate entry 'link_this_topic' for key 1
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('cms_style', '0')
+++ Error: Duplicate entry 'cms_style' for key 1
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('show_alpha_bar', '0')
+++ Error: Duplicate entry 'show_alpha_bar' for key 1
•ALTER TABLE `ip_album` ADD COLUMN `pic_size` int(15) unsigned default '0' NOT NULL AFTER `pic_filename`
+++ Error: Duplicate column name 'pic_size'
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('db_log_actions', '1')
+++ Error: Duplicate entry 'db_log_actions' for key 1
•CREATE TABLE `ip_logs` ( `log_id` int(11) unsigned NOT NULL auto_increment, `log_time` varchar(11) NOT NULL, `log_page` varchar(255) NOT NULL default '', `log_user_id` int(10) NOT NULL, `log_action` varchar(60) NOT NULL default '', `log_desc` varchar(255) NOT NULL default '', `log_target` int(10) NOT NULL default '0', PRIMARY KEY (`log_id`) )
+++ Error: Table 'ip_logs' already exists
•ALTER TABLE `ip_ajax_shoutbox` DROP `shout_uid`
+++ Error: Can't DROP 'shout_uid'; check that column/key exists
•ALTER TABLE `ip_cms_blocks` DROP `block_bbcode_uid`
+++ Error: Can't DROP 'block_bbcode_uid'; check that column/key exists
•ALTER TABLE `ip_dl_bug_tracker` DROP `report_uid`
+++ Error: Can't DROP 'report_uid'; check that column/key exists
•ALTER TABLE `ip_dl_comments` DROP `bbcode_uid`
+++ Error: Can't DROP 'bbcode_uid'; check that column/key exists
•ALTER TABLE `ip_downloads` DROP `bbcode_uid`
+++ Error: Can't DROP 'bbcode_uid'; check that column/key exists
•ALTER TABLE `ip_downloads_cat` DROP `bbcode_uid`
+++ Error: Can't DROP 'bbcode_uid'; check that column/key exists
•ALTER TABLE `ip_kb_articles` DROP `bbcode_uid`
+++ Error: Can't DROP 'bbcode_uid'; check that column/key exists
•ALTER TABLE `ip_pa_comments` DROP INDEX `comments_id`
+++ Error: Can't DROP 'comments_id'; check that column/key exists
•ALTER TABLE `ip_pa_comments` DROP INDEX `comment_bbcode_uid`
+++ Error: Can't DROP 'comment_bbcode_uid'; check that column/key exists
•ALTER TABLE `ip_pa_comments` DROP `comment_bbcode_uid`
+++ Error: Can't DROP 'comment_bbcode_uid'; check that column/key exists
•ALTER TABLE `ip_privmsgs_text` DROP `privmsgs_bbcode_uid`
+++ Error: Table 'fivestar_foro.ip_privmsgs_text' doesn't exist
•ALTER TABLE `ip_shout` DROP `shout_bbcode_uid`
+++ Error: Can't DROP 'shout_bbcode_uid'; check that column/key exists
•ALTER TABLE `ip_users` DROP `user_sig_bbcode_uid`
+++ Error: Can't DROP 'user_sig_bbcode_uid'; check that column/key exists
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('show_topic_description', '0')
+++ Error: Duplicate entry 'show_topic_description' for key 1
•ALTER TABLE `ip_users` ADD COLUMN `user_birthday_y` VARCHAR(4) DEFAULT '' NOT NULL AFTER `user_birthday`
+++ Error: Duplicate column name 'user_birthday_y'
•ALTER TABLE `ip_users` ADD COLUMN `user_birthday_m` VARCHAR(2) DEFAULT '' NOT NULL AFTER `user_birthday_y`
+++ Error: Duplicate column name 'user_birthday_m'
•ALTER TABLE `ip_users` ADD COLUMN `user_birthday_d` VARCHAR(2) DEFAULT '' NOT NULL AFTER `user_birthday_m`
+++ Error: Duplicate column name 'user_birthday_d'
•CREATE TABLE `ip_bots` ( bot_id mediumint(8) UNSIGNED NOT NULL auto_increment, bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, bot_name varchar(255) DEFAULT '' NOT NULL, bot_color varchar(255) DEFAULT '' NOT NULL, bot_agent varchar(255) DEFAULT '' NOT NULL, bot_ip varchar(255) DEFAULT '' NOT NULL, bot_last_visit varchar(11) DEFAULT '0' NOT NULL, bot_visit_counter mediumint(8) DEFAULT '0' NOT NULL, PRIMARY KEY (bot_id), KEY bot_name (bot_name), KEY bot_active (bot_active) )
+++ Error: Table 'ip_bots' already exists
•INSERT INTO `ip_config` (config_name, config_value) VALUES ('bots_reg_auth', '0')
+++ Error: Duplicate entry 'bots_reg_auth' for key 1
•DROP TABLE `ip_themes_name`
+++ Error: Unknown table 'ip_themes_name'
•ALTER TABLE `ip_privmsgs_archive` ADD COLUMN `privmsgs_text` text AFTER `privmsgs_subject`
+++ Error: Duplicate column name 'privmsgs_text'
•CREATE TABLE `___categories___` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_main` mediumint(8) unsigned NOT NULL default '0', `cat_main_type` char(1) default NULL, `cat_title` varchar(100) default NULL, `cat_desc` TEXT NOT NULL, `icon` varchar(255) default NULL, `cat_order` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) )
+++ Error: Table '___categories___' already exists
•INSERT INTO `___categories___` SELECT c.cat_id, c.cat_main, c.cat_main_type, c.cat_title, c.cat_desc, c.icon, c.cat_order FROM `ip_categories` c ORDER BY c.cat_id
+++ Error: Duplicate entry '1' for key 1
•RENAME TABLE `ip_categories` TO `_old_ip_categories`
+++ Error: Table '_old_ip_categories' already exists
•RENAME TABLE `___categories___` TO `ip_categories`
+++ Error: Table 'ip_categories' already exists
•ALTER TABLE ip_forums ADD `forum_topic_views` TINYINT(1) NOT NULL DEFAULT '1' AFTER `forum_similar_topics`
+++ Error: Duplicate column name 'forum_topic_views'
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_global_switch', '0')
+++ Error: Duplicate entry 'cron_global_switch' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_lock', '0')
+++ Error: Duplicate entry 'cron_lock' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_queue_interval', '0')
+++ Error: Duplicate entry 'cron_queue_interval' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_queue_last_run', '0')
+++ Error: Duplicate entry 'cron_queue_last_run' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_digests_interval', '0')
+++ Error: Duplicate entry 'cron_digests_interval' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_digests_last_run', '0')
+++ Error: Duplicate entry 'cron_digests_last_run' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_files_interval', '0')
+++ Error: Duplicate entry 'cron_files_interval' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_files_last_run', '0')
+++ Error: Duplicate entry 'cron_files_last_run' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_database_interval', '0')
+++ Error: Duplicate entry 'cron_database_interval' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_database_last_run', '0')
+++ Error: Duplicate entry 'cron_database_last_run' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_cache_interval', '0')
+++ Error: Duplicate entry 'cron_cache_interval' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_cache_last_run', '0')
+++ Error: Duplicate entry 'cron_cache_last_run' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_sql_interval', '0')
+++ Error: Duplicate entry 'cron_sql_interval' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_sql_last_run', '0')
+++ Error: Duplicate entry 'cron_sql_last_run' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_users_interval', '0')
+++ Error: Duplicate entry 'cron_users_interval' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_users_last_run', '0')
+++ Error: Duplicate entry 'cron_users_last_run' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_topics_interval', '0')
+++ Error: Duplicate entry 'cron_topics_interval' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_topics_last_run', '0')
+++ Error: Duplicate entry 'cron_topics_last_run' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_sessions_interval', '0')
+++ Error: Duplicate entry 'cron_sessions_interval' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_sessions_last_run', '0')
+++ Error: Duplicate entry 'cron_sessions_last_run' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_db_count', '0')
+++ Error: Duplicate entry 'cron_db_count' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_db_show_begin_for', '')
+++ Error: Duplicate entry 'cron_db_show_begin_for' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_db_show_not_optimized', '0')
+++ Error: Duplicate entry 'cron_db_show_not_optimized' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('rand_seed_last_update', '0')
+++ Error: Duplicate entry 'rand_seed_last_update' for key 1
•DROP TABLE `ip_optimize_db`
+++ Error: Unknown table 'ip_optimize_db'
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('gsearch_guests', '0')
+++ Error: Duplicate entry 'gsearch_guests' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_glt', '0')
+++ Error: Duplicate entry 'ads_glt' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_glb', '0')
+++ Error: Duplicate entry 'ads_glb' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_glh', '0')
+++ Error: Duplicate entry 'ads_glh' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_glf', '0')
+++ Error: Duplicate entry 'ads_glf' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_fix', '0')
+++ Error: Duplicate entry 'ads_fix' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_fit', '0')
+++ Error: Duplicate entry 'ads_fit' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_fib', '0')
+++ Error: Duplicate entry 'ads_fib' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_vfx', '0')
+++ Error: Duplicate entry 'ads_vfx' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_vft', '0')
+++ Error: Duplicate entry 'ads_vft' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_vfb', '0')
+++ Error: Duplicate entry 'ads_vfb' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_vtx', '0')
+++ Error: Duplicate entry 'ads_vtx' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_vtt', '0')
+++ Error: Duplicate entry 'ads_vtt' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_vtb', '0')
+++ Error: Duplicate entry 'ads_vtb' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_nmt', '0')
+++ Error: Duplicate entry 'ads_nmt' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ads_nmb', '0')
+++ Error: Duplicate entry 'ads_nmb' for key 1
•CREATE TABLE `ip_ads` ( `ad_id` mediumint(8) unsigned NOT NULL auto_increment, `ad_title` varchar(255) NOT NULL, `ad_text` TEXT NOT NULL, `ad_position` varchar(255) NOT NULL, `ad_auth` tinyint(1) NOT NULL default '0', `ad_format` tinyint(1) NOT NULL default '0', `ad_active` tinyint(1) NOT NULL default '0', PRIMARY KEY (`ad_id`) )
+++ Error: Table 'ip_ads' already exists
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('adsense_code', '')
+++ Error: Duplicate entry 'adsense_code' for key 1
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('google_analytics', '')
+++ Error: Duplicate entry 'google_analytics' for key 1
•INSERT INTO ip_config VALUES ('thumbnail_highslide', '1')
+++ Error: Duplicate entry 'thumbnail_highslide' for key 1
•CREATE TABLE ip_registration ( topic_id mediumint(8) unsigned NOT NULL default '0', registration_user_id mediumint(8) NOT NULL default '0', registration_user_ip varchar(8) NOT NULL default '', registration_time int(11) NOT NULL default '0', registration_status tinyint(1) NOT NULL default '0', KEY topic_id (topic_id), KEY registration_user_id (registration_user_id), KEY registration_user_ip (registration_user_ip) )
+++ Error: Table 'ip_registration' already exists
•CREATE TABLE ip_registration_desc ( reg_id mediumint(8) unsigned NOT NULL auto_increment, topic_id mediumint(8) unsigned NOT NULL default '0', reg_active tinyint(1) NOT NULL default '0', reg_max_option1 smallint(5) unsigned NOT NULL default '0', reg_max_option2 smallint(5) unsigned NOT NULL default '0', reg_max_option3 smallint(5) unsigned NOT NULL default '0', reg_start int(11) NOT NULL default '0', reg_length int(11) NOT NULL default '0', PRIMARY KEY (reg_id), KEY `topic_id` (topic_id) )
+++ Error: Table 'ip_registration_desc' already exists
•ALTER TABLE ip_topics ADD topic_reg TINYINT(1) DEFAULT '0' NOT NULL AFTER topic_calendar_duration
+++ Error: Duplicate column name 'topic_reg'
•ALTER TABLE `ip_cms_blocks` ADD `border` TINYINT(1) SET DEFAULT '1' AFTER `border_explain`
+++ 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 'SET DEFAULT '1' AFTER `border_explain`' at line 1
•ALTER TABLE `ip_cms_blocks` ADD `titlebar` TINYINT(1) SET DEFAULT '1' AFTER `border`
+++ 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 'SET DEFAULT '1' AFTER `border`' at line 1
•UPDATE `ip_cms_blocks` SET border= '0' WHERE border_explain= '0,0,0,0'
+++ Error: Unknown column 'border_explain' in 'where clause'
•UPDATE `ip_cms_blocks` SET border= '1' WHERE border_explain= '1,1,1,1'
+++ Error: Unknown column 'border_explain' in 'where clause'
•UPDATE `ip_cms_blocks` SET titlebar= '0' WHERE titlebar_explain= '0,0'
+++ Error: Unknown column 'titlebar_explain' in 'where clause'
•UPDATE `ip_cms_blocks` SET titlebar= '1' WHERE titlebar_explain= '1,1'
+++ Error: Unknown column 'titlebar_explain' in 'where clause'
•ALTER TABLE ip_registration_desc DROP `reg_option1`
+++ Error: Can't DROP 'reg_option1'; check that column/key exists
•ALTER TABLE ip_registration_desc DROP `reg_option2`
+++ Error: Can't DROP 'reg_option2'; check that column/key exists
•ALTER TABLE ip_registration_desc DROP `reg_option3`
+++ Error: Can't DROP 'reg_option3'; check that column/key exists
•ALTER TABLE `ip_cms_layout_special` ADD `page_id` varchar(100) NOT NULL DEFAULT '' AFTER `lsid`
+++ Error: Duplicate column name 'page_id'
•ALTER TABLE `ip_cms_layout_special` ADD `locked` tinyint(1) NOT NULL DEFAULT '1' AFTER `page_id`
+++ Error: Duplicate column name 'locked'
•INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('read_only_forum', '0')
+++ Error: Duplicate entry 'read_only_forum' for key 1
•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
•INSERT INTO ip_config VALUES ('ip_version', '1.3.0.53a')
+++ Error: Duplicate entry 'ip_version' for key 1
Alguien podria explicarme que las genera y como solucionarlas?
Por otro lado.. en la parte superior de mi foro se visualizan las siguientes leyendas..
[
Icy Phoenix Debug] PHP Notice: in file /adm/page_header_admin.php on line 49: ob_start() [ref.outcontrol]: output handler 'ob_gzhandler' conflicts with 'zlib output compression'
en el panel admin y...
[Icy Phoenix Debug] PHP Notice: in file /includes/page_tail.php on line 228: ob_start() [ref.outcontrol]: output handler 'ob_gzhandler' conflicts with 'zlib output compression'
en el FORO
Bueno desde ya muchas gracias.!