Hallo,
I usually not say help me, but I have upgrade my site from phpbb 2.0.21 and FAP 1.4.1 to ip_101111_rc, now.
About the forum all work, except for attached images : I don't know where I have insert the files: in phpbb 2.0.21 I had attach_mod and all files were in "files" folder: have I transfer all files in another folder?
The most important problem is about FAP: I cannot see most images in album index:


and when I click on the link of images I have this error:
Fatal error: Cannot redeclare class bbcode in /web/htdocs/www.oltrelafoto.com/home/forum/includes/bbcode.php on line 114
   

Is there a way or have I return to old configuration?

On form attached files i've solved removing .htaccess in "files" folder.
I've tried removing all .htaccess in album, cache, med_cache and wm_cache folder too, but the problem remain yet

Hello

INFO: the FAP Pic files for IP they are in files/album/
do you upload the pic file in this folder ???
and have you run update_to_ip.php from your root ???

Pepi

pepi wrote: [View Post]

Hello

INFO: the FAP Pic files for IP they are in files/album/
do you upload the pic file in this folder ???
and have you run update_to_ip.php from your root ???

Pepi

Hi pepi, thank for your pretious reply....well, i'me tranfering images from album_mod/upload to files.....but for all images i see only a black image....can you help me again?
I've tried postin a new image...this one has a preview, but when I click on I've the same error:
"Fatal error: Cannot redeclare class bbcode in /web/htdocs/www.oltrelafoto.com/home/forum/includes/bbcode.php on line 114"

pepi wrote: [View Post]

and have you run update_to_ip.php from your root ???

Pepi

Yes, i have.....before tranfering images to new folder...is it important? The forum work correctly...all topics are right...I think so  

Ok, step by step we are resolving...
Now I can see preview image in album index (maybe before tranfering images to "files" folder in ACP I set old functions for thurnbails, now I've switched on "No" and I can see thurnbails.....
Remain "Fatal error: Cannot redeclare class bbcode in /web/htdocs/www.oltrelafoto.com/home/forum/includes/bbcode.php on line 114"

Well, i return to my old config (phpbb 2.0.21 + FAP 1.4.1).
The problem before ("Fatal error: Cannot redeclare class bbcode....") made from a mistake during installation.
From "readme" in docs i read (Upgrade from standard phpBB 2.0.x):
6. Lock your site.
7. Unpack Icy Phoenix package to one folder on your HD.
8. Upload and launch update_to_ip.php (which is in install folder) to the root of your phpbb forum (i.e. http://www.mysite.com/phpbb/update_to_ip.php). Please that if update_to_ip.php is not in the root of your forum, update it won't work correctly.

But, when I lock my site and lanch "update_to_ip.php" i've error: i cannot update if my forum is locked, so I unlock and lanch "update_to_ip.php".
I have these errors (sorry for too long list):

- CREATE TABLE `phpbb_album` ( `pic_id` int(11) unsigned NOT NULL auto_increment, `pic_filename` varchar(255) NOT NULL default '', `pic_thumbnail` varchar(255) NULL default '', `pic_title` varchar(255) NOT NULL default '', `pic_desc` text, `pic_user_id` mediumint(8) NOT NULL default '0', `pic_username` varchar(32) NULL default '', `pic_user_ip` varchar(8) NOT NULL default '0', `pic_time` int(11) unsigned NOT NULL default '0', `pic_cat_id` mediumint(8) unsigned NOT NULL default '1', `pic_view_count` int(11) unsigned NOT NULL default '0', `pic_lock` tinyint(3) NOT NULL default '0', `pic_approval` tinyint(3) NOT NULL default '1', PRIMARY KEY (`pic_id`), KEY `pic_cat_id` (`pic_cat_id`), KEY `pic_user_id` (`pic_user_id`), KEY `pic_time` (`pic_time`) )
+++ Error: Table 'phpbb_album' already exists;

- CREATE TABLE `phpbb_album_cat` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(255) NOT NULL default '', `cat_desc` text, `cat_order` mediumint(8) NOT NULL default '0', `cat_view_level` tinyint(3) NOT NULL default '-1', `cat_upload_level` tinyint(3) NOT NULL default '0', `cat_rate_level` tinyint(3) NOT NULL default '0', `cat_comment_level` tinyint(3) NOT NULL default '0', `cat_edit_level` tinyint(3) NOT NULL default '0', `cat_delete_level` tinyint(3) NOT NULL default '2', `cat_view_groups` varchar(255) NULL default '', `cat_upload_groups` varchar(255) NULL default '', `cat_rate_groups` varchar(255) NULL default '', `cat_comment_groups` varchar(255) NULL default '', `cat_edit_groups` varchar(255) NULL default '', `cat_delete_groups` varchar(255) NULL default '', `cat_moderator_groups` varchar(255) NULL default '', `cat_approval` tinyint(3) NOT NULL default '0', `cat_parent` mediumint(8) unsigned default '0', `cat_user_id` mediumint(8) unsigned default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) )
+++ Error: Table 'phpbb_album_cat' already exists;

- CREATE TABLE `phpbb_album_comment` ( `comment_id` int(11) unsigned NOT NULL auto_increment, `comment_pic_id` int(11) unsigned NOT NULL default '0', `comment_cat_id` int(11) NOT NULL default '0', `comment_user_id` mediumint(8) NOT NULL default '0', `comment_username` varchar(32) default '', `comment_user_ip` varchar(8) NOT NULL default '', `comment_time` int(11) unsigned NOT NULL default '0', `comment_text` text, `comment_edit_time` int(11) unsigned default NULL, `comment_edit_count` smallint(5) unsigned NOT NULL default '0', `comment_edit_user_id` mediumint(8) default NULL, PRIMARY KEY (`comment_id`), KEY `comment_pic_id` (`comment_pic_id`), KEY `comment_user_id` (`comment_user_id`), KEY `comment_user_ip` (`comment_user_ip`), KEY `comment_time` (`comment_time`) )
+++ Error: Table 'phpbb_album_comment' already exists;

