FastSimpleImport cannot get autoincrement value of catalog_product_link

[Chimera16]

Hello everyone,

I have the latest fastsimpleimport extension and use the latest Magento1 Version (1.9.4.3).
I create a new installation of Magento to make sure the database isn't corrupted. After that I run an product import. I receive the error "Cannot get autoincrement value".

The issue appears in file "app\code\core\Mage\ImportExport\Model\Resource\Helper\Mysql4.php". To identify the problem I have printed the $entityStatus of the function getNextAutoincrement. This is what I received:
Array
(
[Name] => catalog_product_link
[Engine] => InnoDB
[Version] => 10
[Row_format] => Dynamic
[Rows] => 0
[Avg_row_length] => 0
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 65536
[Data_free] => 0
[Auto_increment] =>
[Create_time] => 2019-12-05 04:52:41
[Update_time] =>
[Check_time] =>
[Collation] => utf8_general_ci
[Checksum] =>
[Create_options] =>
[Comment] => Catalog Product To Product Linkage Table
)

To summarize my issue: I cannot import any product Data with FastSimpleImport, because the extension is unable to get the autoincrement value of my catalog_product_link table. I have checked the table inside MySQL, a autoincrement value is set. I have even created products with cross selling manually to get a new autoincrement value set to the table, but the problem remains...

Any help would appreciated, thanks in advance!

[Chimera16]

I was able to solve my issue. The reason for this issue is, that I'm using MySQL Server 8 while Magento1 does not official support it.

To get this extension to work with MySQL Server 8 you have to change 2 things:

1. On the MySQL server change the paramter "information_schema_stats_expiry" global to "0". I was unable to do this with the my.ini file or with commands. The solution was to set the parameter inside the MySQL Workbench.

2. Edit the FastSimpleImport file "app\code\core\Mage\ImportExport\Model\Resource\Helper\Mysql4.php". Look for the "getNextAutoincrement" function inside it, and change the content of it like this:

    public function getNextAutoincrement($tableName)
    {
    $resource = Mage::getSingleton('core/resource');
    $readConnection = $resource->getConnection('core_read');
    $writeConnection = $resource->getConnection('core_write');
   
    $query = "SELECT AUTO_INCREMENT FROM  INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = DATABASE() AND   TABLE_NAME   = '".$resource->getTableName($tableName)."';";
    $results = $readConnection->fetchAll($query);
   
    $entityStatus['Auto_increment']=$results[0]['AUTO_INCREMENT'];
   
    if (empty($entityStatus['Auto_increment'])) {
       $query = 'SELECT count(*) AS rowcount FROM ' . $resource->getTableName($tableName);
       $results = $readConnection->fetchAll($query);
       $rowcount=$results[0]['rowcount'];
       if ($rowcount == "0") {
          $entityStatus['Auto_increment']="1";
       } else {
          Mage::throwException(Mage::helper('importexport')->__('Cannot get autoincrement value'));
       }
    }
    return $entityStatus['Auto_increment'];
    }
   

After you have done these steps, FastSimpleImport should work with Magento1 and MySQL Server 8.