OpenCart Community

Hi.

I am getting the below error message on the product page (when editing a product)


https://www.penrithposters.co.uk/error.png (click the link to view the entire error message)

I have looked in the db to try and find the duplicate entry but I am unable to spot anything astray. Does anyone know where I should be looking for the duplicate?

Thanks
Chris

try checking your url_alias database table for duplicate entry.

This error message is not caused by a duplicated entry / value from the database but the way It was queried. As indicated from the picture, subquery error is returned.

I actually found a relative post on StackOverFlow which demonstrates the facts: http://stackoverflow.com/questions/2736 ... than-1-row

This query is definitely a bug located in admin/model/catalog/category.php file.

From the error in the screenshot, it means that in the url_alias table, there is 2 similar entry. Since it is mentioned that it is on the category page, this means that there is 2 entry with the same value in the 'query' column. (e.g. there's 2 of 'category_id=X' in the url_alias table.

Hope this enlightens everyone and others that reads this in the future.

Since two different results might be possible, in this case, I created a free contribution to see if these errors would still persist after providing results to merchants: http://www.opencart.com/index.php?route ... n_id=26654