- # CREATE TABLE `phpbb_album_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )
+++ Error: Table 'phpbb_album_config' already exists

# CREATE TABLE `phpbb_album_rate` ( `rate_pic_id` int(11) unsigned NOT NULL default '0', `rate_user_id` mediumint(8) NOT NULL default '0', `rate_user_ip` char(8) NOT NULL default '', `rate_point` tinyint(3) unsigned NOT NULL default '0', `rate_hon_point` tinyint(3) NOT NULL default '0', KEY `rate_pic_id` (`rate_pic_id`), KEY `rate_user_id` (`rate_user_id`), KEY `rate_user_ip` (`rate_user_ip`), KEY `rate_point` (`rate_point`) )
+++ Error: Table 'phpbb_album_rate' already exists

# CREATE TABLE phpbb_attachments_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name) )
+++ Error: Table 'phpbb_attachments_config' already exists

# CREATE TABLE phpbb_forbidden_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, extension varchar(100) NOT NULL, PRIMARY KEY (ext_id) )
+++ Error: Table 'phpbb_forbidden_extensions' already exists

# CREATE TABLE phpbb_extension_groups ( group_id mediumint(8) NOT NULL auto_increment, group_name char(20) NOT NULL, cat_id tinyint(2) DEFAULT '0' NOT NULL, allow_group tinyint(1) DEFAULT '0' NOT NULL, download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, upload_icon varchar(100) DEFAULT '', max_filesize int(20) DEFAULT '0' NOT NULL, forum_permissions varchar(255) default '' NOT NULL, PRIMARY KEY group_id (group_id) )
+++ Error: Table 'phpbb_extension_groups' already exists

# CREATE TABLE phpbb_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, extension varchar(100) NOT NULL, comment varchar(100), PRIMARY KEY ext_id (ext_id) )
+++ Error: Table 'phpbb_extensions' already exists

# CREATE TABLE phpbb_attachments_desc ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, physical_filename varchar(255) NOT NULL, real_filename varchar(255) NOT NULL, download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, comment varchar(255), extension varchar(100), mimetype varchar(100), filesize int(20) NOT NULL, filetime int(11) DEFAULT '0' NOT NULL, thumbnail tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY physical_filename (physical_filename(10)), KEY filesize (filesize) )
+++ Error: Table 'phpbb_attachments_desc' already exists

# CREATE TABLE phpbb_attachments ( attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, privmsgs_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id_1 mediumint(8) NOT NULL, user_id_2 mediumint(8) NOT NULL, KEY attach_id_post_id (attach_id, post_id), KEY attach_id_privmsgs_id (attach_id, privmsgs_id), KEY post_id (post_id), KEY privmsgs_id (privmsgs_id) )
+++ Error: Table 'phpbb_attachments' already exists

# CREATE TABLE phpbb_quota_limits ( quota_limit_id mediumint(8) unsigned NOT NULL auto_increment, quota_desc varchar(20) NOT NULL default '', quota_limit bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (quota_limit_id) )
+++ Error: Table 'phpbb_quota_limits' already exists

# CREATE TABLE phpbb_attach_quota ( user_id mediumint(8) unsigned NOT NULL default '0', group_id mediumint(8) unsigned NOT NULL default '0', quota_type smallint(2) NOT NULL default '0', quota_limit_id mediumint(8) unsigned NOT NULL default '0', KEY quota_type (quota_type) )
+++ Error: Table 'phpbb_attach_quota' already exists

# ALTER TABLE phpbb_forums ADD auth_download TINYINT(2) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'auth_download'

# ALTER TABLE phpbb_auth_access ADD auth_download TINYINT(1) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'auth_download'

# ALTER TABLE phpbb_posts ADD post_attachment TINYINT(1) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'post_attachment'

# ALTER TABLE phpbb_topics ADD topic_attachment TINYINT(1) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'topic_attachment'

# ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment TINYINT(1) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'privmsgs_attachment'

# ALTER TABLE phpbb_forums ADD auth_globalannounce TINYINT (2) DEFAULT '3' NOT NULL AFTER auth_announce
+++ Error: Duplicate column name 'auth_globalannounce'

# ALTER TABLE phpbb_auth_access ADD auth_globalannounce TINYINT (1) not null AFTER auth_announce
+++ Error: Duplicate column name 'auth_globalannounce'

ALTER TABLE phpbb_auth_access ADD `auth_mod` tinyint(1) NOT NULL default '0'
+++ Error: Duplicate column name 'auth_mod'

