Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Rhys 11 posts 31 karma points
    May 22, 2013 @ 02:41
    Rhys
    0

    Problem with database.

    On our website we use a product search that lists a variety of stock we have for both selling and as a information source. Ive come across a problem with our search. In the past ive deleted items from our search that we dont sell, but we've changed our thinking and are now using the search as more of an information outlet.

    When i deleted the products i deleted the folder they were in, not the product itself( deleting the folder deleted the product as well). Now in our product search the deleted product is still in our list when searching, but with no link and no picture. When i deleted them i didnt unpublish the pages, thinking they would be deleted when the folder was deleted.

    Im still learning alot about this site but is there a way of deleting published items when the folder and product dont exist anymore? They are causing problems with customers saying they cant access these pages( which ive created new versions of these pages that were deleted).

    If i was to unpublish the search page would that refresh the current list, or would i need to unpublish each of the products first in order to refresh the product page?

    Any help would be greatly appreciated.

  • Tom Fulton 2030 posts 4998 karma points c-trib
    May 22, 2013 @ 04:49
    Tom Fulton
    0

    Hi,

    Do you know how you're doing the search - is it Examine based?  If so, I think there's a "bug" in older versions where deleting an item (ie moving to recycle bin) still leaves the node in the Examine index.  If you empty the recycle bin or delete the node from it, though, it should get removed.  Does that sound like your case?

    If so, this is what I've done as a workaround in the past.  Basically it hooks into the MoveToTrash event and manually removes that node from the index.  That may work for you if it's the same situation.

    Hope this helps,
    Tom 

  • Rhys 11 posts 31 karma points
    May 22, 2013 @ 05:20
    Rhys
    0

    When i deleted the files they never went into the rubbish bin. I deleted what was in the bin and theres been no change. Im still kinda new to this so my coding and such isnt the best and ive taken over this website from its previous editor who did most of the coding. I remember seeing an error 404 or something simular with these pages when you clicked on the links, but has since gone and now it refreshes the page.

  • Tom Fulton 2030 posts 4998 karma points c-trib
    May 22, 2013 @ 05:23
    Tom Fulton
    0

    What version of Umbraco?  You might try rebuilding the Examine index (I'm assuming your search uses Examine but you'll want to verify that first) by deleting it from /App_Data/TEMP/ExamineIndexes and restarting the site (touch web.config).  On startup it should rebuild the index from scratch based on the nodes in your Umbraco install, and if those deleted nodes aren't in your install, they shouldn't get added to the index :)  If that works, might be worth seeing if you can reproduce the issue so you can get to the bottom of the cause and maybe we can find a workaround.

  • Rhys 11 posts 31 karma points
    May 22, 2013 @ 06:29
    Rhys
    0

    Umbraco v 4.5.2. Im a little unsure about restarting the site as im not sure how it was set up and i may lose pages ive updated and created since taking over this position. 

    If i was to unpublish the folder which contained the all the products in, would that remove these links from the search?. I can send you a link to the database if that will help or the page source.

  • Tom Fulton 2030 posts 4998 karma points c-trib
    May 22, 2013 @ 06:31
    Tom Fulton
    0

    Understood.  You'll probably want to pull down a copy of the site/DB and test this out locally first.

    Yep - unpublishing should remove the pages from the index.

  • Rhys 11 posts 31 karma points
    May 22, 2013 @ 06:52
    Rhys
    0

    Thanks Tom, ill try unpublishing the main product folder, if that doesnt work ill have to look at the other options. Now for the stupid question, how do i create a copy of the site?

  • Tom Fulton 2030 posts 4998 karma points c-trib
    May 22, 2013 @ 07:03
    Tom Fulton
    0

    That's a bit more involved, but basically you'll just want to pull down all the files and a backup of the DB from the current site.  Then you can setup a new local IIS site to point to those files, restore the DB to an SQL Server, and adjust the connection string in the web.config.

  • Rhys 11 posts 31 karma points
    May 23, 2013 @ 03:19
    Rhys
    0

    No Luck with unpublishing the folder as the files still show up almost like there hidden. Is there any way of unpublishing pages that are hidden.

    I deleted the folder that these pages were in. These pages dont exist but whats left is the former link in the product search, only now since ive unpublished the search all these links are now bunched up so if i republish the rest of the products all of these will remain at the top of the search.

    As ive said before my coding and such is kinda basic and i just maintain the site and add new things to it so i have no idea where the certain files are kept for the product search.

    When i unpublished everything i noticed when i unpublished a folder and not the products in the folder that it left the link like my current problem, now ive got an extra link added, but now i atleast know what happened to cause it, just wondering about if theres a solution.

    Is there a way outside of umbraco that this can be fixed from, ie inspecting the page element shows each of the links, can i edit through that?

  • Rhys 11 posts 31 karma points
    May 27, 2013 @ 02:04
    Rhys
    0

    The link i mentioned above has been fixed. When i was unpublishing each product i would unpublish the product first then the folder, so i tried on one of the products when i unpublish the folder and not the product, when i checked live, my problem was there, however once i unpublished the product pages and restarted the search the product was link dissapeared. That was fixed.

    The products that im having problems with were not deleted, unpublished or lost, only the folder was deleted and unpublished, so these files are still on my site but i cant see them, so i cant get to them to unpublish and delete. Has anyone seen a simular problem? Is there a way to see a site map of each of the pages within?

    Edited.

    Okay ive used the search at the top and found all the pages for these links, however there all giving me the same "This document is published but is not visible because the parent 'Plant Name' is unpublished"

     Ive unpublished these pages yet the link remains and im not given an option to link up pages or move them. In the content section i still cant see the actual files. Ive tried to use the remove button under properties and no luck either.
    How do you remove this line from this text Grrr! 

  • Tom Fulton 2030 posts 4998 karma points c-trib
    May 28, 2013 @ 06:16
    Tom Fulton
    0

    Hi Rhys,

    Have you checked the recycle bin to see if the products are there?

  • Rhys 11 posts 31 karma points
    May 28, 2013 @ 07:35
    Rhys
    0

    The only recycle bin i have is located in my media section, other then that i havent seen another bin unless its in a hidden side pannel.

  • Tom Fulton 2030 posts 4998 karma points c-trib
    May 28, 2013 @ 16:22
    Tom Fulton
    0

    You should definitely have one in your Content section also, unless maybe your user account is set to a specific start node, in which case the recycle bin won't show.  You might be able to check this under Users and editing your user and looking for the "Start node in content" area.  If you don't have a start node set it might be a case of the recycle bin getting removed from the DB - what version of Umbraco are you on?

  • Rhys 11 posts 31 karma points
    May 29, 2013 @ 00:02
    Rhys
    0

    Ive checked the area you said and nothing was selected.

    Start Node in Content
    Home  Delete  Choose...
    Start Node in Media Library
    Media  Delete  Choose...
    -

    This is what im seeing in Umbraco v 4.5.2 in the user pannel. Im not sure if something is already selected but when i choose somewhere nothing is selected, even the media section isnt showing the recycle bin. The same thing is being shown in the content channel tab but with Search all children in the middle of the 2, unchecked.

  • Tom Fulton 2030 posts 4998 karma points c-trib
    May 29, 2013 @ 00:30
    Tom Fulton
    0

    Yeah, your user account has a Start Node set (Home), which is why you're not seeing the recycle bin.  Normally there's a "Delete" button next to "Choose", but since it's absent I'm assuming your user doesn't have the appropriate permissions.  If you login as the admin you should be able to reset that (and/or view the recycle bin).

    Without having enough info, I'm thinking that the pages are in the recycle bin and if you delete them from there, they should be removed from your search index.  As I mentioned earlier, there's a bug where moving to the recycle bin doesn't remove the page from the index -- deleting it from the recycle bin should, though.

  • Rhys 11 posts 31 karma points
    May 29, 2013 @ 01:56
    Rhys
    0

    There's a delete button next to both sets of start nodes in both areas, im pretty sure i have access, its just finding out why its not in there.

Please Sign in or register to post replies

Write your reply to:

Draft