## m# Main code test
# on front endFront-End:
* use `Search Box` from Sidebar to search for `Home` keyword
* confirm, from `Search Box` placed in sidebar,that relevant results appear and contain only `Home` category
# in IDE:
make * open `/themes/advanced/platform/elements/content_boxes/search by keyword 'Home'_results.elm.tpl` template for editing
# confirm, that relevant results appears displaying `Ho* rename `list_name` parameter in the `c_ListCategories` tag to `name` category onlyand save changes
# make change in the `/themes/advanced/platform/elements/content_boxes/search_results.elm.tpl` - rename `list_name` parameter in the `c_ListCategories` tag to `name`on Front-End
# make refresh on * reload Search Results page with search resultsin Web Browser
# * confirm that search results are not relevant to `Home` keyword, (e.g. contains many categories, not only `Home` category)
# Visits code test
## visits cNOTE: Debug mode testmust be enabled.
# ensure debug mode is enabledin Admin Console
* go to {nav User Management > Users} section
* create new user
* go to {nav E-commerce > Affiliates}
* create new affiliate using e-mail used during user creation above
* approve affiliate record using `Approve` button on toolbar
* go to {nav User Management > Users}, select previously created user in the grid
* press `Login As` button in toolbar
* confirm that Front-End was opened in new window/tab
# go to {nav User Management > Users}, create some user# on Front-End (that was opened in new window/tab)
# go to {nav E-commerce > Afiliates}, create new affiliate with same user, entered in `Username` field* click on `Affiliate` link in the `My Account` sidebar section
# go to {nav User Management > Users}, select same user in the grid and press `Login As` button in toolbar* confirm that `Affiliate Program` page is opened
# confirm that front-end page is opened * click on `Affiliate Statistics` link in the main page part
# click on * confirm that `Affiliate` link in the `My Account` sidebar section Statistics` page is opened
# confirm that `Affiliate Program` page is opened * click on `Details` link in the `Total Visitors` row
# click on `Affiliate * confirm that `Visitor Statistics` link in the main page partpage is opened, and no sql error happened
# confirm that `Affiliate Statistics` page is opened# in IDE:
# click on `Details` link in the `Total Visitors` row * open `/themes/advanced/in-commerce/my_account/affiliate/affiliate_statistics_visits_list.tpl` template for editing
# confirm that `Visitor Statistics` page is opened, and no sql error happened* rename `list_name` parameter in the `visits_PrintList` tag to `name` and save changes
# make change in the `/themes/advanced/in-commerce/my_account/affiliate/affiliate_statistics_visits_list.tpl` - rename `list_name` parameter in the `visits_PrintList` tag to `name`on Front-End (that was opened in new window/tab)
# make refresh on * reload `Visitor Statistics` pagee in Web Browser
# confirm that sql error `Unknown column 'au.PortalUserId' in 'where clause'` happened * confirm that noticed about undefined `OrderTotalAmount_SUM` and `OrderAffiliateCommission_SUM` indexes will appear in Debugger