# INSERT INTO `phpbb_album_config` VALUES ('max_pics', '1024')
+++ Error: Duplicate entry 'max_pics' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('user_pics_limit', '-1')
+++ Error: Duplicate entry 'user_pics_limit' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('mod_pics_limit', '-1')
+++ Error: Duplicate entry 'mod_pics_limit' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('max_file_size', '128000')
+++ Error: Duplicate entry 'max_file_size' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('max_width', '1024')
+++ Error: Duplicate entry 'max_width' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('max_height', '768')
+++ Error: Duplicate entry 'max_height' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('rows_per_page', '5')
+++ Error: Duplicate entry 'rows_per_page' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('cols_per_page', '4')
+++ Error: Duplicate entry 'cols_per_page' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('fullpic_popup', '0')
+++ Error: Duplicate entry 'fullpic_popup' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('thumbnail_quality', '75')
+++ Error: Duplicate entry 'thumbnail_quality' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('thumbnail_size', '125')
+++ Error: Duplicate entry 'thumbnail_size' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('thumbnail_cache', '1')
+++ Error: Duplicate entry 'thumbnail_cache' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('sort_method', 'pic_time')
+++ Error: Duplicate entry 'sort_method' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('sort_order', 'DESC')
+++ Error: Duplicate entry 'sort_order' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('jpg_allowed', '1')
+++ Error: Duplicate entry 'jpg_allowed' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('png_allowed', '1')
+++ Error: Duplicate entry 'png_allowed' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('gif_allowed', '1')
+++ Error: Duplicate entry 'gif_allowed' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('desc_length', '512')
+++ Error: Duplicate entry 'desc_length' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('hotlink_prevent', '0')
+++ Error: Duplicate entry 'hotlink_prevent' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('hotlink_allowed', 'mightygorgon.com,icyphoenix.com')
+++ Error: Duplicate entry 'hotlink_allowed' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_gallery', '0')
+++ Error: Duplicate entry 'personal_gallery' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_private', '0')
+++ Error: Duplicate entry 'personal_gallery_private' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_limit', '-1')
+++ Error: Duplicate entry 'personal_gallery_limit' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_view', '-1')
+++ Error: Duplicate entry 'personal_gallery_view' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('rate', '1')
+++ Error: Duplicate entry 'rate' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('rate_scale', '10')
+++ Error: Duplicate entry 'rate_scale' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('comment', '1')
+++ Error: Duplicate entry 'comment' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('gd_version', '2')
+++ Error: Duplicate entry 'gd_version' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('album_version', '.0.54')
+++ Error: Duplicate entry 'album_version' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('fap_version', '1.2.4')
+++ Error: Duplicate entry 'fap_version' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_index_thumb', '0')
+++ Error: Duplicate entry 'show_index_thumb' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_index_total_pics', '1')
+++ Error: Duplicate entry 'show_index_total_pics' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_index_total_comments', '1')
+++ Error: Duplicate entry 'show_index_total_comments' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_index_comments', '0')
+++ Error: Duplicate entry 'show_index_comments' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_index_last_comment', '1')
+++ Error: Duplicate entry 'show_index_last_comment' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic', '1')
+++ Error: Duplicate entry 'show_index_last_pic' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_index_pics', '0')
+++ Error: Duplicate entry 'show_index_pics' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_recent_in_subcats', '1')
+++ Error: Duplicate entry 'show_recent_in_subcats' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_recent_instead_of_nopics', '1')
+++ Error: Duplicate entry 'show_recent_instead_of_nopics' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('line_break_subcats', '1')
+++ Error: Duplicate entry 'line_break_subcats' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_index_subcats', '1')
+++ Error: Duplicate entry 'show_index_subcats' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_allow_gallery_mod', '0')
+++ Error: Duplicate entry 'personal_allow_gallery_mod' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_allow_sub_categories', '0')
+++ Error: Duplicate entry 'personal_allow_sub_categories' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_sub_category_limit', '-1')
+++ Error: Duplicate entry 'personal_sub_category_limit' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_show_subcats_in_index', '0')
+++ Error: Duplicate entry 'personal_show_subcats_in_index' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_in_subcats', '0')
+++ Error: Duplicate entry 'personal_show_recent_in_subcats' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_instead_of_nopics', '0')
+++ Error: Duplicate entry 'personal_show_recent_instead_of_nopics' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_personal_gallery_link', '1')
+++ Error: Duplicate entry 'show_personal_gallery_link' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting', 'cat_order')
+++ Error: Duplicate entry 'album_category_sorting' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting_direction', 'ASC')
+++ Error: Duplicate entry 'album_category_sorting_direction' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('album_debug_mode', '0')
+++ Error: Duplicate entry 'album_debug_mode' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_all_in_personal_gallery', '1')
+++ Error: Duplicate entry 'show_all_in_personal_gallery' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('new_pic_check_interval', '1M')
+++ Error: Duplicate entry 'new_pic_check_interval' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('index_enable_supercells', '0')
+++ Error: Duplicate entry 'index_enable_supercells' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('email_notification', '1')
+++ Error: Duplicate entry 'email_notification' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_download', '2')
+++ Error: Duplicate entry 'show_download' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_slideshow', '1')
+++ Error: Duplicate entry 'show_slideshow' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_pic_size_on_thumb', '1')
+++ Error: Duplicate entry 'show_pic_size_on_thumb' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('hon_rate_users', '0')
+++ Error: Duplicate entry 'hon_rate_users' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('hon_rate_where', '')
+++ Error: Duplicate entry 'hon_rate_where' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('hon_rate_sep', '1')
+++ Error: Duplicate entry 'hon_rate_sep' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('hon_rate_times', '1')
+++ Error: Duplicate entry 'hon_rate_times' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('disp_watermark_at', '3')
+++ Error: Duplicate entry 'disp_watermark_at' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('wut_users', '0')
+++ Error: Duplicate entry 'wut_users' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('use_watermark', '0')
+++ Error: Duplicate entry 'use_watermark' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('rate_type', '2')
+++ Error: Duplicate entry 'rate_type' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('disp_rand', '1')
+++ Error: Duplicate entry 'disp_rand' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('disp_mostv', '1')
+++ Error: Duplicate entry 'disp_mostv' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('disp_high', '1')
+++ Error: Duplicate entry 'disp_high' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('disp_late', '1')
+++ Error: Duplicate entry 'disp_late' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('img_cols', '4')
+++ Error: Duplicate entry 'img_cols' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('img_rows', '1')
+++ Error: Duplicate entry 'img_rows' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('midthumb_use', '1')
+++ Error: Duplicate entry 'midthumb_use' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('midthumb_height', '450')
+++ Error: Duplicate entry 'midthumb_height' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('midthumb_width', '600')
+++ Error: Duplicate entry 'midthumb_width' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('midthumb_cache', '1')
+++ Error: Duplicate entry 'midthumb_cache' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('max_files_to_upload', '1')
+++ Error: Duplicate entry 'max_files_to_upload' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('max_pregenerated_fields', '1')
+++ Error: Duplicate entry 'max_pregenerated_fields' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('dynamic_fields', '1')
+++ Error: Duplicate entry 'dynamic_fields' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('pregenerate_fields', '0')
+++ Error: Duplicate entry 'pregenerate_fields' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('propercase_pic_title', '1')
+++ Error: Duplicate entry 'propercase_pic_title' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic_lv', '0')
+++ Error: Duplicate entry 'show_index_last_pic_lv' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_pics_approval', '0')
+++ Error: Duplicate entry 'personal_pics_approval' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_img_no_gd', '0')
+++ Error: Duplicate entry 'show_img_no_gd' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('dynamic_pic_resampling', '1')
+++ Error: Duplicate entry 'dynamic_pic_resampling' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('max_file_size_resampling', '1024000')
+++ Error: Duplicate entry 'max_file_size_resampling' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('switch_nuffload', '0')
+++ Error: Duplicate entry 'switch_nuffload' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('path_to_bin', './cgi-bin/')
+++ Error: Duplicate entry 'path_to_bin' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('perl_uploader', '1')
+++ Error: Duplicate entry 'perl_uploader' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_progress_bar', '1')
+++ Error: Duplicate entry 'show_progress_bar' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('close_on_finish', '1')
+++ Error: Duplicate entry 'close_on_finish' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('max_pause', '5')
+++ Error: Duplicate entry 'max_pause' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('simple_format', '0')
+++ Error: Duplicate entry 'simple_format' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('multiple_uploads', '1')
+++ Error: Duplicate entry 'multiple_uploads' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('max_uploads', '5')
+++ Error: Duplicate entry 'max_uploads' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('zip_uploads', '1')
+++ Error: Duplicate entry 'zip_uploads' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('resize_pic', '1')
+++ Error: Duplicate entry 'resize_pic' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('resize_width', '600')
+++ Error: Duplicate entry 'resize_width' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('resize_height', '600')
+++ Error: Duplicate entry 'resize_height' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('resize_quality', '70')
+++ Error: Duplicate entry 'resize_quality' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_pics_nav', '1')
+++ Error: Duplicate entry 'show_pics_nav' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_inline_copyright', '0')
+++ Error: Duplicate entry 'show_inline_copyright' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('enable_nuffimage', '1')
+++ Error: Duplicate entry 'enable_nuffimage' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('enable_sepia_bw', '0')
+++ Error: Duplicate entry 'enable_sepia_bw' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('personal_allow_avatar_gallery', '1')
+++ Error: Duplicate entry 'personal_allow_avatar_gallery' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_gif_mid_thumb', '1')
+++ Error: Duplicate entry 'show_gif_mid_thumb' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('slideshow_script', '0')
+++ Error: Duplicate entry 'slideshow_script' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_dir','files')
+++ Error: Duplicate entry 'upload_dir' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_img','images/attach_post.png')
+++ Error: Duplicate entry 'upload_img' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('topic_icon','images/disk_multiple.png')
+++ Error: Duplicate entry 'topic_icon' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('display_order','0')
+++ Error: Duplicate entry 'display_order' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize','262144')
+++ Error: Duplicate entry 'max_filesize' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_quota','52428800')
+++ Error: Duplicate entry 'attachment_quota' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize_pm','262144')
+++ Error: Duplicate entry 'max_filesize_pm' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments','3')
+++ Error: Duplicate entry 'max_attachments' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments_pm','1')
+++ Error: Duplicate entry 'max_attachments_pm' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('disable_mod','0')
+++ Error: Duplicate entry 'disable_mod' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_pm_attach','1')
+++ Error: Duplicate entry 'allow_pm_attach' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_topic_review','0')
+++ Error: Duplicate entry 'attachment_topic_review' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_ftp_upload','0')
+++ Error: Duplicate entry 'allow_ftp_upload' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('show_apcp','0')
+++ Error: Duplicate entry 'show_apcp' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attach_version','2.4.0')
+++ Error: Duplicate entry 'attach_version' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_upload_quota', '0')
+++ Error: Duplicate entry 'default_upload_quota' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_pm_quota', '0')
+++ Error: Duplicate entry 'default_pm_quota' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_server','')
+++ Error: Duplicate entry 'ftp_server' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_path','')
+++ Error: Duplicate entry 'ftp_path' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('download_path','')
+++ Error: Duplicate entry 'download_path' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_user','')
+++ Error: Duplicate entry 'ftp_user' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pass','')
+++ Error: Duplicate entry 'ftp_pass' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pasv_mode','1')
+++ Error: Duplicate entry 'ftp_pasv_mode' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_display_inlined','1')
+++ Error: Duplicate entry 'img_display_inlined' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_width','0')
+++ Error: Duplicate entry 'img_max_width' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_height','0')
+++ Error: Duplicate entry 'img_max_height' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_width','0')
+++ Error: Duplicate entry 'img_link_width' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_height','0')
+++ Error: Duplicate entry 'img_link_height' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_create_thumbnail','0')
+++ Error: Duplicate entry 'img_create_thumbnail' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_min_thumb_filesize','12000')
+++ Error: Duplicate entry 'img_min_thumb_filesize' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_imagick', '')
+++ Error: Duplicate entry 'img_imagick' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('use_gd2','0')
+++ Error: Duplicate entry 'use_gd2' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('wma_autoplay','0')
+++ Error: Duplicate entry 'wma_autoplay' for key 1

# INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('flash_autoplay','0')
+++ Error: Duplicate entry 'flash_autoplay' for key 1

# INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1,'php')
+++ Error: Duplicate entry '1' for key 1

# INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (2,'php3')
+++ Error: Duplicate entry '2' for key 1

# INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (3,'php4')
+++ Error: Duplicate entry '3' for key 1

# INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (4,'phtml')
+++ Error: Duplicate entry '4' for key 1

# INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (5,'pl')
+++ Error: Duplicate entry '5' for key 1

# INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (6,'asp')
+++ Error: Duplicate entry '6' for key 1

# INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (7,'cgi')
+++ Error: Duplicate entry '7' for key 1

# INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (1,'Images',1,1,1,'',0,'')
+++ Error: Duplicate entry '1' for key 1

# INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (2,'Archives',0,1,1,'',0,'')
+++ Error: Duplicate entry '2' for key 1

# INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (3,'Plain Text',0,0,1,'',0,'')
+++ Error: Duplicate entry '3' for key 1

# INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (4,'Documents',0,0,1,'',0,'')
+++ Error: Duplicate entry '4' for key 1

# INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (5,'Real Media',0,0,2,'',0,'')
+++ Error: Duplicate entry '5' for key 1

# INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (6,'Streams',2,0,1,'',0,'')
+++ Error: Duplicate entry '6' for key 1

# INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (7,'Flash Files',3,0,1,'',0,'')
+++ Error: Duplicate entry '7' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (1, 1,'gif', '')
+++ Error: Duplicate entry '1' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (2, 1,'png', '')
+++ Error: Duplicate entry '2' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (3, 1,'jpeg', '')
+++ Error: Duplicate entry '3' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (4, 1,'jpg', '')
+++ Error: Duplicate entry '4' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (5, 1,'tif', '')
+++ Error: Duplicate entry '5' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (6, 1,'tga', '')
+++ Error: Duplicate entry '6' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (7, 2,'gtar', '')
+++ Error: Duplicate entry '7' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (8, 2,'gz', '')
+++ Error: Duplicate entry '8' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (9, 2,'tar', '')
+++ Error: Duplicate entry '9' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (10, 2,'zip', '')
+++ Error: Duplicate entry '10' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (11, 2,'rar', '')
+++ Error: Duplicate entry '11' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (12, 2,'ace', '')
+++ Error: Duplicate entry '12' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (13, 3,'txt', '')
+++ Error: Duplicate entry '13' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (14, 3,'c', '')
+++ Error: Duplicate entry '14' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (15, 3,'h', '')
+++ Error: Duplicate entry '15' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (16, 3,'cpp', '')
+++ Error: Duplicate entry '16' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (17, 3,'hpp', '')
+++ Error: Duplicate entry '17' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (18, 3,'diz', '')
+++ Error: Duplicate entry '18' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (19, 4,'xls', '')
+++ Error: Duplicate entry '19' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (20, 4,'doc', '')
+++ Error: Duplicate entry '20' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (21, 4,'dot', '')
+++ Error: Duplicate entry '21' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (22, 4,'pdf', '')
+++ Error: Duplicate entry '22' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (23, 4,'ai', '')
+++ Error: Duplicate entry '23' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (24, 4,'ps', '')
+++ Error: Duplicate entry '24' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (25, 4,'ppt', '')
+++ Error: Duplicate entry '25' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (26, 5,'rm', '')
+++ Error: Duplicate entry '26' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (27, 6,'wma', '')
+++ Error: Duplicate entry '27' for key 1

# INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (28, 7,'swf', '')
+++ Error: Duplicate entry '28' for key 1

# INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144)
+++ Error: Duplicate entry '1' for key 1

# INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152)
+++ Error: Duplicate entry '2' for key 1

# INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880)
+++ Error: Duplicate entry '3' for key 1


# INSERT INTO `phpbb_config` VALUES ('calendar_header_cells_over', '0')
+++ Error: Duplicate entry 'calendar_header_cells_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_week_start', '1')
+++ Error: Duplicate entry 'calendar_week_start' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_week_start_over', '0')
+++ Error: Duplicate entry 'calendar_week_start_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_title_length', '30')
+++ Error: Duplicate entry 'calendar_title_length' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_text_length', '200')
+++ Error: Duplicate entry 'calendar_text_length' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_nb_row', '5')
+++ Error: Duplicate entry 'calendar_nb_row' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_nb_row_over', '0')
+++ Error: Duplicate entry 'calendar_nb_row_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_birthday', '1')
+++ Error: Duplicate entry 'calendar_birthday' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_birthday_over', '0')
+++ Error: Duplicate entry 'calendar_birthday_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_forum', '1')
+++ Error: Duplicate entry 'calendar_forum' for key 1

# INSERT INTO `phpbb_config` VALUES ('calendar_forum_over', '0')
+++ Error: Duplicate entry 'calendar_forum_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('sub_forum', '1')
+++ Error: Duplicate entry 'sub_forum' for key 1

# INSERT INTO `phpbb_config` VALUES ('sub_forum_over', '0')
+++ Error: Duplicate entry 'sub_forum_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('split_cat', '1')
+++ Error: Duplicate entry 'split_cat' for key 1

# INSERT INTO `phpbb_config` VALUES ('split_cat_over', '0')
+++ Error: Duplicate entry 'split_cat_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('last_topic_title', '1')
+++ Error: Duplicate entry 'last_topic_title' for key 1

# INSERT INTO `phpbb_config` VALUES ('last_topic_title_over', '0')
+++ Error: Duplicate entry 'last_topic_title_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('last_topic_title_length', '24')
+++ Error: Duplicate entry 'last_topic_title_length' for key 1

# INSERT INTO `phpbb_config` VALUES ('sub_level_links', '2')
+++ Error: Duplicate entry 'sub_level_links' for key 1

