mir Posted October 8, 2019 Share Posted October 8, 2019 (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 October 14, 2019 by mir (see edit history) Link to comment Share on other sites More sharing options...
Rhobur Posted October 12, 2019 Share Posted October 12, 2019 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 3 1 Link to comment Share on other sites More sharing options...
mir Posted October 14, 2019 Author Share Posted October 14, 2019 thank you so much Rhobur! Link to comment Share on other sites More sharing options...
Rhobur Posted October 14, 2019 Share Posted October 14, 2019 You're welcome! Did it solve your problem? If so, we can mark this as SOLVED to help other people with the same issue. 1 Link to comment Share on other sites More sharing options...
mir Posted October 14, 2019 Author Share Posted October 14, 2019 yes it helped 🙂 Link to comment Share on other sites More sharing options...
Rhobur Posted October 14, 2019 Share Posted October 14, 2019 Glad to hear, please edit your first post and add [SOLVED] before the title. Link to comment Share on other sites More sharing options...
FeliCati Posted November 18, 2019 Share Posted November 18, 2019 hi @Rhobur, I have the same problem, could you share the .sql file again? thanks Link to comment Share on other sites More sharing options...
selectshop.at Posted November 18, 2019 Share Posted November 18, 2019 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. Link to comment Share on other sites More sharing options...
1062287_1508430735 Posted December 11, 2019 Share Posted December 11, 2019 On 11/18/2019 at 2:07 PM, selectshop.at said: You can download it from post #2. The ressource is not available. Would be really appreciated if someone could upload this. I am desperate Link to comment Share on other sites More sharing options...
selectshop.at Posted December 11, 2019 Share Posted December 11, 2019 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. Link to comment Share on other sites More sharing options...
1062287_1508430735 Posted December 11, 2019 Share Posted December 11, 2019 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? Link to comment Share on other sites More sharing options...
selectshop.at Posted December 11, 2019 Share Posted December 11, 2019 Import the file with phpmyadmin = execute the query. So problem should be solved, or not ? Link to comment Share on other sites More sharing options...
1062287_1508430735 Posted December 11, 2019 Share Posted December 11, 2019 (edited) 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 December 11, 2019 by 1062287_1508430735 (see edit history) Link to comment Share on other sites More sharing options...
selectshop.at Posted December 11, 2019 Share Posted December 11, 2019 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. Link to comment Share on other sites More sharing options...
1062287_1508430735 Posted December 16, 2019 Share Posted December 16, 2019 (edited) On 12/11/2019 at 11:20 PM, selectshop.at said: 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. Successfully deleted the duplicate entry from the table and it would work until I tried to access a specific category. The same entry which causes the problem is created again when accessing said category. The entry that is generated: {"orderBy":"position","sortOrder":"asc","limit":50,"filters":{"id_category_parent":"2"}} It is the last entry with ID 64 that is created at each request to access a category. I tried to remove the filter_id "category" for id 60 and it would work again, but the same entry is then created again at id 64. I did delete both entry 60 and 64. The exact same exception is thrown. How would I stop this entry from being made? Edited December 16, 2019 by 1062287_1508430735 (see edit history) Link to comment Share on other sites More sharing options...
selectshop.at Posted December 16, 2019 Share Posted December 16, 2019 Something is duplicating the entries. You should disable all modules and or services you are using, which are not Prestashop native. Re-enable one per one and check which one is duplicating entries into your database. This one should be debugged. I'm sure it's not a native Prestashop module or service duplicating the entries. Link to comment Share on other sites More sharing options...
misty1234 Posted October 20, 2020 Share Posted October 20, 2020 Hello! Can I use this table from post #2 also in presta shop version 1.7.6.8 ? Thanks! Link to comment Share on other sites More sharing options...
peperodartelopez Posted February 19, 2021 Share Posted February 19, 2021 On 10/12/2019 at 2:32 AM, Rhobur said: 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 3 kB · 159 downloads Can you tell me where I can run this file?? I've already import to my phpAdmin (using the database for ps) but I can't pass the "install shop" with the wizard Link to comment Share on other sites More sharing options...
Aufix Posted July 9, 2022 Share Posted July 9, 2022 Hello I have a similar error in my prestashop 1.7.7.0 and wanted to ask for your help to point me in the right direction to fix it. The error is displayed when I access the order window. From what I can understand from the error there must be a column missing but I am not able to determine which one it is. Could someone please looking at the error tell me what it might be? Thanks in advance! Link to comment Share on other sites More sharing options...
Prestachamps Posted July 9, 2022 Share Posted July 9, 2022 Hi, It looks that the tc_orders table is missing id_order column. If you have i stalled lately some order related moduke try to disable it. Have a nice day, Leo. Link to comment Share on other sites More sharing options...
Aufix Posted July 9, 2022 Share Posted July 9, 2022 Hi, Thanks for the help Leo! With your answer, you have given me the possibility to move forward with this error that had me blocked for not knowing how to proceed. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now