Advertisement:
« previous next »
Pages: [1]

Author Topic: Upgdate to 2.2.3 help  (Read 5973 times)

BuySellAndSwap

  • Sr. Member
  • ****
  • Posts: 389
Upgdate to 2.2.3 help
« on: September 26, 2011, 10:39:47 pm »
I get this message when i auto upgrade...

We had some errors upgrading your database. The follwing queries failedALTER TABLE oc_t_admin CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_admin ADD PRIMARY KEY (pk_i_id),
ALTER TABLE oc_t_admin ADD UNIQUE KEY (s_username),
ALTER TABLE oc_t_alerts CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED DEFAULT NULL,
 ALTER TABLE oc_t_alerts CHANGE COLUMN s_search s_search LONGTEXT,
ALTER TABLE oc_t_alerts CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_category CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_category CHANGE COLUMN fk_i_parent_id fk_i_parent_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_category CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
 ALTER TABLE oc_t_category ADD PRIMARY KEY (pk_i_id),
ALTER TABLE oc_t_category ADD INDEX (fk_i_parent_id),
ALTER TABLE oc_t_category ADD INDEX (i_position),
ALTER TABLE oc_t_category_description CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_category_description ADD PRIMARY KEY (fk_i_category_id, fk_c_locale_code),
 ALTER TABLE oc_t_category_description ADD FOREIGN KEY (fk_i_category_id) REFERENCES oc_t_category (pk_i_id),
 ALTER TABLE oc_t_category_stats CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_category_stats CHANGE COLUMN i_num_items i_num_items INT UNSIGNED NOT NULL DEFAULT 0,
 ALTER TABLE oc_t_category_stats ADD PRIMARY KEY (fk_i_category_id),
ALTER TABLE oc_t_city CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_city CHANGE COLUMN fk_i_region_id fk_i_region_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_city CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT TRUE,
 ALTER TABLE oc_t_city ADD PRIMARY KEY (pk_i_id),
ALTER TABLE oc_t_city ADD INDEX (fk_i_region_id),
ALTER TABLE oc_t_city ADD FOREIGN KEY (fk_i_region_id) REFERENCES oc_t_region (pk_i_id),
 ALTER TABLE oc_t_city_area CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_city_area CHANGE COLUMN fk_i_city_id fk_i_city_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_city_area ADD PRIMARY KEY (pk_i_id),
ALTER TABLE oc_t_city_area ADD INDEX (fk_i_city_id),
ALTER TABLE oc_t_country ADD PRIMARY KEY (pk_c_code, fk_c_locale_code),
ALTER TABLE oc_t_currency CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
 ALTER TABLE oc_t_currency ADD PRIMARY KEY (pk_c_code),
ALTER TABLE oc_t_item CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_item CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_item CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_item CHANGE COLUMN f_price f_price FLOAT(15, 2) NULL,
ALTER TABLE oc_t_item CHANGE COLUMN b_premium b_premium BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_item CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
 ALTER TABLE oc_t_item CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_item CHANGE COLUMN b_spam b_spam BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_item CHANGE COLUMN b_show_email b_show_email BOOLEAN NULL,
ALTER TABLE oc_t_item ADD PRIMARY KEY (pk_i_id),
ALTER TABLE oc_t_item ADD INDEX (fk_i_user_id),
ALTER TABLE oc_t_item ADD FOREIGN KEY (fk_i_user_id) REFERENCES oc_t_user (pk_i_id),
 ALTER TABLE oc_t_item ADD INDEX (fk_i_category_id),
ALTER TABLE oc_t_item ADD FOREIGN KEY (fk_i_category_id) REFERENCES oc_t_category (pk_i_id),
 ALTER TABLE oc_t_item ADD INDEX (fk_c_currency_code),
ALTER TABLE oc_t_item_comment CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_item_comment CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_item_comment CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
 ALTER TABLE oc_t_item_comment CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_item_comment CHANGE COLUMN b_spam b_spam BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_item_comment CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_item_comment ADD PRIMARY KEY (pk_i_id),
ALTER TABLE oc_t_item_comment ADD INDEX (fk_i_item_id),
ALTER TABLE oc_t_item_comment ADD FOREIGN KEY (fk_i_item_id) REFERENCES oc_t_item (pk_i_id),
 ALTER TABLE oc_t_item_description CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_item_description ADD PRIMARY KEY (fk_i_item_id, fk_c_locale_code),
 ALTER TABLE oc_t_item_description ADD INDEX (fk_i_item_id),
