Post by allgoo » Tue Feb 02, 2016 11:04 am

hello,

i have a problem in /system/storage/modification/catalog/controller/common/seo_url.php on line 53

Code: Select all

52:  $category_result = $this->db->query("SELECT * FROM " . DB_PREFIX . "category WHERE category_id = '" . $category_id . "'");
53:  $category_id = (int)$category_result->row['parent_id'];
54:  if ($category_id > 0 && !in_array($category_id, $found_path)) {

Outstanding Сasual Dating


New member

Posts

Joined
Sat Nov 07, 2015 12:49 am
Location - GB

Post by Randem » Tue Feb 02, 2016 3:16 pm

Hi allgoo,

Either there is no data returned from the query or the field 'parent_id' does not exist in the category table.
There should be a check to see if anything is returned from the query before attempting to operate on the resultset.

NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart


User avatar
Active Member

Posts

Joined
Sat Sep 27, 2014 9:17 am

Post by allgoo » Tue Feb 02, 2016 9:07 pm

Randem wrote:Hi allgoo,

Either there is no data returned from the query or the field 'parent_id' does not exist in the category table.
There should be a check to see if anything is returned from the query before attempting to operate on the resultset.
so basically you are saying that this error is caused because there is no parent category, wrong URL end ?

Outstanding Сasual Dating


New member

Posts

Joined
Sat Nov 07, 2015 12:49 am
Location - GB

Post by Randem » Wed Feb 03, 2016 3:39 am

No, I stated EXACTLY what it meant. There is no URL in the code you posted. ???

NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart


User avatar
Active Member

Posts

Joined
Sat Sep 27, 2014 9:17 am
Who is online

Users browsing this forum: No registered users and 50 guests