Error on product save after edit

Hello

I have the SEO Pack pro and UKSB Merchant feed extensions.. My website was running fine with just with UKSB and after i installed SEO Pack pro, i get the following error on product edit>save

Fatal error: Uncaught Exception: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=79') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_uksb_google_merchant_products pg ON (pg.product_id = p.product_id) WHERE p.product_id = '79' AND pd.language_id = '1' in /home/xxx/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/xxx/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT DISTINCT...', Array) #1 /home/xxx/public_html/system/storage/modification/admin/model/catalog/product.php(998): DB->query('SELECT DISTINCT...') #2 /home/xxx/public_html/system/storage/modification/system/engine/loader.php(189): ModelCatalogProduct->getProduct('79') #3 /home/xxx/public_html/system/engine/proxy.php(25): Loader->{closure}(Array, Array) #4 /home/xxx/public_html/system/storage/modification/admin/controller/catalog/product.php(1091): in /home/xxx/public_html/system/library/db/mysqli.php on line 40

What could be the issue?

Typical error for most SEO packs, which add multilingual keywords (SEO URLs) feature. In short, in your oc_url_alias table there's a language_id field, which is most likely equals 1 for all entries, thus resulting in multiple results returned. Contact extension developer on the matter.

I contacted developers of both extensions and they don't seem to have solution.
What can i do next?

hamidg84 wrote: ↑

Tue Jul 17, 2018 5:39 pm

I contacted developers of both extensions and they don't seem to have solution.
What can i do next?

Ask any developer, including me, for commercial support, if you can't fix it yourself.

I contacted you about 3 months ago but you just disabled the extension.

hamidg84 wrote: ↑

Tue Jul 17, 2018 6:03 pm

I contacted you about 3 months ago but you just disabled the extension.

Huh? What? I'm not UKSB and I'm not a developer of SEO Pack Pro.