Menu problems

Submitted by MikeyC on Sat, 2016-02-06 12:49 in Price Tapestry

Hi David,

I am having issues with the category hierarchy.
The 1st and 2nd level don't show up in the category path, and if i click on the 3rd level, it takes me back to the main category page.

I did encounter internal server errors, and even had the database crash which i had to setup all over again. This was due to PHP runtime in fcgid was set to 30 sec.
Importing is running smooth after resetting to 360 sec

underneath the error i get when running in Apache mode, i get the same error in fcgid mode.

Apache error log show:
PHP Notice: Undefined offset: 0 in /home/mydomain/public_html/includes/tapestry.php on line 432, referer: http://www.mydomain.nl/
PHP Notice: Undefined offset: 0 in /home/mydomain/public_html/includes/tapestry.php on line 434, referer: http://www.mydomain.nl/
PHP Notice: Undefined offset: 0 in /home/mydomain/public_html/includes/tapestry.php on line 440, referer: http://www.mydomain.nl/
PHP Notice: Undefined offset: 0 in /home/mydomain/public_html/includes/tapestry.php on line 440, referer: http://www.mydomain.nl/

Any clues ? I did import the data for category_hierarchy table from a text file after i did reinstalled the database, but everyting looks fine.

Mike

Hi Mike, It sounds like the

Submitted by support on Mon, 2016-02-08 09:56

Hi Mike,

It sounds like the hierarchy structure may not have restored properly, if possible please could you email me the .xml file created from the Backup process (/admin/ > Tools > Backup and Restore) with just the categories_hierarchy table selected, and also the text file from which you restored the table and I'll check that all out for you on my test server...

Cheers,
David.
--
PriceTapestry.com

Hi David, I am getting the

Submitted by babyuniverse on Wed, 2016-05-04 09:59

Hi David,

I am getting the same message, I haven't made any recent changes to the database.

[02-May-2016 09:08:45 UTC] PHP Notice: Undefined offset: 0 in /home/xxx/public_html/includes/tapestry.php on line 438
[02-May-2016 09:08:45 UTC] PHP Notice: Undefined offset: 0 in /home/xxx/public_html/includes/tapestry.php on line 440
[02-May-2016 09:08:45 UTC] PHP Notice: Undefined offset: 0 in /home/xxx/public_html/includes/tapestry.php on line 446

FYI - Code below for these lines

    $currentId = $rows[0]["id"];

    $currentNames[] = $rows[0]["name"];

    $currentPath = implode("/",$currentNames);

    if ($currentPath == $path) break;

    $nodeInfo["hierarchy"][] = array("id"=>$rows[0]["id"],"name"=>$rows[0]["name"],"path"=>$currentPath);

Thanks
Richard

Hello Richard, That does

Submitted by support on Wed, 2016-05-04 10:15

Hello Richard,

That does indicate that an element in the hierarchy has lost its parent reference, please could you modify includes/admin.php as follows - look for the following code at line 435:

database_querySelect($sql,$rows);

...and REPLACE with:

if (!database_querySelect($sql,$rows)) continue;

And let me know if all looks OK with that in place, and also if you wouldn't mind, if you could make a backup of just Category Hierarchy Mapping from /admin/ > Tools > Backup and Restore and email me the .xml file generated I'll be able to restore the hierarchy on my test server and see if I can spot the problem...

Thanks,
David.
--
PriceTapestry.com