Continued errors from upgrade to 3.0.3.9 from 3.0.3.8

JaxMusic wrote: ↑

Fri May 10, 2024 6:14 am

version: 3.0.3.9
php: 8.1
Extension installed - Google Shopping, Google Analytics

Good afternoon. I continue to find more errors after upgrading to 3.0.3.9. The current problem is with the Google Shopping extension. Starting about 1pm today, I started getting an error in the feed CRON job - 2024-05-09 17:02:12 - The datafeed file has become too large!

I went to extension in the admin system and attempt to enter the extension and get this:

Warning: mysqli::query(): (23000/1062): Duplicate entry '8710-0' for key 'product_id_store_id' in /home/jaxmusic/public_html/system/library/db/mysqli.php on line 25

While I understand in a general sense what the error is, I do not really have enough knowledge to properly diagnose it. There is only 1 product in OC with a product id of 8710. The only table that has duplicate entries for product id 8710 is the ocnh_googleshopping_product table, but this is allowed for that table (there are others with duplicates and rows have different product_advertise_google_id values) and this is not a key for that table.

Thanks in advance for any insights.

JNeuhoff wrote: ↑

Fri May 10, 2024 5:14 pm

Is there any reason why you won't ask the extension author to fix this? Unless you got multiple store_ids, the product_id_store_id should be unique for a given product_id.

JaxMusic wrote: ↑

Sat May 11, 2024 3:41 am

More errors in admin.

Unknown: Return type of Twig\Node\Node::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/jaxmusic/ocartdata/storage/vendor/twig/twig/src/Node/Node.php on line 161Unknown: Return type of Twig\Node\Node::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/jaxmusic/ocartdata/storage/vendor/twig/twig/src/Node/Node.php on line 166

This is annoying as hell. It was supposed to be a minor upgrade.