sheepstations Posted September 2, 2017 Share Posted September 2, 2017 Hello, I am attempting to upgrade from 1.7.2.0 to 1.7.2.2 and I'm using the latest version of 1Click Upgrade 3.0.3. Everything goes smoothly until the very end of the process when I get the following error. I've tried the process twice and it stumbles at this last step both times. All files upgraded. Now upgrading database...... [Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " " Can anyone suggest a solution for this please? Thanks, JR Link to comment Share on other sites More sharing options...
bellini13 Posted September 3, 2017 Share Posted September 3, 2017 first thing you should do is locate your servers php error log, apache or nginx error log, and check for errors. however the most common upgrade failure is a simple php process timeout, meaning the process took longer than your server is configured to allow for. Link to comment Share on other sites More sharing options...
CMTECH Posted October 22, 2017 Share Posted October 22, 2017 Same issue here. No specials logs in php/apache/mysql logs. On web host I had 3600 seconds and it fails after ~ 2 minutes so not the issue. On localhost with no limits same issue. Checked the chorme network logs when updating : Lots of ok requests like this : Request URL:http://localhost:8888/admin4997e7eo5/autoupgrade/ajax-upgradetab.php Request Method:POST Status Code:200 OK Then suddenly : Request URL:http://localhost:8888/admin4997e7eo5/autoupgrade/ajax-upgradetab.php Request Method:POST Status Code:503 Service Unavailable Like if the server stopped, but it didn't, no errors in logs... After that front is still working but admin gives a 500. It happens at everytime at the same exact step... Link to comment Share on other sites More sharing options...
bellini13 Posted October 22, 2017 Share Posted October 22, 2017 4 hours ago, CMTECH said: On web host I had 3600 seconds and it fails after ~ 2 minutes so not the issue. You are receiving an error 503, which is defined below. I bolded the important piece Quote 10.5.4 503 Service Unavailable. The server is currently unable to handle the request due to a temporary overloading or maintenance of the server. The implication is that this is a temporary condition which will be alleviated after some delay. If known, the length of the delay MAY be indicated in a Retry-After header. You are likely on a server that is not properly configured or has shared resource restrictions. You need to speak with your hosting provider about this. Link to comment Share on other sites More sharing options...
CMTECH Posted October 23, 2017 Share Posted October 23, 2017 5 hours ago, bellini13 said: You are receiving an error 503, which is defined below. I bolded the important piece You are likely on a server that is not properly configured or has shared resource restrictions. You need to speak with your hosting provider about this. Hi bellini, here is the retry after : Retry-After:3600 As stated before, I'm pretty sure it's not server related. On localhost I have no limits and on my provider I've an option to remove limits for one hour for this kind of uses, which was activated. Link to comment Share on other sites More sharing options...
bellini13 Posted October 23, 2017 Share Posted October 23, 2017 I would bet that the issue is server related. If you want to send me an export of your database, as well as your website content, I will put it on my demo server and attempt the upgrade and see if a 503 is received, or if the upgrade completes successfully. If it is successful, I'll even give you the database export and the updated store content so you can just put it on your server. Assuming all goes well, I'll invoice you $40 for the usage of my server resources and my time. Link to comment Share on other sites More sharing options...
markaussie Posted October 23, 2017 Share Posted October 23, 2017 Hi looking into this error as well on a different post feel free to add to my post any feedback suspect it's related, thanks Below is just one of the ways I can reproduce error with the the PHP error log. I will try and relook at when I get a bit of free time - Hope it helps I think it will be an easy tweak to fix. #2 Working from 1.6.1.17 to 1.7.2.0 only then failed at further upgrade to 1.7.2.3 - Downgrade 1clickmodule to (1.6.7) in 1.6.1.17 from build.prestashop.com from article about a year old - choose major and follow prompts - It upgraded to 1.7.2.0 Tried to upgrade 1.7.2.0 via latest updated 1clickupgrade module (3.0.3) and it failed at database upgrade (same error as before) - [Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " " PHP error [22-Oct-2017 17:04:59 Europe/Paris] PHP Notice: Use of undefined constant _PS_INSTALL_LANGS_PATH_ - assumed '_PS_INSTALL_LANGS_PATH_' in C:\xampp\htdocs\prestashop\src\PrestaShopBundle\Install\LanguageList.php on line 68 [22-Oct-2017 17:04:59 Europe/Paris] PHP Fatal error: Uncaught Error: Class 'PrestashopInstallerException' not found in C:\xampp\htdocs\prestashop\src\PrestaShopBundle\Install\LanguageList.php:69 Stack trace: #0 C:\xampp\htdocs\prestashop\src\PrestaShopBundle\Install\LanguageList.php(60): PrestaShopBundle\Install\LanguageList->__construct() #1 C:\xampp\htdocs\prestashop\admin1234\autoupgrade\latest\install\upgrade\php\migrate_tabs_17.php(56): PrestaShopBundle\Install\LanguageList::getInstance() #2 C:\xampp\htdocs\prestashop\modules\autoupgrade\AdminSelfUpgrade.php(2312): migrate_tabs_17() #3 C:\xampp\htdocs\prestashop\modules\autoupgrade\AdminSelfUpgrade.php(1992): AdminSelfUpgrade->doUpgrade() #4 C:\xampp\htdocs\prestashop\admin1234\autoupgrade\ajax-upgradetab.php(90): AdminSelfUpgrade->ajaxProcessUpgradeDb() #5 {main} thrown in C:\xampp\htdocs\prestashop\src\PrestaShopBundle\Install\LanguageList.php on line 69 Link to comment Share on other sites More sharing options...
daleykd Posted February 2, 2018 Share Posted February 2, 2018 I posted my fix on markaussie's thread. I've been hammering away at this for a couple days now and wanted to share what I found out. When you use the beta autoupgrader to go from 1.6.x to 1.7.x, it fails to update the PS_VERSION_DB in the `configuration` table. Therefore, when you try and run the next upgrade, (e.g. 1.7.2.0 to 1.7.2.4), it tries to rerun ALL of the .sql files from the currently set PS_VERSION_DB to the last .sql version. In my case, that would execute the SQL files 1.6.1.0.sql thru 1.7.2.1.sql, when all I needed was a single file, 1.7.2.1.sql, to be executed. Things I did to finally upgrade straight from 1.6.0.14 to 1.7.2.0, then to 1.7.2.4: Make sure I added a Store. Use the beta autoupgrader to go from 1.6.0.14 to 1.7.2.0. After upgrade to 1.7.2.0, in the actual database, set PS_VERSION_DB to 1.7.2.0. Fully uninstall any unnecessary / unsupported modules that I won't use any more. Any legacy modules that I do hope to use, I moved their physical folder out of the /modules directory to a temporary directory. (Be sure to get rid of upscarrier and uspscarrier, too!) Cleared the cache. Updated the 1-Click Auto Updater to 3.0.3. Try the upgrade to 1.7.2.4. If successful, verify PS_VERSION_DB. This is where I'm at as of now and hope to continue with my testing of the upgrade and all the other tweaks that will be necessary. One other thing to note: a clean install of 1.7.x will show the 1-Click Upgrade in the left nav, but the upgrade doesn't. To get around this, I had to uninstall/reinstall the module. However, that has a bug in itself, too. If you do this, be sure you go into the file system and set the folders to 755 and the files to 644 permissions for /modules/autoupgrader and /prestaadmin/autoupgrader (and all subdirectories). 1 Link to comment Share on other sites More sharing options...
webplus Posted March 6, 2018 Share Posted March 6, 2018 I also had the issue with error: [Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " After long testing on localhost, I finally managed to upgrade (from 1.7.2.5 to 1.7.3, autoupgrade module 3.0.4). The trick was, that I had to switch to default theme first and then it worked. It didn't work when I tried to upgrade with my custom theme enabled. This always worked before (I keep upgrading since 1.7.1) Hope this will help you Prestashop to find the issue and fix it. Link to comment Share on other sites More sharing options...
Abbesnabb Posted March 7, 2018 Share Posted March 7, 2018 Tanks alot. Switch to default theme before upgrade. Worked like a charm (1.7.2.5 to 1.7.3.0). Link to comment Share on other sites More sharing options...
abhala Posted March 23, 2018 Share Posted March 23, 2018 Alle Dateien aktualisiert. Aktualisiere jetzt die Datenbank... [Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " " I got the error too, using default classic theme (there is not other theme installed) by using 1 Click Upgrade module 3.04 trying to update Presta 1.7.2.4 to 1.7.3.0. Copy on local server got the same error. Order and file permission checked. Max execution time = 6000 on local server. Any idea? Link to comment Share on other sites More sharing options...
bellini13 Posted March 23, 2018 Share Posted March 23, 2018 locate your servers error log and locate the actual error Link to comment Share on other sites More sharing options...
jonyis Posted March 16, 2020 Share Posted March 16, 2020 I've tried it at least 20 times. it always resulted in the same "Internal Server Error" jqXHR: ".I have found that the problem occurs when the server is busy. Everything went smoothly when the server was little used. No other procedure helped in my case to upgrade. Before upgrading, make a backup of the database and files through a 1-click update. Link to comment Share on other sites More sharing options...
AdriC Posted March 22, 2020 Share Posted March 22, 2020 (edited) Hi all, I just upgraded a website from 1.7.6.1 to 1.7.6.4 with 1-Click Upgrade and experienced a similar error. I got the following error: 236 files left to upgrade. All files upgraded. Now upgrading database... Database upgraded. Now upgrading your Addons modules... 64 modules will be upgraded. 61 modules left to upgrade. 57 modules left to upgrade. 53 modules left to upgrade. 52 modules left to upgrade. 49 modules left to upgrade. 44 modules left to upgrade. 40 modules left to upgrade. [Ajax / Server Error for action upgradeModules] textStatus: "error " errorThrown:"Gateway Timeout " jqXHR: " Gateway Timeout The website seems to be working fine, however I am unsure if there are some underlining issues that might arise in the future. What shall I do? Do I revert back via the 1-Click upgrade backup/restore option? Do I revert back from Website Folder and Database Backup? Or, do I keep using this website and hope for the best? Can the modules be upgraded manually? and if so how? Also, will a future upgrade via 1-Click upgrade fix these potential issues? I would really appreciate some feedback, as I am not sure what to do. Thank you in advance, Adri Edited March 22, 2020 by AdriC (see edit history) Link to comment Share on other sites More sharing options...
num47 Posted October 28, 2020 Share Posted October 28, 2020 Ah! No one seems to have a working solution up until now! Link to comment Share on other sites More sharing options...
num47 Posted October 28, 2020 Share Posted October 28, 2020 (edited) I am trying a way using one-click upgrade. But it failed. Edited October 28, 2020 by num47 (see edit history) Link to comment Share on other sites More sharing options...
AndyNZ Posted February 6, 2021 Share Posted February 6, 2021 Same issue here: trying to upgrade from 1.7.6.5 to 1.7.7.1 using latest version of 1-click update. Stops at DB update with timeout. Restore doesn't work either, same Ajax DB timeout. Had to restore manually. Very frustrating that this seems to be a problem now for years... Link to comment Share on other sites More sharing options...
num47 Posted February 6, 2021 Share Posted February 6, 2021 28 minutes ago, AndyNZ said: Same issue here: trying to upgrade from 1.7.6.5 to 1.7.7.1 using latest version of 1-click update. Stops at DB update with timeout. Restore doesn't work either, same Ajax DB timeout. Had to restore manually. Very frustrating that this seems to be a problem now for years... That is your server setting issue. Increase the execution time and the issue you are facing should be fixed. Link to comment Share on other sites More sharing options...
AdriC Posted February 8, 2021 Share Posted February 8, 2021 (edited) On 2/6/2021 at 5:41 PM, num47 said: That is your server setting issue. Increase the execution time and the issue you are facing should be fixed. What values do you suggest for the following variables? memory_limit max_execution_time max_input_time post_max_size Edited February 8, 2021 by AdriC (see edit history) 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