Jump to content
mir

[SOLVED] problem backend after update 1.7.3.1 to 1.7.6.1

Recommended Posts

Posted (edited)

Hi everyone,

I have a problem with the backend of my store since the update  1.7.3.1 to 1.7.6.1. It seems to be that the update is missed some tables in the database, is there a way to fix this? I can log in to the backend, but on some pages, like the product page, i get a server error.

Quote

Uncaught Exception: An exception occurred while executing 'SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM cecf_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1' with params [1, 1, "category", "index"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list'

Quote

Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM cecf_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1' with params [1, 1, "category", "index"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list'" at /home/public/sites/www.gessicadancewear.nl/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71

I hope someone can help me with this, i have no idea how to solve the problem.

best regards, mirjam

Edited by mir (see edit history)

Share this post


Link to post
Share on other sites

you seem to be missing the column filter_id from the cecf_admin_filter table for some reason; here you have attached the PS1.7.6.1 version of this table, you can import it instead of your current one. 

ps_admin_filter.sql

  • Like 1

Share this post


Link to post
Share on other sites

You're welcome! Did it solve your problem?

If so, we can mark this as SOLVED to help other people with the same issue.

Share this post


Link to post
Share on other sites

Glad to hear, please edit your first post and add [SOLVED] before the title.

Share this post


Link to post
Share on other sites
44 minutes ago, FeliCati said:

hi @Rhobur

I have the same problem, could you share the .sql file again?

thanks

You can download it from post #2.

Share this post


Link to post
Share on other sites
12 minutes ago, 1062287_1508430735 said:

The ressource is now available. Would be really appreciated if someone could upload this. I am desperate

Download it from post #2, import it in phpmyadmin and execute the query with phpmyadmin. Or what exactly is your problem with the file attached to post#2 ?

If you don't know how to work with phpmyadmin, ask your hosting provider or contract somebody as a paid job to do it for you.

Share this post


Link to post
Share on other sites
7 minutes ago, selectshop.at said:

Download it from post #2, import it in phpmyadmin and execute the query with phpmyadmin. Or what exactly is your problem with the file attached to post#2 ?

Thank you for the reply. Managed to download the file and import to my database. What do you exactly mean by executing the query?

Share this post


Link to post
Share on other sites

Receiving this error when trying to access "Categories" tab.

An exception occurred while executing 'INSERT INTO clk_700a0e2195_admin_filter (employee, shop, controller, action, filter, filter_id) VALUES (?, ?, ?, ?, ?, ?)' with params [1, 1, "", "", "{\"orderBy\":\"position\",\"sortOrder\":\"asc\",\"limit\":50,\"filters\":{\"id_category_parent\":\"2\"}}", "category"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-1---category' for key 'admin_filter_search_id_idx'

 

Edited by 1062287_1508430735 (see edit history)

Share this post


Link to post
Share on other sites

Duplicate entry means that you have the same data for same ID (category) in clk_700a0e2195_admin_filter. You need to delete one of the same line with same data.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More