Upgrading issue

[Budrys]

Hello.

 

I want to upgrade PS 1.6.23 to 1.7.0.0.

 

I started upgrading process and got:

 

Error during database upgrade. You may need to restore your database.
You already have the 1.7.0.0 version.

 

 

Now I can't login to BO.

 

Any idea what to do now?

[Chill_user]

1. Try to make a backup

2. Try to switch on debug mode to see errors and try to fix it.(Switch on debug via FTP)

 

[Budrys]

I have error:

 

PrestaShopDatabaseException in Db.php line 744:Table 'galax_sklep7.ps_authorization_role' doesn't exist<br /><br /><pre>
SELECT `slug`,
`slug` LIKE "%CREATE" as "add",
`slug` LIKE "%READ" as "view",
`slug` LIKE "%UPDATE" as "edit",
`slug` LIKE "%DELETE" as "delete"
FROM `ps_authorization_role` a
LEFT JOIN `ps_access` j ON j.id_authorization_role = a.id_authorization_role
WHERE j.`id_profile` = 0</pre>

[Budrys]

I will create that table.

[Budrys]

Table created.

 

Error:

 

PrestaShopDatabaseException in Db.php line 744:Nieznana kolumna 'j.id_authorization_role' w on clause<br /><br /><pre>
SELECT `slug`,
`slug` LIKE "%CREATE" as "add",
`slug` LIKE "%READ" as "view",
`slug` LIKE "%UPDATE" as "edit",
`slug` LIKE "%DELETE" as "delete"
FROM `ps_authorization_role` a
LEFT JOIN `ps_access` j ON j.id_authorization_role = a.id_authorization_role
WHERE j.`id_profile` = 0</pre>

in Db.php line 744

at DbCore->displayError(' SELECT `slug`, `slug` LIKE "%CREATE" as "add", `slug` LIKE "%READ" as "view", `slug` LIKE "%UPDATE" as "edit", `slug` LIKE "%DELETE" as "delete" FROM `ps_authorization_role` a LEFT JOIN `ps_access` j ON j.id_authorization_role = a.id_authorization_role WHERE j.`id_profile` = 0') in Db.php line 378

at DbCore->query(' SELECT `slug`, `slug` LIKE "%CREATE" as "add", `slug` LIKE "%READ" as "view", `slug` LIKE "%UPDATE" as "edit", `slug` LIKE "%DELETE" as "delete" FROM `ps_authorization_role` a LEFT JOIN `ps_access` j ON j.id_authorization_role = a.id_authorization_role WHERE j.`id_profile` = 0') in Db.php line 596

at DbCore->executeS(' SELECT `slug`, `slug` LIKE "%CREATE" as "add", `slug` LIKE "%READ" as "view", `slug` LIKE "%UPDATE" as "edit", `slug` LIKE "%DELETE" as "delete" FROM `ps_authorization_role` a LEFT JOIN `ps_access` j ON j.id_authorization_role = a.id_authorization_role WHERE j.`id_profile` = 0') in Profile.php line 172

at ProfileCore::getProfileAccesses(null) in Profile.php line 114

at ProfileCore::getProfileAccess(null, '81') in AdminController.php line 524

at AdminControllerCore->__construct() in LegacyContext.php line 55

at LegacyContext->getContext() in EmployeeProvider.php line 50

at EmployeeProvider->__construct(object(LegacyContext)) in appDevDebugProjectContainer.php line 3234

at appDevDebugProjectContainer->getPrestashop_Security_Admin_ProviderService() in bootstrap.php.cache line 2222

at Container->get('prestashop.security.admin.provider') in appDevDebugProjectContainer.php line 2799

at appDevDebugProjectContainer->getPrestashop_Adapter_Security_AdminService() in bootstrap.php.cache line 2222

at Container->get('prestashop.adapter.security.admin') in classes.php line 1957

at ContainerAwareEventDispatcher->lazyLoad('kernel.request') in classes.php line 1925

at ContainerAwareEventDispatcher->getListeners('kernel.request') in TraceableEventDispatcher.php line 245

at TraceableEventDispatcher->preProcess('kernel.request') in TraceableEventDispatcher.php line 135

at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent)) in bootstrap.php.cache line 3227

at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3197

at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3351

at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2536

at Kernel->handle(object(Request), '1', false) in index.php line 86

[Budrys]

OK. I fixed that.

 

But even when I change my password I got info it is wrong.

[Budrys]

I'm going to restore my whole site.

 

Maybe I shoupd upgrade from 1.6.23 to another 1.7 version?

[Budrys]

Trying upgrade to 1.7.2.

 

Got error:

 

[ERROR] PHP 1.7.0.0 /* PHP:ps1700_stores(); */[INTERNAL] /home/galax/domains/galax.ssd-linuxpl.com/public_html/src/PrestaShopBundle/Install/Install.php line 56 - Cannot use PrestaShopBundle\Service\Database\Upgrade as Upgrade because the name is already in use

[harryjacob]

18 hours ago, Budrys said:

I'm going to restore my whole site.

 

Maybe I shoupd upgrade from 1.6.23 to another 1.7 version?

I think 1.7 version is better! Prestashop 1.7.6 is just released, you should read this article: http://bit.ly/2J0tmM2

Edited October 18, 2019 by harryjacob (see edit history)

[Budrys]

OK. I will try update to 1.7.6

 

[Budrys]

Updated to 1.7.6

[Budrys]

Get one issue so far. In BO on Module subpage I get:

Attempted to load class "ImportModule" from the global namespace.
Did you forget a "use" statement?

n modules/shopimporter/shopimporter.php (line 30)

*/

if (!defined('_PS_VERSION_'))

    exit;

class shopimporter extends ImportModule

{

    public $supportedImports = array();

    public function __construct()

    {

 

 

[Budrys]

Front Page is also disabled - https://galax.ssd-linuxpl.com/

[Budrys]

WHen I try now to upgrade any module I get :

 

Warning: include_once(/home/galax/domains/galax.ssd-linuxpl.com/public_html/classes/../tools/pear/PEAR.php): failed to open stream: No such file or directory

[harryjacob]

you config a wrong module path so you get an error "no file or directory checked". You try to disable the module "blockbanner" and open it again, then remember to clear cache. Is it ok?

[Budrys]

I did that so I could upgrade that module blockbanner

 

What about rest of modules?

[Budrys]

I fixed all this issues

 

But have something different.

 

When I try to access some webpages on BO I am displayed with dashboard:

-Shop parameters - General, Order performance

- Adwanced parameters - Administration