Problem when i upgraded PS to 1.5.6.0 through softaculous

suteibi · October 8, 2013

HI,

i received an email to upgrade my PS version to 1.5.6.0, i followed the instructions exactly by logging into my cPanel and do the necessary upgrade (i also took a backup), when i finished the upgrade, it said " Please visit below link to complete the upgrade process. http://q8-mart.com/install/upgrade/upgrade.php " i did click on this link and got the attached screen shot, also when i tried to log in to my PS, i got a message saying that for security reasons, i cant log in to PS, and there is something was deleted. please assist me since i cant log in to my PS any more.

please find the other attachments as well

this is what i get when i click the link i mentioned :

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<action result="ok" error="">
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
ALTER TABLE `ps_manufacturer_lang` CHANGE `short_description` `short_description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blockcart, actionCartListOverride); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blockmanufacturer, actionObjectManufacturerDeleteAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blockmanufacturer, actionObjectManufacturerAddAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blockmanufacturer, actionObjectManufacturerUpdateAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blocksupplier, actionObjectSupplierDeleteAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blocksupplier, actionObjectSupplierAddAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blocksupplier, actionObjectSupplierUpdateAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blockmyaccount, actionModuleRegisterHookAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blockmyaccountfooter, actionModuleRegisterHookAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blockmyaccount, actionModuleUnRegisterHookAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
/* PHP:add_module_to_hook(blockmyaccountfooter, actionModuleUnRegisterHookAfter); */
]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[ /* PHP:remove_tab(AdminRangePrice); */ ]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[ /* PHP:remove_tab(AdminRangeWeight); */ ]]>
</sqlQuery>
</request>
<request result="ok" sqlfile="1.5.6.0">
<sqlQuery>
<![CDATA[
UPDATE `ps_employee` SET default_tab = (SELECT `id_tab` FROM `ps_tab` WHERE `class_name` LIKE 'AdminOrders' LIMIT 0 , 1) WHERE default_tab = 0
]]>
</sqlQuery>
</request>
</action>
 
 
 
 
 
 
thank you 

benjamin utterback · October 8, 2013

The first thing you should do is reinstate your database backup and PrestaShop back up.

Second thing you should do is never upgrade a live store before testing the upgrade on a duplicate test store on a subdomain.

Are you able to reinstate your back up?

suteibi · October 8, 2013

i did restore the backup, and the version went back to 1.5.5.0 but still cant log to my PS.

it says for security reasons i cant log in to PS

benjamin utterback · October 8, 2013

You restored your database and PrestaShop files both?

What is the error exactly?

suteibi · October 8, 2013

i restored both, and the restore went fine, and i saw that the version changed back to 1.5.5.0 on "all installation" in softaculous, then i tried to log in to my PS, i got the a message saying that for security reasons, i cant log in to PS, and the install folder was deleted.

Q8-Mart

لأسباب أمنية ، لا يمكنك الاتصال إلى مكتب حتى بعد عودة لديك :

تم حذف مجلد install

Please then access this page by the new URL (e.g. https://q8-mart.com/admin123/)

you can us Google translate to translate from Arabic to English

suteibi · October 8, 2013

i restored the back up again and got the following after trying to connect to my PS :

[PrestaShopDatabaseException]

Table 'qmartcom_pres134.ps_shop_url' doesn't exist

SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
                    FROM ps_shop_url su
                    LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
                    WHERE (su.domain = 'q8-mart.com' OR su.domain_ssl = 'q8-mart.com')
                        AND s.active = 1
                        AND s.deleted = 0
                    ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
at line 613 in file classes/db/Db.php

607. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608.         }
609.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610.         {
611.             if ($sql)
612.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613.             throw new PrestaShopDatabaseException($this->getMsgError());
614.         }
615.     }
616.
617.     /**

DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 315 - classes/shop/Shop.php] - [1 Arguments]
ShopCore::initialize - [line 95 - config/config.inc.php] - [0 Argument]
require - [line 30 - admin123/index.php] - [1 Arguments]

benjamin utterback · October 8, 2013

Can you check your database tables within ps_shop_url

make sure your domain and domain_ssl are correct.

What URL are you trying to use this database into?

suteibi · October 8, 2013

well, I am not a pro , but i logged into my database and checked ps_shop_url , also i found the domain & domain_ssl, but what should i do exactly ?

also i didnt understand your last question " What URL are you trying to use this database into? "

thank you for your help

benjamin utterback · October 8, 2013

Two questions!

What is the URL you are trying to use to access your store?

What is the URL's that are inputted into the tables within ps_shop_url

suteibi · October 9, 2013

Hi Benjamin,

i emailed A2 Hosting Team yesterday regarding the same issue, and today i received another email from one of the technical support representatives saying

"I have removed the install folder as prestashop has requested. You should now be able to login once again."

now everything is working fine.

thank you for your assistance my friend

Sign In

Problem when i upgraded PS to 1.5.6.0 through softaculous

Recommended Posts

suteibi

Link to comment

Share on other sites

benjamin utterback

Link to comment

Share on other sites

suteibi

Link to comment

Share on other sites

benjamin utterback

Link to comment

Share on other sites

suteibi

Link to comment

Share on other sites

suteibi

Link to comment

Share on other sites

benjamin utterback

Link to comment

Share on other sites

suteibi

Link to comment

Share on other sites

benjamin utterback

Link to comment

Share on other sites

suteibi

Link to comment

Share on other sites

Browse

Activity

Go back to prestashop.com