How to set IGNORE TABLE and change ID in MySQL?

Question

After installing the plugin, the following error message appeared on my website. I wonder what query to execute to solve this problem using MYSQL / PhpMyadmin?

Zend_Db_Statement_Mysqli_Exception: Mysqli preparation error: you have an error in the SQL syntax; check the manual corresponding to the MySQL server version for the correct syntax to use next to 'IGNORE TABLE `xf_trophy_category` DROP PRIMARY KEY , CHANGE `trophy_category_id`'in line 1 - library /Zend/Db/Statement/Mysqli.php: 77

UPDATE

This is a stack trace. I asked the plugin developer, but they do not work on it.

0 / home / admin / web / .com / public_html / library / Zend / Db / Statement.php (115):

Zend_Db_Statement_Mysqli → _ prepare ('ALTER IGNORE TA ...')

1 / home / admin / web / .com / public_html / library / Zend / Db / Adapter / Mysqli.php (381):

Zend_Db_Statement → __ construct (Object (Zend_Db_Adapter_Mysqli), 'ALTER IGNORE TA... ')

2/home/admin/web/.com/public_html/library/Zend/Db/Adapter/Abstract.php(478):

Zend_Db_Adapter_Mysqli- > ('ALTER IGNORE TA...')

3/home/admin/web/.com/public_html/library/Waindigo/Install/20150313.php(758):

Zend_Db_Adapter_Abstract- > query ('ALTER IGNORE TA...')

4/home/admin/web/.com/public_html/library/Waindigo/Install/20150313.php(216):

Waindigo_Install → _ makeTableChanges (Array)

5/home/admin/web/.com/public_html/library/Waindigo/Install/20150313.php(88):

Waindigo_Install → _ install (, (SimpleXMLElement))

6/home/admin/web/.com/public_html/library/XenForo/Model/AddOn.php(214):

Waindigo_Install:: install (false, Array, Object (SimpleXMLElement))

7/home/admin/web/.com/public_html/library/XenForo/Model/AddOn.php(169):

XenForo_Model_AddOn- > installAddOnXml (Object (SimpleXMLElement), false)

8/home/admin/web/.com/public_html/library/XenForo/ControllerAdmin/AddOn.php(188):

XenForo_Model_AddOn- > installAddOnXmlFromFile ( '///TMP...')

9/home/admin/web/.com/public_html/library/XenForo/FrontController.php(351):

XenForo_ControllerAdmin_AddOn- > actionInstall()

10/home/admin/web/.com/public_html/library/XenForo/FrontController.php(134):

XenForo_FrontController- > ( (XenForo_RouteMatch))

11/home/admin/web/.com/public_html/admin.php(13): XenForo_FrontController- > run()

12 {main}

Answer 1

MySQL 5.7, , , -, , ALTER IGNORE MySQL Server 5.6 MySQL Server 5.7. , .

IGNORE - MySQL SQL. , ALTER TABLE , , . IGNORE , , . IGNORE, . . .

MySQL 5.6.17, IGNORE . IGNORE MySQL 5.7.

https://dev.mysql.com/doc/refman/5.6/en/alter-table.html

the correct syntax to use near 'IGNORE ...', , IGNORE , . , , , .

, :

3 
/home/admin/web/.com/public_html/library/Waindigo/Install/20150313.php(758):
Zend_Db_Adapter_Abstract->query('ALTER IGNORE TA...')

IGNORE Waindigo/Install/20150313.php 758, ALTER TABLE ....

Answer 2

, , . , . , : .

OP , PHPMyAdmin MySQL. PHP MySQL passe, MySQLi. Zend (, ZendFramework?) , MySQLi, -, :

Zend_Db_Statement_Mysqli_Exception: Mysqli:

PHP , mysqli:

$cfg ['Servers'] [$ i] ['extension'] = 'mysqli';

, , MySQLi, .

xerforo:

XenForo PHP: 5.2.11+ MySQL: 5.0+ PHP: MySQLi, GD ( JPEG), PCRE, SPL, SimpleXML, DOM, JSON, iconv, ctype PHP safe_mode off

, community.