PDA

View Full Version : Update to 4.6 Error



Rosenthaler
October 25, 2017, 04:09 PM
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
October 25, 2017, 05:53 PM
I also have the same problem.
Thank you

Viktor
October 26, 2017, 02:29 AM
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
October 26, 2017, 04:36 AM
i have the same error

and yes viktor this error appears in the admin after importing

2584

tassonfl
October 26, 2017, 05:17 AM
Thank you, yes from Admin Panel >> Database >> Import

Mohammed Elbadawi
October 27, 2017, 09:04 PM
Sam problem

Bright Adams
October 28, 2017, 07:57 PM
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
October 30, 2017, 09:27 AM
is there a solution to this error??

David Da silva
November 24, 2017, 05:43 PM
i have the same error, in fresh instalation

Wei Hong
November 25, 2017, 02:59 AM
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
November 27, 2017, 02:32 PM
just rename "{db_prefix}" in update sql file to "fl_" (your database table prefix you use) befor import update

Mousa Lotfi
November 29, 2017, 06:50 PM
Please solve the problem. An update is not possible. Update sql file will not be imported.

Mousa Lotfi
November 29, 2017, 08:12 PM
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
November 30, 2017, 04:00 AM
please explain with more details

Mohammed Elbadawi
November 30, 2017, 04:04 AM
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