Advertisement:

Author Topic: Upgrade Errors  (Read 307 times)

nootkan

  • Sr. Member
  • ****
  • Posts: 255
Upgrade Errors
« on: April 15, 2018, 07:40:32 am »
Just tried to upgrade my Osclass version 3.7.1 to 3.7.4 and got these failure errors:

Quote
ALTER TABLE oc_t_category_description ADD FOREIGN KEY (fk_c_locale_code) REFERENCES oc_t_locale (pk_c_code)
ALTER TABLE oc_t_city ADD FOREIGN KEY (fk_i_region_id) REFERENCES oc_t_region (pk_i_id)
ALTER TABLE oc_t_city ADD FOREIGN KEY (fk_c_country_code) REFERENCES oc_t_country (pk_c_code)
ALTER TABLE oc_t_country_stats ADD FOREIGN KEY (fk_c_country_code) REFERENCES oc_t_country (pk_c_code)
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 FOREIGN KEY (fk_c_currency_code) REFERENCES oc_t_currency (pk_c_code)
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_comment ADD FOREIGN KEY (fk_i_user_id) REFERENCES oc_t_user (pk_i_id)
ALTER TABLE oc_t_item_description DROP PRIMARY KEY, ADD PRIMARY KEY (fk_i_item_id, fk_c_locale_code)
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_area_id) REFERENCES oc_t_city_area (pk_i_id)
ALTER TABLE oc_t_item_meta DROP PRIMARY KEY, ADD PRIMARY KEY (fk_i_item_id, fk_i_field_id, s_multi)
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_meta ADD FOREIGN KEY (fk_i_field_id) REFERENCES oc_t_meta_fields (pk_i_id)
ALTER TABLE oc_t_item_resource ADD FOREIGN KEY (fk_i_item_id) REFERENCES oc_t_item (pk_i_id)
ALTER TABLE oc_t_item_stats DROP PRIMARY KEY, ADD PRIMARY KEY (fk_i_item_id, dt_date)
ALTER TABLE oc_t_item_stats ADD FOREIGN KEY (fk_i_item_id) REFERENCES oc_t_item (pk_i_id)
ALTER TABLE oc_t_keywords DROP PRIMARY KEY, ADD PRIMARY KEY (s_md5, fk_c_locale_code)
ALTER TABLE oc_t_keywords ADD FOREIGN KEY (fk_c_locale_code) REFERENCES oc_t_locale (pk_c_code)
ALTER TABLE oc_t_locations_tmp DROP PRIMARY KEY, ADD PRIMARY KEY (id_location, e_type)
ALTER TABLE oc_t_meta_categories DROP PRIMARY KEY, ADD PRIMARY KEY (fk_i_category_id, fk_i_field_id)
ALTER TABLE oc_t_meta_categories ADD FOREIGN KEY (fk_i_field_id) REFERENCES oc_t_meta_fields (pk_i_id)
ALTER TABLE oc_t_pages_description DROP PRIMARY KEY, 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_pages_description ADD FOREIGN KEY (fk_c_locale_code) REFERENCES oc_t_locale (pk_c_code)
ALTER TABLE oc_t_preference ADD UNIQUE KEY (s_section, s_name)
ALTER TABLE oc_t_region ADD FOREIGN KEY (fk_c_country_code) REFERENCES oc_t_country (pk_c_code)
ALTER TABLE oc_t_region_stats ADD FOREIGN KEY (fk_i_region_id) REFERENCES oc_t_region (pk_i_id)
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_area_id) REFERENCES oc_t_city_area (pk_i_id)
ALTER TABLE oc_t_user_description DROP PRIMARY KEY, 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_description ADD FOREIGN KEY (fk_c_locale_code) REFERENCES oc_t_locale (pk_c_code)
ALTER TABLE oc_t_user_email_tmp ADD FOREIGN KEY (fk_i_user_id) REFERENCES oc_t_user (pk_i_id)

Anyone know what could be going on?
« Last Edit: April 15, 2018, 07:42:30 am by nootkan »

Aficionado

  • issues
  • Hero Member
  • *
  • Posts: 5918
  • Hardliner
Re: Upgrade Errors
« Reply #1 on: April 16, 2018, 04:15:10 pm »
Where are the errors ?




patrickFromCroatia

  • Full Member
  • ***
  • Posts: 229
Re: Upgrade Errors
« Reply #2 on: April 16, 2018, 05:50:52 pm »
Hello,

The list contains some MySQL functions that are triggered when osclass is upgrading/installing. There are no actual errors, this is just something like an installation log.

Regards.

nootkan

  • Sr. Member
  • ****
  • Posts: 255
Re: Upgrade Errors
« Reply #3 on: April 17, 2018, 05:57:07 am »
These errors show up when I try to do an auto update.  I cannot do the update because of this.  I haven't tried a manual update yet but I am seeing some issues in the database like not being able to edit some tables because the edit button isn't there ( Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available).  Been trying to figure this out but no success yet. Won't let me add a primary key or edit the existing tables to make one of them primary.

I also notice that when someone posts an item for free without registering the pk_i_id is showing a 0 instead of a sequential number like the registered users do. 

Might be that my database got corrupted somehow.  Have installed a fresh version on my local server to see if I can transfer over data that I need like items, users etc. Will post back here if I can figure it out.  Appreciate any feedback.

Aficionado

  • issues
  • Hero Member
  • *
  • Posts: 5918
  • Hardliner
Re: Upgrade Errors
« Reply #4 on: April 17, 2018, 11:50:55 am »
Again, those are NOT ERRORS.