Author Topic: Cannot show menu element link that links to category layout.  (Read 3549 times)

welrachid

  • Jr. Member
  • **
  • Posts: 265
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Cannot show menu element link that links to category layout.
« on: September 03, 2016, 08:38:15 am »
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

Best regards,
Wel

welrachid

  • Jr. Member
  • **
  • Posts: 265
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Re: Cannot show menu element link that links to category layout.
« Reply #1 on: September 10, 2016, 17:10:44 pm »
Either nobody has same problem or im on my own?
I guess next step is looking into core files then..
Best regards,
Wel

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10688
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: Cannot show menu element link that links to category layout.
« Reply #2 on: September 10, 2016, 19:04:30 pm »
Quote
Unknown column 'searchable' in 'where clause'

you need to post the query as well
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

welrachid

  • Jr. Member
  • **
  • Posts: 265
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Re: Cannot show menu element link that links to category layout.
« Reply #3 on: September 11, 2016, 14:29:07 pm »
The Query?

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

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10688
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: Cannot show menu element link that links to category layout.
« Reply #4 on: September 11, 2016, 16:10:06 pm »
no -- the sql query

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

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

welrachid

  • Jr. Member
  • **
  • Posts: 265
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Re: Cannot show menu element link that links to category layout.
« Reply #5 on: September 11, 2016, 18:49:43 pm »
The error page doesnt give me anything On the actual SQL. Ill try see if i can do some debugging and find the sql
Best regards,
Wel

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10688
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: Cannot show menu element link that links to category layout.
« Reply #6 on: September 11, 2016, 19:20:47 pm »
I don't find the word 'searchable' in the whole VM install... must be 3rd party?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10530
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Cannot show menu element link that links to category layout.
« Reply #7 on: September 12, 2016, 15:23:07 pm »
Searcheable is introduced in vm3.0.17.6. I think he just needs to execute the table updater again.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10688
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: Cannot show menu element link that links to category layout.
« Reply #8 on: September 12, 2016, 16:10:38 pm »
AH!
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

welrachid

  • Jr. Member
  • **
  • Posts: 265
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Re: Cannot show menu element link that links to category layout.
« Reply #9 on: September 13, 2016, 15:09:40 pm »
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?
Best regards,
Wel

welrachid

  • Jr. Member
  • **
  • Posts: 265
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Re: Cannot show menu element link that links to category layout.
« Reply #10 on: September 13, 2016, 15:28:55 pm »
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.
Best regards,
Wel

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10530
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Cannot show menu element link that links to category layout.
« Reply #11 on: September 24, 2016, 14:57:20 pm »
Exactly this will be solved, when VM goes WP.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/