Cannot show menu element link that links to category layout.

[welrachid]

Hi everyone. Im getting an error when trying to visit a certain category layout page. This is also a menuitem, so not sure how to check why this error happens.
Can someone please explain how to get around it or at least how i can figure out WHY it happens. It says something about searchable column... not sure what that is, and why this particular category layout does not have it when all the others have it
Fejl: 42S22
Grunden til at du ikke kan besøge denne side kan være en af følgende:

et udløbet bogmærke/favorit
en søgemaskine der har en forældet udgave af dette websted
en fejlindtastet adresse
du har ingen adgang til denne side
Den efterspurgte ressource blev ikke fundet
Desværre er der opstået en fejl under udførslen af din efterspørgsel!
Prøv venligst en af følgende sider:

Hjemmeside
Søg på dette websted
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'searchable' in 'where clause'

Hvis problemerne fortsætter, kontakt venligst systemadministratoren for dette websted, og rapporter fejlen(e) nedenfor:

Call stack
#   Function   Location
1   JApplicationCms->execute()   PUBLIC_HTML_DIRECTORY/htdocs/index.php:49
2   JApplicationSite->doExecute()   PUBLIC_HTML_DIRECTORY/htdocs/libraries/cms/application/cms.php:257
3   JApplicationSite->dispatch()   PUBLIC_HTML_DIRECTORY/htdocs/libraries/cms/application/site.php:230
4   JComponentHelper::renderComponent()   PUBLIC_HTML_DIRECTORY/htdocs/libraries/cms/application/site.php:191
5   JComponentHelper::executeComponent()   PUBLIC_HTML_DIRECTORY/htdocs/libraries/cms/component/helper.php:380
6   require_once()   PUBLIC_HTML_DIRECTORY/htdocs/libraries/cms/component/helper.php:405
7   JControllerLegacy->execute()   PUBLIC_HTML_DIRECTORY/htdocs/components/com_virtuemart/virtuemart.php:125
8   VirtueMartControllerCategory->display()   PUBLIC_HTML_DIRECTORY/htdocs/libraries/legacy/controller/legacy.php:702
9   VirtuemartViewCategory->display()   PUBLIC_HTML_DIRECTORY/htdocs/components/com_virtuemart/controllers/category.php:54
10   VirtuemartViewCategory->getSearchCustom()   PUBLIC_HTML_DIRECTORY/htdocs/components/com_virtuemart/views/category/view.html.php:124
11   JDatabaseDriver->loadObjectList()   PUBLIC_HTML_DIRECTORY/htdocs/components/com_virtuemart/views/category/view.html.php:433
12   JDatabaseDriverPdo->execute()   PUBLIC_HTML_DIRECTORY/htdocs/libraries/joomla/database/driver.php:1689
13   PDOStatement->execute()   PUBLIC_HTML_DIRECTORY/htdocs/libraries/joomla/database/driver/pdo.php:426


Thanks
Wel Rachid

EDIT:
i forgot the most important part: VERSIONS!
Joomla 3.6.2
VirtueMart 3.0.17.6

[welrachid]

Either nobody has same problem or im on my own?
I guess next step is looking into core files then..

[GJC Web Design]

Unknown column 'searchable' in 'where clause'

you need to post the query as well

[welrachid]

The Query?

Like this: /index.php/varme-drikke
??
or what exactly are we looking for?

[GJC Web Design]

no -- the sql query

other wise do we know what table it expects a Unknown column 'searchable'

[welrachid]

The error page doesnt give me anything On the actual SQL. Ill try see if i can do some debugging and find the sql

[GJC Web Design]

I don't find the word 'searchable' in the whole VM install... must be 3rd party?

[Milbo]

Searcheable is introduced in vm3.0.17.6. I think he just needs to execute the table updater again.

[GJC Web Design]

AH!

[welrachid]

Ok Thanks.
i've tried to install the version you sent me trough skype, but unfortunately its not installing.

If you like i can send you login details to the website?

[welrachid]

Problem solved.
Was related to the PDO driver running on the site and VM not supporting it.
Next time i'll do include the joomla db driver in the debugging info.

I do however not understand why VM cannot get the DB details from joomla config file, and use that to make its own mysqli link, IF for some case the rest of the system is using PDO.


Appreciate your help, both of you.
Thanks max for the skype talk.

[Milbo]

Exactly this will be solved, when VM goes WP.