Hi
I have just installed 1.1.0 and all seemed ok, but when I ran the install.php it seems that it has already run but not installed
I got the following error saying that the database tables already exist and there are duplicate entries etc.
Will I have to remove all these tables and try again or is there some way I can work round it?
Thanks in advance for any help.
Keith
Classifieds MOD
PHP Version: 5.2.9
DBMS: MySQL 4.1.22-log
phpBB3 Version: 3.0.9
Adding a new database table: phpbb_classifieds
ERROR: Database table phpbb_classifieds already exists.
Adding a new database table: phpbb_classifieds_categories
ERROR: Database table phpbb_classifieds_categories already exists.
Adding a new database table: phpbb_classifieds_comments
ERROR: Database table phpbb_classifieds_comments already exists.
Inserting data in the phpbb_classifieds_categories database table.
SQL ERROR Duplicate entry '1' for key 1
Adding new config variable: enable_classifieds
ERROR: Config variable enable_classifieds already exists.
Adding new config variable: disable_message
ERROR: Config variable disable_message already exists.
Adding new config variable: number_ads
ERROR: Config variable number_ads already exists.
Adding new config variable: number_expire
ERROR: Config variable number_expire already exists.
Adding new config variable: email_ad
ERROR: Config variable email_ad already exists.
Adding new config variable: email_expire
ERROR: Config variable email_expire already exists.
Adding new config variable: sold_color
ERROR: Config variable sold_color already exists.
Adding new config variable: closed_color
ERROR: Config variable closed_color already exists.
Adding new config variable: allow_comments
ERROR: Config variable allow_comments already exists.
Adding new config variable: allow_upload
ERROR: Config variable allow_upload already exists.
Adding new config variable: display_ads_on_index
ERROR: Config variable display_ads_on_index already exists.
Adding new config variable: ad_num_display_on_index
ERROR: Config variable ad_num_display_on_index already exists.
Adding new config variable: recent_ads_place
ERROR: Config variable recent_ads_place already exists.
Adding new config variable: allow_addthis_button
ERROR: Config variable allow_addthis_button already exists.
Adding new config variable: required_posts_to_create
ERROR: Config variable required_posts_to_create already exists.
Adding new config variable: required_posts_to_view
ERROR: Config variable required_posts_to_view already exists.
Adding a new column named reported to table phpbb_classifieds
ERROR: The column reported already exists on table phpbb_classifieds.
Adding a new column named report_text to table phpbb_classifieds
SQL ERROR Column length too big for column 'report_text' (max = 255); use BLOB or TEXT instead
Adding a new column named reported_by to table phpbb_classifieds
ERROR: The column reported_by already exists on table phpbb_classifieds.
Adding new config variable: enable_watch_cat
ERROR: Config variable enable_watch_cat already exists.
Adding new config variable: rand_ad_num_display_on_index
ERROR: Config variable rand_ad_num_display_on_index already exists.
Adding new config variable: display_rand_ads_on_index
ERROR: Config variable display_rand_ads_on_index already exists.
Adding new config variable: rand_ads_place
ERROR: Config variable rand_ads_place already exists.
Adding new config variable: rand_miniblock_place
ERROR: Config variable rand_miniblock_place already exists.
Adding new config variable: display_rand_miniblock
ERROR: Config variable display_rand_miniblock already exists.
Adding new config variable: rand_miniblock_num_ads
ERROR: Config variable rand_miniblock_num_ads already exists.
Adding new config variable: advertisers_block_place
ERROR: Config variable advertisers_block_place already exists.
Adding new config variable: display_advertisers_ads
ERROR: Config variable display_advertisers_ads already exists.
Adding new config variable: advertisers_ads_num
ERROR: Config variable advertisers_ads_num already exists.
Adding a new database table: phpbb_classifieds_cat_watch
ERROR: Database table phpbb_classifieds_cat_watch already exists.
Adding a new column named short_desc to table phpbb_classifieds
ERROR: The column short_desc already exists on table phpbb_classifieds.
Adding new config variable: hot_block_place
ERROR: Config variable hot_block_place already exists.
Adding new config variable: display_hot_ads
ERROR: Config variable display_hot_ads already exists.
Adding new config variable: hot_ads_num
ERROR: Config variable hot_ads_num already exists.
Adding new config variable: allow_users_set_expiration
ERROR: Config variable allow_users_set_expiration already exists.
Adding new config variable: min_expiration_by_user
ERROR: Config variable min_expiration_by_user already exists.
Adding new config variable: max_expiration_by_user
ERROR: Config variable max_expiration_by_user already exists.
Adding a new database table: phpbb_classifieds_images
ERROR: Database table phpbb_classifieds_images already exists.
Adding a new column named days_active to table phpbb_classifieds
ERROR: The column days_active already exists on table phpbb_classifieds.
Adding new config variable: mandatory_phone
ERROR: Config variable mandatory_phone already exists.
Adding new config variable: allow_classifieds_feeds
ERROR: Config variable allow_classifieds_feeds already exists.
Adding new config variable: number_ad_feeds
ERROR: Config variable number_ad_feeds already exists.
Adding new config variable: default_currency
ERROR: Config variable default_currency already exists.
Adding a new database table: phpbb_classifieds_rules
ERROR: Database table phpbb_classifieds_rules already exists.
Removing the column named allow_comments from table phpbb_classifieds
ERROR: The column allow_comments does not exist on table phpbb_classifieds.
Removing the column named enable_bbcode from table phpbb_classifieds
ERROR: The column enable_bbcode does not exist on table phpbb_classifieds.
Removing the column named enable_magic_url from table phpbb_classifieds
ERROR: The column enable_magic_url does not exist on table phpbb_classifieds.
Removing the column named enable_smilies from table phpbb_classifieds
ERROR: The column enable_smilies does not exist on table phpbb_classifieds.
Removing the column named enable_bbcode from table phpbb_classifieds_comments
ERROR: The column enable_bbcode does not exist on table phpbb_classifieds_comments.
Removing the column named enable_magic_url from table phpbb_classifieds_comments
ERROR: The column enable_magic_url does not exist on table phpbb_classifieds_comments.
Removing the column named enable_smilies from table phpbb_classifieds_comments
ERROR: The column enable_smilies does not exist on table phpbb_classifieds_comments.
Adding new config variable: last_check_expired
ERROR: Config variable last_check_expired already exists.
Adding a new database table: phpbb_classifieds_currency
ERROR: Database table phpbb_classifieds_currency already exists.
Adding a new database table: phpbb_classifieds_prefixes
ERROR: Database table phpbb_classifieds_prefixes already exists.
Adding a new database table: phpbb_classifieds_locations
ERROR: Database table phpbb_classifieds_locations already exists.
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '1' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '2' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '3' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '4' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '5' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '6' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '7' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '8' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '9' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '10' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '11' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '12' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '13' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '14' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '15' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '16' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '17' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '18' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '19' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '20' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '21' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '22' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '23' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '24' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '25' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '26' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '27' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '28' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '29' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '30' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '31' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '32' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '33' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '34' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '35' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '36' for key 1
Inserting data in the phpbb_classifieds_currency database table.
SQL ERROR Duplicate entry '37' for key 1
Inserting data in the phpbb_classifieds_prefixes database table.
SQL ERROR Duplicate entry '1' for key 1
Inserting data in the phpbb_classifieds_prefixes database table.
SQL ERROR Duplicate entry '2' for key 1
Inserting data in the phpbb_classifieds_prefixes database table.
SQL ERROR Duplicate entry '3' for key 1
Inserting data in the phpbb_classifieds_prefixes database table.
SQL ERROR Duplicate entry '4' for key 1
Inserting data in the phpbb_classifieds_prefixes database table.
SQL ERROR Duplicate entry '5' for key 1
Adding a new column named temp_id to table phpbb_classifieds_images
ERROR: The column temp_id already exists on table phpbb_classifieds_images.
Adding a new column named ad_prefix_id to table phpbb_classifieds
ERROR: The column ad_prefix_id already exists on table phpbb_classifieds.
Adding a new column named ad_location_id to table phpbb_classifieds
ERROR: The column ad_location_id already exists on table phpbb_classifieds.
Adding a new column named ad_price_text to table phpbb_classifieds
ERROR: The column ad_price_text already exists on table phpbb_classifieds.
Adding new config variable: display_profile_last_ads
ERROR: Config variable display_profile_last_ads already exists.
Adding new config variable: profile_num_last_ads
ERROR: Config variable profile_num_last_ads already exists.
Adding new config variable: max_img_size
ERROR: Config variable max_img_size already exists.