ALTER TABLE oc_t_item_description ADD FOREIGN KEY (fk_i_item_id) REFERENCES oc_t_item (pk_i_id),
 ALTER TABLE oc_t_item_location CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_item_location CHANGE COLUMN fk_i_region_id fk_i_region_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_item_location CHANGE COLUMN s_region s_region VARCHAR(100),
ALTER TABLE oc_t_item_location CHANGE COLUMN fk_i_city_id fk_i_city_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_item_location CHANGE COLUMN fk_i_city_area_id fk_i_city_area_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_item_location CHANGE COLUMN d_coord_lat d_coord_lat DECIMAL(10, 6),
 ALTER TABLE oc_t_item_location CHANGE COLUMN d_coord_long d_coord_long DECIMAL(10, 6),
 ALTER TABLE oc_t_item_location ADD PRIMARY KEY (fk_i_item_id),
ALTER TABLE oc_t_item_location ADD FOREIGN KEY (fk_i_item_id) REFERENCES oc_t_item (pk_i_id),
 ALTER TABLE oc_t_item_location ADD FOREIGN KEY (fk_c_country_code) REFERENCES oc_t_country (pk_c_code),
 ALTER TABLE oc_t_item_location ADD FOREIGN KEY (fk_i_region_id) REFERENCES oc_t_region (pk_i_id),
 ALTER TABLE oc_t_item_location ADD FOREIGN KEY (fk_i_city_id) REFERENCES oc_t_city (pk_i_id),
 ALTER TABLE oc_t_item_meta CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_item_meta CHANGE COLUMN fk_i_field_id fk_i_field_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_item_meta ADD PRIMARY KEY (fk_i_item_id, fk_i_field_id),
ALTER TABLE oc_t_item_meta ADD FOREIGN KEY (fk_i_item_id) REFERENCES oc_t_item (pk_i_id),
 ALTER TABLE oc_t_item_resource CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_item_resource CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_item_resource ADD PRIMARY KEY (pk_i_id),
ALTER TABLE oc_t_item_resource ADD INDEX (fk_i_item_id),
ALTER TABLE oc_t_item_stats CHANGE COLUMN fk_i_item_id fk_i_item_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_item_stats CHANGE COLUMN i_num_views i_num_views INT UNSIGNED NOT NULL DEFAULT 0,
 ALTER TABLE oc_t_item_stats CHANGE COLUMN i_num_spam i_num_spam INT UNSIGNED NOT NULL DEFAULT 0,
 ALTER TABLE oc_t_item_stats CHANGE COLUMN i_num_repeated i_num_repeated INT UNSIGNED NOT NULL DEFAULT 0,
 ALTER TABLE oc_t_item_stats CHANGE COLUMN i_num_bad_classified i_num_bad_classified INT UNSIGNED NOT NULL DEFAULT 0,
 ALTER TABLE oc_t_item_stats CHANGE COLUMN i_num_offensive i_num_offensive INT UNSIGNED NOT NULL DEFAULT 0,
 ALTER TABLE oc_t_item_stats CHANGE COLUMN i_num_expired i_num_expired INT UNSIGNED NOT NULL DEFAULT 0,
 ALTER TABLE oc_t_item_stats CHANGE COLUMN i_num_premium_views i_num_premium_views INT UNSIGNED NOT NULL DEFAULT 0,
 ALTER TABLE oc_t_item_stats ADD PRIMARY KEY (fk_i_item_id, dt_date),
ALTER TABLE oc_t_item_stats ADD INDEX (dt_date, fk_i_item_id),
ALTER TABLE oc_t_keywords CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_keywords CHANGE COLUMN fk_i_city_id fk_i_city_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_keywords ADD PRIMARY KEY (s_md5, fk_c_locale_code),
ALTER TABLE oc_t_keywords ADD INDEX (fk_i_category_id),
ALTER TABLE oc_t_keywords ADD INDEX (fk_i_city_id),
ALTER TABLE oc_t_keywords ADD FOREIGN KEY (fk_i_category_id) REFERENCES oc_t_category (pk_i_id),
 ALTER TABLE oc_t_keywords ADD FOREIGN KEY (fk_i_city_id) REFERENCES oc_t_city (pk_i_id),
 ALTER TABLE oc_t_locale CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
 ALTER TABLE oc_t_locale CHANGE COLUMN b_enabled_bo b_enabled_bo BOOLEAN NOT NULL DEFAULT TRUE,
 ALTER TABLE oc_t_locale ADD PRIMARY KEY (pk_c_code),
