Update to 4.6 Error

[Rosenthaler]

Hi

I can't update the sql database i get following error:

Error: Failed to run the SQL query.Duplicate column name \'Session_hash\'
Error: Failed to run the SQL query.Table \'db446020_72.{db_prefix}listing_photos\' doesn\'t exist
Error: Failed to run the SQL query.Table \'db446020_72.{db_prefix}payment_gateways\' doesn\'t exist
Error: Failed to run the SQL query.Table \'db446020_72.{db_prefix}payment_gateways\' doesn\'t exist
Error: Failed to run the SQL query.Table \'db446020_72.{db_prefix}blocks\' doesn\'t exist
The MySQL dump has corrupt queries; importing the new language has failed.

How can i fix this?

[tassonfl]

I also have the same problem.
Thank you

[Viktor]

Hello Tobias and Floro,

Would you please explain me how did you run this mysql file?
You need to do it through Admin Panel >> Database then click Import button and choose mysql file from patch.

[Mahmood Al lawati]

i have the same error

and yes viktor this error appears in the admin after importing

2584

[tassonfl]

Thank you, yes from Admin Panel >> Database >> Import

[Mohammed Elbadawi]

Sam problem

[Bright Adams]

The same problem and because I cannot upgrade my site and I restore back as preview version, I hope Flynax Developer they should try to have a Plugin in Admin which can upgrade the whole site, special when the update detected via Admin Panel

[Mahmood Al lawati]

is there a solution to this error??

[David Da silva]

i have the same error, in fresh instalation

[Wei Hong]

i have the same error, in fresh instalation

try to redownload the package. It's included in installation now. So no more update.sql needed to update in admincp

[Vitas Loda]

just rename "{db_prefix}" in update sql file to "fl_" (your database table prefix you use) befor import update

[Mousa Lotfi]

Please solve the problem. An update is not possible. Update sql file will not be imported.

[Mousa Lotfi]

The problem was solved
I used version 4.5.1 I first updated to version 4.5.2 and then to 4.6.0. The problem was resolved.

[Mohammed Elbadawi]

please explain with more details

[Mohammed Elbadawi]

5. Go to the Admin Panel > Database and click the "Import" button (top left corner) > select the SQL file from the patch main folder: sql_update.sql, and click the GO button.
You also can apply the SQL update through a database manager like phpmyadmin by replacing {sql_prefix} with the correct SQL prefix used in your database.

please explain with more detail