Update to 4.6 Error

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?

I also have the same problem.
Thank you

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.

i have the same error

and yes viktor this error appears in the admin after importing

Attachment 2584

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

Sam problem

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

is there a solution to this error??

i have the same error, in fresh instalation

Quote:

---

Originally Posted by David Da silva

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

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

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

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.

please explain with more details

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