Search the Community

Clean install PS 1.6.1.17 no changes and trying to upgrade to PS 1.7.2.3 = FAIL Should this work and has anyone been successful in upgrading via 1 click upgrade from 1.6.x.x to 1.7.x.x Please share results so people trying have some guide to follow or just not try because it doesn't work. Prestashop feel free to contribute and don't be a faceless stranger to the forum. A year into 1.6 Maintenance - The way forward - Not quiet there yet. build.prestashop.com

Hi, Yesterday I tried to update my prestashop 1.6.1.19 to 1.7.5.0. I did not succeed. I used the 1-Click Upgrade module. All checklist was green. Version comparison: PrestaShop Original version: 171 file modifications have been detected, including 101 from core and native modules: Differences between versions: 1761 files will be modified, 1420 files will be deleted (if they are found). I could start the upgrade. But at the very end of the upgrade this error occurred: "error updating doctrine schema" and I had to rollback. THE WHOLE ERROR LOG: [WARNING] SQL 1.7.5.0 1060 in ALTER TABLE `ps_stock_available` ADD `location` VARCHAR(255) NOT NULL DEFAULT '' AFTER `out_of_stock`: Duplicate column name 'location' Updating database schema... Executing: CREATE TABLE ps_module_history (id INT AUTO_INCREMENT NOT NULL, id_employee INT NOT NULL, id_module INT NOT NULL, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB Executing: CREATE TABLE ps_admin_filter (id INT AUTO_INCREMENT NOT NULL, employee INT NOT NULL, shop INT NOT NULL, controller VARCHAR(60) NOT NULL, action VARCHAR(100) NOT NULL, filter LONGTEXT NOT NULL, UNIQUE INDEX admin_filter_search_idx (employee, shop, controller, action), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB Executing: CREATE TABLE ps_translation (id_translation INT AUTO_INCREMENT NOT NULL, id_lang INT NOT NULL, `key` TEXT NOT NULL, translation TEXT NOT NULL, domain VARCHAR(80) NOT NULL, theme VARCHAR(32) DEFAULT NULL, INDEX IDX_ADEBEB36BA299860 (id_lang), INDEX `key` (domain), PRIMARY KEY(id_translation)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB Executing: DROP INDEX id_lang ON ps_attribute_lang Executing: CREATE INDEX IDX_3ABE46A77A4F53DC ON ps_attribute_lang (id_attribute) Executing: CREATE INDEX IDX_3ABE46A7BA299860 ON ps_attribute_lang (id_lang) Executing: DROP INDEX lang_iso_code ON ps_lang Executing: ALTER TABLE ps_lang CHANGE active active TINYINT(1) NOT NULL DEFAULT '0' , CHANGE iso_code iso_code VARCHAR(2) NOT NULL, CHANGE language_code language_code VARCHAR(5) NOT NULL, CHANGE date_format_lite date_format_lite VARCHAR(32) NOT NULL DEFAULT 'Y-m-d' , CHANGE date_format_full date_format_full VARCHAR(32) NOT NULL DEFAULT 'Y-m-d H:i:s' , CHANGE is_rtl is_rtl TINYINT(1) NOT NULL DEFAULT '0' Executing: CREATE INDEX IDX_2F43BFC7BA299860 ON ps_lang_shop (id_lang) Executing: DROP INDEX id_shop ON ps_lang_shop Executing: CREATE INDEX IDX_2F43BFC7274A50A0 ON ps_lang_shop (id_shop) Executing: ALTER TABLE ps_attribute_group CHANGE is_color_group is_color_group TINYINT(1) NOT NULL DEFAULT '0' , CHANGE group_type group_type VARCHAR(255) NOT NULL DEFAULT 'select' , CHANGE position position INT NOT NULL DEFAULT '0' Executing: CREATE INDEX IDX_DB30BAAC67A664FB ON ps_attribute_group_shop (id_attribute_group) Executing: DROP INDEX id_shop ON ps_attribute_group_shop Executing: CREATE INDEX IDX_DB30BAAC274A50A0 ON ps_attribute_group_shop (id_shop) Executing: CREATE INDEX IDX_4653726C67A664FB ON ps_attribute_group_lang (id_attribute_group) Executing: CREATE INDEX IDX_4653726CBA299860 ON ps_attribute_group_lang (id_lang) Executing: ALTER TABLE ps_tab_lang CHANGE name name VARCHAR(128) NOT NULL Executing: CREATE INDEX IDX_CFD9262DED47AB56 ON ps_tab_lang (id_tab) Executing: CREATE INDEX IDX_CFD9262DBA299860 ON ps_tab_lang (id_lang) Executing: DROP INDEX class_name ON ps_tab Executing: DROP INDEX id_parent ON ps_tab Executing: ALTER TABLE ps_tab CHANGE class_name class_name VARCHAR(64) DEFAULT NULL, CHANGE position position INT NOT NULL, CHANGE active active TINYINT(1) NOT NULL DEFAULT '1' , CHANGE hide_host_mode hide_host_mode TINYINT(1) NOT NULL DEFAULT '0' , CHANGE icon icon VARCHAR(32) DEFAULT '' Executing: DROP INDEX id_category ON ps_shop Executing: DROP INDEX id_shop_group ON ps_shop Executing: ALTER TABLE ps_shop CHANGE id_category id_category INT NOT NULL DEFAULT '1' , CHANGE theme_name theme_name VARCHAR(255) NOT NULL, CHANGE active active TINYINT(1) NOT NULL DEFAULT '1' , CHANGE deleted deleted TINYINT(1) NOT NULL DEFAULT '0' Executing: CREATE INDEX IDX_CBDFBB9EF5C9E40 ON ps_shop (id_shop_group) Executing: DROP INDEX deleted ON ps_shop_group Executing: ALTER TABLE ps_shop_group CHANGE active active TINYINT(1) NOT NULL DEFAULT '1' , CHANGE deleted deleted TINYINT(1) NOT NULL DEFAULT '0' Executing: ALTER TABLE ps_attribute CHANGE color color VARCHAR(32) NOT NULL, CHANGE position position INT NOT NULL DEFAULT '0' 04:02:07 ERROR [console] Error thrown while running command "prestashop:schema:update-without-foreign". Message: "An exception occurred while executing 'ALTER TABLE ps_attribute CHANGE color color VARCHAR(32) NOT NULL, CHANGE position position INT NOT NULL DEFAULT '0' ': SQLSTATE[01000]: Warning: 1265 Data truncated for column 'color' at row 1" ["exception" => Doctrine\DBAL\Exception\DriverException { …},"command" => "prestashop:schema:update-without-foreign","message" => """ An exception occurred while executing 'ALTER TABLE ps_attribute CHANGE color color VARCHAR(32) NOT NULL, CHANGE position position INT NOT NULL DEFAULT '0' ':\n \n SQLSTATE[01000]: Warning: 1265 Data truncated for column 'color' at row 1 """] In AbstractMySQLDriver.php line 115: An exception occurred while executing 'ALTER TABLE ps_attribute CHANGE colo r color VARCHAR(32) NOT NULL, CHANGE position position INT NOT NULL DEFAULT '0' ': SQLSTATE[01000]: Warning: 1265 Data truncated for column 'color' at row 1 In PDOConnection.php line 106: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'color' at row 1 In PDOConnection.php line 104: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'color' at row 1 prestashop:schema:update-without-foreign [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--id_shop [ID_SHOP]] [--id_shop_group [ID_SHOP_GROUP]] [--] Before I did the rollback I just visited my https://shop.borntotrick.com to check how it looks like. Only a blank page appeared, same when I wanted to access the admin page. So I enabled the debuger mode and this is what occurred: I tried the whole process one more time with PS cleaning "Functional integrity constraints - Check and Fix" and "Database cleaning - Clean and Optimize" with PS cleaner module before the upgrade but it did not solve my problem. Do you have any solution for this?

Does anyone have this 1click upgrade problem again, that whatever you click, nothing works? I thought this modules problems had been solved...

Hello everyone, I am new here . Tried to upgrade to prestashop 1.6.0.9 from 1.5.5.0 VIA 1-Click-Upgrade . I've tried everything. Red manuals and guides, tried to install the 1.5.6 and tried with .zip file via FileZilla but nothing seems to working. When the installer done with becking up my database, I get an error that some files can't be copied or modify/upgraded. I tried to deal with the problem VIA FTP FileZilla with permissions but PrestShop's 1 Click module has a list of 5000 files that will be modify through the upgrade process and its an Endless job to set permissions individualy to each and every folder & file. Maybe I am wrong, but this is the latest error I am getting: "Error while copying file /admin0776/ajax-tab.php Error when trying to upgrade file /admin0776/ajax-tab.php." Attached screenshot. more then that, It keeps sending me errors when I tried to Rollback and now my website is under maintanance mode but when I am trying to view it, it's a blank page. I guess due to the upgrade interrapt / files that has been deleted. So now I can't upgarde NOR rolling back and the website is off (B.T.Y - My Admin Panel in Hebrew - donno if it related..) PLEASE HELP! THANK YOU!