Hello,
i've upgraded my osclass to the latest version,
those are the errors i get during the upgrade :
We encountered some problems updating the database structure. The following queries failed:
ALTER TABLE pp_t_admin CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_admin ADD PRIMARY KEY (pk_i_id),
ALTER TABLE pp_t_admin ADD UNIQUE KEY (s_username),
ALTER TABLE pp_t_alerts CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED DEFAULT NULL,
ALTER TABLE pp_t_alerts CHANGE COLUMN s_search s_search LONGTEXT,
ALTER TABLE pp_t_alerts CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_category CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_category CHANGE COLUMN fk_i_parent_id fk_i_parent_id INT UNSIGNED NULL,
ALTER TABLE pp_t_category CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
ALTER TABLE pp_t_category ADD PRIMARY KEY (pk_i_id),
ALTER TABLE pp_t_category ADD INDEX (fk_i_parent_id),
ALTER TABLE pp_t_category ADD INDEX (i_position),
ALTER TABLE pp_t_category_description CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_category_description ADD PRIMARY KEY (fk_i_category_id, fk_c_locale_code),
ALTER TABLE pp_t_category_description ADD FOREIGN KEY (fk_i_category_id) REFERENCES pp_t_category (pk_i_id),
ALTER TABLE pp_t_category_stats CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_category_stats CHANGE COLUMN i_num_items i_num_items INT UNSIGNED NOT NULL DEFAULT 0,
ALTER TABLE pp_t_category_stats ADD PRIMARY KEY (fk_i_category_id),
ALTER TABLE pp_t_city CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_city CHANGE COLUMN fk_i_region_id fk_i_region_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_city CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT TRUE,
ALTER TABLE pp_t_city ADD PRIMARY KEY (pk_i_id),
ALTER TABLE pp_t_city ADD INDEX (fk_i_region_id),
ALTER TABLE pp_t_city ADD FOREIGN KEY (fk_i_region_id) REFERENCES pp_t_region (pk_i_id),
ALTER TABLE pp_t_city_area CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_city_area CHANGE COLUMN fk_i_city_id fk_i_city_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_city_area ADD PRIMARY KEY (pk_i_id),
ALTER TABLE pp_t_city_area ADD INDEX (fk_i_city_id),
ALTER TABLE pp_t_country ADD PRIMARY KEY (pk_c_code, fk_c_locale_code),
ALTER TABLE pp_t_currency CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
ALTER TABLE pp_t_currency ADD PRIMARY KEY (pk_c_code),
ALTER TABLE pp_t_item CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_item CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED NULL,
ALTER TABLE pp_t_item CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_item CHANGE COLUMN f_price f_price FLOAT(15, 2) NULL,
ALTER TABLE pp_t_item CHANGE COLUMN b_premium b_premium BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_item CHANGE COLUMN b_show_email b_show_email BOOLEAN NULL,
ALTER TABLE pp_t_item CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
ALTER TABLE pp_t_item CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_item CHANGE COLUMN b_spam b_spam BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_item ADD PRIMARY KEY (pk_i_id),
ALTER TABLE pp_t_item ADD INDEX (fk_i_user_id),
ALTER TABLE pp_t_item ADD FOREIGN KEY (fk_i_user_id) REFERENCES pp_t_user (pk_i_id),
ALTER TABLE pp_t_item ADD INDEX (fk_i_category_id),
ALTER TABLE pp_t_item ADD FOREIGN KEY (fk_i_category_id) REFERENCES pp_t_category (pk_i_id),
ALTER TABLE pp_t_item ADD INDEX (fk_c_currency_code),
ALTER TABLE pp_t_item_comment CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_item_comment CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_item_comment CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED NULL,
ALTER TABLE pp_t_item_comment CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
ALTER TABLE pp_t_item_comment CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_item_comment CHANGE COLUMN b_spam b_spam BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_item_comment ADD PRIMARY KEY (pk_i_id),
ALTER TABLE pp_t_item_comment ADD INDEX (fk_i_item_id),
ALTER TABLE pp_t_item_comment ADD FOREIGN KEY (fk_i_item_id) REFERENCES pp_t_item (pk_i_id),
ALTER TABLE pp_t_item_description CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_item_description ADD PRIMARY KEY (fk_i_item_id, fk_c_locale_code),
ALTER TABLE pp_t_item_description ADD INDEX (fk_i_item_id),
ALTER TABLE pp_t_item_description ADD FOREIGN KEY (fk_i_item_id) REFERENCES pp_t_item (pk_i_id),
ALTER TABLE pp_t_item_location CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_item_location CHANGE COLUMN fk_i_region_id fk_i_region_id INT UNSIGNED NULL,
ALTER TABLE pp_t_item_location CHANGE COLUMN s_region s_region VARCHAR(100),
ALTER TABLE pp_t_item_location CHANGE COLUMN fk_i_city_id fk_i_city_id INT UNSIGNED NULL,
ALTER TABLE pp_t_item_location CHANGE COLUMN fk_i_city_area_id fk_i_city_area_id INT UNSIGNED NULL,
ALTER TABLE pp_t_item_location CHANGE COLUMN d_coord_lat d_coord_lat DECIMAL(10, 6),
ALTER TABLE pp_t_item_location CHANGE COLUMN d_coord_long d_coord_long DECIMAL(10, 6),
ALTER TABLE pp_t_item_location ADD PRIMARY KEY (fk_i_item_id),
ALTER TABLE pp_t_item_location ADD FOREIGN KEY (fk_i_item_id) REFERENCES pp_t_item (pk_i_id),
ALTER TABLE pp_t_item_location ADD FOREIGN KEY (fk_c_country_code) REFERENCES pp_t_country (pk_c_code),
ALTER TABLE pp_t_item_location ADD FOREIGN KEY (fk_i_region_id) REFERENCES pp_t_region (pk_i_id),
ALTER TABLE pp_t_item_location ADD FOREIGN KEY (fk_i_city_id) REFERENCES pp_t_city (pk_i_id),
ALTER TABLE pp_t_item_meta CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_item_meta CHANGE COLUMN fk_i_field_id fk_i_field_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_item_meta ADD PRIMARY KEY (fk_i_item_id, fk_i_field_id),
ALTER TABLE pp_t_item_meta ADD FOREIGN KEY (fk_i_item_id) REFERENCES pp_t_item (pk_i_id),
ALTER TABLE pp_t_item_resource CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_item_resource CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_item_resource ADD PRIMARY KEY (pk_i_id),
ALTER TABLE pp_t_item_resource ADD INDEX (fk_i_item_id),
ALTER TABLE pp_t_item_stats CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_item_stats CHANGE COLUMN i_num_views i_num_views INT UNSIGNED NOT NULL DEFAULT 0,
ALTER TABLE pp_t_item_stats CHANGE COLUMN i_num_spam i_num_spam INT UNSIGNED NOT NULL DEFAULT 0,
ALTER TABLE pp_t_item_stats CHANGE COLUMN i_num_repeated i_num_repeated INT UNSIGNED NOT NULL DEFAULT 0,
ALTER TABLE pp_t_item_stats CHANGE COLUMN i_num_bad_classified i_num_bad_classified INT UNSIGNED NOT NULL DEFAULT 0,
ALTER TABLE pp_t_item_stats CHANGE COLUMN i_num_offensive i_num_offensive INT UNSIGNED NOT NULL DEFAULT 0,
ALTER TABLE pp_t_item_stats CHANGE COLUMN i_num_expired i_num_expired INT UNSIGNED NOT NULL DEFAULT 0,
ALTER TABLE pp_t_item_stats CHANGE COLUMN i_num_premium_views i_num_premium_views INT UNSIGNED NOT NULL DEFAULT 0,
ALTER TABLE pp_t_item_stats ADD PRIMARY KEY (fk_i_item_id, dt_date),
ALTER TABLE pp_t_item_stats ADD INDEX (dt_date, fk_i_item_id),
ALTER TABLE pp_t_keywords CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NULL,
ALTER TABLE pp_t_keywords CHANGE COLUMN fk_i_city_id fk_i_city_id INT UNSIGNED NULL,
ALTER TABLE pp_t_keywords ADD PRIMARY KEY (s_md5, fk_c_locale_code),
ALTER TABLE pp_t_keywords ADD INDEX (fk_i_category_id),
ALTER TABLE pp_t_keywords ADD INDEX (fk_i_city_id),
ALTER TABLE pp_t_keywords ADD FOREIGN KEY (fk_i_category_id) REFERENCES pp_t_category (pk_i_id),
ALTER TABLE pp_t_keywords ADD FOREIGN KEY (fk_i_city_id) REFERENCES pp_t_city (pk_i_id),
ALTER TABLE pp_t_locale CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
ALTER TABLE pp_t_locale CHANGE COLUMN b_enabled_bo b_enabled_bo BOOLEAN NOT NULL DEFAULT TRUE,
ALTER TABLE pp_t_locale ADD PRIMARY KEY (pk_c_code),
ALTER TABLE pp_t_log CHANGE COLUMN fk_i_id fk_i_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_meta_categories CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_meta_categories CHANGE COLUMN fk_i_field_id fk_i_field_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_meta_categories ADD PRIMARY KEY (fk_i_category_id, fk_i_field_id),
ALTER TABLE pp_t_meta_categories ADD FOREIGN KEY (fk_i_category_id) REFERENCES pp_t_category (pk_i_id),
ALTER TABLE pp_t_meta_fields CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_meta_fields CHANGE COLUMN b_required b_required BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_pages CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_pages CHANGE COLUMN b_indelible b_indelible BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_pages_description CHANGE COLUMN fk_i_pages_id fk_i_pages_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_pages_description CHANGE COLUMN s_text s_text TEXT,
ALTER TABLE pp_t_pages_description ADD PRIMARY KEY (fk_i_pages_id, fk_c_locale_code),
ALTER TABLE pp_t_pages_description ADD FOREIGN KEY (fk_i_pages_id) REFERENCES pp_t_pages (pk_i_id),
ALTER TABLE pp_t_plugin_category CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_plugin_category ADD INDEX (fk_i_category_id),
ALTER TABLE pp_t_region CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_region CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT TRUE,
ALTER TABLE pp_t_region ADD PRIMARY KEY (pk_i_id),
ALTER TABLE pp_t_region ADD INDEX (fk_c_country_code),
ALTER TABLE pp_t_user CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ALTER TABLE pp_t_user CHANGE COLUMN s_phone_land s_phone_land VARCHAR(45),
ALTER TABLE pp_t_user CHANGE COLUMN s_phone_mobile s_phone_mobile VARCHAR(45),
ALTER TABLE pp_t_user CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
ALTER TABLE pp_t_user CHANGE COLUMN fk_i_region_id fk_i_region_id INT UNSIGNED NULL,
ALTER TABLE pp_t_user CHANGE COLUMN s_region s_region VARCHAR(100),
ALTER TABLE pp_t_user CHANGE COLUMN fk_i_city_id fk_i_city_id INT UNSIGNED NULL,
ALTER TABLE pp_t_user CHANGE COLUMN fk_i_city_area_id fk_i_city_area_id INT UNSIGNED NULL,
ALTER TABLE pp_t_user CHANGE COLUMN d_coord_lat d_coord_lat DECIMAL(10, 6),
ALTER TABLE pp_t_user CHANGE COLUMN d_coord_long d_coord_long DECIMAL(10, 6),
ALTER TABLE pp_t_user CHANGE COLUMN b_company b_company BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_user CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT FALSE,
ALTER TABLE pp_t_user CHANGE COLUMN i_items i_items INT UNSIGNED NULL DEFAULT 0,
ALTER TABLE pp_t_user CHANGE COLUMN i_comments i_comments INT UNSIGNED NULL DEFAULT 0,
ALTER TABLE pp_t_user ADD PRIMARY KEY (pk_i_id),
ALTER TABLE pp_t_user ADD UNIQUE KEY (s_email),
ALTER TABLE pp_t_user ADD FOREIGN KEY (fk_c_country_code) REFERENCES pp_t_country (pk_c_code),
ALTER TABLE pp_t_user ADD FOREIGN KEY (fk_i_region_id) REFERENCES pp_t_region (pk_i_id),
ALTER TABLE pp_t_user ADD FOREIGN KEY (fk_i_city_id) REFERENCES pp_t_city (pk_i_id),
ALTER TABLE pp_t_user_description CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_user_description ADD PRIMARY KEY (fk_i_user_id, fk_c_locale_code),
ALTER TABLE pp_t_user_description ADD FOREIGN KEY (fk_i_user_id) REFERENCES pp_t_user (pk_i_id),
ALTER TABLE pp_t_user_email_tmp CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED NOT NULL,
ALTER TABLE pp_t_user_email_tmp ADD PRIMARY KEY (fk_i_user_id),
ALTER TABLE pp_t_widget CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
