Database error messages in Admin

Quote

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
chrisio
Newbie
Posts
10
Joined
Sat Dec 31, 2011 8:28 pm
Top

Re: Database error messages in Admin

Quote

Post by MarketInSG » Sat May 07, 2016 8:38 am

try checking your url_alias database table for duplicate entry.

User avatar
MarketInSG
Guru Member
Posts
6443
Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore
Top

Re: Database error messages in Admin

Quote

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.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22525
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top

Re: Database error messages in Admin

Quote

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
MarketInSG
Guru Member
Posts
6443
Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore
Top

Re: Database error messages in Admin

Quote

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

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22525
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 39 guests