Hi there,
I am having problem trying to upgrade my OSClass from 2.3.7 to 2.4
On my development box, empty 2.3.7 database I can upgrade the database successfully.
On my server box database, having some error, and the upgrade database process stop.
When I profile MySql actually it stop after this, statement:
.
.
.
9 Query ALTER TABLE oc_t_plugin_category ADD INDEX (fk_i_category_id),
9 Query ALTER TABLE oc_t_region ALTER COLUMN b_active SET DEFAULT 1,
9 Query ALTER TABLE oc_t_region ADD PRIMARY KEY (pk_i_id),
9 Query ALTER TABLE oc_t_region ADD INDEX (fk_c_country_code),
9 Query ALTER TABLE oc_t_region ADD INDEX idx_s_name (s_name),
9 Query ALTER TABLE oc_t_user CHANGE COLUMN s_phone_land s_phone_land VARCHAR(45),
9 Query ALTER TABLE oc_t_user CHANGE COLUMN s_phone_mobile s_phone_mobile VARCHAR(45),
9 Query ALTER TABLE oc_t_user ALTER COLUMN b_enabled SET DEFAULT 1,
9 Query ALTER TABLE oc_t_user ALTER COLUMN b_active SET DEFAULT 0,
9 Query ALTER TABLE oc_t_user CHANGE COLUMN s_region s_region VARCHAR(100),
9 Query ALTER TABLE oc_t_user CHANGE COLUMN d_coord_lat d_coord_lat DECIMAL(10,6),
9 Query ALTER TABLE oc_t_user CHANGE COLUMN d_coord_long d_coord_long DECIMAL(10,6),
9 Query ALTER TABLE oc_t_user ALTER COLUMN i_permissions SET DEFAULT 0,
9 Query ALTER TABLE oc_t_user ALTER COLUMN b_company SET DEFAULT 0,
9 Query ALTER TABLE oc_t_user ALTER COLUMN i_items SET DEFAULT 0,
9 Query ALTER TABLE oc_t_user ALTER COLUMN i_comments SET DEFAULT 0,
9 Query ALTER TABLE oc_t_user ADD PRIMARY KEY (pk_i_id),
9 Query ALTER TABLE oc_t_user ADD UNIQUE KEY (s_email),
9 Query ALTER TABLE oc_t_user ADD INDEX idx_s_name (s_name(6)),
9 Query ALTER TABLE oc_t_user_description ADD PRIMARY KEY (fk_i_user_id, fk_c_locale_code),
9 Query ALTER TABLE oc_t_user_email_tmp ADD PRIMARY KEY (fk_i_user_id),
9 Quit
and it said fail to upgrade the database, I have tried to checked the upgrade_funcs.php, but not successfull.
Anyone can help?
Cheers
