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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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