sennevb Posted April 3, 2017 Share Posted April 3, 2017 (edited) i get following error so reverted back to 1.7.0.6: Updating database schema...,, , [Doctrine\DBAL\Exception\DriverException] , An exception occurred while 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, CHANGE hide_host_mode hide_host_mode TINYINT(1) NOT NULL, CHANGE icon icon VARCHAR(32) NOT NULL': , SQLSTATE[01000]: Warning: 1265 Data truncated for column 'icon' at row 2 , ,, , [Doctrine\DBAL\Driver\PDOException] , SQLSTATE[01000]: Warning: 1265 Data truncated for column 'icon' at row 2 , ,, , [PDOException] , SQLSTATE[01000]: Warning: 1265 Data truncated for column 'icon' at row 2 , ,,doctrine:schema:update [--complete] [--dump-sql] [-f|--force] [--em [EM]] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-s|--shell] [--process-isolation] [-e|--env ENV] [--no-debug] [--] ,, any clues? Edited April 3, 2017 by sennevb (see edit history) 1 Link to comment Share on other sites More sharing options...
whoey Posted April 3, 2017 Share Posted April 3, 2017 On a test cloned setup had a similar result. Link to comment Share on other sites More sharing options...
DavidMicro Posted April 4, 2017 Share Posted April 4, 2017 I've got the same problem. I've tried update manually and the front-office works but the back office I see it in blank. Link to comment Share on other sites More sharing options...
francescopepoli Posted April 4, 2017 Share Posted April 4, 2017 (edited) I've got the same problem. update the db manually can be a solution? Edited April 4, 2017 by francescopepoli (see edit history) Link to comment Share on other sites More sharing options...
bellini13 Posted April 4, 2017 Share Posted April 4, 2017 It is complaining that you have a record in the ps_tab database table, whose character length is too long. If I had to guess, you have a module installed that added a new back office tab, and the name of the icon for that tab exceeds 32 characters. Use phpmyadmin to review the existing records and locate the record causing the issue. Once you locate the record, then note if the module column is null or not 1 Link to comment Share on other sites More sharing options...
whoey Posted April 4, 2017 Share Posted April 4, 2017 Ours turned out to be a permission to do with INDEX in the database, adding that for the dbuser fixed it and the upgrade completed. It was not needed for the 1.7.0.4 > 1.7.0.5 > 1.7.0.6 upgrades... Link to comment Share on other sites More sharing options...
bellini13 Posted April 4, 2017 Share Posted April 4, 2017 Ours turned out to be a permission to do with INDEX in the database, adding that for the dbuser fixed it and the upgrade completed. It was not needed for the 1.7.0.4 > 1.7.0.5 > 1.7.0.6 upgrades... To avoid confusion, you likely had a different issue. The issue in the OP is very specific Link to comment Share on other sites More sharing options...
sennevb Posted April 7, 2017 Author Share Posted April 7, 2017 (edited) It is complaining that you have a record in the ps_tab database table, whose character length is too long. If I had to guess, you have a module installed that added a new back office tab, and the name of the icon for that tab exceeds 32 characters. Use phpmyadmin to review the existing records and locate the record causing the issue. Once you locate the record, then note if the module column is null or not will check this out, keep you posted! edit: all records are smaller then 64 chars , where do you get 32 chars?? only thing longer then 32 chars is AdminParentCustomerPreferences Edited April 7, 2017 by sennevb (see edit history) Link to comment Share on other sites More sharing options...
sennevb Posted April 7, 2017 Author Share Posted April 7, 2017 Ours turned out to be a permission to do with INDEX in the database, adding that for the dbuser fixed it and the upgrade completed. It was not needed for the 1.7.0.4 > 1.7.0.5 > 1.7.0.6 upgrades... Can you exactly tell me what you did?? Link to comment Share on other sites More sharing options...
whoey Posted April 7, 2017 Share Posted April 7, 2017 (edited) Can you exactly tell me what you did?? ours was not entirely related as mentioned, I am now getting the same ps_tab error trying to roll back to 1.7.0.6 <facepalm> Edited April 7, 2017 by whoey (see edit history) Link to comment Share on other sites More sharing options...
v2910 Posted April 7, 2017 Share Posted April 7, 2017 Managed to rollback to 1.7.0.6. Howto Restore back to 1.7.0.6 Manually : 1. Download complete PS root folder. 2. Delete all files in root 3. Upload all files from /admin/autoupgrade/backup/ Last Backup Folder to root 4. Delete all tables in DB 5. Run the DB Backups from /admin/autoupgrade/backup/ folder as script in phpMyAdmin 6. Go back to your uploaded files and ensure to change recursively files & folder permissions. All files to have 644 permissions & all folders to have 755 permissions. 7. Login to your BO & remove 1-Click Upgrade Module. 8. Download the latest 1-Click Upgrade Module from PS Addons Website and uploaded. You are set with your 1.7.0.6 again. And also managed to upgrade to PS v1.7.1.0 using 1-Click Upgrade v2.0.8 without any problems. Hope this helps. Link to comment Share on other sites More sharing options...
bellini13 Posted April 8, 2017 Share Posted April 8, 2017 will check this out, keep you posted! edit: all records are smaller then 64 chars , where do you get 32 chars?? only thing longer then 32 chars is AdminParentCustomerPreferences The error specifically states that it failed to update the icon column to a varchar(32), which is 32 characters CHANGE icon icon VARCHAR(32) NOT NULL Link to comment Share on other sites More sharing options...
sennevb Posted April 8, 2017 Author Share Posted April 8, 2017 yeah i misread that, i just checked, all icon values are shorter then 32 chars Link to comment Share on other sites More sharing options...
bellini13 Posted April 9, 2017 Share Posted April 9, 2017 then try the upgrade again and see if it still fails with the same error. perhaps the icon value has since changed Link to comment Share on other sites More sharing options...
sennevb Posted April 9, 2017 Author Share Posted April 9, 2017 allready tried, no help..We need someone from prestashop looking into this Think we need to submit a PR in forge... Link to comment Share on other sites More sharing options...
munzirtaha Posted April 10, 2017 Share Posted April 10, 2017 I faced this very same problems a couple of days ago and filed a bug at http://forge.prestashop.com/browse/BOOM-2809 Please, see if you can add any more information Link to comment Share on other sites More sharing options...
bellini13 Posted April 10, 2017 Share Posted April 10, 2017 allready tried, no help.. We need someone from prestashop looking into this Think we need to submit a PR in forge... Then submit one Link to comment Share on other sites More sharing options...
sennevb Posted April 10, 2017 Author Share Posted April 10, 2017 will be fixed in next version: http://forge.prestashop.com/browse/BOOM-2809 Link to comment Share on other sites More sharing options...
MarekVo Posted April 11, 2017 Share Posted April 11, 2017 Hello, we have the same problem. we would like to upgrade our prestashop from version 1.7.0.6 to version 1.7.1. But we can not, because we have this error messege: Activity log: 10255 files left to upgrade. [Ajax / Server Error for action upgradeFiles] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " " -------- Directory /vendor/composer/ca-bundle/res already exists. Copied /vendor/composer/ca-bundle/res/cacert.pem. 10255 files left to upgrade. Do you know where could be the the problem ? Thanks & Regards Link to comment Share on other sites More sharing options...
dango1 Posted April 26, 2017 Share Posted April 26, 2017 Hi, I had exactly the same problem today (from 1.7.0.6 to 1.7.1) with 1-click-upgrade, as quoted below, with exactly the same error message: Activity log: 10255 files left to upgrade. [Ajax / Server Error for action upgradeFiles] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " " -------- The restore function (button) didn't work, only resulting in a new error line, reproduceable (that one I've forgotten to note). The site access was broken then, had to restore manually the database and the files. And I can't figure out how you resolved that issue, without ending up in a loop, restoring manualy again and again... Any hint will be really appreciated, thank you for your time. Link to comment Share on other sites More sharing options...
bellini13 Posted April 26, 2017 Share Posted April 26, 2017 its possible that the upgrade process takes too long and times out, which could be a server configuration issue, especially if you are on a shared hosting server. I would suggest you take your own backups, and disable both the database and image backups during the upgrade. It is not necessary, and could take a long time depending on the size of the database, and how many images you have. Link to comment Share on other sites More sharing options...
dango1 Posted April 27, 2017 Share Posted April 27, 2017 Thank you for your reply and your advice! Link to comment Share on other sites More sharing options...
breda_Mcg Posted June 21, 2017 Share Posted June 21, 2017 I'm probably missing something really obvious but where is the upgrade module in version 1.7.1? I remember in 1.6 there was one. thanks, Breda Link to comment Share on other sites More sharing options...
bellini13 Posted June 21, 2017 Share Posted June 21, 2017 search the PS addons store for upgrade module Link to comment Share on other sites More sharing options...
breda_Mcg Posted June 22, 2017 Share Posted June 22, 2017 Great thanks, B Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now