ALTER TABLE oc_t_log CHANGE COLUMN fk_i_id fk_i_id INT UNSIGNED NOT NULL,
ALTER TABLE oc_t_meta_categories CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_meta_categories CHANGE COLUMN fk_i_field_id fk_i_field_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_meta_categories ADD PRIMARY KEY (fk_i_category_id, fk_i_field_id),
 ALTER TABLE oc_t_meta_categories ADD FOREIGN KEY (fk_i_category_id) REFERENCES oc_t_category (pk_i_id),
 ALTER TABLE oc_t_meta_fields CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_meta_fields CHANGE COLUMN b_required b_required BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_pages CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_pages CHANGE COLUMN b_indelible b_indelible BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_pages_description CHANGE COLUMN fk_i_pages_id fk_i_pages_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_pages_description CHANGE COLUMN s_text s_text TEXT,
ALTER TABLE oc_t_pages_description ADD PRIMARY KEY (fk_i_pages_id, fk_c_locale_code),
 ALTER TABLE oc_t_pages_description ADD FOREIGN KEY (fk_i_pages_id) REFERENCES oc_t_pages (pk_i_id),
 ALTER TABLE oc_t_plugin_category CHANGE COLUMN fk_i_category_id fk_i_category_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_plugin_category ADD INDEX (fk_i_category_id),
ALTER TABLE oc_t_region CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_region CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT TRUE,
 ALTER TABLE oc_t_region ADD PRIMARY KEY (pk_i_id),
ALTER TABLE oc_t_region ADD INDEX (fk_c_country_code),
ALTER TABLE oc_t_user CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 ALTER TABLE oc_t_user CHANGE COLUMN s_phone_land s_phone_land VARCHAR(45),
ALTER TABLE oc_t_user CHANGE COLUMN s_phone_mobile s_phone_mobile VARCHAR(45),
ALTER TABLE oc_t_user CHANGE COLUMN b_enabled b_enabled BOOLEAN NOT NULL DEFAULT TRUE,
 ALTER TABLE oc_t_user CHANGE COLUMN b_active b_active BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_user CHANGE COLUMN fk_i_region_id fk_i_region_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_user CHANGE COLUMN s_region s_region VARCHAR(100),
ALTER TABLE oc_t_user CHANGE COLUMN fk_i_city_id fk_i_city_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_user CHANGE COLUMN fk_i_city_area_id fk_i_city_area_id INT UNSIGNED NULL,
 ALTER TABLE oc_t_user CHANGE COLUMN d_coord_lat d_coord_lat DECIMAL(10, 6),
ALTER TABLE oc_t_user CHANGE COLUMN d_coord_long d_coord_long DECIMAL(10, 6),
ALTER TABLE oc_t_user CHANGE COLUMN b_company b_company BOOLEAN NOT NULL DEFAULT FALSE,
 ALTER TABLE oc_t_user CHANGE COLUMN i_items i_items INT UNSIGNED NULL DEFAULT 0,
 ALTER TABLE oc_t_user CHANGE COLUMN i_comments i_comments INT UNSIGNED NULL DEFAULT 0,
 ALTER TABLE oc_t_user ADD PRIMARY KEY (pk_i_id),
ALTER TABLE oc_t_user ADD UNIQUE KEY (s_email),
ALTER TABLE oc_t_user ADD FOREIGN KEY (fk_c_country_code) REFERENCES oc_t_country (pk_c_code),
 ALTER TABLE oc_t_user ADD FOREIGN KEY (fk_i_region_id) REFERENCES oc_t_region (pk_i_id),
 ALTER TABLE oc_t_user ADD FOREIGN KEY (fk_i_city_id) REFERENCES oc_t_city (pk_i_id),
 ALTER TABLE oc_t_user_description CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_user_description ADD PRIMARY KEY (fk_i_user_id, fk_c_locale_code),
 ALTER TABLE oc_t_user_description ADD FOREIGN KEY (fk_i_user_id) REFERENCES oc_t_user (pk_i_id),
 ALTER TABLE oc_t_user_email_tmp CHANGE COLUMN fk_i_user_id fk_i_user_id INT UNSIGNED NOT NULL,
 ALTER TABLE oc_t_user_email_tmp ADD PRIMARY KEY (fk_i_user_id),
ALTER TABLE oc_t_widget CHANGE COLUMN pk_i_id pk_i_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
 

Thank you for any help
Logged

_CONEJO

  • Administrator
  • Hero Member
  • *****
  • Posts: 4689
