Rahulprbh Posted December 23, 2019 Share Posted December 23, 2019 In my back end when i press products,category tab i'm getting the below error Oops! An Error Occurred The server returned a "500 Internal Server Error". Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused. I don't Know what to do please help me out. I'm using prestashop 1.7.6.2 php version 7.3.6 Link to comment Share on other sites More sharing options...
selectshop.at Posted December 23, 2019 Share Posted December 23, 2019 Activate debug mode and read errors. 500 errors are server error logs. Read them as well and debug the errors of the server. You should have access to these logs via cPanel or Plesk, or FTP specific folder of your hosting root. Link to comment Share on other sites More sharing options...
Rahulprbh Posted December 24, 2019 Author Share Posted December 24, 2019 Hello i activated the debug mode i'm getting the following error And this happened after updating to latest prestashop version Link to comment Share on other sites More sharing options...
selectshop.at Posted December 24, 2019 Share Posted December 24, 2019 1) Access your FTP and delete all folders and files in var/cache. 2) If this does not solve the problem, then access database via phpmyadmin and execute the following query: ALTER TABLE `ps_admin_filter` ADD `filter_id` INT NOT NULL ; 3) If this query also does not work for you and you are getting some more errors with same thing (for ex: Unknown column 'id_contact' in 'order clause', then run the complete query, to add all possible missing things: ALTER TABLE `PREFIX_admin_filter` ADD `filter_id` VARCHAR (255) DEFAULT '' NOT NULL AFTER `shop`, DROP INDEX IF EXISTS `admin_filter_search_idx`, DROP INDEX IF EXISTS `search_idx`, ADD UNIQUE INDEX `admin_filter_search_id_idx` (`employee`, `shop`, `controller`, `action`, `filter_id`) ;``` Theses 3 fixes should solve your problem and extend your database on missing things. 1 Link to comment Share on other sites More sharing options...
DrBre Posted February 19, 2020 Share Posted February 19, 2020 Thanks! This fixed the issue. First time I just copied your line of code and didn't pay attention about the prefix name. Changed that 'ps_ 'with mine 'sp_ ' fixed the issue. Thank you! Link to comment Share on other sites More sharing options...
Rahulprbh Posted February 22, 2020 Author Share Posted February 22, 2020 Hello Thanks It worked for products page. But still i'm not able access some of the pages categories,brands,pages etc below i'm attaching some screenshots if you know the solution please let me know. Thank You Link to comment Share on other sites More sharing options...
JBW Posted February 24, 2020 Share Posted February 24, 2020 On 12/23/2019 at 9:20 AM, Rahulprbh said: php version 7.3.6 Prestashop is not compatible to PHP 7.3 yet - downgrade to 7.2! Link to comment Share on other sites More sharing options...
Rahulprbh Posted February 25, 2020 Author Share Posted February 25, 2020 Hi My php version is 7.0.33 Link to comment Share on other sites More sharing options...
JBW Posted February 25, 2020 Share Posted February 25, 2020 Ok, you wrote PHP 7.3.6. in the initial post. Try the following: 1. Make a DB Backup 2. Download and store the DB backp locally 2. Delete all entries from table ps_admin_filter Link to comment Share on other sites More sharing options...
Antakarana Posted April 10, 2020 Share Posted April 10, 2020 En 24/12/2019 a las 9:03 AM, selectshop.at dijo: 2) If this does not solve the problem, then access database via phpmyadmin and execute the following query: ALTER TABLE `ps_admin_filter` ADD `filter_id` INT NOT NULL ; Hi! I have the same issue after update to PS 1.7.6.4 In my case, deleting cache folder didn't fix it... however after doing that SQL query, the issue was solved. THANK YOU! (Notice that "ps_admin_filter" must be replaced by the one on your SQL database) EDIT I still have problems with that so I also tried to run the 3º query: ALTER TABLE `MYPREFIX_admin_filter` ADD `filter_id` VARCHAR (255) DEFAULT '' NOT NULL AFTER `shop`, DROP INDEX IF EXISTS `admin_filter_search_idx`, DROP INDEX IF EXISTS `search_idx`, ADD UNIQUE INDEX `admin_filter_search_id_idx` (`employee`, `shop`, `controller`, `action`, `filter_id`) ;``` However it shows an error: MySQL said: #1060 - duplicated column name 'filter_id' 🤔 EDIT 2 (SOLVED) As I mentioned before, In my case I experienced this issue after updating from 1.7.5.2 to 1.7.6.4, at the end of the process there were some updating errors. So I performed a rollback to the previous version 1.7.5.2 and then I perform a new update to 1.7.6.4, however this time i did not activate the backup for "database" and neither "images" on the 1-click process... As a result the update was perfect and the issue was fixed! Link to comment Share on other sites More sharing options...
Shabazz Posted June 15, 2020 Share Posted June 15, 2020 On 12/23/2019 at 10:20 AM, Rahulprbh said: In my back end when i press products,category tab i'm getting the below error Oops! An Error Occurred The server returned a "500 Internal Server Error". Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused. I don't Know what to do please help me out. I'm using prestashop 1.7.6.2 php version 7.3.6 I had the same issue, and I just cleared cache and everything worked normally. Link to comment Share on other sites More sharing options...
apenimon Posted March 25, 2021 Share Posted March 25, 2021 Hi, I'm not sure what causing this error but I'm also getting the same when I click categories and some other tabs from the admin back panel. It started after installing a new module. I have the module uninstalled but the problem still persist. I have got the same issue previously when I updated the Prestashop. Despite looking everywhere for a proper solution I couldn't find one unfortunately. The only easiest way to fix this a restoration from back up, but this comes with a nasty price of loss data. I am not sure what has been really causing this issue. I wonder it is to do with the paid theme/template that I have been using on the site? My hosting advised to contact the script vendor for this error. This is the error log: PHP Fatal error: Interface 'PrestaShop\PrestaShop\Core\Session\SessionInterface' not found in /home1/xxxx/mysite.com/classes/CustomerSession.php on line 29 This is really frustrating issue and it really effect us badly. I would appreciate it if someone can please help. Many thanks, Nico Link to comment Share on other sites More sharing options...
dev_darshan Posted May 16, 2021 Share Posted May 16, 2021 Oops! An Error Occurred The server returned a "500 Internal Server Error". Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused. I don't Know what to do please help me out. i have above error in ADVANCED->API->EDIT API in admin panel i am using debug mode than showing below error. how to resolve this issue. Link to comment Share on other sites More sharing options...
JBW Posted May 17, 2021 Share Posted May 17, 2021 On 5/16/2021 at 4:32 PM, dev_darshan said: how to resolve this issue There seems to be a module "Custom Popup" causing the error. You can deactivate it and contact the developer to fix it. As it is only a notice it should also disappear as soon you deactivate debug mode. But I guess in the admin panel you will see a different error!? 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