StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMagento - Error with store search, always returning no results.
primarykey
Id
14643801
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-01T10:04:16.810
FavoriteCount
0
LastActivityDate
2013-02-15T19:55:51.050
LastEditDate
LastEditorUserId
0
OwnerUserId
2032075
ParentId
0
PostTypeId
1
Score
0
ViewCount
328
LastEditorDisplayName
text
Body
<p>I have a template file and a very long day. Can anyone see what i am missing. The following is supposed to return search results however always returns with no products to display. I am using netbeans which seems to have an issue with the line getNoteMessages()): ?> saying that it was an accidental assignment of a variable but i'm sure the person who wrote it did it for a reason. Change it to a == doesn't seem to have any affect anyway. Thoughts? Tired... </p> <pre><code><div class="page-head"> <h3><?php echo ($this->getHeaderText() || $this->getHeaderText() === false) ? $this->getHeaderText() : $this->__("Search results for '%s'", $this->helper('catalogSearch')->getEscapedQueryText()) ?></h3> </div> <?php if($this->getResultCount()): ?> <?php echo $this->getMessagesBlock()->getGroupedHtml(); ?> <div class="page-head"> <?php if ($this->helper('rss/catalog')->getTagFeedUrl()): ?> <a href="<?php echo $this->helper('rss/catalog')->getTagFeedUrl() ?>" class="nobr link-feed"><?php echo $this->__('Subscribe to Feed') ?></a> <?php endif; ?> <h4><?php echo $this->__("Products"); ?></h4> </div> <?php if ($messages = $this->getNoteMessages()):?> <div class="note-msg"> <?php foreach ($messages as $message):?> <?php echo $message?><br /> <?php endforeach;?> </div> <?php endif; ?> <?php echo $this->getProductListHtml() ?> <?php else: ?> <div class="page-head"> <h4><?php echo $this->__("Products"); ?></h4> </div> <div class="note-msg"> <?php echo ($this->getNoResultText()) ? $this->getNoResultText() : $this->__('There are no results.') ?> <?php if ($messages = $this->getNoteMessages()):?> <?php foreach ($messages as $message):?> <br /><?php echo $message?> <?php endforeach;?> <?php endif; ?> </div> <?php endif; ?> <div class="clear"><p></p></div> <?php if (Mage::helper('searchautocomplete')->isSearchCms()): ?> <div class="page-head"> <h4><?php echo $this->__("CMS Pages"); ?></h4> </div> <?php if($this->getPageResultCount()): ?> <?php $pageCollection = $this->_getPageCollection(); ?> <ul> <?php foreach ($pageCollection as $page) : ?> <li><a href="<?php echo rtrim(Mage::getUrl($page->getIdentifier() == Mage::getStoreConfig('web/default/cms_home_page') ? '/' : $page->getIdentifier()),'/') ?>"><?php echo $page->getTitle(); ?></a><p><?php echo $this->_sanitizeContent($page); ?></p></li> <?php endforeach; ?> </ul> <?php else: ?> <div class="note-msg"> <?php echo $this->__('There are no results.') ?> </div> <?php endif; ?> <?php endif; ?> <?php if (Mage::helper('searchautocomplete')->isSearchBlog()): ?> <div class="page-head"> <h4><?php echo $this->__("Blog Posts"); ?></h4> </div> <?php $blogCollection = $this->_getBlogCollection(); ?> <?php if(count($blogCollection)): ?> <ul> <?php foreach ($blogCollection as $post) : ?> <li><a href="<?php echo rtrim(Mage::getUrl('blog/'.$post->getIdentifier()),'/') ?>"><?php echo $post->getTitle(); ?></a><p><?php echo $this->_sanitizeContent($post); ?></p></li> <?php endforeach; ?> </ul> <?php else: ?> <div class="note-msg"> <?php echo $this->__('There are no results.') ?> </div> <?php endif; ?> <?php endif; ?> <?php if (Mage::helper('searchautocomplete')->isSearchCmspro()): ?> <div class="page-head"> <h4><?php echo $this->__("News Pages"); ?></h4> </div> <?php $news = $this->_getNewsCollection(); ?> <?php if(count($news)): ?> <ul> <?php foreach ($news as $n) : ?> <?php $url = Mage::getModel('core/url_rewrite')->load($n->getUrlRewriteId());?> <li><a href="<?php echo Mage::getBaseUrl().$url->getRequestPath();?>"><?php echo $n->getTitle(); ?></a><p><?php echo $this->_sanitizeContent($n); ?></p></li> <?php endforeach; ?> </ul> <?php else: ?> <div class="note-msg"> <?php echo $this->__('There are no results.') ?> </div> <?php endif; ?> <?php endif; ?> </code></pre>
Tags
<magento><search>
Title
Magento - Error with store search, always returning no results.
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USFrank Clark
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.