Posted: 11/12/2004 3:02:11 AM
Hi all,
When a search is performed in the directory...... and it says found x categories and x amount of links..... If you click the links ie:found "5" links I get this error:
SELECT ga_Category.CategoryId,ga_Category.CachedNavbar,ga_Link.*, Relevance FROM ga_ses_AD1B6FDB4EFD_ga_Search INNER JOIN ga_Link ON (ga_ses_AD1B6FDB4EFD_ga_Search.ItemId=ga_Link.LinkId) INNER JOIN ga_CategoryItems ON (ga_CategoryItems.ItemResourceId=ga_Link.ResourceId) INNER JOIN ga_Category ON (ga_Category.CategoryId=ga_CategoryItems.CategoryId) INNER JOIN ga_PermCache ON (ga_CategoryItems.CategoryId=ga_PermCache.CategoryId) WHERE (((FIND_IN_SET(14,acl) OR ((NOT FIND_IN_SET(14,dacl)) AND acl='')) ) AND PermId=15 AND PrimaryCat=1 AND ga_Category.Status=1) AND (ItemType=4 AND ga_Link.Status=1) ORDER BY EdPick DESC,Relevance DESC , ga_Link.Priority DESC, ga_Link.Name asc, ga_Link.Description desc
Error: Table 'gamblingadvertiser_co_uk.ga_ses_AD1B6FDB4EFD_ga_Search' doesn't exist
SELECT ga_Category.CategoryId,ga_Category.CachedNavbar,ga_Link.*, Relevance FROM ga_ses_AD1B6FDB4EFD_ga_Search INNER JOIN ga_Link ON (ga_ses_AD1B6FDB4EFD_ga_Search.ItemId=ga_Link.LinkId) INNER JOIN ga_CategoryItems ON (ga_CategoryItems.ItemResourceId=ga_Link.ResourceId) INNER JOIN ga_Category ON (ga_Category.CategoryId=ga_CategoryItems.CategoryId) INNER JOIN ga_PermCache ON (ga_CategoryItems.CategoryId=ga_PermCache.CategoryId) WHERE (((FIND_IN_SET(14,acl) OR ((NOT FIND_IN_SET(14,dacl)) AND acl='')) ) AND PermId=15 AND PrimaryCat=1 AND ga_Category.Status=1) AND (ItemType=4 AND ga_Link.Status=1) ORDER BY EdPick DESC,Relevance DESC , ga_Link.Priority DESC, ga_Link.Name asc, ga_Link.Description desc
Error: Table 'gamblingadvertiser_co_uk.ga_ses_AD1B6FDB4EFD_ga_Search' doesn't exist
Just something to looks at
Cheers
Pete
