500 (Internal Server Error) _submit @ validation.min.js:6 (anonymous) @ jquery-ui-1.9.2.min.js:26

[Ashish_k_php]

When we product import and click on Check Data button at that time found error on browser console like 

500 (Internal Server Error) _submit @ validation.min.js:6 (anonymous) @ jquery-ui-1.9.2.min.js:26 

Please share if you have any ideas.

Thank you.

[Bhanu Periwal]

Hi @Ashish_k_php 

Please run below command in magento 2 root directory
Static content deploy

php bin/magento cache:clean
php bin/magento cache:flush
php bin/magento setup:upgrade
rm -rf pub/static/frontend/* pub/static/adminhtml/* var/cache/ var/generation/ var/page_cache/ var/view_preprocessed/ var/composer_home generated/
php -dmemory_limit=6G bin/magento setup:static-content:deploy -f
chmod -Rf 777 pub/ var/
php bin/magento cache:clean

Apply permission

find . -type f -exec chmod 644 {} \;
find . -type d -exec chmod 755 {} \;
find ./var -type d -exec chmod 777 {} \;
find ./pub/media -type d -exec chmod 777 {} \;
find ./pub/static -type d -exec chmod 777 {} \;
chmod 777 ./app/etc
chmod 644 ./app/etc/*.xml

It may help you to resolve issue.

Problem Solved ? Click on Accept as Solution!

[Ashish_k_php]

Hi @Bhanu Periwal ,

Thank you for replay.

When we run the upgrade command on terminal then display error like:

Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=core_config_data WHERE `Non_unique` = 1' at line 1, query was: SHOW INDEXES FROM =core_config_data WHERE `Non_unique` =1

Please let us know if you have any other ideas and solutions.

[Bhanu Periwal]

Hi @Ashish_k_php 

It looks like there is some issue with your custom module.

Search below keyword in your custom module

Non_unique

There are not any column exist (non_unique) in core_config_data table in Magento. Correct the query in your module. 

I hope it will help you!

Problem Solved? Click on 'Kudos' & Accept as Solution!

[Ashish_k_php]

Hi, @Bhanu Periwal 

We apply for the command and file permission then after the same error displayed on the browser console. 

[Ashish_k_php]

Hello @Bhanu Periwal 

I fix this issue with the mention reference link.

https://github.com/magento/magento2/issues/3870#issuecomment-273287762

Thank you for your support.