Error 1146 in Search

Joomla webshop template with CSS3-based animations, VirtueMart support and one-page checkout.
GK User
Mon Mar 16, 2015 11:44 pm
Greetings,

We have a strange error. We 're trying to implement some search module or component but don't works. Since Search Joomla Component until some Search Components

You can see them here:

http://almacenelarquitectos.ipage.com/multilock2

For example, try to use the first Search Component and the page show us: 1146 Error.

We have a Template Storefront that I installed around 2 months ago using "gk_storefront_quickstart_J!3.zip". But we disable the search top because in our design we need the search module in bottom or sidebar position. But when we try to use it, doesn't work.

Like don't work we install other search component but dont find anything or show us errors.

Thanks for your help.
User avatar
Expert Boarder

GK User
Tue Mar 17, 2015 5:09 pm
I installed a clean template + joomla for investigate the search or try to indentify was wrong with our joomla here:

http://almacenelarquitectos.ipage.com/multilock2/

And the search module doesn't work. Like you can see the field for search is some hidden in top and we try to search some word but doesnt work. I press "Enter" or click in the bottom search but don't work.

Thanks for your help
User avatar
Expert Boarder

teitbite
Wed Mar 18, 2015 12:12 pm
Hi

Error 1146 is showing when there are lack of tables in database and than joomla needs to be updated and database repair/update option should be used.

If You think the problem is coming from template than disable overrides by deleting folders: com_finder, com_search, mod_search so a default joomla files will be used.

If You have implemented Your own code, than it may have a wrong table name in queries.
User avatar
Moderator

GK User
Wed Apr 01, 2015 10:02 pm
I have the same problem, I have this message:

'H0125U0027_DB_CHI.CHI_VIRTUEMART_CATEGORIES_EN_GB' DOESN'T EXIST SQL=SELECT DISTINCT C.VIRTUEMART_CATEGORY_ID AS CID FROM CHI_VIRTUEMART_PRODUCT_CATEGORIES AS CX LEFT JOIN CHI_VIRTUEMART_CATEGORIES_EN_GB AS C ON CX.VIRTUEMART_CATEGORY_ID = C.VIRTUEMART_CATEGORY_ID LEFT JOIN CHI_VIRTUEMART_PRODUCTS_EN_GB AS CONTENT ON CX.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN CHI_VIRTUEMART_CATEGORIES AS CAT ON C.VIRTUEMART_CATEGORY_ID = CAT.VIRTUEMART_CATEGORY_ID WHERE ( C.VIRTUEMART_CATEGORY_ID = 9 OR C.VIRTUEMART_CATEGORY_ID = 14 OR C.VIRTUEMART_CATEGORY_ID = 12 )
User avatar
Fresh Boarder

teitbite
Fri Apr 03, 2015 1:55 pm
Hi

For same problem please try use the same solution I proposed in my last post here :) Try also update joomla database in extensions panel.
User avatar
Moderator


cron