I'm pretty sure I inserted the snippets in correctly. When I ran the import, I got the same error I've seen a few times already which is telling me the keys didn't disable correctly.
Error
SQL query:
--
-- Dumping data for table tbxn_product_comment_criterion
INSERT INTO tbxn_product_comment_criterion (id_product_comment_criterion, id_product_comment_criterion_type, active) VALUES
(1, 1, 1);
MySQL said: Documentation
1062 - Duplicate entry '1' for key 'PRIMARY'
Here is the beginning of the dump file:
-- phpMyAdmin SQL Dump
-- version 4.3.8
-- http://www.phpmyadmin.net
-- Host: localhost
-- Generation Time: Oct 09, 2017 at 04:01 PM
-- Server version: 5.5.51-38.2
-- PHP Version: 5.6.30
SET SQLMODE = "NOAUTOVALUEONZERO";
SET timezone = "+00:00";
/!40000 ALTER TABLE tbxn_product_comment DISABLE KEYS */;
/!40000 ALTER TABLE tbxnproductcommentcriterion DISABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentcriterioncategory DISABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentcriterionlang DISABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentcriterionproduct DISABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentgrade DISABLE KEYS /;
/!40000 ALTER TABLE tbxnproductcommentreport DISABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentusefulness DISABLE KEYS /;
/!40101 SET @OLDCHARACTERSETCLIENT=@@CHARACTERSETCLIENT */;
/*!40101 SET @OLDCHARACTERSETRESULTS=@@CHARACTERSETRESULTS /;
/!40101 SET @OLDCOLLATIONCONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
And here is the end of the dump file:
-- AUTO_INCREMENT for table tbxn_product_comment_criterion
ALTER TABLE tbxn_product_comment_criterion
MODIFY id_product_comment_criterion int(10) unsigned NOT NULL AUTOINCREMENT,AUTOINCREMENT=2;
/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/!40101 SET CHARACTERSETRESULTS=@OLDCHARACTERSETRESULTS */;
/*!40101 SET COLLATIONCONNECTION=@OLDCOLLATIONCONNECTION /;
/!40000 ALTER TABLE tbxnproductcomment ENABLE KEYS /;
/!40000 ALTER TABLE tbxnproductcommentcriterion ENABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentcriterioncategory ENABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentcriterionlang ENABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentcriterionproduct ENABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentgrade ENABLE KEYS /;
/!40000 ALTER TABLE tbxnproductcommentreport ENABLE KEYS */;
/*!40000 ALTER TABLE tbxnproductcommentusefulness ENABLE KEYS */;