# INSERT INTO `phpbb_config` VALUES ('sub_level_links_over', '0')
+++ Error: Duplicate entry 'sub_level_links_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('display_viewonline', '2')
+++ Error: Duplicate entry 'display_viewonline' for key 1

# INSERT INTO `phpbb_config` VALUES ('display_viewonline_over', '0')
+++ Error: Duplicate entry 'display_viewonline_over' for key 1

# INSERT INTO `phpbb_config` VALUES ('max_posts', '2')
+++ Error: Duplicate entry 'max_posts' for key 1

# INSERT INTO `phpbb_config` VALUES ('max_topics', '1')
+++ Error: Duplicate entry 'max_topics' for key 1

# INSERT INTO `phpbb_config` VALUES ('max_users', '2')
+++ Error: Duplicate entry 'max_users' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_auto_compile', '1')
+++ Error: Duplicate entry 'xs_auto_compile' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_auto_recompile', '1')
+++ Error: Duplicate entry 'xs_auto_recompile' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_use_cache', '1')
+++ Error: Duplicate entry 'xs_use_cache' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_php', 'php')
+++ Error: Duplicate entry 'xs_php' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_def_template', 'mg_themes')
+++ Error: Duplicate entry 'xs_def_template' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_check_switches', '1')
+++ Error: Duplicate entry 'xs_check_switches' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_warn_includes', '1')
+++ Error: Duplicate entry 'xs_warn_includes' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_add_comments', '0')
+++ Error: Duplicate entry 'xs_add_comments' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_ftp_host', '')
+++ Error: Duplicate entry 'xs_ftp_host' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_ftp_login', '')
+++ Error: Duplicate entry 'xs_ftp_login' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_ftp_path', '')
+++ Error: Duplicate entry 'xs_ftp_path' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_downloads_count', '0')
+++ Error: Duplicate entry 'xs_downloads_count' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_downloads_default', '0')
+++ Error: Duplicate entry 'xs_downloads_default' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_template_time', '1132930673')
+++ Error: Duplicate entry 'xs_template_time' for key 1

# INSERT INTO `phpbb_config` VALUES ('xs_version', '7')
+++ Error: Duplicate entry 'xs_version' for key 1

ALTER TABLE `phpbb_search_results` ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'search_time'


# INSERT INTO phpbb_config VALUES ('search_min_chars', '3')
+++ Error: Duplicate entry 'search_min_chars' for key 1

# DROP TABLE phpbb_flags
+++ Error: Unknown table 'phpbb_flags'

# DROP TABLE `phpbb_ctrack`
+++ Error: Unknown table 'phpbb_ctrack'

# DROP TABLE `phpbb_ct_filter`
+++ Error: Unknown table 'phpbb_ct_filter'

# DROP TABLE `phpbb_ct_viskey`
+++ Successfull

# ALTER TABLE `phpbb_users` DROP `ct_logintry`
+++ Successfull

# ALTER TABLE `phpbb_users` DROP `ct_unsucclogin`
+++ Successfull

# ALTER TABLE `phpbb_users` DROP `ct_pwreset`
+++ Successfull

# ALTER TABLE `phpbb_users` DROP `ct_mailcount`
+++ Successfull

# ALTER TABLE `phpbb_users` DROP `ct_postcount`
+++ Error: Can't DROP 'ct_postcount'; check that column/key exists

# ALTER TABLE `phpbb_users` DROP `ct_posttime`
+++ Error: Can't DROP 'ct_posttime'; check that column/key exists

# ALTER TABLE `phpbb_users` DROP `ct_searchcount`
+++ Error: Can't DROP 'ct_searchcount'; check that column/key exists

# ALTER TABLE `phpbb_users` DROP `ct_searchtime`
+++ Error: Can't DROP 'ct_searchtime'; check that column/key exists

# ALTER TABLE `phpbb_users` ADD `ct_search_time` INT( 11 ) NULL DEFAULT 1 AFTER `user_newpasswd`;
+++ Error: Duplicate column name 'ct_search_time'

# ALTER TABLE `phpbb_users` ADD `ct_search_count` MEDIUMINT( 8 ) NULL DEFAULT 1 AFTER `ct_search_time`;
+++ Error: Duplicate column name 'ct_search_count'

# ALTER TABLE `phpbb_users` ADD `ct_last_mail` INT( 11 ) NULL DEFAULT 1 AFTER `ct_search_count`;
+++ Error: Duplicate column name 'ct_last_mail'

# ALTER TABLE `phpbb_users` ADD `ct_last_post` INT( 11 ) NULL DEFAULT 1 AFTER `ct_last_mail`;
+++ Error: Duplicate column name 'ct_last_post'

# ALTER TABLE `phpbb_users` ADD `ct_post_counter` MEDIUMINT( 8 ) NULL DEFAULT 1 AFTER `ct_last_post`;
+++ Error: Duplicate column name 'ct_post_counter'

# ALTER TABLE `phpbb_users` ADD `ct_last_pw_reset` INT( 11 ) NULL DEFAULT 1 AFTER `ct_post_counter`;
+++ Error: Duplicate column name 'ct_last_pw_reset'

# ALTER TABLE `phpbb_users` ADD `ct_enable_ip_warn` TINYINT( 1 ) NULL DEFAULT 1 AFTER `ct_last_pw_reset`;
+++ Error: Duplicate column name 'ct_enable_ip_warn'

# ALTER TABLE `phpbb_users` ADD `ct_last_used_ip` VARCHAR( 16 ) NULL DEFAULT '0.0.0.0' AFTER `ct_enable_ip_warn`;
+++ Error: Duplicate column name 'ct_last_used_ip'

# ALTER TABLE `phpbb_users` ADD `ct_last_ip` VARCHAR( 16 ) NULL DEFAULT '0.0.0.0' AFTER `ct_last_used_ip`;
+++ Error: Duplicate column name 'ct_last_ip'

