Post by chrisio » Fri May 06, 2016 9:57 pm

Hi.

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

Image
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

Newbie

Posts

Joined
Sat Dec 31, 2011 8:28 pm

User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by straightlight » Sun May 08, 2016 8:31 am

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.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by MarketInSG » Sun May 08, 2016 8:25 pm

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.


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by straightlight » Fri May 13, 2016 1:27 am

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

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 13 guests