Jump to content

Error while loading SQL upgrade file "index.php.sql" PS upgrade 1.7.1.0


omine

Recommended Posts

Upgrading from 1.6.1.12 to 1.7.1.0 stuck on "Disabling modules now..."

 

Before the "Database upgrade" action, 2 errors are displayed:

Error while loading SQL upgrade file "index.php.sql".

 

Error while loading SQL upgrade file "index.php.sql".

 

(see attached file)

post-511789-0-12889300-1491406552_thumb.png

 

Despite the error, i tried to access other pages but the authentication automatically redirects to BackOffice login page.

 

I can see the version was changed to 1.7.0.1 but cannot enter .

 

The login seems authenticating but something forcing back to login page again.

 

 

 

When enabling the debug mode:

PrestaShopDatabaseException in Db.php line 744:Table 'pe_jp_db.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>
Edited by omine (see edit history)
Link to comment
Share on other sites

I found the sql files into upgrade/sql folder

 

This folder is inside a folder named "autoupg-inst-58e507769c2d0"

 

After execute some obvious SQL files, i've entered on BackOffice.

 

However, of course, nothing is working and have millions of errors, things not loaded, missing files, etc. 
I give up.. this version is too far to be reliable.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...