Re: Upgdate to 2.2.3 help
« Reply #1 on: September 27, 2011, 10:35:39 am »
At the end of that, should offer you TWO LINKS, one to continue anyway and another to cancel, please, click continue
Logged

BuySellAndSwap

  • Sr. Member
  • ****
  • Posts: 389
Re: Upgdate to 2.2.3 help
« Reply #2 on: September 27, 2011, 05:03:47 pm »
I have managed to update manually

Thank you
Logged

LiteJ

  • Newbie
  • *
  • Posts: 16
Re: Upgdate to 2.2.3 help
« Reply #3 on: September 27, 2011, 11:19:41 pm »
Same problem, it must be a common issue. No links to continue.
Logged

_CONEJO

  • Administrator
  • Hero Member
  • *****
  • Posts: 4689
Re: Upgdate to 2.2.3 help
« Reply #4 on: September 28, 2011, 10:23:02 am »
Quote from: LiteJ on September 27, 2011, 11:19:41 pm
Same problem, it must be a common issue. No links to continue.


I'm pretty sure that at the end there was a link to continue
Logged

LiteJ

  • Newbie
  • *
  • Posts: 16
Re: Upgdate to 2.2.3 help
« Reply #5 on: September 28, 2011, 10:33:13 am »
Logged

kris

  • Full Member
  • ***
  • Posts: 106
Re: Upgdate to 2.2.3 help
« Reply #6 on: September 28, 2011, 10:37:52 am »
Same Here !!
Logged

afeinstein

  • Newbie
  • *
  • Posts: 2
Re: Upgdate to 2.2.3 help
« Reply #7 on: September 28, 2011, 06:46:33 pm »
I am also getting the same error list with no continue link. I looked in the source html and the link is not there either. Thanks.
Logged

Taracque

  • Newbie
  • *
  • Posts: 1
Re: Upgdate to 2.2.3 help
« Reply #8 on: October 03, 2011, 02:15:29 pm »
It seems, that the struct.sql contains TAB characters, which is not trimmed by the updater script.
Replace the line 383 in db.php (os-includes/osclass/db.php)
from:

$indexes[] = trim($field, ", \n");

to:

$indexes[] = trim($field, ", \t\r\n");

and try update again.
Logged

hallartistry

  • Full Member
  • ***
  • Posts: 133
Re: Upgdate to 2.2.3 help
« Reply #9 on: October 05, 2011, 09:36:06 pm »
I'm getting the same thing...no continue link.  :-[
Logged

hallartistry

  • Full Member
  • ***
  • Posts: 133
Re: Upgdate to 2.2.3 help
« Reply #10 on: October 05, 2011, 09:56:57 pm »
Quote from: Taracque on October 03, 2011, 02:15:29 pm
It seems, that the struct.sql contains TAB characters, which is not trimmed by the updater script.
Replace the line 383 in db.php (os-includes/osclass/db.php)
from:

$indexes[] = trim($field, ", \n");

to:

$indexes[] = trim($field, ", \t\r\n");

and try update again.

Sorry, I tried this but it didn't work
Logged

BaliDave

  • Newbie
  • *
  • Posts: 22
Re: Upgdate to 2.2.3 help
« Reply #11 on: October 10, 2011, 11:42:55 am »
I'm getting the same thing -- the error messages as above and NO continue button.  Site is stuck in Maintenance mode and I'm hesitant to turn that off, esp. since most files have been updated on my server.  Any help on this???
Logged

BuySellAndSwap

  • Sr. Member
  • ****
  • Posts: 389
Re: Upgdate to 2.2.3 help
« Reply #12 on: October 10, 2011, 11:47:38 am »
Manual update is the best option and I turned maintaince mode off and the site still worked but once you copy all the files accross then run the update file as I said before just have a look or look on the wiki as I'm on my phone at the min
Logged

BaliDave

  • Newbie
  • *
  • Posts: 22
Re: Upgdate to 2.2.3 help
« Reply #13 on: October 10, 2011, 01:19:47 pm »
That appeared to work fine -- thanks!
Logged

Juan Ramón

  • Osclass Developer
  • Hero Member
  • *****
  • Posts: 2382
Re: Upgdate to 2.2.3 help
« Reply #14 on: October 13, 2011, 01:42:59 pm »
Quote from: hallartistry on October 05, 2011, 09:36:06 pm
I'm getting the same thing...no continue link.  :-[

Have you solved your problems updating OSClass?
Logged
Pages: [1]
« previous next »