# ALTER TABLE `phpbb_users` ADD `ct_login_count` MEDIUMINT( 8 ) NULL DEFAULT 1 AFTER `ct_last_used_ip`;
+++ Error: Duplicate column name 'ct_login_count'

# ALTER TABLE `phpbb_users` ADD `ct_login_vconfirm` TINYINT( 1 ) NULL DEFAULT 0 AFTER `ct_login_count`;
+++ Error: Duplicate column name 'ct_login_vconfirm'

# ALTER TABLE `phpbb_users` ADD `ct_last_pw_change` INT( 11 ) NULL DEFAULT 1 AFTER `ct_login_vconfirm`;
+++ Error: Duplicate column name 'ct_last_pw_change'

# ALTER TABLE `phpbb_users` ADD `ct_global_msg_read` TINYINT( 1 ) NULL DEFAULT 0 AFTER `ct_last_pw_change`;
+++ Error: Duplicate column name 'ct_global_msg_read'

# ALTER TABLE `phpbb_users` ADD `ct_miserable_user` TINYINT( 1 ) NULL DEFAULT 0 AFTER `ct_global_msg_read`;
+++ Error: Duplicate column name 'ct_miserable_user'

# CREATE TABLE `phpbb_ctracker_config` ( `ct_config_name` varchar(255) NOT NULL, `ct_config_value` varchar(255) NOT NULL, PRIMARY KEY (`ct_config_name`) );
+++ Error: Table 'phpbb_ctracker_config' already exists

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('ipblock_enabled', '1');
+++ Error: Duplicate entry 'ipblock_enabled' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('ipblock_logsize', '100');
+++ Error: Duplicate entry 'ipblock_logsize' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('auto_recovery', '1');
+++ Error: Duplicate entry 'auto_recovery' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('vconfirm_guest', '1');
+++ Error: Duplicate entry 'vconfirm_guest' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('autoban_mails', '1');
+++ Error: Duplicate entry 'autoban_mails' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('detect_misconfiguration', '1');
+++ Error: Duplicate entry 'detect_misconfiguration' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_time_guest', '30');
+++ Error: Duplicate entry 'search_time_guest' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_time_user', '20');
+++ Error: Duplicate entry 'search_time_user' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_count_guest', '1');
+++ Error: Duplicate entry 'search_count_guest' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_count_user', '4');
+++ Error: Duplicate entry 'search_count_user' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('massmail_protection', '1');
+++ Error: Duplicate entry 'massmail_protection' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_protection', '1');
+++ Error: Duplicate entry 'reg_protection' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_blocktime', '30');
+++ Error: Duplicate entry 'reg_blocktime' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_lastip', '0.0.0.0');
+++ Error: Duplicate entry 'reg_lastip' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pwreset_time', '20');
+++ Error: Duplicate entry 'pwreset_time' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('massmail_time', '20');
+++ Error: Duplicate entry 'massmail_time' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spammer_time', '30');
+++ Error: Duplicate entry 'spammer_time' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spammer_postcount', '4');
+++ Error: Duplicate entry 'spammer_postcount' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spammer_blockmode', '1');
+++ Error: Duplicate entry 'spammer_blockmode' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('loginfeature', '1');
+++ Error: Duplicate entry 'loginfeature' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_reset_feature', '1');
+++ Error: Duplicate entry 'pw_reset_feature' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_last_reg', '1155944976');
+++ Error: Duplicate entry 'reg_last_reg' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('login_history', '1');
+++ Error: Duplicate entry 'login_history' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('login_history_count', '10');
+++ Error: Duplicate entry 'login_history_count' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('login_ip_check', '1');
+++ Error: Duplicate entry 'login_ip_check' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_validity', '30');
+++ Error: Duplicate entry 'pw_validity' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_complex_min', '4');
+++ Error: Duplicate entry 'pw_complex_min' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_complex_mode', '1');
+++ Error: Duplicate entry 'pw_complex_mode' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_control', '0');
+++ Error: Duplicate entry 'pw_control' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_complex', '0');
+++ Error: Duplicate entry 'pw_complex' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('last_file_scan', '1156000091');
+++ Error: Duplicate entry 'last_file_scan' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('last_checksum_scan', '1156000082');
+++ Error: Duplicate entry 'last_checksum_scan' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('logsize_logins', '100');
+++ Error: Duplicate entry 'logsize_logins' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('logsize_spammer', '100');
+++ Error: Duplicate entry 'logsize_spammer' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_ip_scan', '1');
+++ Error: Duplicate entry 'reg_ip_scan' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('global_message', 'Hello world!');
+++ Error: Duplicate entry 'global_message' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('global_message_type', '1');
+++ Error: Duplicate entry 'global_message_type' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('logincount', '2');
+++ Error: Duplicate entry 'logincount' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_feature_enabled', '1');
+++ Error: Duplicate entry 'search_feature_enabled' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spam_attack_boost', '1');
+++ Error: Duplicate entry 'spam_attack_boost' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spam_keyword_det', '1');
+++ Error: Duplicate entry 'spam_keyword_det' for key 1

# INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('footer_layout', '6');
+++ Error: Duplicate entry 'footer_layout' for key 1

# CREATE TABLE `phpbb_ctracker_filechk` ( `filepath` text, `hash` varchar(32) default NULL );
+++ Error: Table 'phpbb_ctracker_filechk' already exists

# CREATE TABLE `phpbb_ctracker_filescanner` ( `id` smallint(5) NOT NULL, `filepath` text, `safety` smallint(1) NOT NULL default '0', PRIMARY KEY (`id`) );
+++ Error: Table 'phpbb_ctracker_filescanner' already exists

