Osclass forums

Support forums => Installation / Update help => Topic started by: nootkan on April 15, 2018, 07:40:32 am

Title: Upgrade Errors
Post by: nootkan 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?

Title: Re: Upgrade Errors
Post by: Aficionado on April 16, 2018, 04:15:10 pm

Where are the errors ?

Title: Re: Upgrade Errors
Post by: WEBmods 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.

Title: Re: Upgrade Errors
Post by: nootkan 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.

Title: Re: Upgrade Errors
Post by: Aficionado on April 17, 2018, 11:50:55 am

Again, those are NOT ERRORS.