# CREATE TABLE `phpbb_ctracker_ipblocker` ( `id` mediumint(8) unsigned NOT NULL, `ct_blocker_value` varchar(250) default NULL, PRIMARY KEY (`id`) );
+++ Error: Table 'phpbb_ctracker_ipblocker' already exists

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (1, '*WebStripper*');
+++ Error: Duplicate entry '1' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (2, '*NetMechanic*');
+++ Error: Duplicate entry '2' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (4, '*EmailCollector*');
+++ Error: Duplicate entry '4' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (5, '*EmailSiphon*');
+++ Error: Duplicate entry '5' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (6, '*WebBandit*');
+++ Error: Duplicate entry '6' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (7, '*EmailWolf*');
+++ Error: Duplicate entry '7' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (8, '*ExtractorPro*');
+++ Error: Duplicate entry '8' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (9, '*SiteSnagger*');
+++ Error: Duplicate entry '9' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (10, '*CheeseBot*');
+++ Error: Duplicate entry '10' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (11, '*ia_archiver*');
+++ Error: Duplicate entry '11' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (12, '*Website Quester*');
+++ Error: Duplicate entry '12' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (13, '*WebZip*');
+++ Error: Duplicate entry '13' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (14, '*moget*');
+++ Error: Duplicate entry '14' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (15, '*WebSauger*');
+++ Error: Duplicate entry '15' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (16, '*WebCopier*');
+++ Error: Duplicate entry '16' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (17, '*WWW-Collector*');
+++ Error: Duplicate entry '17' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (18, '*InfoNaviRobot*');
+++ Error: Duplicate entry '18' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (19, '*Harvest*');
+++ Error: Duplicate entry '19' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (20, '*Bullseye*');
+++ Error: Duplicate entry '20' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (21, '*LinkWalker*');
+++ Error: Duplicate entry '21' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (22, '*LinkextractorPro*');
+++ Error: Duplicate entry '22' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (23, '*Proxy*');
+++ Error: Duplicate entry '23' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (24, '*BlowFish*');
+++ Error: Duplicate entry '24' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (25, '*WebEnhancer*');
+++ Error: Duplicate entry '25' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (26, '*TightTwatBot*');
+++ Error: Duplicate entry '26' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (27, '*LinkScan*');
+++ Error: Duplicate entry '27' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (28, '*WebDownloader*');
+++ Error: Duplicate entry '28' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (29, 'lwp');
+++ Error: Duplicate entry '29' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (30, '*BruteForce*');
+++ Error: Duplicate entry '30' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (31, 'lwp-*');
+++ Error: Duplicate entry '31' for key 1

# INSERT INTO `phpbb_ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (32, '*anonym*');
+++ Error: Duplicate entry '32' for key 1

# CREATE TABLE `phpbb_ctracker_loginhistory` ( `ct_user_id` int(10) default NULL, `ct_login_ip` varchar(16) default NULL, `ct_login_time` int(11) NOT NULL default '0' );
+++ Error: Table 'phpbb_ctracker_loginhistory' already exists

# INSERT INTO `phpbb_album_config` VALUES ('quick_thumbs', '0');
+++ Error: Duplicate entry 'quick_thumbs' for key 1

# ALTER TABLE `phpbb_album_cat` ADD `cat_wm` TEXT AFTER `cat_desc`;
+++ Error: Duplicate column name 'cat_wm'

# NSERT INTO `phpbb_album_config` VALUES ('set_memory', '0');
+++ Error: Duplicate entry 'set_memory' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('lb_preview', '0');
+++ Error: Duplicate entry 'lb_preview' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('use_old_pics_gen', '0');
+++ Error: Duplicate entry 'use_old_pics_gen' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_last_comments', '0');
+++ Error: Duplicate entry 'show_last_comments' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('enable_mooshow', '0');
+++ Error: Duplicate entry 'enable_mooshow' for key 1

# ROP TABLE `phpbb_block_position`
+++ Error: Unknown table 'phpbb_block_position'

# DROP TABLE `phpbb_block_variable`
+++ Error: Unknown table 'phpbb_block_variable'

# DROP TABLE `phpbb_blocks`
+++ Error: Unknown table 'phpbb_blocks'

# DROP TABLE `phpbb_layout`
+++ Error: Unknown table 'phpbb_layout'

# DROP TABLE `phpbb_portal_config`
+++ Error: Unknown table 'phpbb_portal_config'

# NSERT INTO phpbb_config VALUES ('shoutbox_floodinterval', '3')
+++ Error: Duplicate entry 'shoutbox_floodinterval' for key 1

# INSERT INTO phpbb_config VALUES ('display_shouts', '20')
+++ Error: Duplicate entry 'display_shouts' for key 1

# INSERT INTO phpbb_config VALUES ('stored_shouts', '1000')
+++ Error: Duplicate entry 'stored_shouts' for key 1

# INSERT INTO phpbb_config VALUES ('shoutbox_refreshtime', '5000')
+++ Error: Duplicate entry 'shoutbox_refreshtime' for key 1

# INSERT INTO phpbb_config VALUES ('shout_allow_guest', '0')
+++ Error: Duplicate entry 'shout_allow_guest' for key 1

# NSERT INTO `phpbb_album_config` VALUES ('invert_nav_arrows', '0');
+++ Error: Duplicate entry 'invert_nav_arrows' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_otf_link', '1');
+++ Error: Duplicate entry 'show_otf_link' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_all_pics_link', '1');
+++ Error: Duplicate entry 'show_all_pics_link' for key 1

# INSERT INTO `phpbb_album_config` VALUES ('show_personal_galleries_link', '1');
+++ Error: Duplicate entry 'show_personal_galleries_link' for key 1

# INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_calendar_box_index', '0')
+++ Error: Duplicate entry 'show_calendar_box_index' for key 1

# DROP TABLE `phpbb_config_mg`
+++ Error: Unknown table 'phpbb_config_mg'